Fermé

A-binomial pricing in excel Find historical daily closing prices over the most recent 90 days for a stock in the index

2. Find historical daily closing prices over the most recent 90 days for a stock in the index OMX Nordic40 (OMXN40) (see :[login to view URL]).3. Import the file in Excel, then turn the price series into returnsui=ln(Si/Si−1) where,irefers to dayi,andi=0,1,2,...going forward in time.4. Compute the standard deviationsof theui,i=1,2,...using Excel functionSTDEV.S, calculate thestock volatilityσ=s/√τwhereτ=1/252 refers to one-day time step with 252 trading day convention.5. Select a trading call option on this stock that has the expiration data within one month from now, ourtask is to price this option using a simplen-step binomial tree.6. Now construct a binomial tree, with minimumn=5 steps, to model the future evolution of the stockprices up to the expiration date of your option. Your up and down parameters areu=eσ√∆tandd=e−σ√∆t, where∆t(in years) is the length of the time step on your tree. The recommended time stepis one day (=1/252) andnwill be the number of days over the time period from today to maturity.7. Assume that the option is European style, choose a reasonable value of the risk-free rate (to be an-nounced later in the course), calculate the price of this European option.

Compétences : Saisie de Données, Traitement de Données, Excel, Mathématiques, Statistiques

en voir plus : rolling volatility, how to calculate volatility of a portfolio, volatility standard deviation, calculating volatility for black scholes, volatility chart excel, how to calculate realized volatility, volatility calculator excel download, time varying volatility excel, vbs excel find, excel find display macro, excel vba show workbook closing current workbook, visual basic excel find content cell copy, excel download historical stock data yahoo finance vba, tiered pricing excel, excel find user, excel find copy cell, vba excel find text word document, excel find data multiple cells, excel macro historical stock quote vba, excel find sum closest

Concernant l'employeur :
( 4 commentaires ) Arboga, Sweden

Nº du projet : #19616316

5 freelance font une offre moyenne de €20 pour ce travail

mohamedaithmida

Hello sir ! We are a group of expert, each with a master's degree in economics and statistics , we have a good experience and brilliant skills in statistical analysis using EXCEL, we promise you for a quality work. at Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(5 Commentaires)
2.5
Srahman9561

sir, would u mind giving me an opportunity for your project. i will do your your job with full of honesty, sincerity and carefully. waiting for your kindness

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
yoyo09

Hello, Hope you are doing great!! I have gone through the project details extremely carefully and i am absolutely sure that i can do the project very well. please give me a chance and I well make sure that you'll more Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0
Norfaizaa

Dear Sir, I understand that you will need binomial pricing excel. I have experience using microsoft excel so that I am able to give to you fine results. My pay will be $23 usd for the work and I can finish the w Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0
Sarmistha99

Hi, This is a standard binomial Option Pricing model problem. In the First step you are taking the volatility and from their pricing the option I am planning to download data in Work Sheet 1, In the 2nd worksheet hav Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0