Collaborate Communicate Consolidate

In the last 5 years it’s become increasingly easy to get to know people, stay friends with them, and to collaborate in other ways through the infinite number of tools created with this in mind.?

But interestingly, although as individuals we are open to collaborating and interacting more and more, as businesses we often like to present ourselves as a one stop shop.?Collaboration can seem like a deficiency.?We are scared to show our limitations.

At Adaptable Tools we have always wanted to own one piece of a complex jigsaw – data management through grids.?And from our early days we have looked for other innovators to work with.?We’re lucky to have found a number of them, and also to have found that working with others really can multiply and maximise the power each of us can offer solo.

That’s certainly been our experience of working with OpenFin, the leading financial desktop solution in 2021.?

Collaborating with OpenFin at multiple levels of on-going development has allowed both companies to make the most of the tools that each provides, for the long-term benefit of users of both products.

Webinar

In June 2021, we presented a joint webinar which showed off some of the fruits of this exciting collaboration.

For the webinar we built a small demo application to mimic a trading application which contained three main windows each of which hosted an AdapTable grid: Trades, Prices and Positions.?Because all the functionality on display in the webinar is provided 'out of the box' in AdapTable and OpenFin it only took a couple of hours to put together the demo.

The Trades view updated a few seconds with a new, fictitious trade, and the Prices view updated each second for with a new price for each of the 50 assets we displayed.?Both of these ticking data changes automatically updated the Positions grid which showed an overall ‘PnL’ view.

Each grid also had an associated audit window that showed a stream of data change information – both ticking and user edits – that leveraged AdapTable’s in built audit log.?

Drawing on AdapTable’s strengths, each of the three views were pre-populated with examples of Predefined Config including:

• Layouts
• Format Columns
• Conditional Styles
• Calculated Columns
• User Reports
• Action Columns

And then we looked to see how we could interweave OpenFin with AdapTable to do more.

Communication

We leveraged the OpenFin FDC3 api to manage communication between the three AdapTable instances, so that selecting an instrument in any grid filtered all three views to that instrument.?And because it broadcast on the current channel, we showed how other applications running in OpenFin – external to AdapTable – were also able to listen and then filter their contents accordingly.?

In the same way, we selected an instrument in the external application and noted how it updated the AdapTable instances.

FDC3 Instruments

We also showed how the same functionality can be achieved using FDC3 messaging.?

Adaptable includes Instrument Columns – columns which are defined in the Finance Plugin as containing Instrument data, and which automatically provide a ‘Broadcast Instrument’ menu entry in the AdapTable Context Menu.??

We showed how clicking on that menu entry fires a Broadcast Instrument event which is picked up by Adaptable's OpenFin plugin and sends it on as a full FDC3 message for other applications to deal with as required.

Notifications

One of the most important aspects of any advanced application is to keep users immediately informed of things that matter and of data changes that concern them.?

AdapTable has very rich Alerting and Notification capabilities.?Users are able to create notifications in a wide variety of scenarios including when:

• Data Changes in the grid – either by user action or if ticking data
• Validation Rules provided by the User has been triggered
• Data has changed (or perhaps not changed?) in interesting ways over a given period of time - Observable Alerts
• A Data Change affects the sum of a given set of column values (e.g. limits management) - Aggregation Alerts

Alerts can be given ‘actions’ which will be performed when a Button in the Notification is clicked.?These include both those provided by AdapTable (like ‘Undo’, ‘Highlight Cell’ etc) and custom actions and buttons provided by the User at design time.

We showed how, when using AdapTable with OpenFin, all of these buttons – and associated actions – displayed automatically in the OpenFin Notification Center as OpenFin notifications with actionable buttons.

Excel

As anyone who has worked in finance will tell you, users love Excel.?If given the chance, they will do everything in Excel, because it is easy to use and enriched with every feature they would ever want.?

But Excel comes at a price: it is not designed for collaboration, it is not auditable, and it does not contain validation.

Our webinar demonstrated how AdapTable’s integration with Excel fixes all 3 of these:

1. AdapTable provides powerful exporting functionality – allowing for custom user reports to be created using queries and then exported to multiple destinations either manually or via a schedule.?When running in OpenFin these reports, when exported to Excel, are ‘Live’.?This means that Excel will update automatically to show any changes made in the grid after the export has run.
2. Similarly, any edits made in Excel are sent back to AdapTable which will update the grid and also send the details to Audit so a full record exists of who changed what and when.
3. And, best of all, validation can be extended to data exported to Excel.?So any business rules regarding legitimate data changes can be set in AdapTable and will include any edits made in Excel.?Which will then display as OpenFin notifications with actions.

In the webinar, we created a validation business rule to say that a certain column’s value could not move by more than 20%. We then demonstrated how, when that rule was broken by an Excel edit, the OpenFin Notification popped up together with an undo button allowing the user to revert the edit - and have Excel return to the previous value.

As these significant additions to functionality indicate, one plus one can equal four.?Our team at AdapTable, our colleagues at OpenFin, and our many users, can see the benefits of aligning what we each specialise in.?

And the result is a serious enrichment to what is possible in terms of day-to-day management in the financial world.

For more information or to book a personalised demo do get in touch

Take a look for yourself at the results of our collaboration by accessing the webinar recording.