Remember to check the correctness of the URL and XPath. Additionally, keep in mind that some websites may prevent or restrict access through the IMPORTXML function due to security restrictions or to prevent unauthorized web scraping. If the issue persists, it might be helpful to verify whether the website in question allows access and data extraction using the IMPORTXML function. Also, consider using more advanced tools such as APIs or scripts for extracting data from web pages.
This is great but I tried this and for some reason it says “Imported Content is Empty”. Then I tried the same thing you did for Kobe but got the same error. Is yours still working?
How can you pull variable data from a webpage? example: Only business addresses from a listing page that gives you multiple addresses and full descriptions of each address in between the addresses. How do you scrap specific variable data like that into a spreadsheet keeping it organized and separate from the other data?
@@MohitBadgotra-of7xu In this case the "tool" is Google sheets. In the past I had to write programs and use functions like split or import libraries like beautiful soup and requests. Then you have to deal with error handling. One change to the page or a 404 and your entire program might crash. Often I had to reformat the data and correct character sets too. That really sucks because the errors you see aren't obvious. There is a strange version of the quotation mark you run into a lot when scraping the web. It looks the same to the untrained eye but will break stuff if you don't catch it. Google sheets in this case makes it MUCH easier.
What would you do in the case that a website you're pulling prices from requires a log in? I have the login for the specific site i'm referencing, but what if you don't as well? More curious on how to do it if you have the login. For example, if I get specialty pricing from a hardware store that's only visible via my login, how would I automate that extraction?
nice video, thanks for posting! I've got two questions. 1) I get a N/A cell and the error is "could not fetch the url". What is the cause of this and is there any workaround? 2- Is there any way with this method to see the values changing in real time? thank you!
can you make something showing how to pull a specific portion of a financial statement. For example, free cash flow. I am trying to pull that from yahoo finance and it keeps giving me an error Resource url not found. I have followed your step by step instructions. Spent countless hours and can't find any help. Can you help? I see that in one of your tables you had the price to free cash flow auto populating so I figured you would now how to at least pull free cash flow. Please help.
Quick question, what if the stocks I want to look at is not a US stock and the stock is listed on an other stockexhange? then the stock have a little more to its ticker, but when I try to add CO/CPH (it's a danish stockexhance) then the scraping just says Error or N/A what to do?
Hello i dont know if you ever see my message but is seems google has changed something in their settings, the inspec option is not working as one unit but it shows all text so i can not scrape anything lately... am i wrong??
I'm running into an error. It says "imported content is empty". I've done this two or three times now and it worked for another site, but the yahoo finance site won't let me pull the data. Any thoughts?
When I try to pull prices from Etsy, it comes up as "Price: $1.70 Loading" instead of "$1.70". Is there a way to get just the price, or will I just have to deal with it? It also only works sometimes with Etsy, the xpath doesn't seem to be the same on every page and I can't always find the right part to highlight... It's similar with Amazon, if the price is $5.27 the $, 5, and 27 seem to be on different parts of the code so I can't figure out what to paste
Tell me, this function works for Facebook, I need to get the number of participants from the list of groups, the name of the group description is the number of participants, it doesn’t work.?
Great. Though I got a question what would you do if you got to a store front page that offered a price range that varies based on different options the user could pic but selecting the different options don't change the URL?
Buenos días. Consulta, porque al traer un dato de una pagina de cotizaciones, redondea el mismo y además no coincide en cantidad. El dato es 151.00 y me trae 1.600.000. Gracias
great video I learn a lot but this term is not successfully applied in my scenario because i am looking to pull meta description but my code shows me "empty data" what is the solution? thanx
Has anyone tried scraping from YH subsection pages like "Statistics" or "Financials" sections? I have tried scraping from there using importhtml and importxml and both seem to fail (only working in summary page)
Why it can't work on me although i do the same function ? literally same like what happened in this video, on me its always turn out either N/A or ERROR. IDK HWY ARHGGGGG
Thanks for making this. It helps tremendously. My one question is, is it a different function to pull in a chart/graph of a stocks trend? I tried importxml and followed the steps and i get an error (formula parse error). Any help?
My spreadsheet frequently changes prices that were working previously into #N/A with the message "Error, could not fetch URL: [url]", even before I turned on the auto-update feature. Would you happen to know why this happens, and how to fix it?
Yahoo finance has been a little finicky lately when it comes to webscraping using importantxml. I’ve noticed some elements not webscraping properly as well. I’m looking into solutions.
Hey man, really like you videos so keep it up. Also like the other i too am having an error with yahoo. I have been trying to import tables off their site and when i copy paste the site and find the table number it works. However when i delete the url to input the cell where i change the ticker symbol, all of a sudden it shows N/A. I have looked at all your videos on web scrappiing ect. and tried on my own with no success on inputting the cell with the ticker. And also with the xml fuction i am also not able to scape the differnt items from yahoo or other sites. i am on a chrombook but figured that would not matter to much, and also read that it might be a javascript problem but disabled that and tried but nothing seems to work. I am not a code writer so dont know what else to try, so if you are able to find a solution please post another video. Thanks
Thank you but It seems that it does not work, may be some update from Yahoo finance. In my case I receive: "N/A". Any help from you would be very nive as this function is very powerfull
I’ll have to look into this as it has worked for me in the past. Yahoo finance can be finicky at times, so maybe it’ll be a short term problem that gets fixed in the near future.
doesn't seem to work on views on youtube videos or instagram etc etc. But does work on the data you show in the video. How come?
Hi! I’ve tried the formula to import the full xpat section but now the cell return #N/D so can’t find the object at the url. Any suggestions?
did you find a fix? im getting the same issue
Remember to check the correctness of the URL and XPath. Additionally, keep in mind that some websites may prevent or restrict access through the IMPORTXML function due to security restrictions or to prevent unauthorized web scraping.
If the issue persists, it might be helpful to verify whether the website in question allows access and data extraction using the IMPORTXML function. Also, consider using more advanced tools such as APIs or scripts for extracting data from web pages.
This is great but I tried this and for some reason it says “Imported Content is Empty”. Then I tried the same thing you did for Kobe but got the same error. Is yours still working?
I have been looking for YEARS for a formula that would help me pull NBA win totals automatically -- this finally did it. Thank you so much!
You're welcome!
Great video!
I'm blown away by this feature. Didn't realize it was that easy to scrape without using code
i have been looking this function for a long time thanks alot for sharing this wonderful ideas
How can you pull variable data from a webpage? example: Only business addresses from a listing page that gives you multiple addresses and full descriptions of each address in between the addresses. How do you scrap specific variable data like that into a spreadsheet keeping it organized and separate from the other data?
Maybe you add the unfiltered data first then add another formula to delete the stuff that is not nessesary
Modern tools make this so much easier!
WHICH TOOLS PLEASE TELL ME
@@MohitBadgotra-of7xu In this case the "tool" is Google sheets. In the past I had to write programs and use functions like split or import libraries like beautiful soup and requests. Then you have to deal with error handling. One change to the page or a 404 and your entire program might crash. Often I had to reformat the data and correct character sets too. That really sucks because the errors you see aren't obvious. There is a strange version of the quotation mark you run into a lot when scraping the web. It looks the same to the untrained eye but will break stuff if you don't catch it. Google sheets in this case makes it MUCH easier.
@@jmr thank you for such a great information
@@MohitBadgotra-of7xu You're welcome. I hope it helps.
Thanks , your video is very good. But when I use this formula, error come is - import data is empty...Pls help
Can u help me in this..
Thanks for the video but this doesn't work for me and I've seen other people get the same #N/A Error Resource at URL not found - please help.
Same here, the Kobe example worked but not the MSFT one. Did you figure it out?
What would you do in the case that a website you're pulling prices from requires a log in? I have the login for the specific site i'm referencing, but what if you don't as well? More curious on how to do it if you have the login. For example, if I get specialty pricing from a hardware store that's only visible via my login, how would I automate that extraction?
nice video, thanks for posting! I've got two questions. 1) I get a N/A cell and the error is "could not fetch the url". What is the cause of this and is there any workaround? 2- Is there any way with this method to see the values changing in real time? thank you!
Is the site you’re trying to pull from password protected?
@@sawyersahagun2073 i get the same error, and yes the site is password protected
To make it change value in realtime, you may need to use Google Apps Script extension, and write a simple code to refresh formula.
Amazing video!
Smooth as it can be. Excellent. Liked, subscribed. 🫡
When I use the same function, but the cell shows"N/A". Do you have any idea what is the problem with it? Thank you!
This may be an error on yahoo finance send as I occasionally run into this.
@@Dividendology I am having the same issue scraping from any website. Any idea where I may be going wrong? Thank you
@@jtporter89 same issue here
@@DividendologyI couldn't even get the price for Microsoft does this still work
Yes same issue
Mindblowing stuff! I just managed to web scrap off another website based on the principles here! Thanks for teaching me something new!
Fantastic! Glad it helped!
thanks but some sites like similar web wont let to scrape data any methods for that . ?
Excellent guiding video. Thanks.
Nice! What about the 'Statistics' tab? It doesn't seem to allow me access to the Xpath on, say EV/EBITDA
I have a similar issue with the financecharts site
can you make something showing how to pull a specific portion of a financial statement. For example, free cash flow. I am trying to pull that from yahoo finance and it keeps giving me an error Resource url not found. I have followed your step by step instructions. Spent countless hours and can't find any help. Can you help? I see that in one of your tables you had the price to free cash flow auto populating so I figured you would now how to at least pull free cash flow. Please help.
Thank you for this informative video.
How about extracting live indicator data ,say at a particular timestamp??
I'm getting error: Resource at url not found. and as far as I can tell I'm doing exactly the same thing. Any suggestions?
how if website need login ?
Thank you. But I cannot web scrap some ETF like GLD (gold). Can you help ?
First thanks but for me , wasn't working i had to use ; for separate now works good
Thanks for your sharing!
Quick question, what if the stocks I want to look at is not a US stock and the stock is listed on an other stockexhange? then the stock have a little more to its ticker, but when I try to add CO/CPH (it's a danish stockexhance) then the scraping just says Error or N/A
what to do?
Hello i dont know if you ever see my message but is seems google has changed something in their settings, the inspec option is not working as one unit but it shows all text so i can not scrape anything lately... am i wrong??
I'm running into an error. It says "imported content is empty". I've done this two or three times now and it worked for another site, but the yahoo finance site won't let me pull the data. Any thoughts?
Thank you for this helpful tutorial but is there a way to automatically update the data ?
This is a great video and I appreciate you putting it together! Thank You 🙂🙂
You are welcome! I’m glad you enjoyed.
hey what if there's a quotation mark in the path? Can't figure it out
Hi bro, I want to import amazon product prices using URLs. But no matter what I do , my content is always empty. Can you help/
When I try to pull prices from Etsy, it comes up as "Price: $1.70 Loading" instead of "$1.70". Is there a way to get just the price, or will I just have to deal with it?
It also only works sometimes with Etsy, the xpath doesn't seem to be the same on every page and I can't always find the right part to highlight... It's similar with Amazon, if the price is $5.27 the $, 5, and 27 seem to be on different parts of the code so I can't figure out what to paste
Tell me, this function works for Facebook, I need to get the number of participants from the list of groups, the name of the group description is the number of participants, it doesn’t work.?
hello, what can i do when the website doen't allow the web scraping?
how can i import table in this case? thanks
I cant figure out how to get levered cash flow. It doesn't seem to work for me.
Nice video...but more than 100 ticker its take to mach time to update so any other idea to track revenue details.....
does this update real time? If not do you know how to make it do so?
Thanks brother much appreciated simple and quick.
Thank you nice, on the Home Screen in Yahoo its work, but not for the Split statistic. Can you make this for maybe divident yield...😊
can you post a video with the formula that works? I copied the exact formula you used in the video but didn't worked at all
Great. Though I got a question what would you do if you got to a store front page that offered a price range that varies based on different options the user could pic but selecting the different options don't change the URL?
Buenos días. Consulta, porque al traer un dato de una pagina de cotizaciones, redondea el mismo y además no coincide en cantidad. El dato es 151.00 y me trae 1.600.000. Gracias
Hi I wonder why it doesnt work when i do this with copying the youtube website title? Thank you.
I’m working on a new update!
great video I learn a lot but this term is not successfully applied in my scenario because i am looking to pull meta description but my code shows me "empty data" what is the solution? thanx
Do you know why some of these import take ages to load or just never load?
Does this work with linkedin?
can we do same web scrapping for prices of articles listed on amazon???
Has anyone tried scraping from YH subsection pages like "Statistics" or "Financials" sections? I have tried scraping from there using importhtml and importxml and both seem to fail (only working in summary page)
Cant get it to work either
Why it can't work on me although i do the same function ? literally same like what happened in this video, on me its always turn out either N/A or ERROR. IDK HWY ARHGGGGG
Same!
Thanks for making this. It helps tremendously. My one question is, is it a different function to pull in a chart/graph of a stocks trend? I tried importxml and followed the steps and i get an error (formula parse error). Any help?
If I want chart,this method won’t work..what should I do to import stock chart pl inform
Hi, do you know why it is not working for some stocks like RETC, INND ,... ?
Hey any idea how importing google trends values for a period works?
Thanks for this video. I am able to fatch data from any site to sheet. This is very helpful . Thanks again.
You’re welcome!
Hello, I've tried using Safari and Firefox to find Full XPath but it's not showing for either browser. Any thoughts on how to find Full XPath?
In Firefox it just gives you the option for XPath, but thankfully that is the exact same result as choosing Full XPath in Chrome.
Thank you so much from Perú . you re the best.
You're welcome!
yasss this is what I was looking for (I think... let's see if it actually works)
damn!thank you for this brother super super great information
My spreadsheet frequently changes prices that were working previously into #N/A with the message "Error, could not fetch URL: [url]", even before I turned on the auto-update feature. Would you happen to know why this happens, and how to fix it?
I’m getting ready to post an update! Stay on the look out!!
You've got to be kidding me... This is next level awesome. THANK YOU!!!
You’re welcome!!
Is webscraping a live function?
Very interesting and useful. Great content for all of us data nerds. Thanks!
How to fx an error "Imported Content is Empty"?
Thanks lad!
good stuff! i'm looking for a way to pull option chain data for stocks/indexes that i trade but have been unable to figure out a way....can you help?
I haven't tried that before. I'll have to look into it.
@@Dividendology any luck figuring this out?
Great content for all of us data nerds. Thanks!
You are welcome!
showing an error: Resource at url contents exceeded maximum size.
Great content. I follow the steps but it keeps say ERROR into the cell. I can't find what i'm doing wrong
What are you trying to webscrape?
@@Dividendology just like you i've tried to enter prices fron yahoo finance
Yahoo finance has been a little finicky lately when it comes to webscraping using importantxml. I’ve noticed some elements not webscraping properly as well. I’m looking into solutions.
@@Dividendology did you find any solution?
@@Dividendology Leaving comment to keep update for solution, having same issues too, appreciate and thanks in advance, subscribed.
Very interesting and useful. Will it auto refresh the page so you can see it update in real time? Or do you have to manually refresh the page somehow?
Google sheets automatically refreshes typically around every 20 minutes.
I tried it. Doesn't work.
It didn't work for me as demonstrated.
Thank you so much for this!!!
Would I be able to use this to add ROIC to your complete valuation model?
That could be possible!
@@Dividendology I’ll try
Hi, great video, pls tell link will auto updated....
Hey man, really like you videos so keep it up. Also like the other i too am having an error with yahoo. I have been trying to import tables off their site and when i copy paste the site and find the table number it works. However when i delete the url to input the cell where i change the ticker symbol, all of a sudden it shows N/A. I have looked at all your videos on web scrappiing ect. and tried on my own with no success on inputting the cell with the ticker. And also with the xml fuction i am also not able to scape the differnt items from yahoo or other sites. i am on a chrombook but figured that would not matter to much, and also read that it might be a javascript problem but disabled that and tried but nothing seems to work. I am not a code writer so dont know what else to try, so if you are able to find a solution please post another video. Thanks
^This
Great video, Wondering if anybody got the n/a message and how to fix it…? Thanks.
too bad my triggers don’t work to auto update the sheet :(
i cant get it too work
Thank you for this! :)
You're so welcome!
Awesome, thank you!
You're welcome!
You have the best stock videos for beginners!
Thanks!!
Thank you but It seems that it does not work, may be some update from Yahoo finance. In my case I receive: "N/A". Any help from you would be very nive as this function is very powerfull
I’ll have to look into this as it has worked for me in the past. Yahoo finance can be finicky at times, so maybe it’ll be a short term problem that gets fixed in the near future.
@@Dividendology yes please if you Can have a look...
hello I am an Amazon seller, do you think I could retrieve the 2020 history in a Google sheet?
it's blocked, that doesn't work anymore ??
I’m working on an update!
@@Dividendology ho okay thanks. But I think it could be easier to find an another website maybe ?
Its not working..Can you check again?
always error parsing formula -,-
How to pull list of company names around one building from google sheets
you can use the tools at Tickerdata.com !
I can only find copy XPATH - I cant find copy full xpath
Thank you :)
Very good 👉🔔
Thank you so much you saved my whole month 😘
Very interesting
I didn't know this was possible. Thank you for this tutorial! 🤗🤗
wow what the heck this is awesome
Very good! I tried with reuters site and I didn't get.
Big Thumbs up to you.... Thanks
Thank you too!
Ty so much
It is not posible to private website.