App Icon
    =YHFINANCE is the easiest way to pull the Finance data into a spreadsheet. =YHFINANCE formula extends functionality of =GOOGLEFINANCE.
    By:
    Listing updated: January 29, 2024
    Works with:
    36K+
    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
    Pricing Free of charge trial
    Developer
    Support
    Privacy policy
    Terms of service
    Report Flag as inappropriate
    YHFINANCEwill 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
    Rate & review this app
    Share your experience to help others.
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    Reviews
    Language:
    Sort by:
    Google doesn't verify reviews or ratings. Learn more about reviews
    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
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    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
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    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
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    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
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    Profile Picture
    Gerard Rosell i Saldaña
    August 25, 2024
    Love it! It is helping me review stock and plan my investments.
    Is this review helpful?
    Yes
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    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
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    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
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    Profile Picture
    Chandra D
    July 4, 2024
    It is nice to work with YHFINANCE, where we just need to Add On this feature using google sheet extension, once done, just link YHFINANCE with the Ticker, dates etc, and it capture all required information from Yahoo Finance, it is great and I am enjoying it. Regards
    Is this review helpful?
    Yes
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    Profile Picture
    HeeCheon Darren Ko
    June 19, 2024
    Makes my portfolio tracker easy to be upadated. I would highly recommend to the others who are using CDR companies. 5 stars.
    Is this review helpful?
    Yes
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    Profile Picture
    Daniel Yu
    August 3, 2024
    Easy to implement
    Is this review helpful?
    Yes
    Yes
    No
    No
    profile avatar

    Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More

    1-10 of 198
    Search
    Clear search
    Close search
    Google apps
    Main menu
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: