From the ICE XL Ribbon, Select Data Point
Index Mode
Symbol |
|
Symbol |
Symbols selected |
Symbol Search |
You can click
the |
Index Mode |
|
Values Ago |
The number of Values ago based on interval |
Interval |
The interval of data, options are minutes, hours, days, weeks, months |
Field |
Field to displayed |
Format Numbers |
Apply formatting to the output |
Show NA instead of empty |
Show =NA() error message instead of null |
Set as Default |
Set selected configurations as default |
Retrieve Data |
Select Retrieve Data to execute and build your Quote Table within your Excel sheet |
Date/Time Mode
Symbol |
|
Symbol |
Symbols selected |
Symbol Search |
You can click
the |
Index Mode |
|
Date Picker |
Exact Date to retrieve data from |
Interval |
The interval of data, options are minutes, hours, days, weeks, months. If minutes or hours is selected, an additional filter will be displayed for selecting time of day |
Field |
Field to displayed |
Format Numbers |
Apply formatting to the output |
Show NA instead of empty |
Show =NA() error message instead of null |
Set as Default |
Set selected configurations as default |
Retrieve Data |
Select Retrieve Data to execute and build your Quote Table within your Excel sheet |
Now Mode
Symbol |
|
Symbol |
Symbols selected |
Symbol Search |
You can click
the |
Index Mode |
|
Field |
Field to displayed. This will also include additionally fundamental fields like Expiration, Unit of Measure, Currency, Etc. |
Format Numbers |
Apply formatting to the output |
Show NA instead of empty |
Show =NA() error message instead of null |
Set as Default |
Set selected configurations as default |
Retrieve Data |
Select Retrieve Data to execute and build your Quote Table within your Excel sheet |
to access symbol search dialog