Please advise how can I get the nominal value of the bonds and the annual base (days in year) with TRKD API. I try using search and search v2 services, but can't find this fields.
Please advise how can I get the nominal value of the bonds and the annual base (days in year) with TRKD API. I try using search and search v2 services, but can't find this fields.
Received response from Waseem:
"This is a content question and I need to engage data team for explanation. I have already reached out to them and will update my response in forum once I hear from them."
Extended triage by 1 wk
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
Hello,
Apology for delay in getting back to you. I had to engage content team to get the answer. The field NOMINAL or fid 1057 is used as illogical FID for Z-Spread value for RIC 912828U81=. For the actual Nominal or Par value, you should be using the field PAR_AMT or fid # 3376 which contains 100 for this RIC.
let me know if any questions.
thanks,
Waseem
Hello,
The Searchv2 is used as a lookup service to find identifiers and other info. For pricing, market data etc you need to use Quote (RetrieveItem_3) service. The field 'NOMINAL' indicates nominal value of the bonds. Please find sample JSON request/response attached for a sample bond RIC 12527GAB9=RRPS. retrieveitem-request-3.txtretrieveitem-response-3.txt
The field to indicate annual base days is not available.
let me know if any questions.
thanks,
Waseem
Hi, thanks for answer
When I try find info about US Notes (RIC 912828U81=) I get answer
{ "DataType": "Double", "Name": "NOMINAL", "Double": -2.6 }
But Nominal should be 100 USD for this security.
Request:
{ "RetrieveItem_Request_3": { "ItemRequest": [ { "Fields": "", "RequestKey": [ { "Name": "/912828U81=", "NameType": "RIC" } ], "Scope": "All" } ], "TrimResponse": false, "IncludeChildItemQoS": false } }
Response:
{ "RetrieveItem_Response_3": { "ItemResponse": [ { "Item": [ { "RequestKey": { "Name": "/912828U81=", "Service": "IDN", "NameType": "RIC" }, "QoS": { "TimelinessInfo": { "Timeliness": "REALTIME", "TimeInfo": 0 }, "RateInfo": { "Rate": "TICK_BY_TICK", "TimeInfo": 3000 } }, "Status": { "StatusMsg": "OK", "StatusCode": 0 }, "Fields": { "Field": [ { "DataType": "Utf8String", "Name": "DSPLY_NAME", "Utf8String": "UST 2 D/21/d" }, { "DataType": "Double", "Name": "NETCHNG_1", "Double": 0.0703125 }, { "DataType": "Double", "Name": "HIGH_1", "Double": 100.71875 }, { "DataType": "Double", "Name": "LOW_1", "Double": 100.65625 }, { "DataType": "Utf8String", "Name": "CURRENCY", "Utf8String": "USD" }, { "DataType": "Double", "Name": "OPEN_PRC", "Double": 100.65625 }, { "DataType": "Double", "Name": "HST_CLOSE", "Double": 100.625 }, { "DataType": "Utf8String", "Name": "NEWS_TIME", "Utf8String": null }, { "DataType": "Utf8String", "Name": "MATUR_DATE", "Utf8String": "31 DEC 2021" }, { "DataType": "Double", "Name": "COUPN_RATE", "Double": 2 }, { "DataType": "Utf8String", "Name": "HSTCLSDATE", "Utf8String": "02 JUL 2019" }, { "DataType": "Utf8String", "Name": "BOND_TYPE", "Utf8String": "STR" }, { "DataType": "Utf8String", "Name": "ISSUE_DATE", "Utf8String": "03 JAN 2017" }, { "DataType": "Double", "Name": "ISSUE_PRC", "Double": 99.7307 }, { "DataType": "Utf8String", "Name": "ACT_TP_1", "Utf8String": " B" }, { "DataType": "Utf8String", "Name": "ACT_TP_2", "Utf8String": "B⇧" }, { "DataType": "Utf8String", "Name": "ACT_TP_3", "Utf8String": "B⇩" }, { "DataType": "Double", "Name": "SEC_ACT_1", "Double": 100.7265625 }, { "DataType": "Double", "Name": "SEC_ACT_2", "Double": 100.71875 }, { "DataType": "Double", "Name": "SEC_ACT_3", "Double": 100.71875 }, { "DataType": "Utf8String", "Name": "SC_ACT_TP1", "Utf8String": " A" }, { "DataType": "Utf8String", "Name": "SC_ACT_TP2", "Utf8String": " A" }, { "DataType": "Utf8String", "Name": "SC_ACT_TP3", "Utf8String": " A" }, { "DataType": "Utf8String", "Name": "OPEN_TIME", "Utf8String": "00:02" }, { "DataType": "Utf8String", "Name": "HIGH_TIME", "Utf8String": "01:21" }, { "DataType": "Utf8String", "Name": "LOW_TIME", "Utf8String": "00:02" }, { "DataType": "Utf8String", "Name": "SETTLEDATE", "Utf8String": "05 JUL 2019" }, { "DataType": "Double", "Name": "RT_YIELD_1", "Double": 1.7131 }, { "DataType": "Double", "Name": "RT_YIELD_2", "Double": 1.7131 }, { "DataType": "Double", "Name": "RT_YIELD_3", "Double": 1.7163 }, { "DataType": "Double", "Name": "YLD_NETCHG", "Double": -0.03 }, { "DataType": "Double", "Name": "OPEN_YLD", "Double": 1.73 }, { "DataType": "Double", "Name": "HIGH_YLD", "Double": 1.73 }, { "DataType": "Double", "Name": "LOW_YLD", "Double": 1.704 }, { "DataType": "Double", "Name": "HST_CLSYLD", "Double": 1.743 }, { "DataType": "Double", "Name": "IRGPRC", "Double": 1.7401 }, { "DataType": "Double", "Name": "PRIMACT_1", "Double": 100.6953125 }, { "DataType": "Double", "Name": "PRIMACT_2", "Double": 100.6953125 }, { "DataType": "Double", "Name": "PRIMACT_3", "Double": 100.6875 }, { "DataType": "Double", "Name": "DEALT_VL1", "Double": 0 }, { "DataType": "Double", "Name": "DEALT_VL2", "Double": 0 }, { "DataType": "Double", "Name": "DEALT_VL3", "Double": 0 }, { "DataType": "Utf8String", "Name": "LONGLINK1", "Utf8String": "US3YT=RR" }, { "DataType": "Utf8String", "Name": "LONGLINK2", "Utf8String": "0#USTSY=" }, { "DataType": "Utf8String", "Name": "LONGLINK3", "Utf8String": "USGV2YUSAB=R" }, { "DataType": "Utf8String", "Name": "LONGLINK4", "Utf8String": null }, { "DataType": "Utf8String", "Name": "LONGLINK5", "Utf8String": "CompYield" }, { "DataType": "Utf8String", "Name": "CTB_LOC1", "Utf8String": "NYC" }, { "DataType": "Double", "Name": "AMT_OS", "Double": 38521 }, { "DataType": "Utf8String", "Name": "PAY_FREQ", "Utf8String": "SEMI ANN" }, { "DataType": "Utf8String", "Name": "VALUE_DT1", "Utf8String": "03 JUL 2019" }, { "DataType": "Utf8String", "Name": "VALUE_DT2", "Utf8String": "03 JUL 2019" }, { "DataType": "Utf8String", "Name": "VALUE_DT3", "Utf8String": "03 JUL 2019" }, { "DataType": "Double", "Name": "MOD_DURTN", "Double": 2.417 }, { "DataType": "Utf8String", "Name": "BKGD_REF", "Utf8String": "USFISUPERRICS" }, { "DataType": "Utf8String", "Name": "CTBTR_BKGD", "Utf8String": "TRADEWEB" }, { "DataType": "Double", "Name": "SEC_YLD_1", "Double": 1.7003 }, { "DataType": "Double", "Name": "SEC_YLD_2", "Double": 1.7035 }, { "DataType": "Double", "Name": "SEC_YLD_3", "Double": 1.7035 }, { "DataType": "Utf8String", "Name": "ACT_FLAG1", "Utf8String": null }, { "DataType": "Utf8String", "Name": "ACT_FLAG2", "Utf8String": null }, { "DataType": "Utf8String", "Name": "ACT_FLAG3", "Utf8String": null }, { "DataType": "Utf8String", "Name": "SC_AFLAG1", "Utf8String": null }, { "DataType": "Utf8String", "Name": "SC_AFLAG2", "Utf8String": null }, { "DataType": "Utf8String", "Name": "SC_AFLAG3", "Utf8String": null }, { "DataType": "Double", "Name": "SEC_VOL1", "Double": 0 }, { "DataType": "Double", "Name": "SEC_VOL2", "Double": 0 }, { "DataType": "Double", "Name": "SEC_VOL3", "Double": 0 }, { "DataType": "Utf8String", "Name": "GEN_TEXT16", "Utf8String": "Act/Act " }, { "DataType": "Utf8String", "Name": "VALUE_TS1", "Utf8String": "05:10:46" }, { "DataType": "Utf8String", "Name": "VALUE_TS2", "Utf8String": "05:08:01" }, { "DataType": "Utf8String", "Name": "VALUE_TS3", "Utf8String": "04:23:50" }, { "DataType": "Utf8String", "Name": "STOCK_RIC", "Utf8String": "MME" }, { "DataType": "Double", "Name": "NOMINAL", "Double": -2.6 }, { "DataType": "Double", "Name": "CONV_FAC", "Double": 7.4 }, { "DataType": "Utf8String", "Name": "GN_TXT24_1", "Utf8String": null }, { "DataType": "Double", "Name": "ACCR_INT", "Double": 0.02717 }, { "DataType": "Double", "Name": "STOCK_PRC", "Double": 1.7144 }, { "DataType": "Double", "Name": "CONVEXITY", "Double": 7.1099 }, { "DataType": "Double", "Name": "CNV_RATIO", "Double": -4.0908 }, { "DataType": "Double", "Name": "CNV_PREM", "Double": 0 }, { "DataType": "Double", "Name": "DELTA", "Double": 7.6462 }, { "DataType": "Utf8String", "Name": "CTB_2A_1", "Utf8String": "<USDSB3L=RR>" }, { "DataType": "Utf8String", "Name": "CTB_2A_1LL", "Utf8String": "<0#FIXEDINCOME> " }, { "DataType": "Double", "Name": "SWAP_SPRD", "Double": -2.7 }, { "DataType": "Int64", "Name": "ACC_DAYS", "Int64": 5 }, { "DataType": "Double", "Name": "ASK_SPREAD", "Double": 4.8 }, { "DataType": "Double", "Name": "AST_SWPSPD", "Double": -2.5 }, { "DataType": "Double", "Name": "BMK_SPD", "Double": 3.2 }, { "DataType": "Double", "Name": "BPV", "Double": 2.4348 }, { "DataType": "Utf8String", "Name": "EMAIL_ADRS", "Utf8String": "Issued " }, { "DataType": "Double", "Name": "GEARING", "Double": 1.7014 }, { "DataType": "Utf8String", "Name": "IND_NEWS", "Utf8String": "[GVD] " }, { "DataType": "Double", "Name": "ISMA_B_YLD", "Double": 1.72 }, { "DataType": "Double", "Name": "ISMA_A_YLD", "Double": 1.7 }, { "DataType": "Utf8String", "Name": "ISSUER_DOM", "Utf8String": "US " }, { "DataType": "Double", "Name": "OFF_CLOSE", "Double": 0.0807 }, { "DataType": "Utf8String", "Name": "TICKER", "Utf8String": "GOVT " }, { "DataType": "Utf8String", "Name": "WEB_ADRS", "Utf8String": null }, { "DataType": "Utf8String", "Name": "PROV_SYMB", "Utf8String": "<USDSWAPZC> " }, { "DataType": "Double", "Name": "ASTSWPSD_A", "Double": -2.7377 }, { "DataType": "Double", "Name": "ASTSWPSD_B", "Double": -8.8117 }, { "DataType": "Double", "Name": "OAS_BID", "Double": -2.6 }, { "DataType": "Double", "Name": "CF_ASK", "Double": 100.7265625 }, { "DataType": "Double", "Name": "CF_BID", "Double": 100.6953125 }, { "DataType": "Double", "Name": "CF_CLOSE", "Double": 100.625 }, { "DataType": "Utf8String", "Name": "CF_DATE", "Utf8String": "03 JUL 2019" }, { "DataType": "Utf8String", "Name": "CF_EXCHNG", "Utf8String": null }, { "DataType": "Double", "Name": "CF_HIGH", "Double": 100.71875 }, { "DataType": "Double", "Name": "CF_LAST", "Double": 100.6953125 }, { "DataType": "Double", "Name": "CF_LOW", "Double": 100.65625 }, { "DataType": "Double", "Name": "CF_NETCHNG", "Double": 0.0703125 }, { "DataType": "Double", "Name": "CF_OPEN", "Double": 100.65625 }, { "DataType": "Utf8String", "Name": "CF_SOURCE", "Utf8String": "TRADEWEB " }, { "DataType": "Utf8String", "Name": "CF_TICK", "Utf8String": " B" }, { "DataType": "Utf8String", "Name": "CF_TIME", "Utf8String": "05:10:46" }, { "DataType": "Int64", "Name": "CF_VOLUME", "Int64": 0 }, { "DataType": "Double", "Name": "CF_YIELD", "Double": 1.7131 }, { "DataType": "Utf8String", "Name": "CF_NAME", "Utf8String": "UST 2 D/21/d" }, { "DataType": "Utf8String", "Name": "CF_SRC_PAGE", "Utf8String": "TRADEWEB" }, { "DataType": "Utf8String", "Name": "CF_CURRENCY", "Utf8String": "USD" } ] } } ] } ] } }
Hello @Shaikh.Waseem,
There appear to be a follow-up question from the original inquirer, could you please take a look?