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

question

Upvotes
Accepted
joneliu avatar image
16 ●0 ●1 ●3

why don't get commodities ricCode by IF2403?

this is my code to get commodities ricCode

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

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

  
                
    
                 
  1. "code":"IF","date":"Mar 24"
    2.

but I use below params , it's right

  
                
    
                 
  1. "code":"TF","date":"Mar 24"
    2.

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)?

#technologycommodities
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jirapongse avatar image   Jirapongse

@joneliu

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Jirapongse avatar image   Jirapongse

@joneliu

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

2 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@joneliu

I found this RIC in the EQUITY_QUOTES view.

The query looks like this:

df = rd.discovery.search(
    view=rd.discovery.Views.EQUITY_QUOTES,
    filter="TickerSymbol eq 'IF' and ExpiryDateString eq 'Mar 2024' and DerivedCategory eq 'Future'",
    top=10,
    select="RIC,DocumentTitle,TickerSymbol,ExpiryDateString"
)
df

To search for other items, you can use the SEARCH_ALL view.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Jirapongse avatar image
79.2k ●251 ●52 ●74

@joneliu

Thank you for reaching out to us.

If I remove the ContractMonthYear property from the filter string, I can get results. 

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

1702883074198.png

You need to contact the helpdesk team via MyRefinitiv to verify the content.


1702883074198.png (23.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

joneliu avatar image joneliu

1702951797419.png

we want to get this commodities info by IF2403

we try using your code to get info,but return new york exchange info,we want china financial futures exchange info

1702951910342.png

1702951797419.png (246.6 KiB)
1702951910342.png (66.2 KiB)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.