Skip to content

Get Position Value

rosssaunders edited this page Jul 7, 2019 · 5 revisions

Description

Returns the value of a position cell.

This is an real-time function so will update automatically.

Syntax

GETPOSITIONVALUE(position_id, column_name)

The GETPOSITIONVALUE function has the following arguments

  • position_id Required. The Id (MVTIDENT) of the position.
  • column_name Required. The name of the column. (Case insensitive)

Example

Formula Result
=GETPOSITIONVALUE(12345, "Result") 100000
=GETPOSITIONVALUE(12345, "Theoretical") 100.34

Demo