question

Upvotes
Accepted
50 9 12 20

Instrument and REF file type missing

We were trying to download below files, it was not listed. Please help us here.

REF-Data-CUSIP-SEDOL and Instruments-CUSIP-SEDOL

tick-history-rest-api
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.

@Ayan

Could you please specify the exchange name and date? Therefore, we can verify it.

It is across all the availble dates. However it is available is DSS. We can see from Data Scope. But while listing the file details under exchanges it is not getting listed.

@Ayan, can you tell us how you are listing the files ? If it is through the API then please share the call endpoint and body. That will help us understand and respond.

Upvotes
Accepted
262 8 9 15

I have reviewed the above query and confirm that you need to have permissions to CUSIP, SEDOL GICS to access Instruments-CUSIP-SEDOL-GICS and REF-Data-CUSIP-SEDOL-GICS files.

As an alternative, you can refer to the following:

  • 1)<Instruments-1-of-1.csv.gz> instead of Instruments-CUSIP-SEDOL-GICSs
  • 2)<REF-Data-1-of-1.csv.gz> instead of REF-Data-CUSIP-SEDOL-GICS

The difference between these couple of files is the “CUSIP-SEDOL-GICS” will provide CUSIP-SEDOL-GICS details others don’t. The rest of the data remain same.

Regards,
Beera

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.

Upvotes
38.1k 71 35 53

I used this extraction for NAS.

/StandardExtractions/UserPackageDeliveryGetUserPackageDeliveriesByPackageId(PackageId='0x04f21a8d26059cb1')

It returns NAS-2017-09-05-Instruments-CUSIP-SEDOL-GICS-1-of-1.csv.gz and NAS-2017-09-05-REF-Data-CUSIP-SEDOL-GICS-1-of-1.csv.gz.

nas.txt


nas.txt (22.0 KiB)
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.

We are using below command, but still not able to see those files.

curl -k -X GET -H 'Content-Type: application/json' -H 'Prefer: odata.maxpagesize=600; respond-async' -H 'Accept-Charset: UTF-8' -H 'Authorization: Token xxxxx' https://10.192.6.221/RestApi/v1/StandardExtractions/UserPackageDeliveryGetUserPackageDeliveriesByPackageId%28PackageId%3D%270x04f21a8d26059cb1%27%29

Is it possible that due to subscription restriction we are not able to see the file names? Please help.

I used the above command. My result is different from yours. It contains "NAS-2017-09-05-Instruments-CUSIP-SEDOL-GICS-1-of-1.csv.gz" and "NAS-2017-09-05-REF-Data-CUSIP-SEDOL-GICS-1-of-1.csv.gz".

I will contact TRTH support team to verify the problem.

Click below to post an Idea Post Idea