Integrated VBAWhy clients choose our solutions

Why should you have to learn a proprietary scripting language for complex procedures and algorithms, when VBA (Visual Basic for Applications) is already heavily utilised, fully supported and accessible?


Does this help in trading/risk analysis? Absolutely!
  • Allowing personnel to quickly integrate into the unique problem solving operation
  • Saves time and money on hiring specialised software experts
  • Delivers precisely what users need
  • Fully integrated with Genic DataManager
  • Versioned with source safe

Why did we use VBA?

Most database applications provide some form of query or expression-oriented language, allowing the user free-form interaction and manipulation with the Database. However, invariably, the language is proprietary in nature, with a steep learning curve and heavy support requirement. DataGenic wanted to move away from anything proprietary. That included the database environment, the operating system, the application server, and the user interactive language.

Used by millions of users worldwide, VBA is functionally rich and extremely flexible: Additionally, there is usually client in-house expertise and a comfort factor of knowledge. DataGenic extend the power of VBA by providing a .NET API to access Genic DataManager via our web services layer.

Any VBA (or Action) can be imposed on a Template or User Defined Group. Additionally, all VBA code is saved on the Genic DataManager server (acting as a source-safe) and any changes are recorded, versioned and reported. Users also have the ability to roll-back to previous versions.