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.

Login 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.
Modified 28 October 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.
Modified 10 December 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
Modified 09 December 2020

Enhanced Consolidated Portfolio Composition Input File: AutoRoute 11301

View the Enhanced Consolidated Portfolio Composition Input File for AutoRoute 11301. Type DATATRAK Input
Modified 01 July 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
Modified 28 January 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.
Modified 12 November 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.
Modified 29 April 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.
Modified 10 August 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...
Modified 10 December 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.
Modified 21 January 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
Modified 23 April 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.  ...
Modified 22 July 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.  ...
Modified 22 July 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.  ...
Modified 27 January 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.
Modified 24 November 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.  ...
Modified 24 November 2021

back to top