The Finance Plugin Options contains some useful properties if using AdapTable in the financial services sector.
|instrumentColumns||Columns to be defined as (FDC3) Instrument|
|weightedAverageColumns||Columns to use a Weighted Average aggregation|
Cell Summary Definitions
The Finance Plugin provides 2 additional Cell Summary Definitions:
|Only||Numeric||Returns true if all selected cells match (single column only)|
|WeightedAverage||Numeric||Calculates the Weighted Average (is using a Weighted Average Column)|
Weighted Average Columns
A common scenario in the Finance Industry is to aggregate or summarise data using a Weighted Average.
AdapTable facilitates this by providing Weighted Average Columns which defines the Column on which the aggregation is performed and the supporting Column used to calculate the aggregation.
Aggregations for Weighted Average columns can be turned off and on at runtime through the AG Grid UI, but they can only be defined at design-time
The full definition is as follows:
|columnId||Column which will contain the aggregation|
|weightedColumnId||Column used to perform the aggreation calculation|
Weighted Average Cell Summary
The Weighted Average is also used when performing a Cell Summary.
If the selected cells are all in a Weighted Column, the Weighted Average Cell Summary will display the weighted average value for the cells.
FDC3 Instrument Columns
The Finance Plugin Options enables a Column to be defined as an Instrument Column.
InstrumentColumn object requires a columnId which is the Id of the Column, and at least one 'Instrument Data' column to be picked. It is defined as follows:
|bbgColumnId||Column which holds a Bloomberg Ticker value as instrument data|
|columnId||Column to be defined as an Instrument - its value will provide the |
|cusipColumnId||Column which holds a CUSIP value as instrument data|
|figiColumnId||Column which holds a FIGI value as instrument data|
|isinColumnId||Column which holds an ISIN value as instrument data|
|permidColumnId||Column which holds a PERMID value as instrument data|
|ricColumnId||Column which holds a Reuters Instrument Code value as instrument data|
|sedolColumnId||Column which holds a SEDOL value as instrument data|
|tickerColumnId||Column which holds a ticker value as instrument data|
When a Column is defined as an InstrumentColumn AdapTable will create an extra Menu Item Broadcast [cell value] to appear in the Context Menu for each cell in the Column.
Broadcasting FDC3 Message
When the context menu item is clicked AdapTable will fire the BroadcastInstrument event which packages the cell value as FDC3 Instrument Context.
For example clicking the entry 'Apple' in a row which contained 'ticker' and 'CUSIP' columns (as per the example above) would produce this Instrument Context:
If the OpenFin Plugin is also active, then AdapTable will listen to this event and broadcast the context on the currently active channel.
Visit the Cell Summary Demo to see AdapTable with the Finance plugin.