creating an interval sample

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

murdoncio
Posts: 7
Joined: Mon Jun 07, 2010 10:56 am

creating an interval sample

Postby murdoncio » Mon Jun 07, 2010 11:12 am

Hi everyone, i´m very new in this program..... and probably my question is simple but i
I have a intraday data from 9:30 to 15:59, and i want to create 15-minutes intervals so i can see something like this: 9:30 9:45 10:00 ....

if someone could help me.... thanks!!!!!!!!!!

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

Re: creating an interval sample

Postby EViews Gareth » Mon Jun 07, 2010 11:16 am

You'll have to expand on what you mean by "create 15-minute intervals".

If you just want to create a new, empty, workfile with those intervals, you can do so by clicking on File->New->Workfile, and then setting the date specification to Intraday, etc...
Follow us on Twitter @IHSEViews

murdoncio
Posts: 7
Joined: Mon Jun 07, 2010 10:56 am

Re: creating an interval sample

Postby murdoncio » Mon Jun 07, 2010 11:37 am

i have this data, and i want to create a sample or a new page with 15 minutes intervals

8/01/1997 09:32 953.92
8/01/1997 09:33 953.60
8/01/1997 09:34 953.23
8/01/1997 09:35 952.76
8/01/1997 09:36 952.76
8/01/1997 09:37 952.55
8/01/1997 09:38 952.42
8/01/1997 09:39 952.42
8/01/1997 09:40 952.55
8/01/1997 09:41 952.77
8/01/1997 09:42 952.77
8/01/1997 09:43 952.87
8/01/1997 09:44 953.82
8/01/1997 09:45 955.05
8/01/1997 09:46 955.33
8/01/1997 09:47 955.05
8/01/1997 09:48 954.88
8/01/1997 09:49 954.78
8/01/1997 09:50 955.06
8/01/1997 09:51 955.16
8/01/1997 09:52 955.14
8/01/1997 09:53 955.18
8/01/1997 09:54 955.07
8/01/1997 09:55 954.94
8/01/1997 09:56 954.81
8/01/1997 09:57 954.65
8/01/1997 09:58 954.70
8/01/1997 09:59 954.65
8/01/1997 10:00 954.67

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

Re: creating an interval sample

Postby EViews Gareth » Mon Jun 07, 2010 11:55 am

To create a new page, click on the New Page tab at the bottom of the workfile, then Specify by Frequency/Range, then set the structure type to "Dated-regular Frequency", then set the Frequency to Intraday, then fill in the rest.
Follow us on Twitter @IHSEViews

murdoncio
Posts: 7
Joined: Mon Jun 07, 2010 10:56 am

Re: creating an interval sample

Postby murdoncio » Mon Jun 07, 2010 12:22 pm

ok.. i create the new page with te intervals and paste thhe data...... but the values are not ok... for example in the original data i have 955.05 at 9:45 and in the new page with 15 minutes intervals it chages to 954.96 and its the same with the other values....
ORIGINAL INTRADAY DAtA
8/01/1997 09:40 952.55
8/01/1997 09:41 952.77
8/01/1997 09:42 952.77
8/01/1997 09:43 952.87
8/01/1997 09:44 953.82
8/01/1997 09:45 955.05
8/01/1997 09:46 955.33
8/01/1997 09:47 955.05
8/01/1997 09:48 954.88
8/01/1997 09:49 954.78
8/01/1997 09:50 955.06
8/01/1997 09:51 955.16
8/01/1997 09:52 955.14
8/01/1997 09:53 955.18
8/01/1997 09:54 955.07
8/01/1997 09:55 954.94
8/01/1997 09:56 954.81
8/01/1997 09:57 954.65
8/01/1997 09:58 954.70
8/01/1997 09:59 954.65
8/01/1997 10:00 954.67
8/01/1997 10:01 954.74

DATA WITH 15 INTERVALS8/01/1997 09:30 NA
8/01/1997 09:45 954.96
8/01/1997 10:00 950.13

8/01/1997 10:15 941.30


Thanks Again!!!!!

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

creating an interval sample

Postby EViews Gareth » Mon Jun 07, 2010 12:40 pm

Again, what do you want the new data to be?
Follow us on Twitter @IHSEViews

murdoncio
Posts: 7
Joined: Mon Jun 07, 2010 10:56 am

Re: creating an interval sample

Postby murdoncio » Mon Jun 07, 2010 12:45 pm

i just want to do some statistics with a 15 minutes intervals..... the problem is that i have minute by minute data and i´ve been trying to do it but... as i said before the numbers don´t match....
Is there anyway to convert my data from minute by minute to 15 minutes intervals???

thanks

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

Re: creating an interval sample

Postby EViews Gareth » Mon Jun 07, 2010 1:14 pm

Yes, but you need to specify how you want to do the "conversion". Do you want to average, to sum, and so on...
Follow us on Twitter @IHSEViews

murdoncio
Posts: 7
Joined: Mon Jun 07, 2010 10:56 am

Re: creating an interval sample

Postby murdoncio » Mon Jun 07, 2010 1:32 pm

ahhhh ok... i just want the values as is.

for example my original data has
8/01/1997 09:45 955.05

i want the same value for the 15 minute interval
8/01/1997 09:45 955.05

sorry if i can´t explain myself...... thanks Gareth

murdoncio
Posts: 7
Joined: Mon Jun 07, 2010 10:56 am

Re: creating an interval sample

Postby murdoncio » Mon Jun 07, 2010 1:38 pm

it was with the first observation option.......

thanks a lot !!!!!!!!!!!!!!!!!!!!!!!!!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 22 guests