Track the value of all US stocks, ETFs, and cryptocurrencies in your portfolio. Marketview lets you pull real-time financial data into your sheets and take full control of your investment portfolio.
Pull real-time quotes, financial indicators, streaming charts, 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.
➤ 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.
➤ 2500+ financial assets supported: US stocks, ETFs, and the most popular cryptocurrencies
➤ Returns real-time data, historical data, and price charts
➤ 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
➤ 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
⁃ 1Y price target estimate
⁃ Recommended 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
➤ Price charts:
⁃ Historical line and column charts
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.
Have questions or need help getting started? Please check our
Or contact us here, our team will get back to you in 24 hours or less:
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
March 29th 2021 - +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, 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
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.
USER MANUAL: https://cutt.ly/user_manual
CONTACT US: firstname.lastname@example.org
Please rate the add-on 5 stars if you like it!