清空筛选条件
清空筛选条件

Convert table of Daily Stock data into Monthly data

1 次查看（过去 30 天）
Fabian Niederreiter
编辑： Cris LaPierre 2021-3-20
I have a 13000x3000 table with colums representing the dates and rows representing the stocks with values of daily stock returns in it.
Now I'd like to get the monthly sum of returns for each stock (each line).
Would appreciate any kind of help.

请先登录，再回答此问题。

采纳的回答

Cris LaPierre
Cris LaPierre 2021-3-12
Look into groupsummary.
G = groupsummary(T,groupvars,groupbins,method)
Use the date info as your groupvar.
Use the appropriate value for your groupbin (sounds like you want 'monthly').
Specify the desired method (sounds like you want 'sum')
  6 个评论
显示 4更早的评论
Cris LaPierre
Cris LaPierre 2021-3-15
编辑：Cris LaPierre 2021-3-20
It would appear that your grouping variable, dates, is not valid with the syntax you are using.
B = groupsummary(A,groupvars,groupbins,method)
When you use the table form, your grouping variable needs to be a variable in the table. Try adding dates as a new column in your table rather than as the rownames.
G_CRSP.dates = dates;
Then your groupsummary statement should work.
Fabian Niederreiter
Fabian Niederreiter 2021-3-20
Thanks for your help Chris! With some adjustments to my data I managed to make it work with the help of groupsummary. :)

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by