MATLAB: When I fetch the data from Bloomberg using SEDOL, how to get the currency in which it is priced

bloombergcurrencydatafeedDatafeed Toolboxfetchsedol

I would like to know the base currency of an equity. For example, I want to load the price timeseries for a stock, I fetch the data using the SEDOL code but I want to get the currency in which it is priced.

Best Answer

One can retrieve the currency as follows:

d = fetch(b,'2005973','GETDATA','CRNCY',[],[],'SEDOL1')

2005973 is the SEDOL number for IBM. Note that no overrides are being used in this case and hence the two empty inputs.

Related Solutions

MATLAB: How to obtain the currency of the security and the dividend when I perform a Bloomberg FETCH command using the Datafeed Toolbox in MATLAB 7.8 (R2009a)

The following command:

cur = fetch(bbg,'NDA SS Equity','GETDATA',{'BDVD_ALL_PROJECTIONS','CRNCY','EQY_DVD_CRNCY'})

will return a structure with the information. EQY_DVD_CRNCY is the currency of the dividend and CRNCY is the currency of the security itself.

MATLAB: How to specify an issue by its SEDOL number in the Datafeed Toolbox

This enhancement has been incorporated in Release 14 Service Pack 3 (R14SP3). For previous product releases, there are no workarounds.

Here's a sample function call:

blb = bloomberg;
% Return today's trade time series for the given security SEDOL1 id
% aggregated into 5 minute intervals.
d = fetch(blb,'2224563','TIMESERIES',NOW,5,'Trade','SEDOL1');

Best Answer

Related Solutions

MATLAB: How to obtain the currency of the security and the dividend when I perform a Bloomberg FETCH command using the Datafeed Toolbox in MATLAB 7.8 (R2009a)

MATLAB: How to specify an issue by its SEDOL number in the Datafeed Toolbox

Related Question