Why does the cumulative sum of my financial time series change when I covert it from a daily to a monthly series in Financial Toolbox 3.6 (R2009a)?

3 views (last 30 days)
I created a daily time series and converted it to monthly using the TOMONTHLY function with the 'cumsum' cumulative sum calculation method as follows:
fts2mat(tomonthly(fints(dates,data),'calcmethod','cumsum'))
I noticed that the sum of the monthly data is not equal to the sum of the daily data.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 16 Sep 2009
By default, the TOMONTHLY function skips non-business days. Therefore, values associated with non-business days are not included in the cumulative sum.
To include all days, add the 'BusDays' flag and set it to 0.
For example:
fts2mat(tomonthly(fints(dates,data),'calcmethod','cumsum','BusDays',0))

More Answers (0)

Categories

Find more on Mathematics in Help Center and File Exchange

Products


Release

R2009a

Community Treasure Hunt

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

Start Hunting!