Close

Live Stock Quotes in Excel with Excel Formulas

marketxls

See a quick 5 minute overview

Below are a few of the key stock functions available with MarketXLS

Stock Quotes

Use =Last, =Ask, =Bid and so on to get live prices


Use =QM_Stream_Last and so on to stream real time data*

Key Ratios

Use =PERatio, =DividendYield, =Beta, =EBITDA, =BookValuePerShare and many more to get the Key Ratios

Stock Returns

Use =StockReturnSevenDays, =StockReturnFiveYears and so on to get pre-calculated stock returns

Custom Functions

Use =x_week_high, x_day_low and many more to get the highest or lowest price in x number of days 

Fundamentals

Use =hf_revenue, hf_cash, hf_currentAssets and many more to get historical fundamentals

Volume Averages

Use =VolumeAverageSevenDays, =VolumeAverageTenDays and many more get pre-calculated volume averages. 

Technical Functions

Use =AverageTrueRange, =RelativeStrengthIndex, =MoneyFlowIndex and many more to get pre-calculated technical indicators

Historicals

Use =close_historical, =open_historical and many more to get historical pricing on specific days in history

Analyst Estimates

Use =EPSEstimateCurrentQuarter, =EPSEstimateCurrentYear many more get analyst estimates 

mxls_db_query

Run your stats from our database right from your Excel sheets with the function =mxls_db_query and get quick answers....


Highest price in x days

Average price in x days

Average volume in x days

Revenue growth rate in last 4 quarters

and many more...

  • 1
    Live Stock Quotes in Excel with Formulas Like =Ask("MSFT")
  • 2
    300+ Custom Functions to get prices, fundamentals and various indicators
  • 3
    Refresh on Demand or Streaming Prices in Excel. Streaming available with Real Time Pricing Addons
  • 4
    Real time simultaneously streaming of upto 300 symbols will not slow down your Excel
  • 5
    Quality data sources and data partners
  • 6
    Pricing for Futures, Options and Mutual Funds with Quotemedia's Addons
  • 7
    Works with any version of Excel on Windows machines (Excel 2007, 2010, 2013, 2016)
  • 8
    Trusted by thousands of Investors and traders

Get Started Today with MarketXLS and save time while investing

With our 30 day money back guarantee you have nothing to lose.