question

Upvotes
Accepted
50 12 22 29

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 512.0 KiB each and 1.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.

Contacted TRTHUpgradeSpecialists to verify the problem.

Followed up an update from @jirapongse.phuriphanvichai.

@Ayan

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

Thanks,

AHS

Upvotes
Accepted
262 12 15 18

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 512.0 KiB each and 1.0 MiB total.

Upvotes
79.2k 251 52 74

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 512.0 KiB each and 1.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.

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.