Enter relation data on any row of the spreadsheet. On the next row enter the column data. The following row is reserved for the date fields in the first two columns and the time fields in the next two columns. The data in the spreadsheet must be aligned in a contiguous manner so that all the data will be selected.
After entering the data in the spreadsheet you will select the cell containing the first relation name entry and then you will select Get Records from the menu bar. All the data entered will automatically populate the corresponding fields in the display box.
The following outlines this process in detail:
Enter the symbol names in the first row. Type NG in cell A:1, CL in cell B:1 and HU in cell C:1.
Next, enter the column data. Type Close in cell A:2, Open in cell B:2 and Volume in cell C:2.
On the next row, enter the date and time information. For Date From enter 1/1/2001 in cell A:3, for Date To enter 2/1/2001 in cell B:3. On the same row enter the time fields. For Time From enter 10:00 am in cell C:3, for Time To enter 1:00 pm in cell D:3.
Select cell A:1 then select Get Records from the MIM menu.
The fields will automatically populate the Fetch Historical Data from XMIM Server box. For Source Ranges, cells A:1 to C:1 will display for the Relation Name cells. Cells A:2 to C:2 will display for the Column Name cells.
For Destination Range, the data will populate in cells A:4 to I:4. Keep the -1 value in the Num rows box if you want all the data rows to display. If you want only a certain number of rows to display type in a specific number.
For the Reshaping field, select a Units option: Years, Quarters, Months, Weeks, Days, Hours or Minutes. Since we are dealing with intra-day data, select Hours. Enter a value for Number of Units. All the values will display with the default setting of 1.
In the Options field, set the decimal place. The default is 5.
The Date Range field will automatically populate with a date range from cell A:3. The date range fields are optional. If a Date Range is not entered, all the dates for the symbol will be queried. The Date Range must be entered in the following format: mm/dd/yyyy.
Since we entered time ranges in the spreadsheet in cells C:3 and D:3 these cells automatically populate the time range fields in the display box. The Time Range field is optional. The Time Range is in the format: hh:mm am/pm. Keep in mind that when entering a time range, Hours or Minutes must be selected in the Units box in the Reshaping section.
Select a Fill Option from the pull-down menu. A default NaN is filled if there is no data point available for a given date. Use the pull-down menu to have the data filled in other ways (e.g. Filled Forward or Backward, Linear, Geometric or Logarithmic interpolated values). For this example, select Skip all-NaN records. All the NaN values will not display.
Select OK to run the query.
The following shows the results for the Get Records query. Columns labeled 1, 2, 3 are the Close, Open and Volume for NG. The next three columns are the Close, Open and Volume for CL. The last three columns are the Close, Open and Volume for HU.
This completes the Get Records lesson. Next, see how to use the Show When function.