Refinitiv Datastream

What You're Getting

Refinitiv Datastream (now part of LSEG Data & Analytics) is an enterprise financial and economic database covering 175+ countries — equities, bonds, currencies, commodities, economic indicators, and fund data. 50+ years of history for major series. Access is via the Datastream Web Services (DSWS) API, Excel add-in, or Python wrapper. This is a paid enterprise data source used widely in quantitative finance and academic research.

Ingestion Strategy

Use the DSWS API or the DatastreamDSWS2Python Python library. Requests specify Datastream mnemonics (e.g. USCPALL% for US CPI), date ranges, and frequency. For bulk warehouse loads, build a series registry and request in batches.

import DatastreamDSWS as DSWS

ds = DSWS.Datastream(username="your_user", password="your_pass")
df = ds.get_data(
    tickers="USCPALL%, GGGDPD%, UKUN%",
    fields=[""],
    date="-20Y",
    freq="M"
)

Rate Limits & API Details

• Access requires active LSEG/Refinitiv license
• Rate limits vary by subscription tier — typically 30–60 requests/minute
• Python library: pip install DatastreamDSWS2Python
• DSWS base: https://product.datastream.com/dswsclient/V1/DSService.svc/rest

Schema Stability

Datastream mnemonics are long-standing and stable. LSEG changes mnemonics rarely but does retire series — monitor for ERR responses indicating discontinued series. Economic series often have both % (percentage change) and level variants. Datastream uses its own date format conventions.

Data Quality Gotchas

• Mnemonic discovery is manual: no programmatic catalog browse; Datastream Navigator tool required for series discovery
• Backfilled data: some series show consistent historical data that was actually backfilled by Refinitiv — not always point-in-time
• Currency and index base: default base periods and currencies are mnemonic-specific; always check the series description
• License scope: different client licenses cover different geographies and asset classes — empty responses may indicate license restriction, not missing data

Tool Compatibility

• Python: DatastreamDSWS2Python official library
• R: DatastreamR package
• Excel: Datastream add-in for ad-hoc queries
• Airbyte: not supported (proprietary)
• For warehouse loads, use Python library + custom ETL pipeline

Benchmarking Approach

US CPI all items (USCPALL%) should show monthly YoY change within 0.1pp of BLS published CPI. S&P 500 (S&PCOMP) closing price for a known date should match within 0.1% of exchange-reported value. Verify series count in your registry returns valid data (no ERR response) after each contract renewal. Alert if series returns ERR for more than 2 consecutive periods.