...
(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)
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 and 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:
=BEH_Daily_Close("TSLA","8/31/2020",BE_ADJ_DIVIDEND()&BE_ADJ_NO_SPLIT())
BEH Date Function Document
Below is a text document that contains all of the Barchart for Excel Historical date functions. Copy and paste any of the functions into Excel (with a ‘equals sign’ prefix) to quickly pull in data into your spreadsheet.
...
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 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 and 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:
=BET_Daily("TSLA","Close","7/1/2020","9/20/2020",BE_ADJ_DIVIDEND()&BE_ADJ_NO_SPLIT())
BES Historical Study Functions
...