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?
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.
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!
@@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.
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?
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?
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?
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.
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
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
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??
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.?
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?
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?
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?
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
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.
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
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
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?
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.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
This is a great video and I appreciate you putting it together! Thank You 🙂🙂
You are welcome! I’m glad you enjoyed.
i have been looking this function for a long time thanks alot for sharing this wonderful ideas
Great video!
I'm blown away by this feature. Didn't realize it was that easy to scrape without using code
yasss this is what I was looking for (I think... let's see if it actually works)
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?
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!
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?
Excellent guiding video. Thanks.
Smooth as it can be. Excellent. Liked, subscribed. 🫡
Thanks brother much appreciated simple and quick.
Thanks for your sharing!
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..
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.
Amazing video!
Can i track multiple seperate flights through this? I need it for tracking for travel job
Thank you so much from Perú . you re the best.
You're welcome!
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.
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.
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!
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
Very interesting and useful. Great content for all of us data nerds. Thanks!
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
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
Thank you for this helpful tutorial but is there a way to automatically update the data ?
damn!thank you for this brother super super great information
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?
Thank you so much for this!!!
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?
Thank you for this informative video.
How about extracting live indicator data ,say at a particular timestamp??
thanks but some sites like similar web wont let to scrape data any methods for that . ?
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?
You've got to be kidding me... This is next level awesome. THANK YOU!!!
You’re welcome!!
Awesome, thank you!
You're welcome!
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...😊
how if website need login ?
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.
Thanks lad!
does this update real time? If not do you know how to make it do so?
Does this work with linkedin?
Great content for all of us data nerds. Thanks!
You are welcome!
Nice video...but more than 100 ticker its take to mach time to update so any other idea to track revenue details.....
Thank you for this! :)
You're so welcome!
hey what if there's a quotation mark in the path? Can't figure it out
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.
Ty so much
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
Very good 👉🔔
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
Is webscraping a live function?
can we do same web scrapping for prices of articles listed on amazon???
Big Thumbs up to you.... Thanks
Thank you too!
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??
Do you know why some of these import take ages to load or just never load?
Thank you :)
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.?
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?
Thank you. But I cannot web scrap some ETF like GLD (gold). Can you help ?
Thx
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?
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?
Very interesting
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
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....
I cant figure out how to get levered cash flow. It doesn't seem to work for me.
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?
You have the best stock videos for beginners!
Thanks!!
First thanks but for me , wasn't working i had to use ; for separate now works good
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, what can i do when the website doen't allow the web scraping?
how can i import table in this case? thanks
wow what the heck this is awesome
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/
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?
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 ?
Hey any idea how importing google trends values for a period works?
Thank you so much you saved my whole month 😘
If I want chart,this method won’t work..what should I do to import stock chart pl inform
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
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 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.
too bad my triggers don’t work to auto update the sheet :(
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!
I tried it. Doesn't work.
I didn't know this was possible. Thank you for this tutorial! 🤗🤗
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, do you know why it is not working for some stocks like RETC, INND ,... ?
It didn't work for me as demonstrated.
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.
Great video, Wondering if anybody got the n/a message and how to fix it…? Thanks.
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!!
Awesome video with simple steps.. Thanks a lot.
Most welcome!
How to fx an error "Imported Content is Empty"?
How to pull list of company names around one building from google sheets
you can use the tools at Tickerdata.com !
showing an error: Resource at url contents exceeded maximum size.
always error parsing formula -,-
I can only find copy XPATH - I cant find copy full xpath
i cant get it too work
Very good! I tried with reuters site and I didn't get.
hello I am an Amazon seller, do you think I could retrieve the 2020 history in a Google sheet?
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...