Investment Stocks

May 2019
1
0
Australia
StockContractCostShare Price50% DropExercise PriceFeesReturn-Per-sharetimes_By_Contract
AGLPut(100) Shares$155$21.73$10.86$21.00$40/100$10.14 $ 1,014.00
BHPPut(100) Shares$234$37.45$18.75$36.00$40/100$17.25$ 1,725.00
CSLPut(100) Shares$1535$206.42$103.21$202.00$40/100$98.79$ 9,879.00

I would like to work out a formula on which contract would profit the most.

If I had $1000 and I bought:

6 contracts of AGL 6*155=930
or
4 contracts of BHP 4*234=936
or
1 contract of CSL "unable to buy unless I have extra funds but included"

I have a Google sheet with 80 Option stocks, as above, each Exercise price is at a different price, the fees are the same for each contract, and the contract contains 100 stocks

The strike price is the Exercise Price + Fees to break even. Each dollar the price goes down from there you collect for each share in the contract(100)

For example: Break Even Price is $10
The Share price is $5 - PUTS pay on falling prices
1 contract = 100 shares times by $5 = $500

Hope you can help - thank you
 
Feb 2015
2,255
510
Ottawa Ontario
StockContractCostShare Price50% DropExercise PriceFeesReturn-Per-sharetimes_By_Contract
AGLPut(100) Shares$155$21.73$10.86$21.00$40/100$10.14 $ 1,014.00
BHPPut(100) Shares$234$37.45$18.75$36.00$40/100$17.25$ 1,725.00
CSLPut(100) Shares$1535$206.42$103.21$202.00$40/100$98.79$ 9,879.00
I would like to work out a formula on which contract would profit the most.
If I had 1000 and I bought:
6 contracts of AGL 6*155=930
or
4 contracts of BHP 4*234=936
or
1 contract of CSL "unable to buy unless I have extra funds but included".

I have a Google sheet with 80 Option stocks, as above, each Exercise price is at a different price,
the fees are the same for each contract, and the contract contains 100 stocks.

The strike price is the Exercise Price + Fees to break even.
Each dollar the price goes down from there you collect for each share in the contract(100).

For example: Break Even Price is 10
The Share price is 5 - PUTS pay on falling prices
1 contract = 100 shares times by 5 = 500
Making it "readable"!!