Trade analysis & record keeping : Excel Trading Analysis

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

Sat May 14, 2011 11:16 am

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: 461
Joined: Wed Apr 15, 2009 11:00 pm

Sat May 14, 2011 9:27 pm

What version of Excel are you using?

Nigel.

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

Sat May 14, 2011 11:21 pm

Hi Nigel

Thanks for replying, It looks like office 2000! so I guess thats the problem.??

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

Sun May 15, 2011 9:55 am

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

Sat Jun 25, 2011 10:50 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

Sat Jun 25, 2011 10:57 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

Sun Dec 30, 2012 5:55 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

Sun Feb 03, 2013 8:53 am

great stuff really.thanks a lot for this.

is tehre a sportsbook version of this?

thanks

sneakydog
Posts: 7
Joined: Mon Dec 23, 2013 2:43 pm

Sat Feb 08, 2014 7:01 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

Sat Nov 08, 2014 12:30 pm

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”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 0 guests