Forum Discussion

Tim Ballingall's avatar
Tim Ballingall
Copper Contributor
Jan 25, 2021

Excel 365 stock data for DXY

Hi all

I've been struggling to find the correct codes to Query the US Dollar basket from Excel 365 stock types.

 

After reading this - https://support.microsoft.com/en-us/office/about-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6 

 

I have experimented with every version of DXY / DX-Y / US Dollar Index / USDX - that i can think of.. FWIW it took me ages to find the codes for VIX - "CBOE MKT VOLATILITY IDX"... Not sure why this is so poorly documented !

 

Anyway - I can find cross currency rates easily, but not so DXY so I would appreciate some help if anyone has solved it.

thanks

t

excel
Formulas and Functions
office 365
  • Tim Ballingall's avatar
    Tim Ballingall
    Copper Contributor
    Jan 26, 2021

    Tim Ballingall 

    For those who follow later - the original data source is the Intercontinental Futures Exchange ( ICE ) and they seem to be pretty guarded with redistribution. Microsoft obtain their data from Refinitiv , but they don't seem to have ICE data.

     

    More later

    • AdolfoGr's avatar
      AdolfoGr
      Copper Contributor
      Nov 17, 2022
      More than 1 year past your post and we have still the very same problem.
      Nothing seems to work, unless we go to one of the add-ins that can do that, but usually they charge a lot (either money or your data).
      I wish someone at MSFT could help 😊

Resources