Assignment 3 Question 1: (50 points) (1) Download option prices of ticker ^VIX for all expiration...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assignment 3 Question 1: (50 points) (1) Download option prices of ticker ^VIX for all expiration dates and name it VIX.options (2) Download the current price (last quote price) for ^VIX (3) For calls and puts of VIX.options at each expiration calculate the average of Bid and Ask. Create a new column named 'Price' to contain the result. (4) For calls and puts of VIX.options at each expiration, add a column of InTheMoney, which takes value TRUE when it is in-the-money, and FALSE otherwise. Compare it to ITM column to check your results. (Hint. A call option is in-the-money when its strike is less than the current price of underlying. A put option is in-the-money if its strike is greater than the current price of underlying. And the current price of underlying is the last quote price from 1.2) (5) For calls and puts of VIX at each expiration, delete all the fields except Strike, Bid, Ask, Price, and In-The-Money, and save them in .csv files with the format "VIXdata2021-09-26Exp2021-10-08puts.csv", here 2021-09-26 should be replaced by the date you download the data, and 2021-10-08 should be replaced by the date of expiration. (Hint. You may generate many .csv files, besides your .pdf report, please submit one of the .csv file.) Assignment 3 Question 1: (50 points) (1) Download option prices of ticker ^VIX for all expiration dates and name it VIX.options (2) Download the current price (last quote price) for ^VIX (3) For calls and puts of VIX.options at each expiration calculate the average of Bid and Ask. Create a new column named 'Price' to contain the result. (4) For calls and puts of VIX.options at each expiration, add a column of InTheMoney, which takes value TRUE when it is in-the-money, and FALSE otherwise. Compare it to ITM column to check your results. (Hint. A call option is in-the-money when its strike is less than the current price of underlying. A put option is in-the-money if its strike is greater than the current price of underlying. And the current price of underlying is the last quote price from 1.2) (5) For calls and puts of VIX at each expiration, delete all the fields except Strike, Bid, Ask, Price, and In-The-Money, and save them in .csv files with the format "VIXdata2021-09-26Exp2021-10-08puts.csv", here 2021-09-26 should be replaced by the date you download the data, and 2021-10-08 should be replaced by the date of expiration. (Hint. You may generate many .csv files, besides your .pdf report, please submit one of the .csv file.)
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Ms. Calhoun is age 51 and single. What is the maximum contribution that she can make to a Roth IRA if: a. Her AGI consists of an $89,400 salary from her employer? b. Her AGI consists of an $89,400...
-
The addition of water to ethylene to yield ethanol has the following thermodynamic parameters: (a) Is the reaction exothermic or endothermic? (b) Is the reaction favorable (spontaneous) or...
-
On January 1, 2020, the board of directors of Bunting Inc. granted restricted stock awards to 10 key employees to acquire 2,000 shares each under the following terms. - Restricted stock awards vest...
-
"About four percent of our production is defective, and there is no market for defective products. So our choice is either to discard the defective units or rework them. Some require more work than...
-
Kinnard Electronics manufactures two home theater systems: the Elite which sells for $1,400, and a new model, the Preferred, which sells for $1,100. The production cost computed per unit under...
-
? Journalize the following transactions of M . ?Clark, interior designer, in her first month of business. ( Credit account titles are automatically indented when amount is entered. Do not indent...
-
The following table shows estimates for a Canadian stock. Firm-Specific Standard Deviation 0.50 Expected Return 0.20 Beta 1.20 Suppose the TSX composite index has a standard deviation of 0.32. What...
-
A company has an expected dividend of $2.50 in one year and a required rate of return of 12%. What is the value of the company\'s stock today?.
-
One Primary Source Annotation citation and annotation Share one primary source related your topic; provide the citation and a brief annotation. Just to clarify, a primary source is generally a first...
-
Blake was 21 years of age at the end of the year. During the year, he was a full-time college student. He also worked part-time and earned $8,000, which he used to pay all $6,000 of his living...
-
1. Why business writing and communication is critical to your success: 2. What writing skills are most important; 3. How non-verbal communication are demonstrated; and 4.The three most important...
-
Gayane Corporation just issued a 20-year 12% semi-annual coupon bond. The bind is currently selling for $950 in the market. Suppose that the bond includes a call provision that allows the issuer to...
-
a business assessed a project and found that it had an internal rate of return of 15% and a payback period of 4 years. Subquent investigation found that the project cash flows in 5 years have been...
-
F.(3e* -2x 3 sin(2x)) is equal to 2 3 Cos 8. IT 3, t (4+@ 2 3, 1+o 1 4 Cos 4 4 1 3. 1 +4cos V7 (1+o 4 1 4 Cos 4 1+0 4-
-
Drop a department: revised information (Learning Objective 4) Consider Knight Fashion from S8-5. Assume that the fixed expenses assigned to each department include only direct fixed costs of the...
-
Product mix decision: unlimited demand (Learning Objective S) StoreAll produces plastic storage bins for household storage needs. The company makes two sizes of bins: large (50 gallon) and regular...
-
Replace a department (Learning Objective 4) Consider Knight Fashion from S8-5. Assume once again that all fixed costs are unavoidable. If Knight Fashion drops one of the current departments, it plans...
Study smarter with the SolutionInn App