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.
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?
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.
***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!
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!!
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!
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
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!
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.
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!
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
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?
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!!!!!!!!!!!!!!!!!!!!!!
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 ;)
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
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
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
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!
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?
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?
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?
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
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.
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.
@@randolfeo9277 just to clarify, I am using TGT at initial cell A10 hence the specific numbers of * 4.17 (2.52%) * ( there is no space between the * and 4 or ) and * )
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
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?
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. th-cam.com/video/MAi62N3V1H4/w-d-xo.html
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?
finviz has changed the table number again - its now 10 instead of 9. I'm still trying to figure out where yahoofinance has hidden their table though 😕 hope this helps you some. -FC
@@nuthingoinon Got things to work with FINVIZ #10 but they don't have the XDATE in their sheet. Can't seem to find the key for the Yahoo Finance transfer for Xdate
This just does not seem to work for me, I always get an error, even if I copy the code from your description and change the C6 to my own one. Or if I delete the &C6 and just put the ticket directly into the parentheses. Always an error. Any suggestions ?
The payout ratio doesnt work anymore. Ans do you have any idea why its taking forever to load on my list of stocks? Even one at a time, it doesnt really load (been waiting 5 min)
Hey, I just checked on my end and it looks like everything still works including the payout ratio. Sometimes finviz takes a while to communicate with Google finance. Try closing out your tab and reopening!
@@ThinkStocks turns out i was wrong on the payout ratio stuff. It was just that particular stock (altria). For some reason it wouldn’t pull, maybe because its 100x+? The other stocks work. Anyway many of the stocks still wont load even after doing what you said. Its certain stocks that can’t pull from finviz (overwhelmingly majority). If i can pull dividends, i can pull the rest instantly too. Any ideas? Really really want this to work.
@@ThinkStocks i really appreciate the back and forth and you replying. I need help with this kid of stuff. Although im not sure how many non us stocks i have listed, i do know that there are us stocks finviz is not pulling. Is there a way to work around this? So far i put: Div, div %, insider ownership, insider transactions, institutional ownership, fwd pe, p/fcf These are important to me and my process. Can i find a way to get all these tickers filled on these data points?
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.
thanks man, literally came back because of that
I am still getting error loading data...
It says “parameter 2 value is 8. Valid values are between 0 and 2.”
Table number is 9 now.
@@thecantstopwontstopentrepr4156 Legend!
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?
Table has changed on finviz page. Now you need to change after "table" must be 10 not 9
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."
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
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.
You're welcome!
***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!
Hi, how can we figure out the table number?
Yay having a hard time getting the correct table number
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!!
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!
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
you saved my life. I've been trying to figure this out all day and you helped me in 5 mins. You rock
Super useful. Much better than similar videos because you go through the formula so clearly. Subscribed!
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!
As of April 21, 2023 it's Table 10.
Thank you
As of 6/20/2024, it’s still Table 10
Still 10 as at 6-Feb-2025
I cant thank you enough for making this video. I was trying to figure this out for many hours. 5 stars for your content.
Thank you. I tried multiple things, but your solution is simple and works perfectly
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.
hey! Any progress on that? I was thinking the same.
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!
Thanks! And glad it works for you!
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
Great tips man! Having it all in documentation is great to see and track those dividends!
Thanks, the best detailed explanation ever. 👍🏻
Thanks a lot. I saw it on a blog, but with a vidéo, this is day better ! 👌🏻👍🏻
I keep getting an ERROR message :(( it says = "Function INDEX parameter 2 value is 7. Valid values are between 0 and 1 inclusive"
Super Cool! Just followed all your steps and got what i needed. More blessings to you.
This was helpful, thank you. Can you advise how i determine what the table number is if i choose a different html website ?
Pretty useful! I was looking for this solutions for months...Thanks! Subscribed
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?
Hello have you found out another website that can use this method?
Dude!!, this was epic and helpful beyond words. I'm working on a dividend stock screener/tracker and this is perfect.
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!!!!!!!!!!!!!!!!!!!!!!
THIS! Thank you sooo much!
Yeah this fixed it for me, thanks!! Anyone know how to check the table location in the future in case it moves again?
You are the man for my spreadsheet nightmare. Subscribed! Thanks and take care
Thanks for the sub!
Man u r genius, I have been looking for this forever!
AYO NO CAP THIS WAS MAD HELPFUL, I ALWAYS WONDERED HOW PEOPLE GET THE DATE OMG TYSM TYSM TYSM TYS
unable to get data from yahoo finance, can you help me in this regard
How do you know that it's table 9 on finviz? What if they change their site up? How would we find that?
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 ;)
Talking about the first Dividend Yield formula.
thanks man, got the same thing
Thank you,was getting the same problem
does it still run? can you copy the formula in here? for me it doesnt run with 9 and 8 and other numbers. TY
@@Razorhead12345 same
Did u find the solution?
Thanks for the video. It took me some tries to make the code work, but I finally did it today.
Thats awesome, glad it works for you!
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
it doesn't work
@@northinvestor well you'll just need to copy it from the video then
@@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
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
You're so right. I just couldn't get the importxml function to work with Yahoo Finance data. A mega mega mega thanks.
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
have the same question
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!
You went hard on this video and thanks for the updated code it was exactly what I needed. Thank you sir
you're awesome, huge thanks for all your hard work in sharing your wisdom
Thanks for the very valuable information. Is there any way formula for getting Dividend Payout Date.
I have a problem with the exdate. Idk what I have done wrong but I am getting a "loading" error and no result....
Thank you so much for posting this. This is very helpful. :)
You are a god send. I have been looking for this information! Thanks
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?
Thanks! And not yet but thats a good idea for a video!
hi how did get the table 9 i have try ur formula but not working at all ?
Table is now 10 instead of 9.
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?
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.
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?
hey i kowla
iam late to the game you might have already figured it out but i used the importxml formu
I need to import dividend yield data for Canadian securities also; any ideas?
Same here
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
Hi, Just watched your video. This is amazing, you used hidden techniques to get this data. Thank you for making this video.
My pleasure, glad you liked it!
Very helpful video, "Subscribed". Hoping to learn a lot from this channel.
This is fantastic! Thank you! 🙂
Thanks, but the dividend is the total annual dividend, not the exact dividend in the Ex-dividend date ? how it can be resolved?
Any update for what table is for the ex dividend date???
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
exactly what I needed. Thank u so much !
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.
do you have an update for the Ex-Dividend Date line getting NA
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.
This is awesome man, thank you so much!
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.
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.
I changed the table number back to 9. worked for me.
Yahoo Finance function as shown in above video is Returning error for table, 2. Says, "Resource at url not found".
Thanks for the video. Very helpful and easy to follow.
this won't work anymore, since the table got updated in finviz. Now it displays both dividend and dividend yield in the same cell of the table.
You can use LEFT and RIGHT to trim the result.
Delete *1 at the end of the formula. If it's still causing an error, then trim whitespace (data, data cleanup, trim whitespace).
@@randolfeo9277 just to clarify, I am using TGT at initial cell A10 hence the specific numbers of * 4.17 (2.52%) * ( there is no space between the * and 4 or ) and * )
Great explanation, thanks a lot. Can we do this with MSFT Excel?
THe Ex div date from Yahoo isn't working for me. Could you please place the formula in the comments?
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
Thanks for this. I’m trying to pull divided payments date into Google sheets. Any idea what that formula would be? Thanks
You are a genius. I don't know how to thank you!
Any suggestions on how you found the 'table number'? You said - this is table 9 but not sure how you figured that out.
Hey man, this was a great video. Can you also make a video on pay dates? Thanks so much man
How do you know the "table #" is?
it doesn't work with me
I don't know why!
Change the 9 at the end to a 10
Aren´t Ex-Dividend Date and Pay date still two seperate things?
Yes ones when you have to own the stocks by and the other is when you get money for owning that stocks.
What is the formula for the stock ticker plz?
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?
Hi , thank you so much for this video much appreciated
Any idea on a data source for ASX stocks? Thank you!
In the formula you provide to Copy the sell is not the correct one "C6" intead off "A2"
Great job
EXCELLENT THANKS ,INFORMATIVE AND ACTULLY WORKS, REAL JOY!!!
Hi mate, finviz doesn't show Canadian stocks, do you have any suggestions for inputting dividends data for Canadian stocks? Much appreciate!
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. th-cam.com/video/MAi62N3V1H4/w-d-xo.html
Also is there a way to do this for mutual funds for trackings sake
can you pull free cash flow from yahoo? or is this only able to be pulled from the first page? Thanks for your help
does the link still work?
Ex-dividend only appeared in the cell i put the formula in for that stock but not the others. How could i fix this?
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
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?
Hi I cannot get the asterixis out of the way even with your modified code. Is there a fix to this. Thanks!
Followed instructions exactly but I receive the following errors - "#REF! #ERROR! #ERROR! #ERROR!" Looking for solutions please
finviz has changed the table number again - its now 10 instead of 9. I'm still trying to figure out where yahoofinance has hidden their table though 😕 hope this helps you some. -FC
@@nuthingoinon Got things to work with FINVIZ #10 but they don't have the XDATE in their sheet. Can't seem to find the key for the Yahoo Finance transfer for Xdate
thank you so much! this was so helpful, cant thank you enough!
This just does not seem to work for me, I always get an error, even if I copy the code from your description and change the C6 to my own one. Or if I delete the &C6 and just put the ticket directly into the parentheses. Always an error. Any suggestions ?
Liked the video, will check out the rest of the channel. Thank you for the educational video.
Any idea how you get valuation data from morningstar?
I cannot get the ex-dividend date to import? Has something changed?
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?
Great video! Do you think you could reverse engineer this to pull the stocks that have an ex-dividend date within a certain date range?
why did you put after table 9? How could I know about it because I put 9 in the formula and had nothing; I had an value that is not what I expected
Its now table 8!
@@ThinkStocks It works now, but how do you read what number the table is?
The payout ratio doesnt work anymore.
Ans do you have any idea why its taking forever to load on my list of stocks? Even one at a time, it doesnt really load (been waiting 5 min)
Hey, I just checked on my end and it looks like everything still works including the payout ratio. Sometimes finviz takes a while to communicate with Google finance. Try closing out your tab and reopening!
@@ThinkStocks turns out i was wrong on the payout ratio stuff. It was just that particular stock (altria). For some reason it wouldn’t pull, maybe because its 100x+? The other stocks work.
Anyway many of the stocks still wont load even after doing what you said. Its certain stocks that can’t pull from finviz (overwhelmingly majority). If i can pull dividends, i can pull the rest instantly too.
Any ideas? Really really want this to work.
Ah yeah finviz is only good for us stocks. Yahoo finance has data for much more. I need to make a yahoo finance version this
@@ThinkStocks i really appreciate the back and forth and you replying. I need help with this kid of stuff.
Although im not sure how many non us stocks i have listed, i do know that there are us stocks finviz is not pulling.
Is there a way to work around this?
So far i put:
Div, div %, insider ownership, insider transactions, institutional ownership, fwd pe, p/fcf
These are important to me and my process. Can i find a way to get all these tickers filled on these data points?
So far yahoo is the best bet but I'm still learning how to pull more market data from them.