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

back to top