Feb 15 2020 03:47 PM
When I try to use Data Type > Stocks or Geography, it will give the correct title, stock symbol, and market. However I am not able to get any additional information (i.e. price, P/E, etc). Nor do I see the icon to the left of each ticker.
What am I missing?
Feb 17 2020 12:45 PM
Hello, based on the attached file, you aint missing anything. I am able to get additional information such as Price, Volume etc. See the caption below
Just click on the Add Column icon and select whatever information you want to view
Feb 17 2020 06:38 PM
Thanks. however I do not get those options when I insert column. I also do not see the little "house icon" to left of the companies (ie. Microsoft)
Feb 17 2020 10:02 PM
@Guido2020 Please have a look at the attached article.
It suggests that these data types are not available on Excel 2019. You may have been able to set the format but you can not pick attributes from a field list. When I open your file, being on Office365, I can see that the cells are of the Stock data type and I can see the field icon and pick the different attributes of the stock.
Feb 18 2020 07:35 PM
Thanks for your help.
That makes sense.@Riny_van_Eekelen
Feb 27 2020 09:00 AM
Any idea if Microsoft have plans on adding Stocks data type support for Excel 2019 as I am also having similar behavior and probably many others?
Feb 27 2020 11:04 AM
@rlabatia Unfortunately, I do not have the answer to your question.
Feb 27 2020 11:45 AM
Sep 11 2020 09:22 AM - edited Sep 11 2020 09:23 AM
It is indeed frustrating to read the linking ability of Excel 2016 and note that it is NOT included in 2019 ! I was reluctant to try the linking to get stock prices until I got a book on linking from Office Watch, and there they seem to describe the possibility to get data from the web, but so far I've had no luck. It strikes me that MS downgraded 2019 in order to boost the required long-term guaranteed income for MS from their Office 365 version. While I am sympathetic to the company for wanting to close the door on non-online users, I find it very disheartening that I will have to switch over to Google-Finance to achieve a goal that was once somewhat more straightforward.
Sep 11 2020 12:55 PM
Oct 05 2020 02:19 PM
@Abiola1 did you really say Hotmail! Holy cow, we are going backwards here. What can we do if we do not have an outlook account or a hotmail, are you saying we can no longer use the Excel Stock function, even though it is an icon on the toolbar? Something seems amiss
There is an icon that says stock. If you enter MSFT, you can hit the stock button and it recognizes Microsoft as a stock. Now, how might we be able to see the data for that stock, say last close price, volume, etc. Can you help?
Feb 03 2021 09:14 AM
@Riny_van_Eekelen Actually, Excel 2019 does (did) support data type Stock. I purchased Office 2019 Home and Business just for that reason. I installed Office 2019 and registered it. I then created a spreadsheet with my stock portfolio and made the stock symbol column data type Stock. It changed the ticker symbols stock names and added the house icon to the left. I was able to add columns for .price and other things. I created a macro that would refresh the prices automatically. I ran this a few times each day for a week. Then, the Stock and Geography buttons disappeared from the Data ribbon and all the stock type fields now read #VALUE!. I have tried for several days now trying to get it back. From the high number of articles about the problem that I found on Bing it seems to be a universal issue.
Mar 08 2021 05:05 PM
Jan 06 2022 11:57 AM
@Hummergeezer That is REALLY sucky that Microsoft would take away functionality which existed in an earlier product just to promote gravitation to their current product for the sake of revenue generation. I liken this to an auto manufacturer coming to your house and removing a feature from your vehicle then saying "We're allowed to do so via the EULA. Sorry. Not sorry."
Really SH****, Microsoft.