Getting currency code for a security
When I request the currency of a RIC like DTEGn.DE using the Eikon Data API using Python (streaming MarketPrice domain), I don't get back the ISO code (EUR) but a number (978). How can I translate this into the ISO currency code string?
Similar problems are found with other fields, e.g. CF_EXCHNG for the name of the exchange the security is traded on.
Best Answer
The logic of enumerated values you find in the enumtype.def file that can be located in the default Thomson Reuters Eikon location:
\AppData\Local\Thomson Reuters\Eikon User\Cache\UUID\PersistentFiles\Config\RealTime
Thanks. How can I programmatically derive the UUID to be included in the above path?
Try this:
from winreg import *
import xml.etree.ElementTree as ET
registry = ConnectRegistry(None, HKEY_CURRENT_USER)
rawkey = OpenKey(registry, r"Software\Thomson Reuters\DumpUploader")
val = QueryValueEx(RawKey, "FilePath")[0]
root1 = ET.parse(val.split("LibraryCache")[0] + "LMO.LatestUserAccount.xml").getroot()
enumtype = val.split("LibraryCache")[0] + (root1.attrib['uuid'] + r"\PersistentFiles\Config\RealTime\Display Templates" + r"\enumtype.def")