Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute the difference between the prices for each day; i.e., the difference between the B and C columns and enter that amount in the D

image text in transcribed
Compute the difference between the prices for each day; i.e., the difference between the B and C columns and enter that amount in the D column headed "differential" for each day. Compute the arithmetic average and standard deviation of the "differential" column. The commands are respectively: =AVERAGE(D2:D67) and =STDEV(D2:D67). Your arbitrage strategy will be to buy one stock and simultaneously sell the other "short." To be specific, when the spread reaches one standard deviation above the mean you will buy the lower priced stock and sell the higher priced one. Alternatively, when the spread reaches one standard deviation below the mean, you will buy the expensive stock and simultaneously sell the cheap one short. You would then refrain from subsequent trading until the spread returned to the mean. At that point you would close out your positions. That is, you would sell stocks you owned "long" and buy those you were "short." Articulate your trading "rules" in statements such as: "I would buy stock X and sell Y when the spread reached _. I would extinguish positions when the spread returned to ." Your "trigger points" will be the mean plus and/or minus one standard deviation. Indicate them. Submit your record of prices and "trading rules." As a footnote to your record, please define the terms "arbitrage" and "short sale." Also please write a sentence explaining the underlying theoretical premise upon which such an arbitrage is based; i.e., why should it work? This completes our project. It is due on the

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Numerical Analysis

Authors: Richard L. Burden, J. Douglas Faires

9th edition

538733519, 978-1133169338, 1133169333, 978-0538733519

More Books

Students also viewed these Mathematics questions

Question

How do books become world of wonder?

Answered: 1 week ago