How to create series that sums other series for particular date?

[shunkar]

Hello,
I am trying to create my own stock market index that is aggregate of all stocks' trade data within a particular stock market. I have multiple markets with multiple stocks in each. Let's say I want to create a series that sums number of all traded stocks (volume) for each trading day. How can I do it in eviews v8.1?

Assume that for market="US" I have series VOL (number of stocks traded for a given day) for stocks X,Y, and Z for dates Date:t, Date:t+1, and Date:t+n.
I need to create a series of US_inx_vol that sums VOL of all stocks for each date (total number of stocks traded for a given day).

If I use excel SUMIF function then I would type =sumif(range of multiple stocks data for a period; Date; VOL) near each Date on the vector.

PS: Also, if it won't complicate it much, how to weight each additional component. In the example above, all stocks have same impact on the index. Is it possible to weight variables by market capitalization before summing? Let's say I want to estimate weighted average of PE ratio for all stocks in a market.

[startz]

Code: Select all

series US_inx_vol= volx + voly + volz

series US_inx_vol = .4*volx + .3*boly + .3*volz

[shunkar]

Thank you for such swift reply. Although it is helpful as it clearifies that dates are automatically matched, it is not exactly what I was asking. I have over three thousands stocks in each market and I have dozen markets. It will be very difficult to type one by one each stock in the formula. How can I use SUMIF function for stocks from the same market. Something like: if market="US" then sum VOL. Same for other markets.

[EViews Gareth]

Code: Select all

series mysum = @sumsby(vol, market)


[shunkar]

Thank you. That's what I was looking for.