by Gavin » Sun May 27, 2018 8:16 pm
Hi davo82ccfc,
Yes that is possible using Cymatic and Excel. If you only submit one back bet on each runner, then you can determine the price at which it was matched by looking in the bet summary columns in Excel, which give the average price matched (column AR) of all back bets on each runner. As there is only 1 back bet per runner, you know that the average price match is the actual price matched of your single bet.
So it is a case of making a formula that compares the contents of column AR (the matched price) with the current price to lay found in column J.
The formula could also look at cell E4 to see if the market has gone in-play.
The countdown timer value should also be helpful, which is in cell B4.
Kind regards,
Gavin