English/中文
Introduction of QPRLib

QPRLib (Quantitative Pricing Risk Library) is a pricing and risk measurement library developed for the Chinese financial derivatives market, which can be used to price and value specific equity and fixed income OTC derivatives, such as structured snowball products, convertible bonds, etc. The project is ongoing and we expect the final QPRLib library to have the following capabilities:

  1. Ability to handle a full range of financial derivative instruments (e.g. fixed income products, over-the-counter equity structured products, etc.);
  2. Different models for the same product class are available to users for model validation and comparison of pricing results (e.g. volatility models for different classes);
  3. Complete full chain analysis framework, including product construction, model calibration, pricing and valuation, risk analysis, etc.;
  4. Portfolio analysis, including NPV, DV01, P\&L, VaR, etc.;
  5. Diverse interfaces and seamless IT integration;
  6. Easy access to real time data and historical data;
Install QPRLib

The underlying structure of QPRLib is written in C++. Currently, we only support loading and using it as a plugin in Microsoft Excel (version later than 2013) and WPS (version later than 2016) on Windows systems. If you need to use external data sources, please ensure that you have purchased a Choice API account and installed the Choice client. Installation steps:

  • 1. Download installation.zip
  • 2. Extract the files, then run InstallationScript_EXCEL_online.bat or InstallationScript_WPS_online.bat as administrator to perform automatic installation
  • 3. If you need to calibrate the volatility model using external volatility surface data, copy the three files from the ChoiceApi folder into the directory C:/QPRLib/ or D:/QPRLib/, and update the account and password in account.txt
  • Note: Run the .bat file as administrator, and make sure Excel or WPS is closed during the installation process.

Document

Installing Package