|
|
Features
Below is a brief description of some selected Proto features. For comprehensive reference material and tutorials, please visit the Developer Center. If you have any questions about Proto's capabilities, don't hesitate to contact us.
Charts & Graphs
- Includes common graph types like bar, pie, scatter, line, contour, and surface
- Graphs support interactive drilldown and filtering, use the mouse to select underlying data from a graph to use in subsequent reports
- Customize graph "look and feel" parameters through simple dialogs
- Graphs support autoscaling, resizing, formatting dates, text, and numbers
- Create and integrate completely custom interface controls with Adobe Flash
Importing Data
- Read data from Excel and subscribe to updates from live Excel spreadsheets
- Read data from text files such as CSVs
- Access data available via WSDL-backed web services
- Dynamically connect to and query databases
- Create any data-import capability through Visual Basic for Applications and COM
- Import data and analytics in historical or real-time mode from Bloomberg Professional Service (Proto Financial only)
Manipulating Data and Performing Calculations
- Flexible built-in modules for filtering and sorting
- Includes modules to automate normalizing and altering the structure of incoming datasets: rename/reorder columns, replace data with VLOOKUP-like functions, etc.
- Built-in modules to easily apply formulas, calculations, or custom routines built in Proto to any dataset
- Support for dynamic "Pivot"-style summaries with drill down capability
- Easily involve end users to handle edge cases and check results when oversight is needed
- Enrich and combine data from disparate sources with flexible joins, merges, etc.
- Full embedded VBA environment allows you to implement any type of data manipulation or calculation necessary
Exporting Data
- Export any raw dataset to Excel or clipboard
- Write data to pre-formatted Excel workbooks that end users can edit to create new custom reports
- Write data to flat files such as CSV, and create custom output formats
- Update databases, insert and delete records
- Update WSDL-backed web services
- Take "live" interactive dashboards on the road for use in presentations or onscreen
User Interaction
- Built-in UI controls include: buttons, sliders, checkboxes, tables, listboxes, date choosers, textboxes, and interactive graphs
- Manage multi-screen interfaces with Proto's Workflow Steps feature and pop-up windows
- Configure the UI in a completely mouse-driven, WYSIWIG environment on the fly
- Quickly customize the UI of a tool to suit different end users' preferences
- Interactive, flexible UI elements make it possible to pack more information on a single screen than Excel-based interfaces
- Embed a Web Browser window into dashboards to display HTML data and webpages
Scripting & Extension
- Integrated Visual Basic for Applications environment means your existing VBA knowledge can be transferred directly to Proto
- VBA allows interfacing with COM objects so you can connect to custom DLLs and hundreds of useful libraries
- Excel interoperability allows existing, complex Excel models to be normalized into a "function" and applied over a large dataset
- Web Services module opens up connectivity to SAAS applications and other web servics
|