The following pages and posts are tagged with
| Title | Type | Excerpt |
|---|---|---|
| Introduction | Page | QuantSA Excel functions |
| Introduction to the code | Page | Project overview There are 4 main projects: General Valuations Excel QuantSAInterfaces and 2 test projects General and Valuation Most maths and finance except valuation is implemented in General. The simulators and other valuation tools are implemented in Valuations. The main reason for... |
| Market Data | Page | In the future some publicly available market data will be obtainable directly inside QuantSA. |
| Setup the documentation | Page | The documentation for QuantSA can be found here The source code is in markdown and is based on: https://github.com/tomjohnson1492/documentation-theme-jekyll. The source code can be found here To compile this documentation locally to review your edits, follow any of the many instructions online for building and... |
| The Excel-Addin | Page | Download and install |
| Setup a development environment | Page | Once the addin is installed, you will be able to tell it is present when you can see QuantSA in the Excel ribbon. Start typing =QSA. and the list of available functions will appear. Alternatively browse the online documentation. |
| Creating Objects | Page | Many QuantSA functions create objects. These can then be used in other functions or data can be extracted directly from them. Objects are available to use in Excel via the names that is output into the sheet. The name will look something like: simulationResults.12:29:14-8 Extracting... |
| Getting help on Excel Functions | Page | Function Wizard Function: Inside the function wizard is a description of the function. Arguments: Inside the function wizard you will get help on each input when the focus is on range input for that argument. Details: There is also a link to the online help inside the function... |
| FAQ | Page | FAQ |
| Installation | Page | Installing the Excel add-in or the development environment. |
| Introduction | Page | Getting started |
| Writing Plugins | Page | Introduction QuantSA allows plugins that may be required for several reasons such as: a user may require bespoke functionality that does not fit naturally into QuantSA. a quant may have some proprietary models that they would like to sell to a particualr party and not make available to... |
| Setup a development environment | Page | Github QuantSA is written in C#. It includes visual Studio 2015 solution files so the easiest way to get started is to open the solution in Visual Studio and begin writing. Download the source from https://github.com/JamesLTaylor/QuantSA Open QuantSA.sln Rebuild (Visual studio will sort out the project... |
| Setting up and running test | Page | Writing tests A useful function for transferring your Excel use case into a CSharp test is: =QSA.GetCSArray(data) Which turns a block of numbers into something like: {{3578,0,0,0,0,0,0,0,0<span... |
| Getting started with QuantSA | Page | A free, easy to use quant library for South Africa |
| Sample post | Post | This is some summary frontmatter for my sample post. |