Live by Excel, Die by Excel

By By Derrick Harris, Editor

March 17, 2008

Although Wall Street firms are widely regarded as among the biggest, most cutting-edge spenders in the world of enterprise IT — doing and paying whatever it takes to achieve a competitive advantage — there is one area in particular where performance and efficiency are suffering because of unwillingness to let go of the past.

On the trading floors of even the world’s largest firms, the large numbers (perhaps the majority) of traders are using Microsoft Excel-based applications on their desktops for analytical tasks. However, given that data is growing exponentially in both volume and complexity, Excel is fast becoming a major hindrance to completing these analyses with the speed required to keep ahead of the competition. One might say these trading floors are giving rise to their own cliché: live by Excel, die by Excel.

Geva Perry, chief marketing officer at GigaSpaces, speaks of traders so attached to Excel that abandoning the software is not an option, even though having to wait up to 12 minutes for a simple spreadsheet refresh severely affects their efficiency, and sharing models can be a difficult undertaking in a desktop environment. Their reasons for sticking with Excel, though, are perfectly understandable: traders have spent lots of time and resources building their Excel-based models and, frankly, they like it.

Amnon Raviv, GigaSpaces’ director of strategic alliances, has tales of his own, including a recent fieldtrip to the trading floor at a large Wall Street firm where he witnessed traders running up to six spreadsheets and Excel-based applications on their desktops all day long. Echoing Perry’s take, Raviv said that both the traders and their specialized IT teams know and love Excel, in large part for its highly customizable nature that allows them to create new tools on the fly. In fact, he added, efforts by firms’ central IT teams to implement enterprise-level replacements to Excel often fail because of these affinities.

However, despite the love for Excel on the trading floor, the harsh reality is that Excel just is not designed to handle today’s increasingly complex and data-intensive analytic jobs, and in many cases has become “unworkable.” “Nobody sits down and makes a grand plan of how they’re going to build these Excel applications,” explained Perry. “These guys start building their models, and over time the models grow in complexity and the volumes of data — as they always do — grow and grow and grow, and at some point, they’re basically facing a situation where they’re using a tool, like Microsoft Excel, that really wasn’t meant for that kind of complexity … and volume.”

In an attempt to let traders keep their beloved Excel while simultaneously experiencing major improvements in speed, efficiency and reliability, GigaSpaces concerted with Microsoft to develop a solution that moves Excel server-side. Users of the new tool will benefit from GigaSpaces’ eXtreme Application Platform (XAP), which leverages an in-memory data grid to ensure fast access to critical data; co-locates data and business logic to maximize performance; offers automatic failover and high availability; scales linearly with commodity hardware; and can handle application written in a variety of languages, including Java, .NET and C++.  The end result, said Perry, is that users will interact with Excel like they do a Web browser, but with all the data access and processing taking place on the XAP-powered grid.

Stevan Vidich, an industry architect for Microsoft Financial Services, says the combination of XAP and Excel should be very appealing, as many uses of Excel require low-latency access to large volumes of data, and desktops are rather limited in terms of how much memory and data they can handle. What do you do when you need to access a lot more data, or when you can’t afford to access it from the same database where other users are competing for resources? Now, he noted, an Excel frontend can handle live market data, streaming applications and intensive processing. Since commencing work with GigaSpaces, when Vidich’s clients (which include Bank of America, Barclays, Citi and Merrill Lynch, to name a few) bring up their concerns about how to handle their complex Excel-based jobs — such as “non-trivial, not-so-perfectly-parallel” Monte Carlo simulations — Vidich brings up GigaSpaces.

“[The] perfect customer is one that uses GigaSpaces and has challenges with Excel on the desktop. And, I’ll tell you, that’s just about every GigaSpaces user because in their world, they encounter a situation where the volumes of data are very large,” explains Vidich. “How do you make changes propagate to all of the end users very quickly, and how do you not only process a large volume of data, but how can you do it with very low latency?”

Another selling point is that in addition to working with the presently ubiquitous Excel 2003, GigaSpaces’ solution also is compatible with Excel 2007 and Microsoft Office SharePoint Server, which can cater to thousands of users. Using Excel Services on SharePoint along with XAP, explains Vidich, calculations carried out on the Sharepoint server and rendered on a user’s desktop inside a browser also integrate with the data grid. And although Excel 2007 does not support Visual Basic, GigaSpaces’ solution will not suffer adverse effects as VBA code is converted during the upgrade process, said GigaSpaces’ Raviv.

Trader productivity is the No. 1 driver here, added Raviv, but “the IT guys are loving the idea that we can give them better return on investment and utilization of their datacenter, of their backend.”

As alluded to above, the potential market for a solution like this is vast. GigaSpaces’ Perry believes it will be a large part of the company’s business, as discussions have shown him that all of GigaSpaces’ financial services customers have “a very strong need” for it. According to Raviv, although the partnership is very recent, GigaSpaces already is in discussions with “at least a dozen” of the top 50 financial services firms (all of whom have problems with Excel), who are in various stages of evaluating the solution. He expects it will be two to three months before a customer is in production with it.

Additionally, Perry is excited about this partnership opening streams to Microsoft’s channel partners — something Vidich assures will happen. He said that a full-blown marketing and customer response campaign will take place at some point, and that although this is a GigaSpaces product, Microsoft will help broker discussions with its customers who are suffering because of their outgunned Excel environments.

If Raviv is correct, the Excel adapter should have legs outside of the financial market, as well. He points to the energy industry — specifically upstream oil & gas and energy trading — as closely mirroring the financial services industry. They also are using desktop-hosted Excel for applications it was not intended to run, such as Monte Carlo and value-of-trade applications, and they also have very large backend grids. The problem, said Raviv, is “they don’t have that glue, the ability to offload the data and the computation from Excel to the grid.” He also cites insurance and corporate treasury as areas that could benefit from this solution.

“This solution will be applicable to just about everyone who is using Excel and has a data challenge,” summarizes Microsoft’s Vidich, “because the trends in escalation of data volumes and complexity of algorithms used to do calculations is not reversible.”

Subscribe to HPCwire's Weekly Update!

Be the most informed person in the room! Stay ahead of the tech trends with industy updates delivered to you every week!

Penguin Computing Brings Cascade Lake-AP to OCP Form Factor

July 7, 2020

Penguin Computing, a subsidiary of SMART Global Holdings, Inc., is announcing a new Tundra server, Tundra AP, that is the first to implement the Intel Xeon Scalable 9200 series processors (codenamed Cascade Lake-AP) in t Read more…

By Tiffany Trader

Google Cloud Debuts 16-GPU Ampere A100 Instances

July 7, 2020

On the heels of the Nvidia's Ampere A100 GPU launch in May, Google Cloud is announcing alpha availability of the A100 "Accelerator Optimized" VM A2 instance family on Google Compute Engine. The instances are powered by t Read more…

By Tiffany Trader

Q&A: HLRS’s Bastian Koller Tackles HPC and Industry in Germany and Europe

July 6, 2020

HPCwire: Let's start with HLRS and work our way up to the European scale. HLRS has stood out in the HPC world for its support of both scientific and industrial research. Can you discuss key developments in recent years? Read more…

By Steve Conway, Hyperion

The Barcelona Supercomputing Center Offers a Virtual Tour of Its MareNostrum Supercomputer

July 6, 2020

With the COVID-19 pandemic continuing to threaten the world and disrupt normal operations, facility tours remain a little difficult to operate, with many supercomputing centers having shuttered facility tours for visitor Read more…

By Oliver Peckham

What’s New in Computing vs. COVID-19: Fugaku, Congress, De Novo Design & More

July 2, 2020

Supercomputing, big data and artificial intelligence are crucial tools in the fight against the coronavirus pandemic. Around the world, researchers, corporations and governments are urgently devoting their computing reso Read more…

By Oliver Peckham

AWS Solution Channel

Maxar Builds HPC on AWS to Deliver Forecasts 58% Faster Than Weather Supercomputer

When weather threatens drilling rigs, refineries, and other energy facilities, oil and gas companies want to move fast to protect personnel and equipment. And for firms that trade commodity shares in oil, precious metals, crops, and livestock, the weather can significantly impact their buy-sell decisions. Read more…

Intel® HPC + AI Pavilion

Supercomputing the Pandemic: Scientific Community Tackles COVID-19 from Multiple Perspectives

Since their inception, supercomputers have taken on the biggest, most complex, and most data-intensive computing challenges—from confirming Einstein’s theories about gravitational waves to predicting the impacts of climate change. Read more…

OpenPOWER Reboot – New Director, New Silicon Partners, Leveraging Linux Foundation Connections

July 2, 2020

Earlier this week the OpenPOWER Foundation announced the contribution of IBM’s A21 Power processor core design to the open source community. Roughly this time last year, IBM announced open sourcing its Power instructio Read more…

By John Russell

Google Cloud Debuts 16-GPU Ampere A100 Instances

July 7, 2020

On the heels of the Nvidia's Ampere A100 GPU launch in May, Google Cloud is announcing alpha availability of the A100 "Accelerator Optimized" VM A2 instance fam Read more…

By Tiffany Trader

Q&A: HLRS’s Bastian Koller Tackles HPC and Industry in Germany and Europe

July 6, 2020

HPCwire: Let's start with HLRS and work our way up to the European scale. HLRS has stood out in the HPC world for its support of both scientific and industrial Read more…

By Steve Conway, Hyperion

OpenPOWER Reboot – New Director, New Silicon Partners, Leveraging Linux Foundation Connections

July 2, 2020

Earlier this week the OpenPOWER Foundation announced the contribution of IBM’s A21 Power processor core design to the open source community. Roughly this time Read more…

By John Russell

Hyperion Forecast – Headwinds in 2020 Won’t Stifle Cloud HPC Adoption or Arm’s Rise

June 30, 2020

The semiannual taking of HPC’s pulse by Hyperion Research – late fall at SC and early summer at ISC – is a much-watched indicator of things come. This yea Read more…

By John Russell

Racism and HPC: a Special Podcast

June 29, 2020

Promoting greater diversity in HPC is a much-discussed goal and ostensibly a long-sought goal in HPC. Yet it seems clear HPC is far from achieving this goal. Re Read more…

Top500 Trends: Movement on Top, but Record Low Turnover

June 25, 2020

The 55th installment of the Top500 list saw strong activity in the leadership segment with four new systems in the top ten and a crowning achievement from the f Read more…

By Tiffany Trader

ISC 2020 Keynote: Hope for the Future, Praise for Fugaku and HPC’s Pandemic Response

June 24, 2020

In stark contrast to past years Thomas Sterling’s ISC20 keynote today struck a more somber note with the COVID-19 pandemic as the central character in Sterling’s annual review of worldwide trends in HPC. Better known for his engaging manner and occasional willingness to poke prickly egos, Sterling instead strode through the numbing statistics associated... Read more…

By John Russell

ISC 2020’s Student Cluster Competition Winners Announced

June 24, 2020

Normally, the Student Cluster Competition involves teams of students building real computing clusters on the show floors of major supercomputer conferences and Read more…

By Oliver Peckham

Supercomputer Modeling Tests How COVID-19 Spreads in Grocery Stores

April 8, 2020

In the COVID-19 era, many people are treating simple activities like getting gas or groceries with caution as they try to heed social distancing mandates and protect their own health. Still, significant uncertainty surrounds the relative risk of different activities, and conflicting information is prevalent. A team of Finnish researchers set out to address some of these uncertainties by... Read more…

By Oliver Peckham

[email protected] Turns Its Massive Crowdsourced Computer Network Against COVID-19

March 16, 2020

For gamers, fighting against a global crisis is usually pure fantasy – but now, it’s looking more like a reality. As supercomputers around the world spin up Read more…

By Oliver Peckham

[email protected] Rallies a Legion of Computers Against the Coronavirus

March 24, 2020

Last week, we highlighted [email protected], a massive, crowdsourced computer network that has turned its resources against the coronavirus pandemic sweeping the globe – but [email protected] isn’t the only game in town. The internet is buzzing with crowdsourced computing... Read more…

By Oliver Peckham

Global Supercomputing Is Mobilizing Against COVID-19

March 12, 2020

Tech has been taking some heavy losses from the coronavirus pandemic. Global supply chains have been disrupted, virtually every major tech conference taking place over the next few months has been canceled... Read more…

By Oliver Peckham

Supercomputer Simulations Reveal the Fate of the Neanderthals

May 25, 2020

For hundreds of thousands of years, neanderthals roamed the planet, eventually (almost 50,000 years ago) giving way to homo sapiens, which quickly became the do Read more…

By Oliver Peckham

DoE Expands on Role of COVID-19 Supercomputing Consortium

March 25, 2020

After announcing the launch of the COVID-19 High Performance Computing Consortium on Sunday, the Department of Energy yesterday provided more details on its sco Read more…

By John Russell

Steve Scott Lays Out HPE-Cray Blended Product Roadmap

March 11, 2020

Last week, the day before the El Capitan processor disclosures were made at HPE's new headquarters in San Jose, Steve Scott (CTO for HPC & AI at HPE, and former Cray CTO) was on-hand at the Rice Oil & Gas HPC conference in Houston. He was there to discuss the HPE-Cray transition and blended roadmap, as well as his favorite topic, Cray's eighth-gen networking technology, Slingshot. Read more…

By Tiffany Trader

Honeywell’s Big Bet on Trapped Ion Quantum Computing

April 7, 2020

Honeywell doesn’t spring to mind when thinking of quantum computing pioneers, but a decade ago the high-tech conglomerate better known for its control systems waded deliberately into the then calmer quantum computing (QC) waters. Fast forward to March when Honeywell announced plans to introduce an ion trap-based quantum computer whose ‘performance’ would... Read more…

By John Russell

Leading Solution Providers

Contributors

Neocortex Will Be First-of-Its-Kind 800,000-Core AI Supercomputer

June 9, 2020

Pittsburgh Supercomputing Center (PSC - a joint research organization of Carnegie Mellon University and the University of Pittsburgh) has won a $5 million award Read more…

By Tiffany Trader

‘Billion Molecules Against COVID-19’ Challenge to Launch with Massive Supercomputing Support

April 22, 2020

Around the world, supercomputing centers have spun up and opened their doors for COVID-19 research in what may be the most unified supercomputing effort in hist Read more…

By Oliver Peckham

Nvidia’s Ampere A100 GPU: Up to 2.5X the HPC, 20X the AI

May 14, 2020

Nvidia's first Ampere-based graphics card, the A100 GPU, packs a whopping 54 billion transistors on 826mm2 of silicon, making it the world's largest seven-nanom Read more…

By Tiffany Trader

Australian Researchers Break All-Time Internet Speed Record

May 26, 2020

If you’ve been stuck at home for the last few months, you’ve probably become more attuned to the quality (or lack thereof) of your internet connection. Even Read more…

By Oliver Peckham

10nm, 7nm, 5nm…. Should the Chip Nanometer Metric Be Replaced?

June 1, 2020

The biggest cool factor in server chips is the nanometer. AMD beating Intel to a CPU built on a 7nm process node* – with 5nm and 3nm on the way – has been i Read more…

By Doug Black

15 Slides on Programming Aurora and Exascale Systems

May 7, 2020

Sometime in 2021, Aurora, the first planned U.S. exascale system, is scheduled to be fired up at Argonne National Laboratory. Cray (now HPE) and Intel are the k Read more…

By John Russell

Summit Supercomputer is Already Making its Mark on Science

September 20, 2018

Summit, now the fastest supercomputer in the world, is quickly making its mark in science – five of the six finalists just announced for the prestigious 2018 Read more…

By John Russell

TACC Supercomputers Run Simulations Illuminating COVID-19, DNA Replication

March 19, 2020

As supercomputers around the world spin up to combat the coronavirus, the Texas Advanced Computing Center (TACC) is announcing results that may help to illumina Read more…

By Staff report

  • arrow
  • Click Here for More Headlines
  • arrow
Do NOT follow this link or you will be banned from the site!
Share This