Excel Trading Analysis

Post Reply
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
Rafick385
Posts: 14
Joined: Tue Oct 21, 2014 1:07 pm

Hi,

I'm testing a rule and would like to know how to use this together with the Bet Angel P&L spreadsheet. I'm not good at spreadsheets and I have never been able to get something readable from Bet Angel's spreadsheet.

Thanks.

Rafick
Rafick385
Posts: 14
Joined: Tue Oct 21, 2014 1:07 pm

Nobody replied but I've been able to sort it out. Thanks.
andyfuller
Posts: 4619
Joined: Wed Mar 25, 2009 12:23 pm

Does anyone know if this would work with Betdaq's P&L's?

Also (more importantly) where do you download the latest version - I have read through the whole thread and can't seem to figure it out :?

Or is there a different thread where an analysis spreadsheet is available?

TIA.
User avatar
deanbond07
Posts: 3
Joined: Mon Nov 21, 2016 12:15 pm
Location: Cambridge

I know this was back in 2009, but I just downloaded and amended the directories in the Macro and it works perfectly - brilliant...thank you :)
User avatar
gstar1975
Posts: 613
Joined: Thu Nov 24, 2011 11:59 am

Bet Angel wrote:
Tue May 19, 2009 9:52 pm
Please see attached..
Is there any instructions on how to use this spreadsheet? How do I link it to my Betfair account results?
Post Reply

Return to “Trade analysis & record keeping”