Page 4 of 4

Can I determine the winner from Odds Recorder?

PostPosted: Fri Feb 09, 2018 12:15 pm
by 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.

Re: Odds Recorder For Technical Analysis

PostPosted: Fri Feb 09, 2018 8:48 pm
by 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

Re: Odds Recorder For Technical Analysis

PostPosted: Mon Jul 23, 2018 1:12 pm
by 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.

Re: Odds Recorder For Technical Analysis

PostPosted: Mon Jul 23, 2018 7:30 pm
by 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

Re: Odds Recorder For Technical Analysis

PostPosted: Mon Jul 27, 2020 9:50 am
by 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

Re: Odds Recorder For Technical Analysis

PostPosted: Mon Jul 27, 2020 9:19 pm
by 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

Re: Odds Recorder For Technical Analysis

PostPosted: Thu Jul 30, 2020 6:47 pm
by nig299

Re: Odds Recorder For Technical Analysis

PostPosted: Sun Jan 22, 2023 4:05 pm
by 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.

Re: Odds Recorder For Technical Analysis

PostPosted: Tue Jan 24, 2023 11:45 pm
by Gavin
El9999 wrote: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