I am trying to calculate the change in data from one year ago. I can use the CHANGE() formula but that returns a percent. I want to know the numeric change over a period.
FRED data has many index series. I want to know what the delta in the series is from a year/month/week ago. I don’t want to know the percent as that value makes no sense for what I am plotting. If the index was 23 a year ago and -5 today then I want the formula to return -28.
If anyone knows an existing formula that does this then please let me know. If anyone has created a script formula then I would like to see that script code.
Thanks. Andy