Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: data processing (daily to yearly)
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: data processing (daily to yearly)
Date
Tue, 5 Apr 2011 08:10:55 +0100
Sounds like homework. Statalist does not encourage students to get
others to do their
assignments for them. See the FAQ.
On Tue, Apr 5, 2011 at 1:15 AM, Arlene Young (yi yang
<[email protected]>) wrote:
> We have met a data processing problem.
>
> We now have a series of daily trading data for all stocks listed from year 2000 to 2011. Our assignments are:
>
> (1) For each stock, keep only the data on the last trading day of each year;
>
> (2) For each year, accumulate the daily trading data of single stock as to obtain the mean value as the final trading data of this stock.
>
> As to the first requirement, we find it hard to locate the last trading day of each year, since it may be December 31th, or December 29,th or else.
>
> As to the second requirement, we have no idea which function or order to use as to accumulate the daily data, and finally count the mean value.
>
> Could anyone kindly help us to locate the target record, or to tell us how to compute the mean value?
>
> Thank you and best wishes!
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/