pharlap1959 wrote:Hi all,
My excel sheet triggers very well at a set time, with lay spread odds of 1 to 20 to 1. If it partially gets set at say 12 to 1 it will not set the rest at anything over those odds when there is a market available below 20's.
Can anyone suggest a remedy.
Cheers
pharlap, if I am reading correctly is your problem due to the fact that if your bet is only partially matched that the bet reference is still shown on the sheet and therefore your trigger can't fire another bet?
As long as your lay bet is not LAY-F5 then surely the bet ref ends with "P". Code can be written that if the last character in the cell is "P" then clear the cells at a set time so that a new bet can be triggered.