Absolute and relative forecasts

This guide shows how to load absolute and relative forecast data with the add-in.

Caution

Absolute and relative forecasts cannot be used at the same time. Their issue dates work independently of each other, and are not the same as the Issue Date on the curve table.

Absolute forecast

1. Select the cell to the right of the Absolute cell.

   

2. The absolute forecast options appear in the add-in panel.

   

3. Pick the Issue Date From and Issue Date To. By default, the latest issue date is used.

   

4. Optionally filter the forecast by Date Time.

   

5. Optionally choose the issue frequency, which is the frequency of the output time series.

   

6. Click Submit.

   

7. The parameters are added to the cell.

   

   You can edit the parameters directly in the cell, or click Clear to remove them all.

8. Click refresh or refresh all in the top bar to load the data.

   

Learn more about absolute forecasts in the API documentation.

Relative forecast

1. Select the cell to the right of the Relative cell.

   

2. The relative forecast options appear in the add-in panel.

   

3. Pick the issue dates, as for absolute forecasts.

   

4. Set the Offset and Max Length. The offset is where the data starts, measured from the issue date. The max length sets where the subset ends.

   

5. Optionally use Filter for Issue Dates to limit issue dates to specific time periods.

   

   

6. Click Submit.

   

7. The parameters are added to the cell.

   

   You can edit the parameters directly in the cell, or click Clear to remove them all.

8. Click refresh or refresh all in the top bar to load the data.

   

Learn more about relative forecasts in the API documentation.