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.
Greyhound Profit Loss analysis excel
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
You can switch the code from
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
ChDir "C:\Users\nigel\Desktop"
Workbooks.Open Filename:="C:\Users\nigel\Desktop\BettingPandL.xls"
Code: Select all
Workbooks.Open Filename:=Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls")
-
- 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.
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.