You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The bundle ingests as normal into zipline but when I try running the actual backtest using zipline run --algofile sample.py -s 2020-01-01 -e 2021-01-01 --no-benchmark --bundle yahoo_csv , I get this error :
Traceback (most recent call last): File "/home/franklin/anaconda3/envs/algotrading_multi_asset/bin/zipline", line 8, in <module> sys.exit(main()) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1137, in __call__ return self.main(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1062, in main rv = self.invoke(ctx) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1668, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1404, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 763, in invoke return __callback(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/__main__.py", line 106, in _ return f(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/decorators.py", line 26, in new_func return f(get_current_context(), *args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/__main__.py", line 300, in run return _run( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/run_algo.py", line 93, in _run bundle_data = bundles.load( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/data/bundles/core.py", line 534, in load asset_finder=AssetFinder( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/assets/assets.py", line 302, in __init__ metadata = sa.MetaData(bind=engine) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/assets/assets.py", line 303, in __init__ metadata.reflect(only=asset_db_table_names) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/sqlalchemy/sql/schema.py", line 4703, in reflect raise exc.InvalidRequestError( sqlalchemy.exc.InvalidRequestError: Could not reflect: requested table(s) not available in Engine(sqlite:////home/franklin/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646/assets-7.sqlite): (equities, futures_contracts, exchanges, futures_root_symbols, equity_supplementary_mappings, asset_router, version_info, equity_symbol_mappings) (algotrading_multi_asset) franklin@franklins-pc:~/Documents/Projects/algotrading_multi_asset$ cd /home/franklin/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646/ bash: cd: /home/franklin/.zipline/data/yahoo_csv/2021-06-08T14: No such file or directory bash: 43: command not found bash: 30.461646/: No such file or directory (algotrading_multi_asset) franklin@franklins-pc:~/Documents/Projects/algotrading_multi_asset$ cd "/home/franklin/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646/" (algotrading_multi_asset) franklin@franklins-pc:~/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646$ rm assets-7.sqlite (algotrading_multi_asset) franklin@franklins-pc:~/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646$ cd ~/Documents/Projects/algotrading_multi_asset/ (algotrading_multi_asset) franklin@franklins-pc:~/Documents/Projects/algotrading_multi_asset$ clear (algotrading_multi_asset) franklin@franklins-pc:~/Documents/Projects/algotrading_multi_asset$ zipline run --algofile sample.py -s 2020-01-01 -e 2020-02-01 --no-benchmark --bundle yahoo_csv Traceback (most recent call last): File "/home/franklin/anaconda3/envs/algotrading_multi_asset/bin/zipline", line 8, in <module> sys.exit(main()) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1137, in __call__ return self.main(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1062, in main rv = self.invoke(ctx) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1668, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1404, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 763, in invoke return __callback(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/__main__.py", line 106, in _ return f(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/decorators.py", line 26, in new_func return f(get_current_context(), *args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/__main__.py", line 300, in run return _run( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/run_algo.py", line 93, in _run bundle_data = bundles.load( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/data/bundles/core.py", line 534, in load asset_finder=AssetFinder( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/assets/assets.py", line 301, in __init__ self.engine = engine File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/input_validation.py", line 811, in preprocessor return to(arg, **to_kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/sqlite_utils.py", line 44, in check_and_create_engine verify_sqlite_path_exists(path) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/sqlite_utils.py", line 33, in verify_sqlite_path_exists raise ValueError("SQLite file {!r} doesn't exist.".format(path)) ValueError: SQLite file '/home/franklin/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646/assets-7.sqlite' doesn't exist. .
The csv files are downloaded from the yfinance module and written into as pd dataframes and written into csv files.
The text was updated successfully, but these errors were encountered:
The bundle ingests as normal into zipline but when I try running the actual backtest using
zipline run --algofile sample.py -s 2020-01-01 -e 2021-01-01 --no-benchmark --bundle yahoo_csv
, I get this error :Traceback (most recent call last): File "/home/franklin/anaconda3/envs/algotrading_multi_asset/bin/zipline", line 8, in <module> sys.exit(main()) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1137, in __call__ return self.main(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1062, in main rv = self.invoke(ctx) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1668, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1404, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 763, in invoke return __callback(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/__main__.py", line 106, in _ return f(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/decorators.py", line 26, in new_func return f(get_current_context(), *args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/__main__.py", line 300, in run return _run( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/run_algo.py", line 93, in _run bundle_data = bundles.load( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/data/bundles/core.py", line 534, in load asset_finder=AssetFinder( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/assets/assets.py", line 302, in __init__ metadata = sa.MetaData(bind=engine) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/assets/assets.py", line 303, in __init__ metadata.reflect(only=asset_db_table_names) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/sqlalchemy/sql/schema.py", line 4703, in reflect raise exc.InvalidRequestError( sqlalchemy.exc.InvalidRequestError: Could not reflect: requested table(s) not available in Engine(sqlite:////home/franklin/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646/assets-7.sqlite): (equities, futures_contracts, exchanges, futures_root_symbols, equity_supplementary_mappings, asset_router, version_info, equity_symbol_mappings) (algotrading_multi_asset) franklin@franklins-pc:~/Documents/Projects/algotrading_multi_asset$ cd /home/franklin/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646/ bash: cd: /home/franklin/.zipline/data/yahoo_csv/2021-06-08T14: No such file or directory bash: 43: command not found bash: 30.461646/: No such file or directory (algotrading_multi_asset) franklin@franklins-pc:~/Documents/Projects/algotrading_multi_asset$ cd "/home/franklin/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646/" (algotrading_multi_asset) franklin@franklins-pc:~/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646$ rm assets-7.sqlite (algotrading_multi_asset) franklin@franklins-pc:~/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646$ cd ~/Documents/Projects/algotrading_multi_asset/ (algotrading_multi_asset) franklin@franklins-pc:~/Documents/Projects/algotrading_multi_asset$ clear (algotrading_multi_asset) franklin@franklins-pc:~/Documents/Projects/algotrading_multi_asset$ zipline run --algofile sample.py -s 2020-01-01 -e 2020-02-01 --no-benchmark --bundle yahoo_csv Traceback (most recent call last): File "/home/franklin/anaconda3/envs/algotrading_multi_asset/bin/zipline", line 8, in <module> sys.exit(main()) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1137, in __call__ return self.main(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1062, in main rv = self.invoke(ctx) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1668, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 1404, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/core.py", line 763, in invoke return __callback(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/__main__.py", line 106, in _ return f(*args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/click/decorators.py", line 26, in new_func return f(get_current_context(), *args, **kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/__main__.py", line 300, in run return _run( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/run_algo.py", line 93, in _run bundle_data = bundles.load( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/data/bundles/core.py", line 534, in load asset_finder=AssetFinder( File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/assets/assets.py", line 301, in __init__ self.engine = engine File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/input_validation.py", line 811, in preprocessor return to(arg, **to_kwargs) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/sqlite_utils.py", line 44, in check_and_create_engine verify_sqlite_path_exists(path) File "/home/franklin/anaconda3/envs/algotrading_multi_asset/lib/python3.8/site-packages/zipline/utils/sqlite_utils.py", line 33, in verify_sqlite_path_exists raise ValueError("SQLite file {!r} doesn't exist.".format(path)) ValueError: SQLite file '/home/franklin/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646/assets-7.sqlite' doesn't exist.
.The csv files are downloaded from the yfinance module and written into as pd dataframes and written into csv files.
The text was updated successfully, but these errors were encountered: