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?

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);

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)

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);

Thanks for the script...very useful!
Doug