question

Upvotes
Accepted
bshieh avatar image
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?

permid-apiintelligent-tagging-apiopen-permid-apisymbology
icon clock
10 |1500

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

Nipat Kunvutipongsak avatar image   Nipat Kunvutipongsak

Hello @bshieh,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @bshieh

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Nipat Kunvutipongsak avatar image   Nipat Kunvutipongsak

Hello again!

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

warat.boonyanit avatar image   warat.boonyanit

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

-AHS

1 Answer

· Write an Answer
Upvotes
Accepted
tsafi.tsur.1 avatar image
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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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