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
Waters Wavelength Podcast: S&P’s CTO on AI, data, and the future of datacenters
Frank Tarsillo, CTO at S&P Global Market Intelligence, joins the podcast to discuss the firm’s approach to AI, the importance of data, and what might be in store for datacenters in the coming years.
Breaking out of the cells: banks’ long goodbye to spreadsheets
Dealers are cutting back on their use of Excel amid tighter regulation and risk concerns.
BMO’s cloud migration strategy eases AI adoption
The Canadian bank is embracing a more digital future as its cloud strategy makes gains and it looks to both traditional machine learning and generative AI for further augmentation.
Waters Wrap: GenAI and rising tides
As banks, asset managers, and vendors ratchet up generative AI experiments and rollouts, Anthony explains why collaboration between business and tech teams is crucial.
People Moves: NorQuant, Tradition, Duco, HKEx, SimCorp, Hazeltree, Xceptor, Broadridge, and more
A look at the past month’s people moves in the capital markets technology and data space.
Northern Trust building internal cloud data ‘marketplace’
Using a mix of in-house expertise and third-party technologies, the firm has constructed a cloud-based data mesh that gives internal staff access to proprietary datasets and analytical tools to deliver greater insights into client activity.
FactSet looks to build on portfolio commentary with AI
Its new solution will allow users to write attribution summaries more quickly and adds to its goal of further accelerating discoverability, automation, and innovation.
How Ally found the key to GenAI at the bottom of a teacup
Risk-and-tech chemistry—plus Microsoft’s flexibility—has seen the US lender leap from experiments to execution.
Most read
- Chris Edmonds takes the reins at ICE Fixed Income and Data Services
- Waters Wavelength Podcast: S&P’s CTO on AI, data, and the future of datacenters
- BMO’s cloud migration strategy eases AI adoption