Help Creating P&L Spreadsheet

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
RonObvious
Posts: 198
Joined: Mon Dec 09, 2013 4:12 pm

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?
spreadbetting
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
RonObvious
Posts: 198
Joined: Mon Dec 09, 2013 4:12 pm

Thanks, thats definitely a help :)
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”