Excel Trading Analysis

[Lagos]

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]

What version of Excel are you using?

Nigel.

[Lagos]

Hi Nigel

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

[nigelk]

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

[William31]

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

[William31]

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]

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]

great stuff really.thanks a lot for this.

is tehre a sportsbook version of this?

thanks