Info

La pregunta está cerrada. Vuélvala a abrir para editarla o responderla.

cell/vector operation to replace excel operation

2 visualizaciones (últimos 30 días)
liu James
liu James el 24 de Nov. de 2016
Cerrada: MATLAB Answer Bot el 20 de Ag. de 2021
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.

Respuestas (1)

Image Analyst
Image Analyst el 24 de Nov. de 2016
Try movmean().

La pregunta está cerrada.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by