Google Sheets - Backtesting Stocks

1 year ago
54

This video introduces the Google sheet I developed to perform backtesting on publicly traded stocks. Find out if you invested $2,200 in AAPL stock when they went public in 1980 what it would be worth today and other stocks as well.

Please like and comment.

Backtesting Google Sheet
https://docs.google.com/spreadsheets/d/1KYhtUTHpYcmJAr56bZSOU-ZKlj_xWwrIckz6F-8VjIM/edit?usp=sharing

Symbols provided by
https://www.eoddata.com/symbols.aspx

Backtesting: Definition, How It Works, and Downsides
https://www.investopedia.com/terms/b/backtesting.asp

What Is Annual Return? Definition and Example Calculation
https://www.investopedia.com/terms/a/annual-return.asp

Google Sheets - Dynamically Combine Sheets Video
https://rumble.com/v28xl0k-google-sheets-dynamically-combine-sheets.html

Introduction to Google Sheets Named Functions
https://rumble.com/v25qm9k-introduction-to-google-sheets-named-functions.html

Loading 1 comment...