App Icon
Marketview Ltd.
•  638
Overview
Pull real-time financial data and more into your Sheets and take full control of your investment portfolio. Track and monitor the value of your Stocks, ETFs, and Crypto!
Marketview gives you the control you need to manage your investment portfolio better:
➤ MANAGE AS YOU LIKE: Pull real-time data, historical data, and price charts into your Sheets. Personalize your dashboards and 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 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

➤ Supports the most popular financial assets: 2500+ US and international stocks, ETFs, and cryptocurrencies
➤ Returns real-time data, historical data, and price charts 
➤ As simple as =MARKETVIEW(“AAPL”, "price")
➤ Formula Builder to create custom formulas in a few clicks
➤ Auto-update of real-time data every 60 minutes
➤ Unlimited data calls/day for every user

ALL DATA SUPPORTED

➤ 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
	⁃ 1Y target estimate
	⁃ Recommended ratings: daily, weekly, monthly
	⁃ Bearish and bullish sentiment
	⁃ Stock’s industry & logo
➤ Historical data:
	⁃ Price change 1W, 1M, YTD, 1Y, and 3Y
➤ Price charts:
	⁃ Historical line and column charts

TUTORIAL

1. Install the add-on from the G Suite Marketplace or from within the Google Sheets add-ons store.
2. Open an existing sheet with Google Sheets or create a new one.
3. Click on the FORMULA BUILDER menu to open the add-on sidebar and create formulas in a few clicks. Be sure to type in the cell in which the ticker symbol is located.
4. Alternatively, pick and copy the formulas directly from the USER MANUAL menu, where you’ll also find some instructions and useful tips.
5. You’re all set to build your dashboards and visualize your investments to suit your needs!

SUPPORT

Have questions or need help getting started? Check our FAQs:

➢ https://www.market-view.net/faq

Or contact us here:

➢ https://www.market-view.net/contact

PRICING

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

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

UPDATES & RELEASES

In the pipeline - Reduced time interval for the auto-update of data from 60-minute to real-time; improved overall dividend data accuracy; dividend and yield data coverage also for ETFs; currency converter feature in the Formula Builder.

October 16th 2020 - Marketview has been upgraded with new and more complete functionalities such as: support of the most popular international stocks; new and improved historical data and charts; and 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 app 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, 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 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, investment tracking, investing, trade, trading, tracker, finance, market, data, analytics, stockbroker, adviser, ticker symbol, tickers, stock, etf, crypto, cryptos, cryptocurrency, altcoin, altcoins, bitcoin, 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://www.market-view.net/
SUPPORT: https://www.market-view.net/faq
CONTACT US: chat.marketview@gmail.com

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

Please rate the add-on 5 stars if you like it!
Reviews
Language:
Sort by:
Profile Picture
atxnfo
January 12, 2021
Love this plug in- I'm so glad I found it!
Is this review helpful?
Yes
No
Profile Picture
Vitor Euphrasio da Silva
January 4, 2021
pretty awesome!
Is this review helpful?
Yes
No
Profile Pciture
Lisa Adelle Hurley
January 9, 2021
I am seeing REPLY TO THIS REVIEW sorry they have used and abused me I have all sorts of company and businesses HAAA I can't believe these people are not expecting me to SHOUT OUT LOUD what there doing. to me. No real brains fair doos
Profile Picture
Chester Andrews
January 4, 2021
Market View is great. I was looking for a way to pull the dividend yield into my Google sheet. I wasn't able to do that using Excel but with Market View it is easy. I also sent a question into the help email and within a few hours had an answer. So far this is an excellent tool and is meeting my needs.
Is this review helpful?
Yes
No
Profile Pciture
Marketview
January 5, 2021
Hi Vitor, you can use the Formula Builder and select Dividend as data attribute (recommended). Alternatively, you could also manually write the formula =MARKETVIEW(A1, “dividend”) and replace A1 with the cell reference that contains your ticker.
Profile Pciture
Vitor Euphrasio da Silva
January 4, 2021
which formula did you used for dividend?
Profile Picture
David Shugert
January 3, 2021
Excellent tool, recommended 100%
Is this review helpful?
Yes
No
Profile Picture
Mohammad Abdoh
December 27, 2020
excellent for some retributes that are not available in googlefinance...
Is this review helpful?
Yes
No
Profile Picture
Gary Thatcher
December 17, 2020
Thank you, just what I needed. Would have given 5 stars if you had more cryptocurrencies such as Tron, USD Coin, Tezos, Cosmos, Algorand, Orchid, BAND, Bitcoin SV, Dai, Maker, Compound, Celo
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 3, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Hosaki Solette
November 11, 2020
Great product. Does exactly as advertised. Only issue I have with it is the lack of supported tickers to choose from. A little under half the companies I tried pulling data for weren't on the supported list.
Is this review helpful?
Yes
No
Profile Pciture
Marketview
November 12, 2020
Thanks for the feedback! We currently support over 2600 companies and include new tickers every week, but if any ticker symbols you’re looking for are missing, please just drop us an email and we will add them right away.
Profile Picture
Bharathy Subramanian Parimalam
October 26, 2020
Work's great. Great pricing and generous free quota. My biggest problems are, 1. The prices are about a week old! Look into what Alpha Vantage does and create a dummy variable so the users can refresh the data. It's a work around for google sheet's behavior 2. Most of the TSE:XXX stocks return "NA". Please fix it asap, I'll probably be a long time premium user.
Is this review helpful?
Yes
No
Profile Picture
Elbert Greenaway Jr.
October 23, 2020
I rarely ever write a review, but this one is definitely worth it! Great tool for managing your portfolio, and definitely easy to personalize. Even their customer service is likely one of the best I've seen. Hit install and thank me later!
Is this review helpful?
Yes
No
1-10 of 23
Additional information
Marketview Ltd.
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu