How to get Yahoo Finance Data in Google Sheets!

[@Dividendology]

*UPDATE* Here is an updated video on how to do this: kzbin.info/www/bejne/l4uck6OLqs6iZ7s

[@sohailmalik5481]

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.

[@Dividendology]

Fantastic!

[@briane.2778]

Your tutorials are great, advanced feautures explained with ease. Thanks alot!

[@Dividendology]

You are welcome!

[@cpatimevalue69]

Did they change something , I cant get dividend date to import. I Get #N/A

[@BobSaggit69]

Not only this I also get an error message: "Resource at url contents exceeded maximum size."

[@btpd912]

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.

[@rymelo2405]

Same.

[@kevinspaeth5895]

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.

[@iamrsgill]

Data not found even if I copy the same code

[@sajalsukharanjande9120]

url not found

[@jayedsheath]

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).

[@Dividendology]

Working on an update

[@usmleibm]

Did you find any solution? Thanks@@Dividendology

[@elizastefanescu5390]

Great video! ❤ It is working. Thanks alot! A little update here, use ; instead of , and will work like in the video. Keep it up! ☀️

[@piotrk2269]

thank you

[@mbabcock111]

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,

[@chrisinflight5298]

How come I receive an errorn "could mot fetch URL on every one of these I try from multiple sources. Can someone please help.

[@2NormalHuman]

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 //)

[@JoeCarena]

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.

[@ResuelveloTu]

It seems to be that it doesn't work anymore. It always says that the imported data is empthy. Any update in 2024? Thanks

[@Dividendology]

Yep! Here's the updates video: kzbin.info/www/bejne/l4uck6OLqs6iZ7s

[@guershon9114]

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?

[@TheCPelsor]

I'm having the same problem. Will post if I find a solution.

[@filippoghezzi654]

@@TheCPelsor Found a solution?

[@baalzhamon8491]

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

[@JustinSharePickers]

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.

[@FabsBlog07]

I get the same thing were you able to find the solution?

[@endysdoodoo]

This doesn't work anymore

[@elizastefanescu5390]

Hi! It works but you need to use ; instead of , and will work properly.

[@m.anandakumar9065]

How

[@amanjaelani]

Still worked

[@m.anandakumar9065]

@@amanjaelani send the code

[@Punkinchunks]

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.

[@SoulMarauder59]

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

[@Dividendology]

You are welcome!

[@SoulMarauder59]

Oh they changed so you dont write , between the expressions but ;

[@ICTARABIC]

@@SoulMarauder59 getting value error,needs table and list

[@sandeepkumar-js3gi]

Same here...

[@Play-jv3oi]

​@@Dividendology can we find the float on that google sheet?

[@ironm88]

Hi sir, is not working anymore I think, at least for me the formula now shows an #ERROR! 😢

[@genemerritt5536]

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.

[@AH247-qn5uf]

Thank you. Great job.

[@boerke772]

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.

[@aliagha.huseynli]

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. (((

[@AE-sy1pn]

same thing is happening to me

[@cristiandarioarevalolopez3791]

First of all thanks for sharing this video, a question, is the data updated on real time from Yahoo finance? Thank you so much

[@Dividendology]

Google sheets periodically updates automatically.

[@philloes2778]

@@Dividendology Do you know how to update it manually? If I want all cells to update right now?

[@CantHealz]

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

[@filippoghezzi654]

I checked the question marks but they are correct. Still getting the error message

[@FabsBlog07]

@@filippoghezzi654 me too have you guys figured this out?

[@corvinlord]

Great job bro, thank you.

[@amateurinvestorchronicles]

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 kzbin.info/www/bejne/hJbQk4ieetiebdk , but if you want to get everything working some coding knowledge is unfortunately needed.

[@tiinif]

Yeaaah I have just seen your video! In addition thanks to @dividendology for this great video too :)

[@eloiwallaert2630]

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

[@CantHealz]

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

[@Jonnyrockin71]

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.

[@eliogarcia2955]

I get the error "Could not fetch url..." I'm copying and pasting the url, but don't know what to do.

[@filippoghezzi654]

Found a solution?

[@ElioG]

@@filippoghezzi654 no unfortunately.

[@major8forextrading30]

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.

[@adarshpatil2163]

Please make a full spreadsheet stock trading automation course it will be helpful

[@annamonso1937]

I think that is no longer working. I am doing the exact same thing as you, and it is not working for me.

[@jayedsheath]

Have you been able to fix it? Im getting the same error

[@Play-jv3oi]

can we find the float on that google sheet?

[@PurveshPatel-u6e]

it is showing error with import data is empty, please help me why it is showing it?

[@Dividendology]

You now have to use the TickerData add on in google sheets! TickerData.com

[@sebastianandersson7270]

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?

[@felipeturbayr]

Thanks for this information! very useful! do you know why sometimes the formula wont update and stays on "loading..."?

[@Dividendology]

I haven’t run into that error before with yahoo finance data. If I find out, I’ll be sure to let you know.

[@bobkoss280]

@@Dividendology Have you found out anything about "Loading..." for a long time, and then ending up with #N/A

[@vaclavkinsky6964]

Same here @@bobkoss280

[@NaturalAltitudes]

This no longer seems to be working.

[@useful4537]

Data shows up then vanished, How to solved it? Thanks in advance.

[@sambo8100]

Thanks for the videos, I keep getting an imported content is empty error, any fix for this?

[@elizastefanescu5390]

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 ;

[@乾淨核能]

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?

[@TroyAtyeo]

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

[@jeremiethompson7798]

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...

[@Dividendology]

I haven't run into that problem before. I'll have to look into it.

[@jeremiethompson7798]

@@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

[@baalzhamon8491]

I have to use microsoft edge instead of firefox due to this

[@bobkoss280]

I got that in Firefox. I switched to Chrome and now see "full xpath"

[@michaeldhont3805]

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]

Hi Michael, what were you trying to webscrape from yahoo finance? Some metrics may be slightly different.

[@michaeldhont3805]

@@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.

[@Dividendology]

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.

[@michaeldhont3805]

@@Dividendology thnx, I will take a look at that.

[@weihu2064]

not working for stock code with dot or foregin stocks

[@Dividendology]

working on an update for this

[@radomillion]

@@Dividendology Have you found an update yet for foreign stocks?

[@seeyawouldntwannabeya347]

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.

[@jadepriest7209]

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

[@jayedsheath]

Getting the same problem. Have you fix it?

[@Archer-c6m]

Its not working, I'm sure its a user error, but what could it be?

[@skenderaxe5968]

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)

[@Dividendology]

I'll look into ways to do this.

[@harveymoment]

@@Dividendology Any update on this? Can't get the book value per share to turn up, XPath appears broken/weird

[@iamnomadgg]

Any update on this? @@Dividendology

[@SoftwareSolusindocom]

to implement shares in Indonesia?

[@modernismdelendaest1511]

Thanks, very helpful! Do you know is there a similar function in Excel?

[@Dividendology]

I believe excels power query function provides similar capabilities, but I’m guessing there are other ways to do it in excel as well!

[@jimd1617]

thank you 🤝

[@A7480394]

Thank-you so much!

[@mangekyousharingan7335]

unfortunately it does not work, do you have another solution? Thanks

[@WinterKing2811]

Mine not working as well. Something related to google blocking importxml i believe...

[@Dividendology]

I’m surprised it’s not working for you, as I haven’t had any problems. Are you receiving an error message?

[@soumya178]

@@Dividendology yes it's showing #NA

[@XInfinity2024]

@@soumya178 That is the same error that I have been getting

[@EnormousClock]

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!

[@umair5807]

I am facing the same issue. Have you got any solution for this error?

[@krishnasubramanian792]

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

[@BetasCoin]

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. kzbin.info/www/bejne/g3LMZ2WEaLtkfpY

[@stockstuff7395]

it doesnt work after i change it to update it to differnt stocks also "," is replaced with ";"

[@maciejwnuk1812]

Hello, seens doesn't work for tickers with "." in URL ;/

[@asianlvl]

Im getting an error pulling "Growing Estimates, Next 5 Years (per annum)". Does anyone know how to solve it?

[@rayli6640]

I am facing the same problem either

[@michaeldhont3805]

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]

may be an error on yahoo finance's end. Some people have been having trouble lately.

[@michaeldhont3805]

@@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

[@claudiocaiti138]

It doesn't work to me! I can't understand why. I copy everything in the same way. What's wrong?

[@Dividendology]

They may have changed their website out look. I'm working on an update.

[@claudiocaiti138]

@@Dividendology Thank you

[@johnhe9984]

How to pull data from balance sheet in yahoo finance?

[@Dividendology]

I am currently searching for a way to do this.

[@moisesbenavides]

This is very useful! Thank you for sharing. How do I split the 52 Week Range data (Low and High) separately?

[@jakelamotta7904]

FY

[@koriv6329]

Does this not work with Options Data ?

[@stevewilson6524]

Anyone notice in this video that yahoo is displaying $315.41, but when he imports it, spreadsheet has $313.86?

[@jerrydellasala7643]

Doesn't work any more. Finance recently went through a big change. Hope this can be updated to work!

[@Dividendology]

Working on a custom solution that won’t break :)

[@sharktooth-gp3jz]

Hi I got a problem with your function, is someone able to help me?

[@olaranes2402]

Dosent work on any other then american stocks

[@ciph3rwolf345]

Thanks man.

[@traleyton8057]

Somehow it does not work. Probably Yahoo has introduced a problem.

[@radomillion]

Which exchange and company stock price do you want?

[@RxBTC]

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

[@s-statik]

Sadly not working

[@thomaskreisel5764]

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]

I’m working on a solution for this!

[@thomaskreisel5764]

@@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]

Yep, thats actually something Im trying to work on. It may take some time, but I'll find a way to make it happen.

[@thomaskreisel5764]

@@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!

[@stephanevachon8273]

I'm getting information from 2 days ago ???

[@erickrgarcia]

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?

[@Dividendology]

I’m working on creating a custom solution with a developer!

[@erickrgarcia]

@Dividendology thank you replying back. Look forward to the video.

[@dbarrantescr]

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.

[@rohitsethi2627]

Same for me, only working on Summary section, not on Satistics

[@dbarrantescr]

@@rohitsethi2627 I tried about everything I could think of but didn't manage to make it work. If anyone knows please let us know!

[@deivisonaraujo9922]

Great video and explanation.

[@arqingmx]

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.

[@Dividendology]

I created the tickerdata add on in google sheets to auto import stock financials straight into your spreadsheet. Link in description.

[@Quroe_]

I feel like I'm being given the keys to the internet.

[@Dividendology]

🔑

[@cmli0203]

sorry, i can't get the date and dividends... Historical Data > dividends only > Time Period (Max)

[@vrivas2186]

Get #ERROR! formula parse error?

[@Dividendology]

I’m working on an update!!

[@rockhead2700]

It works except the price doesn't fluctuate like on Yahoo Finance! and I refreshed like 6 times.

[@ICTARABIC]

updates every 1 minute in settings

[@mehradhajati9057]

this does not work

[@kavanaroy3484]

Its not working for me :(

[@willbreece]

Very interesting

[@PoonsYungv]

The price doesnt change when it changes on yahoo finance it just stays the same

[@Dividendology]

Google sheets will update periodically. Typically around every 20 minutes

[@rayli6640]

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.

[@Dividendology]

I've had some trouble scraping from Yahoo finance lately as well. Im creating a new solution for this!

[@rayli6640]

​@@Dividendology ok, I am not alone😂

[@electroartesanias]

doesn't work with yahoo, only works with finviz

[@Dividendology]

Im working on a new custom solution!

[@FinanzasSinCorbata]

For those with a Spanish keyboard, be advise to separate arguments with semicolon (;) and not with commas (,), otherwise it doesnt work....😩

[@Dividendology]

thank you!!

[@FinanzasSinCorbata]

@@Dividendology You are most welcome, your work is great. Thank you!

[@Fakaax]

TE AMO VIEJAA!!!

[@lewiskerchuis8017]

Anyone getting "Resource at URL not found" I fixed it by deleting UK from the yahoo web address.

[@KrekreDoBusao]

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 ;

[@aaronderouen5873]

Anyone else getting "Imported content is empty" when trying this?

[@Dividendology]

I'm creating a new method to do this. Stay tuned!

[@Gragento]

Doesn't for me.

[@muhammadshehzad4764]

not wroking

[@erniecheung5282]

No longer works.

[@Dividendology]

I’m working on a new solution

[@rebym]

@@Dividendology So why waste everyone's time? Pin a comment that says that it no longer works!

[@italianjump]

Non funziona purtroppo. Grazie lo stesso.

[@sdl9258]

Good

[@Daddywaah]

I keep getting that darn 'Resource not found at url" again. >:(

[@Dividendology]

Yahoo finance has been a little ‘hit or miss’ lately. I’m looking into other webscraping options currently.

[@Daddywaah]

@@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. :)

[@danb7146]

@@Dividendology Have you figured out why importxml and importhtml won't work a good amount of time with Yahoo Finance?

[@Omar-sq6zz]

This is not scalable.

[@Dividendology]

I’m working on a new solution! :)

[@Archer-c6m]

This explanation and others suck as a step, a crucial step is being left out.

[@WebBeMee]

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?