I need an excel calculator built.
The input should be....
Stock Current Price
Strike price
Expiry Date
Price Of Option
Call/Put
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.
I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
Thanks
Pooja