tag:blogger.com,1999:blog-66345488633473549472024-03-13T01:24:20.458+00:00Betfair Trading Mind GamesIs 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?Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.comBlogger44125tag:blogger.com,1999:blog-6634548863347354947.post-69729588649924914032021-12-07T17:31:00.029+00:002022-01-07T14:31:57.115+00:00‘Betfair Customer Report’ conversion spreadsheet available for download<p><i><span style="color: #666666;">Note: This post is about an <u>optional</u> add-on spreadsheet for the <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">Results Summary Spreadsheet</a>.</span></i></p><p><i><span style="color: #666666;">Note: This post is only relevant to purchasers of Results Summary Spreadsheet with betfair accounts more than 3 months old and who want access to all of their historic betting data (maybe years or decades worth).</span></i></p><p>There’s a problem…..and a solution!</p><p><b><u>Problem</u></b></p><p><span>Whilst Betfair offer up to 3 months of betting Profit and Loss data download from "My Account" area on their website as a file called 'BettingPandL', if you require any more than that then you need to contact their helpdesk. They will provide a report of the entire betting results on your account since opening, if you ask nicely! However, their report format is different to </span>'BettingPandL' and has also recently changed.</p><p>I’ve had a number of purchasers of the <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">Results Summary Spreadsheet</a> recently contact me with news that Betfair will no longer provide their customers with the <a href="https://betfairtradingmindgames.blogspot.com/2011/08/betfair-lifetime-results-how-to-make.html" target="_blank">lifetime P&L report</a> in the original format. Betfair support have stated to a number of customers that it is not possible for them to provide the old format report anymore, after many years of doing so.</p><p>The new format report that Betfair provide, titled “Betfair Customer Report” (or "Statement") looks like this:</p><p></p><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiCcaNOeJNMMiT_tmPIjSoML8QscWqUsmM-UuaZlIscW5FGB_WKtOsJpPKMZVqE-b2WPQrjzlnthjA1QoL7HFgPyUaoyGc84tfXH24kdE25lpPfO3CLiJuWHVzlCFtBr2i3JPpUQ4CW2LMyRGsjzIibvZUHefdiKk3r9K8hSRBYnouVbUB1GuO2yiZ5Dg=s1429" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="661" data-original-width="1429" height="296" src="https://blogger.googleusercontent.com/img/a/AVvXsEiCcaNOeJNMMiT_tmPIjSoML8QscWqUsmM-UuaZlIscW5FGB_WKtOsJpPKMZVqE-b2WPQrjzlnthjA1QoL7HFgPyUaoyGc84tfXH24kdE25lpPfO3CLiJuWHVzlCFtBr2i3JPpUQ4CW2LMyRGsjzIibvZUHefdiKk3r9K8hSRBYnouVbUB1GuO2yiZ5Dg=w640-h296" title="Betfair Customer Statement" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><span style="font-size: small;">Betfair Customer Statement</span><span style="font-size: x-small;"> (identifying information has been removed)</span></td></tr></tbody></table><br /><div>This has two fundamental problems compared to the old lifetime P&L report report:</div><p></p><p class="MsoNormal">1.<span style="white-space: pre;"> </span>Each row is an individual bet result, before commission is deducted. The original report had the total P&L net of commission on each row for every market (e.g. horse race, football match odds).</p><p class="MsoNormal">2.<span style="white-space: pre;"> </span>The sport name isn’t stated. This is a big omission that is needed for the Results Summary Spreadsheet to help you understand your P&L by sport. Adding in the sport name manually is problematic as most customers using this will have several thousand bets on their account!</p><div><br /></div><p class="MsoNormal"><b><u>Solution</u></b></p><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiIoeqBAoghdSXFxJcxDWmIp6DO2AX3M28UljRAg6fBxgXZKy3eJKUNBrK7qnODzovVI8w5NxuBFrBcHRLwKQC4xqTeKJv1Q7EWb4lC09tPP-1Qlt-EMBGz47P5ratejXxl0yqVVp8qVxh7j9SlWwa4gfPmFwDEYuQNbbxO6zls1O4Q05Rm2a8dI1NasQ=s1499" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1023" data-original-width="1499" height="436" src="https://blogger.googleusercontent.com/img/a/AVvXsEiIoeqBAoghdSXFxJcxDWmIp6DO2AX3M28UljRAg6fBxgXZKy3eJKUNBrK7qnODzovVI8w5NxuBFrBcHRLwKQC4xqTeKJv1Q7EWb4lC09tPP-1Qlt-EMBGz47P5ratejXxl0yqVVp8qVxh7j9SlWwa4gfPmFwDEYuQNbbxO6zls1O4Q05Rm2a8dI1NasQ=w640-h436" title="Convert Betfair Customer Report - showing unfiltered results with 98% of sports identified and the remainder highlighted" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><span style="font-size: small;">Convert Betfair Customer Report - showing unfiltered results with 98% of sports auto-identified and the remainder highlighted</span></td></tr></tbody></table><p class="MsoNormal">I’ve created a new spreadsheet called, “<b>Convert Betfair Customer Report</b>” {snappy, heh?!}. This largely solves the problems created by Betfair’s new report format:</p><p class="MsoNormal"></p><ol style="text-align: left;"><li>The new conversion spreadsheet sums up the exchange bets and deducts the commission to provide the net of commission P&L for each market, as per the original format report.</li><li>The new conversion spreadsheet analyses the bet data and can automatically identify and enter the sport for the vast majority of bets so you will <u>save potentially hours or days of time.</u></li></ol><p></p><p class="MsoNormal"></p><ul style="text-align: left;"><ul><li>This varies by sport – for horse racing and greyhound racing it will add in the sport for virtually all records. It will also identify football bets for all non-international games involving English teams and most European teams. Other identifiers are used, e.g. goals, frame, and leg for football, snooker and darts.</li><li>The remainder needs to be manually entered by you but <u>this should only take 5-20 minutes</u> depending on your data and variety of bets. The spreadsheet is set-up to make this data-entry easier. It also identifies bets of team vs team or player vs player which helps narrow it down for you.</li></ul></ul><p></p><p class="MsoNormal">Results cannot be guaranteed, however what we’ve experienced so far has been as <b>high as 98% of all markets auto-identified</b> with the lowest score still being a whopping 92%! Results will depend on how many different sports you’ve bet on and how obscure they are. Even so, if you’ve only bet on the horses and volleyball then any bets not identified are likely to be volleyball and after a quick check you can copy them down in one go. Simples!</p><p class="MsoNormal">The results can then be exported with a click and <b>imported into the Results Summary Spreadsheet in one go</b> (Results Summary Spreadsheet is available separately <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html" target="_blank">here</a>).</p><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-align: center;">_______________________________________</div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-align: center;"><br /></div><div style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: center;"><br /><div style="color: #333333; font-size: 14.85px;"><span style="font-size: medium;"><b>Click on the 'BUY NOW' button for an instant download of the spreadsheet</b></span></div><div><span style="color: #999999;"><b><i>(DOES NOT include the <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html" target="_blank"><span style="color: #999999;">Results Summary Spreadsheet</span></a>!)</i></b></span></div><div style="font-size: 14.85px;"><br /><b style="color: #0b5394;"><span style="font-size: large;">Only £4.</span><span style="font-size: medium;">97</span></b><br /><span style="color: #0b5394;">(How many hours / days will this save you?)</span></div><div class="separator" style="clear: both; color: black; font-size: 14.85px;"><a href="https://www.e-junkie.com/ecom/gb.php?&c=cart&ejc=2&cl=162630&i=1730990" style="color: #336699; text-decoration-line: none;" target="_blank"><img alt="Buy Now" border="0" height="121" src="https://www.e-junkie.com/ej/x-click-butcc.gif" style="border: none; position: relative;" width="200" /></a></div><div class="separator" style="clear: both; color: black; font-size: 14.85px;"><a href="https://www.e-junkie.com/ecom/gb.php?c=cart&ejc=2&cl=162630">View cart</a></div><div class="separator" style="clear: both; font-size: 14.85px;"><span style="color: #38761d;"><br /></span></div><div class="separator" style="clear: both; font-size: 14.85px;"><span style="color: red;">IMPORTANT!</span><span style="color: #38761d;"> </span><span>Ask betfair for your Customer Report before purchasing the spreadsheet. </span></div><div class="separator" style="clear: both; font-size: 14.85px;"><span>Make sure it looks like the one shown above,</span></div><div class="separator" style="clear: both; font-size: 14.85px;"><span> it must include the following three / four columns</span>:</div><div class="separator" style="clear: both; font-size: 14.85px;"><br /></div></div><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px; text-align: left;"><div style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: center;"><div class="separator" style="clear: both; font-size: 14.85px; text-align: left;"><span><b>1. Settled Date</b></span></div></div><div style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: center;"><div class="separator" style="clear: both; font-size: 14.85px; text-align: left;"><span><b>2. Details </b>- Event name; betting market,</span><span style="background-color: transparent;"> </span></div></div></blockquote><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px; text-align: left;"><div style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: center;"><div class="separator" style="clear: both; font-size: 14.85px; text-align: left;"><span><span> </span><span> </span><span> </span><span> </span><span> </span>e.g. "Leicester 15th Nov; 15:30 2m4f Hcap Hrd"</span></div></div><div style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: center;"><div class="separator" style="clear: both; font-size: 14.85px; text-align: left;"><span><span> </span><span> </span><span> </span><span> </span><span> </span>or "Man Utd v Man City; Over/Under 3.5 Goals"</span></div></div><div style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: center;"><div class="separator" style="clear: both; font-size: 14.85px; text-align: left;"><span><b>3. Either:</b></span><span style="background-color: transparent;"> </span></div></div></blockquote><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px; text-align: left;"><div style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: center;"><div class="separator" style="clear: both; font-size: 14.85px; text-align: left;"><ul style="text-align: left;"><li><span><b>Deposit</b> (winning bet payout, number)</span> AND <b>Credit</b> (losing bet amount, number)</li></ul></div></div></blockquote><p><span> </span><span> </span><span> </span><span> </span><b>or </b></p><p></p><ul style="text-align: left;"><ul><li><span face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" style="background-color: white; font-size: 14.85px;"><b>Amount </b>(single column showing winning bets as a positive number, losing bets as a negative number)</span></li></ul></ul><p></p><div style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: center;"><div class="separator" style="clear: both; font-size: 14.85px;"><span><br /></span></div><div class="separator" style="clear: both; font-size: 14.85px;"><span>The columns can be in any order and the heading names don't matter, it's the contents that matter. </span></div><div class="separator" style="clear: both; font-size: 14.85px;"><span><br /></span></div><div class="separator" style="clear: both; font-size: 14.85px;"><span>Any doubts then please email me, no refunds are available once you've downloaded the product.</span></div><div class="separator" style="clear: both; font-size: 14.85px;"><span><br /></span></div><div class="separator" style="clear: both; font-size: 14.85px;"><span style="color: #38761d;">See below for software requirements (different to Results Summary Spreadsheet)</span></div><div class="separator" style="clear: both; color: black; font-size: 14.85px;"><br /></div><div class="separator" style="clear: both; color: black; font-size: 14.85px;"><b style="font-size: large;"><u>No PayPal account necessary for purchase</u></b></div><div class="separator" style="clear: both; color: black; font-size: 14.85px;"><div class="separator" style="clear: both;"><a href="https://www.e-junkie.com/ecom/gb.php?i=914894&c=single&cl=162630" style="color: #336699; margin-left: 1em; margin-right: 1em; text-decoration-line: none;" target="_blank"><img border="0" data-original-height="802" data-original-width="829" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdDNhKsFx6jDIclphpfM301WtFFO5gb45vioOzJza1F6xDj76qxRcxiJLOIe4kRxoKR-zSslhJnkNXb8agfh9Y9c1JRZBjP36gPHIa7cG2lKt4y2kCyacUn4_v7CqDwG6JcdujtTSW0jl_/s320/temp.png" style="border: none; position: relative;" width="320" /></a></div><div><span style="color: #0b5394;">Your card statement will show 'BTMG' as the merchant.</span></div><div><span style="color: #0b5394;">PayPal do not disclose your street address for this download-only purchase.</span></div></div><div style="color: black; font-size: 14.85px;"><div><br /></div><div><div><span style="color: #0b5394;">Price includes free access to future updates e.g. v1.0 to v1.1, v1.2 etc</span></div><div><span style="color: #0b5394;">(upgrades apply to new versions e.g. v2 to v3)</span></div></div><div><span style="color: #0b5394;"><br /></span></div><div><span style="color: #0b5394;">Price includes bundle with the original <a href="https://betfairtradingmindgames.blogspot.com/2011/08/betfair-lifetime-results-how-to-make.html">'Lifetime' conversion spreadsheet</a>.</span></div><span style="color: #cc0000; font-size: x-small;"> </span></div><table align="center" border="0" cellpadding="10" cellspacing="0" style="color: #0b5394; font-size: 14.85px;"><tbody><tr><td align="center"><u style="color: black;"><b>Requires Excel 2010 or newer for Windows</b></u><b> </b><br /><span style="color: #38761d;">Please check the detailed <b>software requirements</b> below for use of this spreadsheet before buying.</span></td></tr></tbody></table><table align="center" border="0" cellpadding="10" cellspacing="0" style="color: #0b5394; font-size: 14.85px;"><tbody><tr></tr></tbody></table></div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-align: center;">_______________________________________</div><div style="background-color: white; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><br /><span style="color: #38761d;"><b>Software requirements </b>(not included!):</span></div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: #38761d;"><u><b>Excel 2010 or newer for Windows</b></u>. </span><span style="color: #38761d;">Excel 365 recommended (Windows version only).</span></div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: #38761d;"><br /></span></div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: #38761d;"><b>Excel 2010 - Excel 2016</b> users will need to apply a FREE add-on from Microsoft which can be downloaded <a href="https://www.microsoft.com/en-US/download/details.aspx?id=39379" target="_blank">HERE</a>.</span></div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: #38761d;"><br /></span></div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"></div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><span style="color: #38761d;"><u><b>WILL NOT work on Excel 2007</b> and older, Open Office or any version of <b>Excel for Macintosh.</b></u><br /></span></div><p class="MsoNormal"><u style="background-color: white; color: #38761d; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><b>WILL NOT work on any operating system other than Windows.</b></u></p><p class="MsoNormal"><u style="background-color: white; color: #38761d; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"></u></p><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-align: center;">_______________________________________</div><div><br /></div><p class="MsoNormal">Here's the 'How to' video for using the conversion spreadsheet:</p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="471" src="https://www.youtube.com/embed/50mBwxr6sl4" width="568" youtube-src-id="50mBwxr6sl4"></iframe></div><br /><p class="MsoNormal"><br /></p>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com2tag:blogger.com,1999:blog-6634548863347354947.post-35047631990040792902021-03-04T18:33:00.006+00:002021-03-15T18:27:30.114+00:00New 'filter by sport' control on 'Total by Sport' tab (Results Summary Spreadsheet v3.3.4)<p>There's a major update to the '<b>Total by Sport</b>' tab which includes:</p><p></p><div><ul style="text-align: left;"><li>'<b>Filter by Sport</b>' control which controls all three tables</li><ul><li>Select one or several sports</li><li>Exclude one or several sports</li><li>All sports</li></ul><li>New <b>third table</b> showing market type information by sport</li><li>New '<b>expand</b>' button and '<b>Toggle sort column</b>' button to sort the table either by profitability or alphabetically by market type</li><li>This tab is now similar to the 'My Sport' tab but can be switched to a different sport with a single click. The 'My Sport' tab is intended for your favourite other sport that you want setup more permanently for review. </li><li>The chart previously on this tab has been moved to the 'Graphs' tab</li></ul></div><div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCyEQprnmMo4LVKs9So9YGm7Hhyphenhyphenyw5_BFkiSUEGMQOYrj25iIGSv9D5OnE0baAdOMBhAXmjrvPUTukKpdYNtQI5_ibSTg5ge20C3O19UVbeywpvEzQKoWPf7svgRbttwVWJXY0nicar-ZG/s1920/Total+by+sport.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1039" data-original-width="1920" height="346" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCyEQprnmMo4LVKs9So9YGm7Hhyphenhyphenyw5_BFkiSUEGMQOYrj25iIGSv9D5OnE0baAdOMBhAXmjrvPUTukKpdYNtQI5_ibSTg5ge20C3O19UVbeywpvEzQKoWPf7svgRbttwVWJXY0nicar-ZG/w640-h346/Total+by+sport.jpg" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'Football' selected on the new 'Filter by Sport' control</td></tr></tbody></table><br /></div><div>The latest version released today (v3.3.5) added a <b>daily market count</b> on the central table of the 'Summary' tab and this is also <b>shown graphically</b> on the 'Graphs' tab. Check out the updated screenshot <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">here</a>.</div><div><br /></div><div>Previous purchasers of v3 of the spreadsheet have already been emailed with their free update details.</div><div><br /></div><div>If you are a prior purchaser of v2 of the spreadsheet then you can upgrade for <b>50% off the full price</b>! <a href="https://betfairtradingmindgames.blogspot.com/2020/10/results-summary-spreadsheet-v3-is-now.html">Click here</a> to find out how.</div><div><br /></div><div>To find out more about the whole spreadsheet <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">click here</a>.</div><div><br /></div><div>p.s. Happy 4.3.21 !<br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /></div><p></p>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com0tag:blogger.com,1999:blog-6634548863347354947.post-87868759863817504652020-12-04T16:37:00.005+00:002021-01-01T17:09:18.395+00:00Benefits of analysing your P&L easily with Results Summary Spreadsheet<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiROXRdrrJTTeAX0xWRJekxOgaiC8a8vMcqAnJCBRZJPWdt4BYTOFJC_bE_VW6BThvld62Jt8kokepEECgcnidAb-DepQM2XHcyCh2hFxBqdQQ1iFYFdfdNXqp5vhM18h29mzZggMDnbkCD/s2528/Horse+racing.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1243" data-original-width="2528" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiROXRdrrJTTeAX0xWRJekxOgaiC8a8vMcqAnJCBRZJPWdt4BYTOFJC_bE_VW6BThvld62Jt8kokepEECgcnidAb-DepQM2XHcyCh2hFxBqdQQ1iFYFdfdNXqp5vhM18h29mzZggMDnbkCD/w622-h305/Horse+racing.jpg" width="622" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'Horse Racing' tab in the Results Summary Spreadsheet (v3)</td></tr></tbody></table><p></p><div><br /></div>Many thanks to all the current purchasers of the <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">Results Summary</a> spreadsheet! It would be great to hear more from traders and gamblers who've used it to improve their profits.<br /><br />For me, I was <a href="http://betfairtradingmindgames.blogspot.com/2009/06/part-2-of-ending-your-pre-race-trading.html" target="_blank">haemorrhaging money </a>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.<br /><br /><a name='more'></a><br />It's also invaluable to be able to compare profitability across all the sports you trade. Sometimes when there was a big tournament on, for example, snooker or darts and they clashed with racing I wasn't sure if it was worth my while to trade them - but now I do! I can see that my average return on snooker is way higher than racing - so I give snooker preference when it's on. It's not that I have made more in total on snooker than racing - but on the days it's on, it's more profitable for me to trade it than the horses - and it's a nice change of pace too! For you it may be tennis for example, it doesn't matter, you can see all the sports you trade compared in the Results Summary spreadsheet. You can even compare year-on-year results to see if you did better on this year's tournament than the last ones!<br /><br />How much is it worth to you to find out a way of radically reducing your losses and increasing your profits? £5? £1000? Well the spreadsheet doesn't cost that much!<br /><br /><div>Get the <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">Results Summary spreadsheet here</a></div>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com0tag:blogger.com,1999:blog-6634548863347354947.post-68635036547277270272020-12-04T16:23:00.027+00:002022-05-13T11:45:18.451+01:00Results Summary Spreadsheet v3 is here!<p><b><span style="font-size: medium;">Easily track and analyse your Betfair and Betdaq exchange trading and betting</span></b></p><p>View your P&L performance over the lifetime of your accounts, find trends, find your best - and worst - market types and shape your future decisions.</p><p>Your lifetime results presented in an easy to understand format just one click away.</p><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl64ZyHAYC6Is9BH6DVkj0RABUq8aheVa9EUmOicPRTWKE3TyLnTezhykI4k6LSx-699fnb1MArnxhkteyegguIqW5tBoSSk7US0cxdZtDmqjEeU3UgMwqgUqxBRD97kESgGnso0ZRGE7f/s1462/Summary+tab.jpg" style="margin-left: auto; margin-right: auto; text-align: center;"><img border="0" data-original-height="1036" data-original-width="1462" height="454" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl64ZyHAYC6Is9BH6DVkj0RABUq8aheVa9EUmOicPRTWKE3TyLnTezhykI4k6LSx-699fnb1MArnxhkteyegguIqW5tBoSSk7US0cxdZtDmqjEeU3UgMwqgUqxBRD97kESgGnso0ZRGE7f/w640-h454/Summary+tab.jpg" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><b>'Summary'</b> tab (v.3.3.5 showing daily markets count)</td></tr></tbody></table><p></p>See the video <a href="https://youtu.be/-s18wYJyXBI" target="_blank">here</a>.<div><br /><span style="text-align: right;"><u><b>'Summary' tab</b></u></span><p></p><p><span style="text-align: right;">The heart of the spreadsheet. </span></p><p><b style="text-align: right;">See and understand your Betfair and Betdaq profit & loss data</b><span style="text-align: right;"><b> like never before</b>:</span></p><p></p><ul style="text-align: left;"><li><span style="text-align: right;">At a glance your all-time P&L with charts throughout the spreadsheet revealing trends</span></li><li><span style="text-align: right;">See your all-time P&L by <b>month, week, date, day of week, time of day</b></span></li><li><b>Drill-down</b> on any date to see more details by:</li><ul><li><b>Sport</b></li><li><b>Racecourse / track / team </b>(depending on the sport)</li><li><b>Market type</b></li></ul><li>New modern design. New 'hide' button which removes all controls from view to give even more screen space for your results analysis</li></ul><p><b style="text-decoration-line: underline;">New in v3</b> (upgraders from v2 see <a href="https://betfairtradingmindgames.blogspot.com/2020/10/results-summary-spreadsheet-v3-is-now.html">this post</a>)</p><ul style="text-align: left;"><li><b>Football</b>. <span style="font-family: inherit;">See your results</span> by:</li><ul><li>Match / Team</li><li>Market type, e.g. Match odds, over/under, tournament betting</li><li>Click on match or market type to see market information</li></ul></ul><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIZZI5rVLhtS8j0W1UbLcnxZn1t8wl7lkER1e_alCutb3d9ErTgU4d18en78Zg11ILQCf9VV2Y0hQWfwWwv91R99bbiD0p4BTDbh-2MdG21eWdPN-zo9Ac0dXC0nWFD23_2dU7S6J2Sxu8/s1576/Football.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="810" data-original-width="1576" height="321" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIZZI5rVLhtS8j0W1UbLcnxZn1t8wl7lkER1e_alCutb3d9ErTgU4d18en78Zg11ILQCf9VV2Y0hQWfwWwv91R99bbiD0p4BTDbh-2MdG21eWdPN-zo9Ac0dXC0nWFD23_2dU7S6J2Sxu8/w626-h321/Football.jpg" width="626" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'<b>Football</b>' tab</td></tr></tbody></table><b><br /></b><ul style="text-align: left;"><li><b style="text-align: right;">Horse Racing:</b></li><ul><li><span style="text-align: right;">Race type</span></li><li><span style="text-align: right;">Distance (in furlongs)</span></li><li><span style="text-align: right;"><b>New third table showing results by racecourse</b> which can be sorted by P&L or racecourse.</span></li><li><span style="text-align: right;">Click on race type or distance or racecourse to see market level information</span></li><li style="text-align: left;"><span style="text-align: center;">Horse racing split by jumps, flat, place market. Can be toggled to show total for all horse racing</span></li><li style="text-align: left;"><span style="text-align: center;">Foreign racetracks now include the country code with the course name</span></li></ul></ul><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL5RiSKIiZrZgbm_yyAn4xS5pVKLy8wk5oMiMglbkp1I3TD6nKBjF1389MptBNJocnbQvljEORdV7Nnf_2oSRtDOSeeF9KYjbzwY3KbRnYnQq4rElEI-66ZLrfavgfoICgMQxqYPKeCxoz/s2528/Horse+racing.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1243" data-original-width="2528" height="309" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL5RiSKIiZrZgbm_yyAn4xS5pVKLy8wk5oMiMglbkp1I3TD6nKBjF1389MptBNJocnbQvljEORdV7Nnf_2oSRtDOSeeF9KYjbzwY3KbRnYnQq4rElEI-66ZLrfavgfoICgMQxqYPKeCxoz/w629-h309/Horse+racing.jpg" width="629" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'<b>Horse Racing</b>' tab</td></tr></tbody></table><br /><ul style="text-align: left;"><li>'<b>My Sport</b>' user definable tab:</li><ul><li>This is a new concept in the spreadsheet for a dedicated user-definable sports tab</li><li>Are you a big <b>Tennis, Darts, Cricket or MMA</b> fan? Done! </li><li>You can even analyse Special Bets such as the X-Factor!</li></ul></ul><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi0A8v_qR70LGHzyD_5Mcb8YO-dhWoNPAa12hhx7BIaSpHymzkEGw41c7SVALoRb4tkbWePEDwIhps7e_Yujr97J2xvy2gThJq_2yUW53KJSw0bh5p3G6R6dD1UbjEw7bDUyB0a1cMhHz5/s2048/My+Sport+-+Snooker.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1180" data-original-width="2048" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi0A8v_qR70LGHzyD_5Mcb8YO-dhWoNPAa12hhx7BIaSpHymzkEGw41c7SVALoRb4tkbWePEDwIhps7e_Yujr97J2xvy2gThJq_2yUW53KJSw0bh5p3G6R6dD1UbjEw7bDUyB0a1cMhHz5/w627-h360/My+Sport+-+Snooker.jpg" width="627" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'<b>My Sport</b>' tab (Snooker selected)</td></tr></tbody></table><b><br /></b><ul style="text-align: left;"><li><b>Greyhound racing</b>. See your results by:</li><ul><li>Race grade (e.g. A1, A2, S1, OR etc)</li><li>Distance (in metres)</li><li>Track</li><li>Click on race grade or distance or track to see market level information</li><li>Foreign tracks include the country code with the track name</li></ul></ul><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv_UM1BUB8Ki1VZ6zKQXlnCR003wAUg1QnVtSFFmW7Aqx7TnokonRWP5BKNvtUVmsN7neDwd6_d9sDZ2cIF-hL170JEmDCH9mKuUvyCg0XDOSNQaGoLCg1eKP0jrtOgiJwmUlanlv7K3xw/s3088/Greyhound+racing.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1019" data-original-width="3088" height="208" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv_UM1BUB8Ki1VZ6zKQXlnCR003wAUg1QnVtSFFmW7Aqx7TnokonRWP5BKNvtUVmsN7neDwd6_d9sDZ2cIF-hL170JEmDCH9mKuUvyCg0XDOSNQaGoLCg1eKP0jrtOgiJwmUlanlv7K3xw/w628-h208/Greyhound+racing.jpg" width="628" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'<b>Greyhound' </b>tab</td></tr></tbody></table><p><b><u><br /></u></b></p><p><b><u>Further analysis for ALL sports</u></b></p><span style="text-align: center;"><ul><li style="text-align: left;"><span style="text-align: center;">'</span><b style="text-align: center;">Total by Sport</b><span style="text-align: center;">' tab. See your results by:</span></li><ul><li style="text-align: left;"><span style="text-align: center;">Sub-total by <b>every sport</b> you have results for in a chart and accompanying table</span></li><li style="text-align: left;"><span style="text-align: center;">Horse racing split by jumps, flat, place market. Can be toggled to show total for all horse racing</span></li><li style="text-align: left;"><span style="text-align: center;">Monthly total broken down by each sport</span></li></ul></ul></span><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBY6To9dDLowEKLpbGlYiDkHg8jTdGkba-g1Tn-spwE5KZnuUMPe8NS9NYGWHpm2VLtRSupe6oxAT27D0EkRQzkPqUH34x8h4pTtrMXasIT5LJqaqLczxzkfauH_ja3fWS1GDehbdI4Rsi/s1143/Total+by+sport.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1032" data-original-width="1143" height="561" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBY6To9dDLowEKLpbGlYiDkHg8jTdGkba-g1Tn-spwE5KZnuUMPe8NS9NYGWHpm2VLtRSupe6oxAT27D0EkRQzkPqUH34x8h4pTtrMXasIT5LJqaqLczxzkfauH_ja3fWS1GDehbdI4Rsi/w621-h561/Total+by+sport.jpg" width="621" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'<b>Total by sport</b>' tab</td></tr></tbody></table><div><br /></div><div><ul style="text-align: left;"><li>'<b>Running totals</b>' tab:</li><ul><li>Your P&L running total split out by sport</li><li><b>Timescale can be easily filtered</b> to current year, current quarter, last quarter etc.</li><li><b>Sports can be easily filtered </b>to only your results you are interested in, or all</li><li style="text-align: left;"><span style="text-align: center;">Horse racing split by jumps, flat, place market. Can be toggled to show total for all horse racing</span></li></ul></ul></div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieotN1cosdeGw2Yw4FPuxDMRQtLJMaKh9VRl-dZPYzaOal9m2hrm2LZbtRh6eyqOYN7HQpAPTE7kBz14BCIR-MfqhWtMsxz-TOwgGJ2X2PDcgttUVeGuSdTxt3gNecYunUZky23d1u-lQB/s2048/Running+totals.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1434" data-original-width="2048" height="438" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieotN1cosdeGw2Yw4FPuxDMRQtLJMaKh9VRl-dZPYzaOal9m2hrm2LZbtRh6eyqOYN7HQpAPTE7kBz14BCIR-MfqhWtMsxz-TOwgGJ2X2PDcgttUVeGuSdTxt3gNecYunUZky23d1u-lQB/w626-h438/Running+totals.jpg" width="626" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'<b>Running totals</b>' tab</td></tr></tbody></table><div><br /></div><div><ul style="text-align: left;"><li>'<b>Graphs</b>' tab:</li><ul><li>P&L running total for all sports (as per the 'Summary' tab graph, just larger)</li><li>Average profit by market vs average loss by market each day. See <a href="https://betfairtradingmindgames.blogspot.com/2009/06/part-2-of-ending-your-pre-race-trading.html" target="_blank">this post</a> for more about how this is useful.</li><li>Daily strike rate across markets</li><li><b>Timescale can be easily filtered </b>to current year, current quarter, any range of dates</li></ul></ul></div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglUY1hQJIWyFa5HewTBSCrYeIppBFr6peWwrK4v_gYeUDpskz2EaWTXl4pFZ-0QF8Dem_rn3lgS9JgVtC2psVb-8jdsWyyK1vMtBrEfkivrfcz-A38PSJe1iy8BbdKvnlyORwrIRsS0uXy/s2040/Graphs.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1899" data-original-width="2040" height="581" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglUY1hQJIWyFa5HewTBSCrYeIppBFr6peWwrK4v_gYeUDpskz2EaWTXl4pFZ-0QF8Dem_rn3lgS9JgVtC2psVb-8jdsWyyK1vMtBrEfkivrfcz-A38PSJe1iy8BbdKvnlyORwrIRsS0uXy/w624-h581/Graphs.jpg" width="624" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'<b>Graphs</b>' tab</td></tr></tbody></table><br /><ul style="text-align: left;"><li>'<b>Month comparison</b>' tab</li><ul><li>P&L running total comparison by month</li><li><b>Timescale can be easily filtered</b> to current year, last year, etc.</li></ul></ul><div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKE5tqkQXsYQeX3-_gnhTCvn9kWkYn6kW9jHvm919Jp3CbMOntlmQQhf6e9vj-tkHc54gQgb8tPpK_CnUMnnVrfUSnPpL4Y9EWrdm9mUdw1zu3JosUC2xp8PSI9L0dS-HkC1xCHE3NFZ-R/s2040/Month+comparison.jpg" style="margin-left: auto; margin-right: auto; text-align: center;"><img border="0" data-original-height="1452" data-original-width="2040" height="444" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKE5tqkQXsYQeX3-_gnhTCvn9kWkYn6kW9jHvm919Jp3CbMOntlmQQhf6e9vj-tkHc54gQgb8tPpK_CnUMnnVrfUSnPpL4Y9EWrdm9mUdw1zu3JosUC2xp8PSI9L0dS-HkC1xCHE3NFZ-R/w623-h444/Month+comparison.jpg" width="623" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'<b>Month comparison</b>' tab (showing past three months only)</td></tr></tbody></table></div><div><br /></div><p><b><u>How to use your P&L analysis information</u></b></p><p>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.</p><div>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? </div><div><br /><b><u>How does it work?</u></b></div><div><b><u><br /></u></b></div><div>Download your Betfair 'BettingPandL' file or Betdaq P&L file then <b>simply click 'Import'. Simples!</b></div><div><br /></div>New conversion spreadsheet allows you to import the Betfair Customer Report / Statement with your <b>entire lifetime</b> 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 <a href="https://betfairtradingmindgames.blogspot.com/2021/12/betfair-customer-report-conversion.html" target="_blank">this post</a> for more info.<div><div><u><br /></u></div><div><u>General</u></div><div><ul><li><b>Keep your P&L results private </b>- <b>NO uploading</b> your results to someone else's website</li><li><b>Fully compatible</b> with Betfair altered file format of 'BettingPandL' (changed in summer 2020)</li><li><b>OneDrive</b>: Keep your data backed up in your OneDrive, now supported in v3</li><ul></ul></ul><u>Betdaq P&L</u><ul><li>Horse racing markets automatically separated from other sports (where Betdaq state the racecourse in the P&L file)</li><li>Horse racing summaries by win, place and each-way market results</li><li>Racecourse totals (where available)</li></ul><ul></ul><div><u>YouTube Videos</u></div><div><ul><li>Subscribe to the <a href="https://www.youtube.com/channel/UC59PvqXMWLlq-rz5Oa4_e1A" target="_blank">Mind Games YouTube channel</a> and get notified immediately when I upload new videos</li><li>'<a href="https://youtu.be/-s18wYJyXBI" target="_blank">Results Summary Spreadsheet v3 and the two main advantages it gives you</a>' video</li><li>Getting started with '<a href="https://youtu.be/rkudqkctzwI" target="_blank">importing your data</a>'</li><li><a href="http://betfairtradingmindgames.blogspot.co.uk/2013/06/unlocking-secrets-of-your-p-data-by.html" target="_blank">More advanced analysis</a> video</li></ul></div><div><br /></div></div></div><div><b>All the best with your trading!</b></div><div><br /><div style="text-align: center;">_______________________________________</div><div style="text-align: center;"><br /></div><div style="text-align: center;"><br /><div><span style="font-size: medium;"><b>Click on the 'BUY NOW' button for an instant download of the spreadsheet</b></span></div><div><span style="color: #38761d;">See below for software requirements</span><br /><b style="color: #0b5394;"><span style="font-size: large;">Only £9.</span><span style="font-size: medium;">97</span></b><br /><span style="color: #0b5394;">(How quickly will you make that back?)</span></div><div class="separator" style="clear: both; color: black;"><a href="https://www.e-junkie.com/ecom/gb.php?&c=cart&ejc=2&cl=162630&i=914894" target=""><img alt="Buy Now" border="0" height="121" src="https://www.e-junkie.com/ej/x-click-butcc.gif" width="200" /></a></div><div class="separator" style="clear: both; color: black;"><a href="https://www.e-junkie.com/ecom/gb.php?c=cart&ejc=2&cl=162630">View cart</a></div><div class="separator" style="clear: both; color: black;"><br /></div><div class="separator" style="clear: both; color: black;"><b style="font-size: large;"><u>No PayPal account necessary for purchase</u></b></div><div class="separator" style="clear: both; color: black;"><div class="separator" style="clear: both;"><a href="https://www.e-junkie.com/ecom/gb.php?i=914894&c=single&cl=162630" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" data-original-height="802" data-original-width="829" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdDNhKsFx6jDIclphpfM301WtFFO5gb45vioOzJza1F6xDj76qxRcxiJLOIe4kRxoKR-zSslhJnkNXb8agfh9Y9c1JRZBjP36gPHIa7cG2lKt4y2kCyacUn4_v7CqDwG6JcdujtTSW0jl_/s320/temp.png" width="320" /></a></div><div><span style="color: #0b5394;">Your card statement will show 'BTMG' as the merchant.</span></div><div><span style="color: #0b5394;">PayPal do not disclose your street address for this download-only purchase.</span></div></div><div style="color: black;"><div><br /></div><div><span style="text-align: left;">New conversion spreadsheet (available separately) allows you to import the Betfair Customer Report</span> with all your betting history (for those with more than 3 months of betting history).</div><div><div><span style="font-size: small;">For more information on this check out</span><span style="font-size: small;"> <a href="https://betfairtradingmindgames.blogspot.com/2021/12/betfair-customer-report-conversion.html" target="_blank">this post</a>.</span></div><div><span style="font-size: small;"><br /></span></div><div><span style="color: #0b5394;">Price includes free access to future updates e.g. v3.3 to v3.4 etc</span></div><div><span style="color: #0b5394;">(upgrades apply to new versions e.g. v2 to v3)</span></div></div><span style="color: #cc0000; font-size: x-small;"> </span></div><div style="color: black;"><span style="color: #cc0000; font-size: x-small;"><span face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" style="background-color: white; color: #333333; font-size: 14.85px; text-align: left;">v2 Purchasers should </span><a href="https://betfairtradingmindgames.blogspot.com/2020/10/results-summary-spreadsheet-v3-is-now.html" style="background-color: white; color: #6699cc; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-align: left; text-decoration-line: none;">check out this post</a><span face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" style="background-color: white; color: #333333; font-size: 14.85px; text-align: left;"> for a special upgrade discount!</span></span></div><table align="center" border="0" cellpadding="10" cellspacing="0" style="color: #0b5394;"><tbody><tr style="color: #0b5394;"><td align="center"><u style="color: black;"><b>Requires Excel 2007 or newer for Windows</b></u><b> </b><br /><span style="color: #38761d;">Please check the detailed <b>software requirements</b> below for use of this spreadsheet before buying.</span></td></tr></tbody></table><table align="center" border="0" cellpadding="10" cellspacing="0" style="color: #0b5394;"><tbody><tr></tr></tbody></table></div><div style="text-align: center;">_______________________________________</div><div><br /><span style="color: #38761d;"><b>Software requirements </b><span>(not included!):</span></span></div><div><span style="color: #38761d;"><span><u><b>Excel 2007* or newer for Windows</b></u>. Tested on XP, Vista, Windows 7, Windows 8 (see note below about Windows 7 and 8) and Windows 10. </span><br /><br /><span>Works on Excel 365 for Windows.</span></span></div><div><span><span style="color: #38761d;"><br /></span></span></div><div></div><div><span style="color: #38761d;"><u><b>WILL NOT work on </b>Excel 2003 and older, Open Office or <b>Excel for Macintosh.</b></u></span></div><div><span style="color: #38761d;"><b><u><br /></u></b></span></div><div><span style="color: #38761d;"><b>*Excel 2007 users </b>- please email me AFTER your purchase for an additional file you will need.<br /><br /><br /><b><u>International users</u></b> 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 <b>Windows 10</b> click on the Windows button and type 'Currency' and click on 'Change the way currency is displayed'. In <b>Windows 7 & 8</b> go to Windows start button > Control Panel > Regional and Language Options > Formats (tab) - Current format and set to "English - United Kingdom". See this post <a href="http://betfairtradingmindgames.blogspot.co.uk/2012/02/using-your-language-and-currency-format.html">Using your Language and Currency format</a><br /><br /><u><b>Windows 7 & 8</b></u>: There is a security scan in <b>Windows 7 & 8</b> 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". <u>Please download a Betfair P&L file and make sure you can open it</u> before purchasing the 'Results Summary' spreadsheet. If you are using Windows 7 / 8 you <i>can </i>open the Betfair P&L using <a href="http://www.openoffice.org/">Open Office (free software)</a> - 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 <a href="http://social.msdn.microsoft.com/Forums/is/exceldev/thread/69434b37-a3ed-4970-a929-89e03ee01aaf">http://social.msdn.microsoft.com/Forums/is/exceldev/thread/69434b37-a3ed-4970-a929-89e03ee01aaf</a><br /><br /><u><b>Windows 10:</b></u> 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!</span><br /><br />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.<br /><br />All rights are reserved by the author.</div><div><br /><div style="text-align: center;"><b>All the best with your trading!</b></div><div style="text-align: center;"><b>Mind Games</b></div></div></div><div style="text-align: center;"><b><br /></b></div><div style="text-align: center;"><div class="separator" style="clear: both; font-weight: bold; text-align: center;"><a href="https://www.e-junkie.com/ecom/gb.php?&c=cart&ejc=2&cl=162630&i=914894" style="margin-left: 1em; margin-right: 1em;" target=""><img alt="" data-original-height="44" data-original-width="73" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2SkHaZGs8Jrx24H63WBExyftIbYyXLyIjpuSgl1uwzl3y1_9OV6hKNTmg-O_MvIYELqw185TnSNHew6ncvWnslHgySVjXCEV8c1mb1fsUaqModGkmKScutXhdTTQeUwnd9Em8LIv0SIli/w200-h121/image.png" width="200" /></a></div><a href="https://www.e-junkie.com/ecom/gb.php?c=cart&ejc=2&cl=162630">View cart</a><br /><b><br /></b></div><div style="text-align: center;"><b>Check out the blog comments for Results Summary v2 <a href="https://betfairtradingmindgames.blogspot.com/2016/08/results-summary-v2-spreadsheet-is-here.html#comment-form" target="_blank">here</a></b></div></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br />Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com37tag:blogger.com,1999:blog-6634548863347354947.post-55284652620683712502020-10-29T15:38:00.030+00:002022-01-03T23:33:39.280+00:00Results Summary Spreadsheet v3 is now available!<p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://betfairtradingmindgames.blogspot.com/2016/08/results-summary-v2-spreadsheet-is-here.html" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="240" data-original-width="290" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKELI0hU5LXLWG-5t7NvvHjfNKSA28zD8VNNlbCE9E3wDiofxGwHDb6j4rKq5A9WHZ_WDLShNTbhEZvZOr1hpYN5IH213CQr_a-VaIDYEIjkxthdQdXzPZA74HzZZ7gmnrW2ESaC5qU46R/" width="290" /></a></div><br />The new version of Results Summary Spreadsheet (v3) has just been released! It can be purchased using the <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html"><b>link on this post</b></a>.<p></p><p>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.</p><p><u>If you are a <b>prior purchaser</b> of v2 Results Summary Spreadsheet</u> </p><p>There is a <b>special offer </b>for all prior v2 purchasers upgrading - <b>50% off</b> the full price!</p><p>To apply the discount you will need your <b>unique </b>discount code. Your unique discount code <b>can only be used once</b>. </p><p>Your unique discount code is based on the email address you used when <u>making your original purchase</u>.</p><p>The discount code doesn't accept special characters only <u>letters </u>and <u>numbers</u>. So an example of a discount code is:</p><p>An example email: </p><p>Joe_Bloggs.420@BigMarketSwinger.com</p><p>Your example unique discount code would be:</p><p>JoeBloggs420BigMarketSwingercom</p><p>The code is not case sensitive so joebloggs420bigmarketswingercom would work in this example (but don't bother trying it out for real!).</p><p><u>How to make the discounted purchase:</u></p><p></p><ul style="text-align: left;"><li>Click 'ADD TO CART' blue button:</li></ul><p></p>
<a class="ec_ejc_thkbx" href="https://www.e-junkie.com/ecom/gb.php?&c=cart&ejc=2&cl=162630&i=914894" onclick="return EJEJC_lc(this);" style="background-attachment: initial; background-clip: initial; background-color: #3da5d9; background-origin: initial; background-position: 50% 50%; background-repeat: no-repeat; background-size: 100px; background: #3da5d9 url(https://www.e-junkie.com/ej/images/newaddtocart.png) center/100px no-repeat; border-radius: 3px; border: none; box-shadow: rgba(0, 0, 0, 0.2) 1px 2px 2px; display: inline-block; padding: 7px 55px; text-decoration: none;" target="ej_ejc"> </a>
<a class="ec_ejc_thkbx" href="https://www.e-junkie.com/ecom/gb.php?c=cart&ejc=2&cl=162630" onclick="return EJEJC_lc(this);" style="background-attachment: initial; background-clip: initial; background-color: #3da5d9; background-origin: initial; background-position: 50% 50%; background-repeat: no-repeat; background-size: 90px; background: #3da5d9 url(https://www.e-junkie.com/ej/images/newviewcart.png) center/90px no-repeat; border-radius: 3px; border: none; box-shadow: rgba(0, 0, 0, 0.2) 1px 2px 2px; cursor: pointer; display: inline-block; padding: 7px 55px; text-decoration: none;" target="ej_ejc"> </a> <div><br /></div><div><ul style="text-align: left;"><li>then click 'ADD PROMO CODE' on the new screen (example screenshot below): </li></ul><div><div><p></p><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDDUz9ouj_D15sn_u2CThJTZ437e2BlTo4RnJ23BoShB5gROUnz1wsNL9EDNuk_5A6zRtnmg4OkswiHvsEewojT2ujCiZi_rFBW-JGlLyxqC-0x8f5I92DSHgSKbtg_Y7MDuwtUBD6hQYl/s1368/Screenshot+2021-06-16+094103.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="475" data-original-width="1368" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDDUz9ouj_D15sn_u2CThJTZ437e2BlTo4RnJ23BoShB5gROUnz1wsNL9EDNuk_5A6zRtnmg4OkswiHvsEewojT2ujCiZi_rFBW-JGlLyxqC-0x8f5I92DSHgSKbtg_Y7MDuwtUBD6hQYl/w640-h222/Screenshot+2021-06-16+094103.jpg" width="640" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;"><span face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" style="background-color: white; color: #333333; font-size: 11.88px; text-align: left;">Click the 'ADD PROMO CODE' button:</span></td></tr></tbody></table><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><ul><li style="text-align: left;">After entering your discount code click 'APPLY' </li><li style="text-align: left;"><u>Check that the code has been accepted and the discounted price is correct</u></li><li style="text-align: left;">Click 'Pay Using PayPal'. You do not need a PayPal account to pay by debit / credit card.</li></ul></div><div class="separator" style="clear: both; text-align: center;"><span style="text-align: left;">After downloading Results Summary Spreadsheet v3, please use the '</span><b style="text-align: left;">Import records from previous version'</b><span style="text-align: left;"> button and select your old spreadsheet file and all of your data will be transferred into the new spreadsheet. Simples!</span></div><p>New conversion spreadsheet allows you to import the Betfair Customer Report / Statement with your <b>entire lifetime</b> 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 <a href="https://betfairtradingmindgames.blogspot.com/2021/12/betfair-customer-report-conversion.html" target="_blank">this post</a> for more info.</p><p>Or check out this video on getting started with v3 Results Summary spreadsheet:</p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="417" src="https://www.youtube.com/embed/rkudqkctzwI" width="502" youtube-src-id="rkudqkctzwI"></iframe></div>
</div></div></div>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com2tag:blogger.com,1999:blog-6634548863347354947.post-44627925361995350252016-08-20T17:19:00.003+01:002020-12-05T12:37:40.233+00:00Excel 2016 / 365 is compatible with Results Summary spreadsheet!Just a quick note to say that Results Summary Spreadsheet is compatible with Excel 2016 (the latest subscription version that is part of Office 365). Excel running on Windows 10 is also compatible. For more details about the software requirements, please see the <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">Results Summary post</a>!Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com0tag:blogger.com,1999:blog-6634548863347354947.post-31715938979182840932016-08-19T15:07:00.021+01:002021-12-23T11:50:04.003+00:00Results Summary Spreadsheet v2 (old version)<div style="text-align: center;"><b><span style="font-family: inherit; font-size: medium;">'Results Summary' v3 spreadsheet is ready for download! </span></b></div><div style="text-align: center;"><b><span style="font-family: inherit; font-size: medium;"><br /></span></b></div><div><div style="text-align: center;"><b><span style="font-family: inherit; font-size: medium;">Please <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">CLICK HERE</a> to see the post all about the new v3</span></b></div><div style="text-align: center;"><b><span style="font-size: medium;"><br /></span></b></div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih6k2QaLnAXiKxYtBY-TBXJgiKBu6Uz20G8g7zok-tswLUSJRMzZ5TOYZF3ZXVFW-Ez4F3vyhGXvWhHPSJm1YtT-Tkyz_e7at8qcteFKYpRVGwme3_UCge8X2BPLiWtiZNJrF8OVbzCs7u/s1447/Summary+tab.jpg" style="margin-left: auto; margin-right: auto;"><img border="0" data-original-height="1036" data-original-width="1447" height="437" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih6k2QaLnAXiKxYtBY-TBXJgiKBu6Uz20G8g7zok-tswLUSJRMzZ5TOYZF3ZXVFW-Ez4F3vyhGXvWhHPSJm1YtT-Tkyz_e7at8qcteFKYpRVGwme3_UCge8X2BPLiWtiZNJrF8OVbzCs7u/w611-h437/Summary+tab.jpg" width="611" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">'<b>Summary</b>' tab (v3 spreadsheet)</td></tr></tbody></table><br /><div>If you're already chomping at the bit:</div><div>
<div style="text-align: right;"><br /></div><div style="color: #0b5394; text-align: center;"><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; text-align: start;"><div style="text-align: center;"><div style="font-size: 14.85px;"><span style="font-size: medium;"><b>Click on the 'BUY NOW' button for an instant download of the spreadsheet</b></span></div><div style="font-size: 14.85px;"><span style="color: #38761d;">See below for software requirements</span><br /><b style="color: #0b5394;"><span style="font-size: large;">Only £9.</span><span style="font-size: medium;">97</span></b><br /><span style="color: #0b5394;">(How quickly will you make that back?)</span></div><div class="separator" style="clear: both; color: black; font-size: 14.85px;"><div class="separator" style="clear: both; font-family: "Times New Roman"; font-size: medium;"><a href="https://www.e-junkie.com/ecom/gb.php?&c=cart&ejc=2&cl=162630&i=914894" target=""><img alt="Buy Now" border="0" height="121" src="https://www.e-junkie.com/ej/x-click-butcc.gif" width="200" /></a></div><div class="separator" style="clear: both; font-family: "Times New Roman"; font-size: medium;"><a href="https://www.e-junkie.com/ecom/gb.php?c=cart&ejc=2&cl=162630">View cart</a></div></div><div class="separator" style="clear: both; color: black; font-size: 14.85px;"><br /></div><div class="separator" style="clear: both; color: black; font-size: 14.85px;"><b style="font-size: large;"><u>No PayPal account necessary for purchase</u></b></div><div class="separator" style="clear: both; color: black; font-size: 14.85px;"><div class="separator" style="clear: both;"><a href="https://www.e-junkie.com/ecom/gb.php?i=914894&c=single&cl=162630" style="color: #6699cc; margin-left: 1em; margin-right: 1em; text-decoration-line: none;"><img border="0" data-original-height="802" data-original-width="829" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdDNhKsFx6jDIclphpfM301WtFFO5gb45vioOzJza1F6xDj76qxRcxiJLOIe4kRxoKR-zSslhJnkNXb8agfh9Y9c1JRZBjP36gPHIa7cG2lKt4y2kCyacUn4_v7CqDwG6JcdujtTSW0jl_/s320/temp.png" style="border: none; position: relative;" width="320" /></a></div><div><span style="color: #0b5394;">Your card statement will show 'BTMG' as the merchant.</span></div><div><span style="color: #0b5394;">PayPal do not disclose your street address for this download-only purchase.</span></div></div><div style="color: black;"><div style="font-size: 14.85px;"><br /></div><div><div style="font-family: "Times New Roman";"><div><div><span style="text-align: left;">New conversion spreadsheet (available separately) allows you to import the Betfair Customer Report</span> with all your betting history (for those with more than 3 months of betting history).</div><div><span>For more information on this check out</span><span> <a href="https://betfairtradingmindgames.blogspot.com/2021/12/betfair-customer-report-conversion.html" target="_blank">this post</a>.</span></div></div><div style="font-size: medium;"><span face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" style="color: #0b5394; font-size: 14.85px;"><br /></span></div><div style="font-size: medium;"><span face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" style="color: #0b5394; font-size: 14.85px;">Price includes free access to future updates e.g. v3.3 to v3.4 etc</span></div></div></div><div style="font-size: 14.85px;"><div><span style="color: #0b5394;">(upgrades apply to new versions e.g. v2 to v3)</span></div></div><div style="font-size: 14.85px;"><span style="color: #0b5394;"><br /></span></div><div style="font-size: 14.85px;"><span style="color: #0b5394;"><span style="color: #333333; text-align: left;">v2 Purchasers should </span><a href="https://betfairtradingmindgames.blogspot.com/2020/10/results-summary-spreadsheet-v3-is-now.html" style="color: #6699cc; text-align: left; text-decoration-line: none;">check out this post</a><span style="color: #333333; text-align: left;"> for a special upgrade discount!</span></span></div><span style="color: #cc0000; font-size: x-small;"> </span></div><table align="center" border="0" cellpadding="10" cellspacing="0" style="color: #0b5394; font-size: 14.85px;"><tbody><tr><td align="center"><u style="color: black;"><b>Requires Excel 2007 or newer for Windows</b></u><b> </b><br /><span style="color: #38761d;">Please check the detailed <b>software requirements</b> below for use of this spreadsheet before buying.</span></td></tr></tbody></table><table align="center" border="0" cellpadding="10" cellspacing="0" style="color: #0b5394; font-size: 14.85px;"><tbody><tr></tr></tbody></table></div><div style="font-size: 14.85px; text-align: center;">_______________________________________</div><div style="font-size: 14.85px;"><br /><span style="color: #38761d;"><b>Software requirements </b>(not included!):</span></div><div style="color: black; font-family: "Times New Roman";"><span style="color: #38761d;"><span><u><b>Excel 2007* or newer for Windows</b></u>. Tested on XP, Vista, Windows 7, Windows 8 (see note below about Windows 7 and 8) and Windows 10. </span><br /><br /><span>Works on Excel 365 for Windows.</span></span></div><div style="color: black; font-family: "Times New Roman";"><span><span style="color: #38761d;"><br /></span></span></div><div style="color: black; font-family: "Times New Roman";"></div><div style="color: black; font-family: "Times New Roman";"><span style="color: #38761d;"><u><b>WILL NOT work on </b>Excel 2003 and older, Open Office or <b>Excel for Macintosh.</b></u></span></div><div style="color: black; font-family: "Times New Roman";"><span style="color: #38761d;"><b><u><br /></u></b></span></div><div style="color: black; font-family: "Times New Roman";"><span style="color: #38761d;"><b>*Excel 2007 users </b>- please email me AFTER your purchase for an additional file you will need.<br /><br /><br /></span></div><div style="font-size: 14.85px;"><b style="color: #38761d;"><u>International users</u></b><span style="color: #38761d;"> 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 </span><b style="color: #38761d;">Windows 10</b><span style="color: #38761d;"> click on the Windows button and type 'Currency' and click on 'Change the way currency is displayed'. In </span><b style="color: #38761d;">Windows 7 & 8</b><span style="color: #38761d;"> go to Windows start button > Control Panel > Regional and Language Options > Formats (tab) - Current format and set to "English - United Kingdom". See this post </span><a href="http://betfairtradingmindgames.blogspot.co.uk/2012/02/using-your-language-and-currency-format.html" style="color: #6699cc; text-decoration-line: none;">Using your Language and Currency format</a></div><div style="font-size: 14.85px;"><span style="color: #38761d;"><br /><u><b>Windows 7 & 8</b></u>: There is a security scan in <b>Windows 7 & 8</b> 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". <u>Please download a Betfair P&L file and make sure you can open it</u> before purchasing the 'Results Summary' spreadsheet. If you are using Windows 7 / 8 you <i>can </i>open the Betfair P&L using <a href="http://www.openoffice.org/" style="color: #6699cc; text-decoration-line: none;">Open Office (free software)</a> - 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 <a href="http://social.msdn.microsoft.com/Forums/is/exceldev/thread/69434b37-a3ed-4970-a929-89e03ee01aaf" style="color: #6699cc; text-decoration-line: none;">http://social.msdn.microsoft.com/Forums/is/exceldev/thread/69434b37-a3ed-4970-a929-89e03ee01aaf</a><br /><br /><u><b>Windows 10:</b></u> 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!</span><br /><br />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.</div><div style="font-size: 14.85px;"><br />All rights are reserved by the author.</div><div style="font-size: 14.85px;"><br /><div style="text-align: center;"><b>All the best with your trading!</b></div><div style="text-align: center;"><b>Mind Games</b></div></div></div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><b><br /></b></div><div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px;"><b><div class="separator" style="clear: both;"><div class="separator" style="clear: both; color: black; font-family: "Times New Roman"; font-size: medium; font-weight: 400;"><a href="https://www.e-junkie.com/ecom/gb.php?&c=cart&ejc=2&cl=162630&i=914894" target=""><img alt="Buy Now" border="0" height="121" src="https://www.e-junkie.com/ej/x-click-butcc.gif" width="200" /></a></div><div class="separator" style="clear: both; color: black; font-family: "Times New Roman"; font-size: medium; font-weight: 400;"><a href="https://www.e-junkie.com/ecom/gb.php?c=cart&ejc=2&cl=162630">View cart</a></div></div></b></div></div>
<script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-22536193-1']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script></div></div>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com38tag:blogger.com,1999:blog-6634548863347354947.post-2663870176266848812014-08-14T14:21:00.027+01:002021-12-20T12:55:47.938+00:00Affiliate programme - earn 40% commission!<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: black; font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;">Join the Results Summary Spreadsheet affiliate
programme and <b>earn 40% of the sales price in commission</b> for all sales
you bring to the blog! </span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: black; font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;">I'm looking for supporters of the spreadsheet who
can promote it on their sites or by spreading the word in <u>an ethical
way</u> (i.e. no spamming).</span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: black; font-family: "Georgia",serif; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;"><span style="font-size: large;"><b>Post your links once and get paid again and again into the future......</b></span></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #3d85c6; font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;"><b><span>If you have a blog, </span><span>YouTube </span><span>channel, twitter, Facebook, Instagram account then you can earn commission just by posting your affiliate link and recommending the spreadsheet by saying why you find it useful.</span></b></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #3d85c6;"><b><span style="font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;">There is a big opportunity as the conversion rate
of blog visitors into sales is unusually high, but </span><span style="font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;">traffic is much lower than
it should be.<span style="mso-spacerun: yes;"> </span>I think this is a win-win
opportunity for us all.</span></b></span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: black; font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;">You can </span><span style="color: black; font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;">monitor sales you've generated in real-time
with your own account on the download service provider e-junkie.com - this is an independent 3rd party administrator of all sales. Your
commission is paid monthly to your PayPal account on the first working day of the month for the previous month's affiliate share.</span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: black; font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;"><br /></span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"></p><ul style="text-align: left;"><li><span style="color: #3d85c6; font-family: Georgia, serif;">Find out more about your e-junkie affiliate account
here: </span></li></ul><p></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #6aa84f;"><a href="https://www.e-junkie.com/wiki/help-for-affiliates" style="font-family: Georgia, serif;" target="_blank"><span> </span><span> </span><span> </span>https://www.e-junkie.com/wiki/help-for-affiliates</a></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #6aa84f;"><span style="font-family: Georgia, serif;"><br /></span></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"></p><ul style="text-align: left;"><li><span style="color: #3d85c6; font-family: Georgia, serif;">Setup your account here: </span></li></ul><p></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #6aa84f;"><a href="https://www.e-junkie.com/affiliates/?cl=162630&ev=f2a27dd16d" style="font-family: Georgia, serif;" target="_blank"><span> </span><span> </span><span> </span>https://www.e-junkie.com/affiliates/?cl=162630&ev=f2a27dd16d</a></span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #6aa84f;"><span style="font-family: Georgia, serif;"><br /></span></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"></p><ul style="text-align: left;"><li><span style="color: #3d85c6; font-family: Georgia, serif;">Email me with any questions </span></li></ul><p></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #6aa84f;"><a href="mailto:betfairtradingmindgames@yahoo.co.uk" style="font-family: Georgia, serif;" target="_blank"><span> </span><span> </span><span> </span>betfairtradingmindgames@yahoo.co.uk</a></span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: black; font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;"><o:p> </o:p></span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #999999; font-family: "Georgia",serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;"><b><u>T&C's</u></b></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #999999;"><span style="font-family: Georgia, serif;"><b>Common sense rules apply.</b></span><span style="font-family: Georgia, serif; mso-spacerun: yes;"> I want to operate this as a good win-win experience for affiliates and myself and to promote the spreadsheet in a positive light.</span></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #999999;"><span style="font-family: Georgia, serif;">Just in case, I reserve the right to close any
affiliate accounts with immediate effect (and will not enter into any correspondence
/ dispute) where the user has promoted the spreadsheet in a defamatory manner
such as spamming forums. </span><span style="font-family: Georgia, serif;"> </span></span></p><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;"><span style="color: #999999; font-family: Georgia, serif;">In particular:</span></p><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px;"><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; text-align: left;"><span style="color: #999999;"><span style="font-family: Georgia, serif;"><u>D</u><u>on't post any affiliate link on the Bet Angel forum. No commission will be paid for links posted on forum.betangel.com.</u> </span> </span></p></blockquote><blockquote style="border: none; margin: 0px 0px 0px 40px; padding: 0px;"><p class="MsoNormal" style="line-height: normal; margin-bottom: 0cm; text-align: left;"><span style="color: #999999; font-family: Georgia, serif;">In the event of account closure by either the affiliate or myself, any sales share will of course still be distributed to the affiliate - <u>with the exception of any sales referred from the Bet Angel forum which will not be paid out</u>.</span></p></blockquote>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com0tag:blogger.com,1999:blog-6634548863347354947.post-67571848812989638392013-06-23T14:58:00.004+01:002021-12-08T09:54:59.595+00:00Unlocking the secrets of your P&L data by customising Results SummaryAn email from a purchaser of Results Summary spreadshee asked to be able to analyse their P&L by course in the "Horse racing - type & distance" tab in a similar way that it works for race type and distance. Rather than just adding another table to do this I thought it would be more powerful to show all purchasers how to customise and manipulate their spreadsheet in even more ways.<div><br /></div><div>Note: Horse racing P&L shown by racecourse is now built-in to v3 of the spreadsheet, please <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">see this post</a>. </div><div><br /></div><div>The method shown below can still be used if you have other requirements for analysing your data.</div><div><br />
This means you can set up your P&L results to display exactly how you want, and as before, <b>you keep your P&L results private </b>- there is NO uploading your results to someone else's website. <br />
<br />
I hope that this is quite a revelation for those who want to look at their results from new angles and perhaps inspire new strategies.<br />
<br />
<b>Please make a backup of your spreadsheet before you try any of the techniques in the video!</b> You've been warned! For instance, if the "Market type" field is moved up from the bottom of the hierachy you will get an error message (Run-time '1004') when pressing the "Collapse all drill downs" button. So it's best if you copy over a fresh version of the table first (as shown near the end of video "part 2").<br />
<br />
Whilst I hope you enjoy this please note that I can't be giving free tech support for Excel related questions.<i><b> Please </b></i>leave a comment if you have found this useful.<br />
<br />
<u>Video part 1 of 2 (older v2 spreadsheet)</u><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/wqKMUaVCWbQ/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/wqKMUaVCWbQ?feature=player_embedded" width="320"></iframe></div>
<br />
<u>Video part 2 of 2</u><u> (older v2 spreadsheet)</u><br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/0TOSit4MONo/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/0TOSit4MONo?feature=player_embedded" width="320"></iframe></div>
<br />
<br /></div>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com7tag:blogger.com,1999:blog-6634548863347354947.post-10306381489264855332012-02-04T12:36:00.004+00:002020-12-09T18:35:06.127+00:00Using your Language and Currency format in Results Summary spreadsheetSome international purchasers of the Results Summary spreadsheet have asked me how they can display their results with their country's currency symbol instead of "£".<br />
<br />
<div class="separator" style="clear: both; text-align: center;">Here's a video to show you how (click on the YouTube logo to open it in full-screen):</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="407" src="https://www.youtube.com/embed/IXUhgLrOnzw" width="489" youtube-src-id="IXUhgLrOnzw"></iframe></div><div style="text-align: center;">Video shows <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">Results Summary Spreadsheet v3</a></div><div class="separator" style="clear: both; text-align: center;"><span style="text-align: left;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><span style="text-align: left;">Firstly, </span><b style="text-align: left;">before </b><span style="text-align: left;">you launch Excel (make sure you don't have any other spreadsheets you use open either):</span></div>
<div style="text-align: left;"><br /></div>
<span class="phrase"><span class="ui">1. In Windows 10 click on the Windows button and type 'Currency' and click on 'Change the way currency is displayed'. In Windows 7 & 8 click on Start</span> button <img alt="Picture of the Start button" class="embedObject" data-id="pageContainer0_ID0E1C" height="15" src="https://res2.windows.microsoft.com/resbox/en/Windows%20Vista/main/4f6cbd09-148c-4dd8-b1f2-48f232a2fd33_47.png" title="Picture of the Start button" width="15" /> > <span class="ui">Control Panel</span> ><span class="ui"></span> <span class="ui">Regional and Language Options</span> > Formats (tab) > Current Format > <b>English (United Kingdom). Then click "Apply".</b></span><br />
<span class="phrase">(It seems to be significant to select UK because the spreadsheet was originally created under these settings).</span><br />
<span class="phrase"><b> </b></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUz-Clo6aUyZAr0woFCdOZXASkT-VSxMFVHzYgcTBKTxdIbJ_A1qlLoDM94C_23BXmh56zKZtam87BRvx5ZeYIj8z5yGLtxdelacNYf6BdIQWJ1xbASt4mxhcRnc8AoGS93nO5VnhturvT/s1600/English+regional+settings+-+Copy.gif" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUz-Clo6aUyZAr0woFCdOZXASkT-VSxMFVHzYgcTBKTxdIbJ_A1qlLoDM94C_23BXmh56zKZtam87BRvx5ZeYIj8z5yGLtxdelacNYf6BdIQWJ1xbASt4mxhcRnc8AoGS93nO5VnhturvT/s320/English+regional+settings+-+Copy.gif" width="279" /></a></div>
<span class="phrase"><b> </b></span><br />
<span class="phrase"><b> </b></span><br />
<span class="phrase">2. Launch your copy of Results Summary spreadsheet</span><br />
<span class="phrase">3. </span><span class="phrase"><span class="ui">Start</span> button <img alt="Picture of the Start button" class="embedObject" data-id="pageContainer0_ID0E1C" height="15" src="https://res2.windows.microsoft.com/resbox/en/Windows%20Vista/main/4f6cbd09-148c-4dd8-b1f2-48f232a2fd33_47.png" title="Picture of the Start button" width="15" /> > <span class="ui">Control Panel</span> ><span class="ui"></span> <span class="ui">Regional and Language Options</span> > Formats (tab) > Current Format ><i> your language / country. </i><b>Then click "Apply".</b><i><br /></i></span><br />
<br />
<span class="phrase">That's it!</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><br /></div>
<span class="phrase"><i> </i></span>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com0tag:blogger.com,1999:blog-6634548863347354947.post-68595781437555349032011-08-29T12:29:00.041+01:002021-12-08T10:57:32.729+00:00Betfair lifetime results - how to make sense of them<div>2021 update: The post below from 10 years ago refers to the old 'Lifetime conversion' spreadsheet which worked with the previous report that betfair used to provide. It appears that betfair will not be providing the 'Lifetime' report going forwards.</div><div><br /></div><div>Betfair have recently been providing customers with the 'Betfair Customer Report' or 'Statement' for their betting history. This has two major problems compared to the original report. See <a href="https://betfairtradingmindgames.blogspot.com/2021/12/betfair-customer-report-conversion.html">this post</a> for more info and the new solution - ‘<a href="https://betfairtradingmindgames.blogspot.com/2021/12/betfair-customer-report-conversion.html">Betfair Customer Report’ conversion spreadsheet</a>. The original 'lifetime' conversion spreadsheet is also included in the bundle - in case betfair revert to the original report format!</div><div><br /></div><div>_________________________________________________________________</div><div><br /></div><div>Whilst Betfair offer up to 3 months of Betting Profit and Loss data download from "My Account" area on their website, if you require any more than that, then you need to contact the helpdesk at info@betfair.com or by <a href="http://www.betfair.com/aboutUs/Contact.Us/">phone</a>. They will provide a report of the entire "lifetime" P&L of your account. I received mine in about 4 hours - and my account has been active for 10 years! It's probably a good idea to contact them in the morning though to get such a quick response.<div><br />
However, I was surprised to learn that Betfair will not provide this "lifetime" P&L report in the same format as the one you can download from your account area. Confusingly, they don't seem to have a standard format either, as Mets & I initially got reports in totally different formats and level of detail. The key is to be specific what you ask them for (more on this below).<br />
<br />
The good news is that I have developed a spreadsheet to convert the lifetime report into an identical format as the standard P&L report. The standard format means that you can then import your lifetime P&L into the Results Summary spreadsheet (as well as any other compatible system you may have, if you want). Of course, going forwards, all your results are stored safely in the Results Summary spreadsheet and you won't need to ask for them from Betfair again - so long as you download your P&L at least once every 3 months. <b> </b><br />
<br />
As all your data is downloaded to your computer, you <b>keep your P&L results private </b>- there is NO uploading to an anonymous 3rd party website.<br />
<br />So - what format do you need to get your lifetime report in? Here's what the headings looked like on mine (just one row of data is showing):<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;"><tbody><tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuzt1J1-pBHSMXRWqhkEcfSUrat35ASzG5MXEOOBg_LY_EvuwI25LfngY9rdshlgp5kBsaHJbYWaUUsPnY4CRBxbBejgoCs6ZeKvVkoi72mmRc7A0BqggvDKXKMvnsmWuvG-P5SjIQJkJN/s1600/Username+lifetime+report.gif" style="margin-left: auto; margin-right: auto;"><img border="0" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuzt1J1-pBHSMXRWqhkEcfSUrat35ASzG5MXEOOBg_LY_EvuwI25LfngY9rdshlgp5kBsaHJbYWaUUsPnY4CRBxbBejgoCs6ZeKvVkoi72mmRc7A0BqggvDKXKMvnsmWuvG-P5SjIQJkJN/w618-h142/Username+lifetime+report.gif" width="618" /></a></td></tr><tr><td class="tr-caption" style="text-align: center;">Report from Betfair showing results across the account lifetime</td></tr></tbody></table><div class="separator" style="clear: both; text-align: center;">
</div>
<br /><div>The key points are that:</div><div>
<ol>
<li>The report must be at event level (i.e. total profit for a market, not each individual bet you placed on the market).</li>
<li>It <b>must </b>have the following columns: "Event settled date", "Sport", "Event menu hint", "Event name - long", "Net p&l". Any additional columns do not cause a problem, they are ignored. The column order of the report doesn't matter.</li>
</ol>
When you contact Betfair you could just copy and paste the above criteria into your email, maybe even include the screenshot. <br />
<br />
It's really simple to use the conversions spreadsheet, here's what it looks like:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgw13EG_w2TVjorBeRNR9f8Q5bkihiGRHUg97Y5scgO8iRg7jc3F0h3WuLnhKqsLOJNQVD-JGcb43msTvS7xlO80re3NjGGv3RrtDw4JQZzdKvjLEablbLMVJKXQOKCkhtewOiwFv89WgyM/s1600/Convert+Betfair+Lifetime+report+-+screenshot.gif" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="302" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgw13EG_w2TVjorBeRNR9f8Q5bkihiGRHUg97Y5scgO8iRg7jc3F0h3WuLnhKqsLOJNQVD-JGcb43msTvS7xlO80re3NjGGv3RrtDw4JQZzdKvjLEablbLMVJKXQOKCkhtewOiwFv89WgyM/s400/Convert+Betfair+Lifetime+report+-+screenshot.gif" width="400" /></a></div>
<br />
You can buy the Results Summary spreadsheet <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">here</a>.<br />
<br />
If, like me, you've had results in the past that you'd <a href="http://betfairtradingmindgames.blogspot.com/2009/06/part-2-of-ending-your-pre-race-trading.html">rather forget about</a> (!), it needn't be all bad. This experience has actually been useful for me to also remember all the profitable periods I've achieved over the lifetime of my account. I tended to only remember the bad ones! I've actually found it quite positive to know for sure which areas I've won at over time and to have continuing confidence with those whilst reminding myself why I'm avoiding others.<br />
<br />
I hope you find this useful too. Cheers!</div></div></div>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com5tag:blogger.com,1999:blog-6634548863347354947.post-11216172978998401942011-08-03T16:27:00.004+01:002020-10-29T14:50:51.867+00:00New videosHi, just to let you know that I've posted a couple more videos for the Results Summary spreadsheet. One is on the more advanced filtering and sorting you can do and the other shows the data export feature.<br />
<br />
The Results Summary spreadsheet processes your P&amp;L into meaningful summaries without any need for you to have any Excel programming knowledge. So you can easily see where your trading &amp; gambling is going right and, *cough*, needs improvement!<br />
<br />
If you have any questions, please either leave a comment or email me (address on the profile page). <br />
<br />
Check out the videos by clicking the "Videos - Startup" tab at the top of the blog or just click <a href="http://betfairtradingmindgames.blogspot.com/2011/04/videos-overview-of-results-summary-v2.html">here</a>. Cheers!<br />
<br />
<a href="http://betfairtradingmindgames.blogspot.co.uk/2013/06/unlocking-secrets-of-your-p-data-by.html"> Click here for Advanced data analysis videos!!! </a>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com2tag:blogger.com,1999:blog-6634548863347354947.post-62350153929526086662011-04-05T17:13:00.029+01:002021-12-23T11:51:13.654+00:00Videos - Overview of Results Summary plus Getting Started and virtual 'Unboxing'!I've recorded the first couple of videos to show features and benefits of the Results Summary spreadsheet - hopefully more useful to see what's going on this way than ploughing through huge blog posts!<br />
<br />
There's a quick overview of all the screens so you get a flavour for what the spreadsheet can do for you, or if you're ready to get started then click on the 'Buy Now' button below (please check the 'Software requirements' section first).<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="415" src="https://www.youtube.com/embed/-s18wYJyXBI" width="499" youtube-src-id="-s18wYJyXBI"></iframe></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;">Here's how you get started with the spreadsheet and importing your Betfair 'BettingPandL' file (click on YouTube logo to view fullscreen):</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="419" src="https://www.youtube.com/embed/rkudqkctzwI" width="504" youtube-src-id="rkudqkctzwI"></iframe></div><div style="text-align: center;">Getting Started and Virtual 'Unboxing' v3 Results Summary Spreadsheet</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div>
To view a playlist of several videos exploring the spreadsheet <a href="https://www.youtube.com/playlist?list=PLWXZ1jemn92Jgjl_YiHlQbAbc-kdGa-qo" target="_blank">click here.</a><br />
<br />
If you'd like to read more about the Results Summary Spreadsheet features check out <a href="https://betfairtradingmindgames.blogspot.com/2020/12/results-summary-spreadsheet-v3-is-here.html">this post</a>.<br />
<br />
There are additional videos showing each screen in more detail and talking about the benefits of having all these different views on your P&L data.<br />
<br />
I hope you find them useful!<div><br /><div style="text-align: left;"><div><div style="text-align: center;">_______________________________________</div><div style="text-align: center;"><br /></div><div style="text-align: center;"><br /><div><div><div><span style="font-size: medium;"><b>Click on the 'BUY NOW' button for an instant download of the spreadsheet</b></span></div><div><span style="color: #38761d;">See below for software requirements</span><br /><b style="color: #0b5394;"><span style="font-size: large;">Only £9.</span><span style="font-size: medium;">97</span></b><br /><span style="color: #0b5394;">(How quickly will you make that back?)</span></div><div class="separator" style="clear: both;"><a href="https://www.e-junkie.com/ecom/gb.php?&c=cart&ejc=2&cl=162630&i=914894" target=""><img alt="Buy Now" border="0" height="121" src="https://www.e-junkie.com/ej/x-click-butcc.gif" width="200" /></a></div><div class="separator" style="clear: both;"><a href="https://www.e-junkie.com/ecom/gb.php?c=cart&ejc=2&cl=162630">View cart</a></div><div class="separator" style="clear: both;"><br /></div><div class="separator" style="clear: both;"><b style="font-size: large;"><u>No PayPal account necessary for purchase</u></b></div><div class="separator" style="clear: both;"><div class="separator" style="clear: both;"><a href="https://www.e-junkie.com/ecom/gb.php?i=914894&c=single&cl=162630" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" data-original-height="802" data-original-width="829" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdDNhKsFx6jDIclphpfM301WtFFO5gb45vioOzJza1F6xDj76qxRcxiJLOIe4kRxoKR-zSslhJnkNXb8agfh9Y9c1JRZBjP36gPHIa7cG2lKt4y2kCyacUn4_v7CqDwG6JcdujtTSW0jl_/s320/temp.png" width="320" /></a></div><div><span style="color: #0b5394;">Your card statement will show 'BTMG' as the merchant.</span></div><div><span style="color: #0b5394;">PayPal do not disclose your street address for this download-only purchase.</span></div></div><div><div><br /></div><div><span style="text-align: left;">New conversion spreadsheet (available separately) allows you to import the Betfair Customer Report</span> with all your betting history (for those with more than 3 months of betting history).</div><div><div><span style="font-size: small;">For more information on this check out</span><span style="font-size: small;"> <a href="https://betfairtradingmindgames.blogspot.com/2021/12/betfair-customer-report-conversion.html" target="_blank">this post</a>.</span></div><div><span style="font-size: small;"><br /></span></div><div><span style="color: #0b5394;">Price includes free access to future updates e.g. v3.3 to v3.4 etc</span></div><div><span style="color: #0b5394;">(upgrades apply to new versions e.g. v2 to v3)</span></div></div><span style="color: #cc0000; font-size: x-small;"> </span></div><div><span style="color: #cc0000; font-size: x-small;"><span face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" style="background-color: white; color: #333333; font-size: 14.85px; text-align: left;">v2 Purchasers should </span><a href="https://betfairtradingmindgames.blogspot.com/2020/10/results-summary-spreadsheet-v3-is-now.html" style="background-color: white; color: #6699cc; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14.85px; text-align: left; text-decoration-line: none;">check out this post</a><span face="Arial, Tahoma, Helvetica, FreeSans, sans-serif" style="background-color: white; color: #333333; font-size: 14.85px; text-align: left;"> for a special upgrade discount!</span></span></div><table align="center" border="0" cellpadding="10" cellspacing="0" style="color: #0b5394;"><tbody><tr><td align="center"><u style="color: black;"><b>Requires Excel 2007 or newer for Windows</b></u><b> </b><br /><span style="color: #38761d;">Please check the detailed <b>software requirements</b> below for use of this spreadsheet before buying.</span></td></tr></tbody></table><table align="center" border="0" cellpadding="10" cellspacing="0" style="color: #0b5394;"><tbody><tr></tr></tbody></table></div><div>_______________________________________</div><div style="text-align: left;"><br /><span style="color: #38761d;"><b>Software requirements </b><span>(not included!):</span></span></div><div style="text-align: left;"><span style="color: #38761d;"><span><u><b>Excel 2007* or newer for Windows</b></u>. Tested on XP, Vista, Windows 7, Windows 8 (see note below about Windows 7 and 8) and Windows 10. </span><br /><br /><span>Works on Excel 365 for Windows.</span></span></div><div style="text-align: left;"><span><span style="color: #38761d;"><br /></span></span></div><div style="text-align: left;"></div><div style="text-align: left;"><span style="color: #38761d;"><u><b>WILL NOT work on </b>Excel 2003 and older, Open Office or <b>Excel for Macintosh.</b></u></span></div><div style="text-align: left;"><span style="color: #38761d;"><b><u><br /></u></b></span></div><div style="text-align: left;"><span style="color: #38761d;"><b>*Excel 2007 users </b>- please email me AFTER your purchase for an additional file you will need.<br /><br /><br /></span></div><div style="text-align: left;"><b style="color: #38761d;"><u>International users</u></b><span style="color: #38761d;"> 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 </span><b style="color: #38761d;">Windows 10</b><span style="color: #38761d;"> click on the Windows button and type 'Currency' and click on 'Change the way currency is displayed'. In </span><b style="color: #38761d;">Windows 7 & 8</b><span style="color: #38761d;"> go to Windows start button > Control Panel > Regional and Language Options > Formats (tab) - Current format and set to "English - United Kingdom". See this post </span><a href="http://betfairtradingmindgames.blogspot.co.uk/2012/02/using-your-language-and-currency-format.html">Using your Language and Currency format</a></div><div style="text-align: left;"><span style="color: #38761d;"><br /><u><b>Windows 7 & 8</b></u>: There is a security scan in <b>Windows 7 & 8</b> 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". <u>Please download a Betfair P&L file and make sure you can open it</u> before purchasing the 'Results Summary' spreadsheet. If you are using Windows 7 / 8 you <i>can </i>open the Betfair P&L using <a href="http://www.openoffice.org/">Open Office (free software)</a> - 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 <a href="http://social.msdn.microsoft.com/Forums/is/exceldev/thread/69434b37-a3ed-4970-a929-89e03ee01aaf">http://social.msdn.microsoft.com/Forums/is/exceldev/thread/69434b37-a3ed-4970-a929-89e03ee01aaf</a><br /><br /><u><b>Windows 10:</b></u> 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!</span><br /><br />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.<br /><br />All rights are reserved by the author.</div></div><div style="text-align: left;"><br /></div></div><div><div style="text-align: center;"><b>All the best with your trading!</b></div><div style="text-align: center;"><b>Mind Games</b></div></div></div><div style="text-align: center;"><b><br /></b></div><div style="text-align: center;"><b><div class="separator" style="clear: both;"><div class="separator" style="clear: both; font-weight: 400;"><a href="https://www.e-junkie.com/ecom/gb.php?&c=cart&ejc=2&cl=162630&i=914894" target=""><img alt="Buy Now" border="0" height="121" src="https://www.e-junkie.com/ej/x-click-butcc.gif" width="200" /></a></div><div class="separator" style="clear: both; font-weight: 400;"><a href="https://www.e-junkie.com/ecom/gb.php?c=cart&ejc=2&cl=162630">View cart</a></div></div><br /></b></div>
</div>
<script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-22536193-1']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script></div>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com3tag:blogger.com,1999:blog-6634548863347354947.post-10502945375999615682010-10-13T10:39:00.000+01:002020-07-28T11:59:03.617+01:00Money and Emotions<div style="text-align: right;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXgCR4Fob3maxwrJLSilIGkubQHoKGPadtiUAmcVM62fA3ZYUPMZqBdRXQBzxDetMnYu9FNU_fLwWTNtbvvj5tniyD8FcPQIDy7CI_MXzBEKfD0-IozAPS8NzeqHJShpebItP7r7hrQm-M/s1600/Untitled.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXgCR4Fob3maxwrJLSilIGkubQHoKGPadtiUAmcVM62fA3ZYUPMZqBdRXQBzxDetMnYu9FNU_fLwWTNtbvvj5tniyD8FcPQIDy7CI_MXzBEKfD0-IozAPS8NzeqHJShpebItP7r7hrQm-M/s1600/Untitled.jpg" /></a><span style="font-size: xx-small;">(image copyright The Open University 2010) </span></div>
<br />
I've been enjoying a little look around the "iTunes U" online university and found some podcasts from The Open University and in particular thought this one had some relevance: <a href="https://podcasts.apple.com/gb/podcast/money-and-emotions/id393832734" target="_blank">Money and Emotions</a><br />
<br />
They are looking at how emotions affect financial decisions and as well as discussion from the people carrying out the research they interview a few city traders including a Forex trader. It's interesting to hear from the Forex trader that he feels a lot more comfortable with his positions when they're going the right way rather than against him. It doesn't sound much different to someone sitting in hope watching their Betfair trades!<br />
<br />
As is all too often the case when it comes to successful trading, the piece doesn't offer any solutions, but there are some surprising points. For example, one observation they made from their analysis is that contrary to popular belief, people largely devoid of emotion but with all their logical reasoning in tact were <i>not</i> better at making financial decisions. Furthermore, one of the traders' managers at a bank felt that outbursts of emotion such as banging the desk / throwing the phone etc was helpful! Her reasoning was that she felt they need to let off steam and can subsequently make better decisions if they've got it out of their system.<br />
<br />
Personally, when I've "had a moment" I have frequently gone on to have a winning day, but very often at the (potential) cost of taking far greater risk. So, yes, sometimes I've just made things worse. What I have noticed though is that I've made several of my most profitable trades in this mindset. Trading is inherently risky but, particularly when I'm happy with the way things are going, I naturally start becoming more cautious - and hence limit my potential profitability. I guess the ideal balance is to remove the fear of taking a reasonable amount of risk whilst not needing to get steamed-up to do so!<br />
<br />
Has anyone found any other research into this topic which may be useful?Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com6tag:blogger.com,1999:blog-6634548863347354947.post-47890847816815187002010-08-13T10:30:00.003+01:002020-07-28T12:00:30.761+01:00Automated tradingI've been lacking any inspiration to write new posts for some time but a kind comment asking me to get on with it has prompted action!<br />
<br />
A good part of the reason for having no trading-related ideas for posts is because I've been spending all of the day outside of racing working on automated (Excel) trading spreadsheets. It really is a joy to have your criteria systematically executed without loss of concentration and emotional distraction. One of the things that frustrates me when I'm having a really good day trading (manually) is that I tail-off rapidly, I just don't have the killer instinct to keep on hammering the markets when I'm well up on the day. However, with an automated strategy, the spreadsheet shows no mercy! It's really something to have 3 great winners at the end of an evening's racing whilst you're out having a beer. Of course it doesn't always happen like that at all but you get the idea........<br />
<br />
For anyone struggling with "mind games" in their trading I would highly recommend them considering investing some time looking into ways of writing automated betting spreadsheets. If your trading is going nowhere then at least investing time into this will progress you in other ways even if your system turns out to be unprofitable in the long run, for instance, you learn a new skill - i.e. Excel and programming principles, which could be useful for your job. Also it makes you think about the reasons for making trades and what might be the best conditions for entering / exiting trades which could perhaps help in your manual trading.<br />
<br />
So far as I'm aware <a href="http://www.gruss-software.co.uk/default.asp?" target="_blank">Gruss Betting Assistant</a> and <a href="http://www.betangel.com/" target="_blank">Bet Angel</a> are the only two trading applications that offer Excel linking. I have used both extensively but have used Gruss exclusively for well over a year. Back then its Excel functionality was well ahead although since I think Bet Angel has closed the gap somewhat and added some alternative features. The support on Gruss is just so superb I wouldn't go elsewhere though.<br />
<br />
The <a href="http://www.gruss-software.co.uk/forum/" target="_blank">Gruss forum</a>, which non-subscribers can join, has loads of discussion about Excel trading ideas and technical help (search for keywords or look in the Discussion, Suggestions and Help sections) as well as a dedicated section for requesting professional help from Excel developers, including getting them to write all the code for you.<br />
<br />
As well as implementing automated betting using the standard Excel interface, you can code much more sophisticated strategies using the built-in Excel programming language called VBA (Visual Basic for Applications I think it stands for). One post that gives you the basic framework of code for the start and end of your own code can be found <a href="http://www.gruss-software.co.uk/forum/viewtopic.php?t=5132" target="_blank">here</a>.<br />
<br />
You will be amazed how often people on the forum will assist you and maybe even write whole chunks of code for you (for free) - often what might seem complicated to someone who has never written an automated sheet before is really straight-forward to someone experienced (and has probably been thought of and written by many people before you!). It's a great way to learn how to write the spreadsheet code - you can start by just tweaking an existing one to fit your criteria - that way you don't have to give away your idea for alchemy!<br />
<br />
I was thinking about writing some posts about specific coding techniques and examples but am not really sure that is what my blog is about so haven't got around to it so far. Lets see if anyone's interested.<br />
<br />
All the best with your trading!Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com5tag:blogger.com,1999:blog-6634548863347354947.post-47029118170651303232010-06-04T08:09:00.008+01:002020-07-28T12:01:16.052+01:00Recreating your moment of triumph (or otherwise!)Last year I realised the benefits of recording my screen whilst trading prerace <a href="http://betfairtradingmindgames.blogspot.com/2009/07/video-your-trading-with-screen.html">http://betfairtradingmindgames.blogspot.com/2009/07/video-your-trading-with-screen.html</a><br />
<br />
Now I have realised the possibility to watch back my trades on in-running markets in sync with the race replay (archived races are now free on the RUK website as well as ATR, no need to pay 20p to the Racing Post). It's great to be able to review and replay the betfair odds alongside the action - it's a lot cheaper than learning about the behaviour of the in-running markets by sticking some money in and hoping for the best!<br />
<br />
I bought a second monitor for my laptop last year which has been worth every penny. I use it as the main monitor for trading and use the smaller laptop screen for ancillary information such as graphs and the bets manager. However this is also great for replaying videos as I can have my trading screen recreated on my main monitor in full-screen mode and have the race replay on my laptop also in full-screen. It took me a while to work out that on the ATR replays, if you double-click the replay it jumps to full-screen mode - doh!<br />
<br />
For anyone looking for a new monitor now, my top tip for what it's worth, is to consider the <span style="font-style: italic;">resolution</span> of the monitor as more important than the <span style="font-style: italic;">size</span> of the screen. My 19" monitor has a higher resolution (i.e. shows more information) than many of the common resolutions for 21" and 23" screens. And it fits better on my desk!<br />
<br />
When I first started dabbling with the in-running markets, it was quite amusing watching the replays - it was a bit like being at a pantomime where the audience is trying to warn of impending danger - "HE'S BEHIND YOU!!!!!" - I would be shouting at the screen, "NO, don't back that horse now, he's done for!". It's funny how the heat of the moment can make you see things very differently. Watching replays with the betfair market "live" can help you become more accustomed to what can and does happen.<br />
<br />
Of course, nothing beats real experience and putting real money into the market, but at the very least it can be a useful tool to get up to speed before starting the day, or when returning from a holiday. Sometimes after a break I feel quite disconnected from the markets before starting the day. Often this goes quickly, but watching some videos of my trading first helps get me back in the swing of things.<br />
<br />
For some reason my laptop clock drifts a few seconds between the weekly checks with internet time. <a href="http://www.howtogeek.com/howto/windows-vista/dealing-with-windows-vista-time-sync-problems/" target="_blank">This article</a> shows you how to set Vista to automatically check every day. This means that you can accurately sync playback of your video (looking at your countdown timer recorded on your screen video) to the clock in-picture on the ATR/RUK race replay.<br />
<br />
Whilst I haven't posted for some time the number of people reading hasn't gone down and it has been enjoyable to have more of a two-way dialogue as I have been replying to helpful and interesting comments from readers, especially regarding the spreadsheets. Thanks to all who commented!Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com6tag:blogger.com,1999:blog-6634548863347354947.post-84167226191394249062010-02-08T11:30:00.000+00:002020-07-28T12:02:58.869+01:00Should Sports Exchange Traders get a "real" job?When I get asked, “what do you do?”, I don’t tend to say, “oh I place an average annual salary on every horse race throughout the day. I don’t even glance at the form beforehand. But it’s really not like gambling”. I tend to mention my part-time businesses or what I used to do.<br />
<br />
When I have mentioned sports exchanges in reply to this oft-asked ice-breaker, I have almost succeeded on occasion to keep the conversation the right side of respectable, but then as soon as I have to mention the word “horses” I can feel a cavern opening beneath my feet taking me back to burn in hell where I belong!<br />
<br />
I have felt this unease from many people and at times from myself. Why is this?<br />
<br />
I think at its simplest, any link with betting on horses has a very negative connotation for the majority of people. When I explained in detail what trading on horses is about to a friend, she pointed out that her father lost a fortune betting on the horses and I suppose this indirect negative experience of gambling is typical.<br />
<br />
When I started dabbling with Betfair trading in 2005 I believed the sales blurb from the software maker that it wasn’t gambling. Now I am sure that it is gambling. But I do believe that trading is a subset of gambling that probably has a higher likelihood of success (albeit still very small).<br />
<br />
When betting, you only need to produce your stake for the next bet, whilst when trading, you are intentionally using far larger amounts of money than you intend to risk. The problem is that if it goes badly wrong, then a form of Parkinson’s Law can rear its ugly head – <span style="font-style: italic;">Losses expand to fill the size of the bank available! </span> Looking at the path I’ve taken in the past 5 years – and losses along the way – surely does mean that trading <span style="font-style: italic;">is</span> gambling and the losses can be horrendous. Just look at how many blogs spring up from traders only to disappear in total bank loss within months or less.<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-BWbPY8Zz19M2YhgAmuVmLwh-5cTOy85q_NZp2MR1_m6jPV-Tfp00qjbFmC7aFDc0ZYSQ8flkwGGHTUZnRcP-3Hk18v6F7d0vuTGCbendOS8DRwnuWxC7UaOmJ5Du8H9_bMhF68QG_Cz5/s1600-h/Google.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5435831724861842386" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-BWbPY8Zz19M2YhgAmuVmLwh-5cTOy85q_NZp2MR1_m6jPV-Tfp00qjbFmC7aFDc0ZYSQ8flkwGGHTUZnRcP-3Hk18v6F7d0vuTGCbendOS8DRwnuWxC7UaOmJ5Du8H9_bMhF68QG_Cz5/s400/Google.jpg" style="cursor: pointer; display: block; height: 287px; margin: 0px auto 10px; text-align: center; width: 400px;" /></a><br />
It is gambling that has the negative connotations, not horseracing per se (but the search suggestions on Google are quite shocking) although obviously the two are inextricably linked. According to the British Horseracing Authority, “Racing remains, by a clear margin, the country’s second biggest sport after the modern commercial and social phenomenon that is football, with core industry expenditure now exceeding £1 billion per annum and a total economic impact of £3.4 billion”. So we’re part of a huge tax-paying industry (£325 million in 2008) with over 100,000 direct and indirect employees. That’s a good thing isn’t it?<br />
<br />
Furthermore, Betfair stated last July that for the financial year 08/09, "<span style="font-style: italic;">Betfair paid £6.16m of the reported £6.2m paid by “exchanges”. We also paid more than 90% of the £1.35m which has been reported as “voluntary levy from offshore operators”. This payment was paid at the full levy rate – 10% of gross profits.</span><span style="font-style: italic;"><br /><br />Our total contribution to the Levy in the period is therefore approximately £7.5m, up 7% from last year.</span><span style="font-style: italic;"><br /><br />............Betfair would like to thank its customers for their continued support which enables us to make significant contributions to British racing.</span>"<br />
<br />
Football doesn’t seem to have the widespread negative connotations about gambling (although I think the same or more may now be gambled on it than horseracing on Betfair). Betfair’s M.D., Mark Davies, states <a href="http://markxdavies.blogspot.com/2010/01/what-would-google-do-and-british.html" target="_blank">on his blog</a>, “80% of Betfair's revenue came from UK horseracing eight years ago, and less than 25% does today”.<br />
<br />
Here's something I've been mulling over for some time. What is gambling? Just betting? What about hedge-funds, Forex traders et al? Is that socially acceptable gambling ? It is after all, gambling. British taxpayers are all the owners of several banks to prove what goes wrong when <span style="font-style: italic;">their </span>bets lose. What do those traders do that is so superior? Why are they "Masters of the Universe" and horseracing traders are something to be frowned on?<br />
<br />
What about the millions of people following a traditional career path who "invest" chunks of their life-savings in shares? My opinion is that they’re gamblers too. In some ways that is quite reckless as it is not their full-time job to research companies properly, albeit that as the stock-market goes up over time then with a portfolio you should be on a winner eventually. But if getting a steady return is the objective then why not stick savings in the bank or government bonds etc? Because, I think, it's a gamble to make more.<br />
<br />
What do you reckon, traders?!<br />
<br />
<br />
<object height="344" width="425"><param name="movie" value="https://www.youtube.com/v/9SVNKHoe-0o&hl=en_GB&fs=1&"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="https://www.youtube.com/v/9SVNKHoe-0o&hl=en_GB&fs=1&" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" height="344" width="425"></embed></object>Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com19tag:blogger.com,1999:blog-6634548863347354947.post-59064797587914422622010-01-08T11:15:00.005+00:002010-01-08T11:40:12.219+00:00Book a free holiday now!If, like me, your trading has been taking a well-earned break due to the abandonment of so many horse racing meetings, then you might want to consider booking a Betfair holiday to prevent your commission discount from reducing.<br /><br />When you book a Betfair holiday (penultimate option on "My Account" page) then you don't get the 15% deduction on Sunday. HOWEVER, you also don't get credited for any points for the week either so you need to make sure the 15% deduction is more than any points you have accrued this week.<br /><br />The other consideration is that you only get 4 "holidays" per year, so if you are lucky enough to swan off on "real" holidays to the Caribbean regularly then you'll have to weigh up the pro's and con's. Chance would be a fine thing!<br /><br />I've been taking the opportunity to have the whole week off, rather than trying to scrape something from 1 or 2 meetings a day. I don't really like such days as the long gaps between races stops me getting into a rhythm and sometimes leads me to increase my risk by trying to milk every tick from every trade - sometimes ending in disaster!<br /><br />Yesterday I started to get worried about how much trading I'll be able to complete this month as the latest forecasts are for the cold spell to continue for up to 2 weeks. Once the cold weather lifts, I expect it could take a while for the racecourses to thaw out too. Hey ho!<br /><br />As a consequence I've been looking at other markets. I looked at the in-play "leg" markets for the World Darts last night and wished I hadn't! The markets are so thin that I got royally screwed. I might lick my wounds and have another pop tonight with a different approach.<br /><br />Also, on Sunday afternoon the Masters Snooker tournament breaks-off. The frame-betting markets do have a higher volume than the leg-betting for darts (not surprising really) but the spreads can still be very wide. Played the right way though this does present some good opportunities.<br /><br />Good luck and may the sun shine soon!Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com0tag:blogger.com,1999:blog-6634548863347354947.post-37210720347205182692009-12-02T17:24:00.010+00:002020-12-04T17:42:51.259+00:00More on the Results Summary spreadsheetIt's great to see the spreadsheet being used by a few people, I'm glad its been of use posting it up. A couple of <span class="blsp-spelling-error" id="SPELLING_ERROR_0">bloggers</span>, that I'm aware of, have posted screenshots of their results using it. You can check them out here: <a href="http://my-betfair-trading-journal.blogspot.com/2009/12/november-review.html"><span class="blsp-spelling-error" id="SPELLING_ERROR_1">JS</span>' <span class="blsp-spelling-error" id="SPELLING_ERROR_2">Betfair</span> Trading Journal</a> & <a href="http://fighttheinnerdemons.blogspot.com/2009/11/november-summary.html">Fight The Inner Demons</a> Good reads both of them.<br />
<br />
I thought I'd mention a couple of things for the people that have downloaded the spreadsheet (a lot more than 2 - let me know if you are finding it useful!) which may help get more out of it.<br />
<br />
The reason that there is no grand total on the table with the daily results is that by selecting any of the columns you can then get total, maximum, minimum, average and count for that data without the grand totals being included and messing it up. To do this put the cursor <i>just</i> above the column header until you get a black downward-pointing arrow, as shown here above the P&L column:<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha7xbFsXVXb0RmCNl7nq0AtS5GsolPl0vfyF7bhomgI_MkgAUCKzWT7Y_cmrpuEGv1flcN02-bsdZzchKq-afdsqVU3fDterjuoM7QkAR9j8E2-0rQee8NxaNglAe6IT7ZlMf0vXoMMfgl/s1600-h/ScreenHunter_03+Dec.+02+17.46+-+Copy.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5410696901768138994" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha7xbFsXVXb0RmCNl7nq0AtS5GsolPl0vfyF7bhomgI_MkgAUCKzWT7Y_cmrpuEGv1flcN02-bsdZzchKq-afdsqVU3fDterjuoM7QkAR9j8E2-0rQee8NxaNglAe6IT7ZlMf0vXoMMfgl/s400/ScreenHunter_03+Dec.+02+17.46+-+Copy.jpg" style="cursor: pointer; display: block; height: 62px; margin: 0px auto 10px; text-align: center; width: 346px;" /></a><br />
Clicking will then select the whole column and the summary figures I mentioned will be displayed along the bottom of the excel window:<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4rJ-SRPyfmjjN9ynV6-n2SKpTqdXS4_BI9-N_WV9lpNFPd28Ey5zAnoWQ9hpl9iOy2cXyDpaOFu6kgTDd8LIjZ3IOu30PUMqwsg_GsXPLNuTFCpwI8ifvkdnEia4ddLBpOQ13zPMI7RTv/s1600-h/ScreenHunter_04+Dec.+02+17.48+-+Copy.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5410697641711288306" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4rJ-SRPyfmjjN9ynV6-n2SKpTqdXS4_BI9-N_WV9lpNFPd28Ey5zAnoWQ9hpl9iOy2cXyDpaOFu6kgTDd8LIjZ3IOu30PUMqwsg_GsXPLNuTFCpwI8ifvkdnEia4ddLBpOQ13zPMI7RTv/s400/ScreenHunter_04+Dec.+02+17.48+-+Copy.jpg" style="cursor: pointer; display: block; height: 31px; margin: 0px auto 10px; text-align: center; width: 400px;" /></a><br />
If you don't get all the summary figures shown here, you can choose which ones you want by right-clicking this bottom part of the Excel window.<br />
<br />
Another thing is the warning message that you get regarding macros every time you open the spreadsheet. You can get avoid this happening in Excel 2007 without lowering your security for other spreadsheets by digitally signing this spreadsheet as your own.<br />
<br />
To do this go to the start menu, select "All programs" find Microsoft Office, then click on the <span class="blsp-spelling-error" id="SPELLING_ERROR_3">sub-folder</span> called Microsoft Office Tools then select "Digital Certificate for <span class="blsp-spelling-error" id="SPELLING_ERROR_4">VBA</span> projects". Give the certificate any name you want, e.g. "Fred's <span class="blsp-spelling-error" id="SPELLING_ERROR_5">supa</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_6">dupa</span> certificate" & click OK. Then open the Results Summary spreadsheet, right-click on the "Summary" tab at the bottom of the Excel window, select "View code". A new window will open and at the top there are several menus. Select "Tools" then "Digital Signature". Under "Sign as" press the "Choose" button and select the certificate you have just named. Click OK x2 and then close the Microsoft Visual Basic window. At this point, save your spreadsheet. The next time you open it you will not be prompted about macros.<br />
<br />
Sorry that got a bit technical, but over the course of months this will save you tens of irritating warning messages!Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com2tag:blogger.com,1999:blog-6634548863347354947.post-33034129076180984382009-11-01T11:02:00.006+00:002009-11-01T11:50:41.909+00:00If you are going through hell, keep goingThere are so many great quotes from Winston Churchill I'm going to abuse a few for my own purposes!<br /><br />Following on from my last post about the personal considerations of going full-time trading <span class="blsp-spelling-error" id="SPELLING_ERROR_0">Betfair</span>, I think the quote in the blog title is very apt. It has taken me years to become successful on <span class="blsp-spelling-error" id="SPELLING_ERROR_1">Betfair</span> and I'd like to think I'm not <span style="font-style: italic;">that</span> thick!<br /><br />In my case, I think winning was only possible once I developed a winning attitude. Maybe that is why some people can become successful way way quicker than I did - they already had a winning attitude.<br /><br />If you are trying your luck at trading <span class="blsp-spelling-error" id="SPELLING_ERROR_2">Betfair</span> for a living because you've just been sacked then it's likely your self-esteem is not at its highest. This wasn't my scenario - I've been self-employed for a long time - but then again I probably became self-employed because I couldn't stand my manager so I wasn't filled with positivity!<br /><br />I got so used to reviewing my losses most days and being really angry about them that on winning days I would feel like I cheated or got lucky (especially if I got out of a losing trade in-running).<br /><br />I'm very happy to say I've just had my best week ever (apart from those freaky gambling wins I've had in the past, I'm talking about trading here). I still sometimes catch myself at the end of a good winning day feeling a bit "empty". It's odd, I think it relates to all the mass of emotion I used to feel after losing days that now things are going well it almost feels like I'm missing something! Maybe in some ways losing made me feel "alive", as perverse as that is. I'm really aware of this now and I consciously do some fun stuff or something constructive (going to the gym, anyone?!) after winning days to make sure I enjoy these winning days.<br /><br />Sometimes winning can seem a bit flat because after all, the money is just spent on living expenses, like a salary would be. I'm sure I got into gambling all those years ago when I was 16 because I wanted disposable income, and lots of it, to lavish on truly hedonistic adventures. Paying the mortgage and buying the groceries just doesn't cut it!<br /><br />This "normalcy" of income from trading is also something I'm trying to get past by winning a lot more! I can't help but compare trading profits with job salaries I've had in the past and it is a real kick to make a weeks wages in a day. I've noticed that many of the (few) very successful traders leave trading after a couple of years or so, so making hay whilst the sun shines is a good idea. Personally I don't think I'll quit that easily - it's been too long and hard a road to get here!<br /><br />Here's another Churchill quote, "Continuous effort - not strength or intelligence - is the key to unlocking our potential". I believe that applies to trading successfully. If you want it, there's no reason why you can't get it, but it may take an awful lot more effort than you expect.<br /><br />Now I've got a trading mindset worth building on I've also been trading some other sports I know a little about - snooker and F1 - and it's been going really well. I'm also looking at spread betting on financial markets. I've never had the capital to invest properly in shares but the margins on financial spread-betting are 5-10% or even less in some cases so it makes it much more accessible with a small bank.<br /><br />Given my sometimes horrendous losses back in the day when I just gambled on horses, I've <span class="blsp-spelling-corrected" id="SPELLING_ERROR_3">consciously</span> avoided spread-betting as I feared it could result in some truly <span class="blsp-spelling-corrected" id="SPELLING_ERROR_4">catastrophic</span> losses. I'm still not going to use it for horses, but for financial markets I think I can put my trading skills - and more importantly, mind-set - developed on <span class="blsp-spelling-error" id="SPELLING_ERROR_5">Betfair</span> to good use. Time-wise it works well with the UK markets being available to trade in the mornings before racing, or what I prefer is to research US stocks and get my orders put in in the morning before their markets open in the afternoon. I'm not day-trading but looking for trades anywhere from 1 week to about 3 months, so I don't need to be panicking about the markets whilst I'm trading the racing.<br /><br />Anyhow, it's time to make the most of my well-earned day-off now, glad to see it's absolutely bucketing down outside. Still, at least I'm not a jockey!Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com0tag:blogger.com,1999:blog-6634548863347354947.post-51346462438668294842009-10-07T12:35:00.003+01:002020-07-28T12:24:15.730+01:00Going full-time trading BetfairWhen I started trading on Betfair I very quickly wanted to go full-time as making a small amount seemed so realistic (little did I know!). Once I'd mastered making small amounts then I reasoned that it'd just be a small matter of whacking up the stakes, and, Bingo! Instant part-time riches!<br />
<br />
Sometimes I do regret being full-time (days I've gone on tilt mainly!) and I didn't consider it properly, but as I have been self-employed for most of the past 15 years it's not so difficult for me and not as cut-and-dried as it is for people quitting their job to trade. There was an excellent post on this written by thebetfairtrader a couple of years ago. He was (is?) a very successful part-time trader who was asked all the time by his blog readers why he didn't go full-time and this was his response:<br />
<a href="http://thebetfairtrader.blogspot.com/2007/02/going-full-time-on-betfair.html" target="_blank">http://thebetfairtrader.blogspot.com/2007/02/going-full-time-on-betfair.html</a><br />
<br />
It's pretty sobering stuff when you're caught-up in the excitement of bringing the gambling gods to their knees!<br />
<br />
One important benefit of trading for me is the additional time you have available over a full-time job which is a real and most precious gift that is rarely achieved by most working people (once you don't need to spend every waking hour working out how to trade successfully!).<br />
<br />
A very significant drawback though is the lack of a real career to build and fall back on and being tied to one gambling website. At the end of the day trading is a zero-sum game and it's important to consider what you want to contribute in your working life.<br />
<br />
Overall I think a better option in these respects would be owning your own business that does not require your presence for more than a few hours a week or so. Then you can spend your afternoons trading! In fact, this kind of business has other benefits as even if you're ill, need time-off, injured etc then you are still making an income. You can also get a mortgage if you still need one. Passive income is unfortunately not one of trading's benefits - you're only as good as your last trade. However, for people reaching the dizzy heights of £350k a year that does still give enough flexibility for plenty of time off and house purchases!Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com2tag:blogger.com,1999:blog-6634548863347354947.post-22962200736641871562009-09-18T12:14:00.003+01:002009-09-18T12:31:34.811+01:00Weekend starts early today!I've done my daily skim through the markets and there are a lot of weak low-volume markets later on this afternoon, so I'll be shutting down the computer and getting ready for the pub early today!<br /><br />At the time of writing, the highest traded markets on betfair are at 2:45 and 4:45 with £77k and £80k respectively. Contrast with the fact there are no races from the 4:50 (£5k) until evening racing that have more than £10k traded, except the 5:25 (£12k). Some of this is probably due to the earlier races in the day attracting slightly more attention early in the day, but not that much. <br /><br />Obviously this makes these weaker markets different to trade - more risky and probably more jumpy. Personally I really like the jumpy volatile markets but it does become more like gambling so I steer clear of the really weak ones. It is much much easier to have a large loss because if the market turns sharply, there will be a lot of traders desperately chasing the same limited money to get out of their trades.<br /><br />These weaker markets tend to be later in the day (and the Irish courses), so don't kick yourself when you always seem to cock-up your P&L and strike rate for the day - maybe just consider avoiding these races.<br /><br />Whilst the 5:25 might have enough volume when it comes to trading time and actually represent a good opportunity, I think I'll be knocking it on the head for the day after the 4:40 as waiting 45 minutes for one more race to trade isn't much fun! All the best for today.Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com0tag:blogger.com,1999:blog-6634548863347354947.post-23487830989284205282009-09-10T08:42:00.002+01:002009-09-10T09:02:17.459+01:00Keeping tabs on your tradingI do a quick analysis of every race at about midday and note my expectation on a spreadsheet. A side benefit of doing this that I hadn't thought of beforehand is that when I've had a losing race, I can read my comments for the next race. Even if my mind is steamed-up, at least I have analysis for the next race which was done with a clear-head. I can also see when there are several opportunities later in the day for swing trades etc. When I didn't do this pre-race analysis and I had a losing race, the time I had to make-up my loss was always the NEXT race! Sometimes I'd get lucky, but if the next race was a poor trading opportunity then I'd be much more likely to do daft things like doubling-up and going in-play.<br /><br />After having a session where I went on tilt I always used to eventually come to terms with it and soldier on. Now what I try and do when I have a losing race despite my best trading endeavours is not beat myself up. I try and blank it from my mind in the same way I used to do with much bigger losses. Obviously I can do this much more quickly for these smaller losses! I then move on to the next race. It so often surprises me how quickly I can get most or all of the loss back. I then have a chance to make a little more. In the past I'd have no trading bank left to trade with!<br /><br />After each race I note my P&L and make comments about the market. In combination with the screen video I record, this makes a useful review tool. I've thought long and hard about the pros and cons of constantly being aware of my P&L throughout the day and I've read many other traders' blogs about this. The danger is of course that when things aren't going well that focussing on the losses may make you trade worse.<br /><br />On balance I find recording my P&L as I go along useful - for a start it's more up-to-date than my Betfair balance which may have unsettled markets to come into my account. It also enables me to have more perspective on the day than just a total P&L figure. After I've done my pre-race analysis I write a one-sentence forecast for the day - after all if there don't appear to be a lot of good trading opportunities ahead for the day, I shouldn't be beating myself up when I'm not making much money later on!Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com3tag:blogger.com,1999:blog-6634548863347354947.post-68608415962611105922009-09-09T19:03:00.006+01:002009-09-09T19:50:33.639+01:00Scary stuff"Do one thing everyday that scares you." (Eleanor Roosevelt)<br /><br />Trading used to be a world of wonder and mystery. Now it scares me and it is still largely a mystery. I still do it everyday though so hopefully that counts for something. I think taking time off now and then helps maintain the element of wonder.<br /><br />"What's meant to be will always find a way" (Trisha Yearwood)<br /><br />I hope that means laying low and backing high and not the other way around.<br /><br />"You're never as good as everyone tells you when you win, and you're never as bad as they say when you lose." (Lou Holtz)<br /><br />Funny that. No-one has ever told me I was good at winning. When I have a cracker of a losing trade I expect to get a call from Betfair right afterwards with someone laughing so hard they can't speak.<br /><br />"Ignore those that make you fearful and sad, that degrade you back towards disease and death." (Mawlana Jalal-al-Din Rumi)<br /><br />I now ignore those who continually make out that trading is straightforward and even by randomly sticking trades into the market he still finds it hard to lose and so by implication (the 95% of traders) losers are sub-chimp level. And then have a one-way dialogue on their blog......<br /><br />"If you treat an individual as he is, he will remain how he is. But if you treat him as if he were what he ought to be and could be, he will become what he ought to be and could be." (Johann Wolfgang von Goethe)<br /><br />I like this guy. He also wrote my favourite ever quote:<br /><br />"Whatever you can do, or dream you can do, begin it. Boldness has genius, power, and magic in it. "<br /><br />After a long journey I've been making a profit for 6 months.Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com2tag:blogger.com,1999:blog-6634548863347354947.post-43304624676709859502009-08-22T20:02:00.003+01:002009-08-22T20:26:04.389+01:00Blowing your bankTurned out that it only took 2 sticks of dynamite to open the safe at my local Nat West, then like a muppet I laid Johannes in the Ripon 4:35 like there was no tomorrow. Of course it trotted up by 2 1/4 lengths so now I'm back to square one.<br /><br />Only joshing, but there was someone laying Johannes so much that I was tempted to jump on myself in-running, but a swift self-inflicted crack over the knuckles stopped that. I was a bit frustrated because it cost me a chunk of the biggest trading profit I had built-up today when I was riding the steamer. Hey ho, it was still my best result today.<br /><br />I was really pleased to see all the votes for the poll on the right-hand side of my blog about how many times you have blown your bank. Thanks everyone! Early-on the result was split between "Never" and "Three or more times" but now the result is much more what I expected, sadly. At the time of writing the latter has over 60% of the vote, mine included (althought not recently, wayhay!), and this is a big reason why long-term profitable trading is so difficult. When someone says, "oh, you only need to make £3 a race to do over £100 a day", it sounds so easy but anyone who has traded knows there is a lot more to it than that.<br /><br />I've been experimenting with closing my trades within 10 seconds of post time, regardless of how close to the off the race is. It felt very strange at first, but it has advantages. For instance, much less stress! I am doing this experiment to see if I actually do profit in the long-term from trading past the post time. I have always enjoyed this volatile period of trading, but maybe it's not profitable even if there are only occasional large losses? What do you think? Should I put up a poll?Mind Gameshttp://www.blogger.com/profile/00353279735822178218noreply@blogger.com0