Скачать с ютуб Live Stock Portfolio Tracking: Different Exchanges & Currencies in Google Sheets в хорошем качестве

Live Stock Portfolio Tracking: Different Exchanges & Currencies in Google Sheets

Dive deep into live stock portfolio tracking with Ryan O'Connell, CFA, FRM, as he unveils the secrets to monitoring stocks across different exchanges and currencies using Google Sheets. Starting with an insightful introduction to exchanges and currencies, we'll explore how to utilize the =GOOGLEFINANCE() function to get stock prices in your base currency, retrieve real-time exchange rates, and effortlessly convert stock prices to US dollars. Whether you're a seasoned investor or just getting started, this tutorial simplifies the complexities of global portfolio management. 📈 See Why I Recommend This Broker International Stocks: https://ryano.finance/ibkr-overview 💾 Download Free Excel File Here: https://ryanoconnellfinance.com/produ... Chapters: 0:00 - Intro to Exchanges & Currencies in Google Sheets 1:17 - Get Stock Price in Base Currency w/ =GOOGLEFINANCE() 3:07 - Retrieve Exchange Rates Between Currencies 4:48 - Convert Stock Prices to US Dollar 6:06 - Calculate Total Position & Portfolio Values *Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC