Stock Analysis Project

Here is a project I made, utilising the Google Finance function, Google BigQuery, and Google Sheets. I first used the Google Finance function to pull the daily close prices of the current Top 10 stocks within the S&P 500, since the company first became public up until the 15th November 2024. I then imported this data into Google BigQuery, where I ran a query to calculate the annualized yearly returns of each of these stocks over the time period which they have been publically trading, and re  - imported that data into my final Google Sheet, where I created this dashboard. You are able to select the amount of years you would like to invest, the stock you would like to have invested in and the amount of money you would like to invest per month. The dashboard then calculates, based on the annualized return calculated by my SQL query, how much money the investments would appreciate to, at the end of that time period. The graph then shows, the difference between the principal investment, and the total of the investment including appreciation.