Excel 365 stock data for DXY

%3CLINGO-SUB%20id%3D%22lingo-sub-2093282%22%20slang%3D%22en-US%22%3EExcel%20365%20stock%20data%20for%20DXY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2093282%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3EI've%20been%20struggling%20to%20find%20the%20correct%20codes%20to%20Query%20the%20US%20Dollar%20basket%20from%20Excel%20365%20stock%20types.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20reading%20this%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fabout-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fabout-the-stocks-financial-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20experimented%20with%20every%20version%20of%20DXY%20%2F%20DX-Y%20%2F%20US%20Dollar%20Index%20%2F%20USDX%20-%20that%20i%20can%20think%20of..%20FWIW%20it%20took%20me%20ages%20to%20find%20the%20codes%20for%20VIX%20-%20%22CBOE%20MKT%20VOLATILITY%20IDX%22...%20Not%20sure%20why%20this%20is%20so%20poorly%20documented%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%20-%20I%20can%20find%20cross%20currency%20rates%20easily%2C%20but%20not%20so%20DXY%20so%20I%20would%20appreciate%20some%20help%20if%20anyone%20has%20solved%20it.%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3Et%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2093282%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2099712%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20stock%20data%20for%20DXY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099712%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F140295%22%20target%3D%22_blank%22%3E%40Tim%20Ballingall%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20those%20who%20follow%20later%20-%20the%20original%20data%20source%20is%20the%20Intercontinental%20Futures%20Exchange%20(%20ICE%20)%20and%20they%20seem%20to%20be%20pretty%20guarded%20with%20redistribution.%20Microsoft%20obtain%20their%20data%20from%20Refinitiv%20%2C%20but%20they%20don't%20seem%20to%20have%20ICE%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMore%20later%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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-477... 

 

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

1 Reply

@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