How to calculate compounded profits on a given day?

[Donovan]

I think perfringo hit it off with the best practice yet. I would take their approach, it is more clean and much more effecient. I was reading a guide rom DataCamp on working with excel and importing data using python. Check that out: Here

I hope this helps, thanks for adding your code perfringo!