We use API search function to retrieve data, but it returns unknown property 'ProviderSymbol'. Th...

xuke

...e field in Eikon Client is "PROV_SYMB"

df = rd.discovery.search(

view=rd.discovery.Views.COMMODITY_QUOTES,

top=10,

filter="(ProviderSymbol eq 'm2401')",

select="ProviderSymbol,RIC"

)

{

"return_code": 500,

"return_info": "Error code 400 | Invalid filter: unknown property 'ProviderSymbol'",

"result": {}

}

Jirapongse

@xuke

Thank you for reaching out to us.

This ProviderSymbol is not a valid field in the COMMODITY_QUOTES.

You can use the following code to the all available fields in the COMMODITY_QUOTES.

response = search.metadata.Definition(
    view = search.Views.COMMODITY_QUOTES  # Required parameter
).get_data()

response.data.df

I tried m2401 in Eikon and it doesn't show anything.

xuke

https://community.developers.refinitiv.com/discussion/comment/108623#Comment_108623

@Jirapongse thanks. I asked another question is related to this question. Could you have a look at it? (https://community.developers.refinitiv.com/questions/108440/how-to-use-eikon-api-to-get-commodities-ric-code-b.html) I got a reply to use search function to get the RIC code.

Jirapongse

@xuke

I assume that m2401 is from Ticker (M) and Expirate Date (Jan 24).

If my assumption is correct, the seach query should be:

{
  "View": "CommodityQuotes",
  "Filter": "TickerSymbol eq 'M' and ContractMonthYear eq 'Jan 24' and AssetStateName eq 'Active' and RCSAssetCategoryLeaf xeq 'Commodity Future' and ExpiryDateString ne null",
  "Select": "DocumentTitle,RIC,AssetType,ContractMonthYear,Periodicity,RCSAssetCategoryLeaf,RCSAssetClass,RCSCurrencyLeaf,ExchangeCode,ExpiryDateString"
}

The output is:

{
  "Total": 1,
  "Hits": [
    {
      "DocumentTitle": "DCE Soybean Meal Commodity Future Jan 2024, Commodity Future, Dalian Commodity Exchange",
      "RIC": "DSMF4",
      "AssetType": [
        "DERIVATIVE"
      ],
      "ContractMonthYear": "Jan 24",
      "Periodicity": "Irregular",
      "RCSAssetCategoryLeaf": "Commodity Future",
      "RCSAssetClass": "FUT",
      "RCSCurrencyLeaf": "Chinese Yuan",
      "ExchangeCode": "DLC",
      "ExpiryDateString": "15 Jan 2024"
    }
  ]
}

joneliu

https://community.developers.refinitiv.com/discussion/comment/108629#Comment_108629

"TickerSymbol eq 'M' and ContractMonthYear eq 'Jan 24' and AssetStateName eq 'Active' and RCSAssetCategoryLeaf xeq 'Commodity Future' and ExpiryDateString ne null",

Hi , I want to replace 'TickerSymbol' with 'TradingSymbol’, but It's not valid.

What is the solution to solve it

joneliu

https://community.developers.refinitiv.com/discussion/comment/112041#Comment_112041

@Jirapongse Can you help me solve this problem

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/112034#Comment_112034

@joneliu

I couldn't find this "TradingSymbol" field in the CommodityQuotes.

joneliu

https://community.developers.refinitiv.com/discussion/comment/112141#Comment_112141

@Jirapongse

this is my code to get commodities ricCode

filter="TickerSymbol eq '" + code + "' and ContractMonthYear eq '" + date + "' and AssetStateName eq 'Active' and RCSAssetCategoryLeaf xeq 'Commodity Future' and ExpiryDateString ne null",

I use below param to get code , it will return error messges.

"code":"IF","date":"Mar 24"

but I use below params , it's right

"code":"TF","date":"Mar 24"

They are all commodities codes I found on the Internet, I can see price info in other web by IF2403，TF2403,

Why is using the first code problematic(IF2403)?

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/112347#Comment_112347

@joneliu

The accepted question will not be monitored.

Please create a new question for this new problem.

joneliu

https://community.developers.refinitiv.com/discussion/comment/112353#Comment_112353

@Jirapongse https://community.developers.refinitiv.com/questions/112386/why-dont-get-commodities-riccode-by-if2403.html

this is my new question for this