SnPy-500

Automated Equal-Weight S&P 500 Index Fund Portfolio Optimization

This project is designed to automate the process of creating an equal-weight S&P 500 index fund portfolio for a given portfolio size. It uses Python, together with various libraries such as Pandas, Numpy, Requests, and Xlsxwriter. The program fetches stock information for all S&P 500 constituents from Yahoo Finance API, calculates the number of shares to buy based on equal-weight position size, and outputs a recommended trades Excel file.

The purpose of this project is to provide a simple and automated way to create an equal-weight S&P 500 index fund portfolio for investors. The program fetches the latest stock information from Yahoo Finance API, calculates the number of shares to buy based on equal-weight position size, and outputs a recommended trades file that can be used to buy the selected stocks.

Click the embed github link above to see the full project files.