Download annual returns for stocks?

Discussion in 'Data Sets and Feeds' started by BrooksRimes, Aug 7, 2019.

  1. Just download daily returns and compare first day of year to last?
     
  2. Thanks for the post. It's an idea. What are you suggesting for the source? Individual downloads for hundreds of stocks is a lot of work, even automated. Then there is the problem of dividends. Yahoo Finance quotes have an Adjusted Close but using it only matches Morningstar returns for the most recent year. Prior year calculations don't match Morningstar returns. Looking for an easier way.
     
  3. MKTrader

    MKTrader

    Yeah, Yahoo Finance is a mess. I made some spreadsheets for returns and simple timing systems using ETFs a few year ago...and the ETF values were different every time I downloaded new ones.
     
  4. drm7

    drm7

    Look at Portfolio Visualizer. Go to "backtest portfolio" and put in your stocks. You can then look at annual returns (or monthly returns, etc.)

    portfoliovisualizer.com

    (I have no affiliation with this site.)
     
  5. Thanks for the post. I use PV, it's a great site, but I need the data for hundreds of stocks. That would be too labor intensive. They probably have limits on how many tickers you can enter, too.
     
  6. ph1l

    ph1l

    The attached mstr_total_return.csv with columns separated by semicolon and lines terminated with newline has the total return data downloaded from morningstar.com for current S&P 500 constituents.
     
    BrooksRimes likes this.
  7. nursebee

    nursebee

  8. Wow, thanks! That's great. How did you do that? Is there a way I can do it, keep it updated, and add additional tickers?
     
  9. #10     Aug 8, 2019