Betting at strange prices with spreadsheets

[Vaardgrim]

Hi guys,

I want to build a spreadsheet which works on a strategy of laying to a % of the taken back price.

The issue is that if I (hypothetically) back at a price of 10.5 and want a place a lay order at 75% of that price then 0.75x10.5 is 7.875.

Now there is no 7.875 on the available ladder on Betfair. Therefore I would want to place my lay at 7.8.

So what happens if my spreadsheet fires a lay in at 7.875? Does the api reject the bet outright or adjust it to 7.8? On the website, it adjusts the price to 7.8 but asks for confirmation.

Thanks guys,

Arthur

[LeTiss]

The 7.8 bet won't fire, it will show an error in the cell

Your best bet is to possibly have all BF prices listed in a column & use a VLOOKUP to pick the appropriate price. I used to use a similar strategy & that's how I fixed the issue

[gazuty]

And from experience you will get disconnected from the api.

[6thSense]

LeTiss has the correct method to get around this. It's fairly quick to set up.

gazuty - Not sure what this has got to do with getting disconnected from the API? Incorrect code in a spreadsheet will not do this.

Other problems such as Betfair API problems, local internet issues and possibly account problems may cause this.