Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't use the bundle - ValueError: SQLite file '/home/franklin/.zipline/data/yahoo_csv/2021-06-08T14;43;30.461646/assets-7.sqlite' doesn't exist. #3

Open
Franklin-oss opened this issue Jun 10, 2021 · 0 comments

Comments

@Franklin-oss
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant