|
|
 Overview : Advantages : Databases : Graphics : Technical
MarketQA Advantages
Clean, Normalized Databases
Quantitative Analytics, Inc. offers financial data provided by major national
and international vendors. This data is checked and corrected daily by QAI staff. Advanced software normalizes
the vendor identifiers across all data vendors globally. Use of a single QAI identifier alleviates the confusion caused by
vendors using varying identifiers to represent the same issue.
Automatic Updates via FTP
QAI’s communication software updates financial databases at the client location.
These mutliple daily updates are automated to run during non-market hours and require no manual intervention. The software
checks for a complete file transmission so interrupted downloads and partial files are never a problem.
Cost
MarketQA software and databases are competitively priced research tools.
Performance
Optimized, efficient, proprietary algorithms ensure high processing speeds and performance.
Language Flexibility
QAL is a full programming language, which provides flexibility when combined with
the normalized database. QAL enhances productivity and eliminates the
frustration of a constraining point-and-click interface. MarketQA also has a C/C++ API.
Local Databases
The MarketQA database and software resides on a pc or server at the client site and is
updated automatically overnight, providing the highest level of security, flexibility, and processing performance available.
Presentation Flexibility
MarketQA also integrates seamlessly with commonly used software packages like SQL Server, S-PLUS®, MATLAB®, SAS®, and Excel™.
Portfolio Re-Balance Capabilities
MarketQA software allows rebalancing to daily granularity or on
a conditional basis, allowing the user to buy and sell securities based on security-level rules. Most other quantitative
back-testing tools only allow rebalancing on a monthly basis.
Batch Processing Capabilities
Through the Windows CMD language, MarketQA allows the user to
batch large lists of queries for future processing. Batch files can be added to the update program and executed when updates
are completed, which means time-consuming queries can be run at non-peak times. Using MarketQA's table trigger capabilities,
queries can be triggered to run after specific updates are processed.
Ability to Add New Functionality
Because QAL is a function language, adding new functionality is easy. All MarketQA
interfaces are driven with functions and no interface changes are necessary when a new function is added. The MarketQA C/C+ API allows users to define their own functions and product development is driven
by user suggestions, which are always encouraged.
Proprietary Data Storage
Users can load proprietary data, either individual series or matrices. This proprietary data is
normalized to QAI identifiers and then may be retrieved as quickly and efficiently as the supported databases.
Tick Data Analysis
MarketQA provides a seamless interface to tick data. With this interface, users can integrate tick data with any
other database and also run back tests as with any other database.
Powerful Programming Language
Quantitative Analytics Language (QAL) is used to retrieve
and analyze all data stored in the database. With over 1,000 functions, users can analyze data in any mathematical way. A C++ API
also allows the user to expand functionality. Click here to view image
Command-Line Queries
Command-line queries save time by automating daily tasks. These queries can be run automatically after updates, at non-peak times.
Portfolio Builder
This tool provides the ability to construct large portfolios of securities and weights. Users can rebalance dynamically,
query, back-test, sort and rank.
|
|
