Digitalising Financial Markets with Data-as-a-Service

Data-as-a-Service

How ipushpull cloud-enables firms to seamlessly share live, streaming, and on-demand data with Data-as-a-Service.

There have been many unpredicted outcomes from the current COVID-19 pandemic, but one of the more interesting ones has been the rapid acceleration of digitalisation. How rapid? Well, earlier this year, Microsoft’s CEO Satya Nadella stated that they’d seen two years’ worth of digital transformation occur within the space of two months, something that was inconceivable at the start of the year. While IBM’s CEO Arvind Krishna said “history will look back on this as the moment when the digital transformation of business and society suddenly accelerated”.

Like many other industries, the financial markets sector, with so many staff confined to working from home in 2020, has suffered severe disruption to existing workflows, forcing firms to readjust their working practices.

But with every challenge comes opportunity, and the savvier firms are looking not only at how to get through the current situation, but how they can transform their business for the better over the longer term by utilising Cloud – and specifically Data-as-a-Service (DaaS) – as an enabling technology.

What is DaaS & what can it offer?

Data-as-a-Service provides the ability to seamlessly connect your data to the right person, at the right time, in the right application. This means that you can share your data – which could be sitting in a database, in a platform, or even in a spreadsheet – with your clients, your counterparties, or your colleagues, directly into applications they’re already using. Excel spreadsheets, chat platforms, chatbots, even internal platforms via an API, for example.

ipushpull’s approach to DaaS is to integrate into both legacy and cloud-based technologies, enabling firms to access and share live, streaming, and on-demand data across the entire trade lifecycle, from the front office through to the middle and back office.

To offer a few examples, live data might be an investment bank distributing live ‘high touch’ bond axes to the buyside’s spreadsheets, OMS or chat platform. Streaming data could be where a market-maker is constantly updating quotes from an internal pricing engine, or a broker client workflow of publishing real-time prices to clients in a ‘call around market’. And on-demand means that end users can pull the most up-to-date data from any data source. Ops users may be pulling down the latest list of ISINs to match to RIC codes for example, or risk managers might need to see live P&Ls in Symphony or Slack.

All of this needs to come with the requisite enterprise security, control, and audit necessary for financial markets.

Embracing the Cloud

Historically, data sharing in capital markets has been problematic. Either it’s been done manually, through emails, file sharing, and copying/pasting data – which is then very hard to streamline, automate, and audit – or firms have had to use expensive developers to connect data together, with none of it being ‘out of the box.’

ipushpull bundles all the data and tasks that were spread across spreadsheets, email and file shares into a new structured flow into any connected application. Utilising the Cloud as an enabling technology means you can share data inter as well as intra company. You can share data to trigger workflows with external clients, customers, and teams, and do it in any application via plug and play. And using the Cloud means it’s incredibly scalable, it’s significantly cheaper than trying to build it yourself, and it has a fast time to market.

The Cloud also offers several commercial benefits for both the suppliers of data and the end-users. From the end-user perspective, only paying for what you need allows you to match and scale your operational costs more closely with your trading activity, for example.

Beneficial use cases

Where our customers already have the data and the platform, but may lack the distribution into end-user applications, they have successfully used ipushpull either for the first or the last mile of connectivity.

The first mile is where data may be unstructured or sitting in an application or system that generally does not have any external connectivity. By connecting into ipushpull, data can be securely pushed into the Cloud and then made available elsewhere.

The last mile is about getting data into the applications or tools that your clients or your teams already use, so nothing new needs to be installed. That data can be coming directly into spreadsheets, into chat, or collaborative apps such as Symphony or Slack, or straight into your internal blotters or platforms that you might be using for that last mile of distribution.

Importantly, nothing is on-premise. Everything happens via the Cloud. Rather than engage costly development teams, or rely on manual processes where someone has to copy and paste from one application to another and send it to a counterparty who is doing something similar – a process that involves lots of manual tasks, emails, spreadsheets, copy/pasting and the like – by moving to this new way of data sharing, it unlocks both technical efficiency and automation, which means your staff can spend their time on higher-value activities or things that only humans can do such as being creative, complex decision making or speaking to clients.

A growing number of firms, including panelists from our recent webinar, such as NatWest Markets and Euromoney TRADEDATA, are now utilising different flavours of the examples given above. All of them are using ipushpull to accelerate digital initiatives to widen digital distribution channels and provide better experience for their clients and workflow efficiency and automation for end-users.

Conclusion

The digitalisation of these types of use cases will become more commonplace as people question why they are still using manual processes or one-off development projects to share data. As Data-as-a-Service becomes more prominent and firms look for technical efficiency and automation, we’ll see this new way of sharing data becoming the norm.

We see it already in the digitisation and electronification of OTC markets, where manual processes make way for standardised delivery of prices and workflow, but why stop there? Live data sharing can be ubiquitous internally across the firm, and externally to clients and counterparts – all of this being accelerated by the Cloud and by integrations into financial networks like Symphony, Refinitiv, Bloomberg, Broadridge, DTCC, Markit, etc.

In the post-COVID landscape, there is no new norm anymore. There is only a future state. As working practices change, workflow needs to be more efficient, and data needs to be easy to access, secure and access-controlled.

As we move towards live data-driven workflows, people need to be able to seamlessly connect to data in any application in real-time, at the right time, at the right place, and from any location.

We’re seeing Data-as-a-Service being adopted across sales and trading, between sell-side and buy-side, and across technology vendors. All of them are providing a better and more efficient experience for their clients.

It’s time to move away from manual processes, emails, spreadsheets, and copy/paste and away from embarking on expensive development projects to connect data from one app to another. Instead, look to incorporate Data-as-a-Service into your digital transformation projects or as a new digital distribution channel.


On-demand Webinar & Report: Digitisation of Pre-trade Client Workflows

Learn how J.P. Morgan, Goldman Sachs, Insight Investment and TP-ICAP are approaching the digitisation of pre-trade client workflows.

Understand how market infrastructure providers like CurveGlobal, Symphony and ipushpull are facilitating this by improving price discovery and building liquidity through standardisation, automation and live data.

REGISTER HERE

The problem with files. Alternatives to file sharing?

file sharing

In a series of articles ipushpull explores how innovative new software products are transforming the landscape of enterprise workflow, offering cost-effective, fast-to-market solutions for big efficiency and security improvements. This is part 1 in a series of articles about alternatives to emails attachments, chat attachments and file sharing services and instead looking at new platforms that allow real-time interoperability, automation and – importantly – empower workflow efficiency.

Let’s start with the root cause of many a workflow efficiency problem, the humble file. Whether it’s a PDF, Excel spreadsheet, PowerPoint or even a CSV, files are without a doubt really useful; particularly in a world still dominated by the powerful desktop applications we know and love which were designed to store information exclusively using files.

So why is file sharing a problem?

Perhaps because of their very success, files are almost routinely used in situations where they are not a sensible tool of choice – to often damaging, and sometimes disastrous, effect. We’ve all heard, for example, of inadequate version control or access control of spreadsheet files leading to huge trading losses in securities trading or discrepancies in a company annual report. But away from these headline-grabbing cases, in aggregate far greater damage to organisations is done by the more mundane use of files day-in day-out as the dominant method of sharing information both internally or externally, whether as email attachments or on file share services.

file sharing

The perfect storm – unsecured file sharing and copy & paste errors

File-based data sharing and workflows are inherently inefficient and introduce unnecessary risks. Because files were not built with automation in mind, endless frustrated employee time is needlessly wasted manually copying and pasting and merging between files. IDC estimates that there are 5.5 million advanced spreadsheet users in Europe (and 30 million globally) who, on average, spend 28 hours a week working on spreadsheets with each user spending up to 9 hours a week repeating effort when data sources are updated. In total this adds up to €55 billion per year in wasted time. With such inefficient workflow any real time aspirations are usually just that, with even the simplest automation a challenge and often involving highly-bespoke End Used Developed (EUD) applications. And, in addition to the clear operational risks from spreadsheets, there is high potential for data loss and access control breaches with file sharing in general, combined with an ever-present threat of file-hosted viruses, trojans and the like.

All-in-all a potential perfect storm of under-performance across the business having a major impact on top and bottom line, as well as adding significant, and frankly unnecessary, security risks. All round potentially very bad for the company’s health, yet regularly overlooked or ignored.

So, what’s the solution? No files.

Businesses that have confronted this situation have gained huge competitive advantage through improved automation and efficiency, but it has come at a cost. Until now, only those prepared to invest heavily in building in-house platforms or buying expensive industry-standard super secure ‘licensed’ platforms have benefited. And where, until recently, the main driver was the improved efficiency ‘carrot’, more recently we’ve also seen law-makers focusing increasingly on data protection, privacy and (in financial markets) transparency, all combining to form quite a hefty ‘stick’ for organisations to get their act together. While there are plenty of products which aim to contain the risks of files without addressing the underlying causes, a more exciting development has been that of cloud-based workflow and collaboration platforms. Yet the common oversight among these is that most aim to replace current applications like desktop spreadsheets rather than embracing them as part of a new, secure, real-time ecosystem.

The good news is that, behind the scenes, a new generation of software platform providers have been working hard to overcome all of these problems and, because of the advantages of cloud delivery, at a price that’s well within the reach of not just top-tier enterprises. ipushpull is at the forefront of the innovative and exciting area of real-time secure data sharing. Among other things, ipushpull is replacing file sharing with flexible, yet secure and compliant, ways of connecting and sharing data in real time across powerful desktop applications (Excel) we know and love, cloud-based services (Microsoft Teams, Symphony, Slack), databases and even legacy systems. It’s called Real-time Interoperability or RTI.

Our next blog will be exploring how this is going to change our everyday working lives.

To learn more about how ipushpull is being used to automate and streamline enterprise data sharing and workflows please go to www.ipushpull.com

Excel Add-In for iPushPull: Download our new version now

We’ve been working hard here at iPushPull developing a host of exciting new features to help you get the most out of our Microsoft Excel Add-In. It’s available to download now for registered users. If you haven’t already registered, why not do it now (it’s free!)?

 

Download the latest Excel Add-In for iPushPull Now 

What’s new with the latest version of Excel Add-In

  • Our new ribbon makes finding your pages and sharing Excel content a breeze. Search and  preview  pages before pushing or pulling

 

Excel

  • Insert live pushes and pulls as new worksheets in your existing workbooks and automatically overlay web formatting over a live pull

Excel

  • New ‘URL’ option for our =iPullDisplayInfo(...) worksheet function allows you to create clickable links from your spreadsheets to iPushPull pages

Excel

  • New =iPullTime(...) worksheet function allows you to control exactly when your live pushes occur and reliably push cells containing volatile functions

Share Excel Charts Online

  • Charts! You can now share Excel charts online by pushing them to an iPushPull page just as you would any other Excel range, and even include them in a wordpress site just like this one:


  • We’ve added support for Excel 2016 and high-resolution displays
  • Vertical alignment added to cell formatting

 

There’s a lot more to discover too, so why not download it now and check out our support site for more information, tutorials, and videos. Want to know more about our popular WordPress plug-in?  You can find out all about it here: Embed live Excel spreadsheets in web pages using our Free WordPress Plugin

 

About iPushPull

iPushPull‘s services enable its customers to securely share live data between desktop applications like Microsoft Excel, and distribute documents and research on a fully access-controlled and audited platform.  With iPushPull’s Research Delivery Platform you can take control of your research distribution. To date, it has won two UK Government grants for its innovative research and development work.