
Get a whole bunch of stock data in a single function call. New parameters available for the WISE and WISEPRICE functions Parameters like filling date, accepted date, CIK, date, etc. Pick your favorite template from Wise Templates, including DCFs, stock trackers, and watchlists, among others, and make any changes you want! Access powerful pre-made templates on Excel and Google Sheets in one click. 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. Get historical stock and ETF price data, including open, close, volume, etc. Use the refresh error button to refresh all errors all at once. Get all the stock data you need in Google Sheets without running into #errors. The stock data comes directly from the company's reports and is standardized according to the XBRL US GAAP Taxonomy Preparers Guide. Make your investing easier and more effective than ever. Perfect for long-term investors and value investors. One single financial data source with everything you need. Need support? Email us at we are happy to help.
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. Simply enter =WISEPRICE(“ticker”, “dividend”) and watch your spreadsheet get populated with the dividend data you needĪccess historical stock and ETF price data, including open, close, volume, etc:. Get stock’s dividend data, including the dividend, declaration date, and payment date going back to 1985: Get stock's real-time price and the following live metrics and refresh them when you want at the push of a button 50,000 stocks and ETFs: Use our custom WISE and WISEPRICE functions and autofill to quickly fill your models and DCF' with all the data you need. Get your custom stock dashboards, screeners, and DCF's done faster than ever: Simply select the company symbol and get the annual financials and quarterly financials going back to 2002 in different tabs of your spreadsheet. Years of financial statements and key metrics in seconds: Using simple formulas, you can get the stock data you need for your analysis so you can easily compare and visualize hundreds of stocks at once in a simple view.īetter yet, you can use pre-built stock analysis models built by the community to get inspiration and your analysis done in a fraction of the time.
With Wisesheets, you can forget about wasting hours collecting and organizing financial data for every stock you analyze.