Where to get real history or emulated performance data of S&P500, VTSAX, NASDAQ100, DALIO-ALLWEATHER?
I have found S&P500 thats very available but what about these others ETF's has been hard to find data that goes back to 1920. I have added it to below excel.
I have made an excel here with the S&P500 and an estimate what $10000 would compound to when invested from birth of age groups. Child, parent, grandparent. I would like to make this for the above ETF's if you can help our or explain how to add it to this excel. Also if i have compounded correctly. All dividends/return should get reinvested. I'm planning on investing 10-100.000 myself with focus on compounding, so i want to estimate what kind of result each type of ETF would give with real relatable numbers. The plan is to add the money and leave for 20-50years with minimum to no effort. So need to know it would really pay off. I know past performance does not equal future performance, but i do think ETFs can get you an idea what to expect over 10-20 years. It least that it's unlikely to loose money. I would like to test this with many data sets with reliable data, i know a few mistakes can have major impact on the final number.
Hope some professionals out there would be willing to help or can link to some similar research. I like the random age-groups and periods in this test that can give you more relate-able numbers instead of the typical ideal 80 year S&P scenario examples.
Main questions i would like to have real numbers and a conclusion on:
Is volatility and sometimes 50% losses of the S&P500 worse than a more stable allweather folio, when 20year compounding is the main focus?
Are a lower but more stable return better than higher more volatility return when longterm compounding?
Would adding money in recessions have major positive impact on performance?
I'm very inspired by:
https://jlcollinsnh.comAnthony Robbins - Money master the game book with Ray Dalio.
In case it make you undestand better where i'm coming from. "Beginner passiv longterm index fund investing".
Excel:
https://drive.google.com/file/d/1WAxFQd0-8LgOxHTvFvMH9tU-52ZyGtve/view?usp=sharing