Monday 31 March 2014

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

Friday 28 March 2014

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

Thursday 27 March 2014

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

Wednesday 26 March 2014

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

Monday 24 March 2014

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

Thursday 20 March 2014

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

Wednesday 19 March 2014

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

Tuesday 18 March 2014

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

Monday 17 March 2014

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

Friday 14 March 2014

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

Thursday 13 March 2014

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

Wednesday 12 March 2014

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

Monday 10 March 2014

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

Thursday 6 March 2014

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...

Tuesday 4 March 2014

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

Saturday 1 March 2014

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