Refinitiv Eikon Excel Add In (now part of LSEG Workspace) is one of the most established financial data platforms for Excel integration — but is it the right choice for every analyst and investor? With subscription costs that can exceed $20,000 per year per user, many professionals and individual investors are evaluating alternatives that deliver similar capabilities at a fraction of the price. In this comprehensive comparison, we examine Refinitiv Eikon's Excel Add-In alongside MarketXLS, covering data coverage, formula libraries, ease of use, pricing, and real-world workflow to help you choose the platform that fits your needs and budget.
Overview: Two Approaches to Financial Data in Excel
Both Refinitiv Eikon and MarketXLS share a core mission: deliver financial market data directly into Microsoft Excel so analysts can build models, run analyses, and make decisions without leaving their spreadsheet environment. However, they serve different audiences and take different approaches.
| Aspect | Refinitiv Eikon Excel Add-In | MarketXLS |
|---|---|---|
| Parent Company | LSEG (London Stock Exchange Group) | MarketXLS Inc. |
| Primary Audience | Institutional traders, banks, large firms | Individual investors, RIAs, small firms |
| Pricing Model | Enterprise licensing (typically $15,000–$22,000+/yr) | Subscription tiers (visit pricing page) |
| Data Sources | Refinitiv proprietary feeds, Reuters | QuoteMedia, multiple aggregated feeds |
| Asset Coverage | Equities, FX, fixed income, commodities, derivatives, ESG | Equities, options, ETFs, mutual funds, crypto |
| Excel Integration | COM add-in with custom ribbon | COM add-in with custom ribbon |
| Platform | Windows (Excel desktop) | Windows (Excel desktop) |
Refinitiv Eikon Excel Add-In: Strengths
Refinitiv Eikon (rebranded as LSEG Workspace in 2024) is an institutional-grade platform. Here is where it excels:
1. Unmatched Data Breadth
Eikon covers virtually every asset class across global markets — equities, fixed income, FX, commodities, derivatives, structured products, ESG data, and economic indicators. If you need Zambian government bond yields or Malaysian palm oil futures, Eikon has it.
2. Deep Fixed Income and FX Coverage
Eikon's strength in bonds and foreign exchange is unrivaled among Excel add-ins. It provides real-time bid/ask quotes, yield curves, swap rates, and credit default swap data — essential for institutional fixed-income desks.
3. Time Series and Screening
The RHistory and RData functions allow powerful time-series queries. Eikon's screener can filter across thousands of data fields spanning fundamentals, technicals, ESG scores, and ownership data.
4. Real-Time Streaming
Eikon supports real-time streaming data directly into Excel cells — critical for trading desks that need millisecond-level updates on FX pairs or equity quotes.
5. Integration with Reuters News
Direct access to Reuters news feeds, analyst estimates, and research within the same platform provides comprehensive context alongside raw data.
6. Compliance and Audit Trail
Institutional users benefit from Eikon's compliance features, data governance tools, and audit trails — requirements for regulated financial firms.
Refinitiv Eikon Excel Add-In: Limitations
1. Cost
Eikon's pricing is the most significant barrier. Enterprise licenses typically run $15,000–$22,000+ per user per year, with additional costs for premium data packages. This puts it out of reach for individual investors, small RIAs, and startup firms.
2. Single-User Licensing
Each Eikon license is tied to a single user and a single machine. You cannot share a license across team members or use it on multiple computers simultaneously. For a firm with 10 analysts, that means 10 separate licenses.
3. Steep Learning Curve
Eikon's formula syntax (=TR(), RData, RHistory) is powerful but complex. The function builder helps, but new users often require formal training sessions and weeks of practice before becoming proficient.
4. Heavy System Requirements
Eikon requires significant system resources — it runs a full desktop application alongside the Excel add-in. Older machines or laptops with limited RAM may experience performance issues.
5. Complex Onboarding
Getting started with Eikon involves procurement negotiations, IT setup, account provisioning, and often a dedicated support representative. It is not a self-service product.
MarketXLS: Strengths
MarketXLS is designed for speed, simplicity, and affordability. Here is where it shines:
1. Affordable Pricing
MarketXLS offers multiple subscription tiers at a fraction of Eikon's cost. Visit the MarketXLS pricing page for current plans. Individual investors, financial advisors, and small firms can access institutional-quality data without enterprise-level budgets.
2. Floating License Model
Unlike Eikon's single-machine lock, MarketXLS supports floating licensing — one license can be used on multiple machines (one at a time). This is ideal for professionals who work from an office desktop and a home laptop.
3. 1,100+ Excel Functions
MarketXLS provides over 1,100 pre-built Excel functions covering:
- Real-time prices:
=Last("AAPL"),=Stream_Last("AAPL") - Historical data:
=GetHistory("AAPL", "2025-01-01", "2026-01-01", "Daily") - Fundamentals:
=PERatio("AAPL"),=Revenue("AAPL"),=MarketCapitalization("AAPL") - Options:
=QM_GetOptionChain("^SPX"),=QM_GetOptionQuotesAndGreeks("^SPX") - Dividends:
=DividendYield("AAPL"),=DividendPerShare("AAPL"),=DividendFrequency("AAPL") - Technical indicators:
=RSI("AAPL"),=SimpleMovingAverage("AAPL", 50) - Portfolio analytics:
=SharpeRatio(A1:B5),=SortinoRatio(A1:B5),=TreynorRatio(A1:B5) - Historical financials:
=hf_revenue("AAPL", 2024, 2),=HF_EBIT("AAPL", 2024)
4. Intuitive Formula Names
MarketXLS functions are self-explanatory. Compare:
| Task | MarketXLS | Refinitiv Eikon |
|---|---|---|
| Current price | =Last("AAPL") | =TR("AAPL","CF_LAST") |
| P/E ratio | =PERatio("AAPL") | =TR("AAPL","TR.PE") |
| Historical prices | =GetHistory("AAPL",start,end,"Daily") | =RHistory("AAPL","CF_LAST",start,end,"D") |
| Dividend yield | =DividendYield("AAPL") | =TR("AAPL","TR.DivYield") |
| Market cap | =MarketCapitalization("AAPL") | =TR("AAPL","TR.CompanyMarketCap") |
| Option chain | =QM_GetOptionChain("^SPX") | =TR(RIC,"OPT_CHAIN") (with additional params) |
| Sharpe Ratio | =SharpeRatio(A1:B5) | No built-in function; manual calculation required |
MarketXLS functions read like plain English. There is virtually no learning curve for anyone comfortable with Excel formulas.
5. Options Analysis Suite
MarketXLS provides deep options coverage — full option chains, Greeks, implied volatility, historical IV, and options profit calculators. The =QM_GetOptionQuotesAndGreeks() function delivers a complete options snapshot in one call.
6. Broker Integration
MarketXLS integrates with Interactive Brokers, Tradier, and Thinkorswim, enabling trade execution directly from Excel. This creates a seamless research-to-execution workflow that Eikon does not offer for retail brokers.
7. 100+ Pre-Built Templates
MarketXLS ships with 100+ downloadable Excel templates for portfolio tracking, options analysis, stock screening, valuation models, and more. These templates use MarketXLS functions and are ready to use immediately.
8. Fast Data Delivery
Most MarketXLS data requests are processed in under 86 milliseconds. For the vast majority of use cases — portfolio monitoring, fundamental analysis, options scanning — this is more than sufficient.
9. AI-Powered Function Search
MarketXLS includes AI-powered search that helps users find the right function from over 1,100 options. Describe what you need in plain language, and the search returns the appropriate formula.
10. Accessible Support and Education
MarketXLS provides tutorials, webinars, video guides, and responsive customer support — especially helpful for users who are new to financial data in Excel.
Feature-by-Feature Comparison
| Feature | Refinitiv Eikon | MarketXLS |
|---|---|---|
| US equities (real-time) | ✅ | ✅ |
| US equities (historical) | ✅ | ✅ |
| Options chains | ✅ | ✅ |
| Options Greeks | ✅ | ✅ |
| Fundamentals (income statement, balance sheet, cash flow) | ✅ | ✅ |
| Technical indicators | ✅ (manual setup) | ✅ (=RSI(), =SimpleMovingAverage()) |
| Portfolio analytics (Sharpe, Sortino, Treynor) | ❌ (manual calc) | ✅ (built-in functions) |
| International equities | ✅ (comprehensive) | ✅ (US, Canada, major markets) |
| Fixed income / bonds | ✅ (extensive) | Limited |
| Foreign exchange | ✅ (institutional-grade) | ✅ (major pairs) |
| Commodities | ✅ (comprehensive) | ✅ (major commodities) |
| ESG data | ✅ | ❌ |
| Economic indicators | ✅ (comprehensive) | Limited |
| Real-time streaming | ✅ | ✅ (=Stream_Last()) |
| News integration | ✅ (Reuters) | ❌ |
| Broker integration | Limited (institutional) | ✅ (IB, Tradier, Thinkorswim) |
| Pre-built templates | Some | 100+ |
| AI-powered search | ❌ | ✅ |
| Floating license | ❌ | ✅ |
| Self-service setup | ❌ | ✅ |
| Learning curve | Steep | Minimal |
| Pricing | $15,000–$22,000+/yr per user | See pricing page |
Who Should Choose Refinitiv Eikon?
Refinitiv Eikon is the right choice if you:
- Work at an institutional trading desk, bank, or large asset management firm
- Need deep coverage in fixed income, FX, or emerging markets
- Require Reuters news integration within your Excel workflow
- Need ESG data and advanced screening across global markets
- Have a budget that supports enterprise licensing
- Require compliance features and audit trails mandated by regulators
For these use cases, Eikon's breadth and depth are difficult to match.
Who Should Choose MarketXLS?
MarketXLS is the right choice if you:
- Are an individual investor, financial advisor, or small firm analyst
- Focus primarily on US equities and options
- Want intuitive, self-explanatory Excel functions with no training required
- Need built-in portfolio analytics (Sharpe Ratio, Sortino Ratio, Treynor Ratio)
- Want to execute trades directly from Excel through retail broker integration
- Prefer a floating license that works across your office and home computers
- Need 100+ ready-to-use templates for common financial analyses
- Want institutional-quality data at an affordable price point
Real-World Workflow Comparison
Scenario: Analyzing a 10-Stock Portfolio
With Refinitiv Eikon:
- Open Eikon desktop application and Excel
- Use
=TR()functions to pull current prices, fundamentals, and historical data - Manually build Sharpe Ratio calculation from historical returns
- Use
RDatafor screening,RHistoryfor time series - Reference Eikon's function builder for correct syntax
- Export results or share workbook (each user needs their own license)
With MarketXLS:
- Open Excel with MarketXLS add-in
- Enter tickers and use
=Last()for current prices - Use
=PERatio(),=Revenue(),=DividendYield()for fundamentals - Use
=SharpeRatio(A1:B10)for instant risk-adjusted performance - Use
=GetHistory()for historical analysis - Execute trades via Interactive Brokers integration
- Share workbook — colleague can activate floating license on their machine
The MarketXLS workflow is faster, simpler, and does not require a separate desktop application running in the background.
Migration Considerations
If you are currently using Refinitiv Eikon and considering a switch to MarketXLS:
Data Coverage Gap Analysis
Before switching, identify any data points you rely on that MarketXLS may not cover:
- If you heavily use fixed income, FX crosses, or ESG data, MarketXLS may not fully replace Eikon
- If your work centers on US equities, options, and fundamental analysis, MarketXLS covers 95%+ of your needs
Formula Translation
Most Eikon formulas have direct MarketXLS equivalents:
| Eikon Function | MarketXLS Equivalent |
|---|---|
=TR("AAPL","CF_LAST") | =Last("AAPL") |
=TR("AAPL","TR.PE") | =PERatio("AAPL") |
=TR("AAPL","TR.Revenue") | =Revenue("AAPL") |
=TR("AAPL","TR.DivYield") | =DividendYield("AAPL") |
=RHistory(...) | =GetHistory(...) |
Template Library
MarketXLS's 100+ templates can replace many custom Eikon workbooks. Check the template library for portfolio trackers, options scanners, valuation models, and more.
Pricing Comparison
| Factor | Refinitiv Eikon | MarketXLS |
|---|---|---|
| Annual cost per user | $15,000–$22,000+ | Visit pricing page |
| Multi-user discount | Enterprise negotiation | Floating license included |
| Additional data packages | Extra cost | Included in subscription |
| Setup / onboarding cost | Varies (may include training) | Self-service, no setup cost |
| Contract length | Typically annual | Flexible |
For a small RIA firm with 3 analysts, the Eikon cost could be $45,000–$66,000+ per year. MarketXLS serves the same team at a dramatically lower cost, with floating licensing allowing license sharing across machines.
Data Quality and Reliability
Both platforms deliver institutional-quality data, but through different channels.
Refinitiv Eikon Data Sources
Eikon's data comes from Reuters and LSEG's proprietary feeds, which aggregate data from exchanges worldwide. The platform is trusted by banks and hedge funds for:
- Tick-by-tick trade data
- Level 2 order book depth
- Corporate actions (splits, dividends, mergers)
- Analyst estimates and consensus forecasts
- Ownership and insider trading data
MarketXLS Data Sources
MarketXLS aggregates data from QuoteMedia and other reliable providers. The data covers:
- Real-time and delayed quotes for US equities and options
- Historical OHLCV data going back decades
- Fundamental financial statements (income statement, balance sheet, cash flow)
- Technical indicators computed server-side
- Options chains with full Greeks
For most analytical workflows — portfolio analysis, stock screening, options trading, fundamental research — the data quality from both platforms is comparable. The key differences emerge in niche asset classes (exotic derivatives, emerging market bonds) where Eikon has exclusive feeds.
Data Latency
| Metric | Refinitiv Eikon | MarketXLS |
|---|---|---|
| Real-time quote latency | Sub-second | Sub-second |
| Historical data retrieval | 1-3 seconds | < 86 ms typical |
| Options chain load time | 2-5 seconds | 1-2 seconds |
| Streaming refresh rate | Millisecond-level | Second-level |
For portfolio monitoring, research, and swing/position trading, MarketXLS's speed is excellent. For high-frequency or algorithmic trading requiring tick-level streaming, Eikon's infrastructure is more robust.
Setup and Onboarding Experience
Getting Started with Refinitiv Eikon
- Contact LSEG sales team for a demo and pricing quote
- Negotiate contract terms and licensing agreement
- IT department provisions Eikon desktop application
- Install Excel add-in alongside the desktop client
- Complete training sessions (often multi-day)
- Begin building models using the function builder
- Typical time from interest to productive use: 2-6 weeks
Getting Started with MarketXLS
- Visit MarketXLS and choose a subscription plan
- Download and install the Excel add-in
- Enter your license key
- Start using functions like
=Last("AAPL")immediately - Browse 100+ templates for pre-built analysis models
- Typical time from interest to productive use: 15 minutes
The difference in onboarding speed is dramatic. MarketXLS is a self-service product designed for immediate productivity, while Eikon requires enterprise procurement processes.
Customer Support Comparison
| Support Feature | Refinitiv Eikon | MarketXLS |
|---|---|---|
| Dedicated account manager | Yes (for enterprise clients) | No |
| Email support | Yes | Yes |
| Phone support | Yes | Yes |
| Knowledge base / docs | Extensive | Yes |
| Video tutorials | Limited | Extensive |
| Community forum | Yes | Yes |
| Response time | Varies by tier | Typically < 24 hours |
| Webinars | Quarterly | Regular |
| Template library | Some | 100+ ready-to-use |
MarketXLS's support is geared toward helping individual users become productive quickly, with video tutorials, template walkthroughs, and responsive email support. Eikon's support model is more traditional enterprise — comprehensive but slower for individual queries.
Frequently Asked Questions
Is MarketXLS a full replacement for Refinitiv Eikon?
For US equity and options analysis, MarketXLS covers the vast majority of what most analysts need — real-time prices, historical data, fundamentals, options chains, technical indicators, and portfolio analytics. However, if you require deep fixed income coverage, FX analytics, ESG data, or Reuters news integration, Eikon provides capabilities that MarketXLS does not match. The answer depends on your specific data requirements.
Can I use both Eikon and MarketXLS simultaneously?
Yes. Both are COM add-ins for Excel and can coexist. Some users keep Eikon for specialized data (bonds, FX) while using MarketXLS for equities, options, and portfolio analytics — potentially reducing Eikon license costs by moving some users to MarketXLS-only.
How does MarketXLS handle real-time data?
MarketXLS provides real-time data via =Last() for on-demand current prices and =Stream_Last() for streaming updates. Most data requests complete in under 86 milliseconds. While not tick-by-tick institutional streaming, it is more than sufficient for portfolio monitoring, analysis, and day-trading workflows.
Does MarketXLS support international markets?
MarketXLS covers US exchanges comprehensively, with additional coverage for Canadian markets and major international exchanges. Refinitiv Eikon has broader international coverage, particularly in emerging markets and exotic instruments.
How difficult is it to switch from Eikon to MarketXLS?
The transition is straightforward. MarketXLS function names are intuitive (e.g., =Last(), =PERatio(), =GetHistory()), so there is no steep learning curve. Most users are productive within minutes of installation. The main effort is replacing Eikon formulas in existing workbooks — a one-time task that can be done with Find & Replace.
What about Bloomberg vs MarketXLS?
Bloomberg Terminal is even more expensive than Eikon (approximately $24,000/year per user) and serves a similar institutional audience. The comparison dynamics are similar — Bloomberg and Eikon excel in breadth and institutional features, while MarketXLS excels in affordability, ease of use, and self-service setup. For a detailed look, see our Bloomberg vs MarketXLS comparison.
Conclusion
Refinitiv Eikon Excel Add In remains a powerful, comprehensive platform for institutional financial analysis. Its unmatched data breadth in fixed income, FX, and global markets — combined with Reuters news integration and compliance features — makes it indispensable for banks and large asset management firms.
However, for individual investors, registered investment advisors, small firms, and anyone focused primarily on US equities and options, MarketXLS delivers the essential capabilities at a fraction of the cost. With 1,100+ intuitive Excel functions like =Last(), =PERatio(), =GetHistory(), and =SharpeRatio(), built-in portfolio analytics, broker integration, floating licensing, and 100+ ready-to-use templates, MarketXLS provides a compelling alternative that gets you from question to answer faster.
The right choice depends on your specific needs: choose Eikon for institutional breadth, choose MarketXLS for accessible power. Either way, your financial analysis stays where it belongs — in Excel.
Ready to try MarketXLS? Get started today and see how 1,100+ Excel functions can transform your financial analysis workflow. Visit the MarketXLS pricing page for subscription details.