Selecting end of month values out of daily time series

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

Flow
Posts: 1
Joined: Thu Jan 29, 2015 1:17 am

Selecting end of month values out of daily time series

Postby Flow » Thu Jan 29, 2015 2:16 am

Hi,

I am a new user of EViews 8. I imported a daily time series (5 days a week) from Excel. It works. How can I create a new series based upon the last (or the first) observation of each calendar month? Paste special/frequency conversion didn't work.
Example data:

1/02/1979 1.65194
1/03/1979 1.63116
1/04/1979 1.63128
1/05/1979 1.62994
1/08/1979 1.63587
1/09/1979 1.63164
1/10/1979 1.62897
1/11/1979 1.62318
1/12/1979 1.62293
1/15/1979 1.62035
1/16/1979 1.62701
1/17/1979 1.63232
1/18/1979 1.63593
1/19/1979 1.63344
1/22/1979 1.63192
1/23/1979 1.62959
1/24/1979 1.63175
1/25/1979 1.62414
1/26/1979 1.6278
1/29/1979 1.61932
1/30/1979 1.62047
1/31/1979 1.61352
2/01/1979 1.60556
2/02/1979 1.60506
2/05/1979 1.61788
2/06/1979 1.6213
2/07/1979 1.63727
2/08/1979 1.632
2/09/1979 1.63084
2/12/1979 1.62821
2/13/1979 1.62459
2/14/1979 1.62323
2/15/1979 1.62594
2/16/1979 1.62334
2/19/1979 1.62325
2/20/1979 1.62246
2/21/1979 1.6216
2/22/1979 1.6239
2/23/1979 1.62527
2/26/1979 1.62767
2/27/1979 1.62599
2/28/1979 1.62507

Thanks in advance!

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

Re: Selecting end of month values out of daily time series

Postby EViews Gareth » Thu Jan 29, 2015 9:16 am

Create a new monthly page, Copy the series over to that monthly page, and use "Last" as the conversion method.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests