question

Upvotes
Accepted
9 4 3 8

How can i get symbol changes from trth v2? sample data given below..

"sdate,edate,old,new,current"
"2014-08-24,2099-01-01,8321.HK,0048.HK,0048.HK"
"2015-06-15,2099-01-01,DEA0V6ZA.D,00E1.D,00E1.D"
"2015-06-15,2099-01-01,DEA0V6ZA.SG,00E1.SG,00E1.SG"
"2015-06-15,2099-01-01,DEA0V6Y7.D,00E2.D,00E2.D"
"2015-06-15,2099-01-01,DEA0V6Y7.SG,00E2.SG,00E2.SG"
"2015-06-15,2099-01-01,DEA0V6Y8.D,00E3.D,00E3.D"
"2015-06-15,2099-01-01,DEA0V6Y8.SG,00E3.SG,00E3.SG"
"2015-06-15,2099-01-01,DEA0V6YU.D,00E4.D,00E4.D"
"2015-06-15,2099-01-01,DEA0V6YU.SG,00E4.SG,00E4.SG"
"2015-06-15,2099-01-01,DEA0V6ZC.D,00E5.D,00E5.D"
"2015-06-15,2099-01-01,DEA0V6ZC.SG,00E5.SG,00E5.SG"
"2015-06-15,2099-01-01,DEA0V6ZR.D,00E6.D,00E6.D"
"2015-06-15,2099-01-01,DEA0V6ZR.SG,00E6.SG,00E6.SG"
"2015-06-15,2099-01-01,DEA0V6ZF.D,00E7.D,00E7.D"
"2015-06-15,2099-01-01,DEA0V6ZF.SG,00E7.SG,00E7.SG"
"2015-06-15,2099-01-01,DEA0V6ZU.D,00E8.D,00E8.D"
"2015-06-15,2099-01-01,DEA0V6ZU.SG,00E8.SG,00E8.SG"

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.

1 Answer

Upvotes
Accepted
38.1k 71 35 53

You can use HistoricalReferenceExtractionRequest. For more information, please refer to this question.

The request could be request.txt.

You can filter out the delisted RICs by using Trading Status field. The Trading Status of delisted RICs is zero.


request.txt (2.3 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.

Click below to post an Idea Post Idea