by Gavin » Wed May 02, 2018 9:59 pm
Hi CBB,
Yes it would be possible. I'll assume that your definition of 'opening print', refers to the first price that appears when you select the market in the software (rather than the first trade that occurred in the market after Betfair opened the market for business, when you might not have been watching the market).
So you'd need to store the first print in a separate cell, either by typing it manually, or using Visual Basic code to copy the value for you. The code would simply copy the value to an suitable empty cell (for example on Sheet 2 where you won't interfere with any used cells on the Cymatic sheet).
Then you just need to put a simple formula in column BA, that references the current price and the stored opening print value and compares them.
Kind regards,
Gavin