Feb 17 2021 04:02 AM
There are several stocks that were listed on stock exchange, however, the data in excel are not updated yet. Why do we have such option in excel, if it not updated. It should drag the data live from exchange, right? Or there is somebody who updates these data manually)). Below list of stocks that were listed recently, please fix excel or your work!!!!!!!!!!
Name | Ticker | Date listed |
Playtika holding corp | PLTK | 15.01.21 |
Myte Netherlands | MYTE | 21.01.21 |
Shoals Technology | SHLS | 27.01.21 |
Telus International | Telus | 03.02.21 |
ON24 Inc | Ontf | 03.02.21 |
Sana biotechnology | Sana | 04.02.21 |
Vor bioharma | VOR | 05.02.21 |
Immunocore holdings | IMCR | 05.02.21 |
Viant technology | DSP | 10.02.21 |
Bumble Inc | BMBL | 11.02.21 |
Signify Health | Sgfy | 11.02.21 |
Feb 20 2021 03:37 AM
Agree. this has been a problem for long, so I started using online platforms to play with my portfolio data instead, but would be nice that this was automated.
Mar 09 2021 02:32 PM
Perhaps the same case as here Excel and the NYSE - Microsoft Tech Community
Mar 09 2021 11:39 PM
Mar 10 2021 02:08 AM
Data for this service is provided by Refinitiv About the Stocks financial data sources - Office Support (microsoft.com) , have no idea how they are collecting the data. In any case it's better to send feedback using this option within Excel and/or in comments to blog about the function on this resource.
Mar 10 2021 06:52 AM
Mar 16 2021 10:22 AM
I'm not working for Microsoft and to contact with them you the same channels as you are (Feedback, etc), thus can't help more.
Dec 23 2022 08:44 AM
This is still happening as of Dec 23, 2022. I have to select every Stock ticker cell and press F2 to get the corresponding Price and other cells to update. The Prices etc. do not update automatically or by pressing F9. So, everything is manual.
As a subissue, most tickers do allow me to update at least with the F2 method. But when I press F2 in a ticker cell with the S&P 500 ticker (which Excel deems to be "S&P 500 INDEX"), I get the Data Selector sidebar with its recommended ticker options, which requires me to reenter "S&P 500 INDEX" into the cell every time. Other tickers do at least update with the simple F2 procedure.
I did give Feedback just now using the link in Data Selector, noting that the update issue has been on the Internet for years now. Whether it will do any good...