Stock Market Data in Google Sheets with MarketXLS
MarketXLS is a Google Sheets add-on that puts stock prices, option chains, financial statements, and technical indicators into cells with formulas such as =Last("AAPL"). Install it from the Google Workspace Marketplace; it runs in the browser on Mac, Windows, and Chromebook. US stock quotes are 15-minute delayed on the Standard plan and real-time on the Advanced and Business plans.
1,000+ Stock Market Functions for Google Sheets
MarketXLS for Google Sheets adds over 1,000 financial data functions to your spreadsheet, the same function library as the MarketXLS Excel add-in. Each function is a formula you type in a cell, like GOOGLEFINANCE.
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
MarketXLS returns stock prices in Google Sheets for US and Canadian stocks and ETFs. Quote speed follows your MarketXLS plan: US stock quotes are 15-minute delayed on the Standard plan and real-time on the Advanced and Business plans. Google states that GOOGLEFINANCE quotes may be delayed up to 20 minutes.
Stock price 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
MarketXLS pulls income statement, balance sheet, and cash flow data into Google Sheets with hf_ functions that take a ticker and a fiscal year, such as =hf_revenue("AAPL", 2024). GOOGLEFINANCE does not return financial statement 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 brings option chains, Greeks, and implied volatility into Google Sheets with formulas. GOOGLEFINANCE has no options data. Options data is end-of-day on the Standard plan and real-time on the Advanced and Business plans.
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 an option contract, to measure risk and build strategies in your spreadsheet.
Put/Call Analytics: Track put/call volume ratios, open interest ratios, and historical implied volatility trends for any stock.
Pricing Models: Black-Scholes functions such as =BlackScholesOptionValueWithUserInputs calculate theoretical option values from your own inputs.
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
MarketXLS portfolio functions turn a Google Sheet into a portfolio tracker that calculates risk metrics and performance for your holdings.
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.
Dividend Data in Google Sheets
Track dividend stocks in Google Sheets with MarketXLS dividend functions. Get dividend yield, dividend per share, ex-dividend dates, payout ratios, and dividend history for any US or Canadian stock.
=DividendYield("AAPL")=DividendPerShare("AAPL")=Ex_DividendDate("AAPL")=PayoutRatio("AAPL")=DividendPaymentDate("AAPL")
Earnings Estimates in Google Sheets
Access Wall Street earnings estimates and consensus data in Google Sheets. Track analyst estimates, earnings surprises, and forward guidance for any stock.
- Consensus EPS estimates
- Number of analyst estimates
- Revenue estimates
- Earnings surprise history
- Forward earnings data
GOOGLEFINANCE vs MarketXLS for Google Sheets
The built-in GOOGLEFINANCE function is free and works for basic stock price lookups. MarketXLS is a paid add-on that covers statements, options, indicators, and screening. The table compares the two.
| Feature | MarketXLS for Google Sheets | GOOGLEFINANCE |
|---|---|---|
| Total Functions | 1,000+ | 15 to 20 attributes |
| Stock Prices | Bid/ask quotes; real-time on Advanced and Business, 15-min delayed on Standard | May be delayed up to 20 minutes |
| Options Data | Full chains, Greeks, pricing models | None |
| Financial Statements | Income statement, balance sheet, and cash flow by fiscal year | None (P/E, EPS, and market cap only) |
| Technical Indicators | SMA, EMA, RSI, MACD, Bollinger, ATR, VWAP | None |
| Portfolio Analytics | Sharpe, Sortino, VaR, Beta, Max Drawdown | None |
| Stock Screener | Built-in screener functions | None |
| Dividend Data | Yield, ex-date, payout ratio, history | None |
| Earnings Estimates | Consensus estimates, analyst counts | None |
| ETF Data | Holdings, categories, low-cost screening | Basic price only |
| Data Reliability | Licensed data; quotes from QuoteMedia | Provided as is, not for trading purposes (per Google) |
| Support | Dedicated support team | Google Docs Editors Help |
For a detailed comparison, see our MarketXLS vs Google Finance page.
How to Get Stock Market Data in Google Sheets
Step 1: Install the Add-on
Get MarketXLS from the Google Workspace Marketplace. Click Install and grant the required permissions. It takes less than a minute.
Step 2: Sign In
Choose a plan on the pricing page. Then open Extensions > MarketXLS > Open Sidebar, click Login and sign in with your MarketXLS website email and password. No license key is needed.
Step 3: Start Using Functions
Type =Last("AAPL") in any cell to get your first stock price. Explore the full function library for all 1,000+ available functions.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todayWho 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.
- 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.
- Chromebook users and Google Workspace teams who work in Google Sheets rather than Excel. (Mac users can also use MarketXLS in Excel through the Microsoft 365 add-in.)
Prefer Excel? Explore the MarketXLS Excel add-in or read the Excel Online installation guide.
Frequently asked questions
Install the MarketXLS add-on from the Google Workspace Marketplace, then type formulas such as =Last("AAPL") for the stock price, =hf_revenue("AAPL", 2024) for annual revenue, and =PERatio("AAPL") for the P/E ratio in any cell. Quote speed follows your MarketXLS plan: US stock quotes are 15-minute delayed on the Standard plan and real-time on the Advanced and Business plans.
Use GOOGLEFINANCE if you only need basic prices and a few statistics for free; Google states its quotes may be delayed up to 20 minutes. Use MarketXLS if you need financial statements, option chains with Greeks, technical indicators, or screening in Google Sheets, or real-time quotes (Advanced and Business plans). MarketXLS for Google Sheets uses the same data as the MarketXLS Excel add-in.
Yes. MarketXLS for Google Sheets works on any device that runs Google Sheets in a browser, including Mac, Windows, Chromebook, and Linux. The add-on runs inside Google Sheets, so nothing is installed on your computer. Mac users who prefer Excel can also use the MarketXLS Microsoft 365 add-in.
You can get stock prices (real-time on the Advanced and Business plans), historical prices, full income statements, balance sheets, cash flow statements, options chains, options Greeks, implied volatility, technical indicators (SMA, EMA, RSI, MACD, Bollinger Bands), portfolio risk metrics (Sharpe ratio, Sortino ratio, VaR), dividend data, earnings estimates, ETF holdings, and more. MarketXLS supports US and Canadian stocks and ETFs.
Yes. =QM_GetOptionChain("AAPL") returns an option chain in Google Sheets with bid, ask, volume, open interest, and implied volatility, and MarketXLS functions return Greeks (delta, gamma, theta, vega, rho) for a contract. Options data is end-of-day on the Standard plan and real-time on the Advanced and Business plans.
MarketXLS for Google Sheets uses the same pricing as MarketXLS for Excel: Standard is $70/month billed annually, Advanced is $125/month billed annually, and Business is $200/month billed annually. Quarterly billing is also available. See the pricing page for details.
Yes. MarketXLS includes built-in stock screener functions that let you filter stocks by dividend yield, value metrics, growth rates, momentum, and custom criteria directly in Google Sheets. You can also use the MarketXLS Stock Screener on the website for advanced filtering with 1,000+ metrics.
GOOGLEFINANCE is a free built-in function with about 15 to 20 attributes, quotes that Google says may be delayed up to 20 minutes, and no options data, financial statements, or screening. MarketXLS is a paid Google Sheets add-on with 1,000+ functions, including financial statements, option chains and Greeks, technical indicators, portfolio functions, and screening. Real-time quotes require the Advanced or Business plan.
Book a demo with our team to explore the features and workflows relevant to your research.