Check out our new trigger example that leverages the average race duration that we have calculated based on the huge volume of stats we've gathered over the last few years:
Acting towards the end of a race: calculating race duration based on statsThe "magic formula" is below:
IF(FIND("2m4f", "market_name") > 0, 324, IF(FIND("3m1f", "market_name") > 0, 381, IF(FIND("2m1f", "market_name") > 0, 258, IF(FIND("2m3f", "market_name") > 0, 282, IF(FIND("2m6f", "market_name") > 0, 355, IF(FIND("2m2f", "market_name") > 0, 263, IF(FIND("1m6f", "market_name") > 0, 212, IF(FIND("1m3f", "market_name") > 0, 135, IF(FIND("2m5f", "market_name") > 0, 326, IF(FIND("2m7f", "market_name") > 0, 354, IF(FIND("1m4f", "market_name") > 0, 142, IF(FIND("1m2f", "market_name") > 0, 125, IF(FIND("1m5f", "market_name") > 0, 189, IF(FIND("1m1f", "market_name") > 0, 102, IF(FIND("3m3f", "market_name") > 0, 419, IF(FIND("3m7f", "market_name") > 0, 389, IF(FIND("3m4f", "market_name") > 0, 467, IF(FIND("3m2f", "market_name") > 0, 393, IF(FIND("3m5f", "market_name") > 0, 476, IF(FIND("3m6f", "market_name") > 0, 450, IF(FIND("4m1f", "market_name") > 0, 523, IF(FIND("4m3f", "market_name") > 0, 520, IF(FIND("1m7f", "market_name") > 0, 228, IF(FIND("4m2f", "market_name") > 0, 546, IF(FIND("5f", "market_name") > 0, 55, IF(FIND("6f", "market_name") > 0, 61, IF(FIND("7f", "market_name") > 0, 79, IF(FIND("4m", "market_name") > 0, 497, IF(FIND("3m", "market_name") > 0, 360, IF(FIND("2m", "market_name") > 0, 228, IF(FIND("1m", "market_name") > 0, 91, 0)))))))))))))))))))))))))))))))