1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/DarthBen_in_Chicago
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#real-time data collaboration
#Excel compatibility
#rows.com
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#financial modeling with spreadsheets
#Excel
#stock data
#data fields
#ticker
#last price
#change
#Change (Extended hours)
#pre-market
##FIELDS error
#dashboard