Data Info from Kaggle: https://www.kaggle.com/datasets/camnugent/sandp500/data
S&P 500 Stock Data: The dataset provides historical stock prices for companies in the S&P 500 index over the last five years, aiming to facilitate analysis and model building for potential financial payoff. The dataset was compiled using a script available on GitHub, and it includes updates accounting for changes in the S&P 500 index as of February 2018.
Formats: The data is available in two formats: Merged Data: all_stocks_5yr.csv - contains combined data for all stocks. Individual Data: individual_stocks_5yr folder - contains separate files for each stock, named by their ticker.
- Date: Stock price date in yy-mm-dd format.
- Open: Opening price of the stock in USD.
- High: Highest price reached during the day.
- Low Close: Lowest price reached during the day.
- Volume: Number of shares traded.
- Name: Stock's ticker symbol.
- Data Source: Due to volatility in Google Finance, the data was sourced from The Investor's Exchange API.
- Tools Used: Kaggle, GitHub, pandas_datareader, and The Market.
- Visualization Opportunities: Users can visualize price changes over time, compare multiple stocks, and generate new metrics.
- Analytical Potential: The dataset allows for the calculation of stock statistics such as volatility and moving averages.
- Challenge: Develop a model that can outperform the market and enable statistically informed trades.
- Scenario Analysis for Portfolio Stress Testing: "Financial Crisis Scenario". This scenario is particularly relevant because financial crises often have significant impacts on markets and can provide insights into how your portfolio might perform under extreme conditions. Objective: Evaluate how a significant economic downturn or financial crisis impacts your portfolio. This could involve a sudden market crash, a recession, or a severe economic downturn.
Key Assumptions: Market Drop: Assuming a substantial drop in stock prices. For example, a 30% decline in the closing prices of all stocks in the portfolio. Increased Volatility: During a financial crisis, market volatility often increases. This can be factored into your model by increasing the standard deviation of returns. Sector Impact: Different sectors may be affected differently. Consider how a crisis might impact various sectors in your portfolio. Objective: Evaluating the performance of financial portfolios under different economic scenarios.
- Value at Risk (VaR) and Conditional Value at Risk (CVaR)
Objective: Calculating and compare the Value at Risk (VaR) and Conditional Value at Risk (CVaR) for different portfolios.
Approach: Implementing historical simulation and Monte Carlo simulation techniques to estimate VaR and CVaR.
- Stress Testing with Factor Models
Objective: Useing factor models to stress test portfolios by simulating the impact of factor movements (e.g., interest rates, inflation) on portfolio returns.
Approach: Implementng multi-factor models (e.g., Fama-French) to analyze the sensitivity of portfolios to different economic factors.
- Liquidity Risk Assessment in Stress Testing
Objective: Assessing the liquidity risk of portfolios under stressed market conditions.
Approach: Developing models to simulate the impact of liquidity shocks on portfolio performance, considering factors like bid-ask spreads and trading volumes.