Days LTP for Betfair - all runners UK

Post Reply
fractalmodel
Posts: 58
Joined: Thu Jun 23, 2011 1:22 am

Does anyone have a speadsheet that consolidates all the exchange horse prices onto one spreadsheet for the day please?

I would like to compare with calculated prices. Currently use BET365 which have a large margin in and would prefer to download betfair LTP

Thanks
User avatar
Euler
Posts: 24996
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

fractalmodel
Posts: 58
Joined: Thu Jun 23, 2011 1:22 am

Thank you

I think these are historical prices.
I am looking for the current days prices on one spreadsheet as you might get through Guardian
Atho55
Posts: 657
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

You can import the Sporting Life ABC of Runners into Excel via Power Query like this if that`s any use but having BA provide the same detail on one sheet even with Proj SP would be so much better.

Sporting Life ABC of Runners.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
Euler
Posts: 24996
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

An option would be to add the LTP to a stored value and display via a new list in Guaridan, then use the export option on Guardian.
Atho55
Posts: 657
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

I thought the OP was looking for live odds as you could find in the BA Excel Workbook but all rolled into 1 Excel sheet rather than 1 Excel sheet per race. A BA version of the ABC of runners with live odds.
fractalmodel
Posts: 58
Joined: Thu Jun 23, 2011 1:22 am

Hi

I have the SL export file but require the betfair prices without the overround

The BA version of ABC with prices is correct. Is that possible on one sheet?
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

fractalmodel wrote:
Sun Jan 29, 2023 11:33 pm
but require the betfair prices without the overround
Betfair prices have an overround that's determined by the participants. If you want Betfair prices to compare with bookie prices then you'll need the current back price not the LTP which might have been a lay, or a bet at a price that's no longer available or placed a while ago.
fractalmodel
Posts: 58
Joined: Thu Jun 23, 2011 1:22 am

All prices can have an overound but betfair once the market is mature has the least level

My main issue is collecting all the prices on one sheet.
This can be done through other software but I would prefer to use BA and have anything through the one platform
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

If you can get the prices into Excel in any form anywhere then you can get them on one sheet. Are you familiar with VBA?
fractalmodel
Posts: 58
Joined: Thu Jun 23, 2011 1:22 am

Not to programme it ...No

Im surprised this hasnt apppeared in any of the example spreadsheets as it is much easier to manipulate than 30 odds sheets or more

Thanks
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

fractalmodel wrote:
Mon Jan 30, 2023 12:38 pm
Not to programme it ...No

Im surprised this hasnt apppeared in any of the example spreadsheets as it is much easier to manipulate than 30 odds sheets or more

Thanks
It could be because people either focus on one race at a time, or if they want to look at 30 simultaneously then they'll use automation to do the heavy lifting.

Could you set up a summary worksheet use references the individual race worksheets?
Atho55
Posts: 657
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

You need a worksheet open and connected to BA for every race. What the OP is looking for is all these sheets combined by BA so just 1 worksheet needs to be open.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

Atho55 wrote:
Mon Jan 30, 2023 12:59 pm
You need a worksheet open and connected to BA for every race. What the OP is looking for is all these sheets combined by BA so just 1 worksheet needs to be open.
I think we're agreeing here but in other words, BA can write to multiple worksheets within the same workbook at the same time, one per race. Guardian can set that up semi-automatically rather than setting up 30 everyday....and then you create a seperate dashboard sheet that references them?
Atho55
Posts: 657
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

You have it all wrong. BA collates ALL the info into 1 worksheet just like the SL ABC only the BA sheet has live ish Exchange odds and not bookie odds. This is the dashboard.
Post Reply

Return to “Horse racing”