Trade analysis & record keeping : Excel Trading Analysis

Post Reply
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Wed May 27, 2009 7:03 pm

Tub's right. Open Office is a bit limited with macros as compared to Excel


Posts: 5
Joined: Tue May 05, 2009 12:59 pm

Thu May 28, 2009 1:22 pm

Cheers anyway guys

User avatar
Posts: 12
Joined: Mon Apr 20, 2009 6:18 pm

Thu May 28, 2009 4:28 pm

What a fantastic spreadsheet. Been meaning to do something like this but no point reinventing the wheel (and a very good wheel it is!)

I have a question about the strike rate as to whether it should count a £0 market as a negative. To me this is the same as not doing anything on the market but I can see it from the opposing side that you put trades into the market and didn't come away with a profit. What are your thoughts - should zero markets be ignored in the strike rate?

The only other thing I have noticed is that downloading the profit and loss sheets from betfair always means I have to open the spreadsheet first which cleans errors out of it before I can import it into the trading spreadsheet. I wouldn't be surprised if this is because I'm trialing Windows 7 but a little frustrating!

Keep up the good work.


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

Thu May 28, 2009 8:27 pm

Hi Dave,

I did think of ignoring the £0's but then thought
we set out to make a profit, and if we don't we've failed, hence them being counted of as failures.

Both ways are vaild. In football for example, a 0 would represent a draw, but in tennis, you can only win or lose.

Sorry about the spreadsheet problems, sounds like an unwanted feature of Windows 7.

PS. Feel free to mention the spreadsheet on you blog!


Posts: 2
Joined: Thu Apr 16, 2009 6:15 pm

Fri May 29, 2009 11:10 am

Thanks very much for sharing the results of your efforts, great bit of programming! Much appreciated.

Posts: 46
Joined: Thu Apr 16, 2009 9:44 am

Fri Jun 19, 2009 2:10 pm

Hi, I'm late to this thread but thought it would be a great tool to use. However, I haven't really got a clue about excel and can't make it work. It's just telling me it can't find a file named BettingPandL.
I saved the PandL from Betfair as "Save target as" and it saved it as BettingPandL on my desktop. It doesn't work. You said it works on Excel 2000/2003 and mine is 2000. Did you mean 2000 to 2003 or only those 2 years shown? I did alt F11 to change the file path, which I copied from the "properties" and it still doesn't work.
An idiot would be pleased for any advice.

User avatar
Posts: 147
Joined: Fri Apr 17, 2009 10:03 am

Sun Aug 23, 2009 8:04 pm

Hi Nigel,

Thanks for the spreadsheet - it's great.

The only thing is, most of my betting revolves around cricket - would you be interested in creating one for that sport?

If so, I'd be happy to re-imburse you with a reasonable amount.


Posts: 11
Joined: Wed Aug 26, 2009 1:36 pm

Wed Aug 26, 2009 6:42 pm


Thank you very much for a superb spreadsheet, managed to get it up and working with no problems, your instructions were excellent.

Just joined the forum and been using Bet Angel for aprox 2 months, mainly for laying but after yesterdays course at Hook I intend to start trading more than just on the odd race.

Your spreadsheet I'm sure will be a great aid.

Posts: 1
Joined: Wed May 06, 2009 6:32 pm

Sun Aug 30, 2009 2:25 pm

I downloaded the newest spreadsheet you put up here, its all working fine. All the races course/tracks come up... but i have one which has the name #value! what is that ?


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

Sun Aug 30, 2009 3:34 pm

It could be that either your spreadsheet contains place markets or that you are downloading the incorrect sheet ( should be BettingP&L not the Betting History sheet).


Post Reply

Return to “Trade analysis & record keeping”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest