How To Pull Dividend Data Into Google Sheets

[@nikhil06472]

Thanks for the code. If anyone is getting a REF error, please update table number to 7 and the issue will be resolved. The table number is updated since this video was uploaded.

[@JohnnyWalkerYT]

thanks man, literally came back because of that

[@levanberdze]

I am still getting error loading data...

[@That1Fam]

It says “parameter 2 value is 8. Valid values are between 0 and 2.”

[@thecantstopwontstopentrepr4156]

Table number is 9 now.

[@petera4640]

@@thecantstopwontstopentrepr4156 Legend!

[@sarubinca]

I copied and pasted your revised function. I get an error: "Function ERROR parameter 2 value is 8. Valid values are between 0 and 1 inclusive." Any correction to this?

[@dariusdeg]

Table has changed on finviz page. Now you need to change after "table" must be 10 not 9

[@KaiRush]

No...You rock!!! This was so easy. I read over 20 blogs and the steps were so out there. You made it so easy! Thank you and I hit "Subscribe."

[@grezm0nkey]

made personal sheet in 2015 and for the life of me couldnt accomplish or find solution till now, many many thx, hats off to you.....cheers

[@stevenfair3992]

This is amazing. I’ve been trying to do this for months and was completely stuck on it. I can’t wait to incorporate this into my spreadsheet. Thank you.

[@ThinkStocks]

You're welcome!

[@pressrepeat2000]

Super useful. Much better than similar videos because you go through the formula so clearly. Subscribed!

[@maggiekreuzkamp6193]

you saved my life. I've been trying to figure this out all day and you helped me in 5 mins. You rock

[@ionelmitel9835]

Thank you. I tried multiple things, but your solution is simple and works perfectly

[@brucecampbell208]

I cant thank you enough for making this video. I was trying to figure this out for many hours. 5 stars for your content.

[@dentontay]

Thanks, this was great! I saw your last video about pulling the dividend amount, and I couldn't get the formula to work. I used this one, adjusting row, column, and my personal spreadsheet cell, and it works great. Awesome!

[@ThinkStocks]

Thanks! And glad it works for you!

[@IbadassI]

I wish I could like this 100 times! You've earned a subscription from me. I can put this into a dividend calendar and it will tell me where to concentrate my money every month so I maximise the dividend payout instead of spreading it everywhere at the same time. This will boost my dividends snowball! Thank you so so much!

[@TradingWithCJ]

Great tips man! Having it all in documentation is great to see and track those dividends!

[@Zues64]

This was helpful, thank you. Can you advise how i determine what the table number is if i choose a different html website ?

[@junabad3412]

Super Cool! Just followed all your steps and got what i needed. More blessings to you.

[@masterbaitt]

Another enhancement we can do in this, is to multiply the shares with dividend amount when it is declared and log the date and dividend amount in history tab for the shares I currently hold and add it to the dashboard as dividend received. This thing no one has done it yet, so I'll be working on it and let you know if got success. Btw thanks for this, now I have something which can be improved further.

[@oleksiiavramchuk7726]

hey! Any progress on that? I was thinking the same.

[@denisjose5993]

Thanks brother. You have made my life much much much easier now!!. Super love your video here. Thank you so much for the info and looking forward to seeing more of your videos here! Cheers

[@akshatrastogi9063]

Man u r genius, I have been looking for this forever!

[@joelpolese]

Pretty useful! I was looking for this solutions for months...Thanks! Subscribed

[@svbhave]

As of April 21, 2023 it's Table 10.

[@Mostafizur_rahman188]

Thank you

[@erickkillian5590]

As of 6/20/2024, it’s still Table 10

[@ThinkStocks]

***FINVIZ UPDATE*** Hey everyone! Finviz likes to change around its backend code and the table we are pulling from will change every now and then. When I made this video the table we were pulling from was table 9. Now it changed to table 7! If your code doesn't work its because they changed around the tables, but it is usually a very easy fix!

[@supersaiefull]

Hi, how can we figure out the table number?

[@cfii2fly]

Yay having a hard time getting the correct table number

[@thekid2003]

I don't see how you can tell the table number for the chart? How do you know it is say table 7 vs table 8 or 1 for that matter, Thanks. Love the instruction!!

[@ThinkStocks]

Great question and unfortunately I don't have an answer to it. Not sure if anyone does yet! It's all trial and error! I've had several of my coder friends try to figure it out too and nothing. But its been table 8 for a while now so hopefully it stays that way!

[@vortac2k9]

Ok... yes, EX-Dividend date is the hardest one, and it became even harder for me...wonder if you have some code or formula to fix this? Here it is: Seems like the YAHOO Finance tables don’t follow a pattern in terms of the information available.... meaning that the same cell either has different data if dividend information is not available, so they fill it with other stats. As a result when I export to my sheet, some numbers are correct (ex. 44721), some are from other data (ex. 0.00634) and some give you and N/A error message because the cell has no data... The challenge is: how to filter ONLY the data that has numbers like 44127 (which will yield the correct date when converted) and just display a “-“ character for either an error message or any number not resembling 44286 for example I hope I didn’t confuse you too much, but your help would be much appreciated

[@swedesam]

Dude!!, this was epic and helpful beyond words. I'm working on a dividend stock screener/tracker and this is perfect.

[@giandigiandomenico9179]

Good, but Finviz doesn't have a complete listing of dividend paying stocks on the TSX. Could you suggest another screener that pull dividend data from the TSX please?

[@Fadliadiputra]

Hello have you found out another website that can use this method?

[@carlosfernandoam]

Got a #REF error when trying it first, but I corrected it by typing 8 instead of 9 (the one that goes after "table", ). In case someone else had the same problem ;)

[@carlosfernandoam]

Talking about the first Dividend Yield formula.

[@JohnnyWalkerYT]

thanks man, got the same thing

[@cheetah-virusxi7560]

Thank you,was getting the same problem

[@Razorhead12345]

does it still run? can you copy the formula in here? for me it doesnt run with 9 and 8 and other numbers. TY

[@justin3814]

@@Razorhead12345 same Did u find the solution?

[@Babymem15]

How do you know that it's table 9 on finviz? What if they change their site up? How would we find that?

[@adamstruss7434]

How do you know what number to plug in for the table that will be pulled from finviz? Not the rows and columns but the actual table. I'm also having an issue where it is telling me I can only use numbers 0 or 1 for rows and columns. Thanks so much!

[@georgebruno9846]

Thanks for the very valuable information. Is there any way formula for getting Dividend Payout Date.

[@Pegaroo_]

Ex-dividend date formula =index(importhtml(Concatenate("YAHOO WEB ADDRESS",A2),"table",2),7,2) you'll need to replace YAHOO WEB ADDRESS with what's shown at 9:36

[@northinvestor]

it doesn't work

[@Pegaroo_]

@@northinvestor well you'll just need to copy it from the video then

[@Pegaroo_]

@@EpicTalesHub-d7z I've just spotted a typo in my original post, I had B2 where it should be A2 so formula was looking at wrong cell to get ticker

[@omarfuentes2856]

You are the man for my spreadsheet nightmare. Subscribed! Thanks and take care

[@ThinkStocks]

Thanks for the sub!

[@et_phonehome_2822]

Thanks, the best detailed explanation ever. 👍🏻

[@Thomas-il6el]

Thanks a lot. I saw it on a blog, but with a vidéo, this is day better ! 👌🏻👍🏻

[@gastonibanez7349]

Thanks for the video. It took me some tries to make the code work, but I finally did it today.

[@ThinkStocks]

Thats awesome, glad it works for you!

[@bldrmtnman]

Good work! You mentioned payday, whereas the Ex-dividend date is not actually the pay date, it is the date you have to be invested in the underlying, to get paid on the actual pay date. Just to clarify. Thanks for your work! I guess the tables have been changed again as the link no longer works. in native Windows, the options for selecting tables is available, but not in the Mac version 365, much to my dismay.

[@strowie1697]

AYO NO CAP THIS WAS MAD HELPFUL, I ALWAYS WONDERED HOW PEOPLE GET THE DATE OMG TYSM TYSM TYSM TYS

[@EricaDyson]

You're so right. I just couldn't get the importxml function to work with Yahoo Finance data. A mega mega mega thanks.

[@darkpaladin4917]

you're awesome, huge thanks for all your hard work in sharing your wisdom

[@callumhewson8514]

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

[@theintelligentinvestor300]

Hello my friend could you please explain me the first number that you have wrote after "table" ?? how do you know that this is the number to choose ? Thanks you so much

[@jorgp.1966]

have the same question

[@jeevanmangalya]

unable to get data from yahoo finance, can you help me in this regard

[@hectormunoz4812]

You went hard on this video and thanks for the updated code it was exactly what I needed. Thank you sir

[@craigschleppi2573]

You are a god send. I have been looking for this information! Thanks

[@bngolfin]

As someone pointed out to get the dividend payout you now use table 10 instead of nine. Now the dividend date on yahoo has changed, has anyone figured this out yet? Thanks

[@1stFoxmovie]

I have a problem with the exdate. Idk what I have done wrong but I am getting a "loading" error and no result....

[@NaveedAhmad-zg3rd]

Hi Mate, I am having this error message each time I load the code. I have checked everything but nothing. Can you please help? Error Function MULTIPLY parameter 1 expects number values. But '-' is a text and cannot be coerced to a number

[@Mostafizur_rahman188]

Very helpful video, "Subscribed". Hoping to learn a lot from this channel.

[@philiptran617]

Thank you so much for posting this. This is very helpful. :)

[@AutomationMaestro]

THe Ex div date from Yahoo isn't working for me. Could you please place the formula in the comments?

[@KaiRush]

I am teacher and I am telling you...you can teach! Keep making videos! Do you have any videos on how to do covered calls, if you already own 100 shares of a stock?

[@ThinkStocks]

Thanks! And not yet but thats a good idea for a video!

[@aarthiarun9440]

exactly what I needed. Thank u so much !

[@vipinarora9]

Hi, Just watched your video. This is amazing, you used hidden techniques to get this data. Thank you for making this video.

[@ThinkStocks]

My pleasure, glad you liked it!

[@Pharaoo2012]

Great explanation, thanks a lot. Can we do this with MSFT Excel?

[@itworkss]

This is awesome man, thank you so much!

[@werrtvnsioftuzrngkld]

Aren´t Ex-Dividend Date and Pay date still two seperate things?

[@Inviting1word]

Yes ones when you have to own the stocks by and the other is when you get money for owning that stocks.

[@DH-pz7bc]

Thanks for the video. Very helpful and easy to follow.

[@broadwaygypsy3304]

EXCELLENT THANKS ,INFORMATIVE AND ACTULLY WORKS, REAL JOY!!!

[@ivanpalamarenko3729]

My didn't work and I needed to put table "10" instead of ""9" Maybe they updated a web site with added table on top. Thanks a LOT!!!!!!!!!!!!!!!!!!!!!!

[@simulateandtrade]

THIS! Thank you sooo much!

[@IsaacTheGray]

Yeah this fixed it for me, thanks!! Anyone know how to check the table location in the future in case it moves again?

[@mrironleg]

I need to import dividend yield data for Canadian securities also; any ideas?

[@eliashanna2436]

Same here

[@charenk]

when I tried to create dividend yield, I am getting "#REF!" error with text "Function INDEX parameter 3 value is 2. Valid values are between 0 and 1 inclusive." Am I missing something here

[@Steve_Gouws]

Thanks for this. I’m trying to pull divided payments date into Google sheets. Any idea what that formula would be? Thanks

[@buffsurfer]

You are a genius. I don't know how to thank you!

[@nedh.8792]

Great content. Subscribed! FYI I'm getting the following error message when trying to import this data into Google sheets - "Function INDEX parameter 2 value is 8. Valid values are between 0 and 3 inclusive." Any suggestions on how to fix this? Thanks.

[@bigc716]

I changed the table number back to 9. worked for me.

[@JDJRN]

How do you know the "table #" is?

[@PacPacBumGaming]

Great video! But I encounter a problem when trying to fetch data for a quote like RNO(dot)PA for example(on yahoo). It seems to be the dot before PA that cripples the Google Sheets. If you find any way around it, please do let me know! Thanks again for the video!

[@BetasCoin]

Instead of pulling data using htmlimport, then you can pull all data on Yahoo Finance using the fact that it is build on Javascript. I just made a video showcasing my version of this if you need. kzbin.info/www/bejne/g3LMZ2WEaLtkfpY

[@jg5479]

Why do I keep getting n/a or resource at url not found when trying to change the dynamic cell from where I input to ticker after changing the url for the cell where I input the ticker?

[@nullnoob]

Any update toyour revised function. Get the same error as below: Error Function INDEX parameter 2 value is 8. Valid values are between 0 and 1 inclusive.

[@debbieshapiro9779]

This is fantastic! Thank you! 🙂

[@abutaymiyyahlectures]

does the link still work?

[@tmmedia1000]

How do you know its table 9? I'm trying to apply this to another site with a table, but have to find out which table I'm looking at, thanks.

[@jorgebaia865]

In the formula you provide to Copy the sell is not the correct one "C6" intead off "A2" Great job

[@lance4u19]

Hi mate, finviz doesn't show Canadian stocks, do you have any suggestions for inputting dividends data for Canadian stocks? Much appreciate!

[@BetasCoin]

Instead of pulling data htmlimport, then you can pull all data on Yahoo Finance using the fact that it is build on Javascript. I just made a video showcasing my version of this if you need. kzbin.info/www/bejne/g3LMZ2WEaLtkfpY

[@angelogramatica9967]

Wow! Awesome dude. Thanks a lot. Learned a lot again. Works not for all stocks but still a big help. Doesn't work for a stock like UBS f.e.

[@sarubinca]

Many thanks for noting correcting that after "table" the number is now 10. However, Google sheets responds with the following: "Function parameter MULTIPLY 1expects number value. But '0.99 (0.40%)' is text and cannot be coerced to a number." Any thoughts?

[@darkcrow42]

Try using LEFT() function before the rest of the formula in the video to only select the numbers to need. In this case 4 characters.

[@nodems613]

do you have an update for the Ex-Dividend Date line getting NA

[@michaelcloresandersm.d.7050]

Thanks Nikhil, that worked!

[@danielporter4493]

Hey bro, awesome videos. So my spreadsheet worked beautiful up until the other day, now it won't pull any data from Yahoo, displays N/A with an error that says " could not fetch url". All of my dividend paying stocks now have that error from Yahoo, so any other cells that reference those for calculations also don't work. Any ideas? Thank you

[@darkho0]

Liked the video, will check out the rest of the channel. Thank you for the educational video.

[@ProdLeo]

thank you so much! this was so helpful, cant thank you enough!

[@sachidanandsadhguru3703]

Yahoo Finance function as shown in above video is Returning error for table, 2. Says, "Resource at url not found".

[@rhlogic]

Wow! This is crazy brilliant!

[@investinggrind]

Hey man, this was a great video. Can you also make a video on pay dates? Thanks so much man

[@RedCirclePottery]

Has anyone recently dont this? The issue i have with pully from finvis is that the yield pct is importing as text with both the yeld pct and payout dollar ammount. For instance VZ shows as 2.63 (6.29%) anyone know how to deal with that?

[@krystalyan4264]

Any idea on a data source for ASX stocks? Thank you!

[@lihk9412]

Thanks, but the dividend is the total annual dividend, not the exact dividend in the Ex-dividend date ? how it can be resolved?

[@strangergranger10]

Any update for what table is for the ex dividend date???

[@bigsiegee]

Any suggestions on how you found the 'table number'? You said - this is table 9 but not sure how you figured that out.

[@Paddlehappy]

Hi , thank you so much for this video much appreciated

[@ruddvann]

Also is there a way to do this for mutual funds for trackings sake

[@KeithBandell]

I have been trying to figure out how to auto-populate dividend info into google sheets for a while. I tried the formula you listed above, but was not successful. Do you know if this formula is still current in January, 2023, or has something changed again like the table number?

[@GH-qx1lx]

What is the formula for the stock ticker plz?

[@87bhavneet]

I tried the function you posted in your description but I keep getting the error index 2 parameter value is 8, valid values are 0 and 1

[@lmao9222]

Ex-dividend only appeared in the cell i put the formula in for that stock but not the others. How could i fix this?

[@hanshausen2676]

This was very helpful, thanks. Just one question, How as the finviz table identified as 9? I don't see a numbering system. Your help is appreciated.

[@ThinkStocks]

Glad you liked it and currently finviz is pulling from table 8. They had a major update to their page a few months back but luckily it has been at table 8 for a while now. And honestly it was trial and error figuring out the table!

[@MostafaAbdelaziz]

it doesn't work with me I don't know why!

[@simulateandtrade]

Change the 9 at the end to a 10

[@mariex800]

Wow - that is so cool. Thank you.

[@riccardovarrazza6979]

Seems not working for LSE. Strange enough it works for SHEL.L and VOD.L but not for the others . It get stuck in loading or #n/A Any help? Cheers

[@nasserkareem3705]

I want to sum my dividends from multiple stocks. Some stocks don't have dividends and it return #value. How can i replace the #value with a zero?

[@rp19loring]

This is very helpful, thank you!

[@alphabeta01]

Fantastic video. I tried and all these work great. Only issue is that it takes a long time to load the data esp for symbols like AAPL. JNJ, GSK and ARKK. Thanks.

[@ruddvann]

Hi I cannot get the asterixis out of the way even with your modified code. Is there a fix to this. Thanks!

[@drtham]

Great video. showing me how to auto extract the ex-dividend date. Please show the code for extracting the dividend.and the dividend yield? For example Yahoo Finance shows : Forward Dividend & Yield 1.92 (15.74%) for stock OCR.

[@gregerlindstrand1665]

What would the code looklike for Riocan?