01-03-2022, 11:20 PM
Help me properly model future probability based on historical data.
<!-- SC_OFF --><div class="md"><p>How can I use excel to count probabilities of future yearly returns of index based on 40 years of historical data. I specificaly need forecast of future decade based on historical data. I know there are many externalities that make it impossible to predict but i need just some framework upon which i can make my financial plan. For example websites backtest()curvo()eu makes excelent statistics of different etfs. I would like to make the same with excel. Thanks!</p> </div><!-- SC_ON --> submitted by <a href="https://www.reddit.com/user/medBrain"> /u/medBrain </a> <br/> <span><a href="https://www.reddit.com/r/investing/comments/rv63rc/help_me_properly_model_future_probability_based/">[link]</a></span> <span><a href="https://www.reddit.com/r/investing/comments/rv63rc/help_me_properly_model_future_probability_based/">[comments]</a></span>Kind Regards R
<!-- SC_OFF --><div class="md"><p>How can I use excel to count probabilities of future yearly returns of index based on 40 years of historical data. I specificaly need forecast of future decade based on historical data. I know there are many externalities that make it impossible to predict but i need just some framework upon which i can make my financial plan. For example websites backtest()curvo()eu makes excelent statistics of different etfs. I would like to make the same with excel. Thanks!</p> </div><!-- SC_ON --> submitted by <a href="https://www.reddit.com/user/medBrain"> /u/medBrain </a> <br/> <span><a href="https://www.reddit.com/r/investing/comments/rv63rc/help_me_properly_model_future_probability_based/">[link]</a></span> <span><a href="https://www.reddit.com/r/investing/comments/rv63rc/help_me_properly_model_future_probability_based/">[comments]</a></span>Kind Regards R