Import data from Excel - Reverse chronological order

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

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

jbourque
Posts: 7
Joined: Tue Jul 05, 2011 8:26 am
Location: Ottawa, Ontario (Canada)
Contact:

Import data from Excel - Reverse chronological order

Postby jbourque » Wed Jul 06, 2011 7:01 am

Hi,
I would like ot know if there's a way that Eviews can import data that is in reverse chronological order in Excel? The data is a regular weekly time series, in columns, with the last value appearing first. Dates are in column A, data in column B.
Thanks for your help.
Attachments
OSB Prices.xlsx
(11.16 KiB) Downloaded 459 times

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

Re: Import data from Excel - Reverse chronological order

Postby EViews Gareth » Wed Jul 06, 2011 7:44 am

Sure. The only problem with that file is the first row and last row. If you tell EViews to ignore those rows (telling it to import the range A2 to B105), it will work fine.


Return to “Data Manipulation”

Who is online

Users browsing this forum: ruthhollies and 2 guests