=YHFINANCE is the easiest way to pull the Finance data into a spreadsheet. =YHFINANCE formula extends functionality of =GOOGLEFINANCE.
By:
Listing updated:November 21, 2024
Works with:
39K+
Overview
=YHFINANCE is a spreadsheet formula that allows you to pull the Finance data directly into a Google Sheets spreadsheet. =YHFINANCE formula works in a similar way to =GOOGLEFINANCE for fetching current or historical securities information.

Save yourself from copy/paste hell, pull the Finance data without ever leaving Google Sheets. And =YHFINANCE 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:
=YHFINANCE
=YHFINANCE_QUOTES
=YHFINANCE_HISTORY
=YHFINANCE_STATEMENTS
=YHFINANCE_OPTIONS

PRICING

We offer a 7-day trial to test all the features of YHFINANCE for free. No credit card required, install the add-on and start using it!
After the free trial, upgrade to enjoy unlimited access to all YHFINANCE data for as low as $19/month.

******************************

Please rate the add-on 5 stars if you like it!
Additional information
PricingFree of charge trial
Developer
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
YHFINANCE will ask for the permissions shown below. Learn more
YHFINANCE will need access to your Google account
This will allow YHFINANCE to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Tom
February 2, 2025
Highly recommended to anyone who wants to make use of Yahoo Finance API within a few clicks. I use this add-on in Google Sheet to overcome the decimal points rounding issue in Google Finance API. It has been working well as expected to date.
Is this review helpful?
Yes
No
Profile Picture
S C
January 27, 2025
Useless if it’s a paid extension. Better to just use google finance instead since it’s free. Save your money. Didn’t realize I was on a free trial until I subscribed. Don’t get BAITED.
Is this review helpful?
Yes
No
Profile Picture
Prabha karan
November 19, 2024
YHFINANCE is a game-changer for anyone who needs to integrate financial data into their spreadsheets. It extends the functionality of =GOOGLEFINANCE with ease, making it incredibly simple to pull the latest finance data. I've been using it for several projects, and the accuracy and speed are unmatched. Highly recommended for both beginners and seasoned professionals looking to streamline their financial data management!
Is this review helpful?
Yes
No
Profile Picture
Handrus Stephan Nogueira
December 15, 2024
Where googlefinance fails yhfinance shines! I just wish info about daily limits and prices where more clear.
Is this review helpful?
Yes
No
Profile Picture
Maximilian Lahrmann
September 25, 2024
YHFINANCE is a game-changer for anyone who needs to integrate financial data into their spreadsheets. It extends the functionality of =GOOGLEFINANCE with ease, making it incredibly simple to pull the latest finance data. I've been using it for several projects, and the accuracy and speed are unmatched. Highly recommended for both beginners and seasoned professionals looking to streamline their financial data management!
Is this review helpful?
Yes
No
Profile Picture
Alexis Argent
January 28, 2025
love this app, so many more tickers i can import into google sheet now!
Is this review helpful?
Yes
No
Profile Picture
Bhaskararao Kandi
August 22, 2024
It is better than GoogleFinance formula and handy and takes 10seconds to refresh if more cells. Overall I find it very useful. They can reduce the price a bit.
Is this review helpful?
Yes
No
Profile Picture
Kush Saxena
December 19, 2024
Outstanding tool, super simple and gets the job done.
Is this review helpful?
Yes
No
Profile Picture
Jai Singh
September 13, 2024
Great Product! If you compare it with google finance then the best advantage is that the feed of YHFINANCE is almost real time. So if you need the real time feed for your calculations then it is the go to choice. Also there is no lag in relaying the data.
Is this review helpful?
Yes
No
Profile Picture
Joan Sacdalan
December 16, 2024
very helpful! it saves time and effort!
Is this review helpful?
Yes
No
1-10 of 186
Search
Clear search
Close search
Google apps
Main menu