search

FabioLuca / invst

A project for algorithm trading. From fetching OHLC market data from either Alpha Vantage API or Yahoo Finance API, or other data providers, analyze data based on investment strategies, and decide and act on Comdirect API.
https://fabioluca.github.io/invst/
3 stars 0 forks source link

Store Data in Database #4

Closed wayneconnolly closed 2 years ago

wayneconnolly commented 2 years ago

Storing the historic data and analysis in a database would be amazing. With your existing panda setup it should be straight forward?

Maybe also the ability to download and process all symbols in one go rather than having to do them as a single request.

FabioLuca commented 2 years ago

The actual implementation is storing into files (Microsoft Excel). So basically a new file stores the data for the given day. The decision in the past to use files instead of a database was because performance was not an issue, and the most important was that the final goal is to deploy / use from a cloud computing system, and to keep costs low, avoid the costs related to database usage. The first (current) implementation is using local files, but current goal is to store/load files directly from an online storage platform (e.g. Dropbox).

For the batch operation (multiple symbols) you can take the example from automation/run_analysis.py . If no argument is passed to the run_analysis function, it will process the analysis on the list defined inside it. Unfortunately much of the latest developments are still open, and so the documentation, so this option is not clear.

wayneconnolly commented 2 years ago

That makes sense. Thanks