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 New!

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

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

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
1PCF and Near Real Time File Specification AutoRoutes (02261256) and (02262335)PCF and Near Real Time File Specification AutoRoutes (02261256) and (02262335) New!

This document describes the fields in the ETF Portfolio Composition File (PCF) Specification file (AutoRoutes (02261256) and (02262335).

Apr 05, 2018
2Non-CUSIP Portfolio Composition File (PCF) File SpecificationNon-CUSIP Portfolio Composition File (PCF) File Specification

This document describes the fields in the Non-CUSIP Portfolio Composition file.

Mar 19, 2018
3PCF and  Near Real Time File SpecificationPCF and Near Real Time File Specification

This file documents the fields in the PCF and Near Real Time file.

Mar 19, 2018
4ETF PCF Daily Sample FileETF PCF Daily Sample File

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

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

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

Apr 16, 2018
6ETF 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) New!

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

Apr 16, 2018
7ETF 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 New!

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