Absolute and Relative Forecast

Warning

This feature is still in Beta. We are still testing and bug fixing the problems we find. That means it can suffer breaking changes. On the other hand, if you would like to test it, we would like to hear your feedback.

This section describes about how to generate of absolute and relative forecast data with Volue Insight API add-in on excel:

Absolute Forecast

1. First, select the cell on the right side of the Absolute cell.

   

2. The absolute forecast options would appear on the right (add-in).

   

3. The first and second option are the Issue Date From and Issue Date To respectively. These allow user to pick the issue date from and to, meanwhile the default issue date is the latest.

   

4. The next option is the Date Time. The user can filter the date and time of the forecast date.

   

5. The last option is the issue frequency options, which is frequency for the output time series. Thus, user could also choose the issue frequency.

   

6. After giving the input, click Submit button.

   

7. Then, the parameter is being added on the cell.

   

8. Furthermore, you can also edit the parameters directly on the cell, or using the Clear button to remove all.

9. Finally, click the refresh or refresh all button on navigation to get the data out.

   

You can find out more about absolute forecast Volue Insight API on: https://volueinsight.com/docs/api/api-absolute-relative-forecast.html

Relative Forecast

1. To navigate the relative forecast, select the cell on the right of the Relative cell

   

2. Then the relative forecast options would appear on right (add-in).

   

3. The input form has similiarity with Absolute Forecast, such as Issue Dates picker.

   

4. There are difference features, such as the Offset and Max Length. The Offset allows user to define the data offset from the starting of issue date. Meanwhile, the Max length is to define when the subset end.

   

5. Another feature is Filter for Issue Dates, given the options of different types of time periods.

   

6. After giving the input, click Submit button.

   

7. Then, the parameter is being added on the cell.

   

8. Furthermore, we can also edit directly on the cell, or using the Clear button to remove all.

9. Finally, click the refresh or refresh all button on navigation to get the data out.

   

Warning

The Absolute and Relative forecast can not work at the same time together. Moreover, the issue dates work independently for its feature, thus it is not the same as the Issue Date on the curve table.

You can find out more about relative forecast Volue Insight API on: https://volueinsight.com/docs/api/api-absolute-relative-forecast.html