Export (0) Print
Expand All

Rate of Change Formula

The rate of change formula calculates the rate of price change compared with historical data. It differs from the Performance Formula in that it calculates the rate of change against a period of days prior to the current price. The output is a percentage.

This formula can also be used to calculate the rate of volume change.




This formula takes one optional parameter.

Number of days prior to the current day. The formula uses the data from that day as a reference when calculating the current rate of change. The default value is 10.

Input Values

This formula takes one input Y value.

Price for which the rate of change is calculated. It can be any other data for which you wish to calculate the rate of change, such as volume.

Output Value

This formula outputs one Y value.

Rate of change indicator.

The Line chart type is a convenient chart type to display the formula output.

The following example takes input from Series1's Y value for the daily close price (Series1:Y4), and outputs the rate of change on Series3 (Series3:Y). It uses data from 5 days prior to the current date as the reference.

Chart1.DataManipulator.FinancialFormula (FinancialFormula.RateOfChange, 5, "Series1:Y4", "Series3:Y");

Build Date:

© 2015 Microsoft