In this tutorial, I will show you the Excel Dividend & Portfolio Tracker I have built for you. All you need to do is to enter the Ticker Symbol, the number of shares you own as well as your average purchase price.
The Excel Spreadsheet is pulling the financial data from Yahoo Finance by using Python. It is not only limited to US stock. You could return any stock, cryptocurrency, forex, mutual fund & ETF data which is available on Yahoo Finance.
In this video, I will show you:
- how to use this template
- how you can build your own portfolio tracker from scratch
- and last but not least, how to customize this template to your needs and liking
I've developed some handy Excel add-ins that you might find useful:
- 📊 Dashboard Add-in: Easily create interactive and visually appealing dashboards.
- 🎨 Cartoon Charts Add-In: Create engaging and fun cartoon-style charts.
- 🤪 Emoji Add-in: Add a touch of fun to your spreadsheets with emojis.
- 🛠️ MyToolBelt Add-in: A versatile toolbelt for Excel, featuring:
- Creation of Pandas DataFrames and Jupyter Notebooks from Excel ranges
- ChatGPT integration for advanced data analysis
- And much more!
- 📺 YouTube: CodingIsFun
- 🌐 Website: PythonAndVBA
- 💬 Discord: Join the Community
- 💼 LinkedIn: Sven Bosau
- 📸 Instagram: sven_bosau
If you appreciate the project and wish to encourage its continued development, consider supporting my work.
For feedback, suggestions, or potential collaboration opportunities, reach out at contact@pythonandvba.com.
If you have any feedback, please reach out to me at contact@pythonandvba.com