Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

=BET_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 TSLA data sorted in ascending order:

=BET_Daily("TSLA","Close","1/1/2024","2/5/2024",,"A")

BES Historical Study Functions

...

Below are the available equity option time and sales fields:

Last

LastSize

Exchange

Bid

BidSize

BidExchange

Ask

AskSize

AskExchange

TradeCondition