Is it possible to learn how to successfully trade on Betfair (and Betdaq) markets in the long-term? Why do only 5% (or less) of traders manage this? Is the correct mind-set the most important factor leading to success?
'Horse Racing' tab in the Results Summary Spreadsheet (v3)
Many thanks to all the current purchasers of the Results Summary spreadsheet! It would be great to hear more from traders and gamblers who've used it to improve their profits.
For me, I was haemorrhaging money on flat races (in-play trading) which I wasn't aware of - a classic gambler's case of remembering the big wins and forgetting all the losers! Because I was only looking at the overall P&L things looked good. I also had a major "leak" on maiden hurdles at certain courses (in-play trading). Both these problems were very easy to see once I developed this functionality in the spreadsheet - at the press of a button your horse racing P&L is split between flat and jumps, you can then see splits by racecourse, distance, race type, date and you can also filter all of these. For example, you could see all the maiden hurdle races split by racecourse, or distance, sorted by profitability. The flexibility is really great and enables you to see what's really going on.
Market type, e.g. Match odds, over/under, tournament betting
Click on match or market type to see market information
'Football' tab
Horse Racing:
Race type
Distance (in furlongs)
New third table showing results by racecourse which can be sorted by P&L or racecourse.
Click on race type or distance or racecourse to see market level information
Horse racing split by jumps, flat, place market. Can be toggled to show total for all horse racing
Foreign racetracks now include the country code with the course name
'Horse Racing' tab
'My Sport' user definable tab:
This is a new concept in the spreadsheet for a dedicated user-definable sports tab
Are you a big Tennis, Darts, Cricket or MMA fan? Done!
You can even analyse Special Bets such as the X-Factor!
'My Sport' tab (Snooker selected)
Greyhound racing. See your results by:
Race grade (e.g. A1, A2, S1, OR etc)
Distance (in metres)
Track
Click on race grade or distance or track to see market level information
Foreign tracks include the country code with the track name
'Greyhound' tab
Further analysis for ALL sports
'Total by Sport' tab. See your results by:
Sub-total by every sport you have results for in a chart and accompanying table
Horse racing split by jumps, flat, place market. Can be toggled to show total for all horse racing
Monthly total broken down by each sport
'Total by sport' tab
'Running totals' tab:
Your P&L running total split out by sport
Timescale can be easily filtered to current year, current quarter, last quarter etc.
Sports can be easily filtered to only your results you are interested in, or all
Horse racing split by jumps, flat, place market. Can be toggled to show total for all horse racing
'Running totals' tab
'Graphs' tab:
P&L running total for all sports (as per the 'Summary' tab graph, just larger)
Average profit by market vs average loss by market each day. See this post for more about how this is useful.
Daily strike rate across markets
Timescale can be easily filtered to current year, current quarter, any range of dates
'Graphs' tab
'Month comparison' tab
P&L running total comparison by month
Timescale can be easily filtered to current year, last year, etc.
'Month comparison' tab (showing past three months only)
How to use your P&L analysis information
BUT! This spreadsheet isn’t just about keeping a record of your trading using tables and graphs. It’s been developed over several years to help with becoming a more profitable and consistent trader. I wanted to find out how to have less risk, less stress, less wasted time and more profit.
Of course you need to adapt your trading according to what you find out and the spreadsheet does not give betting advice. There’s a saying I really believe in which states, “If you keep doing what you've been doing you'll keep getting what you've been getting”. Only about 5% of Betfair customers make a long-term profit and that’s mostly very small. If you can take responsibility and own the fact that the results you see are because of the actions you’ve chosen to take, it means that you are in control. Find what aspects of your trading are working and hammer them hard! Reign back the stuff that’s increasing your losses. Simple, eh?!, so how come most people aren’t doing it?
How does it work?
Download your Betfair 'BettingPandL' file or Betdaq P&L file then simply click 'Import'. Simples!
New conversion spreadsheet allows you to import the Betfair Customer Report / Statement with your entire lifetime Betfair exchange P&L results (i.e. more than 3 months worth of data). This is to get around the 3-month limit Betfair has for the standard P&L download. See this post for more info.
General
Keep your P&L results private - NO uploading your results to someone else's website
Fully compatible with Betfair altered file format of 'BettingPandL' (changed in summer 2020)
OneDrive: Keep your data backed up in your OneDrive, now supported in v3
Betdaq P&L
Horse racing markets automatically separated from other sports (where Betdaq state the racecourse in the P&L file)
Horse racing summaries by win, place and each-way market results
Your card statement will show 'BTMG' as the merchant.
PayPal do not disclose your street address for this download-only purchase.
New conversion spreadsheet (available separately) allows you to import the Betfair Customer Report with all your betting history (for those with more than 3 months of betting history).
Requires Excel 2007 or newer for Windows Please check the detailed software requirements below for use of this spreadsheet before buying.
_______________________________________
Software requirements (not included!):
Excel 2007* or newer for Windows. Tested on XP, Vista, Windows 7, Windows 8 (see note below about Windows 7 and 8) and Windows 10.
Works on Excel 365 for Windows.
WILL NOT work on Excel 2003 and older, Open Office or Excel for Macintosh.
*Excel 2007 users - please email me AFTER your purchase for an additional file you will need.
International users may have to alter their Regional settings due to Betfair spelling out the dates in English text format within the BettingPandL file even for non English-speaking countries. In Windows 10 click on the Windows button and type 'Currency' and click on 'Change the way currency is displayed'. In Windows 7 & 8 go to Windows start button > Control Panel > Regional and Language Options > Formats (tab) - Current format and set to "English - United Kingdom". See this post Using your Language and Currency format
Windows 7 & 8: There is a security scan in Windows 7 & 8 which can prevent 3rd party Excel files such as the Betfair P&L file from being opened. When trying to open the Betfair P&L file in excel you will get the error message,"Run-time error '1004': Method 'Open' of object 'Workbooks' failed". Please download a Betfair P&L file and make sure you can open it before purchasing the 'Results Summary' spreadsheet. If you are using Windows 7 / 8 you can open the Betfair P&L using Open Office (free software) - then by saving it without any changes it can be opened by Excel under Windows 7 /8. Equally, if you have access to another PC with XP or Vista you can re-save the file before transferring it to your Windows 7 / 8 PC. This is a known issue which Microsoft have no plans to rectify http://social.msdn.microsoft.com/Forums/is/exceldev/thread/69434b37-a3ed-4970-a929-89e03ee01aaf
Windows 10: The issue described above with Windows 7 & 8 does not occur with Windows 10. You can download the BettingPandL file from Betfair and directly open it in Excel. Happy days!
Once downloaded, no refunds will be given under any circumstances, please make sure you have the right Excel software and can open the BettingPandL file downloaded from Betfair.
The new version of Results Summary Spreadsheet (v3) has just been released! It can be purchased using the link on this post.
This was required because in July Betfair changed the data format of the BettingPandL file and so it was no longer compatible. Anyhow, more recently they have changed the download file again and the required information is now available. The new spreadsheet v3 is fully compatible with this new download format.
If you are a prior purchaser of v2 Results Summary Spreadsheet
There is a special offer for all prior v2 purchasers upgrading - 50% off the full price!
To apply the discount you will need your unique discount code. Your unique discount code can only be used once.
Your unique discount code is based on the email address you used when making your original purchase.
The discount code doesn't accept special characters only letters and numbers. So an example of a discount code is:
An example email:
Joe_Bloggs.420@BigMarketSwinger.com
Your example unique discount code would be:
JoeBloggs420BigMarketSwingercom
The code is not case sensitive so joebloggs420bigmarketswingercom would work in this example (but don't bother trying it out for real!).
How to make the discounted purchase:
Click 'ADD TO CART' blue button:
then click 'ADD PROMO CODE' on the new screen (example screenshot below):
Click the 'ADD PROMO CODE' button:
After entering your discount code click 'APPLY'
Check that the code has been accepted and the discounted price is correct
Click 'Pay Using PayPal'. You do not need a PayPal account to pay by debit / credit card.
After downloading Results Summary Spreadsheet v3, please use the 'Import records from previous version' button and select your old spreadsheet file and all of your data will be transferred into the new spreadsheet. Simples!
New conversion spreadsheet allows you to import the Betfair Customer Report / Statement with your entire lifetime Betfair exhange P&L results (i.e. more than 3 months worth of data). This is to get around the 3-month limit Betfair has for the standard P&L download. See this post for more info.
Or check out this video on getting started with v3 Results Summary spreadsheet: