Versions Compared

Key

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

...

(Note: Using weekly and higher aggregations will require the correct start date to properly pull in the data. Example, for last week's weekly close, Monday's date will have to be entered) 

Futures data as of a date can be adjusted for both the ‘nearest’ and ‘continue’ aggregations based on roll options: days to expiration and volume and open interest.

...

To view historical data where the underlying future rolled on expiration, enter in '0'. To roll the historical data based on a date prior to expiration, enter in a days to expiration value. Leave this argument blank to roll based on a combination of volume and open interest.

Equity data as of a date can be adjusted for both dividends and splits by opting to use either or both of the following arguments following the symbol,:

BE_ADJ_DIVIDEND()

BE_ADJ_NO_SPLIT()

BE_ADJ_DIVIDEND()&BE_ADJ_NO_SPLIT())

...

Sample query for dividend adjusted and non split adjusted TSLA:

=BCH_Daily_Close("TSLA","8/31/2020",BE_ADJ_DIVIDEND()&BE_ADJ_NO_SPLIT())

BCH Date Function Document

...