App Icon
=YAHOOFINANCE is the easiest way to pull Yahoo Finance data into a spreadsheet. =YAHOOFINANCE formula extends functionality of =GOOGLEFINANCE.
Works with:
13,388
Overview
=YAHOOFINANCE is a spreadsheet formula that allows you to pull the Yahoo Finance data directly into a Google Sheets spreadsheet. =YAHOOFINANCE formula works in a similar way to =GOOGLEFINANCE for fetching current or historical securities information.

Save yourself from copy/paste hell, pull data from Yahoo Finance without ever leaving Google Sheets. And =YAHOOFINANCE 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:
=YAHOOFINANCE
=YAHOOFINANCE_QUOTES
=YAHOOFINANCE_HISTORY
=YAHOOFINANCE_STATEMENTS
=YAHOOFINANCE_OPTIONS

PRICING

We offer a 7-day trial to test all the features of YAHOOFINANCE 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 YAHOOFINANCE 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, 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
Privacy policy
Terms of service
YAHOOFINANCE will ask for the permissions shown below. Learn more
YAHOOFINANCE will need access to your Google account
This will allow YAHOOFINANCE 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:
Profile Picture
chris319
June 11, 2021
Doesn't work. All I get is #NAME?
Is this review helpful?
Yes
No
Profile Picture
Dav Jaxx
May 18, 2021
It was ok, but the price was much higher than other options out there.
Is this review helpful?
Yes
No
Profile Picture
Charles Landriault
August 23, 2021
Works great for stock market quotes!
Is this review helpful?
Yes
No
Profile Picture
Brenda George
May 18, 2021
Just installed yesterday. Works well so far. Can't figure out how to make it refresh the figures though. Perhaps that's beyond its capability. (Even with only 22 rows in my database, it saved me hours in copying & pasting.)
Is this review helpful?
Yes
No
Profile Picture
Pritpal Singh
June 2, 2021
I love it.. very useful as I build my portfolio using yahoo finance. The ability to use within sheets is amazing. welldone guys!
Is this review helpful?
Yes
No
Profile Picture
Brian Solka
August 20, 2021
Works well with the cryptos I want to follow!
Is this review helpful?
Yes
No
Profile Picture
PRO CHARTS
January 1, 2021
I was searching for this kind of data....search ends here...thanks a lot
Is this review helpful?
Yes
No
Profile Picture
test test
August 29, 2021
Works well for my need.
Is this review helpful?
Yes
No
Profile Picture
Daniel Ribas
June 23, 2021
I'm very happy with everything. Works ;)
Is this review helpful?
Yes
No
Profile Picture
Florin Tomozei
August 23, 2021
Good app!
Is this review helpful?
Yes
No
1-10 of 66
Search
Clear search
Close search
Google apps
Main menu