Data Not Updating
Posted: Fri Feb 28, 2020 11:50 am
I have a field that uses the following formula:
(myseries-@cummean(myseries,"1999m12 2019m12"))/@cumstdev(myseries,"1999m12 2019m12")
Eviews created the date range when I created the formula and "hardcoded" it so that I have to update it manually every month. This takes lots of time.
I would like to have the range equal to the entire series so long as there is data available. In other words, so that I don't have to keep updating the formula one at a time for each calculated series.
Is there a way to change this formula so that the date range is not "hardcoded?"
Thank you!
KC
(myseries-@cummean(myseries,"1999m12 2019m12"))/@cumstdev(myseries,"1999m12 2019m12")
Eviews created the date range when I created the formula and "hardcoded" it so that I have to update it manually every month. This takes lots of time.
I would like to have the range equal to the entire series so long as there is data available. In other words, so that I don't have to keep updating the formula one at a time for each calculated series.
Is there a way to change this formula so that the date range is not "hardcoded?"
Thank you!
KC