Get Flat Position Value - rosssaunders/FusionLinkDocs GitHub Wiki
Description
Returns the value of a position cell.
This is a real-time function so will update automatically.
Syntax
GETFLATPOSITIONVALUE(portfolio_id, instrument_id, column_name)
The GETFLATPOSITIONVALUE function has the following arguments
- portfolio_id Required. The Portfolio Id (OPCVM).
- instrument_id Required. The Instrument Id (SICOVAM).
- column_name Required. The name of the column. (Case insensitive)
Example
| Formula | Result |
|---|---|
| =GETFLATPOSITIONVALUE(12345, 67123456, "Result") | 100000 |
| =GETFLATPOSITIONVALUE(12345, 67123456, "Theoretical") | 100.34 |