Tutorial 7: The market information you can record
Hi,
We have
questions from our users about the format of the saved Excel spreadsheet. Today
we would like to clarify this issue and give more detailed descriptions for all
Betfair data fields which you can record using BetMarket Scanner.
Below you can see a small screenshot which illustrates the data from the saved Excel spreadsheet. It’s just a piece of all information, but it gives a view of the format.
First row
is the header of each column. All other rows below are showing selections in
different moments of time. If you have 10 selections, they will be repeating -
each time 10 rows for some particular moment. The exact time of this moment you
can find in the first column called Date/Time.
Here are
descriptions for all columns:
1) Date/Time
The date
and time when this row was recorded.
2) Market Id
The
internal unique indemnificatory of the Betfair market (event) which can be used
to reference a market.
3) Market Name
The textual
name of the market.
4) Matched Amount
The amount
of money of all matched bets in the market.
5) Currency
GBP, USD,
EUR, etc
6) Back Book Percentage & Lay Book
Percentage
Values
which you can see at top in the Betfair market interface. They are calculated
from formula:
Percentage
= 100 / Runner1Price + 100 / Runner2Price + 100 / Runner3Price
7) Is In-Play
Whether
this market In-Play now or not
8) Selection Name
The name of
the selection (ruunner)
9) Selection Id
The
internal unique Betfair identificator for a selection. Can be used to reference
selections.
10) Back Price 1, Back Price 2, Back Price 3
'Back'
prices (the best price is Back Price 3)
11) Lay Price 1, Lay Price 2, Lay Price 3
'Lay'
prices (the best price is Lay Price 1)
12) Back Amount and Lay Amount
Amounts
offered to bet at respective prices
13) SP
'Spread' -
the difference in ticks between back and lay prices. The size of the tick is
different for particular price range. Say, for range of 1.01 - 1.99 the tick is
0.01, for 2.00 - 5.00 is 0.02, etc.
14) WoM Ratio
Weight of
money ratio = (BackAmount1 + BackAmount2 + BackAmount3) / (LayAmount1 + LayAmount2
+ LayAmount3)
15) WoM Difference
Weight of
money difference = (BackAmount1 + BackAmount2 + BackAmount3) - LayAmount1 +
LayAmount2 + LayAmount3)
16) Matched
The amount
of money of matched bets for a given selection
17) %Matched
The
percentage of matched money for a given selection comparing with matched amount
for whole market.
18) New Traded
The amount
of money were matched for a given selection since the last refresh
19) Trade Ratio
Trade Ratio
= Sum of all matched 'Back' bets divided to Sum of all matched 'Lay' bets
20) Back Trade EMA, Lay Trade EMA
The
exponential moving average of the amount of matched bets over the last 19
refreshes (for Back and Lay bets respectively).
21) Last Price Matched
The price
at which last taken bet was matched for a given selection.
22) Reduction Factor
Quoted from
Betfair:
For our
horseracing markets we guard against possible non-runners with a system of
Reduction Factors (similar to Rule 4 with traditional bookmakers). Each horse
is allocated a Reduction Factor, based on its likely chance of winning the
race. Should a horse be declared a non-runner, the Reduction Factor will be
applied to the prices of all matched bets, for both backers and layers. This is
to ensure that layers are not unfairly treated and exposed to large liabilities
when the chances of other horses winning have improved. The Reduction Factors
are designed to be fair to both backers and layers.