Excel Trading Analysis Greyhounds

Example spreadsheets and comments on example spreadsheets.
Post Reply
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Guys,
As before but for greyhounds.

I only had 4 rows of data to work with but, (fingers crossed), everything should be ok. If not please let me know.

Things to note:
As the downloaded sheet from Betfair will have the same name as the horses, I've told this one to look out for a spreadsheet named GBettingPandL (change to suit to whatever name you want to save the spreadsheet as).

Secondly, If some of you are VBA inclined and are experimenting (thats' how I learnt!) with the horses spreadsheet and keep getting the error message everytime you try something new, it's probably NOT the pathway that is causing the error.

I forgot to re-set the trap, and no matter what error occurs or where, it will drop right down to the trap.

I fixed it on this one with

On Error GoTo Errtrap

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

On Error GoTo 0

Thanks,Nigel.
You do not have the required permissions to view the files attached to this post.
Nero Tulip
Posts: 686
Joined: Wed Apr 15, 2009 5:29 pm

Great work Nigel! Thanks for sharing. Very interesting stuff indeed!

Would love to see what you could come up with to analyse settled individual bets.
Post Reply

Return to “Bet Angel - Example spreadsheets”