Forum Discussion

Guido2020's avatar
Guido2020
Copper Contributor
Feb 15, 2020

Data Type Stocks not working in Excel 2019

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...
excel
Abiola1's avatar
Abiola1
MVP
Feb 17, 2020

Guido2020 

 

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

  • Guido2020's avatar
    Guido2020
    Copper Contributor
    Feb 18, 2020

    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) 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Feb 18, 2020

      Guido2020 Please have a look at the attached article.

      https://support.office.com/en-us/article/excel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877 

      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.

       

      • champracer29's avatar
        champracer29
        Copper Contributor
        Mar 09, 2021
        OH WOW.... I bought the upgrade to 2019 to have update STOCKs for my portfolio and now MICROSOFT didn't tell us that STOCK update tools don't include?! Not cool at all... Gonna refund the money. SMH

Resources