# The index level=1 contains the security or asset object# It has several attributes. Lets see what they are by looking at the docstrfirst_security=result.index.get_level_values(level=1)[0]help(first_security)

# Create columns to expose these attributesresult['asset_name']=[str(asset.asset_name)forassetinresult.index.get_level_values(level=1)]result['exchange']=[str(asset.exchange)forassetinresult.index.get_level_values(level=1)]result['exchange_full']=[str(asset.exchange_full)forassetinresult.index.get_level_values(level=1)]result['symbol']=[str(asset.symbol)forassetinresult.index.get_level_values(level=1)]result['sid']=[str(asset.sid)forassetinresult.index.get_level_values(level=1)]# Look at the new dataframe and see how the different exchanges handle symbolsresult.groupby('exchange').first()

Out[5]:

economy

listing currency

listing exchange

mkt_cap

price

sector

security type

subsector

volume

asset_name

exchange_full

symbol

sid

exchange

BOM

Healthcare

INR

R5YP6Q-S

5.104200e+08

140.0

Healthcare Services

SHARE

Patient Care

4585.0

Dr. Agarwal'S Eye Hospital Limited

BSE Ltd. (BOM)

526783

1178883482794310

NSE

Consumer Non-Cyclicals

INR

CL2QD7-S

1.126230e+09

220.9

Food and Tobacco Production

SHARE

Food and Beverage Production

111.0

United Nilgiri Tea Estates Co. Ltd.

National Stock Exchange of India (NSE)

UNITEDTEA

1178913799819604

In [6]:

# From above it can be seen that the BOM exchange uses numbers for tickers but the NSE uses alpha characters# To reference a given asset one can use the standard 'symbols' method# However, use the SID rather than the ticker. The ticker only works for US securities.# Don't put the sid in quotesargawals=symbols(1178883482794310)argawals

Out[6]:

Equity(1178883482794310 [526783])

In [7]:

# check it's the right one by lookiing at the nameargawals.asset_name

Out[7]:

u"Dr. Agarwal'S Eye Hospital Limited"

In [8]:

# a little trick to remove the preceding 'u'...# change the value to an ascii string rather than unicodestr(argawals.asset_name)

Out[8]:

"Dr. Agarwal'S Eye Hospital Limited"

So, referencing a global security is identical to a US security except use the SID rather than the ticker.