App Icon
WebDataHub.com
•  5,260
Overview
=YAHOOFINANCE is the easiest way to pull Yahoo Finance data into a spreadsheet. =YAHOOFINANCE formula extends functionality of =GOOGLEFINANCE.
=YAHOOFINANCE is a spreadsheet formula that allows you to pull the Yahoo Finance data directly into a Google Sheets spreadsheet. =YAHOOFINANCE formula works in a similar way to =GOOGLEFINANCE for fetching current or historical securities information.

Save yourself from copy/paste hell, pull data from Yahoo Finance without ever leaving Google Sheets. And =YAHOOFINANCE add-on does not require any special API service configuration and knowledge of importJSON or importXml. Everything is preset for you.

Here is real-time data you can pull into Google Sheets with the next formulas:
=YAHOOFINANCE
=YAHOOFINANCE_QUOTES
=YAHOOFINANCE_HISTORY
=YAHOOFINANCE_STATEMENTS
Reviews
Language:
Sort by:
Profile Picture
Isaac Frisch
March 31, 2021
Product is nice but once you start using it you instantly see that its just a way for them to gauge for money. I use this add-on to pull FOUR sets of data and then all the data went blank and I received a message saying that I exceeded my limit. Do NOT download unless you expect to pay them money, and it is very expensive. My suggestion would be to learn how to pull your own data. Yes, it make take more time but you will gain excellent knowledge from doing so at no cost.
Is this review helpful?
Yes
No
Profile Pciture
Admin WebDataHub
March 31, 2021
100 calls per 24 hours for FREE 500 calls per 24 hours for $9.99/month 1000 calls per 24 hours for $17.99/month 5000 calls per 24 hours for $79.99/month 20000 calls per 24 hours for $299.99/month =YAHOOFINANCE_USAGE() to track the number of calls
Profile Picture
Elaine L
March 31, 2021
This is fantastic - it was frustrating that I could not retrieve SGX prices via Google Finance. This is so easy to use - instead of GOOGLEFINANCE, I replaced with YAHOOFINANCE. The Help section also gave very good hints
Is this review helpful?
Yes
No
Profile Pciture
Admin WebDataHub
March 31, 2021
Thank you, Elaine
Profile Picture
JP Wiegand
March 18, 2021
WebDataHub is a great discovery. I'm using it pull Yahoo Finance data into a Google Sheet that tracks stocks and options. Customer Support promptly replied to my question and guided me to using the =YAHOOFINANCE function for live stock and option quotes. It's a great Add-on.
Is this review helpful?
Yes
No
Profile Pciture
Admin WebDataHub
March 31, 2021
Thank you, JP
Profile Picture
Suraj kumar Badjatiya
March 17, 2021
how to get data for indian market NSE BSE.
Is this review helpful?
Yes
No
Profile Pciture
Admin WebDataHub
March 17, 2021
Dear Suraj, We never promised data for Indian market NSE BSE and this is not a place for questions.
Profile Picture
niteesh joshi
March 14, 2021
Fantastic ... immediately changed my spreadsheet to use yahoo data from addin instead of googlefinance which is becoming highly unreliable. Thank you.
Is this review helpful?
Yes
No
Profile Pciture
Admin WebDataHub
March 17, 2021
Thank you
Profile Picture
PRO CHARTS
January 1, 2021
I was searching for this kind of data....search ends here...thanks a lot
Is this review helpful?
Yes
No
Profile Pciture
Admin WebDataHub
January 3, 2021
You are very welcome.
Profile Picture
Samson Assefa
December 7, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Edwardo Marshall
November 1, 2020
This is a great add on and it does what it says on the tin. "Saves you from copy past hell" However, If there was a version that did more than just paste the info you need. A version that updated with the live figures, thati would pay for
Is this review helpful?
Yes
No
Profile Pciture
Joe Song
March 12, 2021
Agreed.
1-8 of 8
Additional information
WebDataHub.com
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu