Hi!

Could somebody please tell me a bit more about the calculation expression blocks? When I'm building a strategy, I really try to avoid them since they tend to crash strategies when testing. So im basically down to using multiple calculation blocks, even when the calculation expression blocks seem to be much more efficient.

As an example, I tried to get an average of 5 values. So cell A1 till A5 contained the doubles that needed averaging, and A6 contained the value 5 (First as a hard value, afterwards as a variable), but I can't test the strategy anymore (ends as soon as I try to start it, seems like an error to me). Tried 2 different formulas:
- ((a1+a2+a3+a4+a5)/a6)
-((((((a1)+a2)+a3)+a4)+a5)/a6)

It didn't work, so I ended up using 4 calculation blocks, 3 for adding everything up and 1 for dividing it by five....

Would appreciate some info on them

Kind regards,

Koen

Hi,

I don't see any issue with the calculation block and the formula "((a1+a2+a3+a4+a5)/a6)" is fine. You can even remove the brackets : "(a1+a2+a3+a4+a5)/a6"
I believe the error that you've got is more related to the variables (a1, a2,...) that you use for your formula. probably some variables are not defined at all (undetermined by the system). To check that, I need to see the strategy.

Cheers

Hi,

We've improved the brackets display in this block for your convenience: