Importing an Equivalence

Overview

You can import equivalences that you created in another portfolio management system. Once imported, these equivalences display in the Equivalence List. Equivalence information is imported using text files (.txt or .csv extension). The data contained in the text file must be separated by commas and must comply with the platform equivalence import file specifications.

Top

Importing an Equivalence

NOTE:

  1. Select Trade > Trading Tools > Portfolio Modeling & Rebalancing to launch Modeling & Rebalancing.
  2. Select Equivalences > Import Equivalence.
    OR
    Select Equivalences > Equivalence List and then select the Import Equivalence button at the top of the screen.
  3. The Import Equivalence screen displays. Select the Browse button to locate the text file. NOTE: Select the View template import file link to display a pop-up screen containing the equivalence import file specifications. Select the Cancel Import link to close the screen without performing the import and to return to the Equivalence List.
  4. Select the Import button. The system validates the file format and verifies that the equivalence name is unique, the equivalence contains valid security symbols and/or CUSIPs, and the securities in the imported equivalence do not overlap with any existing equivalences. NOTE: Select the Stop Import link to abort the importing of the equivalence and return to the Equivalence List.
  5. If the system locates equivalences that already exist, a pop-up screen containing a list of these equivalences displays.
    Select the Cancel button to ignore the import and close the pop-up.
    OR
    Select the equivalence(s) that you wish to import by selecting the associated check box(es). Select the Overwrite button that is enabled to perform the import and close the pop-up.
  6. If you chose to perform the import, two sections display below the import criteria you entered. These sections are Import Status and an Import Log. There are two icons associated with each section:
    - Excel: Displays a pop-up screen that you can use to specify the location where you wish to save the list contents; the file is saved as a .csv file.
    - Print: Displays a pop-up screen that you can use to print the list contents.

    The Import Status section contains a Percentage Complete indicator, as well as the Total Imported, which is a sum of those that were Successful those With Errors, and those Not Imported. The information in the table provides the Status of the import, the Equivalence Name, and the Creation and Update Date and Times.

    The Import Log section provides information on the components included in the import, such as the total number equivalent securities and account equivalence assignments imported and whether they were imported correctly.

  7. If the import is successful, the equivalence displays in the Equivalence List. If there are errors in the import, review the contents of the import file, make any necessary edits, and perform the import again.
Top

Equivalence Import File Specifications

NOTE:

Equivalence Import Record Format

<Record Indicator>,<Equivalence Name>,<Equivalence Description>,<Creation Timestamp>,<Creator User ID>,<Last Updated Timestamp>,<Last Updater User ID>,<Access Preference>
<Record Indicator>,<Security ID>,<Security Indicator>
<Record Indicator>,<Account Number>,<Custodian Code>,<Account Source Code>

Field Description
Access Preference

Displays the access constraint of the equivalence. Options are:

  • Public: Unlimited access
  • Private: Limited to you or a member of your firm

NOTE: This field is entitled and may not apply to you.
Account Number Displays the account number assigned to the equivalence.
Account Source Code

Displays a one character code that identifies the type of account - either Fidelity or other (e.g., Advent, Black Diamond). Some examples are:

  • B or BROK: Fidelity Brokerage/Trust
  • XAVNT: Advent
  • XBLKD: Black Diamond
Creation Timestamp Displays the time the equivalence was created.
Creator User ID Displays the User ID of the individual who created the equivalence.
Custodian Code

Displays a code that identifies the custodian of the account. There are many options; some examples are:

  • FID: Fidelity
  • bz: Fidelity Investments: FITSCo Retirement
  • vs: Charles Schwab
Equivalence Description Displays the description of the equivalence.
Equivalence Name Displays the user-defined name of the equivalence.
Last Updated Timestamp Displays the last time the equivalence was edited.
Last Updater User ID Displays the User ID of the individual who last edited the equivalence.
Record Indicator

Displays the type of record that follows. Options are:

  • A: Account Record (Account Assignment)
  • E: Equivalence Record
  • S: Security Record (Security Assignment)
Security ID Displays the ID of the security included in the equivalence.
Security Indicator

Indicates the type of Security ID. Options are:

  • C: CUSIP
  • S: Security
Top

Sample Equivalence Import Files

With Double Quotes

"E","Technology Companies","Sample Description","20080312","769000007","20080315","769000007","Public"
"S","YHOO","S"
"S","106702103","C"
"S","594918104","C"
"S","ORCL","S"
"A","179000034","FID","B"
"A","179000123","FID","B"

Without Quotes

E,Technology Companies,Sample Description,20080312,769000007,20080315,769000007,Public
S,YHOO,S
S,106702103,C
S,594918104,C
S,ORCL,S
A,179000034,FID,B
A,179000123,FID,B

871234.1.0

Top