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
From excel to eview readable version
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
From excel to eview readable version
- Attachments
-
- Q.xlsx
- (1.75 MiB) Downloaded 269 times
-
- monthly.xlsx
- (4.61 MiB) Downloaded 276 times
-
- annual .xlsx
- (796.54 KiB) Downloaded 253 times
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: From excel to eview readable version
Did you try dragging and dropping the file onto EViews?
Sent from my iPhone using Tapatalk
Sent from my iPhone using Tapatalk
Re: From excel to eview readable version
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!
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: From excel to eview readable version
You're going to have to provide a lot more detail on what you're trying to do.
Follow us on Twitter @IHSEViews
Re: From excel to eview readable version
Ok.. thanks! To simplify the question, how to input many series from excel to eviews to match the original database format in eviews?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: From excel to eview readable version
Just drag the Excel file onto the workfile.
Follow us on Twitter @IHSEViews
-
- Posts: 4
- Joined: Thu Aug 03, 2017 4:01 am
Re: From excel to eview readable version
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
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
Who is online
Users browsing this forum: No registered users and 25 guests