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
View the Enhanced ETF Create and Redeem Instruction Input MRO: DATATRAK Production 11300/PSE 41300.
October 28, 2020
Enhanced ETF Create and Redeem Instruction Data Output (MRO): AutoRoute Production 02261254/PSE 02981254
View the Enhanced ETF Create and Redeem Instruction Data Output (MRO) for AutoRoute Production 02261254/PSE 02981254 record layout.
December 10, 2020
Enhanced Consolidated Portfolio Composition Output File Layout: AutoRoute 02261256/PSE 02981256
View the Enhanced Consolidated Portfolio Composition Output File Layout for the AutoRoute 02261256/PSE 02981256.
Type: AutoRoute Output
December 09, 2020
Enhanced Consolidated Portfolio Composition Input Data File: DATATRAK Production 11301/ PSE 41301
View the Enhanced Consolidated Portfolio Composition Input File for DATATRAK Production 11301/ PSE 41301.
Type DATATRAK Input
July 01, 2020
Enhanced Consolidated Portfolio Receipt Reject MRO: AutoRoute Production 02261255/PSE 02981255
View the Enhanced Consolidated Portfolio Receipt Reject MRO: AutoRoute Production 02261255/PSE 02981255.
Type: AutoRoute Output
January 28, 2021
Enhanced ETF Create and Redeem Instruction Print Image Report: AutoRoute Production 02260291/PSE 02980291
View the Enhanced ETF Create and Redeem Instruction Print Image Report: AutoRoute Production 02260291/PSE 02980291.
November 12, 2020
End of Day Instruction Create/Redeem Receipt/Reject Report: AutoRoute Production 02120098/Test 02980098
View the ETF End of Day Instruction Create/Redeem Receipt/Reject Report: AutoRoute Production 02120098/Test 02980098.
April 29, 2019
Enhanced Intraday Create/Redeem Receipt/Reject Report: AutoRoute Production 02261954/Test 02981954
View the record layout for the Enhanced Intraday Create/Redeem Receipt/Reject Report: AutoRoute Production 02261954/Test 02981954.
August 10, 2018
Near RealTime Supplemental PCF: AutoRoute Production 02262335/Test 02982335
View the record layout for the Near RealTime Supplemental Portfolio Composition File (PCF) Layout for AutoRoute Production 02262335/Test...
December 10, 2020
UTC MRO Trade Capture Data File: AutoRoute 02081673/Test 02981673
View the UTC MRO Trade Capture Data File: AutoRoute 02081673/Test 02981673 used for ETF processing.
January 21, 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
View the Enhanced Consolidated Portfolio Composition canned input sample data for AutoRoute Production 11301/PSE 41301.
Type: DATATRAK Input
April 23, 2021
ETF Canned Sample Output for AutoRoute Production 02261254/PSE 02981254
View this canned Data Enhanced ETF Create and Redeem sample output in a text editor with Word Wrap turned off.
...
July 22, 2021
ETF Canned Sample Output for AutoRoute Production 02261256/PSE 02981256
View these canned portfolio composition file (PCF) sample output data in a text editor with Word Wrap turned off.
...
April 13, 2021
ETF Canned Sample Output for AutoRoute 02261255/PSE 02981255
View this enhanced Consolidated Portfolio Composition Receipt Reject sample output data in a text editor with Word Wrap turned off.
...
January 27, 2021
View the Historical Portfolio Composition output record layout and canned sample for AutoRoute 02262222. Learn more about the ETF Portfolio Data Service.
Historical Portfolio MRO File Layout: AutoRoute 02262222
View the Historical Portfolio MRO File Layout: AutoRoute 02262222 output file layout for ETF processing.
November 24, 2021
Historical Portfolio Canned Test Data for AutoRoute 02262222
View the Historical Portfolio Composition sample output data for AutoRoute 02262222 in a text editor with Word Wrap turned off.
...
November 24, 2021