Real-time and historical data for 80k securities including stocks, ETFs, mutual funds, FOREX, commodities, cryptocurrencies and more in your spreadsheet.
Listing updated:November 27, 2024
Works with:
47K+
Overview
With Wisesheets, you can forget about wasting hours collecting and organizing financial data for every stock you analyze.

Using simple formulas, you can get the data you need for your analysis so you can easily compare and visualize hundreds of securities at once in a simple view.

With coverage for over 80k securities including stocks, ETFs, mutual funds, FOREX, commodities, cryptocurrencies and indices.

Better yet, you can use pre-built stock analysis models built by the community to get inspiration and get your analysis done in a fraction of the time.

Years of financial statements and key metrics in seconds:
• Simply select the company symbol and get the annual financials and quarterly financials going back to 2002 in different tabs of your spreadsheet.
Income statement
Balance sheet
Cash flow statement
Stock key metrics
Stock growth metrics

Built-in-stock screener to filter and find over 80,000 securities. You can combine this with Google Finance to build impressive screeners and trackers. Filter by market cap, volume, industry, sector, dividend and more…

Get your custom stock dashboards, screeners, and DCFs done faster than ever:
• Use our custom WISE and WISEPRICE functions and autofill to quickly fill your models and DCF' with all the data you need.

Build powerful a powerful Google Finance Watchlist with the help of Wisesheets and the Google Finance Function.

Get stock's real-time price and the following live metrics and refresh them when you want at the push of a button 80,000 stocks and ETFs:
• Symbol
• Name
• Price
• Changes Percentage
• Change
• Day Low
• Day High
• Year High
• Year Low
• Market Cap
• Price Avg 50
• Price Avg 200
• Volume
• Avg Volume
• Exchange
• Open
• Previous Close
• EPS
• PE
• Shares Outstanding

Get stock’s dividend data, including the dividend, declaration date, and payment date going back to 1985:
• Simply enter =WISEPRICE(“ticker”, “dividend”) and watch your spreadsheet get populated with the dividend data you need.This is as magical as having the Google Finance Dividend Yield.

Access historical stock and ETF price data, including open, close, volume, etc:
•  Enter any of these parameters in the WISEPRICE function and then enter the number of days you’d like to get data from or a specific date range.

Example function calls:

=WISE(“AAPL”, “Revenue”, “TTM”)

=WISE(“TSLA”, “Net income”, 2021, “q3”)

=WISEPRICE(“AMZN”, “Price”)

=WISEPRICE(“AAPL”, “Close”, 20)

See all data available here: https://www.wisesheets.io/pages/excel-available-data.html

Need support? Email us at info@wisesheets.io we are happy to help.

50+ Different exchanges covered:
• XETRA (Germany)
• NSE (India)
• LSE (London)
• MCX (Russia)
• SIX (Switzerland)
• HKSE (Hong Kong)
• ASX (Australia)
• OSE (Norway)
• NYSE (US)
• NASDAQ (US)
• AMEX (US)
• EURONEXT (Europe)
• INDEX
• TSX (Canada)
• EURONEXT (Paris)
• OTC (Over the Counter US)
• Shanghai
• Shenzhen (China)
• Nasdaq Stockholm (Stockholm Sweeden)
• TYO (Tokyo)

And more...

One single financial data source with everything you need. Perfect for long-term investors, traders and value investors.

Make your investing easier and more effective than ever.

Get your free trial account here: https://www.wisesheets.io/

The stock data comes directly from the company's reports and is standardized according to the XBRL US GAAP Taxonomy Preparers Guide.

-------------------------------------------------------------------------------------------------------------------------------

Updates:

-Discover stocks and fund lists that fit your specific sector and industry criteria. Utilize over 150+ new industries to find attractive investments

-Compare tons of securities across historical price data quickly.  You can now use the WISEPRICE function to get historical price data for up to 1,000 securities at once. 

-Get data faster in fewer function calls. You can now use the WISE function with multiple tickers, periods and parameters.

-Build better, more powerful custom stock screeners faster. There are no more random errors on the screener now. Even if your tickers are wrong or your parameters are incorrect, the screen will display unavailable, but that won't stop you from getting all the other data for your stock lists. 

-Analyze Stocks, ETFs, and Funds dividend payment with ease. Use the WISE function or Get data screener function to obtain the dividend payments of a company in the last 12 months using the TTM time period.

-Analyze ETF and Fund data for many symbols at once. Use the WISEFUNDS function to get Fund and ETF-specific data for multiple securities at once.

-Access historical segment and geographic information historically even when the segments change. You can now access long historical segment and geographic data for companies that report to the SEC in one single function call, even if they have irregularly reported segments or geographies.

-Discover stock and fund lists that fit your specific criteria, such as market cap, exchange, volume, and more. Utilize the new get list and get data screener functionality to access relevant stock lists and get data for those companies quickly.

-Build better, more powerful custom stock screeners than ever. The screener get data functionality now allows you to access price change data, specific years and quarters, longer historical data up to LY-17 and LQ-71 and includes dividend per share data. 

-Access adjusted dividend data for specific years effortlessly. Use the WISE function with the format =WISE("ticker", "adjusted dividend", year/s). Get accurate dividend information in seconds!

-NEW company profile data like beta, sector and industry for the screener Get company profile information in seconds for thousands of companies at once.

-Build custom stock screeners and get the data you need for many companies super fast! Utilize the new screener functionality to get financials, price data, key metrics and more in one go.

-Analyze historical price changes for many companies at once. Use the WISEPRICE function to get historical stock data for multiple securities at once.

-See price changes over multiple time periods in one go. Use the WISEPRICE function to get stock and funds price changes over periods like 1 day, 5 days, 1 month, etc. You can refresh this data at any time to get the most up-to-date numbers!

-Get stock financials as reported to the SEC. No more back and forth between your spreadsheet and the SEC filings. Now you can access the filings data directly on your spreadsheet in just a few clicks.

-Share the latest and best stock templates with the community. You can now edit the templates you upload to Wisesheets.

-Share your favorite stock templates with the community. Upload, your custom Excel or Google Sheets stock analysis templates to be used by the community. 

-Get a company's dividend payment history for only the timeframe you want. Use the WISEPRICE function to get the dividend payment history of a stock or ETF for only a specific timeframe.

-Sanity check your analysis and valuations. Use the WISE function to get future and historical analyst estimates from institutions like Goldman Sachs, Morgan Stanley, Citi Group, Barclays, and more.

-Analyze dividend payments for specific years. Use the WISE function to get the sum of the dividend payments made over a specific year.

-Analyze stocks over more company information .Use the WISEPRICE function to get company information such as beta, sector, industry, and more.

-Analyze dividend payment information any way you'd like.Use the WISE function to get individual dividend per share payments on a quarterly basis.

-Analyze segment and geographic revenue breakdowns across multiple time periods at once. Enter a range of periods in the WISE function to get the data across multiple years or quarters.

-Get financials, key metrics, and growth metrics in the order you want. Reverse the statement dump output to show the oldest data available first.

-Get historical segment and geographic revenue breakdowns. Use "segment revenues" and "geographic revenues" in the WISE function to access this data.

-Get real-time and historical price data for indexes like the S&P500. Use an index ticker like ^GSPC in the WISEPRICE function to access this data.

-Get annual and quarterly data in the order you want without worrying about fiscal and calendar dates. Use LY-1, LY-2 etc. and LQ-1, LQ-2 etc. in the WISE function as the period to get the yearly or quarterly data for any previous quarter or year.

-Get all the stock data you need in Google Sheets without running into #errors. Use the refresh error button to refresh all errors all at once.

-Get historical stock and ETF price data, including open, close, volume, etc. Enter any of these parameters in the WISEPRICE function and then enter the number of days you’d like to get data from or a specific date range.

-Access powerful pre-made templates on Excel and Google Sheets in one click. Pick your favorite template from Wise Templates, including DCFs, stock trackers, and watchlists, among others, and make any changes you want!

-New parameters available for the WISE and WISEPRICE functions Parameters like filling date, accepted date, CIK, date, etc. are now available 

-Get a whole bunch of stock data in a single function call. You can now enter a range including multiple parameters and years in the WISE function (vertically and horizontally). 

-Search for ticker and company names within Wisesheets. Forget looking for tickers and the respective company names to use for Statment Dump and the =WISE function. You can now search on the Statement Dump search bar by company name and ticker.

-Get multiple stock's real-time data in a single function call. Instead of a single ticker, you can now enter multiple tickers in the =WISEPRICE function to get all the data you need a lot faster.

-Get all the stock data parameters you want in a single function call. Instead of individual requesting parameters like "revenue" you can now enter a range of parameters in the =WISE function such as "A1:A:5" with those cells containing multiple data points like "net income", "eps" etc.

-Analyze historical stock dividend data directly on your spreadsheet. Use the "dividend" parameter on the =WISEPRICE function to get all the dividends paid by a particular company along with the payment date, declaration date etc.

-See stock financials as reported by the company to the SEC. Change the Statement Dump output to SEC as reported to get the company financials reported to the SEC without standardization (in BETA).

-Use Google Finance and Wisesheets to get all the stock data you need

-Compare company stock data based on the latest year and quarter available. Forget about knowing the different company fiscal years and quarters use the "ly" and "lq" period types in the =WISE function to get the latest year and latest quarter of data for your analysis. 

-Get stock financials and real-time data for OTC and penny stocks. Use Statement Dump and the =WISE and =WISEPRICE functions to perform any analysis of your choice. 

-Compare companies across TTM key metrics and financials. Use the "ttm" period instead of a specific year in the =WISE function to retrieve key metrics or financials calculated based on the trailing twelve months. 

-Get the date and period of specific historical data via the =WISE function Use the "date" and "period" parameters to know exactly the date and quarter of a particular period. 

-Get real-time stock data such as price, volume, pe. You can use the new =WISEPRICE function to get real-time stock data and refresh it as often as you wish. 

-Get all the historical data you need across Excel and Google Sheets. You can now use Wisesheets on Google Sheets and combine it with GOOGLEFINANCE to get all the stock data you need. 

-Easily compare companies across key metrics and growth metrics. These metrics are now accessible via the =WISE function. 

-Get the historical financials your choice. Use the =WISE function for any stock analysis model of your choice. 

-Get all stock financials and key metrics in one click. Simply enter the company ticker on the Statement Dump Menu and select quarterly or annual data. 

-------------------------------------------------------------------------------------------------------------------------------

Wisesheets is one of the best rated apps on the G Suite marketplace and one of the most popular add-ons, among others, such as Google Finance, GoogleFinance, Market View, GPT for Sheets, TickerData, Investar.com, MarketView, SheetsFinance, Crypto, Morningstar, Refinitiv, S&P,  CryptoWallet, XERO, Alpha Vantage, Yahoo, YahooFinance, Currency Converter, SketchUp for Schools, Apipheny.io, 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, Finsheet, MathType, Backupify, Choice Eliminator, EasyBib, Bark, Digication, WiseSheets, 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 investors all 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, currency, alpha, beta, dividends, portfolio, stocks, 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, balance sheets cash flow etc, historical financials, financial statements, quarterly financials, annual financials, value investing, long term investing, stock value, google finance, ttm data, stock data, stock price.
Additional information
PricingFree of charge with paid features
Developer
Non-trader
Privacy policy
Terms of service
Wisesheets | Google Finance Watchlist will ask for the permissions shown below. Learn more
Wisesheets | Google Finance Watchlist will need access to your Google account
This will allow Wisesheets | Google Finance Watchlist to :
View and manage spreadsheets that this application has been installed in
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Adam Bright
July 20, 2024
Took me a little while to get used to the commands, but once I got comfortable, this app really paid off. Huge time saver in terms of screening, analyzing, and comparing prospective stocks. The info basically gets as granular as I could possibly want. And whenever I've had questions, the support team has answered them promptly. Glad to have made the purchase.
Is this review helpful?
Yes
No
Profile Picture
Dennis Sprengers
August 3, 2024
## INTRODUCTION As an avid user, I’ve found Wisesheets transformative for managing financial data in Google Sheets. It’s indispensable for my analysis and investment tracking. It's key features are: (1) Historical Data Access: Wisesheets offers 19 years of financials for global exchanges, supporting thorough evaluations and trend analysis. (2) Integration: Seamlessly integrates with Google Sheets and Excel. (3) User-Friendly: The intuitive interface and simple formulas make data retrieval easy. (4) Real-Time Updates: Provides real-time data, essential for timely decisions. (5) Affordable: Competitively priced, offering substantial value with a free trial. ## PERSONAL EXPERIENCE I’ve created stock analysis sheets with detailed financials and models like DCF, DDM, GGM, and Graham's Formula. Wisesheets streamlines data population, saving hours and ensuring accuracy. The efficiency of data calls and market support significantly boost my analysis. Exceptional customer support—prompt and precise responses—enhances my experience. Pulling in accurate financial data allows for sophisticated models without manual data entry. ## CUSTOMER SUPPORT I noted it before, but want to make a special shout out to the customer support for being incredibly responsive and helpful, going as far as pointing me out where my formula is failing, and how to have the formula's operate more efficiently. They went as far as explaining me why some particular data for a specific company didn't make sense to me; turns out the data wasn't wrong but my interpretation was. ## CONCLUSION Whether you're a seasoned investor or new to financial analysis, Wisesheets offers the functionality and support to elevate your work. I'm Dutch and go out of my way to not spend money. I’ve tried scraping Yahoo! Finance and connecting to free APIs - anything to save a penny - but it’s frustrating and a waste of time. Take it from the Dutchie—get your license today; you won’t regret it. I've done the research; this is the best value-for-money you're going to find. The price is super reasonable, and the otherwise wasted time is now spent doing what you're supposed to do: analyze and seek a handsome return on your investments, instead of fixing broken code. It's the WISE thing to do xD
Is this review helpful?
Yes
No
Profile Picture
Stephen Allen
August 4, 2024
Wisesheets has proven to be a powerful spreadsheet tool that provides me with real-time access to a wide range of stock market data as well as a wide range of analytical tools. It easily integrates with Excel but does have a slight learning curve. However, the Wise Investors Discord provides plenty of timely information for times when I reach a road block and need some help! Despite this slight learning curve, its automation capabilities have greatly increased my productivity and data accuracy making it a worthwhile investment in managing my financial data. With Wisesheets, I make informed decisions more easily and I'm more efficient in my stock market analysis. All in all, Wisesheets has been a great tool for streamlining my stock market analysis.
Is this review helpful?
Yes
No
Profile Picture
Kirk Spano
July 17, 2024
I have been using WiseSheets about 2 years now. It was good when I started and is better now. For tracking performance, screening or monitoring investments it is awesome and eliminates hours of work for a very low price tag. I have had a few issues I needed help with, mainly my lack of skill with spreadsheets and they have helped quickly and graciously each time. I really have nothing but good things to say. A bargain and a time saver.
Is this review helpful?
Yes
No
Profile Picture
Michael H
July 21, 2024
After 7 months of using this Google software with Excel and Google plugins: Pros: Cost-effective: This software offers the cheapest API in the market, making it an excellent choice for budget-conscious users. Strong support: The Discord community provides good support, and the feedback system is responsive, showing the team's commitment to user satisfaction. Integration: Works well with Excel and Google plugins, Cons: Documentation needs improvement: The current documentation could be more comprehensive and user-friendly to ease the learning curve for new users. Occasional downtimes: The service experiences some downtimes, which can disrupt workflows. Daily login requirement: The Google plugin needs daily login, which can be inconvenient for users seeking a more seamless experience. API limitations with complex spreadsheets: Large Excel spreadsheets with formulas often hit API limits, despite being designed by the team. This is particularly frustrating as these are official templates. Overall, while the software offers great value and support, there are some operational issues that users should be aware of. The need for daily logins and API limitations on complex spreadsheets can be significant drawbacks for power users or those working with large datasets. Despite these issues, the affordability and strong community support make it a viable option for many users, especially those with less demanding requirements. However, improvements in stability and handling of complex spreadsheets would greatly enhance the user experience.
Is this review helpful?
Yes
No
Profile Picture
Harinath J
July 20, 2024
Sure! Here's a review for Wisesheets:--- **Wisesheets: The Ultimate Spreadsheet Add-On for Stock Investors** As a stock investor, I've always struggled with the tedious process of collecting and organizing financial data for analysis. Wisesheets has completely transformed the way I handle stock data, making it an indispensable tool in my investment toolkit. **Pros:** - **Effortless Data Collection:** Wisesheets eliminates the need for hours of manual data entry. With simple formulas, I can quickly retrieve the financial data I need for any stock. - **Custom Models:** The ability to build custom models directly in Excel or Google Sheets is a game-changer. It allows for personalized analysis and comparison of multiple securities in a single, easy-to-view format. - **Comprehensive Data:** The app provides a wealth of financial information, making it easier to screen stocks and identify good investment opportunities. - **User-Friendly:** The integration with both Excel and Google Sheets is seamless, and the learning curve is minimal thanks to the intuitive interface. **Cons:** - **Limited to Spreadsheet Software:** While the integration with Excel and Google Sheets is excellent, it would be great to see support for other platforms or standalone applications in the future. Overall, Wisesheets has significantly improved my efficiency and effectiveness as an investor. It allows me to focus on analysis and decision-making rather than data collection. If you're a stock investor looking for a powerful tool to streamline your data handling process, I highly recommend giving Wisesheets a try. Price: Wisesheets offers a range of pricing options, including free features and a trial period, making it accessible for all levels of investors. The paid features are well worth the investment, providing enhanced capabilities that significantly improve data handling and analysis efficiency.
Is this review helpful?
Yes
No
Profile Picture
Redneck Johnny
July 22, 2024
This is a fantastic product! The add-on is easy to use and they have a Discord server where you can ask about updates, templates, how things work and ask for help if you face any issues. They are very quick to respond and also very helpful. Guillermo, the founder, is also very accessible and are doing a lot to make you understand how the product works, how you could use their formulas and so on. I've managed to build out multiple sheets in google sheets that uses this add-on and the amount of data they provide you with, with the current price point they are charghing you, is incredible. You have a lot of opportunities if you implement Wisesheets in your research process. I highly recommending them to anyone! In addition to this, I can't think of more than a handful of times since I started using them in 2022 or so, where they've had issues with their service. It's very stable and very reliable.
Is this review helpful?
Yes
No
Profile Picture
Joe Radomsky
July 22, 2024
I've been using Wisesheets for about a year. The normalization of financial data has helped simplify my investment analysis. The integration with Google Sheets is seamless, automating the input of data. The user interface is intuitive and user-friendly, even for those who might not be very tech-savvy. Additionally, the customer support team is responsive and helpful, always ready to assist with any questions or issues I encounter. Wisesheets has significantly improved my productivity and accuracy, saving me hours of manual work. I highly recommend it to anyone looking to streamline their financial data management process.
Is this review helpful?
Yes
No
Profile Picture
Dale Raichman
July 21, 2024
Wisesheets is outstanding. The data is well formatted and extracts information that would take you days if not weeks of full-time work in Excel before you had it to analyze. Moreover, there are formulas and quantitative stock-picking strategies out there that work if applied with discipline. To model the strategies is one thing , getting the data is another. They have stayed ahead of the curve to apply current technology to the equity analysis field and present available data in an easy-to-use format at a very reasonable price. Finally, their chat forum on Discord is invaluable and the developers will go out of their way to make things simpler for you or to answer questions, instead of charging an additional fee to do it. I honestly spent a while just finding out about XBRL, let alone something that extracts the data so efficiently using Excel Dynamic Arrays and other functionalities. Once I knew what XBRL was and played around with a not-yet-fully-developed Beta version, I knew there had to be something out there that did it properly. Fantastic value and highly recommended.
Is this review helpful?
Yes
No
Profile Picture
Adel Kashgary
July 21, 2024
Wisesheets Finance is a valuable tool for investment advisors and financial analysts. It streamlines the process of collecting and organizing financial data, saving countless hours and allowing for more time to focus on analysis and decision-making. Here are some of the key benefits of Wisesheets Finance: * Time-saving: With real-time and historical data for over 80,000 securities, Wisesheets Finance eliminates the need for manual data collection and entry. This frees up valuable time for investment professionals to focus on what they do best – analyzing the data and making informed investment decisions. * Accurate data: Wisesheets Finance provides access to high-quality financial data from a variety of sources. This ensures that investment decisions are based on reliable information. * User-friendly: Unlike complex financial terminals, Wisesheets Finance is designed to be easy to use. Even those who are not familiar with financial data can quickly get up and running. * Extensive data coverage: Wisesheets Finance covers a wide range of asset classes, including stocks, ETFs, mutual funds, forex, commodities, cryptocurrencies, and indices. This makes it a one-stop shop for all your financial data needs. * Excellent customer service: Wisesheets Finance is known for its exceptional customer service. The team is always willing to help and will go the extra mile to ensure that users are satisfied. Overall, Wisesheets Finance is a powerful tool that can save investment professionals time and money. It provides access to accurate and up-to-date financial data, all in a user-friendly format. If you're looking for a way to streamline your investment process, Wisesheets Finance is definitely worth considering.
Is this review helpful?
Yes
No
1-10 of 58
Search
Clear search
Close search
Google apps
Main menu