preliminary data analysis
DESCRIPTION
Preliminary Data Analysis. Angela Ryu Economics 201FS Honors Junior Workshop: Finance Duke University February 10, 2010. Data. XOM (Exxon Mobile) Dec 1 1999 – Jan 7 2009 (2264 days) GOOG (Google) Aug 20 2004 – Jan 7 2009 (1093 days) WMT (Wal-Mart) - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/1.jpg)
Preliminary Data Analysis
Angela Ryu
Economics 201FSHonors Junior Workshop: Finance
Duke University
February 10, 2010
![Page 2: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/2.jpg)
Data
• XOM (Exxon Mobile) – Dec 1 1999 – Jan 7 2009 (2264 days)
• GOOG (Google)– Aug 20 2004 – Jan 7 2009 (1093 days)
• WMT (Wal-Mart)– Apr 9 1997 – Jan 7 2009 (2921 days)
![Page 3: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/3.jpg)
Getting hands dirty…
• Prices, Log Returns, Spotting Outliers• Realized Volatility• Bipower / Tripower / Quadpower Variation• Z-scores
Huang-Tauchen (2005)
![Page 4: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/4.jpg)
vs. Prices
XOM GOOG
WMT
![Page 5: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/5.jpg)
vs. Log Returns (5 min)
![Page 6: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/6.jpg)
vs. RV (5 min, daily)
![Page 7: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/7.jpg)
vs. BV (5 min, daily)
![Page 8: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/8.jpg)
vs. RV & BV (5 min, daily)
![Page 9: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/9.jpg)
Volatility Signature Plot
![Page 10: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/10.jpg)
vs. TP (5 min, daily)
![Page 11: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/11.jpg)
vs. QP (5 min, daily)
![Page 12: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/12.jpg)
XOM: Jump Detection using Z-score (5 min)
Test Fractions of days over sig. level
Zlog, TP, 0.95 0.1767
Zlog, TP, 0.99 0.0892
Zlog, TP, 0.999 0.0420
ZRJ, TP, 0.95 0.1480
ZRJ, TP, 0.99 0.0623
ZRJ, TP, 0.999 0.0221
![Page 13: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/13.jpg)
GOOG: Jump Detection using Z-score (5 min)
Test Fractions of days over sig. level
Zlog, TP, 0.95 0.2351
Zlog, TP, 0.99 0.1226
Zlog, TP, 0.999 0.0631
ZRJ, TP, 0.95 0.2068
ZRJ, TP, 0.99 0.0961
ZRJ, TP, 0.999 0.0375
![Page 14: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/14.jpg)
WMT: Jump Detection using Z-score (5 min)
Test Fractions of days over sig. level
Zlog, TP, 0.95 0.2372
Zlog, TP, 0.99 0.1287
Zlog, TP, 0.999 0.0681
ZRJ, TP, 0.95 0.2081
ZRJ, TP, 0.99 0.0965
ZRJ, TP, 0.999 0.0421
![Page 15: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/15.jpg)
GOOG: Kernel Density (5 min)
• Mean: 0.7643 ; Variance: 1.8278 ( ~N(0,1)?)
![Page 16: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/16.jpg)
Results & Plans
• Got more used to MATLAB– more efficient data analysis
• Better understanding in volatility measures
• Possible interests: RCOV, Volatility Risk Premium
• Background Reading
![Page 17: Preliminary Data Analysis](https://reader036.vdocuments.us/reader036/viewer/2022062408/56813494550346895d9b7eb2/html5/thumbnails/17.jpg)
Comments &Suggestions