Spreadsheets Still Rule, But for How Long?
It's a common refrain that I've heard in many different ways, and at many different times, to describe many different things: We need to automate and move away from our dependence on spreadsheets.
Even with this common battle cry, though, walk through the halls of most any asset manager and you will see a portfolio manager, trader, risk officer or compliance officer scanning through a spreadsheet, and more than likely it will be a Microsoft Excel spreadsheet.
There have been tremendous advancements when it comes to data aggregation techniques and reporting capabilities in recent years. Cloud and hosted solutions populate the market for order management and compliance-related systems alike. Even still, there's a comfort level that spreadsheets enjoy and undeniably, spreadsheets are very, very cheap to manage. Sure, they can be a bit of a pain, but in familiarity there's comfort.
I would've thought that after 2008 there would be a true sea change toward automation. And to an extent, there has been a shift with added investment in end-to-end automated platforms. Gary Brackenridge, who head's Linedata's hedge funds business, says that this can prove a long and slow-to-develop process at large buy-side institutions.
While the largest firms are trying to untangle systems already in place, startup hedge funds and asset managers are relying on familiarity and cost cutting wherever possible. Two different explanations explain the same behavior.
Most startups have only a few people on staff and it's relatively easy to monitor the firm's risk and positions through a spreadsheet. The key is in knowing when to move to an automated solution as the firm grows.
But Brackenridge does note one potentially new driving force in favor of automation: investors, themselves.
As investors become savvier about how a firm manages its risk and positions, they may be more forceful in demanding that the firm reduce or drop its reliance on spreadsheets entirely. While some may like to believe that regulators are the most effective agents of change, in reality money rules and investor dollars will prove a better cattle prod in this regard.
For the March issue of Waters I'll be looking at this topic in depth. If you have any insight, feel free to shoot me an email (anthony.malakian@incisivemedia.com) or give me a call 646-490-3973.
Only users who have a paid subscription or are part of a corporate subscription are able to print or copy content.
To access these options, along with all other subscription benefits, please contact info@waterstechnology.com or view our subscription options here: http://subscriptions.waterstechnology.com/subscribe
You are currently unable to print this content. Please contact info@waterstechnology.com to find out more.
You are currently unable to copy this content. Please contact info@waterstechnology.com to find out more.
Copyright Infopro Digital Limited. All rights reserved.
As outlined in our terms and conditions, https://www.infopro-digital.com/terms-and-conditions/subscriptions/ (point 2.4), printing is limited to a single copy.
If you would like to purchase additional rights please email info@waterstechnology.com
Copyright Infopro Digital Limited. All rights reserved.
You may share this content using our article tools. As outlined in our terms and conditions, https://www.infopro-digital.com/terms-and-conditions/subscriptions/ (clause 2.4), an Authorised User may only make one copy of the materials for their own personal use. You must also comply with the restrictions in clause 2.5.
If you would like to purchase additional rights please email info@waterstechnology.com
More on Data Management
Facing platform shutdown, former IEX Cloud head buys its assets in 11th-hour bid
Tim Baker, Pedro Aguayo, and a silent partner have come together to purchase IEX Cloud’s assets days before the exchange was to retire all its products on August 31.
New working group to create open framework for managing rising market data costs
Substantive Research is putting together a working group of market data-consuming firms with the aim of crafting quantitative metrics for market data cost avoidance.
Off-channel messaging (and regulators) still a massive headache for banks
Waters Wrap: Anthony wonders why US regulators are waging a war using fines, while European regulators have chosen a less draconian path.
Back to basics: Data management woes continue for the buy side
Data management platform Fencore helps investment managers resolve symptoms of not having a central data layer.
‘Feature, not a bug’: Bloomberg makes the case for Figi
Bloomberg created the Figi identifier, but ceded all its rights to the Object Management Group 10 years ago. Here, Bloomberg’s Richard Robinson and Steve Meizanis write to dispel what they believe to be misconceptions about Figi and the FDTA.
SS&C builds data mesh to unite acquired platforms
The vendor is using GenAI and APIs as part of the ongoing project.
Aussie asset managers struggle to meet ‘bank-like’ collateral, margin obligations
New margin and collateral requirements imposed by UMR and its regulator, Apra, are forcing buy-side firms to find tools to help.
Where have all the exchange platform providers gone?
The IMD Wrap: Running an exchange is a profitable business. The margins on market data sales alone can be staggering. And since every exchange needs a reliable and efficient exchange technology stack, Max asks why more vendors aren’t diving into this space.