Support Board
Date/Time: Fri, 28 Feb 2025 09:32:11 +0000
Post From: Alert Condition that is only valid within X minutes of one of the conditions being TRUE
| [2021-07-27 00:38:11] |
| BenjaminR - Posts: 172 |
|
Well, I've tried to figure this out for several hours today- & I can't seem to work it out. The signal is on a tick chart, but the signal is only valid within 5 minutes from when the MACD is above the zero line. I used Study/Price overlay to have the data from a 1 minute chart in the spreadsheet. But I've tried the timestamp formula for a buy entry on both the last price of the 1 Min. data, & the MACD differential, & for both- I get decimal numbers I don't know what to do with. I created a Boolean 1 or 0 in a column for when the MACD is positive, & tried to apply the 'buy entry return timestamp' example formula on that. I just get a different decimal number. I'm at a loss at how to read that in terms of time. I looked into the IF THEN ELSE format, but with the OR, I still don't understand the persistent variable/count from an event example, as it does work for counting, but it just keeps counting- I don't know how to tie it to count to 5 minutes, then reset. Seems it's counting bars on the tick chart. Would you be so kind as to please help me through this? Date Time Of Last Edit: 2021-07-27 00:38:56
|