Round 3 summary update

I wanted to check how my round 3 was going, so I put together a spreadsheet of the dates and running PnL. 

The key take out - sideways !!

Round 3 : Week 29 Day 5 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	843.99	9 131.19	-1.21	243.67
Brewin Dolphin Holdings	Long	303.86	336.25	5 707.96	15.27	152.26
Porvair	Long	310.78	341.50	3 701.22	25.55	98.83
Hikma Pharmaceuticals	Long	1 424.60	1 654.99	6 047.17	-2.13	161.71
Lookers	Long	129.32	148.00	5 416.64	1.36	144.46
Schroders	Long	2 690.70	2 578.00	-1 550.09	8.89	-41.90
Sports Direct	Long	797.80	866.17	3 212.86	1.76	85.68
Running profit / loss				23 006.18
Diff from prev day				1 544.80

Round 3 : Week 29 Day 4 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	845.50	9 243.30	-4.60	246.66
Brewin Dolphin Holdings	Long	303.86	331.96	4 951.86	57.52	132.09
Porvair	Long	310.78	335.25	2 948.11	69.13	78.72
Hikma Pharmaceuticals	Long	1 424.60	1 660.00	6 178.68	-0.42	165.22
Lookers	Long	129.32	147.75	5 344.14	-6.35	142.52
Schroders	Long	2 690.70	2 567.00	-1 701.34	-13.80	-45.99
Sports Direct	Long	797.80	864.99	3 157.40	7.18	84.20
Running profit / loss				21 461.38
Diff from prev day				2 184.30

Round 3 : Week 29 Day 3 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	851.50	9 688.80	0.00	258.55
Brewin Dolphin Holdings	Long	303.86	321.70	3 143.56	-11.42	83.85
Porvair	Long	310.78	325.25	1 743.12	-9.40	46.54
Hikma Pharmaceuticals	Long	1 424.60	1 661.00	6 204.93	8.24	165.93
Lookers	Long	129.32	149.00	5 706.63	1.29	152.19
Schroders	Long	2 690.70	2 582.00	-1 495.09	-31.43	-40.41
Sports Direct	Long	797.80	860.49	2 945.90	14.63	78.56
Running profit / loss				19 277.08
Diff from prev day				-22.62

Round 3 : Week 29 Day 2 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	851.50	9 688.80	5.24	258.55
Brewin Dolphin Holdings	Long	303.86	324.00	3 548.93	-6.67	94.67
Porvair	Long	310.78	326.75	1 923.87	30.70	51.37
Hikma Pharmaceuticals	Long	1 424.60	1 643.00	5 732.43	12.35	153.29
Consort Medical	Long	1 056.60	937.55	-3 724.95 (SOLD @ 950.94)	-13.49	-100.01
Lookers	Long	129.32	148.75	5 634.13	-1.27	150.26
Schroders	Long	2 690.70	2 608.00	-1 137.59	29.13	-30.75
Sports Direct	Long	797.80	852.49	2 569.91	36.05	68.54
Running profit / loss				19 299.71
Diff from prev day				1 943.97

Round 3 : Week 29 Day 1 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	851.50	9 206.18	-9.43	245.67
Brewin Dolphin Holdings	Long	303.86	324.00	3 802.72	-32.01	101.44
Porvair	Long	310.78	326.75	1 472.00	32.55	39.30
Hikma Pharmaceuticals	Long	1 424.60	1 643.00	5 102.44	-2.02	136.44
Consort Medical	Long	1 056.60	937.55	-3 282.22	-11.35	-88.12
Diploma	Long	761.40	710.00	-3 356.21 (SOLD @ 693.26)	-4 733.25	-89.50
Lookers	Long	129.32	148.75	5 706.63	11.31	152.19
Schroders	Long	2 690.70	2 608.00	-1 605.09	-89.09	-43.38
Sports Direct	Long	797.80	852.49	1 888.88	5.49	50.37
Running profit / loss				17 355.74
Diff from prev day				-6 192.04

Round 3 : Week 28 Day 5 Trade Log

I missed Thursday's close due to my spreadsheet crashing again, so this is Friday's trade log with the 'diff from prev day' being difference to Wednesday instead.

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	857.91	10 164.73	0.00	271.25
Brewin Dolphin Holdings	Long	303.86	335.60	5 593.40	0.00	149.20
Porvair	Long	310.78	320.00	1 110.50	0.00	29.65
Hikma Pharmaceuticals	Long	1 424.60	1 623.00	5 207.44	0.00	139.25
Consort Medical	Long	1 056.60	972.99	-2 947.70	0.00	-79.14
Diploma	Long	761.40	760.00	-69.44	0.00	-1.85
Lookers	Long	129.32	147.00	5 126.64	0.00	136.72
Schroders	Long	2 690.70	2 629.00	-848.85	0.00	-22.94
Sports Direct	Long	797.80	835.91	1 790.66	0.00	47.76
Running profit / loss				23 547.78
Diff from prev day				-3 858.84

Round 3 : Week 28 Day 3 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	865.50	10 728.28	32.57	286.29
Brewin Dolphin Holdings	Long	303.86	339.00	6 192.64	34.44	165.19
Porvair	Long	310.78	315.25	538.14	-10.96	14.37
Hikma Pharmaceuticals	Long	1 424.60	1 677.00	6 624.92	-0.39	177.16
Consort Medical	Long	1 056.60	1 000.00	-1 995.61	16.27	-53.58
Diploma	Long	761.40	739.50	-1 079.05	-92.03	-28.78
Lookers	Long	129.32	147.50	5 271.64	-2.10	140.59
Schroders	Long	2 690.70	2 692.00	17.39	103.10	0.47
Sports Direct	Long	797.80	855.00	2 687.87	11.03	71.68
Running profit / loss				27 406.61
Diff from prev day				4 731.52

Round 3 : Week 28 Day 2 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	830.00	8 092.44	1.40	215.95
Brewin Dolphin Holdings	Long	303.86	330.00	4 606.41	-4.04	122.88
NCC	Long	216.29	203.00	-1 220.14 (SOLD @ 209.25)	-1 640.58	-32.56
Porvair	Long	310.78	315.80	604.41	-8.23	16.14
Hikma Pharmaceuticals	Long	1 424.60	1 678.00	6 651.17	16.56	177.86
Consort Medical	Long	1 056.60	989.00	-2 383.36	-0.75	-63.99
Diploma	Long	761.40	750.00	-561.93	-234.60	-14.99
Lookers	Long	129.32	147.89	5 384.74	11.33	143.60
Schroders	Long	2 690.70	2 650.00	-560.10	55.59	-15.14
Sports Direct	Long	797.80	849.32	2 420.92	-15.13	64.56
Running profit / loss				22 675.09
Diff from prev day				-84.82

Round 3 : Week 28 Day 1 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	828.50	7 981.07	3.37	212.98
Brewin Dolphin Holdings	Long	303.86	331.10	4 800.29	30.72	128.05
NCC	Long	216.29	216.75	79.20	113.88	2.11
Porvair	Long	310.78	316.25	658.64	-31.38	17.59
Hikma Pharmaceuticals	Long	1 424.60	1 642.00	5 706.19	31.44	152.59
Consort Medical	Long	1 056.60	989.50	-2 365.73	17.77	-63.52
Diploma	Long	761.40	758.00	-167.94	-41.49	-4.48
Lookers	Long	129.32	146.00	4 836.65	-4.30	128.99
Schroders	Long	2 690.70	2 599.00	-1 261.34	14.05	-34.09
Sports Direct	Long	797.80	858.50	2 852.37	123.21	76.07
Running profit / loss				22 759.91
Diff from prev day				5 126.37

Round 3 : Week 27 Day 5 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	825.00	7 721.20	-9.56	206.04
Brewin Dolphin Holdings	Long	303.86	324.70	3 672.30	-12.22	97.96
NCC	Long	216.29	213.00	-570.48	-153.05	-15.22
Porvair	Long	310.78	318.75	959.88	-7.00	25.63
Hikma Pharmaceuticals	Long	1 424.60	1 590.00	4 341.20	24.93	116.09
Consort Medical	Long	1 056.60	975.00	-2 876.85	6.31	-77.24
Diploma	Long	761.40	759.00	-118.69	79.77	-3.17
Lookers	Long	129.32	146.75	5 054.14	13.92	134.79
Ricardo	Long	718.80	700.00	-809.74 (SOLD @ 703.24)	-316.56	-21.66
Schroders	Long	2 690.70	2 584.00	-1 467.59	-7.02	-39.67
Sports Direct	Long	797.80	825.00	1 277.89	-28.79	34.08
Running profit / loss				17 633.54
Diff from prev day				-2 696.01

Round 3 : Week 27 Day 4 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	835.99	8 537.19	0.00	227.82
Brewin Dolphin Holdings	Long	303.86	327.60	4 183.42	0.00	111.59
NCC	Long	216.29	222.50	1 075.38	0.00	28.70
Porvair	Long	310.78	319.35	1 032.18	0.00	27.56
Hikma Pharmaceuticals	Long	1 424.60	1 557.00	3 474.96	0.00	92.92
Consort Medical	Long	1 056.60	969.50	-3 070.72	0.00	-82.45
Diploma	Long	761.40	749.50	-586.56	0.00	-15.64
Lookers	Long	129.32	144.62	4 436.45	0.00	118.31
Ricardo	Long	718.80	726.00	373.91	0.00	10.00
Schroders	Long	2 690.70	2 591.00	-1 371.34	0.00	-37.07
Sports Direct	Long	797.80	835.99	1 794.42	0.00	47.86
Running profit / loss				20 329.56
Diff from prev day				-457.48

Round 3 : Week 27 Day 3 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	840.50	8 872.06	-16.43	236.75
Brewin Dolphin Holdings	Long	303.86	332.00	4 958.91	-5.06	132.28
NCC	Long	216.29	221.50	902.13	-63.98	24.07
Porvair	Long	310.78	315.30	544.16	1.12	14.53
Hikma Pharmaceuticals	Long	1 424.60	1 527.00	2 687.47	111.61	71.87
Consort Medical	Long	1 056.60	980.00	-2 700.60	-34.14	-72.51
Diploma	Long	761.40	759.00	-118.69	-177.99	-3.17
Lookers	Long	129.32	141.38	3 496.86	12.92	93.26
Ricardo	Long	718.80	737.00	945.90	-42.60	25.31
Schroders	Long	2 690.70	2 601.00	-1 233.84	0.00	-33.35
Sports Direct	Long	797.80	839.99	1 982.41	4.95	52.87
Running profit / loss				20 787.04
Diff from prev day				-6 989.14

Round 3 : Week 27 Day 2 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	864.00	10 616.91	-2.05	283.31
Brewin Dolphin Holdings	Long	303.86	333.50	5 223.28	-11.63	139.33
NCC	Long	216.29	230.75	2 504.67	-10.80	66.84
Porvair	Long	310.78	315.25	538.14	0.00	14.37
Hikma Pharmaceuticals	Long	1 424.60	1 473.00	1 269.99	29.43	33.96
Consort Medical	Long	1 056.60	999.50	-2 013.24	-22.53	-54.05
Diploma	Long	761.40	764.50	152.18	-49.26	4.06
Lookers	Long	129.32	140.00	3 096.67	69.27	82.58
Ricardo	Long	718.80	750.50	1 647.89	-12.43	44.09
Schroders	Long	2 690.70	2 601.00	-1 233.84	-109.98	-33.35
Sports Direct	Long	797.80	838.00	1 888.88	259.17	50.37
Xaar	Long	1 090.70	1 004.00	-3 634.38 (SOLD @ 984.60)	-43.95	-97.29
Running profit / loss				27 776.18
Diff from prev day				2 832.29

Round 3 : Week 27 Day 1 Trade Log

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	864.00	10 839.66	-1.34	289.26
Brewin Dolphin Holdings	Long	303.86	333.50	5 910.65	-27.47	157.67
NCC	Long	216.29	230.75	2 807.85	3.18	74.93
Porvair	Long	310.78	315.25	538.14	-18.30	14.37
Hikma Pharmaceuticals	Long	1 424.60	1 473.00	981.25	-21.10	26.24
Consort Medical	Long	1 056.60	999.50	-1 643.12	-17.67	-44.12
Diploma	Long	761.40	764.50	299.93	949.81	8.00
Lookers	Long	129.32	140.00	1 829.38	1.77	48.79
Ricardo	Long	718.80	750.50	1 881.89	-44.06	50.35
Schroders	Long	2 690.70	2 601.00	-587.60	-5 712.07	-15.88
Sports Direct	Long	797.80	838.00	525.90	-53.74	14.03
Xaar	Long	1 090.70	1 004.00	-2 524.68	-12.17	-67.58
Running profit / loss				24 943.89
Diff from prev day				-2 840.95

Round 3 : Week 26 Day 5 Trade Log

As explained, my Excel spreadsheet broke last week - I entered the closing prices manually but couldn't do all days from last week so here is Friday's trade log...

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	871.00	10 987.41	0.00	293.20
UK Mail	Long	632.64	650.00	2 729.46 (SOLD @ 664.95)	0.00	72.95
Brewin Dolphin Holdings	Long	303.86	347.80	8 148.99	0.00	217.37
NCC	Long	216.29	232.50	2 721.23	0.00	72.62
Porvair	Long	310.78	320.00	658.64	0.00	17.59
Hikma Pharmaceuticals	Long	1 424.60	1 471.85	1 243.74	0.00	33.26
Consort Medical	Long	1 056.60	1 010.00	-1 396.37	0.00	-37.49
Diploma	Long	761.40	773.00	28.57	0.00	0.76
Lookers	Long	129.32	136.00	1 797.49	0.00	47.94
Ricardo	Long	718.80	778.00	3 363.87	0.00	90.00
Schroders	Long	2 690.70	2 677.00	-10.11	0.00	-0.27
Sports Direct	Long	797.80	816.50	1 136.89	0.00	30.32
Xaar	Long	1 090.70	1 012.80	-2 250.68	0.00	-60.25
Running profit / loss				27 784.85
Diff from prev day				6 796.37

Lack of trade logs this week

Having some major issues with Excel again so apologies for the lack of trade logs for the last couple of days. I am going to manually input prices etc. either tonight/tomorrow/over the weekend so I can provide trade logs for this week.

The app I have been talking about (if you have missed it, I have had a mobile app that does all the things I do in Excel to track my bets developed by a mate of mine) is ready to be tested and I just need to free up some time to do so, we can release it to all of you (for free obviously!). 

I have been playing around with it a bit and it looks great and works beautifully.

I will keep you updated...

Round 3 : Week 26 Day 1 Trade Log

Down, down, down !

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	861.50	10 431.29	-8.77	278.36
UK Mail	Long	632.64	670.00	3 156.18	-34.87	84.35
Avon Rubber	Long	636.42	617.90	-1 510.16 (SOLD @ 618.45)	-203.26	-40.35
Brewin Dolphin Holdings	Long	303.86	340.20	6 404.14	-8.79	170.83
NCC	Long	216.29	216.75	79.20	-73.22	2.11
Porvair	Long	310.78	305.25	-666.85	-936.29	-17.81
Hikma Pharmaceuticals	Long	1 424.60	1 430.00	141.26	-42.64	3.78
Consort Medical	Long	1 056.60	1 016.00	-1 431.62	-52.60	-38.44
Diploma	Long	761.40	749.00	-611.18	-198.57	-16.30
Lookers	Long	129.32	128.00	-383.29	-217.19	-10.22
Record	Long	43.61	42.25	-1 170.08	-12.39	-31.21
Ricardo	Long	718.80	737.00	945.90	-33.10	25.31
Schroders	Long	2 690.70	2 589.00	-1 398.84	-556.93	-37.81
Sports Direct	Long	797.80	798.50	32.41	-92.06	0.86
Xaar	Long	1 090.70	1 048.88	-1 432.81	-112.20	-38.36
Running profit / loss				19 200.97
Diff from prev day				-10 668.18

Round 3 : Week 25 Day 5 Trade Log

Pretty good day all in all - up £7k!

Stock	Long/Short	Entry Price	Latest Price	Current profit/loss	% on prev day	% on total risk
St. James's Place	Long	721.00	875.00	11 433.65	17.19	305.11
UK Mail	Long	632.64	690.00	4 846.16	0.00	129.52
Avon Rubber	Long	636.42	630.50	-497.97	-192.27	-13.31
Brewin Dolphin Holdings	Long	303.86	343.70	7 021.01	25.52	187.28
NCC	Long	216.29	218.00	295.76	414.50	7.89
Porvair	Long	310.78	310.25	-64.35	31.89	-1.72
Hikma Pharmaceuticals	Long	1 424.60	1 434.00	246.26	293.95	6.59
Consort Medical	Long	1 056.60	1 030.00	-938.13	27.31	-25.19
Diploma	Long	761.40	774.00	620.05	172.31	16.54
Lookers	Long	129.32	128.91	-120.84	-29.53	-3.22
Record	Long	43.61	42.40	-1 041.08	0.00	-27.77
Ricardo	Long	718.80	746.00	1 413.89	82.17	37.83
Schroders	Long	2 690.70	2 713.00	306.14	225.54	8.27
Sports Direct	Long	797.80	806.50	408.40	201.51	10.89
Xaar	Long	1 090.70	1 071.00	-675.21	-6.71	-18.07
Running profit / loss				29 869.15
Diff from prev day				7 138.91