Betfair Exchange Betting History Downloads

A place to discuss anything.
Post Reply
deestar
Posts: 179
Joined: Thu Feb 20, 2020 6:17 pm

Hi,

Anyone else notice a change to the Betting Exchange History in the My Account section? The download is now a CSV file and the information in it has changed. For example the markets used to start with GB/.... or AUS/... etc. No longer. A real pain as I download this every day and parse it using macros for my record keeping. Basically have to recreate the lot :x
deestar
Posts: 179
Joined: Thu Feb 20, 2020 6:17 pm

Old market field: GB / Wind 24th Jun / 20:55 1m2f Hcap
New Market Field: Horse Racing / 20:25 Leicester / Win

A real pain.
User avatar
jimibt
Posts: 4200
Joined: Mon Nov 30, 2015 6:42 pm

you could build an adaptor function in your macro to translate the file format as required and then apply that as per normal. this would mean that you preserve your existing records and apply the reformatted file.

should be fairly simple to create and test. ;)
deestar
Posts: 179
Joined: Thu Feb 20, 2020 6:17 pm

jimibt wrote:
Fri Jun 26, 2020 9:57 am
you could build an adaptor function in your macro to translate the file format as required and then apply that as per normal. should be fairly simple to create and test. ;)
The problem is the removal of the geo location and the market type and distance not the change in file type
deestar
Posts: 179
Joined: Thu Feb 20, 2020 6:17 pm

It seems they are updating all these reporting pages

https://community.betfair.com/service/g ... s---update
User avatar
jimibt
Posts: 4200
Joined: Mon Nov 30, 2015 6:42 pm

deestar wrote:
Fri Jun 26, 2020 9:59 am
jimibt wrote:
Fri Jun 26, 2020 9:57 am
you could build an adaptor function in your macro to translate the file format as required and then apply that as per normal. should be fairly simple to create and test. ;)
The problem is the removal of the geo location and the market type and distance not the change in file type
yes, i can see your issue. that's a royal pain. short of having an entire lookup function per course->location, you are literally screwed !!

betfair yet again making their download data ever less useful.
deestar
Posts: 179
Joined: Thu Feb 20, 2020 6:17 pm

Just noticed it's also only downloading the first 1000 records :shock:
User avatar
jimibt
Posts: 4200
Joined: Mon Nov 30, 2015 6:42 pm

deestar wrote:
Fri Jun 26, 2020 10:14 am
Just noticed it's also only downloading the first 1000 records :shock:
not that you want to go down any more obscure avenues but, you could use the FREE delayed API key that comes with your account to fire up and account query and then you'd be able to use the data in any fashion you needed. this would of course entail delving into something like c# or python. laim has a github space with all the basics for getting this sort of dat. will update this answer with the location in 2 mins...
Anbell
Posts: 2405
Joined: Fri Apr 05, 2019 2:31 am

jimibt wrote:
Fri Jun 26, 2020 10:24 am
deestar wrote:
Fri Jun 26, 2020 10:14 am
Just noticed it's also only downloading the first 1000 records :shock:
not that you want to go down any more obscure avenues but, you could use the FREE delayed API key that comes with your account to fire up and account query and then you'd be able to use the data in any fashion you needed. this would of course entail delving into something like c# or python. laim has a github space with all the basics for getting this sort of dat. will update this answer with the location in 2 mins...
https://github.com/liampauling/betfair
User avatar
jimibt
Posts: 4200
Joined: Mon Nov 30, 2015 6:42 pm

Anbell wrote:
Fri Jun 26, 2020 10:26 am
jimibt wrote:
Fri Jun 26, 2020 10:24 am
deestar wrote:
Fri Jun 26, 2020 10:14 am
Just noticed it's also only downloading the first 1000 records :shock:
not that you want to go down any more obscure avenues but, you could use the FREE delayed API key that comes with your account to fire up and account query and then you'd be able to use the data in any fashion you needed. this would of course entail delving into something like c# or python. laim has a github space with all the basics for getting this sort of dat. will update this answer with the location in 2 mins...
https://github.com/liampauling/betfair
thanks - that's the one :D
deestar
Posts: 179
Joined: Thu Feb 20, 2020 6:17 pm

Thanks both. A little outside my knowledge base but gives me something to work with. Back to school I go!
User avatar
jimibt
Posts: 4200
Joined: Mon Nov 30, 2015 6:42 pm

deestar wrote:
Fri Jun 26, 2020 10:39 am
Thanks both. A little outside my knowledge base but gives me something to work with. Back to school I go!
i've always found that anything FREE will take you so far, until things change that are beyond your control. the investment in having control over your activities cannot be overstated!!

enjoy the new school, but rmbr that *playtime* (recess/the break) is just as important! :D
longmot
Posts: 7
Joined: Sun Jun 18, 2017 10:49 pm

This looks fixed. You can download more than before. They may have changed the way they define what is included between the dates as I had some diffs. Possibly using settled date rather than placed date.
User avatar
firlandsfarm
Posts: 3370
Joined: Sat May 03, 2014 8:20 am

deestar wrote:
Fri Jun 26, 2020 9:08 am
Old market field: GB / Wind 24th Jun / 20:55 1m2f Hcap
New Market Field: Horse Racing / 20:25 Leicester / Win

A real pain.
You gain some you lose some, that's life! Like you deestar I will regret the loss of the Country Code :( but I will benefit from the introduction of the market … it's a pain when dogs and horses have the same location … this solves that. :)
deestar
Posts: 179
Joined: Thu Feb 20, 2020 6:17 pm

firlandsfarm wrote:
Mon Jul 27, 2020 12:32 pm
deestar wrote:
Fri Jun 26, 2020 9:08 am
Old market field: GB / Wind 24th Jun / 20:55 1m2f Hcap
New Market Field: Horse Racing / 20:25 Leicester / Win

A real pain.
You gain some you lose some, that's life! Like you deestar I will regret the loss of the Country Code :( but I will benefit from the introduction of the market … it's a pain when dogs and horses have the same location … this solves that. :)
What about when dogs and dogs have the same location though, or indeed horses and horses. Bendigo trots v Bendigo gallops. Newcastle Dogs (Aus) v Newcastle Dogs (UK)
Post Reply

Return to “General discussion”