Hello,
I was curious if it is possible to get the scaling factors for cross rates through the Eikon Python API. For example, using the ek.get_timeseries method for JPYUSD returns a value of 0.89 while the real rate here should be 0.0089. I have not come across anything in the documentation that indicates whether scaling is necessary or what the scaling factor should be. Is there something I am missing here? What is the best way to recalculate these values so that they are correct?
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
1
●2 ●2 ●3
Cross Scaling Factors for Eikon API
Hi @mohit.kansal,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hello @mohit.kansal,
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
-AHS
39.4k
●77 ●11 ●27
You can use get_data method of Eikon Python API to retrieve the field named SCALING, which gives you the scaling factor for FX RICs, e.g.
ek.get_data('JPYUSD=R','SCALING')
returns 100.
4.6k
●26 ●7 ●22
Unfortunately, it is not possible with the Scripting API
The only API that currently supports reference data for FX/MM instruments is Adfin COM, through AdStyleStructure() function call, you can test it in Eikon Excel by using the following formula:
=AdStyleAttribute("CROSS","JPYUSD","QU")
Where
- CROSS - Cross-currency style table
- JPYUSD - Cross-currency code
- QU - quotation units
