Track Your Stock Portfolio in Microsoft Excel 365

In this video, I'll show you how to track your stock portfolio in Microsoft Excel, and get real-time price updates from the Internet. We'll calculate our total profit and percent gain. This feature is only available for Microsoft 365 subscribers.

Xander from Omaha, Nebraska (a Gold Member) asks: A friend of mine told me that you can get current stock prices in Excel automatically. Can you show me how to do that?

Members

Members will learn how to format the stock data as a table which makes updates much easier. We will also see how to use conditional formatting to make the data easier to visualize. We'll see how to pick a stock when Excel doesn't guess the name correctly. Finally, we will record a macro and assign it to a button to refresh the stock data automatically.

•  Extended Cut Video - Silver
•  Gold Member Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

After This...

• Display Stock Portfolio in Microsoft Access!

Links

• Stocks for Older Excel Versions: https://599cd.com/XLB5
• Tables: https://599cd.com/XLB4
• Conditional Formatting: https://599cd.com/XLB2

Learn More!

• FREE Excel Beginner Level 1
• Excel Beginner Level 2 for $1.00
• Excel Forum
• Mailing List Notifications for New Videos

Questions?

Please feel free to post your questions or comments below. Thanks.

Keywords

tracking stocks in excel, get latest stock data in excel, stock portfolio, stock dashboard, pull live stock data, track your portfolio, investment portfolio tracker template, stock prices in excel, stock quotes