Python for Finance

Ryan O’Connell, CFA walks through how to use Python and Jupyter Notebooks in Microsoft Excel. You can use Python in Excel instead of VBA. He also shows how to install and use the PyXLL Excel add-in.

👨‍💼 Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: ryanoconnellfinance.com/freelance-finance-services/

🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/

Find the link to download PyXLL here:
https://www.pyxll.com/

Find the link to download Python here:
https://www.python.org/downloads/

In this tutorial, Ryan shows how you can retrieve free public financial data using Python and Alpha Vantage’s API. Then he shows how you can use the data to perform a DuPont Analysis.

🎓 *Columbia AI for Business & Finance Certificate Program* 🎓
► *Use code RYAN for up to $500 Off:* https://ryano.finance/columbia-ai

📈 *See Why I Recommend This Broker:* https://ryano.finance/ibkr-overview

💻 Find the code shown in this video here: https://ryanoconnellfinance.com/python-for-financial-analysis/

The link to download your own key from Alpha Vantage’s API can be found here:
https://www.alphavantage.co/support/#api-key

The documentation for Alpha Vantage’s API can be found here:
https://www.alphavantage.co/documentation/