=YHFINANCE is the easiest way to pull the Finance data into a spreadsheet. =YHFINANCE formula extends functionality of =GOOGLEFINANCE.
Listing updated:January 29, 2024
Works with:
35K+
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
Miljan Martic
December 28, 2023
One star because they bribe users to leave a 5 star review to get a 1-month free subscription. Not a bad addon if you want to pay $19/month, otherwise find something else.
Is this review helpful?
Yes
No
Profile Picture
wethrox Wethrox
January 25, 2024
Great addon, lets me navigate my portfolio I've created on sheets with ease. Highly recommend it, it is a necessity if you want real-time data with accuracy.
Is this review helpful?
Yes
No
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
James C
February 23, 2024
Fantastic extension that gives you access to far more statistics than Google Finance.Highly recommend for anyone that wants to build their own analysis within Google Sheets.
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
Akwinder Dhindsa
December 5, 2023
This add-on is just fantastic and very helpful. Getting data from Yahoo Finance has never been easier! It is simple and easy to use. Highly recommended
Is this review helpful?
Yes
No
Profile Picture
Anand Jain
June 17, 2024
The tool is beneficial and easy to use. I would love to recommend it to others.
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
Jiesen
February 13, 2024
Highly recommend the extension! Super helpful to sync the token price from YHFinance to Google Sheets.
Is this review helpful?
Yes
No
Profile Picture
Radu G
November 19, 2023
Best API available on the market. Super user friendly interface that is simple to use . Great job
Is this review helpful?
Yes
No
1-10 of 161
Search
Clear search
Close search
Google apps
Main menu