Can you query on BSP?

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

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

commented Jan 6 by Pomroy.dan Plater (170 points)

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.

commented Jan 6 by coltest Listed class (2,900 points)

Can you query on BSP?

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.

Most popular tags