Thread Subject:

SOS: Option chain and implied volatility (Bloomberg)

1. How to get option chain?
In excel :
A1: SPY US Equity
 =BDS(A1,"OPT_CHAIN","cols=1;rows=1720")
gives me all the options on SPY as the following:

SPY US 06/18/11 C20 Equity
SPY US 06/18/11 C25 Equity
SPY US 06/18/11 C30 Equity
SPY US 06/18/11 C35 Equity
SPY US 06/18/11 C40 Equity
SPY US 06/18/11 C45 Equity
SPY US 06/18/11 C50 Equity
...

How can I do that in Matlab with Bloomberg (Datafeed)?

2. How can I get the 30 day implied vol (for ATM options) in Matlab with Bloomberg (Datafeed)?


Thanks in advance !!

On Jun 14, 6:00 pm, "Qiusi " <qzh...@3twelvecapital.com> wrote:
> 1. How to get option chain?
> In excel :
> A1: SPY US Equity
>  =BDS(A1,"OPT_CHAIN","cols=1;rows=1720")
> gives me all the options on SPY as the following:
>
> SPY US 06/18/11 C20 Equity
> SPY US 06/18/11 C25 Equity
> SPY US 06/18/11 C30 Equity
> SPY US 06/18/11 C35 Equity
> SPY US 06/18/11 C40 Equity
> SPY US 06/18/11 C45 Equity
> SPY US 06/18/11 C50 Equity
> ...
>
> How can I do that in Matlab with Bloomberg (Datafeed)?
>
> 2. How can I get the 30 day implied vol (for ATM options) in Matlab with Bloomberg (Datafeed)?
>
> Thanks in advance !!

Warning:
This is from memory since I dont have access to bloomberg to test.


first open a channel to bloomberg:

c = bloomberg(); % depending on your version of matlab you may need to
use blp()

1.

>> oc = fetch(c, 'SPY US Equity', 'GetData','OPT_CHAIN');

2.

>> vol = fetch(c, oc.OPT_CHAIN, ,'GetData',{'OPT_STRIKE_PX','OPT_PUT_CALL',...
               'OPT_EXPIRE_DT','OPT_IMPLIED_VOLATILITY_MID'});

/reza

Thanks, it helps a lot !

Another thing is that is fetch a current or both current and historial?

So if I add a date in the end of the fetch option, could it work? And in what format?

'06/13/2011' or ...?

On Jun 15, 11:18 am, "Qiusi " <qzh...@3twelvecapital.com> wrote:
> Thanks, it helps a lot !
>
> Another thing is that is fetch a current or both current and historial?
>
> So if I add a date in the end of the fetch option, could it work? And in what format?
>
> '06/13/2011' or ...?

fetch() arguments are too rich to explain here. Goto matlab gui help
by typing helpwin

in the gui help search for bloomberg, in the "See Also" section click
on fetch.bloomberg

You can also use a GUI by typing dftool in matlab to Historical, live
tick data.

/reza

Ok, thanks. I get the format of the date.

But now I have an emergency, is there possible to get historical data (no matter using fetch or history) and return a structure (instead of cells).

Our company is running tests to choose the best fit software, plz reply asap, thanks a lot!

"Zoe " <em5357@hotmail.com> wrote in message
news:itdbfg$rp$1@newscl01ah.mathworks.com...
> Ok, thanks. I get the format of the date.
>
> But now I have an emergency, is there possible to get historical data (no
> matter using fetch or history) and return a structure (instead of cells).
> Our company is running tests to choose the best fit software, plz reply
> asap, thanks a lot!

I don't know how many experts there are on the Bloomberg interface in
Datafeed Toolbox on CSSM. You should send a description of what you're
trying to do to Technical Support; they should be able to describe what to
do to accomplish your goal.

--
Steve Lord
slord@mathworks.com
To contact Technical Support use the Contact Us link on
http://www.mathworks.com

I attempted this, but am told that "OPT_CHAIN" is an invalid field requested. Am I missing something? (I do have the datafeed toolbox).

Thanks,
Jeremy

"Jeremy Long" wrote in message <k0mk0h$98a$1@newscl01ah.mathworks.com>...
> I attempted this, but am told that "OPT_CHAIN" is an invalid field requested. Am I missing something? (I do have the datafeed toolbox).
>
> Thanks,
> Jeremy

chain = getdata(c,'SPX Index','OPT_CHAIN')

"Jeremy Long" wrote in message <k0mk0h$98a$1@newscl01ah.mathworks.com>...
> I attempted this, but am told that "OPT_CHAIN" is an invalid field requested. Am I missing something? (I do have the datafeed toolbox).
>
> Thanks,
> Jeremy


>> chain = getdata(c,'SPX Index','OPT_CHAIN')

chain =

    OPT_CHAIN: {{1814x1 cell}}

"Zoe Zhang" <qzhang@3twelvecapital.com> wrote in message <k0oqab$lbt$1@newscl01ah.mathworks.com>...
> "Jeremy Long" wrote in message <k0mk0h$98a$1@newscl01ah.mathworks.com>...
> > I attempted this, but am told that "OPT_CHAIN" is an invalid field requested. Am I missing something? (I do have the datafeed toolbox).
> >
> > Thanks,
> > Jeremy
>
>
> >> chain = getdata(c,'SPX Index','OPT_CHAIN')
>
> chain =
>
> OPT_CHAIN: {{1814x1 cell}}


Thank you for the help. Is there a way to get the option chains from yahoo finance?
Thanks,
Jeremy

"Jeremy Long" wrote in message <k13jfv$35s$1@newscl01ah.mathworks.com>...
> "Zoe Zhang" <qzhang@3twelvecapital.com> wrote in message <k0oqab$lbt$1@newscl01ah.mathworks.com>...
> > "Jeremy Long" wrote in message <k0mk0h$98a$1@newscl01ah.mathworks.com>...
> > > I attempted this, but am told that "OPT_CHAIN" is an invalid field requested. Am I missing something? (I do have the datafeed toolbox).
> > >
> > > Thanks,
> > > Jeremy
> >
> >
> > >> chain = getdata(c,'SPX Index','OPT_CHAIN')
> >
> > chain =
> >
> > OPT_CHAIN: {{1814x1 cell}}
>
>
> Thank you for the help. Is there a way to get the option chains from yahoo finance?
> Thanks,
> Jeremy

That I am not sure. I just use BBG.