@@Dividendology Thanks for your reply! How do I get the numbers correct? Is it based on positioning in the table or some other numerical measure of screen position?
Dear friend Congratulations for your really amazing and helpful videos that you create for us. I’m experiencing a problem and really need your help if it’s possible, please. I’m watching your video: how to build a dividend stock watchlist in google sheets And I am having a problem with a code. It returns me an error (#REF!) and in another shell (#N/A) Can you please help me. Thank you in advance
Love the way you walk through the program. I am in Canada and Finviz does not do the TSE, VSE, CAD or other Canadian exchanges. Will have to find a good substitute for Finviz here.
Good work on the spreadsheet. It absolutely takes a lot of tinkering to make sheets pull in all the info you want to use as an investor. Two thumbs up.
Nope. That's why I created the Tickerdata add on in google sheets. It allows you to import stock financials straight into your spreadsheet, including stocks from Canada. Here's a tutorial video: th-cam.com/video/KRxHOlZSWjs/w-d-xo.html
Nice video indeed! I have issue with "Current yield" formula... when add the divident into formula it says that text cannot be added into formula. But in your videos this is not problem . How can i fix this?
Wow ! You really know your stuff ! I'm working on automating a small Google spread sheet to track the daily changes in stocks and associated Calls I've written. I'm trying to figure out a formula to use to update the Ask price during the open market or after close - using Yahoo data or Google Finance data. Could you provide a formula for that? Thanks!
Actually, all Finviz scrape column have stopped working for me (Dividend, Payout Ratio, Market Cap, and Industry). Did something change that I need to adjust?
Great video! I'm glad it came across my feed. It seems like Finviz does not inlcude OMX30 but Im having much fun learning all these skills in Google sheets.
I really liked your content and videos which are very usefull. but am I only one who gets "formula parse error" in googlesheets, I will be glad if you help how to fix this. I just copy paste your formula, thank you
I have this working fine thanks to your sharing. The only problem is I can not figure out what to put in the Target Buy column, because all recommended stocks are so below historical norms. They are all buys. About the only useful info in this video for me is where you gave the demonstration of how to pull a companies industry. I was able to follow that procedure in my Dividend Tracker Spreadsheet where the formula in that video failed to work. I really like the Dividend Tracker sheet you taught us. I have added a few new tabs to that spreadsheet. So what I am doing with this spreadsheet is plugging in every stock recommended by you and a few other You Tube sharers, but mostly stocks that are in the various monthly recommendations of Sure Dividend. Then I delete the stocks in industries I am overloaded in, like REITS and Financials. I am low on Energy, consumer staples, healthcare, and various, other sectors. I keep those on this watch list spread sheet.I am maxed out money wise to invest, but if I keep good stocks on this spreadsheet, I have alternatives to replace stocks in my portfolio that go south.
Is there a way to add the average dividend growth or the cagr (Compound annual growth rate )? I figure the easiest way to do this would be to get the dividend from the 5 years ago and then simply add a formula for the cagr. The problem is I can't seem to find any place where I can easily scrape a previous year's dividend. I know I can find it easily in yahoo finance. But I can't figure out how to actually get it into google sheets.
@@Dividendology thank you! At the moment, I am still having to look up the past dividend enter it manually. I appreciate you putting your expertise to work :-)
Always great content. I am trying to get the Industry to work and keep getting an error. I copied and paste the stuff in the description with no luck. Any tips to get this to work?
Hello, Thank you for all the wonderful content! I am struggling to get the dividend amount and payout data to consistently load. Out of a list of roughly 60 tickers, only 5 show. The rest show #N/A and present a Fetch Error and states the ticker cannot be found. Interestingly, the errors can change from one ticker to another. I'm also getting an error on the industry data. I'm also getting a #VALUE! error on the Industry cell. I originally thought the dividend and payout errors might simply go away, but I've now been working on this for the past four days, and no improvement... I'm curious if others have had similar issues. Thanks!
@@Dividendology ok, thank you for your great show.It's a good sample to use GOOGLEFINANCE functions.I have another question to discuss to u. Can i send you an email??
![[TH] FS vs BME - VCT Ascension Pacific - Lower Bracket Final](http://i.ytimg.com/vi/wnygqsR2Fig/mqdefault.jpg)
You’re seriously making great content man. You deserve all the growth (stonks + subs)
LOL! Thank you! I'm just trying my best to provide value through these videos! Thanks for watching.
That was a great walk through. Thank you. 🤙
No problem 👍
That is a really nice sheet. Thanks for walking through it and sharing.
You are so welcome!
Everything worked out for me, thanks for the tutorial. Does the dividend column calculate annual dividend payout?
Yes!
Brilliant
This is amazing. Thank you
You're very welcome!
I couldn't get the web-scraping formulas to work. It just displayed an invalid output. Any possible reasons you can think of for this?
make sure you adjust the formulas to reflect wherever your stock ticker data is!
@@Dividendology Thanks for your reply! How do I get the numbers correct? Is it based on positioning in the table or some other numerical measure of screen position?
watch my video on how to get dividend data in google sheets!
Dear friend
Congratulations for your really amazing and helpful videos that you create for us.
I’m experiencing a problem and really need your help if it’s possible, please. I’m watching your video: how to build a dividend stock watchlist in google sheets
And I am having a problem with a code. It returns me an error (#REF!) and in another shell (#N/A)
Can you please help me. Thank you in advance
Where are the formulas? I’ don’t see them in the description
Love the way you walk through the program. I am in Canada and Finviz does not do the TSE, VSE, CAD or other Canadian exchanges. Will have to find a good substitute for Finviz here.
This is awkward, the dividend formula isn't cooperative
I pull in dividend with an updated method that always works! Use he Tickerdata extension in google sheets! You can get it at Tickerdata.com
Good work on the spreadsheet. It absolutely takes a lot of tinkering to make sheets pull in all the info you want to use as an investor. Two thumbs up.
unfortunatelly Finviz doesnt seem to have canadian stocks :(
Nope. That's why I created the Tickerdata add on in google sheets. It allows you to import stock financials straight into your spreadsheet, including stocks from Canada. Here's a tutorial video: th-cam.com/video/KRxHOlZSWjs/w-d-xo.html
@@Dividendology Ill subscribe to Tickerdata, Im right now watching another video of yours explaining about it :) thank u!
I think that this formula needs tweaked a bit
See updated formula in the video description
Nice work you got here. What about the Payout Ration for REITS (AFFO)?
Thanks! Great content. Is it way to scrape the data for dividend growth?
I'll have to look into this!
Nice video indeed! I have issue with "Current yield" formula... when add the divident into formula it says that text cannot be added into formula. But in your videos this is not problem . How can i fix this?
Does it make sense to just buy Realty Income shares?
What if it was just him in my portfolio?
Wow ! You really know your stuff ! I'm working on automating a small Google spread sheet to track the daily changes in stocks and associated Calls I've written. I'm trying to figure out a formula to use to update the Ask price during the open market or after close - using Yahoo data or Google Finance data. Could you provide a formula for that? Thanks!
I love this sheet. For some reason the Dividend column is no longer working for me. It shows as blank. It used to work for me. Any ideas?
Actually, all Finviz scrape column have stopped working for me (Dividend, Payout Ratio, Market Cap, and Industry). Did something change that I need to adjust?
It has changed. I’ll probably make an update video soon on it.
I will await that eagerly. Thanks so much for sharing this.
Great video! I'm glad it came across my feed. It seems like Finviz does not inlcude OMX30 but Im having much fun learning all these skills in Google sheets.
Nice template but seems like the industry section is not working properly as its giving me errors.
Thanks a lot for the great work and sharing this!!!
My pleasure!
That's a good tutorial.
It would be even better if google sheets sent you an email when buy or sell appears in the sheet.
I do know how to make that happen. Maybe I'll make a tutorial on it soon. 😎
@@Dividendology That would be cool if you wanted to show that in google sheets thanks in advance man ;)
Great speadsheet, How do I get UK shares on the sheet as some ticker names do not work. ?
Great content, thank you so much & have a great weekend! 😊
I really liked your content and videos which are very usefull. but am I only one who gets "formula parse error" in googlesheets, I will be glad if you help how to fix this. I just copy paste your formula, thank you
make sure that you adjust the formula to refer to wherever your data is located!
As soon as I put a komma behind the cell with the ticker, it turns black in stead of oranje and it doesn't show the name. What do I do wrong?
Try with ";" instead of "," ... to me that was the problem.
I have this working fine thanks to your sharing. The only problem is I can not figure out what to put in the Target Buy column, because all recommended stocks are so below historical norms. They are all buys. About the only useful info in this video for me is where you gave the demonstration of how to pull a companies industry. I was able to follow that procedure in my Dividend Tracker Spreadsheet where the formula in that video failed to work. I really like the Dividend Tracker sheet you taught us. I have added a few new tabs to that spreadsheet.
So what I am doing with this spreadsheet is plugging in every stock recommended by you and a few other You Tube sharers, but mostly stocks that are in the various monthly recommendations of Sure Dividend. Then I delete the stocks in industries I am overloaded in, like REITS and Financials. I am low on Energy, consumer staples, healthcare, and various, other sectors. I keep those on this watch list spread sheet.I am maxed out money wise to invest, but if I keep good stocks on this spreadsheet, I have alternatives to replace stocks in my portfolio that go south.
well done!
Is the spreadsheet free? I’ve tried downloading the file but it keeps me redirecting to the payment page. Is there a way I can this for free?
you can download it on my patreon page! This sheet is available on the $3 tier.
I'm not usually bothered to leave likes of replies but this is some seriously good stuff! This vid should have way more views!
Thank you!
You're a genious man !! Respect for the high quality content you create, this is one of my favorite youtube channels !!
Thank you!!
Thanks for the awesome video. How do you know how to scrape any field from finviz ?
Check out my videos on webscraping!
Very Helpful
This was very helpful thank you very much
You're welcome!
nice! I didn't know google spreadsheets could do this
it's pretty amazing!
What platform/broker do you use do buy your stocks?
I actually use a few different ones, i'm still deciding which I like best. I do have an affiliate link to Webull for free stocks in my description.
Is there a way to add the average dividend growth or the cagr (Compound annual growth rate
)? I figure the easiest way to do this would be to get the dividend from the 5 years ago and then simply add a formula for the cagr. The problem is I can't seem to find any place where I can easily scrape a previous year's dividend. I know I can find it easily in yahoo finance. But I can't figure out how to actually get it into google sheets.
that's a great idea!! Im going to look into this.
@@Dividendology thank you! At the moment, I am still having to look up the past dividend enter it manually. I appreciate you putting your expertise to work :-)
love this :)) I'm gonna sub to that patreon
Enjoy!
Always great content. I am trying to get the Industry to work and keep getting an error. I copied and paste the stuff in the description with no luck. Any tips to get this to work?
Yep, the website has changed the way you can import the industry. I’ll probably make a new video on this very soon.
@@Dividendology Thanks!! Just watched the new video on building the watchlist. Great stuff!!
Hello, Thank you for all the wonderful content! I am struggling to get the dividend amount and payout data to consistently load. Out of a list of roughly 60 tickers, only 5 show. The rest show #N/A and present a Fetch Error and states the ticker cannot be found. Interestingly, the errors can change from one ticker to another. I'm also getting an error on the industry data. I'm also getting a #VALUE! error on the Industry cell. I originally thought the dividend and payout errors might simply go away, but I've now been working on this for the past four days, and no improvement... I'm curious if others have had similar issues. Thanks!
It looks like there’s been an error on googles end the past few days… Im guessing they’ll have it resolved soon.
@@Dividendology Thanks!!
@@Dividendology I think that rather finviz changes its script so that you can not fetch the industry from.
Thank you very much bro!
You're welcome!
Thank you for this!
My pleasure!
How could know the target price to buy ??
it's just a number that you decide you are comfortable buying the stock at!
@@Dividendology ok, thank you for your great show.It's a good sample to use GOOGLEFINANCE functions.I have another question to discuss to u. Can i send you an email??
Im having trouble with the INDUSTRY syntax. "#VALUE! Search parameter 2 value should be non-empty" How do I fix this error? (10/22)
I have trouble too with this