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...
Expected Race Duration in Seconds
Sun Jan 22, 2017 5:18 pm
Hi everybody,
Would you like to know the expected duration of each race, in seconds? To use in Excel with Cymatic, for example when building an automated strategy to place a bet near the end of the race.
If so, here is formula that might be what you need:
Put this formula somewhere in your spreadsheet in a cell that wont be overwritten by incoming Cymatic data. For example to the right of all the columns with data or command results.
The formula will display the expected race duration, in seconds, based on the length of the race which is usually included in the cell A2. If for any reason the race length is not included in the data that Cymatic displays in cell A2, then the formula will display 0 instead of a predicted duration.
I got the race duration estimates from another site, but haven't checked them. I think they are probably meant to represent statistical average durations for each known race length.
I presume that they are average durations for flat races across all weather conditions.
Using this formula might be quicker and more efficient in Excel than searching a table of race duration data with a VLOOKUP function.
Kind regards,
Gavin
Would you like to know the expected duration of each race, in seconds? To use in Excel with Cymatic, for example when building an automated strategy to place a bet near the end of the race.
If so, here is formula that might be what you need:
- Code:
=IF(ISERROR(FIND("2m4f", $A$2) )=FALSE, 324, IF(ISERROR(FIND("3m1f", $A$2))=FALSE, 381, IF(ISERROR(FIND("2m1f", $A$2) )=FALSE, 258, IF(ISERROR(FIND("2m3f", $A$2) )=FALSE, 282, IF(ISERROR(FIND("2m6f", $A$2) )=FALSE, 355, IF(ISERROR(FIND("2m2f", $A$2) )=FALSE, 263, IF(ISERROR(FIND("1m6f", $A$2) )=FALSE, 212, IF(ISERROR(FIND("1m3f", $A$2) )=FALSE, 135, IF(ISERROR(FIND("2m5f", $A$2) )=FALSE, 326, IF(ISERROR(FIND("2m7f", $A$2) )=FALSE, 354, IF(ISERROR(FIND("1m4f", $A$2) )=FALSE, 142, IF(ISERROR(FIND("1m2f", $A$2) )=FALSE, 125, IF(ISERROR(FIND("1m5f", $A$2) )=FALSE, 189, IF(ISERROR(FIND("1m1f", $A$2) )=FALSE, 102, IF(ISERROR(FIND("3m3f", $A$2) )=FALSE, 419, IF(ISERROR(FIND("3m7f", $A$2) )=FALSE, 389, IF(ISERROR(FIND("3m4f", $A$2) )=FALSE, 467, IF(ISERROR(FIND("3m2f", $A$2) )=FALSE, 393, IF(ISERROR(FIND("3m5f", $A$2) )=FALSE, 476, IF(ISERROR(FIND("3m6f", $A$2) )=FALSE, 450, IF(ISERROR(FIND("4m1f", $A$2) )=FALSE, 523, IF(ISERROR(FIND("4m3f", $A$2) )=FALSE, 520, IF(ISERROR(FIND("1m7f", $A$2) )=FALSE, 228, IF(ISERROR(FIND("4m2f", $A$2) )=FALSE, 546, IF(ISERROR(FIND("5f", $A$2) )=FALSE, 55, IF(ISERROR(FIND("6f", $A$2) )=FALSE, 61, IF(ISERROR(FIND("7f", $A$2) )=FALSE, 79, IF(ISERROR(FIND("4m", $A$2) )=FALSE, 497, IF(ISERROR(FIND("3m", $A$2) )=FALSE, 360, IF(ISERROR(FIND("2m", $A$2) )=FALSE, 228, IF(ISERROR(FIND("1m", $A$2) )=FALSE, 91, 0)))))))))))))))))))))))))))))))
Put this formula somewhere in your spreadsheet in a cell that wont be overwritten by incoming Cymatic data. For example to the right of all the columns with data or command results.
The formula will display the expected race duration, in seconds, based on the length of the race which is usually included in the cell A2. If for any reason the race length is not included in the data that Cymatic displays in cell A2, then the formula will display 0 instead of a predicted duration.
I got the race duration estimates from another site, but haven't checked them. I think they are probably meant to represent statistical average durations for each known race length.
I presume that they are average durations for flat races across all weather conditions.
Using this formula might be quicker and more efficient in Excel than searching a table of race duration data with a VLOOKUP function.
Kind regards,
Gavin
Re: Expected Race Duration in Seconds
Sun Jan 22, 2017 6:05 pm
I found a similar set of data and another way of doing it, was previously posted in the Cymatic forum by user called Canuk. It is here:
Horse Front Runner Spreadsheet, posted by Canuk.
Inside the workbook there is a sheet called LOOKUP, where you'll see the values he uses the race durations in a nice table. You'll see that those values differ a bit from the ones I found elsewhere.
The Horse Front Runner spreadsheet also provides you with a strategy to try out!
Kind regards,
Gavin
Horse Front Runner Spreadsheet, posted by Canuk.
Inside the workbook there is a sheet called LOOKUP, where you'll see the values he uses the race durations in a nice table. You'll see that those values differ a bit from the ones I found elsewhere.
The Horse Front Runner spreadsheet also provides you with a strategy to try out!
Kind regards,
Gavin