Data importing problem

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

zobakos
Posts: 4
Joined: Tue Mar 07, 2017 3:11 pm

Data importing problem

Postby zobakos » Fri Mar 31, 2017 5:05 pm

Hello, I am trying to import some monthly series from excel ( but with exact dates like 24/02/2015 &17/03/2015) but eviews does not understand the exact date in daily frequency. Instead of 24/02/2015 eviews reads 3/2/2015.

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

Re: Data importing problem

Postby EViews Gareth » Fri Mar 31, 2017 5:10 pm

You'll need to provide the file.
Follow us on Twitter @IHSEViews

zobakos
Posts: 4
Joined: Tue Mar 07, 2017 3:11 pm

Re: Data importing problem

Postby zobakos » Fri Mar 31, 2017 5:15 pm

From CPI EU I want to import V159-V182 (dates) and Y159-182 (values) to the eviews file in the daily page
Attachments
eurusd2014-2016 - Copy.wf1
(311.21 KiB) Downloaded 68 times
cpi eu.xlsx
(29.36 KiB) Downloaded 70 times

zobakos
Posts: 4
Joined: Tue Mar 07, 2017 3:11 pm

Re: Data importing problem

Postby zobakos » Fri Mar 31, 2017 5:21 pm

To clarify something. I want to import the values at the specific dates so to create a series with the value at the date and 0 or NA in the rest days of the month until the next date from cpi and so on. You see my point ?

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

Re: Data importing problem

Postby EViews Gareth » Fri Mar 31, 2017 5:25 pm

I can't really see what's going on from your files.

But the general idea is that you would need to import monthly data into a monthly page, and have a date series on that page containing the actual dates. Then you can copy from that monthly page to the daily page, but not as a frequency conversion, but as a General Match Merge, using the date series from both pages as the matching ID.
Follow us on Twitter @IHSEViews

zobakos
Posts: 4
Joined: Tue Mar 07, 2017 3:11 pm

Re: Data importing problem

Postby zobakos » Fri Mar 31, 2017 5:43 pm

These are the values: (monthly)
16/10/2015 0
16/11/2015 0.001
16/12/2015 0.001

I want to create series that will go like: ( in the daily page)

16/11/2015 0.001
18/11/2015 0
19/11/2015 0
20/11/2015 0
until
16/12/2015 0.001
in between, I want to have the value 0

Is this working with general match merge?

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

Re: Data importing problem

Postby EViews Gareth » Fri Mar 31, 2017 10:47 pm

Yes
Follow us on Twitter @IHSEViews

Duke
Posts: 1
Joined: Wed Jan 09, 2019 6:13 am

Re: Data importing problem

Postby Duke » Tue Apr 16, 2019 5:10 am

To clarify something. I want to import the values at the specific dates so to create a series with the value at the date and 0 or NA in the rest days of the month until the next date from cpi and so on. You see my point ?


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 4 guests