listClearedOrders older than 3 months

[davepband]

Hey all,

I'm an established developer but new to the Exchange API. Currently using my delayed API key to test out retrieval of my betting history using listClearedOrders. I have noticed that both this API and listMarketCatalogue return nothing if the data requested is older than 3 months.

Can anyone tell me if this is just a limitation of the delayed API key, or if it's going to persist when I pay for the live key?

Regards,
Dave

[Sansa]

The Live key will return the same.

[jabe]

The documentation only guarantees this data for 90 days.

[davepband]

Oh wow. Ok, so do you guys know if there is another way to extract my older betting history from Betfair? Surely they keep data older than 90 days...

[jabe]

I suppose it depends on what you're aiming to do. If you're writing a program I assume you'll want to run it more often than once every three months. In that case you could save the data you retrieve to a file for future use (you could just write the retrieved JSON direct to the file). The Betfair site itself will only show you data up to 3 months old and suggests that if you need more you should contact the helpdesk.

[davepband]

Thanks for the replies, jabe. Yep, I certainly can call the API more frequently than 3 months to deal with future data. I have a couple years of betting data that I'd like to pull in though up front. I'll reach out to Betfair themselves and see if they can do a one-off export for me. Cheers.

[Guest]

One thing I noticed the other day is that if I just call the ListClearedOrders without a grouping I don't the correct Commission back. So for Example


Bet ID:199353664037 Market ID:1.170294336 Selection ID:22625377 SIDE:BACK Price Matched: $6.2 Profit: $-5 Commission: $0 Total Profit: $-5
Bet ID:199353765905 Market ID:1.170294336 Selection ID:22625377 SIDE:LAY Price Matched: $5.3 Profit: $6 Commission: $0 Total Profit: $6

Yet if I group by Market ID which I normally do anyway I get

Bet ID: n/a (as 2 bets) Market ID:1.170294336 Selection ID:22625377 SIDE:n/a Price Matched: $0 Profit: $1 Commission: $0.08 Total Profit: $0.92

Oh and yes it only gives 3 months however as Jabe said you are running this program every day so I just make a call at the end of the day and save it into a binary file under my dated directory.

[olivergray]

I suppose it depends on what you're aiming to do. If you're writing a program I assume you'll want to run it more often than once every three months. In that case you could save the data you retrieve to a file for future use (you could just write the retrieved JSON direct to the file mapquest directions). The Betfair site itself will only show you data up to 3 months old and suggests that if you need more you should contact the helpdesk.

Thank you, jabe. I understood the problem.