Versions Compared

Key

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

...

To roll the contract forward on the current contract's expiration, enter in '0'. To roll the current contract forward on a date prior to expiration, enter in a days to expiration value. Leave this argument blank to roll forward based on combination of volume and open interest.

Equity time series data can be adjusted for both dividends and splits by opting to use either or both of the following arguments following the symbol, field, start date and end date:

BE_ADJ_DIVIDEND()

BE_ADJ_NO_SPLIT()

BE_ADJ_DIVIDEND()&BE_ADJ_NO_SPLIT())

...

Sample query for dividend adjusted and non split adjusted TSLA:

=BCT_Daily("TSLA","Close","7/1/2020","9/20/2020",BE_ADJ_DIVIDEND()&BE_ADJ_NO_SPLIT())

BCS Historical Study Functions

...