Function
Data Point Detail
=@ICEHistory("BBG02037XBR8","Bid Price EOD Close","DF",DATE(2026,3,24)+TIME(12,0,0),,,-1)
=@ICEHistory(Symbol,Field, Granularity ,DateTime,Index, Reserved ,DateType)
Granularity
| Code | Granularity / Description |
| 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) |
You can also add a modifier to the Granularity how to fill an empty value
| Code | Fill Method Description |
| F | Fill Forward |
| B | Fill Backward |
| E | Fill from End |
| I | Fill Interpolate |
Datetime- If using specific Date or Time
3/2/26 or 3/2/26 12:00:00
Index- If using Index value
5 for previous 5th value. If Aggregation = Day, this is 5 days ago
Reserved- This is Reserved, leave blank
Data Type
| Code | Time Reference Description |
| -1 | Default |
| 0 | Exchange Time |
| 1 | Interval Start |
| 2 | Interval End |
| 3 | Interval Start–End |
Note: This option is only available for certain data type, for example Weather.