Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: data processing (daily to yearly)

From   yi yang <>
Subject   st: data processing (daily to yearly)
Date   Tue, 5 Apr 2011 08:15:58 +0800 (CST)

Hi everyone,
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! 

Arlene Young

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index