Support Board
Date/Time: Tue, 18 Mar 2025 22:46:50 +0000
Post From: How to Specify an Event that Happened During a Prior Time Range in Spreadsheets
| [2022-09-25 02:31:25] |
| bradyfans - Posts: 16 |
|
I'm trying to figure out how to initiate a trade in spreadsheet for trading system with one of the conditions being that price broke an indicator's subgraph during a certain time period (0830-1000, 0900-1000, etc.) I have figured out how to initiate a trade only during certain hours, but I'm not sure how to state a previous time condition (using VWAP as an example): =AND(price opened below VWAP at 0830, price crossed VWAP after 0830, price is currently above VWAP, an inside bar or bearish engulfing pattern prints, current time is 1000-1200) Most of this I can figure out. It's the part that specifies an occurrence that happened during a previous time period that I don't know how to express. Whether it's just stating price broke the line (crossedfrombelow) or is simply above the line, I don't know how to specify that this happened between the open and 10 am, but that I don't want to open a trade until a later time period. Any help is welcome. Thanks! |