Before you begin creating scripts, it is a recommended to layout how the data is going to appear in the MIM. Decide how many categories, symbols and columns are needed and how they will be structured. It is necessary to follow the exact naming conventions outlined in the section called “Futures Type Data Naming Conventions” below.

For this example we are going to add some futures data for the company Widgets Inc. We need to create the category Other then the category WidgetsInc to house all Widgets Inc. specific data so that it is easy for users to find. Under that we will add the WID_Forwards category to house all forwards data. Under that we will add the WID_Electricity category to house all electricity data. Then we will create two symbols, WID.NYISOE.ONPEAK and WID.NYISOE.OFFPEAK to reside in the WID_Electricity category. We will also need to create a column for these symbols named Close.

Our hierarchy should look like this:

     TopRelation:Other:WidgetsInc:WID_Forwards:WID_Electricity (category)
                                  WID.NYISOE.ONPEAK (symbol)    Close (column)
                                  WID.NYISOE.OFFPEAK (symbol)    Close (column)

For more information on data naming conventions, refer to Database and Data Guidelines.