How to Import Dividend Data into Google Sheets

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.

• #howto_style
• #google_sheets
• #google_sheets_dividend_tracker
• #how_to_make_a_portfolio_tracker_in_google_sheets
• #how_to_get_dividend_data_in_google_sheets
• #how_to_import_dividend_data_into_google_sheets
• #how_to_make_a_dividend_income_tracker_in_google_sheets
• #google_finance_google_sheets_dividend
• #google_sheets_stock_tracker
• #import_dividend_data_into_google_sheets
• #dividend_investing
• #track_your_dividend_income_in_google_sheets
• #dividend_data_in_google_sheets