I need an excel calculator built.
The input should be....
Stock Current Price
Price Of Option
The result should look like the image below in a formatting type.
I need it to run EXACTLY the way this runs [login to view URL]
Need this done fast, preferably in a few hours.
I know nothing about how to get to the results, if I did, I would be able to do this myself, thus, you MUST know about options and how to calculate it's profits or losses.
To be accepted, you MUST answer the following question, you WILL NOT be accepted if you don't answer this.
If I bought a contract of AAPL (call) with a price of $1.67 per contract and a expiry date of 1/29 with a strike of $148. How much would the profit be if $144.75 on 1/23.