Access the NSCC file formats for ETF, including record layouts and canned test data files. For answers to general file format questions, transmission options questions, and key definitions for ETF Domestic Portfolio data files, including custom portfolios, see ETF File Format Definitions.
Note:
- ETF Phase 2 enhancements to support fixed income assets for Corporate, Municipal, and UIT (CMU) deployed to production on April 26, 2021.
- ETF Phase 1 PCF enhancements for multiple baskets deployed to production on July 27, 2020.
Log in to view all of the content available in the Learning Center. For content updated specifically for the ETF Phase 1 or 2 releases, see ETF Release.
View the NSCC file formats for ETF processing.
Enhanced ETF Create and Redeem Instruction Input MRO: DATATRAK Production 11300/PSE 41300
Enhanced ETF Create and Redeem Instruction Data Output (MRO): AutoRoute Production 02261254/PSE 02981254
Enhanced Consolidated Portfolio Composition Output File Layout: AutoRoute 02261256/PSE 02981256
Enhanced Consolidated Portfolio Composition Input Data File: DATATRAK Production 11301/ PSE 41301
Enhanced Consolidated Portfolio Receipt Reject MRO: AutoRoute Production 02261255/PSE 02981255
Enhanced ETF Create and Redeem Instruction Print Image Report: AutoRoute Production 02260291/PSE 02980291
End of Day Instruction Create/Redeem Receipt/Reject Report: AutoRoute Production 02120098/Test 02980098
Enhanced Intraday Create/Redeem Receipt/Reject Report: AutoRoute Production 02261954/Test 02981954
Near RealTime Supplemental PCF: AutoRoute Production 02262335/Test 02982335
UTC MRO Trade Capture Data File: AutoRoute 02081673/Test 02981673
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
ETF Canned Sample Output for AutoRoute Production 02261254/PSE 02981254
ETF Canned Sample Output for AutoRoute Production 02261256/PSE 02981256
ETF Canned Sample Output for AutoRoute 02261255/PSE 02981255
View the Historical Portfolio Composition output record layout and canned sample for AutoRoute 02262222. Learn more about the ETF Portfolio Data Service.