I would just add *4 at the end instead of *1 which will calculate the yearly dividend (on the quarterly pay stocks) which is what many are looking for when creating the google stock tracking sheet. Thanks again for sharing this formula.

@DannyDrives

6 ай бұрын

Thanks for the tip, but for my sheet I use the per month DIV

This is amazing, I tried a bunch of other methods and they all failed or were outdated; but this worked. Thank you!

@DannyDrives

Ай бұрын

Exactly why I made it! So many are like 5+ years old and don't work so I aimed to fix that with something I would actually use!

Works great, thank you. I'll still be looking for ways to do this without scraping other pages.

@DannyDrives

4 ай бұрын

You're welcome! You can't my friend until Google implements native formula integration like how you can pull the ticker market price. Scraping will be the best you can get!

Works great so far, Thanks

@DannyDrives

5 ай бұрын

You're welcome!

Super helpful. Thanks!

@DannyDrives

2 ай бұрын

Glad I could help! Be sure to check out my other videos!

works beautiful!! thank you

@DannyDrives

3 ай бұрын

You're welcome!

Very helpful. Thanks

@DannyDrives

2 ай бұрын

Glad it was helpful!

Thank you so much. This is super helpful.

@DannyDrives

2 ай бұрын

Glad I could help! Be sure to check out my other videos!

Opposed to using a google sheet can I use an excel file on the desktop instead?

@DannyDrives

7 ай бұрын

Should work, but might need an edit to fit Excels formula verbiage

Thanks M8. Well done, Sir.

@DannyDrives

4 ай бұрын

Welcome!

Thanks, man!

@DannyDrives

4 ай бұрын

No problem!

I used formula 1. I’m not into race cars, but subscribed anyway. Thanks for the query!

@DannyDrives

2 ай бұрын

Thanks so much! Scroll through, I have random videos too. Crypto, beaches, etc.

Hey Danny, any chance you have a similar method for importing free cashflow data? I have a google sheet I use to do discounted cashflow analysis'. Would be helpful if I could just automatically import free cashflow data into the sheet, instead of having to manually calculate it. I tried to adapt your dividend formula to import the free cash flow from ycharts. But, it imports a letter at the end of the number (19.45B or 67.84M for example). Cant figure out how to get rid of the letter, and with it in the number, I can't do math operations with it lol. I tried to use macrotrends, but I think google sheets cant recognize their tables. I had some success with stock analysis, but their tables aren't the same for every company. Any help would be appreciated.

@DannyDrives

6 ай бұрын

You would just have to find the right table on the right site. What site are you trying to scrape data from? I might be able to quickly able to figure out the formula for you!

Bless you

@DannyDrives

4 ай бұрын

Glad I could help!

Great information. How do we pull the industry/sector from Ycharts?

@DannyDrives

4 ай бұрын

You would have to play around to find which chart/column/row that is in

Doesn't seem to work for me. When I copy and past the formula, and then edit B2 to where I keep the ticker info in my sheet, I just get a black bar in the cel. If I made a copy of your sheet, and change the ticker, it seems to work. Not too sure why it isn't working in my sheet.

@18pth

6 ай бұрын

Never mind. I got it. Somehow, I randomly filled the cell with a black colour when I put in the formula. So, I couldn't see the number. Thank you for figuring this all out.

@DannyDrives

6 ай бұрын

Glad I got it sorted!

Not working for me. I tried to copy the first formula and paste it on an existing google sheet it throws me ''#ERROR!"

@DannyDrives

Ай бұрын

Try to copy/paste the formula not the cell. It works, I literally use it everyday. No extra coding required. UNLESS there is no current dividend for the company?