MIMIC User Guide

Table of Contents

Introduction
Installation
Java Compatability
MIMIC Research Capabilities
MIMIC Configuration Window
MIMIC Toolbar
Worksheet Toolbar
Favorites
The Worksheet
Worksheet Shortcuts
Copy/Paste Options, Right-Click Menu and Repositioning Rows
Synchronization of Columns and Time Units
Data Builder
Menu Options
File Menu
Edit Menu
View Menu
Options Menu
Tools Menu
Help Menu
Series Tab – Data Builder
Custom Contract/Edit Rollover
Setting Custom Contract / Edit Rollover Options
Presets
Rollover Date
Date Offset
Expiration
Prices
Modify Prices
Edit Chart Stats
Formula Tab – Data Builder
Curve Tab – Data Builder
Forward Curve Tab – Data Builder
Forward Curve Parameters
Date, Table and Worksheet Options – Data Builder
Seasonal Analysis
Seasons Tab
Averages Tab
Missing Data NaNs
Execution Units
Axis Config
Scale Tab
User Preferences
General Tab
Table Tab
Printing Tab
Desktop/Excel Tab
Charting Tab
Shortcuts
Search
Searching in MIMIC
MIM Hierarchy
Search
Searching by Symbol
Searching by Description
Search Options
Shortcuts
Charts
Chart Options
Unify the Chart Type
Control Chart Y-axis
Chart Notes
Chart Configuration
Positioning Mouse Pick Lines
Printing Charts
Tables
Table Options Pane
Table Summary Statistics
Sorting Table Data
Show Dates as Columns
Table Results
More than a 100 Results
MIMICExcel
MIMIC vs. MIMICExcel
Toolbars for MIMICExcel
MIMICExcel Add-in Toolbar
MIMICExcel Toolbar
Queries in MIMICExcel
Embedding a Query
Query Manager
Refreshing MIMICExcel Queries
Advanced Refresh Options
LLC Worksheets
MIMICExcel Functions - Overview
MIMIC Category
GetMIMPath
Excel Documentation
Usage Examples
GetMIMDescription
Excel Documentation
GetMIMDataPoint
Excel Documentation
Arguments
Usage Examples
GetMIMConvPoint
Excel Documentation
Arguments
Examples
GetMIMLastDate
Excel Documentation
Arguments
Examples
GetMIMLastValue
Excel Documentation
Arguments
Examples
GetMIMExpDate
Excel Documentation
Arguments
Examples
GetMIMExpValue
Excel Documentation
Arguments
Examples
Tips and Tricks with MIMIC Excel Functions
AutoCalc
Currencies and Units of Measure
Intraday Frequencies and Hour 0:00
Formulas
Overview
Formulas
% Move or Move
Absolute Value
AccDist
Adjust Contract
Aspect
AspectEquatorial
AspectHelio
AspectPlot
Average
BackContract
BlackScholesOptionPrice
Bollinger High/Bollinger Low
BollingerBandHighSDP/BollingerBandLowSDP
ChannelIndex
ChoppinessIndex
Compound_return
Construct Date
Coregression
Coregression_intercept
Coregression_slope
Correlation
Count
Covariance
DeferredContract
DeMarker
DirMove
DirMoveIdx
Dividend Adjusted Return
Ease of Move
Energy
Exponential Average
Extract Day
Extract Month
Extract Year
FarContract
FrontContract
Greatest Integer
Highest
HistVolLog
HistVolPct
If-Then Statement
Inverse Log
Linear Regression
Lowest
Macd_osc
Macd_signal
Median
Midpoint or Mid_point
MoneyFlowIndex
Move
Natural Log
Nearest Integer
Negative Value
NegVolIndex
Net Change
Net Percent Change
NetHedgers
NetHedgersPct
NetLargeSpecs
NetLargeSpecsPct
NetSmallTraders
NetSmallTradersPct
NormalDist
On Balance Volume
Periods in Range
PlotAspectX
Positive Value
Product
Range
RangeExpIndex
RealSum
Rel Strength
Select Contract
Simple_rsi
Smallest Integer
Standard Deviation
Standard Deviation Population
Stochastics
Sum
Trendline
True Midpoint
True Range
Variance
Volatility
VolatilityIdx
VolPriceTrend
VolumeAccum
Wilders_rsi
WildersADX
WildersADXR
WildersDIMinus
WildersDIPlus
WildersDX
WildersRSI
Williamsr
WilliamsVolAD
ZeroFill
Index