Aug-18-2021, 03:40 PM
I've asked a few people about this and not gotten a good answer. In general, I don't understand how a database can save me time.
I'm looking to build a trade backtester where security prices for every trading day are in a .csv file.
So basically, the program has to import all the .csv files at the very beginning or--I download data into a database once and then it's there for good?
But even in a database, Python still has to query it and in doing so, doesn't it retrieve the data into dataframes? So whether I get data into frames straight from .csv or from database, I don't clearly understand the difference.
One person told me the database takes care of parsing... how so and why?
Someone else told me on top of an already-complicated algo, the database would bog the program down more. Does that make sense or not?
Thanks for any help you can give!
I'm looking to build a trade backtester where security prices for every trading day are in a .csv file.
So basically, the program has to import all the .csv files at the very beginning or--I download data into a database once and then it's there for good?
But even in a database, Python still has to query it and in doing so, doesn't it retrieve the data into dataframes? So whether I get data into frames straight from .csv or from database, I don't clearly understand the difference.
One person told me the database takes care of parsing... how so and why?
Someone else told me on top of an already-complicated algo, the database would bog the program down more. Does that make sense or not?
Thanks for any help you can give!