Betfair Price Files Download Manager

Post Reply
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

As Jukebox says....
Plus, how often are you capturing the ltp? Chances are you're missing events that obviously Betfair aren't missing. Remember that in-play there might be several bets within a couple of milliseconds or even within the same millisecond. Even the api doesn't transit every single market change event and its conflated into, if I remember right, packets of data about 17ms apart.

I know a 20ms refresh seems fast, it's roughly the same frequency as 240v mains hum which is crazy compared to computing years ago, but in a market with 1000s of active users it only takes 50 to act in the same second for 20ms to seem like a long time.
AMS01
Posts: 61
Joined: Wed Feb 19, 2020 6:06 pm

ShaunWhite wrote:
Thu May 14, 2020 7:58 pm
As Jukebox says....
Plus, how often are you capturing the ltp? Chances are you're missing events that obviously Betfair aren't missing. Remember that in-play there might be several bets within a couple of milliseconds or even within the same millisecond. Even the api doesn't transit every single market change event and its conflated into, if I remember right, packets of data about 17ms apart.

I know a 20ms refresh seems fast, it's roughly the same frequency as 240v mains hum which is crazy compared to computing years ago, but in a market with 1000s of active users it only takes 50 to act in the same second for 20ms to seem like a long time.
Hi Shaun, On one particular race Betfair were quoting 4.0 as lowest traded price for the horse in second place but Bet Angel showed it under 2.0 and it definitely traded under 2.5
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

What volume was traded at that price? As Jukebox says BF have a minimum to prevent the odd stray penny from distorting the picture.
AMS01
Posts: 61
Joined: Wed Feb 19, 2020 6:06 pm

ShaunWhite wrote:
Thu May 14, 2020 10:35 pm
What volume was traded at that price? As Jukebox says BF have a minimum to prevent the odd stray penny from distorting the picture.
Hi Shaun, yeah sure think I understand what you're both saying ie The figures which Bet Angel log are the nearest "Lowest Traded Price" to within £100?
User avatar
Dallas
Posts: 22671
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

If you take your hi/lo prices from BA ie, the market overview, excel, stored values etc they have a spike filter to eliminate prices that only traded at small volume (relative to price).

If you store the value of the back/lay/ltp price at its high and lowest points that will give you the actual price regardless of amount traded (note, if using back/lay prices that will be the high/lowest offered so not necessarily anything matched)
AMS01
Posts: 61
Joined: Wed Feb 19, 2020 6:06 pm

Dallas wrote:
Sat May 16, 2020 12:02 am
If you take your hi/lo prices from BA ie, the market overview, excel, stored values etc they have a spike filter to eliminate prices that only traded at small volume (relative to price).

If you store the value of the back/lay/ltp price at its high and lowest points that will give you the actual price regardless of amount traded (note, if using back/lay prices that will be the high/lowest offered so not necessarily anything matched)
Hi Dallas, can we continue this conversation in the following thread as it will be more relevant... Cheers

posting.php?mode=reply&f=37&t=20980
asahenettleton
Posts: 15
Joined: Sat Apr 04, 2020 6:30 pm

Thank you, Nigel, for your work.

May I ask if those videos are still up somewhere? Youtube tells me that they are unavailable.
lee1578
Posts: 16
Joined: Sun Mar 18, 2012 3:58 pm

Hello,

Is there a guide on how to use this please?
Noticed that the youtube videos are no longer available.

Thanks
User avatar
Bot2020
Posts: 28
Joined: Wed Feb 12, 2020 1:48 pm

nigelk wrote:
Sun Jun 18, 2017 12:35 pm
Finding the files here a pain to sort out exactly what you need? How long does it take to sort out & download 1 years worth of files?

www.betfairpromo.com/betfairsp/prices/

Heres a spreadsheet that does away with all the hard work & eyestrain.

Betfair Price Files v5.7z

Note: Any files created on your C drive must be named the same as shown on the download manager. I've made a you tube video thats gives a quick demonstration:

https://www.youtube.com/watch?v=AMpchy4 ... e=youtu.be

and also shows you what VBA reference libraries I've got ticked.

https://www.youtube.com/watch?v=r6rhQ95 ... e=youtu.be

The update button will process any info that is held in the spreadsheet, then looks for any updates for the current year from then on
For example, if you've download 2017 to date, when you run it tomorrow/next week, it will download any updated files. Some files are not listed such as " bfprices_26072008.csv" where there is no indication of win or place or even which country it is

If you look at the UK Win files from 2007, there are only two that we can be sure contain only the win info
Hi Nigel, i've just seen this post now, and ive opened it up on excel, only issue is the video links show unavailable on youtube, the is their any chance of you being able to send the video directly to me on [email protected]. thanks.
User avatar
abgespaced
Posts: 176
Joined: Sun Aug 23, 2020 2:25 am
Location: Australia

I can't get the spreadsheet to open. I get the following errors:
error opening spreadsheet.png
error opening spreadsheet 2.png
error opening spreadsheet 3.png
Any ideas?
You do not have the required permissions to view the files attached to this post.
Anbell
Posts: 2004
Joined: Fri Apr 05, 2019 2:31 am

abgespaced wrote:
Mon Sep 14, 2020 4:14 am
I can't get the spreadsheet to open. I get the following errors:

error opening spreadsheet.png
error opening spreadsheet 2.png
error opening spreadsheet 3.png

Any ideas?
try this
viewtopic.php?p=185027#p185027
User avatar
abgespaced
Posts: 176
Joined: Sun Aug 23, 2020 2:25 am
Location: Australia

Anbell wrote:
Mon Sep 14, 2020 4:34 am
abgespaced wrote:
Mon Sep 14, 2020 4:14 am
I can't get the spreadsheet to open. I get the following errors:

error opening spreadsheet.png
error opening spreadsheet 2.png
error opening spreadsheet 3.png

Any ideas?
try this
viewtopic.php?p=185027#p185027
Thanks but same problem. It may have something to do with my VB installation
rayhigh
Posts: 14
Joined: Fri Jul 15, 2016 9:08 pm

Hi

I've downloaded the v6 version of this file but it's not working.

Has anyone got an updated working version of this great utility (thanks Nigel... it used to work spot on)?

or

Is there another way of downloading the files easily?

Thanks... Ray
User avatar
murdok
Posts: 151
Joined: Sun Apr 02, 2017 7:10 pm

User avatar
Dallas
Posts: 22671
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

murdok wrote:
Tue Nov 10, 2020 3:10 pm
try this i changed the url

http://www.mediafire.com/file/6l17qgef8 ... d.rar/file
I've just added this updated version to the bottom of the opening post with a credit to you as the updater
Post Reply

Return to “Betfair Data”