Support Board
Date/Time: Sun, 24 Nov 2024 23:16:27 +0000
Post From: different algorithm for different time frame
| [2013-12-05 21:05:52] |
| Sawtooth - Posts: 4120 |
|
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
|