PDF Financial Markets I Final Project Guide
Financial Markets I Final Project Guide
Part I - Option pricing in Excel
1. Implement the Black Scholes Model in Excel. The trader will introduce in the specified cells the model parameters as following:
? Current stock price ? Exercise price ? Risk free rate ? Volatility ? Time to expiry
The calculations must dynamically provide the prices of call and put options
2. Calculate the price of a call option using the Black Scholes model implemented earlier in Excel.
Underlying asset:
Microsoft stock price from Yahoo Finance
Volatility calculated in Excel based on the historical daily evolution of Microsoft stock price in the previous 360 days.
Risk free rate = 0.1 %
Time to expiry = 1 year
Exercise price = current stock price
3. Implement the Binomial Option Pricing Model in Excel using the same option inputs found in #2. The trader will introduce, in the specified cells, the model parameters as following, and compare the option prices for each model used in #2 and #3: a. Current stock price b. Exercise price c. Risk free rate d. Volatility e. Time to expiry f. The calculations must provide: g. Upward movement (u)
Page 2
h. Downward movement(d) i. Probability of increase (Pu) j. Probability of decrease (Pd) k. Stock price considering the upward movement l. Stock price considering the downward movement m. Payoffs n. The price of a call option o. The price of a put option
Part II ? Forecast oil price evolution
1. Download data about oil price evolution.
Source:
Asset: WTI Crude Oil Spot Price Cushing, OK
Period: 2014-01-01 ? current day
Frequency: Daily
File type: Excel
2. Make a graph in Excel about oil price evolution using the data download from Quandl. Try to observe a trend if there is one.
3. Calculate oil price average, min and max in Excel.
4. Identify the factors that influenced the evolution of oil price in the mentioned period.
5. Think of a trading strategy for oil. Try to anticipate oil price future evolution.
6. Forecast oil price using:
? Your own judgment based on the information provided by the graph, news from the internet as well as your intuition
? A statistical method (regression, trend line, moving average or what method you consider suitable for the data).
? Forecasted period: one day, one month and one year. ? Try to combine the two approaches.
7. Check after a period if your forecast was close to the registered value.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pdf programming case a methodology for programmatic web data
- pdf hhooww ttoo vvaalluuee ssttoocckkss value spreadsheet
- pdf united states steel corporation historical segment financial
- pdf package stocks r
- pdf a world bank report april 2018 commodity markets outlook
- pdf financial markets i final project guide
- pdf chapter 1 descriptive statistics for financial data
- pdf analysis of stock price fluctuations before earnings statements
- pdf exxonmobil crude oil sites at penn state
- pdf rig count update moment of truth for the permian basin
Related searches
- final project ideas
- yahoo finance financial markets today
- creative final project ideas
- final project ideas computer science
- financial markets today news
- cnn financial markets today
- electrical engineering final project ideas
- us financial markets news
- 2019 financial markets review
- ap biology final project ideas
- blackrock financial markets advisory
- financial markets news