Hi Guys,
I'm setting out to create my own P&L Spreadsheet from scratch but have very basic Excel skills. I'm currently using a manual spreadsheet that I just type results into but its very time consuming. Can anybody offer me a starting point?
I'm guessing using a pivot table is the way to go but can't figure out how to extract the data from a Betfair P&L spreadsheet.
Can anyone with the knowledge required tell me how to do this?
Help Creating P&L Spreadsheet
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Nigel has posted up a pnl spreadsheet in the past why not just tweak that to do what you want. At the very least you can use the code snippets to understand how to import the betfair bettingpnl files into excel
download/file.php?id=8922
viewtopic.php?f=60&t=133
download/file.php?id=8922
viewtopic.php?f=60&t=133