App Icon
=YHFINANCE is the easiest way to pull the Finance data into a spreadsheet. =YHFINANCE formula extends functionality of =GOOGLEFINANCE.
Listing updated:December 18, 2022
Works with:
28,301
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.

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

TOP RATED APP

WebDataHub is one of the best rated apps on the G Suite marketplace and one of the most popular add-ons, among others, such as API Connector, SketchUp for Schools, LucidChart Diagrams, BetterCloud, Pear Deck, Lucidpress, BrainPOP, Form Ranger, Awesome Table, AODocs, EasyBib, GAT+, formLimiter, Smartsheet, Doctopus, Hapara Teacher, diagrams.net, SMART Learning Suite, Nearpod, Kami, Mavenlink, Marketview, Flubaroo, NoodleTools, MindMeister, Form Publisher, MathType, Backupify, Choice Eliminator, EasyBib, Bark, Digication, Cisco Webex, Form Mule, MindMup, SysCloud Security, Expensify, One Up, Xero, Zoho, Cryptosheets, Cryptofinance, Screencastify, Spanning Backup, Doc Appender, DocHub, Pixton for Schools,  Wrike, Virtu / Virtru Data Protection, Super Quiz, PowerSchool, JoeZoo Express, gPanel, LumApps, Asana, GQueues, chromebookInventory, Timify.me, DocuSign eSignature, Easy Accents, Kaizena, Kabanchi, Grackle Docs, Power Tools, PlanbookEdu, VoiceThread, Sketchboard, Mindomo, Mojo Helpdesk, Slido, Stupeflix, Certify'em, StackEdit, Colaboratory, GoFileDrop, Drag, PerformFlow, Avery Easy Merge, Avery Label Merge, Foxy Labels, Taskboard, Google Tasks Desktop, OK Goldy, Google Apps Training, Slides Translator, Turnitin Draft Coach, ProjectWork, Math Equations, CoRubrics, Mail Merge, Document Studio, Control Accepting Responses, Mover, s, Publigo, Folgo, Hew Viewer with Drive, Koalendar, Zipbooks, Smallpdf, Magic Rainbow Unicorns, Sedja, Apptivo, Adveronix, Evernote, WhatsApp, YAHOO, YAHOOFINANCE, Poshmark, Quilgo, PDFfiller, Airtable, OnlyOffice, ScheduleOnce, BeFunky, Photopea and more...

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

For our friends around the world, investments and real-time financial data translates to: Investitionen und Finanzdaten in Echtzeit | Investeringen en realtime financiële gegevens | Investissements et données financières en temps réel | Inversiones y datos financieros en tiempo real | Investimentos e dados financeiros em tempo real | Investimenti e dati finanziari in tempo reale | Επενδύσεις και οικονομικά δεδομένα σε πραγματικό χρόνο | Investice a finanční údaje v reálném čase | Inwestycje i dane finansowe w czasie rzeczywistym | Инвестиции и финансовые данные в реальном времени | Yatırımlar ve gerçek zamanlı finansal veriler | الاستثمارات والبيانات المالية في الوقت الحقيقي | 投资和实时财务数据 | 투자 및 실시간 재무 데이터 | 投資とリアルタイムの財務データ | การลงทุนและข้อมูลทางการเงินแบบเรียลไทม์ | निवेश और वास्तविक समय के वित्तीय डेटा | real time quotes, streaming charts, live stock market data, dividends data, investment tracking, investing, trade, trading, tracker, finance, market, data, analytics, stockbroker, adviser, ticker symbol, tickers, stock, etf, crypto, cryptos, cryptocurrency, altcoin, altcoins, bitcoin, btc

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

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
Henrik Sehested Laursen
February 25, 2023
Nice features but really not worth it for $19 a month for something I can get for free with Google Finance or import XML feature.
Is this review helpful?
Yes
No
Profile Picture
Sam Liyanage
March 13, 2023
Awesome tool to use however not worth the $19 paid subscription. Would have wanted a cut down version instead.
Is this review helpful?
Yes
No
Profile Picture
Mutuals India
November 29, 2022
App asks for 5 star review on G Marketplace on installation to get 1 month trial subscription . It looks suspicious to get good ranking. Don't install, all reviews seem to be fake without really using the app.
Is this review helpful?
Yes
No
Profile Picture
Matthew Nguyen
January 24, 2023
This app/plugin is unreal! We are using it to do some private company comps for a financial model. So great!
Is this review helpful?
Yes
No
Profile Picture
Jason Delbert
December 31, 2022
Great data for stocks and reviewing data but still don't know yet if I'd subscribe for the current monthly fee.
Is this review helpful?
Yes
No
Profile Picture
Colin Nelson
March 9, 2023
This extension saves me a ton of time and is great bang for your buck!
Is this review helpful?
Yes
No
Profile Picture
Michael Haase
December 22, 2022
I trade stocks with the help of Camarillo Pivots. YHFINANCE helps me to calculate the pivot levels using historical data, and at the same time, it also helps me to highlight trade signals using real-time market data. YHFINANCE is an excellent tool for various financial market use cases. Recommend.
Is this review helpful?
Yes
No
Profile Picture
Rick Viloria
February 27, 2023
This app is very easy and convenient to use!! I highly recommend it
Is this review helpful?
Yes
No
Profile Picture
Radu G
October 22, 2022
This API saved my research. I've been looking for a while at several scrapers but haven't found any so simple and intuitive. The api provides extensive data that can help investors to base their research.
Is this review helpful?
Yes
No
Profile Picture
Justin Waite
December 9, 2022
I tried for ages to use code but failed many times. This product takes the headache out of it. Thank you!
Is this review helpful?
Yes
No
1-10 of 286
Search
Clear search
Close search
Google apps
Main menu