Optionstar EZ

SINGLE CALLS or PUTS

POSITION DATA
Stock Price
Stock Volatility
Option
Qty (no. contracts)
Expiration
Option Strike
Option Price

50.00
30%
1
6/20/2008
50.00
2.00

Intrinsic Value

Time Value

Option Value
Implied Volatility

2.00

#VALUE!
#VALUE!

POSITION SUMMARY
Total Cost
200
Max Profit
4,800
Max Loss
(200)
Breakeven Price
52.00
Probability of profit
#NUM!
Expected Return
#NUM!

Required Input Cells in Green

PROFIT & LOSS (at expiration) TABLE

16.7
33.3
50.0
66.7
83.3
100.0
(200)
(200)
(200)
(200) 1,467
3,133
4,800
-100% -100% -100% -100%
733% 1567% 2400%
#VALUE! ####### ####### ####### ####### ####### #######
PROFIT & LOSS GRAPH
PL at:
7/23/2013
Price interval:
6,000
5,000
4,000
3,000
2,000
1,000
0.0

16.7

33.3

50.0

66.7

83.3

100.0

(1,000)

COVERED CALLS
POSITION DATA
Stock Price
Stock Volatility
Qty (no. contracts)
Expiration
Call Strike
Call Price
Intrinsic Value
Time Value

Call Value
Implied Volatility

50.00
30%
1
6/20/2008
55.00
2.00
2.00

#VALUE!
#VALUE!

PROFIT & LOSS TABLE

16.7
33.3
(4,800) (3,133) (1,467)
-100%
-65%
-31%

66.7
700
15%

83.3
700
15%

100.0
700
15%

PROFIT & LOSS GRAPH

1,000
0.0
(1,000)
(2,000)

POSITION SUMMARY
Total cost
4,800
Max Profit
700
Max Loss
(4,800)
Breakeven Price
48.00
Probability of profit
#NUM!
Yield if assigned
15%
Yield at cur price
4%
Yld (ann) if assn
-3%
Yld (ann) at cur price
-1%

50.0
200
4%

(3,000)
(4,000)
(5,000)
(6,000)

16.7

33.3

50.0

66.7

83.3

100.0

BULL / BEAR SPREAD

POSITION DATA
Stock Price
Stock Volatility
Call or Put Spread
Qty (no. contracts)
Expiration
Option Strike
Option Price

PROFIT & LOSS (at expiration) TABLE

35.0
40.0
45.0
50.0
(400)
(400)
(400)
100

50
30%
call
Buy Option
1
6/20/2008
45
7

Sell Option
1
6/20/2008
50
3

PROFIT & LOSS GRAPH

Price Interval:

200
100

Intrinsic Value

5.00

Time Value

2.00

3.00

(100)

#VALUE!
#VALUE!
700
POSITION SUMMARY
Total Cost
400
Max Profit
100
Max Loss
(400)
Breakeven Price
49.00
Probability of profit
#NUM!
Expected Return
#NUM!

#VALUE!
#VALUE!
300

(200)

Option Value
Implied Volatility

55.0
100

35.0

40.0

45.0

50.0

55.0

(300)
(400)
(500)

STRADDLE
POSITION DATA
Stock Price
50
Stock Volatility
30%
Buy or Sell Spread sell
call option
Qty (no. contracts)
1
Expiration
6/20/2008
Option Strike
40
Option Price
11
Intrinsic Value

PROFIT & LOSS (at expiration) TABLE

25.0
33.3
41.7
50.0
(1,300)
(467)
200
200
put option
1
6/20/2008
60
11

10.00

10.00

1.00

1.00

#VALUE!
#VALUE!
1100
POSITION SUMMARY
Total Cost
(2,200)
Max Profit
200

#VALUE!
#VALUE!
1100

Time Value

Option Value
Implied Volatility

PROFIT & LOSS GRAPH

58.3
200

Price Interval:

400
200
(200)
(400)
(600)
(800)
(1,000)
(1,200)
(1,400)

25.0

33.3

41.7

50.0

58.3

(1,400)

Max Loss
Breakeven Price 1
Breakeven Price 2
Probability of profit
Expected Return

(3,800)
38
62
#NUM!
#NUM!

#NUM!
#NUM!

1
Buy or Sell
Call or Put

(200)

4,800

buy
call

prob

1a
3a

1
2
3
4

buy call
buy put
sell call
sell put

buy
buy
sell
sell

call
put
call
put

1
2
3
4

1 16.6667
16.67
1
12.50
2
8.33
3
5.00
4

#NUM!
1
(200)
(200)
(200)
(200)
1,467
3,133
4,800
3
4,800
3,133
1,467
(200)
(200)
(200)
(200)
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

TP cp, stk,strk, yrs, int, div,svol

IVH cp, stk,strk, yrs, int,div,prem
=C6*0.4*C7*SQRT((C10-NOW())/365)
=C13/(C6*0.4*SQRT((C10-NOW())/365))

prob
#NUM!

60.0
100

4
16.67 call
12.50 put
8.33
5.00

1
2
3
4

65.0
100

Price Interval:

bc

35.0
(700)

40.0
(700)

45.0
(700)

50.0
(200)

55.0
300

60.0
800

sc
bull sprd

300
(400)

300
(400)

300
(400)

300
100

(200)
100

(700)
100

300
(1,200)
(900)

(200)
(700)
(900)

(700)
(200)
(900)

(700)
300
(400)

(700)
300
(400)

(700)
300
(400)

25.0
(1,100)
2,400
1,300

33.3
(1,100)
1,567
467

41.7
(933)
733
(200)

50.0
(100)
(100)
(200)

58.3
733
(933)
(200)

66.7
1,567
(1,100)
467

5
bp
sp
bear sprd
60.0

65.0

1
2
3
4

66.7
75.0
(467) (1,300)
Price Interval:

66.7

8.3333

75.0

(3,800)

3
16.67
12.50
8.33
5.00

(3,800) bc
bp
straddle

1
7/23/2013
4/14/2012
1/5/2011
6/20/2008
0
(200)
4,800

100.00
4,800
(200)

1
2
3
4
5
6
7
8
9
10
11
12
13
14

65.0
1,300

100.0

(1,200)
100
(700)
300
(400)

75.0
2,400
(1,100)
1,300

0
(1,100)
4,900
3,800

100
4,900
(1,100)
3,800

Optionstar EZ

Required Input Cells in Green

CUSTOM SPREAD
POSITION DATA
Stock Price
POSITIONS:
Option
Qty (no. contracts)
Expiration
Option Strike
Option Price
Option Value
Intrinsic Value

200
(200)
200
200
200
200
50.00 Stock Volatility
1
2
3

(200)
200
30.0% interest rt
4
5

TOTAL

3
4
1
2
1
2
1
2
6/20/2008 6/20/2008 6/20/2008 6/20/2008
50.00
45.00
50.00
55.00
2.00
1.00
2.00
1.00
#VALUE! #VALUE! #VALUE! #VALUE!
-

2.00

1.00

2.00

1.00

Option Theoretical
Implied Volatility
TOTAL COST

#VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE!
200
(200)
200

#VALUE!
#VALUE!
(200)

GREEKS
Net Delta (stk prc)
gamma (delta)
theta (time to exp)
vega (volatility)
rho (interest)

change in option value due to change in one unit of

Time Value

2.5%
6

TOTAL

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

SUM
PROFIT & LOSS (at expiration) TABLE
21.43
28.57
35.71
42.86
(1,857)

(1,143)

PL at

(429)

286

50.00

57.14

286

64.29
(429)

Price Interval

7/23/2013

71.43
(1,143)

7.14286

500

78.57
(1,857)

1 bc
2
3
4
5
6

sc
bp
sp
bu
su
1

21.4

28.6

35.7

42.9

50.0

57.1

64.3

71.4

78.6

1
2
3
4
5
6

(500)
(1,000)
(1,500)

bc
sc
bp
sp
bu
su
2

(2,000)

POSITION SUMMARY at Expiration

Total Cost
Total Delta
#VALUE!

Max Profit
Max Loss

286
(4,000)

1
2
3
4
5
6

bc
sc
bp
sp
bu
su
3

1
2
3
4
5
6

bc
sc
bp
sp
bu
su
4

1
2
3
4
5
6

bc
sc
bp
sp
bu
su
5

1
2
3
4

bc
sc
bp
sp

5 bu
6 su
6

(1,857)

(1,143)

(429)

286

21.43
(200)

28.57
(200)

35.71
(200)

42.86
(200)

50.00
(200)

200
2,657
(2,657)
(2,857)
2,857
2,657

200
200
1,943
1,229
(1,943) (1,229)
(2,143) (1,429)
2,143
1,429
1,943
1,229

200
514
(514)
(714)
714
514

200
(200)
200
(200)

(200)
200
4,514
(4,514)
(5,714)
5,714
(4,514)

(1,143)

(1,857)

64.29
1,229

71.43
1,943

78.57
2,657

(514)
(200)
200
714
(714)
(200)

(1,229)
(200)
200
1,429
(1,429)
(200)

(1,943)
(200)
200
2,143
(2,143)
(200)

(2,657)
(200)
200
2,857
(2,857)
(200)

200
4,800
(4,800)
(5,000)
5,000
4,800

(4,800)
(200)
200
5,000
(5,000)
(200)

(200)
(200)
(200)
200
200
200
3,086
1,657
229
(3,086) (1,657)
(229)
(4,286) (2,857) (1,429)
4,286
2,857
1,429
(3,086) (1,657)
(229)

800 2,229
(800) (2,229)
(200)
(200)
200
200
1,429
(1,429)
200
200

3,657
(3,657)
(200)
200
2,857
(2,857)
200

5,086
(5,086)
(200)
200
4,286
(4,286)
200

6,514
(6,514)
(200)
200
5,714
(5,714)
200

(200)
200
8,800
(8,800)
######
10,000
(8,800)

10,800
######
(200)
200
10,000
######
200

(200)
200
2,657
(2,657)
(2,857)
2,857
(200)

(200)
(200)
200
200
1,943
1,229
(1,943) (1,229)
(2,143) (1,429)
2,143
1,429
(200)
(200)

(200)
200
(200)
200
(200)

514
(514)
(200)
200
714
(714)
514

1,229
(1,229)
(200)
200
1,429
(1,429)
1,229

1,943
(1,943)
(200)
200
2,143
(2,143)
1,943

2,657
(2,657)
(200)
200
2,857
(2,857)
2,657

(200)
200
4,800
(4,800)
(5,000)
5,000
(200)

4,800
(4,800)
(200)
200
5,000
(5,000)
4,800

(200)
200
6,514
(6,514)
(5,714)
5,714
200

(200)
(200)
(200)
200
200
200
5,086
3,657
2,229
(5,086) (3,657) (2,229)
(4,286) (2,857) (1,429)
4,286
2,857
1,429
200
200
200

(200)
229
200
(229)
800
(200)
(800)
200
1,429
(1,429)
200
(229)

1,657
(1,657)
(200)
200
2,857
(2,857)
(1,657)

3,086
(3,086)
(200)
200
4,286
(4,286)
(3,086)

4,514
(4,514)
(200)
200
5,714
(5,714)
(4,514)

(200)
200
10,800
######
######
10,000
200

8,800
(8,800)
(200)
200
10,000
######
(8,800)

(200)
200
514
(514)
(714)
714
(200)

286
57.14
514

(429)

(4,000)
(200)

(4,000)
100.00
4,800

(1,857)

(1,143)

(429)

286

21.43
(200)

28.57
(200)

35.71
(200)

42.86
(200)

50.00
(200)

200
2,657
(2,657)
(2,857)
2,857
2,657

200
1,943
(1,943)
(2,143)
2,143
1,943

200
1,229
(1,229)
(1,429)
1,429
1,229

200
514
(514)
(714)
714
514

200
(200)
200
(200)

(200)
200
4,514
(4,514)
(5,714)
5,714
(4,514)

(200)
200
3,086
(3,086)
(4,286)
4,286
(3,086)

(200)
200
1,657
(1,657)
(2,857)
2,857
(1,657)

(200)
200
229
(229)
(1,429)
1,429
(229)

(200)
200
2,657
(2,657)
(2,857)
2,857
(200)

(200)
200
1,943
(1,943)
(2,143)
2,143
(200)

(200)
200
1,229
(1,229)
(1,429)
1,429
(200)

(200)
200
6,514
(6,514)
(5,714)
5,714
200

(200)
200
5,086
(5,086)
(4,286)
4,286
200

286

(1,143)

(1,857)

64.29
1,229

71.43
1,943

78.57
2,657

(514)
(200)
200
714
(714)
(200)

(1,229)
(200)
200
1,429
(1,429)
(200)

(1,943)
(200)
200
2,143
(2,143)
(200)

(2,657)
(200)
200
2,857
(2,857)
(200)

800
(800)
(200)
200
200

2,229
(2,229)
(200)
200
1,429
(1,429)
200

3,657
(3,657)
(200)
200
2,857
(2,857)
200

5,086
(5,086)
(200)
200
4,286
(4,286)
200

6,514
(6,514)
(200)
200
5,714
(5,714)
200

(200)
200
514
(514)
(714)
714
(200)

(200)
200
(200)
200
(200)

514
(514)
(200)
200
714
(714)
514

1,229
(1,229)
(200)
200
1,429
(1,429)
1,229

1,943
(1,943)
(200)
200
2,143
(2,143)
1,943

2,657
(2,657)
(200)
200
2,857
(2,857)
2,657

(200)
200
3,657
(3,657)
(2,857)
2,857
200

(200)
200
2,229
(2,229)
(1,429)
1,429
200

(200)
200
800
(800)
200

229
(229)
(200)
200
1,429
(1,429)
(229)

1,657
(1,657)
(200)
200
2,857
(2,857)
(1,657)

3,086
(3,086)
(200)
200
4,286
(4,286)
(3,086)

4,514
(4,514)
(200)
200
5,714
(5,714)
(4,514)

57.14
514

(429)

1
2
3
4
5
6
7
1
buy Call
sell Call
buy Put
sell Put
buy Stk
sell Stk

3 7.142857
1
12.50
1 7/23/2013
10.00
2 4/14/2012
7.14
3 1/5/2011
5.00
4 6/20/2008
3.33
2.50
1.25