Morning guys, hope we're all good.
Been searching the forum as I'm wanting to know if you can use excel formula to close all trades at one minute from the actual off for example. Basically use formula to get out of any trade before the business end of the race regardless of whether my bets have been matched or not, and tailored depending on the length of the race?
I've noticed some threads using VBA but not familiar with this so just wanted to see if it could be done with formula instead.
Many thanks in advance.
Lee
Time based exit
Moderator: 2020vision
2 posts
• Page 1 of 1
Time based exit
by 813615 » Tue Nov 04, 2025 9:00 am
- 813615
- Posts: 55
- Joined: Mon Sep 30, 2019 5:53 pm
Re: Time based exit
by Captain Sensible » Wed Nov 19, 2025 6:01 pm
The time to the off is displayed in cell D2 as a timestamp 00:05:49 etc, when the time has gone past the offtime the time is displayed as text in the format -00:1:00
So say we want to display YES on, or after, that minute to the off you could use a formula like
=IF(OR(D2 <= TIME(0,1,0), ISTEXT(D2)), "YES", "NO")
So say we want to display YES on, or after, that minute to the off you could use a formula like
=IF(OR(D2 <= TIME(0,1,0), ISTEXT(D2)), "YES", "NO")
-
Captain Sensible - Posts: 2931
- Joined: Sat Nov 19, 2005 2:29 pm
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 55 guests