Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Importing personal data and selecting a list of stocks for the strategy from it
Ruslan Askerov
posted

Hi everyone,

I am new to Quantopian, so would highly appreciate your help here. I've got a list of 438 stocks in a csv file, that I need to turn into a universe on quantopian. So my goal is to create a filter based on that list. I found the following code on the forum and it fits my goal pretty well.

from quantopian.pipeline.filters import  StaticAssets  
aapl_ibm = StaticAssets(symbols(['AAPL', 'IBM']))

What I'm struggling with is I want to create a list variable with the list of stocks and input it in the functions above. So this is how I would do this normally in Python. 

df = pd.read_csv('stocks.csv')  
filter_list = list(df['ticker'])  
universe_filter = StaticAssets(symbols(filter_list))

Apparently, this approach does not work. Quantopian does not let me input and read a csv file. But how would I construct a list of 438 stocks? By hand? Any suggestions?

3 responses
Tentor Testivis

You can upload csv files to Research --> Custom Datasets
It's a bit more complicated than at home, it must have certain criteria. Here it is in the docs.
Once you managed to upload it, you can import it in IDE or notebooks and use it like the other dataset (I think there are also posts in the forum about this topic)

Ruslan Askerov

Thanks for the information! Unfortunately, it does not satisfy my needs, since I've got annual data with no returns. So basically a list of tickers. I just somehow need to make Quantopian ingest this list to a filter and use that to get the universe that I need. So looks like it can't be done and I have to manually input all the tickers I need.

Tentor Testivis

Yeah, it's probably the easiest way, I once did that on another platform. Just printed out the list, copied it and pasted it into their IDE as a list.

About Quantopian
Careers
Community
Events
Documentation
Academia
Lectures
Status
Facebook
Twitter
LinkedIn
YouTube
Terms of Use
Privacy Policy

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.