AirXCell features

AirXCell is a Web application, i.e it runs in a browser, enabling the customer to install it once and for all on a production server while every user accesses simply by opening a web browser and reaching the AirXCell site.

AirXCell supports several core applications within a single package, all applications being tightly coupled and deeply integrated with each other:

  • A spreadsheet application: just as Excel in a browser, only better.
    The User Interface emulates Microsoft Excel while the calculator, on the other hand, goes much further. Instead of the poor and unexpressive Excel formula language built of keywords and parenthesis, AirXCell supports R as the formula language. While the syntax is close to Excel, the possibilities are unlimited, thanks to a true functional language and the thousands of available functions.
  • An R Code Editor: unleashes the power of the R calculation platform.
    While the Graphical User Interface of AirXCell is sufficient for most of the financial analysis or quantitative research tasks, it may still be convenient sometime to access the core of the calculation engine. The R Code Editor is implemented for this. It enables the user to tweak AirXCell’s calculation, define new functions or rewrite existing ones, etc.
  • A Chart Wizard: A simple yet powerful charting tool.
    The wizard is used by the user to chart data displayed on the spreadsheet, a data frame, or any other graphical widget within AirXCell. The user simply needs to select the target data and define the parameters of the chart with the wizard.
  • A Data Frame Editor: data visualization and editing easier than ever. In finance, most quantitative or financial analysis requires manipulating a lot of data such as, typically, financial timeseries. The Data Frame Editor provides an Excel like User Interface to visualize and edit data frames such as timeseries or any other structured data.

These core applications coupled to the powerful R calculation engine form the buidling blocks on top of which AirXCell’s financial computation applications are built. As of version 1.0, AirXCell supports the following set of financial applications presented to the user as forms within AirXCell:

  • Asset Quote Management: visualize, edit, chart and analyze asset quotes.
    A financial analyst uses this form to load a set of asset quotes within his workspace (his session in the AirXCell software). He’s provided with a set of tools to visualize, edit or chart the quotes timeseries and a lot of analysis tools. This form is also used to load the portfolio constituents within the workspace which is a prerequisite to building the portfolio.
  • Forex Quote Management: visualize, edit, chart and analyze Forex quotes.
    This form enables financial analysts to load a set of Forex quotes within their workspace. In addition, a set of tools are implemented to visualize, edit or chart the quotes timeseries. One should not that loading a Forex through this form is not a pre-requisites to work with different currencies since Forex Loading is completely automated in AirXcell and performed on the fly when required.
  • Stock volatility Calculation: Compute and chart stock volatility using standard methods.
    Stock volatility is a key financial indicator. For instance, the computation of the theoretical price of a financial Option requires its volatility. This form enables users to compute the theoretical volatility of financial instruments.
  • Option Pricing: Compute theoretical Option price for most common option models.
    This form is used by quantitative researchers to compute the theoretical price of financial Options form most option models such as european, american, asian, barrier, lookback, etc. option models.
  • Portfolio Analysis: compute, analyse and chart key indicators on portfolios.
    This form makes portfolio analysis easier than it ever was. One can either create a new portfolio, open an existing portfolio or import one from an external portfolio management system for analysis. AirXCell loads the quotes of every instrument in the portfolio and provides the user with means to compute, chart or analyse the following key indicators:
    • performance: what is the value of the portfolio, what is its daily, monthly, yearly, etc. performance (i.e. gain or loss) ?
    • exposure: how is the portoflio exposed to a specific aspect such as currency, country. industry sector ?
    • risk: what is the risk value of the portfolio ?
    Each of this indicator can be computed globally or broken down by one or more variables (such as industry sector, sub-industry, country, etc.).
  • Portfolio Simulation: define a management strategy and backtest a portfolio.
    The quantitative researcher can start with an existing portfolio or an empty one, define the constituents of the universe and a portfolio management strategy. Then, he can backtest the simulated portfolio over the past time and see how it behaves. At every moment of the backtesting, he can extract the key financial indicators presented above (Portfolio Analysis Form).
  • Portfolio Optimization: use mathematical optimization methods on the set of a portfolio constituents.
    This form enables the researcher to create a new portfolio, open an existing one or import one from an external portfolio management system and performs a mathematical optimization on it. Optimizing a portfolio in a mathematical way means computing the optimized constituent weights in order to minimize the risk, maximize the returns or maximize the returns over risk ratio. Several models of portfolios are supported such as Markovitz’s Mean Variance Portfolios or Mean Conditional Value at Risk Portfolios.