MATLAB: Sum rows in timetable

MATLAB and Simulink Student Suitetimetable sum timerange

I have a timetable with minutley reutrns.

In each row is a timestap and the return

I now want to calculate the daily returns as a sum of the returns within a day.

Any Ideas 🙂

Best Answer

Use the retime function.

Related Solutions

MATLAB: Function for day of the year

Introduced in R2014b

>> day( datetime('07-Jan-2017', 'InputFormat', 'dd-MMM-yyyy' ), 'dayofyear' )
ans =
     7

"accounting for leap years" If not, shame on The MathWorks!

>> day( datetime('01-Mar-2017', 'InputFormat', 'dd-MMM-yyyy' ), 'dayofyear' )
ans =
    60
>> day( datetime('01-Mar-2016', 'InputFormat', 'dd-MMM-yyyy' ), 'dayofyear' )
ans =
    61

MATLAB: Moving sum in a timetable

I'm a little bit confused what you're asking for, but here is a first attempt. As I understand you are looking for each row to have a sum of the next several doubles. That would be done something like:

for i = 1:size(data,1) % I don't know what your data variable is called, replace as needed
    if i+5<=size(data,1)
        data(i,3) = sum(data(i+1:i+5,2));
    elseif i+1<=size(data,1)
        data(i,3) = sum(data(i+1:end,2));
    else
        data(i,3) = NaN;
    end
end

I do not, off the top of my head, know a way to calculate a moving some without a loop in Matlab.

Best Answer

Related Solutions

MATLAB: Function for day of the year

MATLAB: Moving sum in a timetable

Related Question