EViews.com

Hi all,

I just have excel data for eviews, is there anyone who knows how to let eviews read my excel. The attributes for each variable in current programming are as follows:


Name: C218ECPA( for example, C218ECPA is a name of the variable)
Display Name:
Last Update: Last updated: 07/31/17 - 18:34
Description: Bolivia: Exchange Rate: Par or Market (Average, Bolivianos/US$)
Source: IMF
Units: LC/US$

Remarks:


The attached file is the excel that I am trying to include to my current program.

Thank you!

Best,
Yan

Did you try dragging and dropping the file onto EViews?


Sent from my iPhone using Tapatalk

Hi thanks for the reply! I did try to do so! But I have to match my new data with my current data format.. that is my question ..my current data format was provided in my post!

You're going to have to provide a lot more detail on what you're trying to do.

Ok.. thanks! To simplify the question, how to input many series from excel to eviews to match the original database format in eviews?

Just drag the Excel file onto the workfile.

I am sure there are more elegant solutions, but here what I did under similar circumstances:

1. I create a workfile with three different pages, one for monthly, one for quarterly, and one for annual data; unimaginately, I named each page "Monthly", "Quarterly", and "Annual" respectively.

2. I wrote a quick routine along the lines:

pageselect Monthly
import C:\MyfilesA\Monthly.xlsm

pageselect Quarterly
import C:\MyfilesA\Quarterly.xlsm

pageselect Annual
import C:Myfiles\Annual.xlsm

DF