How to Import Dividend Data into Google Sheets
6 هزار بار بازدید -
10 ماه پیش
-
In this video, I show
In this video, I show you the easiest way to import live stock dividend data into your Google Sheets stock portfolio spreadsheets and trackers. This method utilizes HTML scrape formulas and does not require the need for using Google Chrome Addons or Plugins. This is the safest way to get the dividend data and protect yourself.
► Get FREE Stocks: https://linktr.ee/freemoneystocks
► Follow me on Instagram: Instagram: dkorecki
► Shop on Amazon: http://bit.ly/DKamazon
► Subscribe: http://bit.ly/youtubeDK
Google Sheets Formula: If you use these, please LIKE this video and COMMENT below
=(substitute(index(IMPORTHTML("https://ycharts.com/companies/"&B2&"/dividend","table", 1),2,6),"*",""))*1
=(substitute(index(IMPORTHTML("https://ycharts.com/companies/MMM/div...","table", 1),2,6),"*",""))*1
Google Sheet link: https://docs.google.com/spreadsheets/...
Finance Disclaimer:
►This is not financial advice. I am not a financial advisor. I am not suggesting or recommending you buy any of these stocks mentioned or shown in this video nor providing any financial advice of any kind. I am simply showcasing how to utilize Google Sheets more effectively. This video is meant for education and entertainment. I will not mention which of these stocks I own.
FTC Disclaimer:
►Using my Amazon Affiliate links listed above allows me to receive a small commission.
► Get FREE Stocks: https://linktr.ee/freemoneystocks
► Follow me on Instagram: Instagram: dkorecki
► Shop on Amazon: http://bit.ly/DKamazon
► Subscribe: http://bit.ly/youtubeDK
Google Sheets Formula: If you use these, please LIKE this video and COMMENT below
=(substitute(index(IMPORTHTML("https://ycharts.com/companies/"&B2&"/dividend","table", 1),2,6),"*",""))*1
=(substitute(index(IMPORTHTML("https://ycharts.com/companies/MMM/div...","table", 1),2,6),"*",""))*1
Google Sheet link: https://docs.google.com/spreadsheets/...
Finance Disclaimer:
►This is not financial advice. I am not a financial advisor. I am not suggesting or recommending you buy any of these stocks mentioned or shown in this video nor providing any financial advice of any kind. I am simply showcasing how to utilize Google Sheets more effectively. This video is meant for education and entertainment. I will not mention which of these stocks I own.
FTC Disclaimer:
►Using my Amazon Affiliate links listed above allows me to receive a small commission.
10 ماه پیش
در تاریخ 1402/09/01 منتشر شده
است.
6,093
بـار بازدید شده