Tweet
Comparing historical data JSON with Betfair SP Price Data
Hello,
I've written a small Python script to summarise the traded volume of a runner. I've noticed a discrepancy between the JSON capture of the Betfair stream API, and the Betfair Promo SP price files.
As an example, I looked at the runner 8928588 (Wheat Sheaf) in market 1.118674148 (Nott 8th May 17:15).
Taking the cumulative volumes per price level for this runner from the "trd" JSON key, and summing across all price levels, I get a total traded volume figure of: £303,257.75. If I download the Betfair SP CSV file for this day, the same runner has:
PPTRADEDVOL: 260056.14
IPTRADEDVOL: 59389.84
For a total traded volume of: £319,445.98.
This seems very close to the value in the captured stream (~5% difference), but different enough to be slightly suspicious. Is one of these files more accurate than the other? Is there a known discrepancy between the two?
Thanks!
I've written a small Python script to summarise the traded volume of a runner. I've noticed a discrepancy between the JSON capture of the Betfair stream API, and the Betfair Promo SP price files.
As an example, I looked at the runner 8928588 (Wheat Sheaf) in market 1.118674148 (Nott 8th May 17:15).
Taking the cumulative volumes per price level for this runner from the "trd" JSON key, and summing across all price levels, I get a total traded volume figure of: £303,257.75. If I download the Betfair SP CSV file for this day, the same runner has:
PPTRADEDVOL: 260056.14
IPTRADEDVOL: 59389.84
For a total traded volume of: £319,445.98.
This seems very close to the value in the captured stream (~5% difference), but different enough to be slightly suspicious. Is one of these files more accurate than the other? Is there a known discrepancy between the two?
Thanks!