SOLVED
Home

Excel stock quotes defaulting to US stocks for UK codes

%3CLINGO-SUB%20id%3D%22lingo-sub-307301%22%20slang%3D%22en-US%22%3EExcel%20stock%20quotes%20defaulting%20to%20US%20stocks%20for%20UK%20codes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307301%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20way%20to%20force%20the%20stock%20data%20converter%20to%20treat%20my%20codes%20as%20UK%3F%20For%20example%20I%20have%20ATR%20which%20as%20ATR.L%20is%20Shroder%20Asian%20Total%20Return.%20However%20it%20has%20come%20up%20with%20Aptar%20Group%20which%20is%20the%20NYSE%20ATR%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMakes%20it%20completely%20useless.%26nbsp%3B%20Also%20several%20of%20my%20codes%20have%20not%20found%20results%20despite%20me%20looking%20them%20up%20on%20Bing%20and%20Morning%20Star%20as%20correct%20codes%20e.g%20ABAA.L%20is%20Aberdeen%20Japan%20Investment%20Trust.%26nbsp%3B%20Basically%20of%2045%20UK%20stocks%2C%202%20not%20found%20and%206%20using%20US%20stock%20instead.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20anywhere%20to%20make%20a%20suggestion%20to%20include%20bid%20and%20offer%20as%20last%20price%20is%20not%20necessarily%20useful%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307301%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307450%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stock%20quotes%20defaulting%20to%20US%20stocks%20for%20UK%20codes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307450%22%20slang%3D%22en-US%22%3E%3CP%3EMike%2C%20I%20don't%20think%20so.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20sure%20stocks%20were%20not%20found%20are%20trading%20right%20now%3F%20Back%20to%20your%20example%2C%20Morningstar%20shows%20nothing%20for%20ABAA%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20686px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64367iA6B09B9B08D062A1%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%3ECompare%20to%20ATR%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20916px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64368iBC9D399FFE354F06%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%3EExcel%20takes%20data%20from%20Morningstar.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307445%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stock%20quotes%20defaulting%20to%20US%20stocks%20for%20UK%20codes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307445%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20way%20to%20request%20tickers%20that%20are%20not%20recognised%20to%20be%20added%3F%26nbsp%3B%20They%20are%20all%20conventional%20UK%20main%20market%20stocks%20so%20bit%20surprised%20they%20aren't%20coming%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThnaks%3C%2FP%3E%3CP%3EMike%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307424%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stock%20quotes%20defaulting%20to%20US%20stocks%20for%20UK%20codes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307424%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Mike%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%26nbsp%3Bmay%20add%20the%20country%20for%20better%20recognition%20like%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%2F64364i9E2429BAC0AD8AA2%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%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712497%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stock%20quotes%20defaulting%20to%20US%20stocks%20for%20UK%20codes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712497%22%20slang%3D%22en-US%22%3E%3CP%3ESergey%2C%20is%20there%20any%20way%20to%20trach%20ETFs%20and%20government%20bonds%20by%20ISIN%20(I%20believe%20it%20is%20a%20unique%20global%20ID)%2C%20e.g.%20ISIN%20DE0001135408%20-%20german%20government%20bonds%20traded%20on%20TRAX%3F%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-714042%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stock%20quotes%20defaulting%20to%20US%20stocks%20for%20UK%20codes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-714042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364218%22%20target%3D%22_blank%22%3E%40A_Kashubsky%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20never%20heard%20what%20Microsoft%20support%20ISIN%3C%2FP%3E%3C%2FLINGO-BODY%3E
Mike Asplin
New Contributor

Any way to force the stock data converter to treat my codes as UK? For example I have ATR which as ATR.L is Shroder Asian Total Return. However it has come up with Aptar Group which is the NYSE ATR code.

 

Makes it completely useless.  Also several of my codes have not found results despite me looking them up on Bing and Morning Star as correct codes e.g ABAA.L is Aberdeen Japan Investment Trust.  Basically of 45 UK stocks, 2 not found and 6 using US stock instead. 

 

Also anywhere to make a suggestion to include bid and offer as last price is not necessarily useful

5 Replies
Solution

Hi Mike

 

You may add the country for better recognition like

image.png

 

Is there any way to request tickers that are not recognised to be added?  They are all conventional UK main market stocks so bit surprised they aren't coming up.

 

Thnaks

Mike

Mike, I don't think so.

 

Are you sure stocks were not found are trading right now? Back to your example, Morningstar shows nothing for ABAA

image.png

Compare to ATR:

image.png

Excel takes data from Morningstar.

Sergey, is there any way to track ETFs and government bonds by ISIN (I believe it is unique global ID), e.g. ISIN DE0001135408 - german government bonds traded on TRAX?@Sergei Baklan 

@A_Kashubsky 

 

I never heard what Microsoft support ISIN