From excel to eview readable version

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

yw2555
Posts: 3
Joined: Mon Jul 31, 2017 4:29 pm

From excel to eview readable version

Postby yw2555 » Tue Aug 01, 2017 12:10 pm

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
Attachments
Q.xlsx
(1.75 MiB) Downloaded 268 times
monthly.xlsx
(4.61 MiB) Downloaded 273 times
annual .xlsx
(796.54 KiB) Downloaded 252 times

EViews Steve
EViews Developer
Posts: 788
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: From excel to eview readable version

Postby EViews Steve » Tue Aug 01, 2017 12:43 pm

Did you try dragging and dropping the file onto EViews?


Sent from my iPhone using Tapatalk

yw2555
Posts: 3
Joined: Mon Jul 31, 2017 4:29 pm

Re: From excel to eview readable version

Postby yw2555 » Tue Aug 01, 2017 1:01 pm

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!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: From excel to eview readable version

Postby EViews Gareth » Tue Aug 01, 2017 1:21 pm

You're going to have to provide a lot more detail on what you're trying to do.
Follow us on Twitter @IHSEViews

yw2555
Posts: 3
Joined: Mon Jul 31, 2017 4:29 pm

Re: From excel to eview readable version

Postby yw2555 » Tue Aug 01, 2017 3:38 pm

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: From excel to eview readable version

Postby EViews Gareth » Tue Aug 01, 2017 3:51 pm

Just drag the Excel file onto the workfile.
Follow us on Twitter @IHSEViews

destofante
Posts: 4
Joined: Thu Aug 03, 2017 4:01 am

Re: From excel to eview readable version

Postby destofante » Thu Aug 03, 2017 8:17 am

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


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 13 guests