Info

此问题已关闭。 请重新打开它进行编辑或回答。

cell/vector operation to replace excel operation

2 次查看（过去 30 天）
liu James
liu James 2016-11-24
关闭： MATLAB Answer Bot 2021-8-20
I'm trying to convert simple math operations that can be done in excel into matlab language/script. Basically I'm trying to perform a moving average and need to loop N back into the equation while I calculate each N with the according date associated it. Where TR is the true range for that date. N1=sum(h4:h23)/20,N2=(19*N1 +TR2)/20,N3=(19*N2 +TR3)/20,N4=(19*N3 +TR4)/20.....where TR1=max(E4:G4), TR2=max(E5:G5)....N:end is basically a moving average of 20 days with formula of N=(19*previous N + TR)/20.

此问题已关闭。

回答（1 个）

Image Analyst
Image Analyst 2016-11-24
Try movmean().

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by