MIMIC User Guide

Table of Contents

Introduction
Installation
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 Options 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
Searching in MIMIC
Searching Methods
Searching by Symbol
Adding Result(s) to the Worksheet
Mapping a Result in the Tree View
Tree View Refresh
Searching by Description
Narrowing a Search
Search Options
Charts
Chart Options
Unify the Chart Type
Control Chart Y-axis
Chart Notes
Chart Configuration
Positioning Mouse Pick Lines
Printing Charts
Tables
Table Options in the Worksheet Options Pane
Table Results
More than a 100 Results
Show Dates as Columns
Sorting Table Data
Table Summary Statistics
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
Formula Table
Overview
Formulas for Built-ins
% Move or Move
Absolute Value
Adjust Contract
Average
Bollinger High/Bollinger Low
Compound_return
Construct Date
Coregression
Coregression_intercept
Coregression_slope
Correlation
Count
Covariance
Dividend Adjusted Return
Ease of Move
Exponential Average
Extract Day
Extract Month
Extract Year
Greatest Integer
Highest
If-Then Statement
Inverse Log
Linear Regression
Lowest
Macd_osc
Macd_signal
Median
Midpoint or Mid_point
Move
Natural Log
Nearest Integer
Negative Value
Net Change
Net Percent Change
On Balance Volume
Periods in Range
Positive Value
Product
Range
Rel Strength
Select Contract
Simple_rsi
Smallest Integer
Standard Deviation
Standard Deviation Population
Sum
True Midpoint
True Range
Variance
Wilders_rsi
Williamsr
Formulas for Server Macros
_CoolingDegreeDays
_HeatingDegreeDays
_OffPeakAverage
_OnPeakAverage
_2x8Average
_2x16Average
_5x8Average
_5x16Average
_7x8Average
_7x16Average
AccDist
Aspect
AspectEquatorial
AspectHelio
AspectPlot
PlotAspectX
BackContract
BlackScholesOptionPrice
ChannelIndex
ChoppinessIndex
DeMarker
DeferredContract
DirMove
DirMoveIdx
FarContract
FrontContract
HistVolLog
HistVolPct
MoneyFlowIndex
NegVolIndex
NetHedgers
NetHedgersPct
NetLargeSpecs
NetLargeSpecsPct
NetSmallTraders
NetSmallTradersPct
NormalDist
RangeExpIndex
RealSum
Stochastics
Trendline
VolPriceTrend
Volatility
VolatilityIdx
WildersADX
WildersADXR
WildersDIMinus
WildersDIPlus
WildersDX
WildersRSI
WilliamsVolAD
Index