FTS Trader Support Spreadsheets
Overview
In an FTS Interactive Market, students trade
with each other and learn by doing. What they trade depends on the “trading
case” you choose; we offer over thirty cases, and you can easily create your
own cases as many instructors have done.
What they learn is not only
the mechanics of how financial markets work, but most importantly, how to apply
concepts of valuation, diversification, hedging, and risk management in a real
time competitive environment. You choose
the subset of cases that are most relevant to your course.
This page contains links to Excel Spreadsheets used as
trader support for specific FTS Cases. The spreadsheet links are provided below
but first check your Excel settings:
Important Checklist for Excel Settings:
a. Macro security should be set to Medium and enable
macros when prompted to do so. To set to Medium in Excel click on Tools, Macros,
Security, then check Medium in Security Level. Next load in the support spread
sheet and do not forget to Enable the Macro when prompted to do so otherwise
it cannot work.
b. Set Excel to Auto Recalculate as follows. In Excel
click on Tools, Options, Calculation and click beside Automatic. Now your
spreadsheet support will automatically update when market prices change.
Alternatively, you can always manually recalculate a spreadsheet by clicking
beside Manual instead of Automatic and using the Function 9 key. Automatic
calculation is recommended.
The available spreadsheets are listed below (click on the
hyperlink XR1 Trader Support, ST1 Trader Support etc.,):
i. Spreadsheet Support for XR1
Office 2003 Support:
XR1 Support
(Real time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
Office 2007 Support:
XR1 Support
(Real time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
XR1 Trader Support provides real time updating of the
option "Greeks" (Delta, Gamma and Vega) as well as your position Delta, Gamma,
and Vega that is required to trade this case.
You can also read trading notes for this case by clicking
on
XR1Notes.
ii. Spreadsheet Support for XR2
Office 2003 Support:
XR2 Support
(Real time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
Office 2007 Support:
XR2 Support
(Real time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
iii. Spreadsheet Support for ST1
Office 2003 Support:
ST1 Support
(Real time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
Office 2007 Support:
ST1 Support
(Real time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
ST1 Trader Support provides real time updating of the
option "Greeks" (Delta, Gamma and Vega) as well as your position Delta, Gamma,
and Vega that is required to trade this case.
iv. Spreadsheet Support for ST2
Office 2003 Support:
ST2 Support
(Real time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
Office 2007 Support:
ST2 Support
(Real time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
ST2 Trader Support provides real time updating of the
option "Greeks" (Delta, Gamma and Vega) as well as your position Delta, Gamma,
and Vega that is required to trade this case.
Other Available Spreadsheets
The available spreadsheets are listed below:
v. Spreadsheet Support for GC1
Office 2003 Support:
GC1 Support (Real
time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
Office 2007 Support:
GC1 Support (Real
time updating of the option "greeks" (Delta, Gamma and Vega etc.,)
vi. Spreadsheet Support for GC2
Office 2003 Support:
GC2 Support
Office 2007 Support:
GC2 Support