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?
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).
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.
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.
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
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 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.
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?
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.
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
Any one else figure out why it is not returning the data? I am not getting an error just nothing displayed. I used all the examples he did in the video with no luck. If you have, have you also figured out how to get this to work with ETFs? Or does anyone know of all code that will wotk for ETFs.
Thanks for this. I got it to work easily, but it only returns a few yields then it starts showing 0% for new ones. I redid the API key and it worked, then stopped again. Any idea?
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
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
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.
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 ?
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).
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?
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?
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.
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)?
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.
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.
@@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.
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.
Great video, however, it seems the API Key keeps breaking or simply just working. I would get another Free API Key and the function would start working again but after a while, it would stop and only generate a return of 0. About 3 or 4 times, of getting another free key it would tell me to use another email address. Again, a great video, easier, better, and more accurate with dividend numbers than scraping data from Finviz. If only you didn't have to get a new API Key every time.
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
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!
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.
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 😢
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.
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
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
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.
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?
Me 2 😢
Did you find dividend function in your sheet?
Me too as well. Things must have changed since the video was created??
It doesn’t work . Tried a million different ways and got ChatGPT to check - massive waste of time
Nothing changed. Still works. Recheck your spelling in the function code.
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).
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.
Yield and Dividend not working for me, return 0 value, any fix? thank you for the video!!
Me too March 24
Not working here either.
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.
same here
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
Same for me
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.
@@obirlik68 Did you ever solve this? Having the same issue. Thanks!
@@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.
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?
having the same problem here.
It is working perfectly for stocks, but it is not working for ETFs is there a fix? for this. Cheers for your video.👍
it loads the cell but then its blank?
I do all the process with the apps script and is ok, but th dividend part in the table do not work.
tried but not working for indian stocks. no errors but in the last step in dividend yeild column its showing nothing.
The function is not returning my ETFs and ibm
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.
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
I am having the exact same problem.
Me too 😓
How do you get this to work for the Toronto Stock Exchange(TSE), or any other exchange?
Looks like it doesn't work for TSX stocks...
You can pull the stock using TSE:BNS, but the yield won't work.
TICKER.TRT
Any one else figure out why it is not returning the data? I am not getting an error just nothing displayed. I used all the examples he did in the video with no luck. If you have, have you also figured out how to get this to work with ETFs? Or does anyone know of all code that will wotk for ETFs.
doesnt work for in Argentina, for some reason
Hi! dont see Dividend funtion. Have you got any particular configuration? Thanks!
Thanks for this. I got it to work easily, but it only returns a few yields then it starts showing 0% for new ones. I redid the API key and it worked, then stopped again. Any idea?
I get an 'Unknown function' error for the =Dividend(A2)*1 part????? Can someone help?
I get an 'Unknown function' error for the =Dividend(A2)
Hey, My execution was completed but still i couldnt find the dividend function in my sheet. Can you help me out?
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
add a column for share amounts and multiply by that cell in addition to what was shown.
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
He shows you in the video how to get passed that 7:30
not working
cell showing blank
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?
when i type =Dividend(A2) that cell shows 0 does anyone know why?Please help
Does not work for NSE stocks!
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.
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 ?
Sir, can we get dividend details for Indian ticker from NSE also ? Thanks
What can we do to display new symbols dividends, the function does not find them :
The API run with no problem but the spreadsheet is responding: Unknown function 'Dividend'. What could be the problem?
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?
same thing happened to me, I'm trying to troubleshoot it. Quite frustrating.
I fixed it. Mine was missing an = before apiKey, make sure that's there
Great video! Thanks for making this very easy to follow. I'm getting the error reference error url not defined line 4
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).
Worked great. Other than about 30% of the yields are not updating. I am trying to troubleshoot to figure out why
I had a similar issue. I'm thinking it's because the stock is listed on another exchange like the NASDAQ.
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?
Shall I assume there is no support here but only at patreon?
Same here. The script run without any issue but the dividend function returned a blank value.
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?
The free version of the API only allows 25 data requests per day.
Thank you for your reply! @@buddybrooks9659
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
Can you get the Ex-Dividend Date with this API?
I have been trying to do this for a long time. Excellent video. I really appreciate what you have done. It works perfectly.
I do it and it is all right!!!! can you do the same with the dividend day?
worked perfectly - is Ex Date available? I looked at the documentation couldn't find anything on dividend data.
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.
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)?
Yep. Doesn't work for me. Tried the exact tickers ...nada
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.
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.
@@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.
@MichealHyde67 “Alice Marie Coraggio’’ You can easily look her up, she has years of financial market experience.
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?
any solution??
Still not working.
doesnt work in my case
It's Not Working for me, does anyone has a solution?
You just made my life SOO much easier. Thank you! I never subscribe to anyone, but you just earned it!
Very concise and useful educational video. Thanks a lot for this!
I glad you think so!
DOESNT WORK. IDK WHY
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.
You are a master blaster, my friend. Thank you.
Followed down to the letter and doesn't work at all. I get 0.00%
I only get three rows to work. After that, it is all zero yield.
Good tutorial, but alphavantage not supporting indexfunds and ETFs
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
Tried using this and for some stocks it worked. But for others such as AAPL, ABBV, BTI, EPD, SCHD, VTI - no luck. Any recommendations?
Great video, however, it seems the API Key keeps breaking or simply just working. I would get another Free API Key and the function would start working again but after a while, it would stop and only generate a return of 0. About 3 or 4 times, of getting another free key it would tell me to use another email address.
Again, a great video, easier, better, and more accurate with dividend numbers than scraping data from Finviz. If only you didn't have to get a new API Key every time.
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
dont work
Great video, but the script does not determine dividends for ETFs
How to make it defining not only for companies?
It was a very nice video.
How can I get data for this formula and Turkish stocks?
Great video and solution. Is Ex-Dividend date available?
Could you just add to the description the full code?
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
Thank you so much! Indeed this is graet! Can you add the "Ex dividend day" also?
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!
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.
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 😢
you are a god. Thanks for not putting this through a paywall like the rest of the universe. Consider a donate button.
Excellent tutrorial - thank you!
this exercise was a sive for time, doesn't work. would be great to paste the code snippet for copy/paste, otherwise too tedious.
Great video....straight to the point...No BS!!!
the API has stopped working today, so, I don't see it is reliable, and I am switching to a different method.
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.
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
to be fair, other tickers are working, but obviously can't be relied upon
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
Can you make a video how to see crypto closing prices or open prices?
Amazing!
I previously posted that it didn’t work now it works. I guess it took time. Thanks Great video
Nope, not for me
Still hasnt for me either
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.
This doesn't work, it shows me 0% all the time.
This is amazing!
Good job. Thank you.
Great video thank you. for UCITS & ETFs no data is retrieved
This could have been a blog post.
This is great!
Please make one for top 20 gainers and losers. thx
This is frustrating as hell.
Too complicated, sorry.
Doesn't work