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

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

saranya
Posts: 33
Joined: Wed Nov 16, 2016 5:51 am

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

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11926
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

saranya
Posts: 33
Joined: Wed Nov 16, 2016 5:51 am

### 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?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11926
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 1 guest