SP only for horse race?

[miso.dca]

Hello,
when I check to log SP into excel for something else than horse race, everytime I've got "0". SP works only for horse race, why? It is possible to log SP from any other sports? Or am I missing something?

[mtysocks]

Hi. As far as I know only horse racing has a Starting Price (SP) for runners. Other sports like Football, Tennis etc. do not have this facility. It is common across all bookmakers and exchanges.

[kiint]

And Greyhounds

[miso.dca]

thx guys for answer, and it is possible to show from API in excel this? :
- PE_LOW
- PE_HIGH
- PE_LAST

this could help me to find what I want ...

[alrodopial]

thx guys for answer, and it is possible to show from API in excel this? :
- PE_LOW
- PE_HIGH
- PE_LAST

this could help me to find what I want ...

what is PE ?

[miso.dca]

PE_LOW - should be lowest price in pre match
PE_HIGH - should be max price in pre match
PE_LAST - should be last matched price in pre match

[alrodopial]

only the last price matched can be retrieved from api
the other two must be logged and calculated in ecxel

[doris_day]

You would also have to assign a minimum amount matched for the high and low figures.

Is a very high price with £2 matched any real indication of a high price ?
Probably not.

[miso.dca]

ok, thx for reply

what would you recommend? How should I estimate approximate SP?

[Captain Sensible]

Are you using these 'SP's to bet from or just need them for stats etc, Betfair provide their own data files that contain lots of info regarding high and low prices for both in play and pre off all time stamped too. Lots of people have used those in the past to recreate their own 'at the off' Betfair price.

What sports are you trying to log the SP for? Football data has average bookie prices for football which would be close to BF prices or even just setting your spreadsheet to log last prices until the market went inplay would give you a decent enough 'sp' on a market if you;re not doing too many

[miso.dca]

"Betfair provide their own data files that contain lots of info regarding high and low prices for both in play and pre off all time stamped too" - where should I get this data files? or do you mean something like xml files? because more easier would be load data from bet365 e.g. ... but maybe I have something better, it is possible to load it into excel?

[Captain Sensible]

Their files are large and in csv format they'll load in excel but probably too large to manipulate properly. Probably best use a dedicated database app like Access or SQL database if you want to manipulate the files. All depends what you want and what you want them for , they'd be no use to use as live data for triggered betting as they aren't available until a day or two after the event.

[Captain Sensible]

data.betfair.com

[miso.dca]

yes, but I need it rof live betting so after match it will be useless so probably I cant do it? what a surprise

[Captain Sensible]

It's a bit hard to advise you you as you haven't really said what you're after. It's easy enough to copy the market say to sheet 2 and freeze it at the off so you have a static copy of what the market was at the off. Something as simple as this would save the data

Code: Select all

    If Range("E2").Value = "Not In Play" And Range("F2").Value <> "Suspended" Then
   
    Sheets("Sheet2").Range("A1:AA70").Value = Sheets("Sheet1").Range("A1:AA70").Value
   
End If

.

If you want the high and low matched prices you need to use the COM functions with the getAllTradedVolume calls, you could just use VBA to log highs and lows via the normal excel interface but you'd need to be logging from the market opening to ensure catching all highs and lows. Just search the forum for getAllTradedVolume probably be a few examples around.