Good day!
I am trying to implement data loading from JSON on some Bonds. The problem is that the Bond price at which I would like show on my account it is the current bond price + the current accrued interest (coupon) for this bond. After all, this is the amount I will receive if I decide to sell my bonds right now (current price + current accrued interest)
It seems that such accounting of bonds is not supported by the program or i didn’t found how to do it correctly.
The data source give me JSON which has as two separate values LAST (current bond price) and ACCRUEDINT (current accrued interest):
“marketdata”: {
“columns”: [“SYSTIME”, “LAST”, “HIGH”, “LOW”, “VOLTODAY”,“ACCRUEDINT”],
“data”: [
[“2024-11-19 00:05:01”, 67.296, 67.4, 66.72, 24003,12.5]
]
}
I tried to specify the sum of two fields $.marketdata.data[][1] + $.marketdata.data[][5] in “Latest Quote” → “Path To Close” in JSON Provider, but it does not work.
How can this be done?
Are there any other options to solve this task?