NEW Dividend Function In Google Sheets

[@EmilyBeery]

I was advised to diversify my portfolio among several assets such as stocks and bonds since this can protect my portfolio for retirement. I'm seeking to invest $200K across markets but don't know where to start.

[@NelsonHouse78]

The professionals presently control the market since they not only have the essential business strategy but also have access to inside information that the general public is not aware of.

[@nuraahmadumar8937]

@@NelsonHouse78 The reason I decided to work closely with a brokerage adviser ever since the market got really tense and the pressure became so much(I should be retiring in 17months) so I've had a brokerage adviser guide me through the chaos, its been 9months and counting and I've made approx. 650K net from all of my holdings.

[@nuraahmadumar8937]

@MichealHyde67 “Alice Marie Coraggio’’ You can easily look her up, she has years of financial market experience.

[@MarkBall3]

Many of the stocks I'm invested in don't show the dividend yield. I checked on "Seeking Alpha" & the stocks do show a dividend yield. Not sure what I did incorrectly, coding is correct as it shows on your video & some do show up. Stock Tickers that show 0.00% yield: CHMI, FSK, TWO, NLY, BKCC to name a few. Thanks for the information.

[@baigani0]

same here

[@jayantketkar8711]

I just tried this code .But it does not work. The Div. Yield column remains blank. I have rechecked the code twice it is running with execution completed. what could be the reason?

[@Anthony_108]

Me 2 😢

[@pankajkumars7316]

Did you find dividend function in your sheet?

[@jerryball7783]

Me too as well. Things must have changed since the video was created??

[@727272727271]

It doesn’t work . Tried a million different ways and got ChatGPT to check - massive waste of time

[@sergioarena]

Nothing changed. Still works. Recheck your spelling in the function code.

[@greyhaircapitan]

We need to refresh the spreadsheet in order to show the result or the API won't work. It looks like that API will show the yields only on common stocks but not ETFs, CEFs, ETNs, and Preferred stocks quotes (it shows 0% yield).

[@Kage-Plays]

Weirdly malfunctions from time to time, data was appearing previously, then after awhile it bugs out and all the data disappears. Even refresh doesn't work for the data to populate. Need to delete the code and re-enter and this is also not very certain since it works sometimes not all the time.

[@descubreloporti]

Yield and Dividend not working for me, return 0 value, any fix? thank you for the video!!

[@thejudge2352]

Me too March 24

[@joelnichols3611]

Not working here either.

[@OmaticFever]

This great info Keith. However, I noticed when I setup my api key, alpha vantage only guarantees 25 api queries per day. It appears to not be a hard limit, but I do have some 0% yields on stocks that definitely have non-zero yields.

[@gamingc1981]

Thanks this works for stocks, but not for ETFs like FIVG or JEPI

[@vp2777]

Oh thats a shame!

[@kviswanathan10]

It is working perfectly for stocks, but it is not working for ETFs is there a fix? for this. Cheers for your video.👍

[@theresamartin5170]

I got a message saying "Google hasn't verified this app" and could not figure out how to get it verified. Despite that, I still learned a lot as I know nothing about coding or scripts. Really enjoyed it. Thanks

[@Pegaroo_]

He shows you in the video how to get passed that 7:30

[@RoniejeBuh]

THank you for this. The script seems to work fine. But when in the Sheets and I try to multiply by 1, the sheets puts an "value" error saying that "parameter 1 of the multiply function expects number value; however the result I get is not a number but text and cannot be transferred to number" - anyone can help what is wrong please?

[@wreinus]

This is a great video. I've been over the syntax twice and find no error. Everything was exactly as you described until I tried to use the App Script. It doesn't return an error. It return 0.00% for all ticker symbols, including those that i know have dividends. Any idea what's going on here? Thanks, Wil

[@BreakingGravityPT]

I am having the exact same problem.

[@JuniorHel]

Me too 😓

[@arielonnis1]

Hi! dont see Dividend funtion. Have you got any particular configuration? Thanks!

[@Tanejasinghangadast2]

This has been an incredible helpful video and saved to my playlist as well. Thank you so much for making such a simplified video. I am having a deviation of 0.5%-1% among most stocks (and I am looking at NASDAQ & TSX only). Hoping you can create an FAQ video for the same

[@martinunger9545]

I have been trying to do this for a long time. Excellent video. I really appreciate what you have done. It works perfectly.

[@AmanpreetSingh-mm9ih]

Great video as always mate. Can you add ex-divinded and dividend dates as well? This works for international stock market? As i live in India. Thanks

[@wellsohn]

Very concise and useful educational video. Thanks a lot for this!

[@ThinkStocks]

I glad you think so!

[@lslewis104ca]

How do you get this to work for the Toronto Stock Exchange(TSE), or any other exchange?

[@_faiaz]

Looks like it doesn't work for TSX stocks...

[@asfmnews]

You can pull the stock using TSE:BNS, but the yield won't work.

[@xtasktaste0]

TICKER.TRT

[@floridaboz1]

Worked great. Other than about 30% of the yields are not updating. I am trying to troubleshoot to figure out why

[@NajiKelley]

I had a similar issue. I'm thinking it's because the stock is listed on another exchange like the NASDAQ.

[@Cherokeeman96]

Hi, great video. This is what I am looking for but I would like to use it for the Annual Payout instead of the Dividend Yield. Is this possible? What would I need to change to accomplish this? Thanks

[@rene.s.s]

add a column for share amounts and multiply by that cell in addition to what was shown.

[@kevinvandenboss7740]

You just made my life SOO much easier. Thank you! I never subscribe to anyone, but you just earned it!

[@noahschreiber2988]

I followed the instructions and at the end I got the execution started execution completed message. I then went to the Yield and typed Dividend and the cell with the symbol so it looked like this =Divided(B7) and hit enter and I get the message Error Unknown function Dividend. Can someone please help What did I do wrong

[@rileybk]

Same for me

[@obirlik68]

I had same problem than some how I fixed that but now cell is completely blank no error message either. Second thing is when you bring mouse over the function that time it says unknown function making me crazy.

[@dianawojcik3261]

@@obirlik68 Did you ever solve this? Having the same issue. Thanks!

[@obirlik68]

@@dianawojcik3261 nope but I made a one page website, made a little search box using my api key be able to get all bunch of useful information about stock. Kinda gave up on this.

[@otmastitel]

Thanks for the video its worked .. have you got a video which shows how to do dividend amount instead of dividend percentage ? thanks & good luck

[@januszjaxaxa9929]

Very nice thing, formula is working fine for me, until I'll try to interact it with anything else. Any idea how to switch to american decimal separator? (my excel spreadsheet stubbornly expect comma instead of dot).

[@davidwilding]

Good, but what about non-USA stocks? Doesn't work for that I see! But it's a help anyway :) And how to get the actual DIVIDEND value itself?

[@dawens3199]

Tried using this and for some stocks it worked. But for others such as AAPL, ABBV, BTI, EPD, SCHD, VTI - no luck. Any recommendations?

[@leesmith9299]

presumably line 6 of that code could instead extract the dividend per share in $ and then be used to calculate yield more accurately using googlesheets share price. very backwards to start with yield to work out dividend per share like that. the divi per share is what gets set in stone by the company and we calculate our yields from that and the share price which fluctuates second by second.

[@Reza_Audio]

Good tutorial, but alphavantage not supporting indexfunds and ETFs

[@Moguiman]

worked perfectly - is Ex Date available? I looked at the documentation couldn't find anything on dividend data.

[@DecisiveMoves365]

I created a list of 2023 dividend aristocrats in Google Sheets and tried this method. Out of 50 stocks, it returned the dividend yield for about half a dozen and zeroes for the rest. Can anyone tell me why this is happening?

[@buddybrooks9659]

The free version of the API only allows 25 data requests per day.

[@DecisiveMoves365]

Thank you for your reply! @@buddybrooks9659

[@ultrasrock]

For some reason, the value does not load when I run the function.. And I followed every bit of the tutorial. Is it because I am looking for Brazil stocks ?

[@bfrock01]

Great video and solution. Is Ex-Dividend date available?

[@ivank3718]

Great video, but the script does not determine dividends for ETFs How to make it defining not only for companies?

[@Androidpower20]

tried but not working for indian stocks. no errors but in the last step in dividend yeild column its showing nothing.

[@cristiantesuri958]

doesnt work for in Argentina, for some reason

[@alaattinozturk9883]

It was a very nice video. How can I get data for this formula and Turkish stocks?

[@israelschurek9046]

Thank you so much! Indeed this is graet! Can you add the "Ex dividend day" also?

[@ThinkStocks]

No problem! and that is a good question, I believe you can. I need to look more into how to use Alphavantage and the API. I'm sure there is a lot more that can be done with the API. I'll make a follow up video going more in depth with it!

[@ellasprihatini7148]

been trying using your code for tickers on IDX like BBCA or ADRO to no avail. please help? maybe i need to add something to the code lines?

[@Winston0Boogie]

Some stocks will not show a dividend yield and I can't turn them into % so they're right now ...whatever actually worked 0.0312 which is not practical. Can you paste the code somewhere? I rewrote the code and it will not change anything.

[@user-li1oi4ii3e]

Great video....straight to the point...No BS!!!

[@jcvzz]

I do all the process with the apps script and is ok, but th dividend part in the table do not work.

[@pcsharma8926]

Sir, can we get dividend details for Indian ticker from NSE also ? Thanks

[@greyhaircapitan]

The API run with no problem but the spreadsheet is responding: Unknown function 'Dividend'. What could be the problem?

[@buddybrooks9659]

You should confirm the accuracy. The numbers I am seeing for dividends are often wrong. Sometimes by a large amount. Also note this is limited to 25 requests a day so if you own more stocks than this, you are out of luck.

[@joshuarosenberg1528]

it loads the cell but then its blank?

[@nimrodhadany9504]

What can we do to display new symbols dividends, the function does not find them :

[@jivepatrol6833]

Excellent tutrorial - thank you!

[@sarubinca]

Can the author, or someone, type out the lines of code so that I copy it and enter it exactly as as described in the video (of course, need to get a code and specify which stock/field)?

[@ShanAiyaz]

not working cell showing blank

[@PedroSantos-fh3oe]

Could you just add to the description the full code?

[@russojar]

I only get three rows to work. After that, it is all zero yield.

[@earthman4748]

I get an 'Unknown function' error for the =Dividend(A2)

[@pkaronis1]

I get an 'Unknown function' error for the =Dividend(A2)*1 part????? Can someone help?

[@obirlik68]

when i type =Dividend(A2) that cell shows 0 does anyone know why?Please help

[@GroundUpTrading]

Can you get the Ex-Dividend Date with this API?

[@teembo]

you know what we really need??? a better way to pull the ex dividend date. Finfiz stopped showing it and Yahoo keeps changing the tables. No table # seems to work on Yahoo as of June 2023.

[@obirlik68]

I can tell you this tho if you get the api key if you find url goes with that api you can get so much information about that company I can say that can even tell you what color underwear ceo wearin lol

[@obirlik68]

Those who get blank cell or 0 there is no problem with code problem with how to add new custom function in to the google sheet. I think google sheet does not recognize the new function.

[@obirlik68]

Update I made website I just a put little search box using my api key you can any us base stock symbol and gives you too much information about that company but I still couldn’t figure it out on google sheet 😢

[@valleywineandcheese]

Yep. Doesn't work for me. Tried the exact tickers ...nada

[@markdavis1524]

this exercise was a sive for time, doesn't work. would be great to paste the code snippet for copy/paste, otherwise too tedious.

[@DavidHk28]

Followed down to the letter and doesn't work at all. I get 0.00%

[@Beta_Trader]

Does not work for NSE stocks!

[@Gragento]

Can you make a video how to see crypto closing prices or open prices?

[@gamesview3313]

Thanks but for me it did not work. I got a wrong message for line 2. I think the API key. Can you help me?

[@dianawojcik3261]

same thing happened to me, I'm trying to troubleshoot it. Quite frustrating.

[@dianawojcik3261]

I fixed it. Mine was missing an = before apiKey, make sure that's there

[@noahschreiber2988]

I previously posted that it didn’t work now it works. I guess it took time. Thanks Great video

[@valleywineandcheese]

Nope, not for me

[@judolife5768]

Still hasnt for me either

[@noahschreiber2988]

It now stopped working it put -0- in most of the dividend yield cells. It seems this program is not very stable or very reliable

[@noahschreiber2988]

Still not working.

[@polisdrakas7925]

Good job. Thank you.

[@powerclash8488]

It's Not Working for me, does anyone has a solution?

[@polisdrakas7925]

Doesn't work

[@TheSmallsAbroad]

For me this works about half the time, some stocks they work, some they dont, and some that work now, in 5 minutes they will show 0%, its very unreliable

[@MrCptSilva]

I just tried following to create a sheet for myself. The dividend function doesn’t work for. I did do the “run” and it executed with no errors. I reread the script and I don’t see any errors. What else can it be?

[@MrCptSilva]

Shall I assume there is no support here but only at patreon?

[@mike330i]

Same here. The script run without any issue but the dividend function returned a blank value.

[@susigan]

dont work

[@Paddlehappy]

Great video thank you. for UCITS & ETFs no data is retrieved

[@greyhaircapitan]

the API has stopped working today, so, I don't see it is reliable, and I am switching to a different method.

[@fabforedev]

to be fair, other tickers are working, but obviously can't be relied upon

[@polisdrakas7925]

Only one problem. That function takes all dividend payments e.g. from January to July. But if we purchased only in the second quarter. And we received dividends only for one quarter. But that function shows us the total for the first and second quarters.

[@BERRYofficialmusic]

any solution??

[@georgestephens411]

Please make one for top 20 gainers and losers. thx

[@RedBarnFinancialTV]

This is great!

[@ericborzoni1399]

DOESNT WORK. IDK WHY

[@Ilakovi]

This doesn't work, it shows me 0% all the time.

[@lollipop1894]

This is frustrating as hell.

[@rockhead2700]

Too complicated, sorry.

[@SoCalChunkybutt]

thumbs down for email farming half way through

[@pankajkumars7316]

Hey, My execution was completed but still i couldnt find the dividend function in my sheet. Can you help me out?