How to perform different RUNNING calculations on a financial Timetable.

1 次查看（过去 30 天）

Michel Rathé 2018-4-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393939-how-to-perform-different-running-calculations-on-a-financial-timetable

I have Stock data that I put in a Timetable. Several built in functions exists to perform calculations row by row for a SPECIFIC subset of data ex: tsmovavg (output = tsmovavg(tsobj,'e',timeperiod)) where timeperiod ex: 3 perform the calculation on the last 3 records. But, since those builtin functions are limited, I want to use other functions that could behave identically. For example, create a new variable that, for each row, would calculate the slope for the last 3 rows: coefficients = polyfit(A, B, 1); slope = coefficients(1)

Also, the trend based on the same 3 periods: mdl = fitlm(A,B,'linear'); Xnew = A; ypred = predict(mdl,Xnew);

Note that do not want to emphasize on the functions themselves but the ability to run through each row and perform a calculation base on n rows before and put the result in a new variable in my timetable, so at the end I'd have, for example, the slope at each rows BASED on the last 3 rows.

I'd like to use Matlab's power to not using loop and therefore reduce the numbers of code lines.

I reviewed a lot of possibilities, but none seems obvious but I'm shure there's a simpler way. Thanks all.