Basic Moving Average Calculation
2 次查看(过去 30 天)
显示 更早的评论
Hi Everyone - Sorry if this question is poorly asked as I am a matlab rookie finally moving away from performing my calcs in excel. I have a 194 row array of stock prices (Ordered from newest to oldest), named "SData". I am trying to calculate the 30 day moving average, but I have been unable to do so and looking at other forums is just confusing me more. I would imagine that this is super basic, so I would appreciate any help. That calcs should stop at row 167 since there is not 30 days worth of prior data. Thanks in advance for your help!
Also, if any of my matlab lingo is off, feel free to berate me for it!
0 个评论
采纳的回答
Mohammad Abouali
2015-10-9
编辑:Mohammad Abouali
2015-10-9
movingAVGResult=conv(SData(:),ones(30,1)/30,'valid');
2 个评论
Mohammad Abouali
2015-10-9
编辑:Mohammad Abouali
2015-10-9
So when you say conv(A,b) pretty much slides b over A and multiplies element by element and then sums them up. So if you design the kernel properly, i.e. b, you can achieve different goals.
For simplicity, let's say you want to take the average over a window of 2 days, instead of 30 days. so your data is
[d1 d2 d3 d4 ...]
to the moving average with window size two you do:
avg1= (d1+d2)/2 or ([d1 d2]) .* ([1 1]/2)
avg2= (d2+d3)/2 or ([d2 d3]) .* ([1 1]/2)
....
so if you look pretty much you are moving [1 1]/2 over your data.
In your case you had 30 days so there are 30 ones in that bracket or ones(30,1)/30.
Note that the kernel is flipped when using convolution. however, since here we have symmetric kernel it doesn't matter. Cross-correlation does not flip the kernel.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!