Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
using zipline for own csv data

Hi, I am trying to import my own csv data to backtest with the zipline package. Now I met with some problems.
1. My data only have daily price(no open,high,low,close,volumn). It looks like I cannot register csv bundle, and can only put the data in the zipline.run_algorithm(...data=data...) argument, right?
2. Say, my data only has one column (one stock), like this:

            EUR  
date  
2007-01-01  1.3201  
2007-01-02  1.3273  
2007-01-03  1.3169  
2007-01-04  1.3084  

It looks like I can run the following code from 2014 to 2018, but cannot run it from 2013 to 2018. Does zipline put any restrictions on five years limit? or I have some wrong configuration?
perf = zipline.run_algorithm(start=datetime(2014, 1, 1, 0, 0, 0, 0, pytz.utc), end=datetime(2018, 3, 1, 0, 0, 0, 0, pytz.utc), initialize=initialize, capital_base=100, handle_data=handle_data, data=dat)

The error I got is

SSLError: HTTPSConnectionPool(host='api.iextrading.com', port=443): Max retries exceeded with url: /1.0/stock/SPY/chart/5y (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'ssl3_get_server_certificate', 'certificate verify failed')],)",),))  

Why I am using my local data but the error has some HTTP problem? Shouldn't this kind of job can be run without internet connection? Thank you very much!

1 response

It looks like when I am back home, then there is no problem with it. Maybe my company's wifi has some restriction? Anyway, is it because I did not specify trading_calendar so that zipline has to connect to internet to download some date info?