Percent Difference [%Diff]

Return to Complete List of Functions

The Percent Difference function calculates the percent difference between two values, using one of the values as the base for the percentage.. Parameters ------------------ Differenced Value    The value that the percent difference is being determined for. Base Value              The value that the percent difference is being based on. Both values can be any combination of raw data, calculated values, or constants. Function Value ------------------------ This function subtracts the base value from the differenced value and divides the result by the base value. The result is the percentage by which the base value would have to be changed to obtain the differenced value. Since this function uses division, if the base value is 0, a null value will be returned. Usage ---------- This function is useful for extracting the predicted percent change from predicted fields. To do this, specify the predicted value as the differenced value and the current value of the desired output as the base value. Example: Percent Difference(Predicted Close, Close) returns the predicted percent change in the closing price.