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.
@NelsonHouse787 ай бұрын
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.
@nuraahmadumar89377 ай бұрын
@@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.
@nuraahmadumar89377 ай бұрын
@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.
@baigani03 ай бұрын
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?
@jerryball77837 ай бұрын
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
@sergioarena6 күн бұрын
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-Plays11 ай бұрын
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!!
@thejudge23525 ай бұрын
Me too March 24
@joelnichols36113 ай бұрын
Not working here either.
@OmaticFever7 ай бұрын
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_4 ай бұрын
He shows you in the video how to get passed that 7:30
@RoniejeBuh4 ай бұрын
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?
@wreinus9 ай бұрын
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
@BreakingGravityPT8 ай бұрын
I am having the exact same problem.
@JuniorHel7 ай бұрын
Me too 😓
@arielonnis17 ай бұрын
Hi! dont see Dividend funtion. Have you got any particular configuration? Thanks!
@Tanejasinghangadast211 ай бұрын
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
@martinunger95454 ай бұрын
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
@NajiKelley10 ай бұрын
I had a similar issue. I'm thinking it's because the stock is listed on another exchange like the NASDAQ.
@Cherokeeman9611 ай бұрын
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.s10 ай бұрын
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
@obirlik6810 ай бұрын
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.
@dianawojcik32618 ай бұрын
@@obirlik68 Did you ever solve this? Having the same issue. Thanks!
@obirlik688 ай бұрын
@@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.
@otmastitel9 ай бұрын
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
@januszjaxaxa99294 ай бұрын
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).
@davidwilding4 ай бұрын
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?
@dawens319911 ай бұрын
Tried using this and for some stocks it worked. But for others such as AAPL, ABBV, BTI, EPD, SCHD, VTI - no luck. Any recommendations?
@leesmith92993 ай бұрын
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_Audio5 ай бұрын
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.
@DecisiveMoves3659 ай бұрын
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?
@buddybrooks96598 ай бұрын
The free version of the API only allows 25 data requests per day.
@DecisiveMoves3657 ай бұрын
Thank you for your reply! @@buddybrooks9659
@ultrasrock11 ай бұрын
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 ?
@bfrock018 ай бұрын
Great video and solution. Is Ex-Dividend date available?
@ivank37187 ай бұрын
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
@alaattinozturk988310 ай бұрын
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!
@ellasprihatini71487 ай бұрын
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?
@Winston0Boogie11 ай бұрын
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-li1oi4ii3e10 ай бұрын
Great video....straight to the point...No BS!!!
@jcvzz10 ай бұрын
I do all the process with the apps script and is ok, but th dividend part in the table do not work.
@pcsharma89265 ай бұрын
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?
@buddybrooks96598 ай бұрын
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.
@joshuarosenberg15283 ай бұрын
it loads the cell but then its blank?
@nimrodhadany9504 Жыл бұрын
What can we do to display new symbols dividends, the function does not find them :
@jivepatrol68337 ай бұрын
Excellent tutrorial - thank you!
@sarubinca9 ай бұрын
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?
@russojar8 ай бұрын
I only get three rows to work. After that, it is all zero yield.
@earthman47486 ай бұрын
I get an 'Unknown function' error for the =Dividend(A2)
@pkaronis18 ай бұрын
I get an 'Unknown function' error for the =Dividend(A2)*1 part????? Can someone help?
@obirlik6810 ай бұрын
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.
@obirlik6810 ай бұрын
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
@obirlik6810 ай бұрын
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.
@obirlik6810 ай бұрын
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_Trader7 ай бұрын
Does not work for NSE stocks!
@Gragento Жыл бұрын
Can you make a video how to see crypto closing prices or open prices?
@gamesview331310 ай бұрын
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?
@dianawojcik32618 ай бұрын
same thing happened to me, I'm trying to troubleshoot it. Quite frustrating.
@dianawojcik32618 ай бұрын
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.
@powerclash84883 ай бұрын
It's Not Working for me, does anyone has a solution?
@polisdrakas792511 ай бұрын
Doesn't work
@TheSmallsAbroad10 ай бұрын
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
@Paddlehappy7 ай бұрын
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.
@fabforedev9 ай бұрын
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.
@BERRYofficialmusic10 ай бұрын
any solution??
@georgestephens4116 ай бұрын
Please make one for top 20 gainers and losers. thx
@RedBarnFinancialTV11 ай бұрын
This is great!
@ericborzoni13999 ай бұрын
DOESNT WORK. IDK WHY
@Ilakovi Жыл бұрын
This doesn't work, it shows me 0% all the time.
@lollipop18946 ай бұрын
This is frustrating as hell.
@rockhead27002 күн бұрын
Too complicated, sorry.
@SoCalChunkybutt7 ай бұрын
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?