How to Import Dividend Data into Google Sheets | 2025 UPDATE

Channel:

Danny Drives

Subscribers:

8,350

Published on April 24, 2025 2:28:44 PM ● Video Link: https://www.youtube.com/watch?v=G-QwdenMD8c

Duration: 0:00

121 views

7

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.

► Robinhood: Get $5–$200 in stock FREE: https://join.robinhood.com/danielk-592e84

Google Sheets ETF Formula:
=iferror(query(importhtml(CONCATENATE("https://stockanalysis.com/etf/",$A2,"/dividend/"),"table",1),"Select Col2 order by Col1 desc limit 1",""),"No Data")

Google Sheets Stock Formula:
=iferror(query(importhtml(CONCATENATE("https://stockanalysis.com/stocks/",$A5,"/dividend/"),"table",1),"Select Col2 order by Col1 desc limit 1",""),"No Data")

SUPPORT MY WORK
► Shop on Amazon: https://www.amazon.com/s?k=echo
► Coinbase: Get $10 Bitcoin FREE: https://coinbase.com/join/FUHQGL2?src=referral-link
► SwagBucks: Get $5 PayPal or Amazon FREE: https://www.swagbucks.com/profile/r_153250679?rp=1
► Robinhood: Get $5–$200 in stock FREE: https://join.robinhood.com/danielk-592e84
► Webull: Get 6-12 stocks FREE: https://a.webull.com/gzxterxUts7TssZ89U

SOCIAL LINKS
► Subscribe:
► Instagram: https://www.instagram.com/dkorecki

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 any of my affiliate links listed above may allow me to receive a small commission.