How can current value of the book (net liquidation value) be queried over API? Need it after the market is closed to compute next days position. In the API doc's, this is not clear.
16
●1 ●5 ●5
How to query 'current_portfolio_value' via REDI API?
Hello @qcap17,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi,
Is the reply below satisfactory in resolving your query?
If the problem persists, please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
410
●1 ●1 ●3
@qcap17: the "value" field will show you the account's value (e.g. $1,000,000)
Tutorial here for C#:https://developers.thomsonreuters.com/transactions/redi-api/learning?content=47996&type=learning_material_item
Our Github repository has a VB example as well (“Position Monitor”):https://github.com/TR-API-Samples/Example.REDI.VB.ExcelExamples
16
●1 ●5 ●5
still not clear.
Let me explain another way:
Sometime after the market closes, there is an algorithmically generated request that goes to REDI and returns the net liquidation value of the account and all open positions. These are used in computations resulting in a list of algorithmically generated tickets for the following day. Per the C# tutorial and the GitHub repository, this is not clear. Then the VB example suggests manual steps which we are trying to avoid.
The options in the API docs are: BuyingPower, LongValue, NetValue, ShortValue.
I'm assuming it's NetValue I'm after, but what would be the correct way to do it in either VB or C#?
410
●1 ●1 ●3
@qcap17 setting "Value" in VB (Excel) returns the net value. Can you try that?
e.g.
account A's value = $500
account B's value - -$100
"value" is $400
