Can I use MarketXLS with Google Sheets?

Yes! MarketXLS offers a Google Sheets add-on that brings financial data directly into your Google Spreadsheets.

Getting Started

Install the Add-on

1. Open Google Sheets
2. Go to Extensions > Add-ons > Get add-ons
3. Search for "MarketXLS" or "Stocks/Option Prices"
4. Click Install
5. Grant the necessary permissions

You can also install directly from the Google Workspace Marketplace.

Features Available in Google Sheets

Data Coverage

• US and Canadian Stocks & ETFs
• Live pricing (15-minute delayed)
• Historical stock prices
• Options data
• Key financial ratios
• MarketXLS analysis functions
• Historical fundamental data

Custom Formulas

Use MarketXLS formulas directly in your cells:

=MXLS("AAPL", "price")
=MXLS("MSFT", "pe_ratio")
=MXLS("GOOGL", "market_cap")

Benefits of Google Sheets

• Access anywhere - Work from any device with a browser
• Collaboration - Share spreadsheets with team members
• Cross-platform - Works on any operating system
• Auto-save - Never lose your work
• Free Google Sheets - Only pay for MarketXLS data

Note: Mac users can also use MarketXLS natively with Excel for Mac via our Office 365 add-in.

Pricing

Google Sheets access requires a separate subscription. Visit marketxls.com/pricing for current pricing information.

Limitations vs Excel

The Google Sheets add-on has some differences from the Excel version:

• Streaming real-time data is not available
• Some advanced functions are Excel-only
• Add-in interface is simplified

Need Help?

• Email: support@marketxls.com
• Documentation: marketxls.com/docs