APCURRVAL | Read Current Value


Retrieve the current value from a given tag. This function is available via the taskpane as well as directly via the cell “=APCURRVAL(…)”.

We recommend configuring this formula using the ‘Read Current Value‘ task pane.

Return Value

The function returns the current value of a given tag. The tag must be configured in the Automation Portal Historian before the tag can be read in Microsoft Excel.


Tag – Specifies the tag name of the desired tag. The tag name must be exactly the same as configured in the Automation Portal ‘Historian’

Options – Specifies custom options given by the task pane. Default value is 0.