TP ICAP Fusion Excel In-Cell functions

The TP ICAP Fusion Excel add-in provides provides several in-cell functions that you can use to include live grids in your own spreadsheets:

  • iPullFusion
  • iPullFusionDisplay
  • iPullFusionDisplayInfo

 

iPullFusion and iPullFusionDisplay

These two functions are used together to pull grids into your sheet and display them. You can pull multiple grids into the same sheet.

Use iPullFusion(PageName, FolderName, ...) to pull a reference to your chosen grid into a cell on your sheet. In this case, a ref to the caps-and-floors-basis-3m-v-6m-EUR_BID grid is being pulled into cell D3:

        ipullfusion.png

Once you have pulled the grid reference into your sheet, use the iPullFusionDisplay(iPullFusionCellRef) function to display the ticking grid. iPullFusionCellRef is the reference of the cell where you entered your iPullFusion(...) command (D3 in the example above):

        ipullfusiondisplay.png

If you enter iPullFusionDisplay in a single cell it will only display the top left cell of the grid. To display the entire page you have to use iPullFusionDisplay as an Excel Array Formula. Array formulas let you display the results of a request across multiple cells.

To pull an entire grid you must first highlight a range of cells with the same (or larger) dimensions as the grid (tip: the number of rows and columns in the grid is displayed in the message returned by the iPullFusion command).

Using your mouse, select the top left cell of the range then, keeping the left mouse button pressed down, drag down and to the right until you've selected a big enough range (Excel will display the size of the range you've currently selected in the Name Box in the top left corner). It doesn't matter if the range you select is bigger than the grid.

When you are happy with your selection, release the mouse button and type your iPullFusionDisplay command.

When you've done this, press CTRL+SHIFT+ENTER at the same time. The iPullFusionDisplay function will now be copied into every cell in the range you just selected, and the entire grid will be displayed.

 

Function Reference

iPullFusion

Parameters

  • PageName: Name of grid
  • FolderName: Name of folder containing grid. Usually OptionsGrids_60
  • Interval: OPTIONAL Minimum num seconds between updates. Positive integer. Default:1
  • Update: OPTIONAL Toggles subscription to Page on or Off. TRUE or FALSE. Default: True

Returns

  • Status message. If subscription was successful, it displays the time of last update, the name of the grid being subscribed and the number of rows and columns in the grid:

    22:27:01 Success [caps-and-floors-basis-3m-v-6m-EUR_OFFER][OptionsGrids_60][rows:17][cols:11]

    Otherwise it returns an error message.

 

iPullFusionDisplay

Parameters

  • iPullFusionCellRef: the cell containing the iPullFusion command for the grid

Returns

  • Ticking grid data. Excel Array Formula.

 

iPullFusionDisplayInfo

Use this function to display meta-data about the grid e.g. when it was last updated at the source.

Use iPullFusionDisplayInfo(iPullFusionCellRef, Item) to display metadata about the grid e.g. when it was last updated at source). iPullFusionCellRef is the reference of the cell where you entered your iPullFusion(...) command (D3 in the example above), and Item is the metadata you want to see:

        ipullfusiondisplayinfo.png

The metadata will update each time the grid content updates.

Function Reference

iPullFusionDisplayInfo

Parameters

  • iPullFusionCellRef: the cell containing the iPullFusion command for the grid
  • Item: OPTIONAL which item of metadata you want to see. Options: WHENUPDATED, DESCRIPTION, NUMROWS, NUMCOLS. Default: WHENUPDATED

Returns

  • Ticking metadata value.

 

Further questions?

See this page for FAQs about the add-in.

 

 

Was this article helpful?
0 out of 0 found this helpful
Powered by Zendesk