Switch to full style
Questions about integrating Excel and Cymatic, programming, formulae, etc
Post a reply

Is this possible?

Sun May 27, 2018 11:38 am

Hi, after a bit of advice.

Is the following scenario possible ?

I am looking at backing a named runner just before the off and then,
after 5 - 10 seconds I would like the current price of that selection compared to the matched back price bet .


If X lower then place a lay at DOB , if not hedge.


Any advice greatly appreaciated.

Re: Is this possible?

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

Re: Is this possible?

Mon May 28, 2018 10:26 am

Thank you

I will post something in the developer thread , looks a bit above my ability level.
Post a reply