Excel Trading Analysis

Post Reply
blueport
Posts: 229
Joined: Mon May 18, 2009 7:35 am

Where do I find the version with the date option?

Cheers,
Simon
Lagos
Posts: 204
Joined: Fri Apr 17, 2009 1:04 pm

Hi Nigel

Having trouble getting this to work. I think I have done it as you say but when I connect it I get an error message Run-time error'1004' 'C:\Users\Dad\Desktop\BettingpandL.' could not be found.

I do have other markets on there like without fav and forecasts so that my be the problem.

dont know if you can help.
Thanks

Martin
Lagos
Posts: 204
Joined: Fri Apr 17, 2009 1:04 pm

Got it working on the comuter at work this morning.
It makes very interesting reading.

A great tool ....well done

Martin
BLUFFdisko
Posts: 30
Joined: Sun May 17, 2009 11:34 am

Hej nigelk

im a total newbee to excel

could you please tell me where i can download the spreadsheet that your spreadsheet connects with, from betfair
User avatar
kinglouie
Posts: 81
Joined: Mon Jul 12, 2010 1:45 pm

Hi Nigel

This is a very useful tool and after a bit of playing about I have got it to work.

Very impressed indeed.

Well done Sir.
Lagos
Posts: 204
Joined: Fri Apr 17, 2009 1:04 pm

Hi

I am having trouble getting this to work. I get this message highlighted in the de bugger

Columns("K:K").Sort Key1:=Range("K2"), Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal


after a runtime 1004 message.

Has anyone got any Ideas?

Thanks

Martin
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

What version of Excel are you using?

Nigel.
Lagos
Posts: 204
Joined: Fri Apr 17, 2009 1:04 pm

Hi Nigel

Thanks for replying, It looks like office 2000! so I guess thats the problem.??
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Delete the last part so it looks like this:

Columns("K:K").Sort Key1:=Range("K2"), Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
User avatar
William31
Posts: 2
Joined: Fri Nov 13, 2009 2:36 pm

Hi All
Ive down loaded an older version of Nigels Trading Record. [i believe version 2. no averages} Its a great piece of work / is there a newer / current version of this - ive looked but cant see any thing / can some one point me in the right direction. Thanks William
User avatar
William31
Posts: 2
Joined: Fri Nov 13, 2009 2:36 pm

Re: Trading Record / NigelK
Also im in Australia and the P/L is showing in pounds and also the totals on the far rhs P/L is in pounds how ever all the other totals are shown in $ / maybe the newer version has addressed this - thanks for any help.

William
Lagos
Posts: 204
Joined: Fri Apr 17, 2009 1:04 pm

Nigel

It has taken me since your reply on 15th May to find the time to sort it but I have now so thanks very much.

Martin
torrentco
Posts: 1
Joined: Sat Feb 02, 2013 10:04 pm

great stuff really.thanks a lot for this.

is tehre a sportsbook version of this?

thanks
User avatar
sneakydog
Posts: 9
Joined: Mon Dec 23, 2013 2:43 pm

Nigel,

Just like to thank you for your work. This is just what i was looking for.

Top Stuff!!
flemington
Posts: 5
Joined: Thu Jul 31, 2014 7:41 am

Guys,

Is there a way to check total strike rate ?

Spreadsheet is amazing, is this the latest version

Stephen
Post Reply

Return to “Trade analysis & record keeping”