Excel Trading Analysis

Post Reply
User avatar
TheTub
Posts: 267
Joined: Thu Mar 26, 2009 7:53 pm
Location: Nottinghamshire

I've got to say..... this is top notch!

Well done and huge thanks. This is invaluable. I can already see that I make most profit on Group 1, claimers and Grp2 and least on Maiden Stakes. Folkstone is my happy course and I shall be avoiding Pontefract!

It would be fun to hear what others find!

There are a couple of cells that say '#VALUE!' but I'm sure I can sort those out.

An impressive job.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Thanks Tub.
Can you let me know what cells the #values are appearing in?

Nigel
User avatar
jimrobo
Posts: 1289
Joined: Wed Mar 25, 2009 12:49 pm

Thanks nigel great addition!

Great information from it! I can already see the irish tracks are going to be completely avoided for the summer! As well as sell stks!

I dumped 2 months worth of results in there and overall strike rate was 73%. Not sure whether that is good, bad or average!
User avatar
TheTub
Posts: 267
Joined: Thu Mar 26, 2009 7:53 pm
Location: Nottinghamshire

nigelk wrote:Can you let me know what cells the #values are appearing in?

Nigel
Sorted it - My BettingPandL.xls sheet also featured place markets. It was these causing the '#value!' entries.
taxbreaks1
Posts: 23
Joined: Thu Apr 16, 2009 12:25 pm

Nigel spreadsheet great but will not work for me?

ChDir "C:\Users\nigel\Desktop"
Workbooks.Open Filename:="C:\Users\nigel\Desktop\BettingPandL.xls"

I replace your name with mine and it will not update takes me back to debug same lines? Any ideas?

Thanks
andyfuller
Posts: 4619
Joined: Wed Mar 25, 2009 12:23 pm

Brilliant stuff!!!

Only thing, would it be possible to make it so you can sort by AV?

Many thanks for you effors - I had tried to make something similar before but compared to this my efforts are embarrising :)
User avatar
TheTub
Posts: 267
Joined: Thu Mar 26, 2009 7:53 pm
Location: Nottinghamshire

Adding day of week would be handy. But that could take some coding.

I might have a bash at that when I've got a spare hour or two.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Taxbrakes, What version of Excel are you using?
Are the errors just on those two lines and can you tell me what the message says?

Andy, I did do that, but then binned it!.

Tub, I'll have a look at adding dates.

Nigel.
User avatar
afropunk
Posts: 24
Joined: Tue Apr 21, 2009 12:28 am

Hey Nigel,

First of all thank you so much for the spreadsheet. Looks very useful indeed.

Regrettably I am having some trouble getting it up and running. At first I had a debug error message, however after some moving around of the files and a few renaming attempts of the Copy Data location I have managed to get it to locate my spreadsheet. Unfortunately though it does not appear to be reading this correctly. I will attach some screenshots below to show you exactly what I am doing.

Image

Image

As you can see it does identify the total markets correctly however teh rest of the sheet is not being populated.

Could someone please point me in the right direction. Am hoping to get this working today, looks very handy. Would appreciate any ideas.

I am using Excel 2003 and Windows XP.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Afropunk,
Tub had a similar problem with the #values message, he had done some trades on the place market, and it was these that was causing his problem.

I've never traded these markets, and I can only assume that they have different descriptions/layout of text as the "normal" ? markets.

If someone would like to compare the two and post a line of each, maybe we can reach a solution?

How did you insert the image? I've clicked on the Img button before, and that's as far as I've got.

Let us know what you find.
Thanks,Nigel
Post Reply

Return to “Trade analysis & record keeping”