Close

Live Stock Quotes in Excel with Excel Formulas

Stock Quotes in Excel Using MarketXLS
  • Live Stock Quotes in Excel with formulas like = Ask(“MSFT”)
  • 285 Functions to get you prices, fundamentals, Stock success indicators
  • Auto Refresh at 1 or 5 minutes
  • Handle 1500+ symbols in a sheet with 100+ metrics
  • Lightening fast refreshes
  • Multiple fail proof data sources
  • Data delivered after multiple checks on our redundant Servers
  • Easy to use functions that take only symbol as argument
  • Pricing for Currencies, Futures, Options, and ETFs
  • No workbook limitations with live stock quotes in excel.
  • All versions of Excel®™ (2007, 2010, 2013, 2016) supported
  • Trusted by more than thousands of investors/traders


See Next Feature

See Release Notes


Historical Fundamentals Stock Functions
  • Get historical fundamentals with easy to use formulas
  • Up to 11 years of history, for 101 essential fundamental indicators and financial ratios
  • Annual, Trailing Twelve month, and Quarterly data available with MarketXLS functions
  • =hf_Revenue(“MSFT”,”2013″) will get you yearly revenue in 2013
  • =hf_CurrentAssets(“MSFT”,”2016″,”1″) will get you current assets in Q1 2016
  • Reference grade fundamental stock data (will match 100% with Filings)

MarketXLS has everything you would need as an investor to manage all your stock portfolio needs within Excel. The add-in is designed to fit right within your workflow and provides you the required data the way you want. You can plugin this data within your financial models or portfolio spreadsheets and the data will refresh automatically keeping your numbers always latest. Download historical data for backtesting and charting in excel.

Other than stock quotes, the add-in also provides data for futures, options, ETFs, and currency quotes. The add-in gives access to all the fundamental and technical data for the stocks including balance sheet, income statement, and cashflow metrics and hundreds of technical indicators, charts and screeners.

Supercharge your stock research with MarketXLS and get Stock Quotes in Excel today.

Fast Stock Charts like these in your Excel


Simply select a group of stocks and click on these to get the charts like shown below to create stock charts in excel
032816_1759_MarketXLSNe2.png
stock charts in excel

Realize full potential of Candlestick patterns to identify trends

stock charts in Excel

stock charts in Excel


Questions? Email support@marketxls.com

See our introductory pricing