While the Total profit percentage seems to be okay for the displayed result, the Avg Daily seems to be wrong. I would have expected 0.12% .
I see. I was calculating the average daily that it references the max cost with compound interest in mind. In my opinion, the compound interest approach offers a more robust and flexible method for comparing results of different bots across different time frames, especially when dealing with significant growth rates or longer durations.
Average yearly percent change/growth rate
(1 + 1794.45 / 3334.97) ^ (365 / 359) = 1.532526... ~ +53.25%
Average daily percent change/growth rate
(1 + 1794.45 / 3334.97) ^ (1 / 359) = 1.0011994... ~ +0.12%
In comparison you calculated the percentage:
1794.45 / 3334.97 ~ 53.81% 1794.45 / 3334.97 / 359 ~ 0.15%
Of course, both of our approaches tend to highlight impressive results over short periods of time, but it’s important to remember that these results may not be sustainable. That is, a high growth rate over a short period of time may decline over time. To get a more accurate picture of long-term performance, it’s important to analyze data over longer periods of time when comparing our strategies, including market conditions.
How about including the current value, that is uPnL, in the calculation and displaying the result in a different column?