Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Syntax

Chart.DataManipulator.FinancialFormula(
    FinancialFormula.RateOfChange,
    "Period",
    "Price",
    "Rate")

Parameters

This formula takes one optional parameter.

Period
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
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
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:

2012-08-02
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.