QcXLL.com

QuickCache Functions

QuickCache Functions

The QuickCache functions are grouped in 15 categories:

  1. Bond Functions

    2. Creating bond contracts, calculating various values of bonds: price, yield, duration, convexity, cash flows, pvbp, etc.

  2. Cache Functions

    3. Storing data matrix into in-memory Caches. Then the data can be easily and efficiently retrieved and passed to different functions by a cache name. The Caches can also be written into file and read from file in various formats.

  3. Curve Functions

    4. Building yield term structures, aka curves. The curves can be used to evaluate fixed income instruments.

  4. Database Functions

    5. A simple way to query various databases: Access, MySQL, Oracle, PostgreSQL, SQL server, and others via ODBC. The query only occupies one Excel cell and stores the query result into a Cache. The user can run a complete SQL statement through the “RawSQL” argument or run simpler query via the Select, From, Where, GroupBy, and OrderBy arguments.

  5. DateTime Functions

    6. Getting the current time or date in a time zone. The user can add date or time by a simple token – for example “2w” is adding two weeks. There are also functions to get IMM codes or IMM dates, or to calculate year fractions.

  6. Info Functions

    7. Getting some basic information: address of cell, formula of cell, workbook name, worksheet names, workbook path, QuickCache path, user name, computer name, computer IP address, QuickCache version. There are also functions letting users to create a dictionary and retrieve values from the dictionary.

  7. Math Functions

    8. Add, Minus, Divide, and Multiply calculations of two arrays. There is also function generating random numbers, and an interpolation function supporting 20 interpolators.

  8. Matrix Functions

    9. Data manipulation on matrix: count element, replace empty element, replace error element, frequency of element, flatten, reshape, repeat, padding, joining, merge, and split.

  9. Redis Functions

    10. Publishing static and real-time data to and subscribing data from Redis, a super fast in-memory key-value database.

  10. RTD Functions

    11. Some special RTD engine powered functions: an ultimate heartbeat function, a function looping through a matrix, a pair of functions saving a value to and reading the value back from the local RTD server.

  11. Search Functions

    12. Slicing, searching, sorting, splitting, lookup, filtering data table. Please check QuickCache help file and QuickCache example spreadsheets for details.

  12. Set Functions

    13. Functions operating on SET: Union, Intersect, Except, Different, InSet. It also have 2 functions for getting the first or the last element in a SET or a matrix.

  13. Summary Functions

    14. Various summary operations on numbers by one dimension group or by two dimension groups: Average, Count, Minimum, Maximum, and Sum.

  14. Text Functions

    15. Functions operating on texts (strings). One concatenates every element in a matrix. Two functions split string into parts, either by separators or by Regular Expression pattern. Other functions perform operations of clean up, convert, starts, ends, has, left, right, match, and substitute.

  15. Utility Functions

    16. Miscellaneous functions: calculation count and time of a range; get or add cell comment; hide and unhide rows or columns; file information; run specified ranges; plot a chart; read Windows registry; function usage; mark cells volatile; and set Excel threads.