Odds Recorder For Technical Analysis

Samples developed by Cymatic and others. Please share your spreadsheets here.
Forum rules
Users can post their spreadsheets here, to share with others and for discussion purposes.
If you download a spreadsheet from here, please carefully test any strategies yourself before using it with real money. Cymatic accepts no liability for any spreadsheets in this forum.
Now bring on the robots! Happy automated trading... :)

Can I determine the winner from Odds Recorder?

Postby ThomasAJ » Fri Feb 09, 2018 12:15 pm

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.
ThomasAJ
 
Posts: 15
Joined: Mon Feb 05, 2018 11:11 am

Re: Odds Recorder For Technical Analysis

Postby Gavin » Fri Feb 09, 2018 8:48 pm

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

Re: Odds Recorder For Technical Analysis

Postby Jamesuesername » Mon Jul 23, 2018 1:12 pm

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.
Jamesuesername
 
Posts: 15
Joined: Thu Jun 21, 2018 12:15 am

Re: Odds Recorder For Technical Analysis

Postby Gavin » Mon Jul 23, 2018 7:30 pm

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

Re: Odds Recorder For Technical Analysis

Postby thebumperking » Mon Jul 27, 2020 9:50 am

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
thebumperking
 
Posts: 1
Joined: Sun Feb 21, 2016 8:27 am

Re: Odds Recorder For Technical Analysis

Postby Gavin » Mon Jul 27, 2020 9:19 pm

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

Re: Odds Recorder For Technical Analysis

Postby nig299 » Thu Jul 30, 2020 6:47 pm

nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Previous

Return to Excel - Sample Spreadsheets

Who is online

Users browsing this forum: No registered users and 0 guests

cron