You were a lifesaver today. I found this video to be incredibly valuable when I encountered a significant roadblock. Thanks to this video, I successfully completed my client's project.
Very informative and easy to follow! Thanks for showing how to get this done. I too am running into "Error: Loading Data....." message, but I think this is because of the amount of data elements I am asking for within the file, not just the few fields on the page you showed in your example.
Followed your example for stock price but returns "resource at url not found". I'm trying to grab VGAB from Yahoo. It's Vanguard Global Aggregate Bond Index ETF found on the NEO exchange in Canada. Thank you,
it's a bad advice to copy the full xpath. Because if there is any change in attributes beginning from the root to the element, the absolute xpath will become invalid. Copy the relative xpath instead (the one that starts with //)
Copying the relative path didn't work. No copy/paste options are working. This is frustrating because the formula works for other sites, like his Wikipedia example, but not Yahoo Finance. This was all a waste of time and I assume it was intentional to get us to pay for his tickerdata service.
Doesn't work anymore, it seems that Yahoo Finance website could be using any Java formating. There is an error now in Google Sheets "Imported content is empty" when you do what you are doing when taking the earnings date (You cant really do much anymore).
Thanks for your video! Very informative. I 'm trying to do this with the estimated 5 yr growth (using the url of the "analysis tab") but I get: "Error: Resource at url not found". Any idea?
For those having issues with the Industry Column coming up #Error. Make sure there are not extra Quotation Marks at the end of your input.. thats what was causing my error
I am getting an error message that says "resource at url not found". Thought that it might have been due to my language settings, so I tried starting a new one in english, but no luck there either
Any change to the document structure of the Yahoo page is going to break this. These hard-coded XPaths are very fragile. I don't know if the import XML function allows x query but that would be more robust.
Is it possible to pull the Analyst Data (Sell, Under, Hold, etc.) data from Market watch into Google Sheets? Been trying but I cant get it to up day with each different cell
Amazing work. I have a question about making a Google Sheet for Forex Trading and if you can fetch and parse data like bank interest rates, GDP, inflation numbers and Import & Export numbers of 8 Economies for the major 8 currencies around the globe. Perhaps possible to fetch the data from Yahoo Finance page. I would like to hear from you in this regard. Thank you.
What about the Valuation Measures table in the Statistic tab? I have trouble applying the same command rule with the "Current x Enterprise Value/EBITDA" value (link, XPath)
Many thanks for your video, It doesnt seems to work at my computer. He is giving an error ''imported content is empty'' (translated from Dutch) . Any idea what I might have done wrong ?
@@Dividendology Thanx for your reaction. I would like to have for example Forward Dividend & Yield and some data from the statistics like Return on Assets, Totall cash etc etc.
One thing I recommend is to watch my web scraping in google sheets video. I show how to web scrape data from Finviz, where it is extremely easy to pull in all of the things you just mentioned into google sheets.
Hello, do you know why it only works with stocks and not cryptocurrency? I do exactly the same with both and with cryptocurrency, I receive the message "resource at URL contents exceeded maximum size" . I only want to insert the actual value.
i can get anything above the "Summary Chart Conversations Statistics Historical Data Profile Financials Analysis Options Holders Sustainability" tabs to work, but not the data in the tabs, help plz?
Will repeat myself here. To anyone wandering why IMPORTXML does not work for all xpaths (for example data from statistics or financials tab). The IMPORTXML only works for webpage content which is statically generated, but unfortunately most of the data in yahoo finance is dynamically generated. In this case, the whole process becomes a bit more complex. I have managed to get it working with python (+selenium) script. I made a simple video about it here th-cam.com/video/NembUhEsk7w/w-d-xo.html , but if you want to get everything working some coding knowledge is unfortunately needed.
I am using a MacBook and try to double click on the areas and all I get is the area highlighted I try and do "control" and click and get options but I do not see an "inspect" option. What am I doing wrong.... please help
Seeing a lot of ‘Resource at URL not found’ - despite their obviously being available values for things like price. It seems to happen mainly for smaller cap companies. At first I thought it was an issue with an exchange extension, in my case .L for LSE companies, but then I got it to work for BP. So I can get it work, and am repeating the exact process for other companies with no success. Helpful video nonetheless, thank you!
Instead of pulling data using htmlimport, then you can pull all data on Yahoo Finance using the fact that it is build on Javascript. I just made a video showcasing my version of this if you need. th-cam.com/video/MAi62N3V1H4/w-d-xo.html
I have some problems with the last step, when I try to change the Ticker I get an error . In Dutch "parseerfout in formule" parsing error in formula . Any idea what it means or how I can solve it. Many thanks
@@Dividendology I can finaly scrape data from yahoo finance, so thank your for this tutorial. One more question , I only can retrieve data from the Summary, any idea what this can be? thnks
Has anyone tried scraping from YH "Statistics" or "Financials" sections? I have tried using both IMPORTHTML and IMPORTXML but non of them seem to work other than the homepage (summary) section.
most companies prevent webscraping via importxml or any import function via googlesheet. This no longer works because mostwebsites use java and google sheets cant pull/read stuff coded in java
Anyone knows how to get other data like FCF or shares outstanding in google sheets? seems like The data down below isnt accessable for google sheets. Didnt work for me!
@@Dividendology Sounds good! I would like to have an intrinsic calue calculator, where you just have to change the ticker to get the intrinsic value of a stock. That would be great! Please let me know how if you figured something out!
@@Dividendology I found this intrinsic value calculator in google. I tried to copy it into my spread sheet. But for some numbers like FCF he is using a formula which I dont understand how it works. Its something like "=Data!....". Maybe you check this out and find it helpful!
AUGUST 2024 -- For those who also get ERROR or N/A, this will be expected to happen because Yahoo Finance uses DYNAMIC CONTECT to update this values, and this formula only works with STATIC CONTENT. So this WON'T work. If anyone finds a way to do it please share it.
Check if your separator is semi-colon instead of comma. European separator is normally not the same as the US ones. I fixed that simply by changed the , to ;
Did Yahoo Finance ban web scraping in Google Sheets? I followed the tutorial but I cannot retrieve any data from Yahoo finance. I can retrieve data from Finviz and seeking alpha though.
*UPDATE* Here is an updated video on how to do this: th-cam.com/video/aZ9bpUuio1Y/w-d-xo.html
You were a lifesaver today. I found this video to be incredibly valuable when I encountered a significant roadblock. Thanks to this video, I successfully completed my client's project.
Fantastic!
typed in exactly as you to get x-div date, and I get "#n/a error resource at url not found". Don't understand what I am doing wrong.
Same.
Very informative and easy to follow! Thanks for showing how to get this done. I too am running into "Error: Loading Data....." message, but I think this is because of the amount of data elements I am asking for within the file, not just the few fields on the page you showed in your example.
Your tutorials are great, advanced feautures explained with ease. Thanks alot!
You are welcome!
Did they change something , I cant get dividend date to import. I Get #N/A
Not only this I also get an error message: "Resource at url contents exceeded maximum size."
Followed your example for stock price but returns "resource at url not found". I'm trying to grab VGAB from Yahoo. It's Vanguard Global Aggregate Bond Index ETF found on the NEO exchange in Canada. Thank you,
it's a bad advice to copy the full xpath. Because if there is any change in attributes beginning from the root to the element, the absolute xpath will become invalid. Copy the relative xpath instead (the one that starts with //)
Copying the relative path didn't work. No copy/paste options are working. This is frustrating because the formula works for other sites, like his Wikipedia example, but not Yahoo Finance. This was all a waste of time and I assume it was intentional to get us to pay for his tickerdata service.
How come I receive an errorn "could mot fetch URL on every one of these I try from multiple sources. Can someone please help.
Doesn't work anymore, it seems that Yahoo Finance website could be using any Java formating. There is an error now in Google Sheets "Imported content is empty" when you do what you are doing when taking the earnings date (You cant really do much anymore).
Working on an update
Did you find any solution? Thanks@@Dividendology
Thanks for your video! Very informative. I 'm trying to do this with the estimated 5 yr growth (using the url of the "analysis tab") but I get: "Error: Resource at url not found". Any idea?
I'm having the same problem. Will post if I find a solution.
@@TheCPelsor Found a solution?
For those having issues with the Industry Column coming up #Error. Make sure there are not extra Quotation Marks at the end of your input.. thats what was causing my error
I checked the question marks but they are correct. Still getting the error message
@@filippoghezzi654 me too have you guys figured this out?
Data not found even if I copy the same code
url not found
I am getting an error message that says "resource at url not found". Thought that it might have been due to my language settings, so I tried starting a new one in english, but no luck there either
Great video! ❤ It is working. Thanks alot! A little update here, use ; instead of , and will work like in the video. Keep it up! ☀️
thank you
HI thanks for the video but I can't get this to work, all I get is #N/A Error Resources at URL not found.
I get the same thing were you able to find the solution?
Nice info and video.
Have you done any importing of option chain data, single calls into excel or Google Sheets?
Keep making the videos.
Thank you.
I was looking for this for 30 minutes! Everyone showed how to import the tables but I needed only one information (the stock price)
Thanx
You are welcome!
Oh they changed so you dont write , between the expressions but ;
@@SoulMarauder59 getting value error,needs table and list
Same here...
@@Dividendology can we find the float on that google sheet?
This doesn't work anymore
Hi! It works but you need to use ; instead of , and will work properly.
How
Still worked
@@amanjaelani send the code
Any change to the document structure of the Yahoo page is going to break this. These hard-coded XPaths are very fragile.
I don't know if the import XML function allows x query but that would be more robust.
Hi sir, is not working anymore I think, at least for me the formula now shows an #ERROR! 😢
First of all thanks for sharing this video, a question, is the data updated on real time from Yahoo finance?
Thank you so much
Google sheets periodically updates automatically.
@@Dividendology Do you know how to update it manually? If I want all cells to update right now?
It seems to be that it doesn't work anymore. It always says that the imported data is empthy. Any update in 2024? Thanks
Yep! Here's the updates video: th-cam.com/video/aZ9bpUuio1Y/w-d-xo.html
Thanks for this information! very useful! do you know why sometimes the formula wont update and stays on "loading..."?
I haven’t run into that error before with yahoo finance data. If I find out, I’ll be sure to let you know.
@@Dividendology Have you found out anything about "Loading..." for a long time, and then ending up with #N/A
Same here @@bobkoss280
Is it possible to pull the Analyst Data (Sell, Under, Hold, etc.) data from Market watch into Google Sheets? Been trying but I cant get it to up day with each different cell
Very good explainer video. I am getting some drift on my prices...what I see in Yahoo Finance is not exactly the same as what's in the sheet.
Amazing work. I have a question about making a Google Sheet for Forex Trading and if you can fetch and parse data like bank interest rates, GDP, inflation numbers and Import & Export numbers of 8 Economies for the major 8 currencies around the globe. Perhaps possible to fetch the data from Yahoo Finance page. I would like to hear from you in this regard. Thank you.
I get the error "Could not fetch url..." I'm copying and pasting the url, but don't know what to do.
Found a solution?
@@filippoghezzi654 no unfortunately.
I did same thing but my result is #N/A I dunno why. I even copy your formula and paste it. It does not work anymore I think. (((
same thing is happening to me
What about the Valuation Measures table in the Statistic tab? I have trouble applying the same command rule with the "Current x Enterprise Value/EBITDA" value (link, XPath)
I'll look into ways to do this.
@@Dividendology Any update on this? Can't get the book value per share to turn up, XPath appears broken/weird
Any update on this? @@Dividendology
Please make a full spreadsheet stock trading automation course it will be helpful
Thanks, very helpful! Do you know is there a similar function in Excel?
I believe excels power query function provides similar capabilities, but I’m guessing there are other ways to do it in excel as well!
Hey man ! Do you know how to have the "Full XPath" options in the copy options...? When i'm at this step, I only have: HTML, XPath for choice...
I haven't run into that problem before. I'll have to look into it.
@@Dividendology thanks for the answer !! It looks like my mac don’t offer me the option of Full Xpath… I am looking on internet but find nothing
I have to use microsoft edge instead of firefox due to this
I got that in Firefox. I switched to Chrome and now see "full xpath"
Hi, Bert good video, but when I am trying the code for price it says that I can not have a = in the begining, Any idea?
I think that is no longer working. I am doing the exact same thing as you, and it is not working for me.
Have you been able to fix it? Im getting the same error
Many thanks for your video, It doesnt seems to work at my computer. He is giving an error ''imported content is empty'' (translated from Dutch) . Any idea what I might have done wrong ?
Hi Michael, what were you trying to webscrape from yahoo finance? Some metrics may be slightly different.
@@Dividendology Thanx for your reaction. I would like to have for example Forward Dividend & Yield and some data from the statistics like
Return on Assets, Totall cash etc etc.
One thing I recommend is to watch my web scraping in google sheets video. I show how to web scrape data from Finviz, where it is extremely easy to pull in all of the things you just mentioned into google sheets.
@@Dividendology thnx, I will take a look at that.
Thanks for the videos, I keep getting an imported content is empty error, any fix for this?
Hello! Use ; instead of , and will work. I had the same issue and I saw in the Google sheet syntax that you need to use ;
Hello, do you know why it only works with stocks and not cryptocurrency? I do exactly the same with both and with cryptocurrency, I receive the message "resource at URL contents exceeded maximum size" . I only want to insert the actual value.
i can get anything above the "Summary
Chart
Conversations
Statistics
Historical Data
Profile
Financials
Analysis
Options
Holders
Sustainability" tabs to work, but not the data in the tabs, help plz?
Will repeat myself here. To anyone wandering why IMPORTXML does not work for all xpaths (for example data from statistics or financials tab). The IMPORTXML only works for webpage content which is statically generated, but unfortunately most of the data in yahoo finance is dynamically generated. In this case, the whole process becomes a bit more complex. I have managed to get it working with python (+selenium) script. I made a simple video about it here th-cam.com/video/NembUhEsk7w/w-d-xo.html , but if you want to get everything working some coding knowledge is unfortunately needed.
Yeaaah I have just seen your video! In addition thanks to @dividendology for this great video too :)
Hello sir,
your link is not working. It said that the video is private. How can I watch it please ?
Thank you for your answer
Great job bro, thank you.
This is very useful! Thank you for sharing. How do I split the 52 Week Range data (Low and High) separately?
FY
Thank you. Great job.
What is the formula to get the Growth Estimates - Next 5 Years (per annum) off the Analysis page on yahoo finance ?, I keep getting error message
Doesn't work now for me. I typed in exactly like this video says. I get the "resource at url not found" I wished this worked.
Im getting an error pulling "Growing Estimates, Next 5 Years (per annum)". Does anyone know how to solve it?
I am facing the same problem either
can we find the float on that google sheet?
Data shows up then vanished, How to solved it? Thanks in advance.
I am using a MacBook and try to double click on the areas and all I get is the area highlighted I try and do "control" and click and get options but I do not see an "inspect" option. What am I doing wrong.... please help
Getting the same problem. Have you fix it?
Seeing a lot of ‘Resource at URL not found’ - despite their obviously being available values for things like price.
It seems to happen mainly for smaller cap companies. At first I thought it was an issue with an exchange extension, in my case .L for LSE companies, but then I got it to work for BP. So I can get it work, and am repeating the exact process for other companies with no success.
Helpful video nonetheless, thank you!
I am facing the same issue. Have you got any solution for this error?
Hi, The coding doesn't work for UK stocks for example, Airtel africa, etc. Please help me how to bring UK stocks details in google sheet
Instead of pulling data using htmlimport, then you can pull all data on Yahoo Finance using the fact that it is build on Javascript. I just made a video showcasing my version of this if you need. th-cam.com/video/MAi62N3V1H4/w-d-xo.html
not working for stock code with dot or foregin stocks
working on an update for this
@@Dividendology Have you found an update yet for foreign stocks?
This no longer seems to be working.
Doesn't work any more. Finance recently went through a big change. Hope this can be updated to work!
Working on a custom solution that won’t break :)
I have some problems with the last step, when I try to change the Ticker I get an error . In Dutch "parseerfout in formule" parsing error in formula . Any idea what it means or how I can solve it. Many thanks
may be an error on yahoo finance's end. Some people have been having trouble lately.
@@Dividendology I can finaly scrape data from yahoo finance, so thank your for this tutorial. One more question , I only can retrieve data from the Summary, any idea what this can be? thnks
It doesn't work to me! I can't understand why. I copy everything in the same way. What's wrong?
They may have changed their website out look. I'm working on an update.
@@Dividendology Thank you
it is showing error with import data is empty, please help me why it is showing it?
You now have to use the TickerData add on in google sheets! TickerData.com
it doesnt work after i change it to update it to differnt stocks also "," is replaced with ";"
Anyone notice in this video that yahoo is displaying $315.41, but when he imports it, spreadsheet has $313.86?
How to pull data from balance sheet in yahoo finance?
I am currently searching for a way to do this.
Hello, seens doesn't work for tickers with "." in URL ;/
unfortunately it does not work, do you have another solution? Thanks
Mine not working as well. Something related to google blocking importxml i believe...
I’m surprised it’s not working for you, as I haven’t had any problems. Are you receiving an error message?
@@Dividendology yes it's showing #NA
@@soumya178 That is the same error that I have been getting
to implement shares in Indonesia?
Has anyone tried scraping from YH "Statistics" or "Financials" sections? I have tried using both IMPORTHTML and IMPORTXML but non of them seem to work other than the homepage (summary) section.
Same for me, only working on Summary section, not on Satistics
@@rohitsethi2627 I tried about everything I could think of but didn't manage to make it work. If anyone knows please let us know!
thank you 🤝
Somehow it does not work. Probably Yahoo has introduced a problem.
Which exchange and company stock price do you want?
most companies prevent webscraping via importxml or any import function via googlesheet. This no longer works because mostwebsites use java and google sheets cant pull/read stuff coded in java
Sadly not working
Its not working, I'm sure its a user error, but what could it be?
Thank-you so much!
I hold BDT, CM & CP to name a few that I am having issues with dividend dates. Can anybody suggest a fix or know a video to correct issue?
I’m working on creating a custom solution with a developer!
@Dividendology thank you replying back. Look forward to the video.
Anyone knows how to get other data like FCF or shares outstanding in google sheets? seems like The data down below isnt accessable for google sheets. Didnt work for me!
I’m working on a solution for this!
@@Dividendology Sounds good! I would like to have an intrinsic calue calculator, where you just have to change the ticker to get the intrinsic value of a stock. That would be great! Please let me know how if you figured something out!
Yep, thats actually something Im trying to work on. It may take some time, but I'll find a way to make it happen.
@@Dividendology I found this intrinsic value calculator in google. I tried to copy it into my spread sheet. But for some numbers like FCF he is using a formula which I dont understand how it works. Its something like "=Data!....". Maybe you check this out and find it helpful!
Hi I got a problem with your function, is someone able to help me?
sorry, i can't get the date and dividends...
Historical Data > dividends only > Time Period (Max)
Dosent work on any other then american stocks
AUGUST 2024 -- For those who also get ERROR or N/A, this will be expected to happen because Yahoo Finance uses DYNAMIC CONTECT to update this values, and this formula only works with STATIC CONTENT. So this WON'T work. If anyone finds a way to do it please share it.
I created the tickerdata add on in google sheets to auto import stock financials straight into your spreadsheet. Link in description.
It works except the price doesn't fluctuate like on Yahoo Finance! and I refreshed like 6 times.
updates every 1 minute in settings
Thanks man.
Does this not work with Options Data ?
The price doesnt change when it changes on yahoo finance it just stays the same
Google sheets will update periodically. Typically around every 20 minutes
I feel like I'm being given the keys to the internet.
🔑
I'm getting information from 2 days ago ???
Anyone getting "Resource at URL not found" I fixed it by deleting UK from the yahoo web address.
Check if your separator is semi-colon instead of comma. European separator is normally not the same as the US ones. I fixed that simply by changed the , to ;
this does not work
For those with a Spanish keyboard, be advise to separate arguments with semicolon (;) and not with commas (,), otherwise it doesnt work....😩
thank you!!
@@Dividendology You are most welcome, your work is great. Thank you!
doesn't work with yahoo, only works with finviz
Im working on a new custom solution!
Its not working for me :(
Get #ERROR! formula parse error?
I’m working on an update!!
Anyone else getting "Imported content is empty" when trying this?
I'm creating a new method to do this. Stay tuned!
Doesn't for me.
Very interesting
Great video and explanation.
Did Yahoo Finance ban web scraping in Google Sheets?
I followed the tutorial but I cannot retrieve any data from Yahoo finance.
I can retrieve data from Finviz and seeking alpha though.
I've had some trouble scraping from Yahoo finance lately as well. Im creating a new solution for this!
@@Dividendology ok, I am not alone😂
not wroking
No longer works.
I’m working on a new solution
@@Dividendology So why waste everyone's time? Pin a comment that says that it no longer works!
TE AMO VIEJAA!!!
Non funziona purtroppo. Grazie lo stesso.
I keep getting that darn 'Resource not found at url" again. >:(
Yahoo finance has been a little ‘hit or miss’ lately. I’m looking into other webscraping options currently.
@@Dividendology Cheers for that Div, I appreciate the reply so I can stop scratching my head for now. I'm just glad I wasn't screwing something up. :)
@@Dividendology Have you figured out why importxml and importhtml won't work a good amount of time with Yahoo Finance?
This is not scalable.
I’m working on a new solution! :)
Good
This explanation and others suck as a step, a crucial step is being left out.
So my data is converted to "xx.xx.xx", basically date. How do i get the string from the website (the stock price) to be a number in my sheet?