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.
Excel Trading Analysis Greyhounds
-
- Posts: 688
- 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.
Would love to see what you could come up with to analyse settled individual bets.