Hi,
I wanted to convert an annual series to quarterly using cubic spline interpolation in such a way that the average of the cubic interpolation for the year equal exactly the series at an annual basis.
lets say:
What I have currently: Data from 2010 to 2015 in annual terms. ----- (1)
I need the same data in quarterly series-- for which I do a cubic spline interpolation. Now I get data from 2010 q1 to 2015 q1. (By using Match = first) ---(2)
what I need: average of the cubic spline for each year should equal the annual series-- ie the average of data for each year in (2) should exactly equal the annual series we have in (1)
Is this possible via EViews?
Hoping to receive a reply soon
Matching the average of the cubic spline interpolation to equal the high frequency data
Moderators: EViews Gareth, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Matching the average of the cubic spline interpolation to equal the high frequency data
There is no built in way to do it, no.
Follow us on Twitter @IHSEViews
Re: Matching the average of the cubic spline interpolation to equal the high frequency data
Thanks Gareth. Also, is it possible to take some text from an excel spread sheet to eviews? For instance, I want some bloomberg or haver based codes incorporated in the fetch functionality. i.e, I want to make the codes dynamic and thereby allow the user to delete or add any codes of the data series to the excel sheet instead of doing the same in E-views based programme. Is it possible?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Matching the average of the cubic spline interpolation to equal the high frequency data
You can use the importtbl command to import the Excel codes into a table, then read them from the table.
Follow us on Twitter @IHSEViews
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: No registered users and 14 guests