How to Make a Profit & Loss Spreadsheet?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
nivi7
Posts: 163
Joined: Mon Jul 01, 2019 9:53 pm

hey everyone
i d like to begin keeping proper records of my betting
what i do now is to post on a cell next to the date the profit or loss of the day
but i wish to make it more informative and include the markets i bet on,the leagues,the odds etc

but my knowledge in excel in,unfortunately,very limited
can you provided me with a ready spreadsheet?

i look on these helpful sites but i didnt found what i was looking for

https://templates.office.com/en-us/profit-and-loss
https://www.spreadsheet123.com/ExcelTem ... ement.html
User avatar
Kai
Posts: 6092
Joined: Tue Jan 20, 2015 12:21 pm

Dallas made a simple profit & loss spreadsheet here for racing looks like, maybe it can be adapted to footy : viewtopic.php?t=12327
MindGames
Posts: 8
Joined: Sat Sep 29, 2018 10:09 am

nivi7 wrote:
Sun May 17, 2020 5:10 pm
hey everyone
i d like to begin keeping proper records of my betting
what i do now is to post on a cell next to the date the profit or loss of the day
but i wish to make it more informative and include the markets i bet on,the leagues,the odds etc

but my knowledge in excel in,unfortunately,very limited
can you provided me with a ready spreadsheet?

i look on these helpful sites but i didnt found what i was looking for

https://templates.office.com/en-us/profit-and-loss
https://www.spreadsheet123.com/ExcelTem ... ement.html
Hi nivi, I created the Results Summary spreadsheet which is available on my blog https://betfairtradingmindgames.blogspo ... -here.html. It will enable you to keep proper records of your betting and makes it easy to analyse your results in many ways, including by month, week, date, time, sport, racecourse, distance and more! The spreadsheet uses the Betfair BettingPandL.xls download file which has your results by market but not the individual bets so no odds information is available. There are also some videos showing the spreadsheet in action. Let me know if you have any questions!
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

https://www.dropbox.com/preview/My%20Be ... e=personal

here is a link to something i created a few years ago. the figures are examples to give you an idea.
Berimbau
Posts: 7
Joined: Fri Oct 28, 2011 11:29 pm

Hi !!
In past i buy the Results Summary v2 spreadsheet but i lost this spreadsheet when change my PC.
Someone can help me to have again this spreadsheeet because actually the file not is available on blog of Betfair Trading Mind Games at this link
https://betfairtradingmindgames.blogspo ... tions.html
MindGames
Posts: 8
Joined: Sat Sep 29, 2018 10:09 am

Hi Berimbau,
I will make a new release of the spreadsheet available soon. Betfair changed the format of the Profit and Loss Excel data file available (for the first time in years) so the old spreadsheet doesn't recognise the new format.
I will let you know when it's available (soon). You can always email me directly using the address on the 'about me' info of my blog with any questions.
Thanks,
Mind Games
Berimbau
Posts: 7
Joined: Fri Oct 28, 2011 11:29 pm

Thank you for reply !!
I will send you now an email to [email protected]
to save your email and have updates about your new spreadsheet
MindGames
Posts: 8
Joined: Sat Sep 29, 2018 10:09 am

Hi Berimbau,

Results Summary Spreadsheet v3 is now available from my blog! You can link to it from my 'contact' button on this post (then choose the globe icon).

You encouraged me to finish off the work I had done on the new version, thanks! Please let me know if you have any questions.

Thanks, Mind Games
Berimbau
Posts: 7
Joined: Fri Oct 28, 2011 11:29 pm

Hi Mind Games !!
As i said before i was a prior purchaser of the Results Summary Spreadsheet but unfortunately when i change my PC 2 years ago i lost your spreadsheet.
There is opportunity to have the new file excel or need to buy again ?
MindGames
Posts: 8
Joined: Sat Sep 29, 2018 10:09 am

Hi Berimbau,

YES there is a discount for ALL prior purchasers for the upgrade! Including purchases made nearly 10 years ago!

Thanks, MG
Berimbau
Posts: 7
Joined: Fri Oct 28, 2011 11:29 pm

Hi Mind Games !!
Actually on your blog there is only the " Buy Button " for the price of £ 2.97.
How to have a discount as you say ?
MindGames
Posts: 8
Joined: Sat Sep 29, 2018 10:09 am

Please look at the most recent post (titled 'Results Summary Spreadsheet v3 is now available!'). You can get there directly by clicking on the icon next to the 'Contact' button on this post and selecting the globe icon.
Please email me directly with any queries!
Thanks, MG
Berimbau
Posts: 7
Joined: Fri Oct 28, 2011 11:29 pm

Hi Mind Games !!
I email you for other question but don't receive your reply.
I simulated to buy with unique discount code and i see the price change from 2,97 GBP to 1,99 GBP , but i want to know if i can use your new excel because i lost my old excel and want to know if i can use too your new excel without my old excel.
Thank you in advance
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

This is possibly the worst shilling I've seen
Anbell
Posts: 2004
Joined: Fri Apr 05, 2019 2:31 am

spreadbetting wrote:
Sat Oct 31, 2020 2:46 am
This is possibly the worst shilling I've seen
Yeah, but can't you just appreciate it? Just a little bit?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”