These are draft notes extracted from subtitles. Feel free to improve them. Contributions are most welcome. Thank you!
Please check the wiki guide for some tips on wiki editing.
So why don’t you in this unit look at a fieldexample, if we are applying statistical techniquesfor problems of important significance in stocktrading. So here is a stock price for a specificday in 2010 and the company we’re discussingis Apple, which on the day started trading justabove $250 but in the afternoon the stock wentall of a sudden down to $200, back to theoriginal price. As a statistician, we areconcerned about this, because if we make tradingdecisions based on what’s happening, we mightlose millions or billions of dollars.This is a one in a decade abnormal behaviorand as a statistician, we might care aboutwriting software that finds these kind ofbehaviors, so we stop trading and we don’tfall into the trap of selling our stock at aunfortunate rate just because something really,really strange is happening. And that’s a realexample, in which have lost millions if notbillions of dollars.So on a typical trading day, Apple stock tradedabout 70,000 times, giving us 70,000 data pointsof prices during the day. What we’d be lookingat is the percentage change between adjacenttrades, which we call Delta T and this definedas the difference between two consecutive tradingpoints, XT plus one minus XT normalized by XT.So normally if XT and XT plus one is the same,this will be zero. If there is a big differencethen this is a larger value and we know for theday in question what the mean and the standarddeviation is for this percentage change. Themean is as small as 0.00074 negative in percent,so if we leave off the percent it’s even ahundred times smaller and this is the valuefor the standard deviation, 0.01344 percent.My first question for you is, to compute theconfidence interval, assuming that we can usea confidence interval to detect outliers inthe data. If you assume a symmetrical confidenceinterval with five percent confidence, in ourmagic factor that percentile is 1.96; computefor me in percent the confidence intervalfor the variable Delta T.
And the correct answer is minus 0.02708 and0.0256 and this is obtained by taking the meanover here and adding in the standard deviationplus minus up multiplied by 1.96.
So here is the real question, suppose you usethis confidence interval to detect abnormalbehavior and abnormal behavior mean, you go toyour boss and you complain, he’ll stop tradingthen how often during a day would you expect todetect abnormal behavior in your trading, ordifferently how frequently does this confidenceinternal trigger on any given single day.
And the answer is way too frequently, 3,500 on just asingle day you’d be taking your boss all the time andthe reason is very simple. You take the 70,000over here and you apply a five percent internalover here and if everything is normal youdistribute it what you believe it is, you get3,500 outliers in expectation every day.
The trick is to change these numbers over hereto numbers that trigger once in a decade andthis is as simple as changing the 1.96 to 6.5which is really kind of a minor change, but thismakes all the difference. The percentage nowbecomes so small, you get one trigger per decade.So let’s quickly compute what the numbers looklike for 6.5.
And these are the numbers I get: minus 0.0881,0.08662. And this is a wider confidence internvalthan before, that means we trigger lessfrequently and we find less frequently problems withour trading statistics.So let’s now dive in on May 6, 2010, when theApple stock crashed and see if we could havedetected that crash and saved ourselves from risky trades.
So, let me give you examples for twoconsecutive prices. So, here’s one examplewhere the stock changed from 286.85, 286.83.First you calculate the Delta T, which toremind you was the difference of those twothings, Xt+1 - Xt, normalized by Xt. So, whydon’t you give me your calculation of Delta T,into this box over here.
Note that a percent sign is missing from the quiz. The answer has to be in percent:
I get 0.00697 when I plug this in.
And now, here’s the important question,is this abnormal, yes or no?
And I would say, no, because this value fallswell into – between this confidence intervalfrom here to here.
I give you three more examples from that day.Because at some point, we got from 247.6 to247.55, some other time 242.5 to 240.0 and thenwe got from 205.71 to 201: all within afraction of a second. I’m just going to askyou the same question as before, do youconsider these abnormal, relativeto this confidence interval over here?
And it turns out, the first one is still okay,but the last two would have been abnormal.And the reason is when you work out the Delta Tin percent, you find that this one over here is a0.104% change, but it’s just too much for a singletrade. And this one is an amazing 2.3% changewithin a single trade. And those clearly triggerthe abnormality behavior. Let’s look at the data.
And this here is our Delta T,over time, for Apple’s stock on May 6, 2010.And you’ll find during the day it trades very normallyand all of a sudden you get this amazing oscillation hereof the stock first going down and then going up againand that is really indicative of something bizarre happening.And our statistic would have found itand might have saved you some money.So, that’s my example from financial data.In the next few minutes we’re going to pick a different example.