Lay a specific price using Excel

[Herbie1809]

Hi All,

Hope you've all had a profitable day.

Excuse me if I've misinterpreted BA, but I've looked through a lot of other posts and been unable to find the answer I'm looking for.

What I would like to do is use Excel to place a Lay bet at an exact price I specify, even though this is different from the existing market price.

For example, if the current Lay Odds on a selection are 6.2, I want to place a bet at 5.8.

Obviously, this may not be matched immediately, or not at all. However, Betfair would maintain the open bet until race time.

I know it can be done manually using BA as I use it often. However, I can't seem to find a trigger that does this in Excel, or have I missed something REALLY obvious?

All of the solutions I've seen always involve Offset bets, but I want a simple Lay bet.

Any ideas??


Much obliged

[osknows]

Do you have an excel sheet you already use? It's easy to set the odds column to be what ever you want, either a fixed odds or offset from the current odds; but what determines when to place the bet is probably what's more important?

Ie. Is it for example

set odds for only certain selections
set odds for only selections between a certain odds range
offset odds for certain selections..or
combination of above
etc?

[Herbie1809]

Thanks Os,

but which Odds column do I set manually?

I am right in thinking its column R ?




Cheers

[osknows]

Yes.

Essentially 3 columns need filled
Q - is the trigger and optional modifier; eg BACK, LAY, BACK-F5 ...etc
R - is the odds, either current back/lay, offset or whatever you want it to be
S - is the stake

[Herbie1809]

Cheers Os,

I'll give it a go!

Still trying to find that dream strategy! LOL