Growing a Series
Posted: Tue Apr 19, 2016 2:11 pm
I have a series with some stock data that I want to grow at a given monthly rate.
The series (STOCK) has monthly data. I've created a scalar that holds my monthly growth rate (GROWTH).
I would like to create a second calculated series (STOCK_FORECAST) that starts with the last value in STOCK and grows it forward using the monthly growth rate (GROWTH).
Any help would be greatly appreciated!
The series (STOCK) has monthly data. I've created a scalar that holds my monthly growth rate (GROWTH).
I would like to create a second calculated series (STOCK_FORECAST) that starts with the last value in STOCK and grows it forward using the monthly growth rate (GROWTH).
Any help would be greatly appreciated!