Frequently Asked Questions
  1. Thanks for sending additional @nalyst products with my Financial (or Bond, Options, etc.) @nalyst purchase. How can I get the other products to work?
    Although you may have ordered only a few @nalyst products, we may send you additional components of our @nalystsoftware so that if you wish to purchase and use the other modules, you can do so without delay. The additional modules will not function however, until you purchase license keys for them.

  2. Can I use @nalyst in Visual Basic, or as a macro?
    The @nalyst products are Excel add-ins, and are compiled for high speed. For this reason, they cannot be accessed directly from Visual Basic or macros.
    For developing Visual Basic applications, you can use QuantTools, our line of C/C++, Java and VB callable object libraries.
    You can use @nalyst indirectly from Visual Basic for Applications within Excel only by using the "Run" command. For example:

    Public Function sum_of_lcm_and_gcd(a, b)
    sum_of_lcm_and_gcd = Run("lcm", a, b) + Run("gcd", a, b)
    End Function

    Now sum_of_lcm_and_gcd can be used as a spreadsheet function.

  3. I tried to install @nalyst on my local machine, but the installation program doesn't work.
    If you are installing @nalyst on a Windows NT/2000 or Unix machine, be sure that you have appropriate privileges. Call us if you have any other problems.

  4. @nalyst runs fine on older versions of Excel, but some functions give different answers with Excel 97.
    Add-in functions that return an array formula may not work properly with some versions of Microsoft Excel 97 due to a bug in Excel introduced by Microsoft. This means that functions which return array values will (a) run significantly slower than they should, and (b) may sometimes produce inaccurate results.
    The solution to this problem is to upgrade to Office 97 service release 1 or higher.
    We recommend that you do not use Excel 97 unless you can patch it with SR-1.

  5. When using QuantTools for Visual Basic, I get an error message:
    Run-time error '48'
    File not found v_<name of dll>.dll
    The QuantTools dlls must either be in the same directory as the executable or must be in the library search path. Either copy the dlls to WINDOWS\SYSTEM (Windows 9x) or WINNT\SYSTEM32 (Windows NT 4.0/2000), or, modify your path to include the directory where the QuantTools dlls are located, e.g. C:\vb_98_70\libs