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 Custom Functions to get accurate 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 from dependable servers after multiple checks.
  • Easy to use functions that take only symbol as the argument
  • Pricing for Futures, Options, and Mutual funds with Addons
  • 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

Get Started
See Next Feature

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
stock charts in excel

Realize full potential of Candlestick patterns to identify trends

stock charts in Excel

stock charts in Excel

Questions? Email

See our introductory pricing