Is this possible?

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

Is this possible?

Postby davo82ccfc » 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.
davo82ccfc
 
Posts: 9
Joined: Sun Aug 30, 2015 11:37 am

Re: Is this possible?

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

Re: Is this possible?

Postby davo82ccfc » Mon May 28, 2018 10:26 am

Thank you

I will post something in the developer thread , looks a bit above my ability level.
davo82ccfc
 
Posts: 9
Joined: Sun Aug 30, 2015 11:37 am


Return to Excel - Help / Support

Who is online

Users browsing this forum: No registered users and 0 guests

cron