Refinitiv Eikon Excel Add In vs MarketXLS: Complete Comparison for Financial Analysts (2026)

M
MarketXLS Team
Published
Refinitiv Eikon Excel Add In comparison with MarketXLS showing feature differences for financial data in Excel

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.

AspectRefinitiv Eikon Excel Add-InMarketXLS
Parent CompanyLSEG (London Stock Exchange Group)MarketXLS Inc.
Primary AudienceInstitutional traders, banks, large firmsIndividual investors, RIAs, small firms
Pricing ModelEnterprise licensing (typically $15,000–$22,000+/yr)Subscription tiers (visit pricing page)
Data SourcesRefinitiv proprietary feeds, ReutersQuoteMedia, multiple aggregated feeds
Asset CoverageEquities, FX, fixed income, commodities, derivatives, ESGEquities, options, ETFs, mutual funds, crypto
Excel IntegrationCOM add-in with custom ribbonCOM add-in with custom ribbon
PlatformWindows (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:

TaskMarketXLSRefinitiv 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.

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

FeatureRefinitiv EikonMarketXLS
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 integrationLimited (institutional)✅ (IB, Tradier, Thinkorswim)
Pre-built templatesSome100+
AI-powered search
Floating license
Self-service setup
Learning curveSteepMinimal
Pricing$15,000–$22,000+/yr per userSee 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:

  1. Open Eikon desktop application and Excel
  2. Use =TR() functions to pull current prices, fundamentals, and historical data
  3. Manually build Sharpe Ratio calculation from historical returns
  4. Use RData for screening, RHistory for time series
  5. Reference Eikon's function builder for correct syntax
  6. Export results or share workbook (each user needs their own license)

With MarketXLS:

  1. Open Excel with MarketXLS add-in
  2. Enter tickers and use =Last() for current prices
  3. Use =PERatio(), =Revenue(), =DividendYield() for fundamentals
  4. Use =SharpeRatio(A1:B10) for instant risk-adjusted performance
  5. Use =GetHistory() for historical analysis
  6. Execute trades via Interactive Brokers integration
  7. 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 FunctionMarketXLS 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

FactorRefinitiv EikonMarketXLS
Annual cost per user$15,000–$22,000+Visit pricing page
Multi-user discountEnterprise negotiationFloating license included
Additional data packagesExtra costIncluded in subscription
Setup / onboarding costVaries (may include training)Self-service, no setup cost
Contract lengthTypically annualFlexible

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

MetricRefinitiv EikonMarketXLS
Real-time quote latencySub-secondSub-second
Historical data retrieval1-3 seconds< 86 ms typical
Options chain load time2-5 seconds1-2 seconds
Streaming refresh rateMillisecond-levelSecond-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

  1. Contact LSEG sales team for a demo and pricing quote
  2. Negotiate contract terms and licensing agreement
  3. IT department provisions Eikon desktop application
  4. Install Excel add-in alongside the desktop client
  5. Complete training sessions (often multi-day)
  6. Begin building models using the function builder
  7. Typical time from interest to productive use: 2-6 weeks

Getting Started with MarketXLS

  1. Visit MarketXLS and choose a subscription plan
  2. Download and install the Excel add-in
  3. Enter your license key
  4. Start using functions like =Last("AAPL") immediately
  5. Browse 100+ templates for pre-built analysis models
  6. 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 FeatureRefinitiv EikonMarketXLS
Dedicated account managerYes (for enterprise clients)No
Email supportYesYes
Phone supportYesYes
Knowledge base / docsExtensiveYes
Video tutorialsLimitedExtensive
Community forumYesYes
Response timeVaries by tierTypically < 24 hours
WebinarsQuarterlyRegular
Template librarySome100+ 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.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader

Meet The Ultimate Excel Solution for Investors

Live Streaming Prices in your Excel
All historical (intraday) data in your Excel
Real time option greeks and analytics in your Excel
Leading data service for Investment Managers, RIAs, Asset Managers
Easy to use with formulas and pre-made sheets