Data Study on Option Pricing

Posted on Jun 1, 2016
The skills we demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.
Contributed by Ruonan Ding. She is currently in the NYC Data Science Academy 12 week full time Data Science Bootcamp program taking place between April 11th to July 1st, 2016. This post is based on her third class project - Web Scraping (due on the 6th week of the program)

Goal:

This exercise illustrates the Option Pricing techniques of Binomial Tree option pricing and Monte Carlo simulated method in pricing. Black-Scholes model is not demonstrated here since it is a data and formula based method that doesn't give flexibility of constructing exotic options.

The example is Russell 2000 Index. The data was scraped from yahoo.finance from 12/1/2015 to 5/2016 using Scrapy.  The option to price in the example is a call option strike price at 980 and exercise date on 6/17/2016.

Data

Price of the underlying index:

This is the price of the underlying index Russell2000 over the past 6 months.

Data Study on Option Pricing

and the daily volatility is graphed as below.  This shows the magnitude of changes bouncing up and down daily of the Russell 2000 index.

Data Study on Option Pricing

Option Pricing Assumption:

  • exerciseDate  : 6/17/2016
  • exercisePrice : 980
  • timeToExpiry : 29 days
  • underlyingPrice : 1094.76
  • expectedVol : 0.1486
  • riskFreeRate : 0.03

Pricing Method 1: Binomial Tree

Binomial Tree is essentially replicate the payoff of the derivative with the stock and a risk-free bond. We define the risk-neutral probability of the stock price going up as follows, assuming a Cox-Ross-Rubinstein tree:

  • u = e^(σ√h)
  • d = e^(−σ√h)
  • p =e^(r−δ)h − d/(u − d)
  • C0 = e−rh[pCu − (1 − p)Cd

Below is the construction of the option pricing tree of 29 days.  Given the scale of the graph, only the first 10 days option prices have been shown here on the graph.  However the same method applies across the entire holding period.  Payoffs were being calculated at each node on the tree here according to the probability and volatility of going up and down.  The final priced option at the root, which is today, is 117.23.

Data Study on Option PricingPricing Method 2: Monte Carlo Simulation

The way we’re going to simulate stocks is by taking advantage of the lognormality of stock prices. We’ll use the following method: start with iid uniform numbers u1, u2, …, un, calculate z’s where zi = N^(-1)(u1), convert these to N(µ, σ2) random variables by letting r1 = µ + σz1.

To simulate a single stock price the following formula can be used:

S(T) = S(0)e(α−δ−σ^2)T +σ√T z

Below is 20 out of 10000 simulated stock price at the time of expiring
##  [1] 1066.7280 1163.9929 1062.4881  974.6737 1117.2668 1131.5114 1165.4857
##  [8] 1086.3615 1147.9924 1090.1666 1124.2775 1181.3669 1083.9656 1069.3006
## [15] 1174.8100 1104.7534 1053.5856 1077.2294 1065.0571 1024.4855 1084.3327
## [22] 1133.4881 1103.6716 1118.3079 1064.6554 1094.3255 1150.0903 1094.5243
## [29] 1049.9021 1139.1014 1121.6219
Based is the simulated payoff given the stock price we just simulated at expiring.
##  [1]  86.72802 183.99287  82.48810   0.00000 137.26685 151.51141 185.48574
##  [8] 106.36153 167.99241 110.16656 144.27751 201.36691 103.96565  89.30063
## [15] 194.81002 124.75345  73.58560  97.22937  85.05710  44.48549 104.33266
## [22] 153.48814 123.67161 138.30794  84.65539 114.32553 170.09025 114.52428
## [29]  69.90208 159.10135 141.62188
Option price is average the simulated payoff at expiring discounted back to current, which is $118.0301

About Author

Ruonan Ding

Ruonan Ding has more than five years of experience in the actuarial science and financial field across asset management and insurance sectors. She was a pricing actuary for a property and casualty company, a lead analyst in capital...
View all posts by Ruonan Ding >

Related Articles

Leave a Comment

Google February 2, 2021
Google One of our guests lately proposed the following website.
Google December 27, 2020
Google That could be the end of this report. Here you will uncover some websites that we consider you’ll enjoy, just click the links.
Google December 14, 2019
Google We prefer to honor several other world wide web web-sites around the net, even if they aren’t linked to us, by linking to them. Beneath are some webpages worth checking out.
Google November 9, 2019
Google Very couple of websites that come about to be comprehensive beneath, from our point of view are undoubtedly well really worth checking out.
nba 2k17 coins August 31, 2016
You're a very valuable site; couldn't make it without ya! nba 2k17 coins http://2chat.arenabay.net/oxwall/event/192
cheap fifa 17 points August 27, 2016
You have possibly the best online websites cheap fifa 17 points http://chandrakalabroking.com/index.php/blog/entry/fifa-17-coins-for-ps4-liquid-printer-is-found-in-printer-inkjet.html
nba 2k17 mt coins August 23, 2016
Wow, lovely portal. Thnx .. nba 2k17 mt coins http://xperationdate.com/forum/#topic/cheap-NHL-coins-play-the-newest-games.htm
NFL 17 coins August 15, 2016
Many thanks, this website is very beneficial NFL 17 coins http://www.someda.co/forum/discussion/12693/fifa-17-points-ncaa-football-10-check-out-its-new-features
LaurenDAldas August 11, 2016
You're so cool! I truly do not believe I've truly go through something this way before. So wonderful to get someone with some original thoughts on this subject material. Seriously.. thanks for starting this up. This website is something that is needed online, someone with a little originality!
CrisZBaillie August 7, 2016
Fabulous, what a webpage it is! This blog provides valuable information to us, keep it up.
RoryFBenanti July 27, 2016
It's amazing to pay a quick visit this site and reading the views of all colleagues concerning this article, while I am also eager of getting experience.
AsaTKueker July 14, 2016
I usually do not realize the way i wound up here, but I thought this post was good. I don't know your identiity but definitely you might be seeing a famous blogger if you aren't already ;) Cheers!
tanie kredyty gotówkowe June 28, 2016
Thank's great post.
LeighQSalais June 24, 2016
Your means of explaining the whole thing with this paragraph is really pleasant, all have the capacity to simply know it, Thanks a lot.
XeniaKMayhan June 19, 2016
Definitely consider that that you just said. Your favourite justification appeared to be with the net the simplest factor to keep in mind of. I believe that for your needs, I definitely get irked whilst folks consider worries which they just don't understand about. You controlled going to the nail upon the very best and in addition defined out the whole thing without any need side-effects , folks can take a signal. Will probably be back to get more. Thanks
Amy June 9, 2016
Whoa! This blog looks just like my old one! It's on a entirely different topic but it has pretty much the same layout and design. Excellent choice of colors!

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI