Optuma Forums › Optuma Scripting › MACD above 0 for 6 consecutive bars › Reply To: MACD above 0 for 6 consecutive bars
May 18, 2021 at 6:37 pm
#64099
- Topics: 70
- Replies: 832
- Posts: 902
Thanks Deepak. Your formula is counting how many days since the MACD-H crossed above zero – not how may days it has been above zero. To see the difference put your formula (without the ==6 so the value will display) in a watchlist column.
This example shows correctly that it has been 50 days since the MACD crossed above zero for STE, but its not what you are looking for as the MACD is currently below zero:
Instead, change the logic to count the number of days since the MACD-H was last below zero:
1 2 3 4 |
V1=MACD(BAR2=34) < 0; TIMESINCESIGNAL(V1)==6 |
Out of the S&P500 stocks, only CME has had 6 days above zero (but change to >=6 for at least 6 days and there are 44 stocks):