Question: How do i plot graph of historical volatility with 1 year implied volatility using given data as below? Stock Price of CALL DELTA CALL PRICE

How do i plot graph of historical volatility with 1 year implied volatility using given data as below?

Stock Price of CALL DELTA CALL PRICE (AUD) PUT DELTA PUT PRICE (AUD) Strike (X) 35 Expiration date: 15/07/2021 Strike (X) 35 Expiration date: 15/07/2021 26/02/21 31.73 0.24849 0.63 0.75558 4.235 01/03/21 31.85 0.25247 0.635 -0.75045 4.125 02/03/21 31.76 0.24471 0.605 -0.75834 4.185 03/03/21 31.83 0.2474 0.61 -0.75472 4.125 04/03/21 31.42 0.22216 0.53 -0.78123 4.45 05/03/21 31.32 0.21587 0.51 -0.78653 4.535 08/03/21 31.03 0.19474 0.44 -0.80674 4.76 09/03/21 30.70 0.19872 0.455 -0.80619 4.73 10/03/21 30.55 0.18907 0.425 -0.81731 4.845 11/03/21 30.49 0.18565 0.415 -0.82083 4.895 12/03/21 31.28 0.22291 0.51 -0.78285 4.2Note: ATM: AT-THE named range from the list Name SONIC SONIC HEALTHCARE CONTINUOUS CALL - IMPLIED VOL(ATM) SONIC HEALTHCARE CONTINUOUS PUT - IMPLIED VOL(ATM) 25/03/16 0.2653 0.2237 0.2407 28/03/16 0.2653 0.2237 0.2407 29/03/16 0.2659 0.2488 0.2485 30/03/16 0.2657 0.2399 0.2492 31/03/16 0.2661 0.2306 0.2435 01/04/16 0.267 0.248 0.2604 04/04/16 0.2668 0.2481 0.2608 05/04/16 0.2676 0.2602 0.2643 06/04/16 0.2679 0.2527 0.26 07/04/16 0.268 0.2468 0.2571 08/04/16 0.2677 0.2455 0.2567 11/04/16 0.268 0.2535 0.2534 12/04/16 0.2676 0.2454 0.2593 13/04/16 0.2666 0.247 0.2491 14/04/16 0.267 0.2429 0.2447 15/04/16 0.2669 0.2409 0.2443 18/04/16 0.2669 0.2423 0.2503 19/04/16 0.2678 0.2321 0.2483 20/04/16 0.2673 0.2342 0.232 21/04/16 0.2674 0.2318 0.2432 22/04/16 0.2674 0.2329 0.2412 25/04/16 0.2674 0.2329 0.2412 26/04/16 0.2673 0.2476 0.2482 27/04/16 0.2674 0.2433 0.2387 28/04/16 0.2676 0.2457 0.2402 29/04/16 0.2676 0.2404 0.2383 02/05/16 0.2679 0.2317 0.2367 03/05/16 0.2692 0.2293 0.2292 04/05/16 0.2696 0.2254 0.2334 05/05/16 0.2687 0.2309 0.2326 06/05/16 0.2691 0.2239 0.2333 09/05/16 0.2693 0.2252 0.2331 10/05/16 0.2694 0.2171 0.237 11/05/16 0.2696 0.2081 0.2379 12/05/16 0.2696 0.2222 0.2352 13/05/16 0.2695 0.2082 0.2447 16/05/16 0.2737 0.2262 0.2557 17/05/16 0.274 0.2454 0.2567 18/05/16 0.2742 0.2472 0.2519 19/05/16 0.2741 0.2458 0.2479 20/05/16 0.2742 0.2375 0.2569

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Sliced Bread plc is a divisionalized company. Among its divisions are Grain and Bakery. Grain's operations include granaries, milling and dealings in the grain markets; Bakery operates a number of...

How do i plot graph of historical volatility with 1 year implied volatility using given data as below?. Stock Price of CALL DELTA CALL PRICE (AUD) PUT DELTA PUT PRICE (AUD) Strike (X) 35 Expiration...

I need to know how each answer was arrived at step by step 20. Assume the Black-Scholes framework. Consider a stock, and a European call option and a European put option on the stock. The current...

Questions were written in the word file named questions, and the question related powerpoint slides were named as slides. Thanks in advance. 1) The common stock of Marielle Machinery will generate...

1) An off-market interest rate swap has: Select one: a. a floating rate payment that is greater than the current fixed rate payment. b. a fixed rate payment that is greater than the current floating...

Current price of the stock is $40. The interest rate r=5%. For each observed put price the Black-Scholes model is used to extract the implied volatility and the delta. [A] Explain how we obtain the...

eco105 A risk-averse invertor with W, to invest has two sets available. One is risk fr and pays a return p, while the other is risky and pays & random return of r. Assume that the investor chooses a,...

fina.. give all answers correctly There are 3 parts to question it is an article: UK Corporate Governance Code reporting last year, FRC stated that: "Effectively applying the Corporate Governance...

Lets focus on the $40-strike put. As we see in the table the trader is offering this option at $0.77, which is an implied volatility of 32%. At this implied volatility we observe a delta of -0.123....

provide solutions, 1.Mr Patel owns an Indian restaurant in a bad neighbourhood. In a given year, there is a25% chance that his restaurant will be set on fire and burnt down by local vandals.Assume...

1 . Suppose you buy a call option and write (ie., short sell) a put option, both based on goodgle stock and having the same strike price and expiring in one month. Your overall option portfolio will...

Do you lose or gain information when you use statistics to reduce a population to a few characteristic numbers?

Aaron Thompson of 725 Midwest Ave, Omaha, NE 68107 died on November 24, 2016. He was survived by his wife, Rachel, and their son, John. At the time of his death, Aaron was employed by a microchip...

Steve works for Alpha Materials sells industrial bolts to small manufacturing companies. In talking with one of his customers he decides to offer a higher grade of metal bolt than what the customer...

How do I compute the maximum, minimum and the average return of a stock using excel?