Connect now supports additional ways to retrieve standard Quarterly and Semi-Annual Strips. Users can now use these dynamic shortcuts that change as Contracts Expire and Drop off the strip, removing the need to update expressions each month.
Strip Definitions:
|
QUARTER1 |
F, G, H |
|
QUARTER2 |
J, K , M |
|
QUARTER3 |
N, Q, U |
|
QUARTER4 |
V, X, Z |
|
SEMIANNUAL1 |
F, G, H, J, K, M |
|
SEMIANNUAL2 |
N, Q, U, V, X, Z |
* All strips are based on Active Contracts.
Syntax:
Strips can be used in any Quote Board, Chart or Data Table. Syntax is:
=StripName(Symbol Root, Year)
Examples:
=QUARTER1(NG, 2015)
=QUARTER4('BRN-ICE', 2014) Tick marks ' ' are required around Symbol Roots with special characters such as - .
=SEMIANNUAL1(CL, 2014)
Strip Behavior:
The Strip functions are Dynamic in that they include only those contracts that are Still Active.
So at any given time when you bring up the Strip, it will only include those which are still active. You can leave them in your Workspace, and they will automatically remove expired contracts when it expires.
To view the symbols used to calculate the Strip in a Quote Board, move the mouse over the symbol field: