question

Upvotes
Accepted
1 1 1 4

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?

intelligent-tagging-apipermid-apiopen-permid-apisymbology
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.

1 Answer

Upvotes
Accepted
161 1 0 1

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,Website

1,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

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