Trading Greyhound racing : Greyhound Profit Loss analysis excel

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

Sun Sep 03, 2017 10:52 am

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: 1443
Joined: Sun Jan 31, 2010 8:06 pm

Sun Sep 03, 2017 3:11 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: 75
Joined: Sat Aug 05, 2017 4:21 pm

Sun Sep 03, 2017 3:18 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.


Post Reply

Return to “Trading Greyhound racing”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest