[R-SIG-Finance] Non standard options, how to filter

Marc Delvaux mdelvaux at gmail.com
Mon Aug 2 17:53:57 CEST 2010


While working on a script comparing options across a large set of
symbols,I discovered a few aberrant cases associated with special
symbols (extra character after the stock symbol), as illustrated
below.  Apparently some of these values are stale.

I was wondering what exactly are these and what is the best way to
filter them out?  I highlighted cases of two options identical except
for the extra character but wildly different quotes.

> Options <- getOptionChain("BHI",Exp=NULL)
> Options[[2]]$puts[1:15,]
                   Strike Last Chg  Bid  Ask Vol   OI
BHI1101016P00017000   17.0 0.45   0 0.07 0.19  10   24
BHI1101016P00018000   18.0 0.95   0 0.17 0.24   0   67
BHI1101016P00019000   19.0 0.65   0 0.30 0.35  10  459
BHI101016P00020000    20.0 0.35   0   NA 0.09   0   50            <<<<<
BHI1101016P00020000   20.0 1.00   0 0.47 0.53  10 1079      <<<<<
BHI1101016P00021000   21.0 1.25   0 0.70 0.79  20  420
BHI1101016P00022000   22.0 1.85   0 1.02 1.09   0  656
BHI101016P00022500    22.5 0.55   0   NA 0.09   0   74
BHI1101016P00023000   23.0 3.70   0 1.45 1.58  10  172
BHI1101016P00024000   24.0   NA   0 2.00 2.16   0   41
BHI101016P00025000    25.0 0.45   0 0.01 0.10  57  156       <<<<<
BHI1101016P00025000   25.0   NA   0 2.69 2.84   0   10        <<<<<
BHI1101016P00026000   26.0   NA   0 3.45 3.60   0   20
BHI101016P00030000    30.0 0.15   0 0.10 0.13  62 1060
BHI101016P00035000    35.0 0.45   0 0.28 0.30  40 4242



More information about the R-SIG-Finance mailing list