Setting Up Method Calculation Period: Microsoft Excel Add-In

To set up method calculation period, use the Calculation Periods tab on the side panel. The set of parameters that determine the period of series calculation depends on the used calculation method.

Make sure that the side panel is displayed.
Select a calculated series in the data table.
Select the Series radio button on the side panel.
Go to the Calculation Periods tab.

Set the type of calculating the start calculation point:

Start of Data +/-. The date is equal to the first actual date of the input series plus the number of periods specified in the corresponding value editor.
Specific Date. The date is specified in the corresponding date editor.
Today +/-. The date is equal to the current date plus the number of periods specified in the corresponding value editor.
From Sample Period End. The start date of the sample period is equal to the end date of the sample period minus the number of periods specified in the corresponding value editor.
From Calculation End. The start date of the sample period is the end date of the calculation period minus the number of periods defined in the value editor.

NOTE. The From Sample Period End method is available if the calculated series is calculated by the regression or the forecasting method. In other cases the From Calculation End method is available.

Set the type of calculating the end point of the sample period.

Start of Data +/-. The date is equal to the first actual date of the input series plus the number of periods specified in the corresponding value editor.
End of Data +/-. The date is equal to the last actual date of the input series plus the number of periods specified in the corresponding value editor.
Specific Date. The date is specified in the corresponding date editor.
Today +/-. The date is equal to the current date plus the number of periods specified in the corresponding value editor.
From Calculation Start. The end date of the sample period is equal to the start date of the sample period plus the number of periods specified in the corresponding value editor.

NOTE. Setting the end point of the sample period is available if the calculated series is calculated by the regression or the forecasting method.

The End Of Data +/- method is used by default. The end point of sample matches the last actual date of the input series.

Set the type of calculating the end calculation point:

Display Period End. The date is equal to the end date of the workbook data display period.
Specific Date. The date is specified in the corresponding date editor.
End of Data +/-. The date is equal to the last actual date of the input series plus the number of periods specified in the corresponding value editor.
Today +/-. The date is equal to the current date plus the number of periods specified in the corresponding value editor.
From Sample Period End. The calculation end date is equal to the end date of the sample period plus the number of periods specified in the corresponding value editor.
From Calculation Start. The calculation end date is equal to the start date of the sample period plus the number of periods specified in the corresponding value editor.

NOTE. The From Sample Period End method is available if the calculated series is calculated by the regression or the forecasting method. In other cases the From Calculation Start method is available.

After changing the limits of the calculation period the calculated period should be calculated again.

Setting Up Method Calculation Period

Features of Setting Calculation Period