How to Import Dividend Data into Google Sheets! (Get Real Time Dividend Tracking!)

[@Dividendology]

*UPDATE Finviz likes to occasionally change the order that their data tables are listed. At the time of this video, you had to import table 7. It is now table 9 that should be imported. So the new formula will look something like this: =importhtml("@t

[@rg1615]

Gives me an error, still, can't seem to figure this one out!

[@bennyeriksson1586]

@@rg1615 Try use ; instead of ,

[@zeipastel]

thank you , from Portugal

[@brandonproductions2575]

can you please write it out as it's not working

[@romeowhiskey1146]

Thanks for ADDING the FORMULA...

[@beardedbobsfishroom7654]

Finviz Dividend now shows div for the year as well as (% yield) how do we delete the % portion without compromising the data? I would like to use the values for other calculations.

[@vipuld8212]

I have the same question.

[@CourtneySoularie]

Thank you so much! I was having a lot of trouble getting other formulas to work but this worked like a charm for dividend yield, annual payout, payout ratio, etc. Subscribed :)

[@Dividendology]

I’m so glad it helped! Thanks!

[@jastr6877]

Thank you so much for your work!!!!

[@UltimateLooping]

you are a legend

[@Dividendology]

you're a legend!

[@OtherKindsofMoney]

Great video! Your trackers are awesome

[@goose-F16]

Div, are you still using this function?.. I tried it recently and getting a #ref on the index parameter wanting to see 0 to 1

[@Dividendology]

Nope! This is how I do it now: kzbin.info/www/bejne/gqK4qZ6ia6t-Z80si=5qIVD0WtMOCf6A-0

[@jivepatrol6833]

Very helpful video - thanks!

[@strangergranger10]

Do you know the formula for ex dividend date???

[@larsw6517]

When i want to divide that dividend with another number i can't do that because it isn't a number but a text. How can i change it so i can divide it by 4?

[@Dividendology]

You can certainly do that! All you would need to do is put the original formula in parentheses and then divide by 4. So the formula would look like this: =(substitute(SUBSTITUTE(index(importhtml("finviz.com/quote.ashx?t="&A27,"table",8),7,2),"*",""),"-","0.00"))/4 Hope that helps!

[@ncairsoft]

Thank you so much for this! Is there a way to track monthly dividends?

[@zackgilbert3109]

this was well explained. thank you

[@jonnya6738]

Great video man. I love dividends. New sub here

[@Wysiest]

Very appreciable video, I am struggling since a few days to find out a solution for these... However I try to get the same info for the european market (Euronext), do you know by any chance an equivalent of FINVIZ for european stocks ? Thanks a lot for your work

[@danielpelloquin9845]

What should I do if Finviz doesn't have the share?

[@Reza_Audio]

Hey thanks for sharing your information, I have an issue with some other datas like P/B or P/EG ratios. when I try do it for my sheet which contains lots of stocks, I get "N/A" for half of stocks and " - " for some which is not really available at the moment. the thing is for stocks I am talking about , the majority of them have these ratios in finviz, you know how to fix it? I would be happy to send you my sheet if you want to take a look at, i think some people have this common problem

[@liveingalway]

This is an awesome video and I think this channel will go big soon. I was wondering, would you make a video showing how to scrape a single data point (let's say industry) rather than a table from Yahoo Finance? Lots of people have looked for this video but there's no step-by-step out there! Anyway, thanks for these vids, it's a great sub.

[@Dividendology]

Thank you for the kind words! That’s a great idea for a video. I’ll add that to my list of videos to make and try to have it out soon. Thank you for the support!

[@ModestMillennial]

Great video buddy!

[@Dividendology]

Thanks! Glad you enjoyed!

[@gregerlindstrand1665]

How would the formula be for CIBUS ? Swedish company

[@rogersimpson1052]

Wow I have been trying to do this for years and this is the best explanation I have seen. Well done. I had to use table 7 to make the dividend scraping work. Did Finfiz change the table #?

[@Dividendology]

Yes, they have! Great catch.

[@Atahualpaelunico]

Thanks for this great video!! I don't know why but when I click enter the cell just stays "loading...".

[@Dividendology]

If you are trying to import large amounts of data, that will likely happen.

[@zeze9062]

love the video, but is there any chance we could import historical divided from, let's say 5 years ago?

[@Dividendology]

There is ways to do that! I know yahoo finance provides historical dividend data. You should be able to export that data into a spreadsheet. Maybe I’ll make a video on this in the future!

[@zeze9062]

@@Dividendology thank you for replying, I'm looking for spx500 data but the data doesn't seem to be downloadable since there's no export button there

[@adamoconnell1368]

Great video. Was wondering if you can tell me how to pull ex dividend and earning dates also.

[@Dividendology]

I believe ex dividend dates can be pull from finviz as well. I’ll have to look into earning dates.

[@catshorrorstitching5473]

So some of my ETF's aren't listed on finviz (maybe because they are Canadian), is there another website I can use in the forumla in my spreadsheet to get the same info?

[@Dividendology]

Great point! I’m looking into a solution for this problem.

[@deancarlson5992]

Was there ever an answer to this Canadian ETF dilemma? I'm trying to figure out the same thing.

[@kylecain6685]

Thanks for this! FYI, the table number has increased from 8 to 9!

[@Dividendology]

Awesome! Thanks for the update!

[@Sbennett76]

awesome formula and tutorial. finviz sucks. it wont work in my sheet. How do we get it to pull from yahoo or google?

[@mariomujica3339]

Thank you bro!

[@Dividendology]

No problem!

[@fraqqle]

Hi i Tried using your formula posted in the description and its telling me NA

[@callumhewson8514]

I keep getting an ERROR message :(( it says = "Function INDEX parameter 2 value is 7. Valid values are between 0 and 1 inclusive"

[@Dividendology]

I've corrected this on my current spreadsheets. I have some updated videos where you can see the formula.

[@chamindasilva3191]

Love it

[@siarheikaravai]

Does not work "Function INDEX parameter 2 value is 7. Valid values are between 0 and 1 inclusive."

[@SaraanInvesting]

thanks for the video

[@jimmygarcia1534]

How can I put like what I’m getting paid monthly,yearly ?

[@Dividendology]

Just take what your are getting paid each year in dividends and divide by 12!

[@Dividendology]

That will give you an average.

[@jimmygarcia1534]

@@Dividendology thank you very much

[@Ramme07]

​@@DividendologyBut is there a way not to get the average but the accurate monthly dividend value? Thx!

[@rolllimp]

How about if you want to do it for historical data

[@Dividendology]

Im creating a way to do this soon.

[@rolllimp]

@@Dividendology you're doing the lord's work

[@Dividendology]

haha thank you!

[@richardbender3784]

Doesn't work for me. I receive a notice and I have a "formula parse error."

[@Dividendology]

I've created updated methods on my channel. See how I build out stock watchlists on my channel.

[@MostafaAbdelaziz]

COULD YOU PUT THE LINK FOR YOUR NEW VIDEO HERE@@Dividendology

[@Daddywaah]

Hey Div, thanks for this video. I have managed to successfully scrape and strip my data into my google sheets thanks to this. One question I had though, does SUBSTITUTE only allow you to strip one character at a time (such as *) or can it do more than one at a time? I'm asking because I am pulling in data that results in something like *12.30%* and I want to strip the % sign as well.

[@Dividendology]

I believe you can use the substitute function twice in a formula. That should work.

[@Daddywaah]

@@Dividendology sounds hopeful, will try it out and see if I get lucky. Many thanks.

[@Daddywaah]

@@Dividendology You legend Div! This worked a treat. :D

[@gphil]

Has anyone else seen this code become inconsistent? I have a list of 50 tickets, many w dividends, use this code exactly, and yet only a handful populate?

[@chrstdvd]

T able changed to 11 as of 4-20-23

[@willbreece]

Muy interesante

[@motive8189]

table number has increased to 10.

[@MajestadePaa]

👏👏👏👏👏👏👏👏👏👏👏

[@kodepot7521]

doesn't work

[@Dividendology]

I use an updated version for my spreadsheets now.

[@kodepot7521]

@@Dividendology thanks for that info. Where do I find this new version? Is there a newer video I should be watching? This has been so frustrating trying to figure out and I can't believe google sheets and google finance can't make this super simple for us.