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.
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)
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.
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.
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?
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
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?
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?
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
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 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?
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.?
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
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.
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?
@@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.
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.
might be that you're not using the EN_US locale in your settings for googlesheets so it is rightly different for you. you can look up the locale differences on punctuation etc in the help there.
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
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 a great video and I appreciate you putting it together! Thank You 🙂🙂
You are welcome! I’m glad you enjoyed.
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!
Excellent guiding video. Thanks.
Smooth as it can be. Excellent. Liked, subscribed. 🫡
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?
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?
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.
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.
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
yasss this is what I was looking for (I think... let's see if it actually works)
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..
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?
Thanks brother much appreciated simple and quick.
Very interesting and useful. Great content for all of us data nerds. Thanks!
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 this video. I am able to fatch data from any site to sheet. This is very helpful . Thanks again.
You’re welcome!
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
Thank you. But I cannot web scrap some ETF like GLD (gold). Can you help ?
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.
how if website need login ?
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 so much from Perú . you re the best.
You're welcome!
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
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?
damn!thank you for this brother super super great information
I tried it. Doesn't work.
You have the best stock videos for beginners!
Thanks!!
Thank you for this helpful tutorial but is there a way to automatically update the data ?
Thank you so much for this!!!
Thanks lad!
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?
Nice video...but more than 100 ticker its take to mach time to update so any other idea to track revenue details.....
Very interesting
Awesome, thank you!
You're welcome!
thanks but some sites like similar web wont let to scrape data any methods for that . ?
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!
Thank you for this! :)
You're so 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?
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 didn't know this was possible. Thank you for this tutorial! 🤗🤗
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?
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?
hey what if there's a quotation mark in the path? Can't figure it out
Big Thumbs up to you.... Thanks
Thank you too!
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.
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, what can i do when the website doen't allow the web scraping?
how can i import table in this case? thanks
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?
Thank you :)
I can only find copy XPATH - I cant find copy full xpath
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 any idea how importing google trends values for a period works?
can we do same web scrapping for prices of articles listed on amazon???
Ty so much
too bad my triggers don’t work to auto update the sheet :(
Hi, do you know why it is not working for some stocks like RETC, INND ,... ?
wow what the heck this is awesome
If I want chart,this method won’t work..what should I do to import stock chart pl inform
always error parsing formula -,-
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
Also keep getting #N/A :(
How to pull list of company names around one building from google sheets
you can use the tools at Tickerdata.com !
hello I am an Amazon seller, do you think I could retrieve the 2020 history in a Google sheet?
Thx
showing an error: Resource at url contents exceeded maximum size.
i cant get it too work
Is webscraping a live function?
How to fx an error "Imported Content is Empty"?
Hi, great video, pls tell link will auto updated....
Awesome video with simple steps.. Thanks a lot.
Most welcome!
Does this work with linkedin?
Very good! I tried with reuters site and I didn't get.
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.
does this update real time? If not do you know how to make it do so?
Its not working..Can you check again?
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.
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
Would I be able to use this to add ROIC to your complete valuation model?
That could be possible!
@@Dividendology I’ll try
Error to me
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!!
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 ?
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.
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...
this works for US stocks but doesn't seem to work for Indian stocks....
Hi, could you figure this out? Did you add ". ns" to the ticker symbol?
Its not wokring for me, .. maybe bec of the link?
niceee
Plenty of sites don't support this
hello
It didn't work for a Sales Force table I'm trying to connect
Do you know why some of these import take ages to load or just never load?
Thank you for this informative video.
How about extracting live indicator data ,say at a particular timestamp??
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/
It didn't work for me as demonstrated.
Great video!
I'm blown away by this feature. Didn't realize it was that easy to scrape without using code
Actually, its no a coma "," its a semicolon ";" between of two arguments.
might be that you're not using the EN_US locale in your settings for googlesheets so it is rightly different for you. you can look up the locale differences on punctuation etc in the help there.
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...😊
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