Support Board

Date/Time: Sun, 05 May 2024 19:29:03 +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] Link To Thread - Link To Post [Go To First Post]
BenjaminR - Posts: 168
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