How to retrieve Permid to Ticker/Cusip mapping in .csv files

We are given TR News Analytics historical data to test and need a mapping between Permid and Ticker/Cusip valid at the time a news item is delivered
We are only able to work with .txt or .csv I am not sure what files to retrieve(instrument,organization?) and as only Turtle and Ntriples are provided how do i do the conversion?
Best Answer
-
Hi Bshieh,
Our organization Bulk download files (in Ntriples /Turtle) includes relationship (tr-fin:hasOrganizationPrimaryQuote) to the respective primary quote records that includes the respective ticker. So you can download the organization file+ Quote file and create your own mapping in a csv.
Alternative solution would be to use our record matching solution . If you have the company names and tickers you want to match, enter them into the template input file (available in the Matching link), and you'll get the matched permid.
If you have the respective exchange it would be even better (as ticker is not a unique identifier).
Example for input:
LocalID,Standard
Identifier,Name,Country,Street,City,PostalCode,State,Website1,Ticker:MSFT,Microsoft, , , , ,
2, ticker:msft&&mic:XNGS., Microsoft, , , , ,
3, ticker:msft&&mic:XNGS, , , , , , ,
You can find further details in our user guide (chapter 4).
Thanks
Tsafi
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 167 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 705 Datastream
- 1.5K DSS
- 633 Eikon COM
- 5.2K Eikon Data APIs
- 14 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 6 Trading API
- 3K Elektron
- 1.5K EMA
- 259 ETA
- 569 WebSocket API
- 40 FX Venues
- 16 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 4 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 284 Open PermID
- 47 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 24 RDMS
- 2.2K Refinitiv Data Platform
- 879 Refinitiv Data Platform Libraries
- 5 LSEG Due Diligence
- 1 LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 123 Open DACS
- 1.1K RFA
- 108 UPA
- 196 TREP Infrastructure
- 232 TRKD
- 919 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 103 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛