Formula Reference: IG Index

  • All IG Index formulas start with EPF.IG so they can be easily referenced. Start typing "=EPF.IG" in a cell and all Excel Price Feed formulas will be displayed.
  • Formulas can either be entered manually or via the shortcut buttons on the Configuration Pane. More details below.

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 by 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.

Streaming must be started (using the button on the toolbar) in order for streaming values to be updated:

IG Index start streaming button

The "Streaming?" icon indicates if streaming is on or off - a green tick indicates streaming is on whereas a red cross indicates streaming is off:

IG Index start streaming button IG Index start streaming button

Account Formulas

These formulas are used to stream live account data to an Excel cell. They always stream data for your currently preferred account (as selected on the Account Setup tab):

Formula Description
EPF.IG.Stream.Account.PNL Stream account profit and loss.
EPF.IG.Stream.Account.Funds Stream account funds.
EPF.IG.Stream.Account.Margin Stream account margin.
EPF.IG.Stream.Account.AvailableCash Stream cash available to trade.
EPF.IG.Stream.Account.Equity Stream equity.
EPF.IG.Stream.Account.EquityUsed Stream equity used.

In addition, there are some shortcut buttons which can be used to quickly add a formula to the currently selected cell:

IG Index streaming account shortcut buttons

Pricing Formulas

Before you can stream any pricing data to a cell, you must subscribe to the instrument. To do this find the instrument using the search screen, then press the "Add Selected" button to add the instrument to your subscribed list.

Please note: you must re-start streaming if you change the instruments you are subscribed to.

IG Index streaming instrument search

The following formulas all require the instrument IG Index epic code as a parameter:

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.

In addition, there are some shortcut buttons which can be used to quickly add a formula to the currently selected cell:

IG Index streaming formula shortcut buttons

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).

Account Formulas

These formulas are used to populate live account data to an Excel cell. They always populate data for your currently preferred account (as selected on the Account Setup tab):

Formula Description
EPF.IG.Stream.Account.PNL Stream account profit and loss.
EPF.IG.Stream.Account.Funds Stream account funds.
EPF.IG.Stream.Account.Margin Stream account margin.
EPF.IG.Stream.Account.AvailableCash Stream cash available to trade.

In addition, there are some shortcut buttons which can be used to quickly add a formula to the currently selected cell:

IG Index non-streaming account shortcut buttons

Pricing Formulas

The following formulas all require the instrument IG Index epic code as a parameter (except sentiment which requires a market id):

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.Name Instrument name.
EPF.IG.Country Instrument country code eg. US, DE, GB, FR, JP etc.
EPF.IG.Type Instrument type eg. SHARES, CURRENCIES, INDICES etc.
EPF.IG.MarketID Market Identifier (used for sentiment data).
EPF.IG.SentimentLong Client sentiment long positions (%).
EPF.IG.SentimentShort Client sentiment short positions (%).
EPF.IG.MarginFactor Instrument margin requirement factor.
EPF.IG.Epic(countryCode, ticker, expiry) Returns the IG Index epic for the specified country code, ticker and expiry (often "DFB" for spreadbets or "-" for CFDs).
EPF.IG.UpdateTime Last update time (UK local time, BST or GMT).
EPF.IG.TradeableStatus Tradeable status.

In addition, there are some shortcut buttons which can be used to quickly add a formula to the currently selected cell:

IG Index non-streaming formula shortcut buttons

Examples

Formula Description
=EPF.IG.Change("CS.D.EURUSD.TODAY.IP") Populate the Excel cell with the current daily change in EURUSD.
=EPF.IG.Bid("UA.D.AAPL.DAILY.IP") Populate the Excel cell with the current bid price of Apple stock.
=EPF.IG.Epic("AAPL","US","DFB") Populate the Excel cell with the IG Index epic code for APPL.
=EPF.IG.SentimentLong("GBPUSD") Populate the Excel cell with the IG Index client sentiment for GBPUSD long positions.