EPF.IG
so they can be easily referenced.
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:
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. |
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. |