Basic Moving Average Calculation
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
Mohammad Abouali
on 9 Oct 2015
Edited: Mohammad Abouali
on 9 Oct 2015
movingAVGResult=conv(SData(:),ones(30,1)/30,'valid');
2 Comments
Mohammad Abouali
on 9 Oct 2015
Edited: Mohammad Abouali
on 9 Oct 2015
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.
More Answers (0)
See Also
Categories
Find more on Creating and Concatenating Matrices in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!