Access to DTCC products and services is managed by your organization’s designated Administrator or Super Access Coordinator (SAC) and cannot be provisioned directly by DTCC. To find your Administrator or SAC, visit Access & Permissions on the MyDTCC homepage.
ETF Technical Resources
Log in to access all resources.
On this page
Access the NSCC file formats for ETF, including record layouts and canned test data files. Log in, if necessary, to view all of the content available in the Learning Center.
Current Release: ETF Create/Redeem Activity Reporting DATATRAK Production 11200/PSE 41200
March 19, 2026
Current Release: Enhanced ETF Create and Redeem Instruction Input MRO: DATATRAK Production 11300/PSE 41300
May 29, 2026
Current Release: Enhanced Consolidated Portfolio Composition Input Data File: DATATRAK Production 11301/ PSE 41301
May 29, 2026
Current Release: Enhanced ETF Create and Redeem Instruction Data Output (MRO): AutoRoute Production 02261254/PSE 02981254
May 29, 2026
Current Release: Enhanced Consolidated Portfolio Composition Output File Layout: AutoRoute Production 02261256 / PSE 02981256
May 29, 2026
Current Release: Enhanced Consolidated Portfolio Receipt Reject MRO: AutoRoute Production 02261255/PSE 02981255
January 28, 2021
Current Release: Near RealTime Supplemental PCF: AutoRoute Production 02262335/PSE 02982335
May 29, 2026
Current Release: UTC Contract MRO: AutoRoute Production 02081673 / PSE 02981673
July 13, 2026
Current Release: End of Day Instruction Create/Redeem Receipt/Reject Report: AutoRoute Production 02120098 / PSE 02980098
April 29, 2019
Current Release: Enhanced Intraday Create/Redeem Receipt/Reject Report: AutoRoute Production 02261954 / PSE 02981954
August 10, 2018
View these canned sample output data in a text editor with Word Wrap turned off.
ETF Canned Sample Input for AutoRoute Production 11301/PSE 41301
April 27, 2026
ETF Canned Sample Output for AutoRoute Production 02261256/PSE 02981256
April 13, 2021
ETF Canned Sample Output for AutoRoute 02261255/PSE 02981255
January 28, 2021
ETF Canned Sample for Create/Redeem Activity Reporting DATATRAK Production 11200/PSE 41200
March 19, 2026
ETF Historical Data
To view the Historical Portfolio Composition output record layout and canned sample for AutoRoute 02262222, see ETF Portfolio Data Service.
Filter resources:
ETF Pended Order Confirmation Process Attestation Form
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
ETF Create/Redeem Threshold Pended Order Approval Process Review Webinar
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
NSCC ETF Create/Redeem Threshold Alert & Pended Order Process (Client Quick Reference)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
ETF Message Codes
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
ETF Create/Redeem Threshold Pended Order Approval Process Review Webinar
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Upcoming Release: ETF Portfolio Composition Input (Legacy DATATRAK 11301/41301)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Upcoming Release: ETF CSV Input and Output Files Help
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
DTCC Transformation Insight Series: Equities Clearing Readiness Check-in
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
ETF Product Information Form (PIF)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Clearing & Settlement Transformation: Client Test Plan
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Current Release: UTC Contract MRO: AutoRoute Production 02081673 / PSE 02981673
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Upcoming Release: ETF Create and Redeem Activity Reporting Input (Legacy DATATRAK Production 11200/PSE 41200)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Upcoming Release: ETF Portfolio Composition Receipt and Reject Output (ETF Agent Only) (Legacy AutoRoute 02260421, 02261255, and 02261955)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Upcoming Release: ETF Create and Redeem Instruction Output (Legacy AutoRoute 02261254 and 02260291)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Upcoming Release: ETF Portfolio Composition Output (Legacy AutoRoute 02261256 and 02262335)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Upcoming Release: ETF Create and Redeem Receipt and Reject Output (Legacy AutoRoute Production 02120098 and 02261954)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Upcoming Release: ETF Create and Redeem Instruction Input (Legacy DATATRAK 11300/41300)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Future State ETF CSV Input and Output File Samples
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
DTCC Transformation Insight Series: Equities Clearing Testing
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Testing Guidelines for the Options ETF Clearing Connect Release
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Current Release: Enhanced ETF Create and Redeem Instruction Input MRO: DATATRAK Production 11300/PSE 41300
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Current Release: Enhanced ETF Create and Redeem Instruction Data Output (MRO): AutoRoute Production 02261254/PSE 02981254
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Current Release: Enhanced Consolidated Portfolio Composition Output File Layout: AutoRoute Production 02261256 / PSE 02981256
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
Current Release: Enhanced Consolidated Portfolio Composition Input Data File: DATATRAK Production 11301/ PSE 41301
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.