Use a formula to modify and combine data series.
For example, invert an exchange rate a by using formula 1/a, or
calculate the spread between 2 interest rates a and b by using formula a - b.
Step 1.
Add Data Series to This Line:
Note that you can only add data series matching the frequency of previous data series added to this line (i.e. "Quarterly, End of Period" data series).
Search:
Step 2. Edit Formula to Specify How to Combine Data Series:
Use the assigned data series variables above (e.g. a, b, ...) together with operators {+, -, *, /, ^}, braces {(,)}, and constants {e.g. 2, 1.5}
to create your own formula {e.g. 1/a, a-b, (a+b)/2, (a/(a+b+c))*100}. The default formula 'a' displays only the first data series added to this line.