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": {}
}
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.
@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.
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"
}
]
}
"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
