Hi
I am new to eviews and with a series of daily exchange rates, i am trying to calculate the mean of the returns only for the observations on a particular day, say only mondays, or tuesdays.
Can someone please help me?
Thanks
calculate the mean of returns only for a particular day
Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: calculate the mean of returns only for a particular day
Set the sample to be Mondays only, then calculate the mean:
where returns is the name of the series you're calculating the mean of.
Code: Select all
smpl if @weekday=1
scalar monmean = @mean(returns)
Re: calculate the mean of returns only for a particular day
thx loadzzz ! :)
Re: calculate the mean of returns only for a particular day
i am rily sry for disturbing u agen bt using the first command only, i fail to obtain the series with observations of Mondays only so that i can examine the descriptive statistics of this data set
thx
thx
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
calculate the mean of returns only for a particular day
What do you mean by you fail?
Re: calculate the mean of returns only for a particular day
i mean i did get the sample but not the series containing only the monday returns. I wish to examine the statistics for only monday returns, tuesday returns, wednesday returns and so on.
Thx
Thx
-
startz
- Non-normality and collinearity are NOT problems!
- Posts: 3798
- Joined: Wed Sep 17, 2008 2:25 pm
Re: calculate the mean of returns only for a particular day
How is your work file structured?
-
startz
- Non-normality and collinearity are NOT problems!
- Posts: 3798
- Joined: Wed Sep 17, 2008 2:25 pm
Re: calculate the mean of returns only for a particular day
All EViews workfiles have a structure: annual, monthly, "unstructured," etc.
Re: calculate the mean of returns only for a particular day
Oh ok... well its dated at daily frequency (7 day week).
-
startz
- Non-normality and collinearity are NOT problems!
- Posts: 3798
- Joined: Wed Sep 17, 2008 2:25 pm
Re: calculate the mean of returns only for a particular day
Code: Select all
smpl if @weekday=1Re: calculate the mean of returns only for a particular day
thanks... think i got it now
Who is online
Users browsing this forum: No registered users and 2 guests
