This project grabs a Kaggle dataset that oulines the historical stock data for all current S&P 500 companies. This dataset include data up to Feb 2018. (https://www.kaggle.com/datasets/camnugent/sandp500).
In fiancial worlds, people are interested in finding out the return of an investment they made, and stock price growth is a great indicator for measuring this. Therefore, in project 1, I'm trying to output the growth rate of a company by inputing its specific stock ticker.
README.md
Makefile
requirements.txt
.devcontainer
helpers.py
querydb.py
query_sql_db.py
databricks clusters list --output JSON | jq
databricks fs ls dbfs:/
databricks jobs list --output JSON | jq
By typing "/" + "ticker name" after the URL, you'll get the growth of the stock price of a specific company over the past five years, which could provide us with a good indicator of whether a compnay is an ideal investment target.
More financial analysis about this S&P 500 stock dataset including daily return of stock price return, moving average of stock price and stock price forecasting will be updated sooner...