Custom DCA Calculation Issue

[d_yo_r]

Bot need taking DCA orders as per my strategy

How do you calculate the deviation? Do you sum the deviations like -1% + -2% + -3% = -6% or do you convert them to change factors and multiply them -1% * -2% * -3% = 0.99 * 0.98 * 0.97 = 0.941094 = -5.8906%

It’s done by multiplication.

  -2%  * -3%
= 0.98 * 0.97
= 0.9506
= -4.94%

That is, please update your Office spreadsheet accordingly.