Greyhound Profit Loss analysis excel

We've gone to the dogs.
Post Reply
Gonzothegreat
Posts: 78
Joined: Sat Aug 05, 2017 4:21 pm

Hi,

In the following post I asked about a spreadsheet to check your profit loss per track etc...
I was pointed to the following spreadsheet, however as this post was done in 2011, it no longer works with the BettingPandL.xls you get from BetFair today.

I have spend some time today and modified the VBA code, it now report correctly as expected.
Google drive link

The following still apply:
ChDir "C:\Users\nigel\Desktop"
Workbooks.Open Filename:="C:\Users\nigel\Desktop\BettingPandL.xls"


As I only trade the dogs, I do not know if this will work with other markets.

Credits to Nigel for creating this spreadsheet in the first place.
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

You can switch the code from

Code: Select all

ChDir "C:\Users\nigel\Desktop"
Workbooks.Open Filename:="C:\Users\nigel\Desktop\BettingPandL.xls"
to the following so people with no VBA knowledge don't have to hard code the directory, can always add a message box telling the what to do if it's not clear. MsgBox "Navigate to, and open, your BettingPandL.xls file to load new records" etc

Code: Select all

Workbooks.Open Filename:=Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls")
Gonzothegreat
Posts: 78
Joined: Sat Aug 05, 2017 4:21 pm

Cool thanks, I will modify the code.

edit:
the modifications I've done in the code were about parsing the content of the BettingPandL.xls file.
it was broken, as in : not pulling all the right data and putting wrong data in the wrong columns.
Pepoli
Posts: 2
Joined: Fri Jul 10, 2020 11:38 am

Hi Gonzothegreat,

I'm wondering if I can use your spreadsheet. I'm a newbie in trading and currently trading Greyhounds markets both AU and UK.

Thank you.
Post Reply

Return to “Trading Greyhound racing”