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
Hub to lay off 20% of staff, sources say
Hub’s CEO says this is simply a case of a startup trying to stay nimble and efficient; others say it points to deeper issues.
TS Imagine integrates LTX’s pre-trade analytics tool
Users of the fixed-income EMS will now have access to LTX’s Liquidity Cloud tool, which provides a pre-trade score for the likelihood of trading success.
After contentious Opra upgrades, vendors brace for a faster future
Upgrades to the datafeed widely used to gauge the current market price for options contracts went into effect in February after three separate delays, which market participants say were caused by persistent bandwidth issues at some important recipients.
The IMD Wrap: No more turf wars, or why CDOs should heed the Voice of the CTO
Max reviews how our recent Voice of the CTO series has implications for those beyond a firm’s technology function, and how communication and collaboration between tech, data, and leadership will deliver better results.
Dark horse: Deutsche Börse building dark pool
New functionality allowing exchange members to execute sweep trades comes hot on the heels of European rival Euronext launching its own dark pool.
Man Group’s proprietary data platform is a timesaver for quants
The investment firm’s head of data delves into its alt data strategy and use of AI tools to boost quant efficiency.
Waters Wrap: The tough climb for startups
Anthony speaks with two seasoned technologists to better understand why startups have such a tough time getting banks and asset managers to sign on the dotted line.
As crypto ETFs become reality, benchmark providers take center stage
The SEC’s approval of the first spot bitcoin ETFs will expose a growing number of traditional market participants to the maturing world of crypto data, a moment that some—such as CF Benchmarks, BlackRock’s benchmark provider—have been eagerly awaiting.
Most read
- Women in Technology & Data Awards 2024: All the winners and why they won
- Witad Awards 2024: Above and beyond award (vendor)—Susan Bennett, Tradeweb
- Fighting FAIRR: Inside the bill aiming to keep AI and algos honest