ICE XL Time Series Function
The Time Series function can be called directly from a formula cell in ICE XL just as one would create a standard function in an Excel spreadsheet.
=ICESeries(<Array of Symbols>,<Array of Fields>,Granularity (Daily if omitted),Start Date, End date, Index)
The array of symbols/fields must be in an Excel range (for example: A1:A20).
Granularity can be set as follows:
| Granularity | |
| "S" | Second Granularity |
| "I1" | 1 Minute Granularity |
| "I60" | 1 Hour Granularity |
| "D" | Daily Granularity |
| "W" | Weekly Granularity |
| "WA" | Weekly Average of Daily values aggregation |
| "M" | Monthly Granularity |
| "MA" | Monthly Average of Daily values aggregation |
Date ranges and index work as follows:
| Date Ranges and Index | |
| Start Date Only | Returns that date only |
| End Date Only | Returns that date only |
| Start Date & Index | Returns index values after that start date |
| End Date & Index | Returns index values before that end date |
| Start Date & End Date | Returns the values between those two dates |
| Index Only | Returns the most recent values |
| Start Date & End Date & Index | Returns the values between those two dates and disregards the index value |
Optional Elements
| Optional Elements | |
| Title= | Any string that follows will be set as the title for that function |
| Snapshot= | True returns downloaded values, False (or omitted) returns default live values |
| Plot= | Vertical returns a vertical plot, Horizontal (or omitted) returns default horizontal plot |
| UseReference= | False turns off any cell referencing, True (or omitted) returns default cell referencing |
| Sort= | Ascending returns ascending dates, descending (or omitted) returns descending dates |
| Fill= | FillForward fills blank values from previous values until the latest value, FillEnd fills blank values until the end date, FillBackwards fills blank values from later values, and Interpolate fills blanks as a line between existing values. Omitting any fill options will show blanks as default. |
| TimelineMerge= | U returns the union of dates when any symbol returns values, I returns the intersection when all symbols return values, R uses the timeline from the first symbol in the list, and omitting any timeline merge option will show the default calendar option. |
| Seasonality= | True returns the output in a seasonal view, false (or omitted) returns the default output |
| DayOfWeek= | Days of the week can be shown or filtered using the corresponding number 1= Monday and 7 = Sunday. Omitting this shows the entire week. |
| Months= | Months can be shown or filtered using the corresponding number or letter. January = 0 and December = B |
| ShowSymbolDescription= | False returns the output without a description, True (or omitted) will show the symbol description |