In a new worksheet, select the Search Database
button to find the symbol for the index price
of Henry Hub Spot Gas. In the Search
Database window, select Energy>NaturalGas>HenryHub>PLATTS.
Select and expand the symbol IGBBL21 and double-click Index to add the symbol information to the
Worksheet.
Select the Configuration
button to return to the Configuration window.To add another series to the Worksheet, select the Add Row
button from the toolbar, or select Edit>Add Row from the menu bar.Select the Search Database
button to find the symbol for the index price
of Florida Gas Zone 1. In the Search
Database window, select Energy>Natural
Gas>FLGasTransmission>PLATTS. Select the symbol
IGBAW21 and double-click Index to add the symbol information to the
Worksheet.
Select the Configuration
button to return to the Configuration window.
The formula required to create the chart for this lesson is the one-month correlation of the series added in rows 'A' and 'B'. To add this formula, select the Add Row
button from the toolbar.In the Data Builder, select the Formula tab.
In the Formula field, enter
1 month correlation of A and B.
When entering formulas, you must enter a space between a symbol identifier and an operator.
Next, in the Description field, enter
Correlation.The formulas are included in the online help, accessible from the MIMIC application (select Help>MIMIC Help from the menu bar). See the "Formula Table" chapter in the MIMIC User Guide.
Before you display the chart, verify that the Change Period is set to 1 year.
From the menu bar, select View>Chart Options and verify that the chart is anchored North and the orientation is set to Vertical. To view a chart of the data, select the Chart
button from the toolbar.Upon selection, a chart will appear with the index price for Henry Hub Spot Gas, the index price for Florida Gas Zone 1 and the one-month correlation between both series.
Select the New
button to clear off the existing worksheet
and start the "Problem Solvers" section. Do not save the
Worksheet.