Excel stock data fields changing during the day or disappear from the field list
(The screenshots are in this automod-removed post!)
Hello! I recently noticed that some of the data labels that are used tend to change during the day. For example, using ticker FNCL, I pull the [last price] and the [change] in price. Works fine all the time until this week. For this ticker, the [Change] field won't work after hours, but [Change (Extended hours)] during actual extended hours, but right now (during pre-market), neither of those fields are actually listed in the field list right now. Due to the missing fields, my dashboard returns the #FIELDS error throughout. I know I can fix that if IFERROR and other methods, but I'm more curious if anyone has a solution for the fields actually persisting? Perhaps it's a bug with Refinitiv.
[link] [comments]
Want to read more?
Check out the full article on the original site