Child pages
  • Expanded Portfolio Data File Layout

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

LengthFromToDatatypeFormatDescription and Comments
111ANX(1)Record ID - "2"
324ANX(3)Clearing Member Firm
20524ANX(20)Account Number / ID
12525AX

Account Type. 

For client account types when clearing firms are calculating requirements for individual accounts: M for Member Account, H for Hedger Account, S for Spec Account, O for Omnibus Account, Q for Omnibus Hedge account. 

In addition, in 2020 support will be added for R for Heightened Risk Profile and N X for Non-Heightened Risk Profile.  Also account type O will be redefined as meaning an Omnibus Account with a Heightened Risk Profile and account type Q will be redefined as an omnibus account with a Non-Heightened Risk Profile.

Account type F is used to specify a clearing firm account when a CCP is margining a clearing firm.

52630ANX(5)Segregation Type (Origin) - CUST or HOUS
203150ANX(20)Subaccount of: If this record is a Hedge or Spec Subaccount of an Omnibus Account, this field should contain the Omnibus Account number. The 2 record for the omnibus account must precede the 2 record for its subaccounts (or the omnibus account portfolio record must already be defined in the PC-SPAN database.)
15151AXnew Portfolio flag: Y or N
125263N9(10)V9(2)Ledger Balance, right justified, with two implied decimal places representing hundredths of a currency unit. For accounts only, not relevant to firms. If negative, with a leading minus sign. If this record is for a firm, enter zero.
126475N9(10)V9(2)Open Trade Equity, right justified, with two implied decimal places. For accounts only, not relevant to firms. If negative, with a leading minus sign. If this record is for a firm, enter zero.
127687N9(10)V9(2)Securities on Deposit, right justified, with two implied decimal places. For accounts only, not relevant to firms. If this record is for a firm, enter zero.
18888AXApply User Scaleups? Flag - either Y or N. If it has been specified on the Maintain System Parameters screen that User Scaleups apply only to designated accounts, this field specifies whether scaleups apply to this particular account.
58993ANX(5)Business Function:  for SPAN 4 -- specifies the business function for which this position is defined
59498ANX(5)Clearing Member Firm -- for SPAN 4 -- provides the full five bytes for the clearing member firm ID
1599113ANX(15)Performance Bond Account ID:  for SPAN 4 -- specifies the PB account
5114118ANX(5)Position Segregation Type (Origin):  for SPAN 4 -- further identifies the performance bond account to which this position pertains
3119121ANX(3)Portfolio Currency - for example, USDCAD, ...- Overall currency for PB requirement
1122122ANX(1)Customer-Clearing Portfolio Use Long Option Value Flag - N for No, or or any other value for Yes.  Applies only to calculations for clearing-level customer-origin portfolios.  Added for the Common Clearing Link to support specification of whether CBOT positions in customer-origin clearing portfolios should be margined net but without use of Long Option Value, or according to submitted spreads and with full use of Long Option Value.  Set to Y if the firm wants CME-style customer-origin margining with full use of LOV, or CBT-style customer-origin margining without use of LOV.

...