Stock Market Data in Google Sheets with MarketXLS

1,000+ Stock Market Functions for Google Sheets

MarketXLS for Google Sheets gives you access to over 1,000 financial data functions right inside your spreadsheet. These are the same professional-grade functions used by financial advisors, portfolio managers, and active traders. Every function works with a simple formula, just like GOOGLEFINANCE, but with far more power and reliability.

Type =Last("AAPL") to get Apple's stock price. Type =hf_revenue("AAPL", 2024) to get Apple's annual revenue. Type =PERatio("AAPL") to get the P/E ratio. It is that simple.

Real-Time Stock Prices in Google Sheets

Get real-time stock prices in Google Sheets without relying on the GOOGLEFINANCE function. MarketXLS provides live stock data for all US and Canadian stocks and ETFs. Unlike GOOGLEFINANCE, which can be delayed by 20 minutes or more, MarketXLS delivers current market data you can trust.

Available real-time stock data functions include:

• =Last("AAPL") for the last traded price
• =Bid("AAPL") and =Ask("AAPL") for bid and ask prices
• =Volume("AAPL") for trading volume
• =DaysHigh("AAPL") and =DaysLow("AAPL") for the day's range
• =FiftyTwo_weekHigh("AAPL") and =FiftyTwo_weekLow("AAPL") for 52-week range
• =ChangeinPercent("AAPL") for percentage change from previous close
• =Fifty_dayMovingAverage("AAPL") and =TwoHundred_dayMovingAverage("AAPL") for moving averages

Financial Statements and Fundamental Data in Google Sheets

Pull complete financial statements directly into Google Sheets. MarketXLS provides over 337 fundamental data functions covering income statements, balance sheets, and cash flow statements going back 10+ years. GOOGLEFINANCE does not offer any of this data.

Income Statement: =hf_revenue("AAPL", 2024), =hf_gross_profit("AAPL", 2024), =hf_ebit("AAPL", 2024), =hf_net_income("AAPL", 2024), =hf_earnings_per_diluted_share("AAPL", 2024), and dozens more.

Balance Sheet: =hf_total_assets("AAPL", 2024), =hf_total_debt("AAPL", 2024), =hf_cash_and_equivalents("AAPL", 2024), =hf_shareholders_equity("AAPL", 2024), and more.

Cash Flow: =hf_operating_cash_flow("AAPL", 2024), =hf_free_cash_flow("AAPL", 2024), =hf_capital_expenditures("AAPL", 2024), and more.

Key Statistics: =PERatio("AAPL"), =EBITDA("AAPL"), =Beta("AAPL"), =MarketCap("AAPL"), =BookValue("AAPL"), and many more key ratios.

Options Data and Greeks in Google Sheets

MarketXLS is one of the only add-ons that brings full options data into Google Sheets. GOOGLEFINANCE has zero options support. With MarketXLS, you can pull live options chains, calculate Greeks, analyze implied volatility, and use advanced options pricing models, all from simple formulas in your spreadsheet.

Options Chain: Use =QM_GetOptionChain("AAPL") to pull the full options chain directly into Google Sheets, including bid, ask, volume, open interest, and implied volatility for every strike and expiration.

Options Greeks: Get delta, gamma, theta, vega, and rho for any option contract. MarketXLS calculates Greeks using professional pricing models so you can analyze risk and build strategies directly in your spreadsheet.

Put/Call Analytics: Track put/call volume ratios, open interest ratios, and historical implied volatility trends for any stock.

Advanced Pricing Models: Black-76, Bachelier, SABR, Heston, and American option pricing models are all available as spreadsheet functions. Calculate theoretical prices, implied volatility, and all Greeks using institutional-grade pricing models.

Learn more about options analytics on our Options Profit Calculator and Option Scanner pages.

Technical Indicators in Google Sheets

Run technical analysis directly in Google Sheets with MarketXLS. Calculate moving averages, RSI, MACD, Bollinger Bands, and more using simple formulas. No scripts, no Apps Script code, no third-party APIs needed.

• =SimpleMovingAverage("AAPL", 20) for 20-day Simple Moving Average
• =ExponentialMovingAverage("AAPL", 12) for 12-day Exponential Moving Average
• =RSI("AAPL") for Relative Strength Index
• =MACD("AAPL") for MACD values
• =BollingerBand("AAPL", 20) for Bollinger Bands
• =AverageTrueRange("AAPL") for Average True Range
• =VWAP("AAPL") for Volume Weighted Average Price
• =Stochastic("AAPL") for Stochastic Oscillator
• =OBV("AAPL") for On-Balance Volume
• =ROC("AAPL") for Rate of Change

Portfolio Analytics in Google Sheets

Build a professional portfolio tracker in Google Sheets with MarketXLS portfolio analytics functions. Calculate risk metrics, optimize allocations, and analyze performance, all from your spreadsheet.

MarketXLS includes portfolio-level analytics functions for calculating Sharpe ratio, Sortino ratio, Treynor ratio, Jensen's Alpha, Value at Risk, maximum drawdown, beta, correlation, and covariance. These functions help you measure risk-adjusted performance and optimize your portfolio allocation directly in Google Sheets.

Stock Screener in Google Sheets

Screen stocks directly from Google Sheets using MarketXLS screener functions. Filter thousands of stocks by dividends, value, growth, momentum, and custom criteria. You can also pull S&P 500 components, NASDAQ 100 components, top gainers, top losers, and most active stocks with a single formula.

MarketXLS includes built-in screener functions that return lists of stocks matching specific criteria. Screen for high dividend yield stocks, undervalued stocks, high growth stocks, momentum stocks, and more. You can also pull S&P 500 components, NASDAQ 100 components, top gainers, top losers, and most active stocks with a single formula. Use the MarketXLS Stock Screener on our website for even more advanced filtering with 1,000+ metrics.

GOOGLEFINANCE vs MarketXLS for Google Sheets

The built-in GOOGLEFINANCE function is free and convenient for basic stock price lookups. But it has serious limitations. Here is how MarketXLS for Google Sheets compares.

For a detailed comparison, see our MarketXLS vs Google Finance page.

How to Get Stock Market Data in Google Sheets

Who Uses MarketXLS for Google Sheets

• Financial Advisors and RIAs who need reliable stock data in Google Sheets for client reports and portfolio analysis. Google Sheets makes it easy to share live dashboards with clients.
• Options Traders who need options chains, Greeks, implied volatility, and pricing models in a spreadsheet. No other Google Sheets add-on provides this level of options data.
• Dividend Investors who want to track dividend yield, ex-dates, payout ratios, and screen for high-yield stocks directly in Google Sheets.
• Active Traders who rely on technical indicators like RSI, MACD, and Bollinger Bands for trade decisions and want this data in their Google Sheets dashboards.
• Portfolio Managers who need professional risk analytics like Sharpe ratio, Value at Risk, and correlation analysis in a collaborative spreadsheet.
• Mac and Chromebook Users who cannot install Windows-based Excel add-ins and need a full-featured stock data solution that works in Google Sheets.