Change from the opening bet price

Questions about integrating Excel and Cymatic, programming, formulae, etc

Change from the opening bet price

Postby CBB » Tue May 01, 2018 8:26 pm

Hi Gavin - is there any way to trigger an order based on a % movement from the first bet placed on a race? For example: the first print/bet on Betfair is 10 and the command would be if the price moves down 20% from the opening print then back at 8 in this case? Thanks!
CBB
 
Posts: 1
Joined: Tue May 01, 2018 8:16 pm

Re: Change from the opening bet price

Postby 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
User avatar
Gavin
Site Admin
 
Posts: 3832
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom


Return to Excel - Help / Support

Who is online

Users browsing this forum: No registered users and 0 guests