How to calculate expected return based on historical data for Mean Variance Analysis

  • I've recently started reading some books on asset allocation and portfolio theory but I don't work in the field and don't have much knowledge yet.

    So I've been reading up on mean-variance analysis and my question is regarding the computation of the expected returns for a particular asset. From what I understand historical data is used to predict future returns. In the book that I'm currently reading, the author provides monthly returns for a particular stock and then we're asked to calculate the expected return for future months.

    My question is this, if i have historical open/close data for a particular stock, how do I use this information to calculate the returns? Since the return is based on the share price when the stock was purchased and the price when the it was sold, I'm not sure exactly what the calculation would look like.

    Did your last sentence get cut off?

    sorry, i was in mid-sentence when i was interrupted. :)

    Even if it is not precisely the question, I think the question raises another issue, which is "Does past returns provide a good estimate of future returns?" These protfolio allocation algos are good but IMO it is a bit easy to assume that we have a good estimate of the returns. If you give me a good estimate of the future return, let me manage your money, its not too hard. Rather than focusing on that, shouldn't we focus on how to forecast returns?

    @RockScience: yes, i've heard the same question asked many times, and have seen in many texts the pitfalls of relying on past returns to estimate future earnings. Although i'm aware of some of these pitfalls, i'm just getting started in this field and so having an understanding of some of the techniques, even if out of fashion, gives me something to cut my teeth on. While we're on the topic though, do you know of any good resources (links, books, etc.) that discuss how to forecast returns? Is that the type of problem time-series analysis would be used for?

    @miggety: There is no one best technique to forecast returns. It is the most difficult part of your model. Some take discretionary decisions, others trust machine learning like god. There is a lot of different things to explore. And yes definitely time series analysis is a good basis for this problem. Good luck

    @RockScience, thanks again for the info, very helpful! Sorry if these questions are basic, but I'm trying to understand what the different techniques for forecasting returns are and what those calculations would look like. Is there maybe one you could send me a link to or refer me to a book. The books i've been reading on portfolio theory mentions how the expected rate of return is used but I don't see anywhere in the content where they give examples of how to calculate this. They'll simply list out with returns and probabilities of those returns, but i'd like to see the calculations.

  • bill_080

    bill_080 Correct answer

    10 years ago

    Thanks Bill, i think that'll get me going in the right direction.

License under CC-BY-SA with attribution


Content dated before 7/24/2021 11:53 AM

Tags used