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.
Your instruments file will contain six records for each instrument, organized and sourced as follows.
If you need assistance determining how best to populate the fields for each of your instruments, please contact Ceylon Support or Bloomberg.
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.
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.
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.
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.
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.
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.
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.
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.