Can you query on BSP?

0 votes

Hi,

1. Is it possible to query race results based on BSP and not on SP?

2. Is it possible to query horse races from a location based on the favourite by BSP and not on SP?

Example: SELECT all races FROM Wolverhampton WHERE BSP=MIN(BSP) of this race AND criteria = x

Thank you in advance,
Dan

asked Jan 5 in Horseracing by Pomroy.dan Plater (170 points)

1 Answer

+1 vote
Yes.  You need to use the betfair_historic_win_prices table and join this to any of the other tables you need for your other criteria.

This blog post uses some example queries from the table that you can adapt, see:

https://blog.betwise.net/2019/07/08/bookmaker-vs-betfair-odds-comparison/
answered Jan 6 by coltest Listed class (2,900 points)
Thank you so much for your response.

Where did you find the betfair_historic_win_prices table?

Many thanks in advance
It’s available to all subscribers.  

I think you may not have subscribed to updates but just bought the historic data - if you send a message via the contact us form with your member ID details we can enable access for you as a one off.
...