Cymatic Trader Community

[ThomasAJ]

Hello

Warning! Newbie here.

Looking at Recorder results can I presume in the 'Status is SUSPENDED' row and if the Back Odds = 0 (zero) for a horse, that it has won subject to say protest?

Just trying to determine the winner.

[Gavin]

Hi ThomasAJ,

Welcome!

I haven't looked into the spreadsheet, but from what you have said, I think it sounds like your assumption should be correct.

Kind regards,

Gavin

[Jamesuesername]

How would I modify the recorder to log 1 row instead of using last row feature, I want to compare the traded volume column, to see how much money is coming in per API refresh.

[Gavin]

Hi Jamesuesuername,

You could edit the Visual Basic code (using the Visual Basic Editor, found in the Developer tab in Excel) to store the previous traded volume so that it can be compared to the figure in the next API refresh. The previous figure could either be stored in a spare cell in a spreadsheet, or in a memory variable declared in the Visual Basic code.

Kind regards,

Gavin

[thebumperking]

Any ideas how i would catch data at certain times before the off instead of on each refresh i.e60 minutes before 30 minutes before etc

many thanks

dean

[Gavin]

Hi Dean,

You have two options. Either make your code (or formula perhaps) refer to cell A4 which shows you the scheduled start date and time, or refer to cell B4 which shows you the countdown clock.

If you use the countdown clock, keep in mind that it might show an estimated value if the race has already gone in play when you select the market, because it won't know the true moment when the race went in-play. In which case, the code shown in the following discussion might be of help to you:

http://www.cymatic.co.uk/forum/topic1333.html

Kind regards,

Gavin

[nig299]

see

topic2006.html

[El9999]

Hi Gavin.
Please could you send me a message with a link to the program for Cymatic for recording odds data for technical analysis please? I sent an email to support, but it hasn't been answered. Thanks.
Also, is there a step by step tutorial on how to use it? I haven't ever used one of these programs before. Thanks.

[Gavin]

Hi Gavin.
Please could you send me a message with a link to the program for Cymatic for recording odds data for technical analysis please? I sent an email to support, but it hasn't been answered. Thanks.
Also, is there a step by step tutorial on how to use it? I haven't ever used one of these programs before. Thanks.

Hi El9999,
Thanks for your messages. I hope the info that I emailed was helpful. If you have any further queries then please don't hesitate to let me know.
Kind regards,
Gavin