C A L CNO D E
The next Generation of managed Market Data Distribution
H
M
S
HMS-CALC
N
ODE
Investment Banking Asset Management Risk Management
The Business speaks Microsoft Excel…
Mid Office Back Office Retail Banking Corporate Banking
…but individual Solutions have Risks!
Difficult Management Business Loss
High operational Costs Maintenance &
What could be the best Solution for FSI’s …
that helps reduce operational Risks
but retains
individual Creativity
That simplifies real time calculation process and guarantees proper results
that standardizes Excel Maintenance & Support
+
gives more Power & Flexibility
that makes it possible to distribute results
(Bank instruments) internally
Market Data Platform + Calculation Platform IT-Governance & Business Compliance Market Data Cost cutting Production of reliable „derived Data“ Low Latency cost-efficient & short ROI HMS-CALCNODE … Microsoft Standard Products
Managed & controlled Excel Calculation Process...
… to meet Requirements for Compliance
Server Side Workbooks
Versions Management
Logging of Calculation and Data Retrieval Process
CALCNODE Frontend Excel 2010 - 64bit Internal Market Data Distribution HMS Market Data Platform
Technology Innovation
HMS-Blade
API
Hardware based Messaging Solace Content Router
Microsoft’s new Office Products 100% Microsoft .Net Technology Microsoft’s new Generation Servers Proven state of the art Messaging HW
Same Technology for Data Vendors and In-house Feeds using Excel RTD …
… preserving original Provider Symbols
Excel RTD Formula HMSDLL Provider S=Subscribe P= Publish Original Provider
Symbol Original Provider Field
100 % CPU workload Reductionof CPU workload by 90% Outsorcing to CALCNODE Server
Excel •Trading Excel •Risk
Management
Excel •Back office
Excel •Other Departments Application •Branches Partner Bloomberg Reuters Math Lib Morningstar Calculation & Market Data Visualisation
Separation of Visualization and…
Real-time Excel Calculations under Server Conditions...
… for creating own Bank Values „Derived Data“!
Internal Distribution of Derived Market Data means avoiding fees for original Data
Speeding up calculation of pricing functions …
… between 10 and 1000 times by reducing the redundancy in the computational process
!
Time for sheet evaluation:
613,9 seconds
using Excel only
Time for sheet evaluation:
1,
3 secondsUsing Theta Proxy
100% Microsoft Technology together with
Hardware based Messaging from Solace Systems
De pl oy CALC UDF CALC UDF Monte Carlo UDF
Moos-müller QuantLib UDF
O rigina l V ie w ing Bloomberg Reuters Morningstar EMI L CNVS– Excel V W D CALCNODE 64 bit Excel Runner E MI L EMI L MS® Excel® 14 HPC Server® 2008 CA L C N O DE Se rv ic e Ac c es s Deployment Management DB Management Access Control User Communication
View Sheets Generator HPC Communication Calcnode Mastersheets CNMS XLS XLS XLS XLS CALCNODE Provider / Feed EMI L Trader Sheet HMS HMS HMS Publish Subscribe
What’s in it
for an FSI?
Increased Transparency & Governance
Reduction of Operational Risks
Management of centralized Market Data Calculation High speed, High volume Distribution
Distribution Calculation
Market Data
Business Improvement
Shorter Time to Market of new Products
Business Improvement establishing a Company wide standardized, real-time, low latency distribution of calculated financial ratios Time to Market Calculation of complex Products in Excel14
C A L CNO D E
BCC Group International GmbH & Co. KG Odenwaldring 9
D- 63110 Rodgau
Tel.: +49 700 1020 9000 Mobil: +49 177 797 04 56
BCC Group International GmbH & Co. KG Odenwaldring 9 D- 63110 Rodgau Tel.: +49 700 1020 9000
Backup Slides:
The CALCNODE
Structured Server Deployment for Excel Calculation … API Original Excel Designer Excel Control Excel Master Excel Copy Copy Copy Deploy to Server HMS-Formula HMS-Formula Deploy locally
Closed after design start
Simple Design Process
Creation of new Symbols for internal market data distribution
Control Sheet and Viewing Sheets with calculated Bank internal instruments & Values Master Sheet
with market data to calculate internal instruments and values
