Quotations
With the quotation feature a new dimension of time is added to a time series.
Creating a Quotation Time Series
To create a quotation time series, you must ensure that an archive table (FWT_TSQUOTATIONARCHIVE or FWT_TSQUOTATIONCOMPRESSEDARCH are the default values) is specified. This can easily be done using the checkbox "Quotation".
When creating a quotation time series the field "Table" has to be empty!
In addition, after activating the "Quotation" checkbox, a default quotation behavior can be selected for the time series:
For more detailed information about "Default Quotation Behavior", please visit: Audit and Quotation
Saving Data on a Quotation Time Series
To save data on a quotation time series you have to set the additional dimension too. In Excel templates this is done in line 13:
The format is mm.dd.yyyy hh:mm:ss AM/PM,exact.
Reading Data from a Quotation Time Series
Similar to "Audit" different versions of a quotation time series can be read. This works either via the Excel template (same as with "Saving Data on a Quotation Time Series") or via the time series plug-in. It is also possible to read data using a combination of audit and quotation.
Via the drop down "Quotation" one of the following options can be selected:
Version at (exact) | A quotation time of this time series can be selected from a drop-down list. The version will be read for this exact time. |
Version before (exact) | A quotation time of this time series can be selected from a drop-down list. The version will be read for this exact time. Additionally it is possible to specify how many preceeding versions should be read out. |
Most recent at (not exact) | A quotation time of this time series can be selected from a drop-down list. Over the Date-Time-Picker choosing a date and time is also possible. If a date of which there is no version is selected, the last valid version will apply. |
Most recent before (not exact) | A quotation time of this time series can be selected from a drop-down list. Using the Date-Time-Picker choosing a date and time is also possible. If a date of which there is no version is selected, the last valid version will apply. Additionally it is possible to specify how many preceeding versions should be read out. |
The Difference Between Quotation Options "exact" and "not exact"
When reading out a quotation time series using the exact time of a quotation, only the values at this exact time are read out. When reading out a quotation time series without an exact time (not exact), values of earlier versions will be loaded for values that are missing at the selected quotation time.
Example:
| Time of Quotation | Period with Valid Values |
|---|---|
1/1/2018 00:00:00 | 1/1/2018 12:00:00 AM – 1/4/2018 12:00:00 AM |
1/2/2018 00:00:00 | 1/2/2018 12:00:00 AM – 1/5/2018 12:00:00 AM |
1/3/2018 00:00:00 | 1/3/2018 12:00:00 AM – 1/6/2018 12:00:00 AM |
| Time of Quotation | 1/3/2018 12:00:00 AM,exact | ||||||
|---|---|---|---|---|---|---|---|
| Selected Period | 1/1/2018 12:00:00 AM – 1/6/2018 12:00:00 AM | ||||||
| Output |
|
| Time of Quotation | 1/3/2018 12:00:00 AM,not exact | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Selected Period | 1/1/2018 12:00:00 AM – 1/6/2018 12:00:00 AM | ||||||||
| Output |
|
Combination with Audit
If only one version is selected, it is always read with the current state. But it is possible to combine quotation and audit (only when using exact times of quotation).
Example:
