Thanks again Gavin!
I've made the correction, and added a summary of the available odds, Profit and Green To columns. I was planning to add a basic arb/dutching calculator, but I understand that Betfair's crossmatching has killed off any inter-market arbs or value bets. For those of you wanting a good arb/dutching calculator, a very generous chap called Grumblebus/Pokebus has created a spreadsheet called Grumblebus 5.5, which is easily found with Google.
Correction to Livescore sheet and minor update to Summary sheet
Cymatic-Football-Summary-v3.1.xlsm
royline wrote:Hi All, are there any instructions on how to use this if you are not familiar with formulae,
Regards,
Roy.
Hi Roy
Looking at the formulae will show you how the result in a cell is calculated, or where the information comes from. In the CS Under and CS Over grid, for example, C38 and C39 show similar odds, but they are calculated from different markets. C39 is referenced directly from the OU0.5 market, whereas C38 is calculated indirectly from the Correct Score market. You don't need a good knowledge of Excel or formulae to use this spreadsheet (I'm speaking from experience!). Simply open a new grid for each market, and connect each to the relevant sheet in the workbook. The spreadsheet is intended to be an aid to whatever strategy you are using, by displaying the available odds and probability of different outcomes.
Best regards
adenlark
You do not have the required permissions to view the files attached to this post.