=YHFINANCE is the easiest way to pull the Finance data into a spreadsheet. =YHFINANCE formula extends functionality of =GOOGLEFINANCE.
Listing updated:October 3, 2023
Works with:
31K+
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
Privacy policy
Terms of service
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
Mauricio Rodriguez
September 25, 2023
YHFINANCE for Google Sheets makes it easy to import and analyze financial data. With a few simple formulas, you can pull in real-time or historical data for stocks, ETFs, mutual funds, currencies, and more. YHFINANCE is a powerful tool for both individual investors and financial professionals. It can be used to track portfolio performance, conduct research, and create custom financial models. YHFINANCE is also very affordable, with a free trial and subscription plans. Overall, YHFINANCE is a must-have tool for anyone who needs to work with financial data in Google Sheets.
Is this review helpful?
Yes
No
Profile Picture
Ray Sampaga
July 19, 2023
This is something I've been looking for a long time. No more wasted time scraping websites and working on apps scripts that fail after a couple of days! Thank you for this extension. Thank you for saving my work time. It's the best extension out there if you're looking for mutual fund data!
Is this review helpful?
Yes
No
Profile Picture
rudra suman
August 3, 2023
YHFINANCE is a game-changer for crypto asset management. It effortlessly pulls real-time financial data into a spreadsheet, providing invaluable insights for informed decision-making. Its reliability and ease of use make it a superior alternative to the standard GOOGLEFINANCE function. Highly recommended for all crypto investors!
Is this review helpful?
Yes
No
Profile Picture
acpan22
September 28, 2023
It is simple to use and like it. But it seems there is no filter function for options? Like Puts only, Calls Only, ITM, OTM, ATM, limit X records, etc.
Is this review helpful?
Yes
No
Profile Picture
Sebastian
September 13, 2023
EASY TO USE JUST LIKE GOOGLE FINANCE BUT IT INCLUDES MOST OF CRYPTO
Is this review helpful?
Yes
No
Profile Picture
Ali Shoukat
September 26, 2023
Very good app. Can effortlessly pull YF data into sheets within seconds for multiple stocks. very easy to use. guide is very well written, easy to understand and follow. Saves ton of time when doing research and comparative analysis.
Is this review helpful?
Yes
No
Profile Picture
Ali Hesham
July 2, 2023
This add-on is just magic! Getting data from Yahoo finance has never been easier! there is still some improvements to be done but the developer has already made a great job with the existing features. Thank you for the great service!
Is this review helpful?
Yes
No
Profile Picture
Kjell Bleivik
August 23, 2023
Excellent. Special format for Norwegian stocks listed in Norway. Example on Euronext Oslo. DnB Norway's largesT bank. =YHFINANCE("DNB.OL","dividendYield") Example 2 Norwegain Stocks listed in the USA. Equinor - The largest Energy (fossile fuel) company in Norway. Ticker EQNR =YHFINANCE(A4,"dividendYield") Cell A4 includes the ticker EQNR. Very helpful.
Is this review helpful?
Yes
No
Profile Picture
Noorazrin Zakaria
August 1, 2023
Awesome sharing with 15 minutes delay data access ...
Is this review helpful?
Yes
No
Profile Picture
Patrick Tom
May 22, 2023
So far so good but not sure I am willing to pay $19/month for this, especially since it is not real-time data. I filtered through add-ons and specifically chose 'free' but after downloading, I feel like it was a bait and switch. Would love if there was a free version based on close prices as it would be nice to build reports this way. Delayed live data is not worth much. Emailed support to ensure it is not renewed as I could not find it under my subscriptions. Will update my review best on customer service.
Is this review helpful?
Yes
No
1-10 of 343
Search
Clear search
Close search
Google apps
Main menu