Description

Returns the value of an instrument property.

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

Syntax

GETINSTRUMENTPROPERTY(id, property)

The GETINSTRUMENTPROPERTY function has the following arguments

• id Required. The Id (Sicovam or Reference) of the instrument.
• property Required. The name of the property. (Case insensitive). The following are available:
  • Code
  • Reference
  • Name
  • Comment
  • Allotment
  • Plus instrument type specific fields listed below

Example

Formula	Result
=GETINSTRUMENTPROPERTY (67123423, "Reference")	UST1234456
=GETINSTRUMENTPROPERTY (67123123, "Name")	Bond #1
=GETINSTRUMENTPROPERTY (67123123, "Expiry")	31/12/2019

Instrument Type Specific Fields

• Bonds
• Caps and Floors
• Commissions
• Equities
• Futures

Coming soon

• CFDs
• Commodities
• Commodity Baskets
• Debt Instruments
• Forex Spot / Forwards / NDFs
• Funds
• Interest Rates
• Indexes
• Issuers / Reference Entities
• Loans and Repos
• Options
• Options (Listed)
• Swapped Options
• Swaps