Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Open PermID /
avatar image
Question by duncan.sands · Oct 02, 2019 at 12:34 PM · riccurrencybulk quotes file

Wrong currency EUR for RIC FLTRF.L

The latest bulk quotes file says the currency for 1-55836052673 (FLTRF.L) is 1-500111. However this is wrong, it is traded in GBp (pennies). I confirmed this using other Thomson-Reuters products, as well as other data vendors and the exchange itself.

I have a theory as to how it got this way: the currency used to be EUR but changed to GBp on 2019-05-27. PermID doesn't seem to support GBp properly: GBp quotes usually have no currency. Probably rather than replacing EUR with null, it left the EUR value alone (a bug).

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

1 Reply

  • Sort: 
avatar image
REFINITIV
Answer by jirapongse.phuriphanvichai · Oct 03, 2019 at 08:33 AM

@duncan.sands

I can see the problem.

<https://permid.org/1-55836052673> <http://permid.org/ontology/financial/isQuotedIn> <https://permid.org/1-500111> .
<https://permid.org/1-500111> <http://permid.org/ontology/currency/iso4217> "EUR"^^<http://www.w3.org/2001/XMLSchema#string> .

Comparing to 1-21523087992, it doesn't have the isQuotedIn entry.

-bash-3.00$ grep 1-21523087992 OpenPermID-bulk-quote-20190929_085631.ntriples
<https://permid.org/1-21523087992> <http://permid.org/ontology/common/hasPermId> "21523087992"^^<http://www.w3.org/2001/XMLSchema#string> .
<https://permid.org/1-21523087992> <http://permid.org/ontology/common/hasName> "ALL ASIA ASSET CAPITAL ORD"^^<http://www.w3.org/2001/XMLSchema#string> .
<https://permid.org/1-21523087992> <http://permid.org/ontology/financial/isQuoteOf> <https://permid.org/1-21522444720> .
<https://permid.org/1-21523087992> <http://permid.org/ontology/financial/hasRic> "AAAL.L"^^<http://www.w3.org/2001/XMLSchema#string> .
<https://permid.org/1-21523087992> <http://permid.org/ontology/financial/hasExchangeTicker> "AAA"^^<http://www.w3.org/2001/XMLSchema#string> .
<https://permid.org/1-21523087992> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://permid.org/ontology/financial/Quote> .
<https://permid.org/1-21523087992> <http://permid.org/ontology/financial/hasExchangeCode> "LSE"^^<http://www.w3.org/2001/XMLSchema#string> .
<https://permid.org/1-21523087992> <http://permid.org/ontology/financial/hasMic> "XLON"^^<http://www.w3.org/2001/XMLSchema#string> .

I will report this issue to the Open PermID support team.

Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
duncan.sands · Jul 25, 2020 at 01:05 PM 0
Share

Any progress on this, it is still wrong. Here's a list of other permids with wrong currencies:
permid | quoted_in | aka | should_be
---------------+-----------+-----+-----------
1-21526557205 | 500111 | EUR | GBP
1-21530530889 | 500111 | EUR | GBP
1-21530530891 | 500111 | EUR | GBP
1-21550102165 | 500110 | USD | GBP
1-21629379085 | 500111 | EUR | GBP
1-21629381057 | 500111 | EUR | USD
1-21629382096 | 500201 | CHF | USD
1-21633180299 | 500140 | CAD | GBP
1-21698487225 | 500111 | EUR | GBP
1-55836044315 | 500111 | EUR | GBP
1-55836049625 | 500111 | EUR | GBP
1-55836050740 | 500111 | EUR | GBP
1-55836051203 | 500133 | NOK | GBP
1-55836051749 | 500110 | USD | GBP
1-55836052673 | 500111 | EUR | GBP
1-55836053308 | 500111 | EUR | GBP
1-55836053789 | 500110 | USD | GBP
1-55850813914 | 500110 | USD | GBP
1-55851542845 | 500111 | EUR | GBP
1-55853419694 | 500110 | USD | GBP
1-55865947384 | 500110 | USD | GBP

For example, permid 1-21530530889 (the second row above) has currency EUR according to openpermid but it should be GBB (actually GBp: pennies).

avatar image
REFINITIV
jirapongse.phuriphanvichai ♦♦ duncan.sands · Jul 29, 2020 at 03:06 AM 0
Share

I have contacted the PermID team to verify this problem.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

Sao Paulo RICs which should have no mic but do

Quote RIC update visible on permid website, but not in bulk file or atom feed

Live permids that recently disappeared

Duplicate RIC NEOE3.SA

Missing RICS in latest bulk quote file

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges