Schofield Money

Enter password to view this report

Incorrect password
Data Provider Gap Analysis

FE fundinfo → Morningstar DWS

Which APIs Do We Actually Need?

8 APIs
Match FE
Could drop FE if needed
  • Full fund data + risk metrics
  • Daily time series (sync + async batch)
  • Universe screening
  • Portfolio look-through (X-Ray)
  • Portfolio performance analytics
  • Already exceeds FE — Star Rating, Medalist Rating, ESG data, discrete performance, IA Sector classification all included as bonuses
Verbatim API products
  1. Investment Details - Managed Investments Sync & Async
  2. Security Details Sync
  3. Time Series Sync & Async
  4. Screener Sync
  5. Screener - Managed Investments Sync
  6. Portfolio Analysis - X-Ray Sync
  7. Portfolio Analysis - Performance Sync
  8. Portfolio Analysis - Risk Score Sync
Recommended 14 APIs
Comfort
Dual-provider sweet spot
  • Everything in Match FE
  • AI-generated analyst highlights
  • PDF research reports (ESG, Carbon, Fund)
  • Editorial content (14 types)
  • MiFID cost comparison
  • Portfolio back-testing (hypothetical performance)
  • Stress testing / scenario analysis
Verbatim API products
  1. Investment Details - Managed Investments Sync & Async
  2. Security Details Sync
  3. Time Series Sync & Async
  4. Screener Sync
  5. Screener - Managed Investments Sync
  6. Portfolio Analysis - X-Ray Sync
  7. Portfolio Analysis - Performance Sync
  8. Portfolio Analysis - Hypothetical Performance Sync
  9. Portfolio Analysis - Risk Score Sync
  10. AI Insights Async
  11. Cost Calculator Sync
  12. Documents Sync
  13. Editorial Sync
  14. Scenario Analysis Sync
19 APIs
Full Arsenal
Everything relevant
  • Everything in Comfort
  • Efficient frontier / portfolio optimizer
  • Generated portfolio reports
  • Fund-level research reports
  • Equity screening capability
Verbatim API products
  1. Investment Details - Managed Investments Sync & Async
  2. Investment Details - Equities Sync & Async
  3. Security Details Sync
  4. Time Series Sync & Async
  5. Screener Sync
  6. Screener - Managed Investments Sync
  7. Screener - Equities Sync
  8. Portfolio Analysis - X-Ray Sync
  9. Portfolio Analysis - Performance Sync
  10. Portfolio Analysis - Hypothetical Performance Sync
  11. Portfolio Analysis - Portfolio Optimizer Sync
  12. Portfolio Analysis - Risk Score Sync
  13. Portfolio Analysis - Reports Sync
  14. Reports Sync
  15. AI Insights Async
  16. Cost Calculator Sync
  17. Documents Sync
  18. Editorial Sync
  19. Scenario Analysis Sync
Best Value 13 APIs
Extras Only
Keep FE, add the gaps
  • 7,000+ ESG data points
  • Star Rating + Medalist Rating
  • UK SDR labels + SFDR classification
  • Analyst reports + AI insights
  • Stock overlap + correlation matrix
  • Portfolio optimizer + back-testing
  • Scenario analysis / stress testing
  • Editorial content (14 types)
  • Skips Time Series, Screener, basic fund data — FE handles those. Strongest negotiation position: supplement, don't replace.
Verbatim API products
  1. Investment Details - Managed Investments Sync & Async
  2. Security Details Sync
  3. Portfolio Analysis - X-Ray Sync
  4. Portfolio Analysis - Hypothetical Performance Sync
  5. Portfolio Analysis - Portfolio Optimizer Sync
  6. Portfolio Analysis - Risk Score Sync
  7. Portfolio Analysis - Reports Sync
  8. Reports Sync
  9. Documents Sync
  10. Editorial Sync
  11. AI Insights Async
  12. Scenario Analysis Sync
  13. Cost Calculator Sync

01 — Current State

FE fundinfo Data Surface

What we currently receive across three API endpoints, tested against 31 live funds.

D
Fund Data API

39 Fields per Fund

  • Identification: Citicode, ISIN, Fund Name, Ethical Flag
  • Size & Charges: Fund Size, OCF, plus 3 others
  • Cumulative Performance: 1yr, 3yr, 5yr
  • Risk Metrics: 19 fields (Vol, Sharpe, Sortino, Beta, BearBeta, Alpha, Treynor, R², MaxDD, MaxGain/Loss, Pos/Neg periods)
  • Manager: Name + Start Date
  • Holdings: Top 10 positions
  • 6 Breakdown types: Asset, Sector, Region, Market Cap, Credit, Maturity
S
Series Data API

Daily Time Series

  • Bid-to-bid total return
  • ~757 data points per 3-year span
  • DD.MM.YY date format
  • Single fund per request
  • Used for PRISM v2 ML pipeline and custom charting
P
Portfolio Data API

Blended Analytics

  • Portfolio ratios: Vol, Sharpe, Sortino, MaxDD
  • Time series: 780 data points
  • Look-through: 118 asset, 77 region, 76 sector
  • Top-10 holdings: returns empty
  • 190ms rate limit between calls

02 — Gap Matrix

Feature-by-Feature Comparison

Every FE capability mapped to its Morningstar equivalent. The colour tells the story.

Equivalent+ MS matches or exceeds FE
Validate Different methodology, needs testing
FE Only No MS equivalent
MS Exclusive FE doesn't offer this
🏷

Identification

4 fields
FE fundinfoMorningstar DWSStatus
CiticodeMSID / PerformanceId (ISIN supported)Different ID
ISINISINMatch
Fund NameLegal NameMatch
Ethical FlagSustainable Attributes (58 fields)Far richer
📈

Performance

8 comparisons
FE fundinfoMorningstar DWSStatus
Cumulative 1/3/5yrTrailing Returns (145 variants) — pre/post tax, all periodsFar more
No discrete performanceCalendar Year + Rolling ReturnsMS adds
No annualised returnsAnnualised variants includedMS adds
No peer rankingsPerformance Ranks (425 fields)MS adds
No attributionPerformance Attribution (country/sector/currency/fee)MS adds
🛡

Risk Metrics

16 comparisons
FE fundinfoMorningstar DWSStatus
Volatility 1/3/5yrStandard Deviation 1/3/5/10/15yrMore periods
Sharpe 1/3yrSharpe Ratio 1/3/5/10/15yrMore periods
Sortino 1/3yrSortino Ratio (all periods)Match+
Beta 3yrBeta 1/3/5/10/15yrMore periods
BearBeta 3yrDownside Capture RatioValidate
Jensen's Alpha 1/3yrAlpha (all periods)Match+
Treynor 1/3yrTreynor RatioMatch
R² 1/3yrR-Squared (all periods)Match+
Max Drawdown 5yrMax Drawdown (all periods)Match+
Max Gain/Loss 5yrMax/Min ReturnMatch
Pos/Neg PeriodsNumberOfPositives / NegativesMatch
No Information RatioInformation RatioMS adds
No Tracking ErrorTracking ErrorMS adds
No Capture RatiosUpside / Downside CaptureMS adds
No Active ShareActive ShareMS adds
No Factor Profile152 factor exposuresMS adds
📊

Holdings & Breakdowns

10 comparisons
FE fundinfoMorningstar DWSStatus
Top 10 HoldingsFull Portfolio Holdings (47 fields per holding)Far deeper
Asset Class breakdownAsset Allocation (104 fields)Match+
Sector breakdownEquity Sectors (639) + FI Sectors (2,629 fields)Far richer
Region breakdownCountry/Regional Exposure (1,944 fields)Far richer
Market Cap breakdownMarket Capital BreakdownMatch
Credit Rating breakdownCredit Quality (777) + FI Stats (2,681 fields)Far richer
Maturity breakdownMaturity / Coupon breakdownsMatch+
No Style BoxEquity + Bond Style BoxMS adds
No GICS classificationGICS Industry / Sub-industry (303 fields)MS adds
No Currency ExposureCurrency Exposure (970 fields)MS adds
💰

Charges & Fees

3 comparisons
FE fundinfoMorningstar DWSStatus
OCFOngoing Charge + 490 fee fieldsFar richer
No MiFID costsMiFID II Cost Data (51 fields)MS adds
No performance fee detailPerformance Fee DetailsMS adds
👤

Manager Information

1 comparison
FE fundinfoMorningstar DWSStatus
Manager Name + Start DateName + Start + Biography + Gender + Education + Ownership + RetentionMuch richer

Ratings

2 comparisons
FE fundinfoMorningstar DWSStatus
No ratings in current configStar Rating (3/5/10yr + overall)MS adds
FE Crown available (not configured)Medalist Rating — Gold/Silver/Bronze (59 fields)MS adds
🌿

ESG & Sustainability

7 MS-exclusive categories
FE fundinfoMorningstar DWSStatus
NothingESG Risk Score (79 fields)MS exclusive
NothingCarbon Risk + Emissions (446 + 377 + 53 fields)MS exclusive
NothingSFDR PAI (994 fields)MS exclusive
NothingUK SDR Labels (12 fields)MS exclusive
NothingProduct Involvement screeningMS exclusive
NothingPhysical Climate RiskMS exclusive
NothingGender & DiversityMS exclusive
📅

Time Series

2 comparisons
FE fundinfoMorningstar DWSStatus
Daily bid-to-bid total returnTime Series API (sync 25 funds, async batch)Validate depth
DD.MM.YY date formatISO datesBetter format
🎯

Portfolio Analytics

4 comparisons
FE fundinfoMorningstar DWSStatus
Portfolio ratios (Vol/Sharpe/Sortino/MaxDD)X-Ray + Performance + Risk Score + OptimizerMuch richer
Look-through breakdownsX-Ray (250 holdings, full look-through)Match+
No stock overlap analysisStock Intersection analysisMS adds
No correlation matrixCorrelation MatrixMS adds
🚀

Morningstar-Exclusive Capabilities

10 new categories
FE fundinfoMorningstar DWSStatus
NothingAI Insights (analyst highlights + earnings summaries)MS exclusive
NothingEditorial (14 content types incl. Investment Trust Research)MS exclusive
NothingDocuments API (ESG/Carbon/Fund/Analyst reports as PDF)MS exclusive
NothingScenario AnalysisMS exclusive
NothingCost CalculatorMS exclusive
NothingRisk ProfilerMS exclusive
NothingMCP Server (AI-native integration)MS exclusive
NothingFund Flows (estimated net flows)MS exclusive
NothingDistribution HistoryMS exclusive
NothingProxy Voting RecordsMS exclusive

03 — Risk Register

FE-Only Features We Would Lose

Features with no direct Morningstar equivalent or requiring validation before migration.

FE Citicode System

All downstream systems use citicodes. Migration requires an ISIN pivot layer — every query, every lookup, every stored reference needs remapping.

BearBeta 3yr

MS has Downside Capture Ratio instead — different calculation methodology. PRISM v2 uses BearBeta directly. Needs validation against ML pipeline.

FE Risk Score Time Series

Proprietary FE metric with no Morningstar equivalent. Used for risk trend analysis. Would need replacement methodology.

FE Crown Rating

Proprietary rating. Replaced by Star Rating + Medalist Rating — arguably stronger, but different methodology and recognition.

UK Life/Pension Internal Funds

Coverage of internal life/pension fund variants unconfirmed on Morningstar. Critical for adviser platform — must verify during trial.

Bulk Universe Pull Pattern

FE allows full universe pulls. MS uses pagination — different integration pattern. Not a blocker, but code rework needed.

Rate Limit Simplicity

FE: simple 190ms between calls. MS may have different, potentially more complex rate limiting. Need to confirm during trial access.


04 — Capability Matrix

Capability Matrix

Complete feature comparison at a glance — every data domain side by side.

Legend
Not available
Limited / basic
Good coverage
Comprehensive (glows = Morningstar full)
Feature / Data Point FE fundinfo Morningstar DWS
Core Fund Data
Fund Identifiers ISIN, name, citicode
Fund Size / AUM
Ongoing Charges (OCF)
Fee Breakdown MiFID, loads, performance
Manager Information
Fund Strategy Text
Performance
Cumulative Returns
Discrete / Calendar Year Returns
Annualised Returns
Peer Group Rankings
Performance Attribution
Risk Metrics
Volatility
Sharpe / Sortino
Alpha / Beta / R²
Bear Beta / Downside Capture
Treynor Ratio
Max Drawdown
Information Ratio / Tracking Error
Active Share
Factor Exposures
Capture Ratios
Holdings & Breakdowns
Top Holdings FE: top 10 only — MS: full portfolio
Asset Allocation
Sector Breakdown
Regional / Country
Market Cap
Credit Quality
Style Box
Currency Exposure
GICS Classification
Ratings & Research
Star / Quantitative Rating
Analyst / Medalist Rating
Analyst Reports (full text)
AI Insights
Editorial Content
ESG & Sustainability
ESG Risk Score
Carbon Emissions / Risk
SFDR Classification
UK SDR Labels
Product Involvement Screening
Climate Risk (Physical)
Gender & Diversity
Time Series
Daily Price / NAV
Total Return Series
Fund Size History
Fund Flows
Portfolio Analytics
Portfolio Ratios
Look-through Breakdowns
X-Ray / Deep Analysis
Stock Overlap / Intersection
Correlation Matrix
Portfolio Optimizer
Platform & AI
Screener / Filtering
MCP Server (AI-native)
Scenario Analysis
Risk Profiler
Document Generation
05 — Roadmap

Next Steps

Four-phase evaluation path from research to commercials.

1
✓ Complete

API Range Selection

Full data dictionary analysed. 116 packages mapped. 22,089 fields catalogued against current FE surface. Gap matrix compiled.

2

Trial API Access

Request Morningstar DWS trial credentials. Validate time series depth, UK life/pension coverage, rate limits, and BearBeta replacement against live data.

3
Planned

MCP Server Trial

Build Morningstar MCP server mirroring the FE integration. Test AI-native queries, X-Ray portfolio analysis, and Jarvis integration.

4
Planned

Commercials

Negotiate pricing with Morningstar. Evaluate total cost of migration including ISIN pivot layer and PRISM v2 recalibration.

Research compiled: 2026-03-30  |  Sources: Live FE API responses (31 funds) + Morningstar official data dictionary (22,089 fields)