Looking for a similar answer, essay, or assessment help services?

Simply fill out the order form with your paper’s instructions in a few easy steps. This quick process ensures you’ll be matched with an expert writer who
Can meet your papers' specific grading rubric needs. Find the best write my essay assistance for your assignments- Affordable, plagiarism-free, and on time!

Posted: September 2nd, 2021

Volatility Assignment | Homework For You

The assignment will require you to extract data from two data sets provided on the LMS.
The first “S&P500 options.csv” contains daily data for traditional European S&P500 options from October 30, 2017 to November 30, 2017. The file contains details on calls and puts for the November 17, 2017 and December 15, 2017 contracts.
The second data set “S&P500.xlsx” contains daily realized volatility estimates (column B) sourced from the Oxford-Man Institute Realized Library -  realized.oxford-. Column C scales the  realized volatility so that it proxies close to close volatility.

QUESTION 1 (10+1+10 = 21 marks)
This question requires you to calculate part of the volatility surface on November 8, 2017 using all available strikes that range from 2500 points to 2700 points.

What Citation Formats Do You Support?

We hear “Can you write in APA or MLA?” all the time—and the answer’s a big yes, plus way more! Our writers are wizards with every style—APA, MLA, Harvard, Chicago, Turabian, you name it—delivering flawless formatting tailored to your assignment. Whether it’s a tricky in-text citation or a perfectly styled reference list, they’ve got the skills to make your paper academically spot-on.

A)    Calculate FOUR separate implied volatility (IV) smiles using all of the provided strikes for each of the FOUR contracts i.e. i) November 17, 2017 calls; ii) November 17, 2017 puts; iii) December 15, 2017 calls and iv) December 15, 2017 puts.
Use the BSM model to extract the IVs. Further, assume a continuously compounded risk free rate of 1.30% p.a, and a continuously compounded dividend yield of 1.70% p.a.
Show all your calculations in your excel spreadsheet. Label the sheet “Surface”.
(10 marks)
B)    Plot the results for each of the FOUR IV smiles on the one graph.
(1 mark)
C)    Write a brief one page report outlining your findings. What can you infer from the results and are they consistent with your expectations?
(10 marks) Finance homework help

Tags: Ace My Homework: Essay Help, Assignment Help: USA's #1 Online Assignment Writing Service, Do My Assignment for Me Online - Write Academic Papers, Reliable Online Homework Help For You

Order|Paper Discounts

Why Choose Essay Bishops?

You Want The Best Grades and That’s What We Deliver

Top Essay Writers

Our top essay writers are handpicked for their degree qualification, talent and freelance know-how. Each one brings deep expertise in their chosen subjects and a solid track record in academic writing.

Affordable Prices

We offer the lowest possible pricing for each research paper while still providing the best writers;no compromise on quality. Our costs are fair and reasonable to college students compared to other custom writing services.

100% Plagiarism-Free

You’ll never get a paper from us with plagiarism or that robotic AI feel. We carefully research, write, cite and check every final draft before sending it your way.