Page 1 of 1

Live stat - percentage change

Posted: Mon Nov 20, 2017 11:51 pm
by tvonbrasch
Hi

Very often I want to compare the level of a series at some time with an earlier date. For example, I often write sentences such as: "Housing prices are now X per cent higher than in january 2017". But to find that number I typically have to use the @element function. for example:

Code: Select all

@elem(pbol_en_sa,"2017m10")/@elem(pbol_en_sa,"2017m01")-1
It would be nice if I could just hold in the CTRL button to mark two different cells in the spreadsheet view and then this statistic would be shown in the status bar as a part of live statistics.

Or maybe there is another and easier way to do this operation?
Thomas


pbol.PNG
pbol.PNG (18.14 KiB) Viewed 5249 times

Re: Live stat - percentage change

Posted: Mon Nov 27, 2017 9:51 am
by EViews Jason
Unfortunately our spreadsheets do not support non-sequential selections. You will have to continue manually performing the calculation.