Switch To
Product Links
Languages
Themes
Feedback
Sign Up Now
VBA Editor
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
Name of the Document:
Note:-
- Supported file formats: xls, xlsx, sxc, ods, csv and tsv
- Only unprotected files will be imported
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
hull.10.15
by
btzoho
217 views
Print
Export
Copy to My Account
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS P Gothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
Contant Inputs (For Modeling purposes, Stock Price is Constant for all Strategies, but Strike Price Varies)
Stock
20
Volatility
20%
Riskless rate
4%
Future Stock Price
Stock
Price
Long
$15
$16
$17
$18
$19
$20
$21
$22
$23
$24
$25
20
1
-5
-4
-3
-2
-1
0
1
2
3
4
5
Strike
Call
Long
Time
Option Payoff (Gross of Premium)
First option
20.82
1
1
1
0
0
0
0
0
0
0.18
1.18
2.18
3.18
4.18
Strike
Put
Short
Time
Option Payoff (Gross of Premium)
Second option
20.82
0
0
1
-5.82
-4.82
-3.82
-2.82
-1.82
-0.82
0
0
0
0
0
Option Premiums (calculated below)
Net Option Payoffs
First
($1.59)
($1.59)
($1.59)
($1.59)
($1.59)
($1.59)
($1.59)
($1.41)
($0.41)
$0.59
$1.59
$2.59
Second
$1.59
($4.22)
($3.22)
($2.22)
($1.22)
($0.22)
$0.78
$1.59
$1.59
$1.59
$1.59
$1.59
Trading Strategies
Long Call
($1.59)
($1.59)
($1.59)
($1.59)
($1.59)
($1.59)
($1.41)
($0.41)
$0.59
$1.59
$2.59
Long Put
($4.22)
($3.22)
($2.22)
($1.22)
($0.22)
$0.78
$1.59
$1.59
$1.59
$1.59
$1.59
Strategy Payoff
($5.82)
($4.82)
($3.82)
($2.82)
($1.82)
($0.82)
$0.18
$1.18
$2.18
$3.18
$4.18
Second
d1
0.10
d2
(0.10)
call (c)
$1.59
put (p)
$1.59
Third
d1
0.10
d2
(0.10)
call (c)
$1.59
put (p)
$1.59
syntheticForward
synthetic_Call
synthetic_Put
0 Viewing
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Processing...
Assign Macro
Change Macro
View Code
Edit Label
More