Hi Team,
I am trying to compute time varying correaltions between x and y series via formular @cor(x,y, sample), say @now-100 ,@now
however once the time periods has been set , the formular automatically expressed as @cor(x,y, "8/04/2020 10/27/2020"), and does no change anymore as workfile sample range changes.
I can't find out which expression is able to fix such problem, please help.
with many thanks !
expression of time varying sample within formular
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: expression of time varying sample within formular
I think what you're saying is that you want to create a formula object with contains a single, repeated, value, where that value is equal to the correlation between the last 100 observations, and every day when you open the workfile, that value will be re-calculated, since the number of observations will have increased by one?
I can't think of a way to do that. Formula objects update when the underlying data changes, they are not dynamic with respect to samples.
You'd be better off writing a quick program that re-calculated the scalar, and just run the program each time.
I can't think of a way to do that. Formula objects update when the underlying data changes, they are not dynamic with respect to samples.
You'd be better off writing a quick program that re-calculated the scalar, and just run the program each time.
Follow us on Twitter @IHSEViews
Re: expression of time varying sample within formular
thanks for resonding so quickly, as i read many blogs in this forum, i think the better solutions would be: @trend to control time varying sample , or directily apply SSpace Kalman filtering to realise time varying values.
Many thanks !
Many thanks !
Who is online
Users browsing this forum: No registered users and 19 guests