ETF Technical Resources

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.

Notes:

  • Access client business requirements and related input and output format files for the upcoming ETF T0 and T+1 Settlement Cycle releases at ETF Release.
  • ETF enhancements to support fixed income assets for Corporate, Municipal, and UIT (CMU) deployed to production on April 26, 2021.
  • ETF 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. 

{docmanlist orderByOrder 1100}

View these canned sample output data in a text editor with Word Wrap turned off.

{docmanlist orderByOrder 1101}


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:
Order Resources by

Test Guidelines for the ETF T0 Release

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

ETF T0 Release: 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.

Client Business Requirements: T0 Same Day Settling Create/Redeem Cycle With End of Day Cash True-up

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

ETF T0 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.

ETF T0 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.

UTC Common Trade FIX Output Format (T+1 Settlement)

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

NSCC Primary Market Create/Redeem Functional Requirements

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

Trading Relationship Management User Guide

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

UTC Intraday MRO (02081673) Trade Capture Data - Output Format (T+1 Settlement)

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

What Is An ETF?

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.

Client Business Requirements: Phase 2 — Clearing Enhancements to Support Fixed Income Assets for Corporate, Municipal, and UIT (CMU)

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

ETF Canned Sample Output for 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.

UTC MRO Trade Capture Data File: AutoRoute 02081673/Test 02981673

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

ETF Canned Sample Input for AutoRoute 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.

Exchange Traded Fund (ETF) Web User Guide

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

ETF Canned Sample Output for 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.

ETF Canned Sample Output for AutoRoute 02261255/PSE 02981255

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

Enhanced Consolidated Portfolio Receipt Reject MRO: AutoRoute Production 02261255/PSE 02981255

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

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.

Near RealTime Supplemental PCF: AutoRoute Production 02262335/Test 02982335

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.

Enhanced Consolidated Portfolio Composition Output File Layout: AutoRoute 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.

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.

Client Business Requirements: Phase 1 — PCF Enhancements for Processing Multiple Basket Types

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam sit amet mauris ac purus imperdiet accumsan id sed nisi. Donec ut pulvinar arcu.
back to top