Formula Reference: IG Index

  • All IG Index formulas start with EPF.IG so they can be easily referenced.
  • Formulas can either be entered manually or via the shortcut buttons on the Configuration Pane.

IG Index provides the ability to either stream a price or request a price on demand. Note that only some instruments can be streamed, this is indicated in the "Stream" column on the search screen.
In the example below, the Bund DFB expiry can be streamed however the Boost Bunds cannot:

IG Index search screen with streaming price indicator

Streaming Formulas

Cell values are updated automatically when the value/price changes.

Formula Description
EPF.IG.Stream.Bid Stream live bid price.
EPF.IG.Stream.Offer Stream live offer price.
EPF.IG.Stream.Change Stream live change in price today.
EPF.IG.Stream.ChangePercent Stream live percentage change in price today.
EPF.IG.Stream.High Stream live intraday high.
EPF.IG.Stream.Low Stream live intraday low.
EPF.IG.Stream.UpdateTime Stream last update time (UK local time, BST or GMT).
EPF.IG.Stream.TradeableStatus Stream tradeable status.

Non-streaming Formulas (on demand)

Cell values are updated manually when the spreadsheet is recalculated (or when you press the Sheet Refresh button on the toolbar).

Formula Description
EPF.IG.Bid Bid price.
EPF.IG.Offer Offer price.
EPF.IG.Change Change in price today.
EPF.IG.ChangePercent Percentage change in price today.
EPF.IG.High Intraday high.
EPF.IG.Low Intraday low.
EPF.IG.UpdateTime Last update time (UK local time, BST or GMT).
EPF.IG.TradeableStatus Tradeable status.