# 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

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