Description

Returns the value of an currency property.

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

Syntax

GETCURRENCYPROPERTY(id, property)

The GETCURRENCYPROPERTYfunction has the following arguments

• id Required. The Id (DEVISE or CODE) of the currency.
• property Required. The name of the property. (Case insensitive). The following are available:
  • Name
  • Last

Example

Formula	Result
=GETCURRENCYPROPERTY(54613316, "NAME")	AUSTRALIAN DOLLAR
=GETCURRENCYPROPERTY("AUD", "Name")	AUSTRALIAN DOLLAR
=GETCURRENCYPROPERTY("AUD", "Last")	0.71