Home

Data Type Stocks not working in Excel 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-1175829%22%20slang%3D%22en-US%22%3EData%20Type%20Stocks%20not%20working%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1175829%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20use%20Data%20Type%20%26gt%3B%20Stocks%20or%20Geography%2C%20it%20will%20give%20the%20correct%20title%2C%20stock%20symbol%2C%20and%20market.%26nbsp%3B%20However%20I%20am%20not%20able%20to%20get%20any%20additional%20information%20(i.e.%20price%2C%20P%2FE%2C%20etc).%26nbsp%3B%20Nor%20do%20I%20see%20the%20icon%20to%20the%20left%20of%20each%20ticker.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20am%20I%20missing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1175829%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178157%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Type%20Stocks%20not%20working%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F559037%22%20target%3D%22_blank%22%3E%40Guido2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%20based%20on%20the%20attached%20file%2C%20you%20aint%20missing%20anything.%20I%20am%20able%20to%20get%20additional%20information%20such%20as%20Price%2C%20Volume%20etc.%20See%20the%20caption%20below%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abiola1_0-1581972250818.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171522iD089D445526D3A66%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Abiola1_0-1581972250818.png%22%20alt%3D%22Abiola1_0-1581972250818.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJust%20click%20on%20the%20Add%20Column%20icon%20and%20select%20whatever%20information%20you%20want%20to%20view%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178571%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Type%20Stocks%20not%20working%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178571%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%26nbsp%3B%20however%20I%20do%20not%20get%20those%20options%20when%20I%20insert%20column.%26nbsp%3B%20I%20also%20do%20not%20see%20the%20little%20%22house%20icon%22%20to%20left%20of%20the%20companies%20(ie.%20Microsoft)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1178663%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Type%20Stocks%20not%20working%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1178663%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F559037%22%20target%3D%22_blank%22%3E%40Guido2020%3C%2FA%3E%26nbsp%3BPlease%20have%20a%20look%20at%20the%20attached%20article.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20suggests%20that%20these%20data%20types%20are%20not%20available%20on%20Excel%202019.%20You%20may%20have%20been%20able%20to%20set%20the%20format%20but%20you%20can%20not%20pick%20attributes%20from%20a%20field%20list.%20When%20I%20open%20your%20file%2C%20being%20on%20Office365%2C%20I%20can%20see%20that%20the%20cells%20are%20of%20the%20Stock%20data%20type%20and%20I%20can%20see%20the%20field%20icon%20and%20pick%20the%20different%20attributes%20of%20the%20stock.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1180989%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Type%20Stocks%20not%20working%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1180989%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3CP%3EThat%20makes%20sense.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1198754%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Type%20Stocks%20not%20working%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1198754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20if%20Microsoft%20have%20plans%20on%20adding%20Stocks%20data%20type%20support%20for%20Excel%202019%20as%20I%20am%20also%20having%20similar%20behavior%20and%20probably%20many%20others%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1199087%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Type%20Stocks%20not%20working%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1199087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F569806%22%20target%3D%22_blank%22%3E%40rlabatia%3C%2FA%3E%26nbsp%3BUnfortunately%2C%20I%20do%20not%20have%20the%20answer%20to%20your%20question.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1199205%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Type%20Stocks%20not%20working%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1199205%22%20slang%3D%22en-US%22%3EIn%20addition%20to%20Riny's%20reply%2C%20the%20Data%20Type%20will%20have%20to%20be%20made%20available%20to%20Microsoft%20Office%202019%20Pro%20Plus%20subscribers%20before%20it%20finally%20gets%20to%20Standard..%20Making%20Dynamic%20Array%20functions%20and%20XLOOKUP%20and%20XMATCH%20available%20to%20other%20office%20365%20channels%2C%20is%20arguably%2Cthe%20priority%20%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20addition%2C%20the%20Data%20Type%2C%20as%20I%20just%20noticed%20on%20my%20Insiders%20edition%20of%20Office%20365%2C%20is%20undergoing%20more%20enhancement.%20So%2C%20all%20this%20features%20will%20have%20to%20get%20fully%20flighted%20to%20other%20channels%20before%20Microsoft%20look%20at%20Office%202019%20direction%20to%20have%20them...%3CBR%20%2F%3E%3CBR%20%2F%3EFinally%2C%20if%20you%20have%20the%20means%2C%20you%20can%20upgrade%20to%20Office%20365%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?

7 Replies
Highlighted

@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

Abiola1_0-1581972250818.png

 

Just click on the Add Column icon and select whatever information you want to view

Highlighted

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) 

Highlighted

@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-8a... 

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.

 

Highlighted

Thanks for your help.

That makes sense.@Riny_van_Eekelen 

Highlighted

@Riny_van_Eekelen 

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?

Highlighted

@rlabatia Unfortunately, I do not have the answer to your question.

Highlighted
In addition to Riny's reply, the Data Type will have to be made available to Microsoft Office 2019 Pro Plus subscribers before it finally gets to Standard.. Making Dynamic Array functions and XLOOKUP and XMATCH available to other office 365 channels, is arguably,the priority

In addition, the Data Type, as I just noticed on my Insiders edition of Office 365, is undergoing more enhancement. So, all this features will have to get fully flighted to other channels before Microsoft look at Office 2019 direction to have them...

Finally, if you have the means, you can upgrade to Office 365
Related Conversations
Calculating months, days, hours, minutes, seconds in Excel
Jo_666 in Excel on
0 Replies
terrible web page code in this forum.
jitterbug888 in Excel on
0 Replies
Need to remove the numbers after the decimal.
cmoran in Excel on
1 Replies
AREA CODE
ATurner876 in Excel on
0 Replies