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

Подписаться 154 тыс.

Просмотров 31 тыс.

50% 1

Access Tickerdata and my Spreadsheets: tickerdata.com/
In this video, I take you step by step on how to automatically get real time dividends in google sheets. This is a great way to automate your dividend tracking. I personally use this method to track dividends in many of my own personal portfolio dividend trackers.
Get 50% off of Seeking Alpha Premium!
www.sahg6dtr.com/9D5QH2/R74QP/
Here is the formula:
=substitute(SUBSTITUTE(index(importhtml("finviz.com/quote.ashx?t="&C3,"table",8),7,2),"*",""),"-","0.00")
Link to download my portfolio tracking spreadsheets: / dividendology
The microphone I use: amzn.to/3ngqbVz

Опубликовано:

2 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 85

@Dividendology 2 года назад

*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 2 года назад

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

@bennyeriksson1586 2 года назад

@@rg1615 Try use ; instead of ,

@zeipastel 2 года назад

thank you , from Portugal

@brandonproductions2575 Год назад

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

@CourtneySoularie 2 года назад

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 2 года назад

I’m so glad it helped! Thanks!

@zackgilbert3109 2 года назад

this was well explained. thank you

@jivepatrol6833 2 года назад

Very helpful video - thanks!

@OtherKindsofMoney 2 года назад

Great video! Your trackers are awesome

@jastr6877 Год назад

Thank you so much for your work!!!!

@Wysiest 2 года назад

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

@Reza_Audio 2 года назад

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

@jonnya6738 2 года назад

Great video man. I love dividends. New sub here

@ncairsoft 2 года назад

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

@joeybuttafucko3402 2 года назад

Well done bro, two thumbs up.

@liveingalway 2 года назад

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 2 года назад

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!

@rogersimpson1052 2 года назад

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 2 года назад

Yes, they have! Great catch.

@romeowhiskey1146 2 месяца назад

Thanks for ADDING the FORMULA...

@SaraanInvesting 2 года назад

thanks for the video

@chamindasilva3191 Год назад

Love it

@ModestMillennial 2 года назад

Great video buddy!

@Dividendology 2 года назад

Thanks! Glad you enjoyed!

@danielpelloquin9845 7 месяцев назад

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

@mariomujica3339 Год назад

Thank you bro!

@Dividendology Год назад

No problem!

@UltimateLooping Год назад

you are a legend

@Dividendology Год назад

you're a legend!

@beardedbobsfishroom7654 5 месяцев назад

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 4 месяца назад

I have the same question.

@gregerlindstrand1665 2 года назад

How would the formula be for CIBUS ? Swedish company

@fraqqle 2 года назад

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

@larsw6517 2 года назад

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 2 года назад

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!

@strangergranger10 8 месяцев назад

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

@adamoconnell1368 2 года назад

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

@Dividendology 2 года назад

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

@catshorrorstitching5473 2 года назад

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 2 года назад

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

@deancarlson5992 7 месяцев назад

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

@Sbennett76 Год назад

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

@willbreece 2 года назад

Muy interesante

@kylecain6685 2 года назад

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

@Dividendology 2 года назад

Awesome! Thanks for the update!

@Atahualpaelunico 2 года назад

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

@Dividendology 2 года назад

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

@Daddywaah 2 года назад

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 2 года назад

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

@Daddywaah 2 года назад

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

@Daddywaah 2 года назад

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

@zeze9062 2 года назад

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

@Dividendology 2 года назад

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 2 года назад

@@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

@goose-F16 24 дня назад

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 24 дня назад

Nope! This is how I do it now: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LqUxkl6FK1k.htmlsi=5qIVD0WtMOCf6A-0

@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?

@siarheikaravai 7 месяцев назад

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

@MajestadePaa Год назад

👏👏👏👏👏👏👏👏👏👏👏

@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!

@chrstdvd Год назад

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

@callumhewson8514 8 месяцев назад

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

@Dividendology 8 месяцев назад

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

@jimmygarcia1534 2 года назад

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

@Dividendology 2 года назад

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

@Dividendology 2 года назад

That will give you an average.

@jimmygarcia1534 2 года назад

@@Dividendology thank you very much

@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 10 месяцев назад

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

@motive8189 9 месяцев назад

table number has increased to 10.

@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.