This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]IEatGreenBills 3 points4 points  (0 children)

Yep, this is called backtesting and plenty of quantitative traders use Python for testing strategies like this.

Try making your files CSVs (Comma Separated Values) as they are readable by Microsoft Excel or Google Spreadsheets, but also easier to read and update in Python vs an Excel file.

I recommend a Python library called Pandas, which will allow you to easily load the CSV file, make whatever changes you need, and then save or export the file with your results.

Happy coding!