Convert table of Daily Stock data into Monthly data
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Fabian Niederreiter
am 12 Mär. 2021
Bearbeitet: Cris LaPierre
am 20 Mär. 2021
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.
Akzeptierte Antwort
Cris LaPierre
am 12 Mär. 2021
Use the date info as your groupvar.
6 Kommentare
Cris LaPierre
am 15 Mär. 2021
Bearbeitet: Cris LaPierre
am 20 Mär. 2021
It would appear that your grouping variable, dates, is not valid with the syntax you are using.
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.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!