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

Options
muneish.adya
muneish.adya Explorer
in TRTH

"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"

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    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.

Categories