SID to company name?

Quantopian's community platform is shutting down. Please read this post for more information and download your code.

Back to Community

SID to company name?

Mustang Capital

posted Mar 24, 2018

Hi friends, does anyone know how to get the name of a company give it's SID?

4 responses

First get an equity object by referencing the SID. In the IDE use the 'sid' method or in the research environment use the 'symbols' method. The equity object has several attributes. The 'asset_name' attribute should get you what you want. Something like this...


#  in the IDE  
my_equity = sid(24)

# in a notebook  
my_equity = symbols(24)

# once one has an equity object then reference the 'asset_name' attribute  
my_equity_name = my_equity.asset_name

# this returns a unicode string and by default prints with a preceding 'u'  
# to strip the preceding 'u' when printing one can use the str function  
str(my_asset_name)

For more info on the equity object and its other attributes see the docs https://www.quantopian.com/help#api-sidinfo .

Good luck

Mustang Capital

Thank you!

How could I show the asset names as a column in the Pipeline in the research environment, please?

Joseph Moorhouse

Did you come to a solution? I'm not sure if there is a way to achieve this within the Pipeline class, but the code below should work on the pipeline output.

The code assumes you named your output as pipeline_output. If not, just replace this name with your output dataframe.

tickers = pipeline_output.index.get_level_values(1)

pipeline_output['company_name'] = [ticker.asset_name for ticker in tickers]

Hope this helps.

You've successfully submitted a support ticket.

Our support team will be in touch soon.

Need help? Contact support.

The material on this website is provided for informational purposes only and does not constitute an offer to sell, a solicitation to buy, or a recommendation or endorsement for any security or strategy, nor does it constitute an offer to provide investment advisory services by Quantopian.

In addition, the material offers no opinion with respect to the suitability of any security or specific investment. No information contained herein should be regarded as a suggestion to engage in or refrain from any investment-related course of action as none of Quantopian nor any of its affiliates is undertaking to provide investment advice, act as an adviser to any plan or entity subject to the Employee Retirement Income Security Act of 1974, as amended, individual retirement account or individual retirement annuity, or give advice in a fiduciary capacity with respect to the materials presented herein. If you are an individual retirement or other investor, contact your financial advisor or other fiduciary unrelated to Quantopian about whether any given investment idea, strategy, product or service described herein may be appropriate for your circumstances. All investments involve risk, including loss of principal. Quantopian makes no guarantees as to the accuracy or completeness of the views expressed in the website. The views are subject to change, and may have become unreliable for various reasons, including changes in market conditions or economic circumstances.

About Quantopian

The material on this website is provided for informational purposes only and does not constitute an offer to sell, a solicitation to buy, or a recommendation or endorsement for any security or strategy, nor does it constitute an offer to provide investment advisory services by Quantopian.

In addition, the material offers no opinion with respect to the suitability of any security or specific investment. No information contained herein should be regarded as a suggestion to engage in or refrain from any investment-related course of action as none of Quantopian nor any of its affiliates is undertaking to provide investment advice, act as an adviser to any plan or entity subject to the Employee Retirement Income Security Act of 1974, as amended, individual retirement account or individual retirement annuity, or give advice in a fiduciary capacity with respect to the materials presented herein. If you are an individual retirement or other investor, contact your financial advisor or other fiduciary unrelated to Quantopian about whether any given investment idea, strategy, product or service described herein may be appropriate for your circumstances. All investments involve risk, including loss of principal. Quantopian makes no guarantees as to the accuracy or completeness of the views expressed in the website. The views are subject to change, and may have become unreliable for various reasons, including changes in market conditions or economic circumstances.