Second bet after partial match with formulas only

[alrodopial]

It was fun, thanks scarlett3 for your request, viewtopic.php?f=5&t=11628
Not tested in real life but I guess it will be ok

Using formulas places a bet and if is partial matched it places a second bet for the remaining stake, no vba is needed, file doesn't have vba
Using formulas it creates "flags" when a bet is placed that are used to fire the second bet

In clm AA you type "Y" for the selection you want to place a bet
Red cells should not be changed as they contain critical formulas
You should change other cells according to your needs, eg min/max odds requested, criteria that must be met etc.
Columns can be moved
Circular reference in Excel must be enabled. File/Options/Formulas/Enable iterative calculation/ lower max iterations to 10 or less
Second bet must be of same type as first one
For resetting formulas that create the required flags you can
1. log SP prices into excel (in BA: excel/log current prices/ tick SP at the right), cell Y5 will be used and reset will be made when market in BA changes (flag in AE1)
or
2. Type "Y" in AE2 and then clear the cell
It is not good for SP bets

Feel free to modify it but be careful as it is not tested
In theory It can be expanded to contain trades eg BACK/LAY first/second bets but it becomes quite complicated
Using the same principals a timer for the inplay racing can be made with just formulas