Overview of the MIMIC Menu Bar

File Menu

The File menu includes the following options:

Option	Function
New (Ctrl+N)	Opens a new worksheet.
Open (Ctrl+O)	Opens an existing worksheet.
Save (Ctrl+S)	Saves a worksheet.
Save As	Saves an existing worksheet with a new name.
Import Symbols	Imports symbols from the following type files: .llc, .csv or .txt. Files of type .csv and .txt must be in the format: SYMBOL,[COLUMN] where COLUMN is optional. If the column is omitted, then the default column for the symbol is used.
Export Symbols	Exports all symbols and columns contained within a worksheet to a file with the format SYMBOL,COLUMN. The file may be saved as a .txt or .csv file.
XML Converter	Use Save Current Worksheet as XML to save current MIMIC worksheets in XML format (.xml). Users can also convert existing MIMIC worksheets (.llc files) to XML using the Convert Existing Sheets option.
Print (Ctrl+P)	Prints a chart or table.
Exit	Exits the MIMIC application.

Edit Menu

The Edit menu includes the following options:

Option	Function
Cut/Copy/Paste	Use the Copy command to copy charts and table data into other applications.
Add Row (Alt+A)	Adds a new row to the bottom of the Worksheet.
Insert Row (Alt+I)	Adds a new row above the selected row.
Remove Row (Alt+R)	Removes a row from the Worksheet.

View Menu

The View menu includes the following options:

Option	Function
Chart Options	Grid - Displays gridlines on a chart. Symbols - Displays the symbol. This helps when printing charts in black and white, so users can distinguish between symbols. Controls - Displays the chart controls at the bottom of the Chart window. Controls include Trendlines, Mouse Pick, and Zoom. Legend - Displays the legend. Legend Anchor - Enables the legend anchor. Options include North, East, South and West. Legend Orientation - Enables the legend orientation. Options include Vertical and Horizontal.
Configuration (Ctrl+G)	Returns users to the Configuration window.
Chart (Ctrl+R)	Displays the Worksheet data in a chart.
Table (Ctrl+T)	Displays the Worksheet data in a table format.
Query (Ctrl+Q)	Displays the XMIM query language.

Options Menu

The Options menu includes the following items:

Option	Function
Color Print	When checked, uses the colors defined in the Chart Configuration option (Options>Chart Configuration).
Mixed Case Symbols	Allows the user to type in lowercase and have the letters appear uppercase in the Symbol field. This is convenient when entering symbols into the MIM Symbol field as symbols must be entered in uppercase.
Connection Manager	Define the host, port number and description for each connection. Multiple connections can be added. A restart of the application is not necessary when changing server connections.
User Preferences	See the following section.
Chart Configuration	Change the color, line thickness and symbol options for charts for printing and on-line viewing.
Axis Front	Change the font type for the chart axis display.

User Preferences

The following outlines each tab under the User Preferences menu option:

For some changes to take effect, you must either restart the program or create a new worksheet.

General Tab

The following options are available when the General tab is selected on the User Preferences window:

Option	Function
Date format	Use the pull-down to change the order of the date display.
Include Average of yearly data	Includes the average of yearly data in a chart.
Lock Units of Measure by default	Converts the unit of measure for a symbol to the same unit of measure as a previously entered symbol when conversion factors are available.
Always force 7 day trading pattern	Always use a seven-day trading pattern versus a five-day pattern.
Use Stream Semantics	This is a future enhancement to accommodate display of millisecond data.
Save Graphics as	Saves graphics as BMP, PNG or JPG.
Round Mode	The round mode determines how MIMIC will treat rounding when the user selects a precision for the series that is less than the number of decimals in the value returned (e.g. precision selected is 2 decimals, the number is 3 or more decimals). In such cases, the user can now specify the rounding technique used by choosing between 3 alternatives: Half Even (the default) - Rounds any trailing 5 up or down to the nearest even number (e.g. if the decimal precision is two decimals and the number to be rounded is 2.345, the calculation rounds down to the nearest even value at 2.34, whereas if the number to be rounded is 2.355, the calculation rounds up to the nearest even value at 2.36.) Half Up - Always rounds the trailing 5 up. Half Down - Always rounds the trailing 5 down.

Table Tab

The Table tab on the User Preferences window includes the following options:

Option

Function

Warn if table data includes zero or NaN values

Displays a warning if there is null or no data values for a date.

Remove data in table if row has a zero or NaN values

Removes null or no data, if it exists.

Show summary stats

Selected by default. Includes summary statistics, such as the sum, averages, percentages, and the standard deviation.

Skip weekends

Excludes weekend data (data for a Saturday or a Sunday).

This feature can only be selected when using the following Execution Units in the Worksheet Options pane: Days, Hours, Minutes, Seconds and Milliseconds.

Sort by: Date Ascending

Sorts the table data by the oldest date first.

Sort by: Date Descending

Sorts the table data by the most recent date first.

Printing Tab

The Printing tab allows users to select the page orientation for printing tables.

Option	Function
Orientation	This option allows you to select the page orientation for printing tables. Options include Landscape and Portrait (default). These options are for table printing only.

Desktop/Excel Tab

The following options are available when the Desktop/Excel tab is selected on the User Preferences window:

Option	Function
Copy table results to clipboard	Copies the table results to the clipboard, so you can use them in another application.
Send New Worksheet and Paste command to Excel	Creates a new worksheet in Excel and pastes the results of a MIMIC table.
Send Paste command to Excel	Pastes the results of a table into an open Excel worksheet.

Excel must be running with a workbook open to receive the data from the application.

Charting Tab

The following options are available when the Charting tab is selected on the User Preferences window:

Option	Function
Use description as chart label	The description entered for a symbol is used as the chart label.
Show Grids	Places a grid line behind the chart.
Show Chart Controls	Turns on the chart controls at the bottom of a chart. Sets trendlines and zoom. Use the Mouse Pick feature to display the symbol data on a specific date, as well as delta and percent change data.
Show Chart Symbol	The lines in a chart are given a unique symbol. This setting helps when printing charts in black and white so the user can distinguish between symbols.
Show Legend	Display the legend stacked vertically or spread out horizontally. Use the Legend Anchorsettings to position the legend in the North, East, South or West quadrant of the chart.

These settings will be used for new worksheets. To modify only the active worksheet use the View>Chart Options menu.

Tools Menu

The Tools menu includes the following options:

Option	Function
Curve Matrix	When a futures symbol is entered into a worksheet, the Curve Matrix menu option becomes accessible. Use this feature to create a .csv file (opens in Excel) showing the futures contracts by value or contract name for a specified date range.
Convert Worksheets	Use this feature to convert Excel worksheets into MIMIC worksheets. This feature is only available when MIMIC is run from Excel.

Help Menu

The Help menu includes the following options:

Option	Function
About MIMIC	Displays MIMIC release and copyright information.
Console (Ctrl+space)	Displays communication between MIMIC and the MIM server in a Java console window. Used for troubleshooting purposes.
MIMIC Help	Opens the MIMIC Help system.

Prev	Up	Next
How Does MIMIC Work?	Home	Overview of the MIMIC Toolbar