How do I calculate the annual average log returns and stansard deviation from a series of monthly log returns?

I would like to extract annual avrage log returns and standard deviation from a dataset containing dates and monthly log returns. Do you know how to solve this? I have calculated the monthly log returns, how do I calculate the annual avrage and standard deviation. I guess I need some sort of loop function, taken in consideration the formula for log return.

thanks

Answer 1

[Akshit Agarwal]

Hi Lars-Martin,

MATLAB supports Vectorizing of your code, so you don't necessarily need to use any looping function.

You can import your data using load() if its a .mat file or readtable() for other files such as spreadsheets, text files etc.

And then accordingly you can pass the data to the built in functions such as standard deviation, exponential, average (mean), logarithm etc. that you might need for your problem statement.

You can search the documentation for any other functions if required.