Home

Adding stocks to the "Stock and Geography" data base

%3CLINGO-SUB%20id%3D%22lingo-sub-320890%22%20slang%3D%22en-US%22%3EAdding%20stocks%20to%20the%20%22Stock%20and%20Geography%22%20data%20base%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320890%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EThere%20are%20some%20stocks%20that%20the%20%22Stock%20and%20Geography%22%20wouldn't%20recognize.%3CBR%20%2F%3EI%20have%20contacted%20the%20Microsoft%20help%20desk%20who%20in%20turn%20referred%20me%20to%20their%20stock%20data%20provider%20-%20Morningstar.%20In%20their%20reply%20they%20confirmed%20that%20all%20the%20stocks%20I%20require%20are%20indeed%20part%20of%20their%20followup%2C%20and%20that%20the%20issue%20is%20with%20Microsoft%2C%20however%2C%20they%20are%20reluctant%20to%20help.%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-320890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355839%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20stocks%20to%20the%20%22Stock%20and%20Geography%22%20data%20base%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ECan%20you%20please%20check%20VEIEX%20which%20is%20the%20Vanguard%20Emerging%20Market%20Stock%20Index.%20It%20is%20in%20Morningstar%20but%20I%20cannot%20get%20it%20to%20load%20in%20Excel%20using%20%22Stock%20and%20Geography%22%20database.%20Thanks%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355655%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20stocks%20to%20the%20%22Stock%20and%20Geography%22%20data%20base%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355655%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20check%20VEIEX%20which%20is%20the%20Vanguard%20Emerging%20Market%20Stock%20Index.%20It%20is%20in%20Morningstar%20but%20I%20cannot%20get%20it%20to%20load%20in%20Excel%20using%20%22Stock%20and%20Geography%22%20database.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321396%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20stocks%20to%20the%20%22Stock%20and%20Geography%22%20data%20base%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321396%22%20slang%3D%22en-US%22%3E%3CP%3EHi..%20can%20you%20please%20try%20MTL.PR%3F%3CBR%20%2F%3EThat%20is%20the%20symbol%20for%20the%20preferred%20shares%20for%20Mechel%20AO%20(Russian%20steel%20producer).%20Mechel%20is%20MTL.%20Another%20one%20FNMAS.%20This%20is%20the%20symbol%20for%20preferred%20shares%20of%20Fannie%20Mae.%20Preferred%20shares%20are%20not%20being%20picked%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321283%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20stocks%20to%20the%20%22Stock%20and%20Geography%22%20data%20base%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321283%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20reply%2C%20however%2C%20when%20I%20try%20to%20define%20LISP%20as%20a%20Stock%2C%20at%20the%20Data%20Selector%20all%20I%20get%20back%20is%20%22No%20results%20found%20for%20LISP%22%20Ofer%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321220%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20stocks%20to%20the%20%22Stock%20and%20Geography%22%20data%20base%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321220%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20only%20few%20papers%20of%20that%20company%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20413px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F69105i7130E46E4637825F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eare%20recognized%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20307px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F69106i36D6D24A84DE53F1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F133173%22%20target%3D%22_blank%22%3E%40James%20Spotanski%3C%2FA%3E%2C%20could%20you%20please%20comment%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320990%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20stocks%20to%20the%20%22Stock%20and%20Geography%22%20data%20base%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320990%22%20slang%3D%22en-US%22%3EHi%20there%2C%20Please%20try%20LISP%20(%3CSPAN%3EChocoladefabriken%20Lindt%20%26amp%3B%20Spruengli%20AG%20Participation)%20traded%20on%20the%20Swiss%20stock%20exchange%20Ofer%3C%2FSPAN%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320984%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20stocks%20to%20the%20%22Stock%20and%20Geography%22%20data%20base%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320984%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ofer%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20gives%20us%20one-two%20tickers%20in%20question%20we%20could%20try%20to%20play%20with%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ofer Pillar
Occasional Contributor

Hi,

There are some stocks that the "Stock and Geography" wouldn't recognize.
I have contacted the Microsoft help desk who in turn referred me to their stock data provider - Morningstar. In their reply they confirmed that all the stocks I require are indeed part of their followup, and that the issue is with Microsoft, however, they are reluctant to help.

Any ideas?

7 Replies

Hi Ofer,

 

If you gives us one-two tickers in question we could try to play with it.

Hi there, Please try LISP (Chocoladefabriken Lindt & Spruengli AG Participation) traded on the Swiss stock exchange Ofer

Yes, only few papers of that company

image.png

are recognized

image.png

@James Spotanski, could you please comment

Thank you for your reply, however, when I try to define LISP as a Stock, at the Data Selector all I get back is "No results found for LISP" Ofer

Hi.. can you please try MTL.PR?
That is the symbol for the preferred shares for Mechel AO (Russian steel producer). Mechel is MTL. Another one FNMAS. This is the symbol for preferred shares of Fannie Mae. Preferred shares are not being picked up.

Hello,

 

Can you please check VEIEX which is the Vanguard Emerging Market Stock Index. It is in Morningstar but I cannot get it to load in Excel using "Stock and Geography" database. Thanks

Hello,

Can you please check VEIEX which is the Vanguard Emerging Market Stock Index. It is in Morningstar but I cannot get it to load in Excel using "Stock and Geography" database. Thanks

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies