Page 1 of 1

Matching the average of the cubic spline interpolation to equal the high frequency data

Posted: Tue Jan 24, 2017 4:44 am
by saranya
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

Re: Matching the average of the cubic spline interpolation to equal the high frequency data

Posted: Tue Jan 24, 2017 8:33 am
by EViews Gareth
There is no built in way to do it, no.

Re: Matching the average of the cubic spline interpolation to equal the high frequency data

Posted: Mon Jan 30, 2017 1:56 am
by saranya
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?

Re: Matching the average of the cubic spline interpolation to equal the high frequency data

Posted: Mon Jan 30, 2017 8:36 am
by EViews Gareth
You can use the importtbl command to import the Excel codes into a table, then read them from the table.