For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
4 2 3 4

How to tell that a quote is in pennies

Certain markets price securities in pennies (e.g. UK, South Africa, Israel. When obtaining a large number of security prices what field tells me that it is priced in pennies?

Thanks.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonpricingquote
icon clock
10 |1500

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

Upvotes
Accepted
39.2k 75 11 27

You can use the field CURRENCY or TR.PriceMoPriceCurrency. The former gives you ISO currency code, the latter gives currency name. For UK, South Africa and Israel these fields return:
Country: CURRENCY, TR.PriceMoPriceCurrency
UK: GBp, British Pence
South Africa: ZAc, South African Cents
Israel: ILa, Israeli Agora

If you need a generic logic to distinguish between major and minor currency units, you can probably use the following: if the value of CURRENCY field is a mixed case string, then the price is in minor currency units (cents, pennies etc.). To the best of my knowledge this logic can be currently applied for all markets around the world, though I'm not 100% sure about that. I'm less sure this logic can be sustained indefinitely in the future.

icon clock
10 |1500

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

Many thanks Alex.

Upvotes
4.6k 26 7 22

You can also use the currency parameter of the field that you are requesting, for example, TR.PriceClose and TR.PriceClose.currency:


icon clock
10 |1500

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

Click below to post an Idea Post Idea