working on a script and trying to see how to have it find the increase in price for last 3 months, 6 months, 1 year and 2 years.

[davidbespoke]

I see how to have it track trading days, but I want it to track by the timeframe.

 

[SleepyZ]

I see how to have it track trading days, but I want it to track by the timeframe.

This should help. If you want to use different closes for prior month end figures, select input debug = yes and find the close per how they were done in the code and make any changes similarly.

def month    = GetMonth();
def candles  = !IsNaN(close);
def capture  = candles and month != month[1];
def moCount  = CompoundValue(1, if capture then moCount[1] + 1 else moCount[1], 0);
def thismo   = (HighestAll(moCount) - moCount) ;

def close3   = if thismo[1] == 4 and thismo == 3 then close[1] else close3[1];
def close6   = if thismo[1] == 7 and thismo == 6 then close[1] else close6[1];
def close12  = if thismo[1] == 13 and thismo == 12 then close[1] else close12[1];
def close24  = if thismo[1] == 25 and thismo == 24 then close[1] else close24[1];


AddLabel(1, "3mo " + ": " + close + "/" + close3 + " = " + (AsPercent(close / close3)), if ((close / close3)) < 1 then Color.PINK else Color.LIGHT_GREEN );
AddLabel(1, "6mo " + ": " + close + "/" + close6 + " = " + (AsPercent(close / close6)), if ((close / close6)) < 1 then Color.PINK else Color.LIGHT_GREEN );
AddLabel(1, "12mo " + ": " + close + "/" + close12 + " = " + (AsPercent(close / close12)), if ((close / close12)) < 1 then Color.PINK else Color.LIGHT_GREEN );
AddLabel(1, "24mo " + ": " + close + "/" + close24 + " = " + (AsPercent(close / close24)), if ((close / close24)) < 1 then Color.PINK else Color.LIGHT_GREEN );

input debug = no;
plot x = if !debug then double.nan else thismo;
x.SetPaintingStrategy(PaintingStrategy.VALUES_BELOW);

 

[Mutagenix]

I see how to have it track trading days, but I want it to track by the timeframe.

I repurposed one of the codes I use for daily price movement to fetch movement by time frame.

plot x = Round(100 * ((close / close[255) - 1), 1);

That will return % gain or loss as a custom watchlist column for a year +/- a few days.

If you're wondering why I used 255 days, it's to account for weekends. I was trying to figure out
why the results didn't match the chart and then it hit me. So if you're adjusting for a period of months,
make sure to remova ~8 days per month (plus any holidays) to get accurate results.

Edit: I just re-read your above post and saw that you're trying to track specific timeframes.
You can do this manually by adjusting the above code to the following:

plot x = Round(100 * ((close / open) - 1), 1);

x.AssignValueColor( if x < 0 then Color.ORANGE else Color.CYAN);

Run the code as a custom wathlist column but set aggregation to yearly/monthly/etc in the editor
dropdown menu. Try it out!