Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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": {}
}
Hi @xuke ,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
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
