Confirmed. Using Close() with a negative value falls back to last value. We’ll have to investigate the reason.
Future%Chg() seems to address this. Can you just use Future%Chg for now?
Also when copy/pasting YAML files the format is very important. Always include the important sections and use the “Preformatted text” under the gear icon in the forums editor. It will make it more readable.
Thanks
Date P123 UID Ticker Close21 Future21
2023-08-05 61784 ETON 4.26 NA
2023-08-12 61784 ETON 4.26 NA
2023-08-19 61784 ETON 4.26 NA
Main:
Operation: Data
On Error: Stop # ( [Stop] | Continue )
Settings:
PIT Method: Prelim # Complete | Prelim
Start Date: 2023-08-11
#End Date: yyyy-mm-dd # optional
Frequency: 1Week
Region: United States
Currency: USD
Tickers: ETON
Ignore Errors: True
Formulas:
- Close21: Close(-21)
- Future21: Future%Chg(21)