DTCC’s ETF Portfolio Data Service enhances users’ decision-making in the management of Exchange-Traded-Fund (ETF) portfolios with a consolidated, convenient and consistent feed of U.S.-listed ETFs.
ETF PortalAlready have an ETF account? Log In
The ETF marketplace continues to grow as investors look to diversify their portfolios. Combining the tax advantages and low costs of index investing with the asset diversity found in mutual funds, an ETF tracks the performance of a group of assets without the need to purchase or hold the underlying components. The DTCC ETF Portfolio Data Service empowers brokers, fund managers, hedge funds, providers, redistributors, educational institutions and research firms to make better-informed decisions as they manage ETF portfolios.
ETF data subscribers can review portfolio files instantaneously through an automated, centralized platform available 24/7. DTCC’s streamlined approach gives subscribers the ability to review, either online or in a data file, the ETF constituents that are analyzed and used in the creation and redemption of ETF shares and their subsequent settlement. This information can also be distributed automatically through a variety of secured transmission options, giving subscribers immediate access to the daily, near-real-time supplemental and historical portfolio files.
Features & Benefits
- Consolidated File Save time by receiving a comprehensive and consolidated industry file without going to multiple sources.
- Near Real-Time Supplemental File and Email Alerts Stay up to date and informed through automatic file delivery or email notification of new and updated ETF portfolios.
- Flexible Pricing Control costs by subscribing to ETF portfolios of interest.
- Component Search Manage exposure and risk by quickly identifying all portfolios containing a particular security.
- Quick Search Quickly respond to client inquiries with on-demand search capability that allows identification of securites in an ETF.
- Up to 5-day historical view Quickly access previous days' constituent data.
- Export to Excel (.csv) or text file Integrate seamlessly with existing systems thanks to multiple file types.
- 24x7 availability Support client inquiries on any timezone.
- Daily consolidated portfolio composition file
- Historical consolidated portfolio composition file (back to November 2007)
The ETF portfolio composition file includes all U.S. listed ETFs along and their underlying constituents (over. 1,900; 70% U.S. and 30% non-U.S. funds).* View list of available ETFs
*Disclaimer: ETF PCF does not contain Exchange Traded Notes. ETF’s backed by physical commodities, such as GLD and WEAT, may or may not be included depending on the preference of the issuer to illustrate the value of the commodities within the basket. Baskets with components that are not exchanged in-kind may be represented by cash.
To facilitate trend and performance analysis of the ETF market, DTCC has a historical data set available from November 2007 to the present.
How It Works
- Data is received from 9 ETF Agents representing over 90 sponsors
- Data is enhanced with the following:
- Create and redeem eligibility indicator for ETF Portfolio
- CNS eligibility indicator for ETF Portfolio and Component Security Indicators
- Indicator for CNS eligible components undergoing corporate action
- Indicator for carry forward of a prior day’s portfolio
- ETF Daily output is distributed at the end of the processing day (Trade Date-1)
- Supplemental Files (includes updated or added portfolios)
- Near-Real Time: distributed upon receipt on Trade Date
- Batch: distributed on Trade Data
- ETF Historical data is updated at the end of the processing day (Trade Date)
- Historical ETF File on demand
- Daily ETF File 10:00PM ET
- Supplemental ETF Files
- Near-Real Time: Upon receipt from 12:00AM ET to 12:00PM ET
- Batch: 12:00PM ET
- Networks: SMART (DTCC Dedicated Network), AT&T Network-Based IP VPN (ANIRA), or Over the Internet i
- Protocols: SFTP, FTPS, Connect:Direct (NDM), MQ
- Web interface for on-demand access
The DTCC Learning Center is a single point of entry for all your DTCC Data services learning needs. Our learning solutions include documentation, simulations, videos, frequently asked questions, training events, and much more.