How to show bars ago cross for MACD

April 26th, 2015, 02:04 AM

Im trying to add a column to my watchlist that shows the bars ago crossed for the MACD. So if the MACD was bullish crossed 6 bars ago I want a green 6 and a red 6 if it was a bearish cross. That way I can sort my symbols to show symbols that have a crossed the most recent and see the ones that haven't crossed the longest. Any ideas how to do this?

April 26th, 2015, 08:34 AM

pollux321, paste it as custom watchlist query.

Code

                            
def fastLength = 12;
def slowLength = 26;
def MACDLength = 9;
def averageType = AverageType.EXPONENTIAL;
def Value = MovingAverage(averageType, close, fastLength) - MovingAverage(averageType, close, slowLength);
def Avg = MovingAverage(averageType, Value, MACDLength);
def Diff = Value - Avg;
def mode = if diff > 0 then 1 else -1;
def bullcount = if mode == 1 then bullcount[1] + 1 else  0;
def bearcount = if mode == -1 then bearcount[1] - 1 else 0;
plot line = if mode == 1 then bullcount else bearcount;
line.assignValueColor(if line > 0 then color.green else color.red);

April 26th, 2015, 11:38 AM

Ok I got that working. Is there a way I can make so the numbers sort from lowest to highest not discriminating by bull or bear but still hold colors. Like...

1 (green)
1 (red)
2 (red)
3 (green)

April 29th, 2015, 12:56 PM

pollux321

Ok I got that working. Is there a way I can make so the numbers sort from lowest to highest not discriminating by bull or bear but still hold colors. Like...

1 (green)
1 (red)
2 (red)
3 (green)

from line 10 to end...

def bearcount = if mode == -1 then bearcount[1] + 1 else 0;
plot line = if mode == 1 then bullcount else bearcount;
line.assignValueColor(if mode == 1 then color.green else color.red);

July 20th, 2018, 08:52 PM

Thanks for the script...very useful!
Doug

How to show bars ago cross for MACD

Discussion in ThinkOrSwim

How to show bars ago cross for MACD