Managing Instruments in RocketSheet

Managing instruments (or "products") is an administrative function performed by the RocketSheet administrator. Instrument data is maintained in a flat file Instruments.csv on the RocketSheet server. RocketSheet uses the information in this file for data-subscription management and to populate the MPF Packet 14 message it sends to Bloomberg. This message informs Bloomberg of the list of instruments for which RocketSheet users may be contributing data.

Note Traders may only publish data for instruments listed in the instruments file Instruments.csv. They will receive an "Unknown Instrument" error message in their spreadsheets if they attempt to contribute data for an instrument not defined in the instruments file.

The administrator may edit the instruments file directly using a text editor or an application such as Microsoft Excel. Alternatively, the administrator may edit the file through dialog boxes launched from the RocketSheet Instruments Manager window.

Instrument data fields and sources

Your instruments file will contain six records for each instrument, organized and sourced as follows.

ID
You will supply this information, which may be a CUSIP, ISIN, Ticker Symbol, Bloomberg Number, or similar identifier, depending upon your preferred choice of Identifier Type ("ID Type") for the instrument from Table 7 of the Bloomberg MPF specification.
ID Type
This will be a single character representing Identifier Type from Table 7 of the Bloomberg MPF specification. This tells Bloomberg how to interpret the ID you supplied in the previous field.
Symbol
This is a symbol for the instrument of your choosing that is used only in the trader Dashboards and MPF Gateway Manager to help you recognize an instrument. This may but is not required to match Bloomberg's symbology. This field is for your convenience only and not transmitted to Bloomberg.
Access Type
This is a two-character identifier for Page Access Type from Table 10 of the Bloomberg MPF specification. Page Access Type corresponds generally with, but is not the same as ID Type.
Monitor ID
Bloomberg will furnish this information to you.
Record Type
This is a two-character identifier for instrument type from Table 1 of the Bloomberg MPF specification.

If you need assistance determining how best to populate the fields for each of your instruments, please contact Ceylon Support or Bloomberg.

Editing the instruments file directly

If you are the RocketSheet administrator, you may use a text editor such as Windows Notepad or a spreadsheet application such as Microsoft Excel to create or edit the instruments file (Instruments.csv on the RocketSheet server). Direct editing of the instruments file is the easiest way to make bulk additions, changes, or deletions to the list of instruments for which you will be publishing data.

You will receive an initial Instruments.csv file with your RocketSheet software, containing at minimum the necessary first row of comma-separated values or "column headings." At your request and subject to data availability, Ceylon Support will provide you an instruments file populated with an sample set of instrument data (e.g., for U.S. Treasury issues) that you may use for testing purposes and replace as needed with your own data.

Note If you choose to use Microsoft Excel to edit Instruments.csv, we strongly recommend that you import the file into Excel using its Text Import Wizard rather than opening the file directly. If you choose to open the file with Excel directly rather than using Excel's Text Import Wizard, you incur the risk that Excel will automatically convert some of your text data to scientific notation, thereby making the data erroneous.

Using Excel's Text Import Wizard

To access the Text Import Wizard in Excel 2010 or Excel 2007, click the "From Text" icon in the "Get External Data" section of the "Data" ribbon. In Excel 2003, use the "Import Data" command from the "Get Exernal Data" submenu of the "Data" menu. In the Text Import Wizard screen that lets you choose columns and set the format for each column, select "Text" as your format for each column.

Structure and contents of the instruments file

Whether you use a text editor or Excel to edit your instruments file, the data in the resulting file must be organized in rows, with one row per instrument and each element of data within a row separated by a comma. The contents of the first row must be exactly as follows:

ID,ID Type,Symbol,Access Type,Monitor ID,Record Type

The corresponding data for each instrument must appear in the same order. Properly structured and if viewed in a text editor, your instruments file should appear much as follows, except that the individual data elements will be those that are appropriate to your list of instruments.

Using the Add, Edit, or Delete dialog boxes to manage instruments

As RocketSheet administrator you may also use dialog boxes accessible through the RocketSheet Instruments Manager window to manage instruments for which you will be publishing data.

Using the RocketSheet Instruments Manager window

Access the RocketSheet Instruments Manager window from RocketSheet MPF Gateway Manager by clicking the "Instruments" button at the bottom of the Gateway Manager window.

The Instruments Manager will report how many instruments you have configured for data publication and list each of those instruments, along with their corresponding data elements. You may sort the data by clicking the associated column heading.

To add a new instrument, click the "Add" button to see the "Add New Instrument" dialog box.

To edit or delete an instrument, first highlight the instrument you wish to edit or delete by clicking its corresponding row in Instruments Manager. Then choose the "Edit" or "Delete" button to launch the appropriate dialog box.

Using the "Add New Instrument" dialog box

To add a new instrument after you have launched the "Add New Instrument" dialog, simply complete the text entry fields for Instrument ID, Symbol, and Monitor ID and make the appropriate selections for ID Type, Record Type, and Access Type from the pop-up boxes provided. Click "Add" when you are satisfied with your selections. If you make a mistake, you may edit or even delete the newly-added instrument by highlighting it in the Instruments Manager window and then choosing from the "Edit" or "Delete" buttons as you prefer.

Using the "Edit Instrument" dialog box

To edit an instrument, first highlight the instrument you wish to edit by clicking its corresponding row in Instruments Manager window. Then choose the "Edit" button to launch the "Edit Instrument" dialog box. You may change the value of any field except for Instrument ID.

Using the "Delete Instrument" dialog box

To delete an instrument, first highlight the instrument you wish to delete by clicking its corresponding row in Instruments Manager window. Then choose the "Delete" button to launch the "Delete Instrument" dialog box. You may delete an instrument permanently or for the duration of a session only. A session is the period of time from the opening of the MPF Gateway to its closing. If you delete an instrument permanently in error, you may use the "Add New Instrument" dialog box to add it back to the instruments file or edit the file directly using a text editor or Excel.




  • Need help?
  • Customer service
  • 1 212 514 5780
  • Connect with us

Copyright © 2014 Ceylon LLC. All rights reserved.