ELPROXYCLEANQUANTITIES

Summary

The function ELPROXYCLEANQUANTITIES is a help function, which provides a simplified way to handle quantities. This functions also checks for null or empty strings.

Examples

=ELPROXYCLEANQUANTITIES(A1) or =ELPROXYCLEANQUANTITIES(A1, "")

Returns a verified version of the quantity in A1. If the value referenced in the second parameters is empty or null, this value is discarded.

=ELPROXYCLEANQUANTITIES(A1, B2)

In this case, the function overrides the quantity in A1 and returns a checked version of the quantity in B2. This allows an override of the quantity in A1, for example in the case where a proxy asset is used.

Syntax

ELPROXYCLEANQUANTITIES(quantityMain, quantityOverride)

Argument name	Description
quantityMain	A main quantity.
quantityOverride	A replacement quantity.