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

Videos

Inside Your ETFs - an overview of the DTCC ETF Portfolio Composition File and ETF Historical data products.

 etfporfoliodateservice

Documentation


This section contains general documentation about the ETF Portfolio Data Service.

General

#NameDescriptionAdded On
1ETF Portfolio Data Service Onboarding GuideETF Portfolio Data Service Onboarding Guide

This file documents the steps to onboard to the ETF Portfolio Data Service.

Apr 17, 2018
2Exchange Traded Funds (ETFs) Frequently Asked Questions and File DefinitionsExchange Traded Funds (ETFs) Frequently Asked Questions and File Definitions

This document answers frequently asked questions related to the ETF Portfolio Service Exchange Traded Funds (ETFs), and also provides file definitions.

Apr 24, 2018

ETF Portfolio (Daily)

#NameDescriptionAdded On
1ETF PCF Daily Sample FileETF PCF Daily Sample File

This text file contains sample date for the ETF PCF Daily file.

Mar 19, 2018
2ETF Portfolio Service - Non CUSIP Composition File (PCF) Specification Document (AutoRoute 02262451)ETF Portfolio Service - Non CUSIP Composition File (PCF) Specification Document (AutoRoute 02262451)

This document describes the Consolidated PDF MRO file (Autoroute 02262451).

Apr 16, 2018
3ETF Portfolio Service PCF and Near RealTime Supplemental Files Specification  Autooutes (02261256) and (02262335)ETF Portfolio Service PCF and Near RealTime Supplemental Files Specification Autooutes (02261256) and (02262335)

This document is a file specification for the ETF Portfolio Service PCF and Near RealTime Supplemental File Autooutes (02261256) and (02262335)

Apr 16, 2018
4ETF PCF Daily Non CUSIP SampleETF PCF Daily Non CUSIP Sample

This text file contains sample date for the ETF PCF Daily Non CUSIP Sample file.

Oct 19, 2016

ETF Portfolio (Historical)

#NameDescriptionAdded On
1ETF Portfolio Data Service Historical File SpecificationETF Portfolio Data Service Historical File Specification

To facilitate trend and performance analytis of the ETF market, DTCC provides a historical data set, available from November 2007 to the present. This document is a specificaiton for this data set.

Apr 20, 2018
2ETF Historical Sample FileETF Historical Sample File

This text file provides sample date for this ETF Historical file.

Oct 19, 2016
3ETF Historical Upload Template - Error Codes and Helpful HintsETF Historical Upload Template - Error Codes and Helpful Hints

This document outlines error codes and helpful hints returned from the ETF Historical Request tab when you complete the ETF Historical Upload Template process. 

Mar 13, 2018