question

Upvotes
Accepted
16 1 5 5

How to query 'current_portfolio_value' via REDI API?

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.

redi-apiportfolio-trader
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
410 1 1 2

@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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you but still not clear....see below

Upvotes
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#?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
410 1 1 2

@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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.