Forum Discussion

alexisonsmith's avatar
alexisonsmith
Copper Contributor
Dec 09, 2021

Commodity Prices - unable to find certain commodities or 52 week highs

Hi,

 

I have been able to find certain commodities using the Data Selector ex Gold, Silver and Platinum, however I am unable to find the following: 

- Crude Oil

- Palladium

- Wheat

- Soybean

- Corn

- Rice

- Cocao

Does anyone know how I would obtain these?

 

Also when I try to obtain a 52 week high using the following formula: =I4.[52 week high] Where I4 is Light Sweet Crude Oil (it is able to read the current price), it is unable to find the value and returns the error #FIELD!. Can anyone help with this error? 

 

Thanks

Alexander 

excel

1 Reply

Sort By
  • Fredrik_Nicklasson's avatar
    Fredrik_Nicklasson
    Copper Contributor
    Jul 17, 2022

    Hialexisonsmith 

     

    It dosent offer this for futures, when we have picked stocks its avalible.

    This is something for microsoft to lookinto, its avalible for shore at source provider Refinitiv

     

    Future Option:

     

    Stock Option

     

    Alex, could you share your file where you have capture the Community you presented.

    I have a few but I got stocked.

     

    Regards

    Fredrik Nicklasson

Resources