=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
Loading
Search
Clear search
Close search
Google apps
Main menu