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?
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!
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)
@@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.
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?
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??
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.
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?
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
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
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
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?
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?
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.?
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
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?
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?
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.
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 I understand that but people clearly have problems with getting it to work so maybe a disclaimer or trying to figure out or maybe fixing what is causing so many problems would be nice.
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 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!
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?
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?
This is a great video and I appreciate you putting it together! Thank You 🙂🙂
You are welcome! I’m glad you enjoyed.
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.
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?
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.
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..
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
Excellent guiding video. Thanks.
Thank you. But I cannot web scrap some ETF like GLD (gold). Can you help ?
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.
yasss this is what I was looking for (I think... let's see if it actually works)
Very interesting and useful. Great content for all of us data nerds. Thanks!
You've got to be kidding me... This is next level awesome. THANK YOU!!!
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?
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
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??
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.
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
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
Smooth as it can be. Excellent. Liked, subscribed. 🫡
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...😊
Thank you for this helpful tutorial but is there a way to automatically update the data ?
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?
Thanks for this video. I am able to fatch data from any site to sheet. This is very helpful . Thanks again.
You’re welcome!
Thanks brother much appreciated simple and quick.
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'm getting error: Resource at url not found. and as far as I can tell I'm doing exactly the same thing. Any suggestions?
Great content for all of us data nerds. Thanks!
You are welcome!
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/
Nice video...but more than 100 ticker its take to mach time to update so any other idea to track revenue details.....
thanks but some sites like similar web wont let to scrape data any methods for that . ?
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
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
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?
how if website need login ?
Thank you so much from Perú . you re the best.
You're welcome!
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?
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.?
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
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.
Great video, Wondering if anybody got the n/a message and how to fix it…? Thanks.
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!
It didn't work for a Sales Force table I'm trying to connect
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 your sharing!
You have the best stock videos for beginners!
Thanks!!
I cant figure out how to get levered cash flow. It doesn't seem to work for me.
hey what if there's a quotation mark in the path? Can't figure it out
hello, what can i do when the website doen't allow the web scraping?
how can i import table in this case? thanks
too bad my triggers don’t work to auto update the sheet :(
It didn't work for me as demonstrated.
Hey any idea how importing google trends values for a period works?
hello I am an Amazon seller, do you think I could retrieve the 2020 history in a Google sheet?
damn!thank you for this brother super super great information
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
can we do same web scrapping for prices of articles listed on amazon???
Hi, do you know why it is not working for some stocks like RETC, INND ,... ?
I didn't know this was possible. Thank you for this tutorial! 🤗🤗
showing an error: Resource at url contents exceeded maximum size.
How to pull list of company names around one building from google sheets
you can use the tools at Tickerdata.com !
I tried it. Doesn't work.
If I want chart,this method won’t work..what should I do to import stock chart pl inform
I can only find copy XPATH - I cant find copy full xpath
Thank you so much for this!!!
Very interesting
Thanks lad!
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!!
Hi, great video, pls tell link will auto updated....
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?
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 you saved my whole month 😘
How to fx an error "Imported Content is Empty"?
wow what the heck this is awesome
always error parsing formula -,-
Awesome, thank you!
You're welcome!
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 good! I tried with reuters site and I didn't get.
Thank you for this! :)
You're so welcome!
Big Thumbs up to you.... Thanks
Thank you too!
Thank you :)
Ty so much
i cant get it too work
does this update real time? If not do you know how to make it do so?
i need forex real time dollar index, japanese index etc to google sheets
The tickerdata add on in google sheets can do that! Tickerdata.com
Also keep getting #N/A :(
Would I be able to use this to add ROIC to your complete valuation model?
That could be possible!
@@Dividendology I’ll try
Is webscraping a live function?
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...
Its not working..Can you check again?
Does this work with linkedin?
Awesome video with simple steps.. Thanks a lot.
Most welcome!
Very good 👉🔔
Everyone has issues with it but he only replies to positive comments
Just trying to make a helpful video!
@@Dividendology I understand that but people clearly have problems with getting it to work so maybe a disclaimer or trying to figure out or maybe fixing what is causing so many problems would be nice.
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 wokring for me, .. maybe bec of the link?