MIMIC Training Guide

Table of Contents

Introduction
Goal of this Class
Installation Instructions
Documentation
Overview of the Software
Overview of the Database
Pre-Calculated Continuation Series
Getting Started with MIMIC
Synopsis
Objectives
How Does MIMIC Work?
Overview of the MIMIC Menu Bar
File Menu
Edit Menu
View Menu
Options Menu
Tools Menu
Help Menu
Overview of the MIMIC Toolbar
Overview of the Worksheet Toolbar
Overview of Searching in MIMIC
Tree View
Search
Basic Price Charts and Tables
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Bringing Table Data into Excel
Problem Solvers
Chart Controls
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Using Chart Controls
Problem Solvers
Setting Time Periods & Using Base-Line Analysis
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Changing the Date Settings
Problem Solvers
Adding Contracts
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Adding the Contracts
Problem Solvers
Basic Seasonal Analysis
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Selecting Seasonal Analysis
Adding the Dates
Problem Solvers
Analyze Crack-Spreads
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Axis Config
Defining the Formula
Changing the Date Settings
Editing the Worksheet
Problem Solvers
Basic Statistical Analysis
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Defining the Formula
Date Settings
Problem Solvers
Using Weekly or Yearly Prices
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Changing the Date Settings
Problem Solvers
Charting Forward Curves
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Plotting the Forward Curves
Forward Curve Limitations
Problem Solvers
Intraday Price Charts
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Changing the Date Settings
Problem Solvers
Using Backward-Adjusted Prices
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Defining the Series
Changing the Rollover Policy
Changing the Date Settings
Comparing the Unadjusted Series and Adjusted Series
Problem Solvers
Using MIMICExcel
Synopsis
Objectives
Market Brief
Problem
Step-by-Step Solution
Creating an Embedded Query in MIMICExcel
Narrowing the Date Range using Advanced Refresh
Using the Query Manager in MIMICExcel
Exporting an Embedded Query
Problem Solvers
Curve Matrix Tool
Synopsis
Objectives
Overview
Problem
Step-by-Step Solution
Creating a Curve Matrix
Problem Solvers
Problem Solver Answers
Problem Solver, Chapter 3: Basic Price Charts and Tables
Questions
Answers
Problem Solver, Chapter 4: Using Chart Controls
Questions
Answers
Problem Solver, Chapter 5: Setting Time Periods & Using Base-Line Analysis
Questions
Answers
Problem Solver, Chapter 6: Adding Contracts
Questions
Answers
Problem Solver, Chapter 7: Basic Seasonal Analysis
Questions
Answers
Problem Solver, Chapter 8: Analyze Crack-Spreads
Questions
Answers
Problem Solver, Chapter 9: Basis Statistical Analysis
Questions
Answers
Problem Solver, Chapter 10: Using Weekly or Yearly Prices
Questions
Answers
Problem Solver, Chapter 11: Charting Forward Curves
Questions
Answers
Problem Solver, Chapter 12: Intraday Price Charts
Question
Answer
Problem Solver, Chapter 13: Using Backward-Adjusted Prices
Questions
Answers
Problem Solver, Chapter 15: Using MIMICExcel
Questions
Answers
Problem Solver, Chapter 16: Curve Matrix Tool
Question
Answer
Index