...
The fields currently supported include the following:
Field | Description |
|---|---|
Ask | The last Ask Price from the exchange indicating a willingness to sell at that price |
Ask Size | The total number of contracts offered at the current Ask Price |
Bid | The last Bid Price from the exchange indicating a willingness to purchase at that price |
Bid Size | The total number of contracts offered at the current Bid Price |
Change | The difference between the Last Price and the Close Price from the previous day or session |
Close | The current session's Close Price |
Description | The description of the symbol |
Exchange | The exchange or data source in which the instrument resides |
High | The highest price paid during the current trading session |
Last | The last price paid during the current trading session |
Low | The lowest price paid during the current trading session |
OI | The total number of futures contracts traded that have not yet been liquidated either by an offsetting futures transaction or by delivery |
Open | The first price paid during the current trading session |
% Change | The percentage difference between the Last Price and the Close Price from the previous day or session |
Previous | The previous trading session's Closing Price |
Prev Settle | The previous trading session's Settlement Price |
Settle | The current session's Settlement Price |
Size x Bid | Contains both the last Bid Price and the number of contracts offered at that price |
Size x Ask | Contains both the last Ask Price and the number of contracts offered at that price |
Symbol | The Barchart unique identifier which represents the symbol of a particular instrument |
Tick Dir | The symbol’s minimum upward or downward last traded price |
Time | Time of the last trade |
Underlying | A cash values deliverable futures expiration month |
Volume | The total number of contracts traded during the current trading session |
Vol Time | Time of last volume update |
Barchart for Excel Functions
...
=BCT_Daily("TSLA","Close","7/1/2020","9/20/2020",BE_ADJ_DIVIDEND()&BE_ADJ_NO_SPLIT())
Historical data by default is returned in descending order, using the Sort argument at the end of the string, data can be returned in ascending order using an “A”.
...
Below is a sample query for unadjusted ZC*0 data sorted in ascending order:
=BCT_Daily("ZC*0","Close","1/1/2024","2/7/2024",,"A")
BCS Historical Study Functions
...