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!