time series data manipulation

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

satish1987
Posts: 2
Joined: Sun Oct 02, 2011 8:11 pm

time series data manipulation

Postby satish1987 » Sun Oct 02, 2011 8:16 pm

hi guys,

I am new to eviews , i am having some trouble with declaring and manipulating time series variables. I have a time series data and i want to use this formula to create a new variable.

stock= stock(t)-stock(t-1)

My data is quarterly so i just used the formula stock= stock(1)-stock(-1) thinking it might work. What eviews did was subtract the third quarter with my first quarter instead of the second with first! Is my formula wrong? if so please help!

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

Re: time series data manipulation

Postby EViews Gareth » Sun Oct 02, 2011 9:13 pm

What does:

Code: Select all

stock= stock(t)-stock(t-1)
mean?

satish1987
Posts: 2
Joined: Sun Oct 02, 2011 8:11 pm

Re: time series data manipulation

Postby satish1987 » Mon Oct 03, 2011 2:52 am

basically i have a data like this

q1 4
q2 5
q3 2
q4 3

and i want to create a new variable which basically subtracts current period by previous period. For this sample i would get three observations.

1) q2-q1 1
2) q3-q2 -3
3) q4-q3 1

In order to do this i need to enter a formula to help me , i want help with that!

Thanks!

sat

startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Re: time series data manipulation

Postby startz » Mon Oct 03, 2011 6:26 am

q -q(-1)

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

Re: time series data manipulation

Postby EViews Gareth » Fri Nov 18, 2011 8:47 am

We can only help if you tell us what it is you're trying to do.

drhal
Posts: 1
Joined: Sun Jan 01, 2012 7:30 pm
Contact:

Re: time series data manipulation

Postby drhal » Sun Jan 01, 2012 7:36 pm

when i use q-q(-1) ........what does the -1 stand for?......
Last edited by drhal on Mon Jul 23, 2012 7:18 pm, edited 2 times in total.

startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Re: time series data manipulation

Postby startz » Sun Jan 01, 2012 10:05 pm

when i use q-q(-1) ..what does the -1 stand for?
One period lag.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests