Permids missing in 20190714 bulk quotes file

duncan.sands

Hi, I noticed that the following permids have all been deleted in recent bulk quote files. To verify that they all represent actual quotes, and aren't just something bogus that should never have been added in the first place, I checked that looking them all up in the OpenFIGI service returned a result (lookup based on: the exchange, exchange_ticker, quoted_in and asset_class; I didn't have the patience to look them all up by hand at the individual exchanges). So I suspect they shouldn't have been deleted.

1-21475816847
1-21500899390
1-21507935997
1-21525093674
1-21526380284
1-21533643942
1-21541502133
1-21543772915
1-21545814306
1-21547022310
1-21547022668
1-21547022763
1-21548931817
1-21550906094
1-21557637986
1-21558659774
1-21589207597
1-21613593111
1-21614085353
1-21622790313
1-21629446562
1-21648795370
1-21684436081
1-21690465068
1-21696282847
1-21696822791
1-21696867332
1-21696915979
1-21697066466
1-21701294504
1-25727370045
1-25727370400
1-25727370402
1-25727371077
1-25727371164
1-25727371167
1-25727393417
1-55834586908
1-55834615307
1-55834633796
1-55834947431
1-55838254423
1-55838736754
1-55838737813
1-55838740880
1-55838741082
1-55838741378
1-55838741632
1-55838753792
1-55838825615
1-55857445832

Jirapongse

@duncan.sands

I found that those PermIDs are available in the OpenPermID-bulk-quote-20200705_132936.ttl file.

Therefore, the problem has been resolved.

Jirapongse

@duncan.sands

Thank you so much for your finding.

I have verified some of those PermIDs and found that they are missing in both OpenPermID-bulk-quote-20190707_070945 and OpenPermID-bulk-quote-20190714_070957 files.

I will contact the Open PermID support team to verify this problem.

nick.zincone

Hi @Jirapongse,

Were you able to verify the problem?

duncan.sands

https://community.developers.refinitiv.com/discussion/comment/63183#Comment_63183

Yes, it has been fixed. Thanks for taking care of it.

duncan.sands

https://community.developers.refinitiv.com/discussion/comment/63183#Comment_63183

While it is mostly better, these two permids were not fixed:
1-21589207597
1-25727370400
I checked the exchange web-sites and both are alive and kicking.

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/63183#Comment_63183

@duncan.sands

I have found those PermIDs in the OpenPermID-bulk-quote-20200712_133131.ntriples file.

<https://permid.org/1-21589207597&gt; <http://permid.org/ontology/financial/hasRic&gt; "239340.KQ"^^<http://www.w3.org/2001/XMLSchema#string&gt; .

<https://permid.org/1-25727370400&gt; <http://permid.org/ontology/financial/hasRic&gt; "1842.HK"^^<http://www.w3.org/2001/XMLSchema#string&gt; .

duncan.sands

https://community.developers.refinitiv.com/discussion/comment/63313#Comment_63313

You are correct, I mistakenly checked OpenPermID-bulk-quote-20200705_132936 rather than the latest bulk quote file OpenPermID-bulk-quote-20200712_133131. Sorry for the bother.