Last 10 Posts Topic: Need help for alert for MACD against MA Posted: Wednesday, April 3, 2019 1:04:06 PM QUOTE (Bruce_L) So the idea is that it is that the MACD is moving toward its trigger line and then starts moving away? If so, being above the MACD would be the following. `TrueInRow(MACD12.26 > AVG(MACD12.26, 9), 3) = 3 AND MACD12.26 > MACD12.26.1 AND MACD 12.26.1 < MACD12.26.2` And being below the MACD would be the following. `TrueInRow(MACD12.26 < AVG(MACD12.26, 9), 3) = 3 AND MACD12.26 < MACD12.26.1 AND MACD 12.26.1 > MACD12.26.2` You could combine these using OR and some parantheses to check for either possibility in the same formula. `(TrueInRow(MACD12.26 > AVG(MACD12.26, 9), 3) = 3 AND MACD12.26 > MACD12.26.1 AND MACD 12.26.1 < MACD12.26.2) OR (TrueInRow(MACD12.26 < AVG(MACD12.26, 9), 3) = 3 AND MACD12.26 < MACD12.26.1 AND MACD 12.26.1 > MACD12.26.2)` You need to make sure the time frame of the formula is set to hourly if you want it to match an hourly chart. Thanks Bruce! Topic: Need help for alert for MACD against MA Posted: Wednesday, April 3, 2019 9:58:20 AM QUOTE (tsben88) Need help .   I wish to write a formulation with the MACD that goes against the Moving Average, forming a "hook" for my hourly chart.   Attached are the pictures.   I would appreciate if you could assist me.   Thanks. Topic: Need help for alert for MACD against MA Posted: Wednesday, April 3, 2019 9:41:49 AM Need help .   I wish to write a formulation with the MACD that goes against the Moving Average, forming a "hook" for my hourly chart.   Attached are the pictures.   I would appreciate if you could assist me.   Thanks.