Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 23:14:45 +0000

How to Post a Message for Support

Post From: different algorithm for different time frame

[2013-12-05 21:05:52]
[Go To First Post]
Sawtooth - Posts: 3976
You would need to include the time frame conditions in your formulas. Here's one way:

Put these in the following cells:
H3:
=AND(J41-INT(J41)>=TIMEVALUE("08:00:00"),J41-INT(J41)<TIMEVALUE("17:00:00"))
H4:
your conditions specific to the RTH time frame.
H5:
=OR(J41-INT(J41)>=TIMEVALUE("17:00:00"),J41-INT(J41)<TIMEVALUE("08:00:00"))
H6:
your conditions specific to the Globex time frame.

(Use OR if the timeframe spans midnight, use AND if it does not.)

Then include absolute references to $H$3, $H$4 and $H$5, $H$6 using IF statements in your K3-N3 formulas:

=AND(YourConditionsNotSpecificToTimeframe,IF($H$3,$H$4,IF($H$5,$H$6,FALSE)))

Instead of separating things in column H, you could concatenate everything in your K3-N3 formulas.
Date Time Of Last Edit: 2013-12-06 13:21:33