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.
You may share this content using our article tools. Printing this content is for the sole use of the Authorised User (named subscriber), as outlined in our terms and conditions - https://www.infopro-insight.com/terms-conditions/insight-subscriptions/
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. Copying this content is for the sole use of the Authorised User (named subscriber), as outlined in our terms and conditions - https://www.infopro-insight.com/terms-conditions/insight-subscriptions/
If you would like to purchase additional rights please email info@waterstechnology.com
More on Data Management
$135.6m fines prompt Citi to modernize infrastructure, controls
The bank was hit with a combined $135.6 million fine on Wednesday for failing to resolve “longstanding internal controls and risk issues,” amid continued internal work across the enterprise.
SocGen pushes data, analytics use cases for SG Markets
The bank is letting a handful of clients experiment with its proprietary data and models to inform their research.
Finra clears hurdle with CAT launch, but several others remain
Two major components of the consolidated audit trail are now in place. But wrangling over the CAT’s future continues.
Ace high or busted flush? Digital Asset’s mixed fortunes mirror DLT adversity
The vendor hoped to remodel post-trade using blockchain technology—and it still might—but its bumpy progress raises questions over the future of DLT in finance.
The IMD Wrap: It’s the data, Cupid!
As BlackRock buys Preqin, and LSEG strikes a data deal with Dow Jones, Max notes that in data, strange bedfellows breed valuable offspring.
This Week: BlackRock/Preqin, Trading Technologies, FIA Tech and more
A summary of some of the past week’s financial technology news.
US banks seek to open vendors’ black box on green data
Inaugural Fed climate scenario analysis flags lack of transparency around third-party models.
IEX Cloud closure forces fintech clients to seek data alternatives
IEX says it is ditching its unprofitable data arm to focus on its core exchange business, but other vendors believe they can turn a profit from its former client base of fintechs, retail investors and some institutions.