Hello Team, Can you please help me in understanding why does this excel behave this way?
The client is reporting that a historical formula is updating unexpectedly when it should not.
Specifically:
- When invalid (nonexistent) RICs are included in the formula range:
- The historical formula initially behaves correctly, but then updates on its own after a few minutes (unexpected behavior).In other words, it keeps on updating even if there is no new data.
- When those invalid RICs are removed from the range:
- The formula does not update, which is the expected behavior.
=@RDP.HistoricalPricing($A$5:$A$592,"CLOSE;ACVOL_UNS;VWAP","SOURCE:RFV START:"&$A$1&" END:"&$B$1&" INTERVAL:P1D",,"TSREPEAT:NO SORT:ASC CH:IN;Fd RH:Timestamp",G5)
The range contains invalid RICs such as ARTFU2D1=BA
This issue was initially raised to a lead specialist, and he mentioned that an excel formula shouldn't be behaving this way. And after hours of investigation, he concluded that he think it is because the excel range has an Invalid RIC.
Can you please help me to verify this one? Thank you so much
