Trading On Betfair: Enhanced Statement Statistics

You'll probably agree that there are never enough statistics for a bettor looking for ways of making their strategy more efficient.

One of the most popular statistics tools is still MS Excel. If you are familiar with its function set or - better still - Visual Basic (or VBA) you will be on top of every trend in betting data analysis.

In this article I'm going to demonstrate an easy way to display charts and gather simple account statement statistics.

MarketFeeder Pro allows you to export market and statement data into an Excel spreadsheet in a real-time mode. I'm emphasising "real-time", as otherwise it is perfectly possible to import your statement from the Betfair website. However, the following approach is for those who want their stats to update automatically as new bets are settled, without the need to re-download and reopen the statement each time.

There is a dedicated panel of Excel settings in MarketFeeder Pro. Without going too deeply into details, I'll say that it is possible to set it to automatically export new statement records into a separate Excel sheet. This way you connect the program to Excel at the very start of your betting, then let it work without further input.

This is how a typical statement would look like in a sheet generated by MarketFeeder Pro.

As you can see, it already provides primitive stats, such as Total Won/Lost or Last Profit/Loss. With a bit of fantasy, you can extend this set by as many figures and objects as you want. Let's practice...

I'm going to use a simple sheet with some VBA code that creates two charts and adds three data labels onto the statement sheet. You can download this sheet from this link and then connect MarketFeeder Pro to it. Zero knowledge of VBA is required for doing this.

As you can see from the picture, it now offers the following stats:

1. Balance Graph
2. Winnings/Losses Graph representing P/Ls in individual markets
3. Number of winning back bets
4. Number of winning lay bets
5. Total commission deducted

How can this help you?

In short, this is a better foundation for making a betting decision. By looking at the graphs, you can quickly evaluate where your strategy is going. By assessing the number of winning back bets as opposed to lay bets, you can decide whether your system better suits for backing or laying.

Moreover, you can access these figures from a trigger inside MarketFeeder Pro, which will make it possible to automate your bets based on the cell values, since the program can read any cell of any sheet in the connected workbook.

For a selection of Betting Apps for Betfair.com please see the Betfair App Directory.