Spreadsheet Transparency in the Blink of an Eye
Major financial institutions and most businesses depend on user-generated models in the form of spreadsheets.
Portfolios are managed, decisions supported, and prices created; All by spreadsheets, many of which use real-time external data.
However, the data used in spreadsheets is rarely documented so you don’t know who is using what instruments, from what vendor.
Census discovers these external market data calls!
…right down to the instrument ID and field identifiers
Ropnoy offers ‘real-time’ spreadsheet discovery, analysis and reporting services and provide management overview and drilldown capability to rapidly interrogate spreadsheets and critically, highlight their external dependencies.
Our service is fast, highly efficient and includes built in modules to facilitate the discovery of specific Vendor API data calls and the external links between spreadsheets.
We can Identify the size and breadth of your Spreadsheet landscape including real-time add-ins (Bloomberg, Reuters) Contribution, downstream linking of Exchange information, and using Business Intelligence, we provide informed decisions that will help to keep your firm compliant and your data use and distribution in check.
We can even provide an extract of every instrument used in your spreadsheets; by vendor!
Market Data Vendor dependency
Exchange Data distribution
Linked Spreadsheet dependencies
User / Desk Profiling
Application API dependency
Compatible with all vendor and in-house developed Excel API’s
Scalable from single share to Enterprise SAN
Low overhead – Agent-less deployment
Fast and effective
Project and Enterprise licencing available – and now available as a Snapshot service