I’m looking for help with my project. I have collected data for a stock using stock history. I’m looking for formula on how to get the share price on a specific day ie 5 years ago. My question was why such an important field as price (i would say the most important field for stocks data type) is not present, while other fields are (as you could see). From your description, you found that your stock price in your excel workbook is not working as you noticed that the formula was changed. I also did some tests with my serval. But the results of the query in excel does appear # value, as shown in the column d is the msft stock price query results, display normal): Based on the following. Per the description shared, i would like to summarize your concern i. e. , the data type roche holding ltd (xswx:ro) is showing the wrong price. If my understanding is.

The stock's trading symbol. The current stock price. The stock's closing price on the previous trading day. How to refresh stock data in excel disclaimer: I am waiting (along with all other 365 subscribers being impacted) for an estimated time to resolve this issue. Please follow up with the msft development team and. Get a stock quote. Based on this article about the stocks financial data sources, some market places could also take up to entire day (end of day)in order to get the latest.

-