Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Rolling calendar estimates

From   Nick Winter <[email protected]>
To   [email protected]
Subject   Re: st: Rolling calendar estimates
Date   Tue, 22 Mar 2005 14:13:32 -0500

I believe -mvsumm- will give you what you want.

  . ssc describe mvsumm

to see a description

--Nick Winter

At 02:00 PM 3/22/2005 -0500, you wrote:

I have a dataset of companies' stock returns on a daily basis. It is easy to calculate the standard deviation of the returns for each company per year, using:

egen sigma = sd(ret), by (firmyear)

However, if I wish to do a rolling estimate giving the standard deviation of the last actual rather than calendar year (e.g. if today is 22 March I want the standard deviation from 22 Mar 04 to 21 Mar 05, not from 1 Jan 04 to 31 Dec 05), is there an easy way to do that? If I know there are 252 trading days per year, can I just ask it to calculate the std dev of the last 252 options? I'd like to do something like

egen sigma = sd(ret[_n-252]:ret[_n-1]) if firm[_n-252] == firm[_n]

but it doesn't seem to allow anything like that.

Many thanks,

FREE pop-up blocking with the new MSN Toolbar � get it now!

* For searches and help try:
Nicholas Winter 607.255.8819 t
Assistant Professor 607.255.4530 f
Department of Government [email protected] e
308 White Hall w
Cornell University
Ithaca, NY 14853-4601

* For searches and help try:

© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index