Forum Discussion

Mike Asplin's avatar
Mike Asplin
Copper Contributor
Dec 28, 2018
Solved

Excel stock quotes defaulting to US stocks for UK codes

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 c...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 29, 2018

    Hi Mike

     

    You may add the country for better recognition like

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 29, 2018

Hi Mike

 

You may add the country for better recognition like

 

A_Kashubsky's avatar
A_Kashubsky
Copper Contributor
Jun 20, 2019

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?SergeiBaklan 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 21, 2019

    A_Kashubsky 

     

    I never heard what Microsoft support ISIN