| |
When a historical query is placed on an Excel spreadsheet, ExcelTools uses a "field ID" to identify the data to place in the cell. When using Plain or Bold Headers, the header identifies the data field:
When using Hidden Headers, the Field ID is embedded in the function. In this example, "Open" is the Field ID:
- Fields have a number of alias names. "Last", "Last Price", " p", "price", "lastprice" all reference the same data.
- Field IDs can be entered with capitalization or lowercase. "Open Interest", "open interest", "Open interest", and "OPEN INTEREST" are all used to reference the same data.
- Use of a space between words is optional. "MID POINT" and "MIDPOINT" reference the same data.
| Display Field |
Description |
Field IDs (FIDs) |
|
Date
|
The date for the historical data set. This field is ALWAYS added to a historical query and cannot be removed.
|
Date
|
| Close |
The closing (settlement) price for the session. |
Close, pc, prevclose, previoussettle, prevsettle |
| High |
The high price for the session. |
High, h |
|
Low
|
The low price for the session.
|
Low, l
|
|
Mid Point
|
The Average Price for the session (High + Low / 2)
|
MidPoint, mp, mpoint
|
|
Open
|
The open price for the session.
|
Open, o
|
|
Open Interest
|
The number of open positions for the contract.
|
OpenInterest, oi, opint
|
|
Volume
|
The number of contracts traded for the session.
|
Volume, tc, totalvol, tvol, vol
|
|
