Pull real-time quotes, key fundamentals, financial indicators, and more into your sheets to have the information you need to make better decisions all in one place.
Listing updated:June 14, 2023
Works with:
27K+
Overview
Pull real-time quotes, key fundamentals, financial indicators, and more into your sheets to have the information you need to make better decisions all in one place. Marketview gives you the control to manage your investments better.

WHY MARKETVIEW?

➤ MANAGE AS YOU LIKE: Pull all the financial data you need into your sheets and personalize your dashboards to visualize your investment portfolio in a way that suits your needs.
➤ TAKE FULL CONTROL: Don’t miss out on any opportunity. Track the value of all US stocks, ETFs, and crypto in your portfolio while monitoring your potential investments simultaneously.
➤ MAKE BETTER DECISIONS: Stop guessing and taking risks. Know the status of your investments at any time by having the information you need all in one place.

FEATURES

➤ 2500+ financial assets supported: US stocks, ETFs, and the most popular cryptocurrencies
➤ Returns real-time data and historical data
➤ Fundamental, technical, and performance indicators available
➤ Quick and easy to set up: as simple as =MARKETVIEW(A1, "price")
➤ Formula Builder to create complex custom functions in a few clicks
➤ Auto-update of real-time data every 60 minutes and historical data every 24 hours
➤ Unlimited data calls/day for every user

ALL SUPPORTED DATA

➤ Real-time data:
	⁃ Real-time price quote
	⁃ Price as of market open
	⁃ Previous day's closing price
	⁃ Price change since the previous day's close
	⁃ Percentage change in price 
	⁃ Current day's high & low prices
	⁃ 52-week high & low prices
	⁃ Current trading volume
	⁃ Market cap of the stock
	⁃ Beta value
	⁃ P/E ratio
	⁃ Earnings per share
	⁃ Forward dividend & yield
	⁃ Analysts 12-month price target estimate
	⁃ Analysts ratings: daily, weekly, monthly
	⁃ Bearish and bullish sentiment levels
	⁃ Stock’s industry 
	- Stock’s logo (most popular stocks only)
➤ Historical data:
	⁃ Price change 1W, 1M, YTD, 1Y, and 3Y

TUTORIAL

1. Click on the FORMULA BUILDER menu to open the add-on sidebar.
2. In “Insert in Cell” input the cell reference (e.g. “B2”) of where you want to insert the data.
3. In “Ticker Symbol Cell” input the CELL REFERENCE of where the corresponding ticker is located (e.g. “A2”).
4. Select then the Data Type you want to pull and the specific Data Attribute from the dropdown menus (e.g. “Real Time Data” and “Price”)
5. Click on Create and in a few seconds you’ll see the data generated in the cell selected in step 1.

SUPPORT

Have questions or need help getting started? Please check our 

User Manual:
➢ https://cutt.ly/user_manual

Contact us here:

➢ MarketviewSupport@WealthAssistants.com


PRICING

We offer a 15-day trial to test all the features of Marketview for free. No credit card required, install the add-on and enjoy it!
After the free trial, upgrade to enjoy unlimited access to all Marketview data for as low as $2.99/month (Just $0.1 /day) for a year.

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

UPDATES & RELEASES

January 9th 2022 - Our crypto API has been upgraded and 16 new cryptocurrencies are now available via Marketview. You can now pull data for a total of 364 cryptos into your sheets - and we won’t stop there. Following the API upgrade, we are now able to support crypto assets that in the past were not available, so do not hesitate to send us your requests for missing tickers to be added.

December 29th 2021 - Marketview’s ticker database has been cleaned up and expanded: new trending stocks and ETFs, more crypto coins, and 2021’s biggest gainers.

October 8th 2021 - The conflict between multiple add-ons has been resolved. You can now use Marketview along with other apps or Google functions without incurring data limits or loading issues.

April 25th 2021 - The user manual and ticker database now open automatically also for users with external links and pop-ups disabled in their browser settings.

March 29th 2021 - Over 200 new crypto assets have been added to our database. Marketview now lets you track all cryptocurrencies listed on Yahoo Finance.

March 17th 2021 - Our crypto database has been expanded. Marketview now supports all TOP 100 cryptocurrencies by market cap!

March 16th 2021 - Marketview’s server & database have been migrated to a Google Cloud Enterprise solution to support the increasing number of users and volume of data calls. Data loading and auto-updating are now much faster and guarantee superior performances! 

January 15th 2021 - The compatibility issue with older versions of Marketview (e.g. ‘unknown function’ error message) has been fixed and the data loading error has been resolved.

October 16th 2020 - Marketview has been upgraded with new and more complete functionalities such as: new and improved historical data and charts; unlimited data calls/day for every user (including trial users).

August 11th 2020 - The invalid syntax issue due to some users’ Google Sheets locale has been fixed. The Formula Builder will now automatically identify and generate the correct syntax based on your locale settings. Enjoy creating custom functions in a few clicks!


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

TOP RATED APP

Marketview is one of the best rated apps on the G Suite marketplace and one of the most popular add-ons, among others, such as 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, 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, API Connector, 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 | الاستثمارات والبيانات المالية في الوقت الحقيقي | 投资和实时财务数据 | 투자 및 실시간 재무 데이터 | 投資とリアルタイムの財務データ | การลงทุนและข้อมูลทางการเงินแบบเรียลไทม์ | निवेश और वास्तविक समय के वित्तीय डेटा | Google Finance, GoogleFinance, Yahoo Finance, YahooFinance, Market View, Morningstar, Refinitiv, S&P, Nasdaq, Alpha Vantage, real time quotes, streaming charts, live stock market data, investment tracking, investing, trade, trading, tracker, finance, market, data, analytics, stockbroker, adviser, ticker symbol, tickers, stock, etf, crypto, cryptos, cryptocurrency, bitcoin, nft, nfts, altcoin, altcoins, btc

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

DISCLAIMER

Marketview (This add-on) and its authors are not responsible for any trading loss incurred by following the data returned. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice.

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

WEBSITE: https://WealthAssistants.com
USER MANUAL: https://cutt.ly/user_manual
CONTACT US: MarketviewSupport@WealthAssistants.com

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

Please rate the add-on 5 stars if you like it!
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
MarketView - By Wealth Assistants will ask for the permissions shown below. Learn more
MarketView - By Wealth Assistants will need access to your Google account
This will allow MarketView - By Wealth Assistants 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
Allow this application to run when you are not present
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
Dave O'Hern
June 23, 2023
I tried this add-on as an alternative to the googlefinance function that has been erroring out lately. I found that for nearly every ticker where I compared =googlefinance("ticker","changepct") to =marketview("ticker","changepct") that marketview said the ticker was going in an opposite direction than googlefinance. That was a bit concerning, maybe the quotes are just a bit older or marketview calculates it a bit differently than google. However, the dealbreaker was when I tried to get a quote for one of my holding, Rollins (NYSE:ROL). Marketview returned an error saying “TICKER NOT SUPPORTED, PLEASE CHECK ‘USER MANUAL>TICKER DATABASE’”. Really? You don't support this S&P 500 company? I don't want to have to email support to add tickers every time I want to look up a not-super-popular company.
Is this review helpful?
Yes
No
Profile Picture
Karolis Jurevicius
December 27, 2022
I've been using Marketview extension to keep track of my dividend stocks and it works smoothly and fast providing me with the exact information that I need, div yield %, MCap, etc without much need to master sheets or learn programming or understand API. Strongly recommended to those who want to save time from reading multiple sources to gather information and only need accurate data here and now.
Is this review helpful?
Yes
No
Profile Picture
simon choi
March 4, 2023
it is good add-on for stock analysis !!
Is this review helpful?
Yes
No
Profile Picture
Bryan Buck
April 4, 2022
Great support... I had an issue where the extension did not work for my use case and Marketview customer service was quick to help me understand the issue and remedy the situation. API seems quick and more reliable than what is built into Google Sheets.
Is this review helpful?
Yes
No
Profile Picture
Kris B
November 26, 2022
this app is nice but falls short on the amount of data points reported
Is this review helpful?
Yes
No
Profile Picture
Benjamin Balak (DearBalak)
April 4, 2022
Wonderful easy way to get current prices and associated stats for many assets directly into my spreadsheet. I use several financial tools, but am absolutely delighted to have this too, and be able to manipulate my data freely. When Marketview doesn't have an asset I need, then I send an email requesting it and they do it within a day! Small suggestion: I wish they also had commodities and hope this can be added to the API in the future, so if you need live commodity prices, know that this is not yet possible. Overall my Marketview-enhanced financial spreadsheet has become my primary overview of all my investments.
Is this review helpful?
Yes
No
Profile Picture
Matt Dunn
December 8, 2021
It actually works after spending months pulling my hair out with Cryptosheets. Most crypto tickers are supported. I would love to see support for all the coins at least #4000+ and beyond on CoinmarketCap. Maybe one day but it's still works great, Definitely gonna buy the yearly subscription. I recommend giving it a shot.
Is this review helpful?
Yes
No
Profile Picture
Peter Portman
January 2, 2022
Marketview is a great way to organize all your investments and the guide was very clear!
Is this review helpful?
Yes
No
Profile Picture
Merlyn Griffiths
February 24, 2022
Not only is this addon super easy to use, when I requested a new ticker be added, they added it with a turnaround of under 24 hrs. Customer service were super responsive via the 'contact us' message service/ email. 10/10 I have recommended this service to my other crypto buddies. UPDATE: I've had to come back and edit my review because I've honestly never had such great, friendly responsive and personal customer service as I have from the team at Marketview. If I could give 6 stars, I would!
Is this review helpful?
Yes
No
Profile Picture
Writer Lady
July 8, 2021
I just downloaded and installed the app today, after growing tired of YahooFinance listing stale data without constant manual refreshing. And I was pleasantly surprised to see that Marketview is easier to configure than YahooFinance as well. Now, a few of my stocks weren't in the Marketview database; the developers provide contact information and request that you let them know in these cases. What a surprise to receive a pleasant email back in roughly 20 minutes, advising me that the missing stock data would be available within twelve hours. They've showed up in my Google Sheets workbook in under four! I'm a relatively new investor, so not a power user by any means. But regardless of your status, you won't do better for a developer's responsiveness and the performance quality here. I am definitely upgrading to a full account at the end of this trial period. Very happy with Marketview.
Is this review helpful?
Yes
No
1-10 of 116
Search
Clear search
Close search
Google apps
Main menu