Offset Bet at Lower Stake

[AndrewP]

Subject to certain conditions I would like to back a selection to £10 stake and when matched, lay it one tick lower to £9. Any suggestions as to how I might achieve this?

One way would be to make a £1 back bet followed by a £9 offset back bet. But how do I clear the bet reference of the first bet and ensure this is not then duplicated but the second bet is placed?

Another way might be to log the same market to two separate areas on a worksheet, one set up for the £1 bet and one set up for the £9 bet. How do I do this?

A third way would be using VBA. One for the Captain perhaps?

[vanbuuts]

Why not use the bet log to track when your back bet has been matched and then place the lay bet accordingly. You can use “CLEAR” first to clear any residual bet references

[Captain Sensible]

Another way might be to log the same market to two separate areas on a worksheet, one set up for the £1 bet and one set up for the £9 bet. How do I do this?

You could simply have two tabs open logging to separate sheets if you don't want to get too complicated or use VBA. Just have one send a £1 bet and the other sheet send a £9 with the 1 tick offset set in the trigger You can use the mybets sheet to see when bets are matched

[AndrewP]

Thanks guys.

I went for the two sheet solution in the end and now have over a hundred successfully triggered bets after ironing out some glitches in my conditional formulas.