This is my combined spreadsheet with the following functionality:
Extract DCA bot profit information from the 3Commas History CSV
Calculate profit compounding to generate new BO & SO for all DCA bots
Evaluate total fund allocation across all bots/accounts/markets
“Recovery Grid” profit tracker for 3Commas
Evaluate number of simultaneous deals for selected bots
It’s a work in progress and comments are welcomed, and if something doesn’t make sense then please ask.
I have the export CSV to copy/paste new BO & SO process down to around 5 or 10 minutes now - this makes it realistic to do daily, and the sheet allows a quick profit check at the same time.
**This is the sheet I use to generate the data shown in this document**