AirXCell - Release Notes

AirXCell version 0.5.10 (r1130)

  • Reworked the presentation of the demo site
  • Lots of critical bug fixes

AirXCell version 0.5.9 (r1118)

  • It is now possible to select DataFrame cells/ranges within charts
  • CalculationSheet module:
    • Lazy data fetching: the underlying data matrix on the server is split by pages and and these pages are loaded asynchronously upon workspace load.
  • Several general performance improvements. For instance, displaying a Dynamic form is not much quicker
  • Several bug fixes
  • Integrated latest version of CodeMirror

AirXCell version 0.5.8 (r1069)

  • Dynamic Form : Historical Volatility
    • Bug fix on TTR volatility calculation
  • Several bug fixes

AirXCell version 0.5.7 (r1065)

  • Dynamic Form : Manage Portfolios
    • Current and historical data frame can be shown
    • Can now work with FOREX positions
  • Several bug fixes on finance dynamic forms
  • Tons of other bug fixes

AirXCell version 0.5.6 (r1036)

  • R backend updated from 2.15.1 to 3.0.0 : this breaks compatibility of previously saved workspaces !
  • Dynamic Form : Analyze Assets : New form for asset analysis
    • Simple linear regression analysis versus time
  • CalculationSheet module:
    • Better management of string values on the R side
  • Several bug fixes on finance dynamic forms
  • Tons of other bug fixes

AirXCell version 0.5.5 (r1009)

  • CalculationSheet module:
    • Strings and other non-numeric data format are now stored at the R side
  • Additional safety-nets on the R backends
  • Got rid of the term 'plugin' to designate modules
  • Lots of fixes on the R console
  • Several bug fixes on finance dynamic forms
  • Tons of other bug fixes

AirXCell version 0.5.4 (r994)

  • Chart Module:
    • Several fixes
  • CalculationSheet module:
    • Support of row-level and column-level styles implemented a bit forward
  • DataFrame module:
    • Support of row-level and column-level styles implemented a bit forward
  • Lots of fixes on the R console + ESCAPE now cancels the pending command parts.
  • Several bug fixes on finance dynamic forms
  • A new How-To on using the R console
  • Other bug fixes

AirXCell version 0.5.3 (r974)

  • Dynamic Form : Manage FOREX
    • Now FOREX loading on multiple years works
  • Dynamic Form : Portfolio Optimization
    • Optimization from constituents can now contain FOREX quotes
  • Finished R console implementation. Most use cases now work flawlessly including multi-line inputs and help display.
  • Fixed documentation presentation on Internet Explorer
  • Several bug fixes on finance dynamic forms
  • First How-To written
  • Other bug fixes

AirXCell version 0.5.2 (r955)

  • Dynamic Form : Analyze Assets : New form for asset analysis
    • Correlation chart
    • Summary and sharp ratio chart
  • Several bug fixes on finance dynamic forms
  • Other bug fixes

AirXCell version 0.5.1 (r938)

  • CalculationSheet module:
    • New supported data format: Date and Time format
  • DataFrame module:
    • New supported data format: Date and Time format
  • Several bug fixes on finance dynamic forms
  • Tons of other bug fixes

AirXCell version 0.5.0 (r915)

  • New companion Web site design
  • Completely rewritten financial forms. Now Assets, FOREX, positions, portfolios, etc. are correctly modelized within the R calculation environment throughout forms.
  • Integrated Findata, a small financial database providing informations on stocks, funds, etc.
  • Completely rewritten the R Log Console, now much more usable.
  • New color chooser used everywhere
  • Dynamic Form : Manage Portfolios : New form for portfolio definition and analysis
    • A portfolio is defined by its set of constituents
    • In addition, the form enables to compute the portfolio value given a set of weights or number of shares and the valuation date
    • Such a defined portfolio is available in the portfolio optimization form
    • The User can compute exposure, risk, performance, etc. broken down to a set of variables.
  • Various performance improvements
  • More automated test scripts
  • Tons of bug fixes

AirXCell version 0.4.7 (r848)

  • Implemented password recovery
  • Implemented newsletter registration and contact form
  • Forms are now much simplier to write for end users
  • R Code Editor module:
    • Various performance (responsivness) improvements
    • Lots of bug fixes
  • CalculationSheet module:
    • Implemented a new, easier and more user friendly color chooser
    • Completely rewritten the selection management logic
  • DataFrame module:
    • Using a drop-down box to choose amongst existing data frames
    • Implemented a new, easier and more user friendly color chooser
    • Completely rewritten the selection management logic
  • Dynamic Form : Manage assets
    • Now able to use adjusted price in charts
    • Possibility to reload all assets as of current date
    • Now a clear (sig!) reporting in case the asset quotes cannot be loaded
    • Lots of bug fixes
  • Dynamic Form : Manage FOREX
    • Possibility to reload all FOREX as of current date
    • Now a clear (sig!) reporting in case the FOREX quotes cannot be loaded
    • Lots of bug fixes
  • Dynamic Form : Portfolio Optimization
    • Several improvements
    • Lots of bug fixes
  • Dynamic Form : Option pricing
    • New models of pricing implemented
    • Now a clear (sig!) reporting in case the option value cannot be computed
  • New administration tools to monitor server status
  • Various improvements on the companion web site
  • Various performance improvements
  • More automated test scripts
  • Tons of bug fixes

AirXCell version 0.4.6

  • Urgent bug fix: it was not possible to create an account anymore.

AirXCell version 0.4.5

  • New version of the main AirXCell page
  • Monitoring: a new tool for administrator which enables admins to monitor resources consumption on the server and consult logs
  • The UI application is migrated to dojo 1.7.2
  • Added the list of supported R package within AirXCell to the user documentation
  • CalculationSheet module:
    • Added a widget that enables the user to search for specific R functions
    • More keyboard shortcuts supported, for instance to extend selection from the current cell
  • DataFrame module:
    • Now supporting to actually change the values within a data frame
    • Several other improvements
    • Supporting FOREX timeseries
  • Dynamic Form : Manage assets
    • Now able to merge an additionally loaded period to previously loaded periods
  • Dynamic Form : Manage FOREX
    • Several improvements
    • Now able to merge an additionally loaded period to previously loaded periods
  • Dynamic Form : Portfolio Optimization
    • Taking weight constraints into consideration
    • Now the portfolio can be computed in any arbitrary currency
  • Dynamic Form : Historical Volatility
    • Initial version of the historical volatility calculation form
  • Dynamic Form : Option pricing
    • Initial version of the option pricing form
    • Most models available in the R packages (mostly rMetrics) are implemented (a few remains)
  • Various improvements in the way the dynamic form results are captured
  • Various improvements on the Graphic Module
  • Various security improvements and health checking when a user connects to the application
  • Several new chapters (new forms) and new sections in the user documentation
  • Integrated latest version of CodeMirror
  • Security improvement: R commands submitted by the user are check for safety before being sent to the R backend
  • Various performance improvements
  • More automated test scripts
  • Tons of bug fixes

AirXCell version 0.4

  • Optimized the GraphicTracker. Images are now generated accordingly to the target resolution of the display panel on the UI
  • Improvements on "Dynamic Forms support"
  • CalculationSheet module:
    • Initial support for the cell extension square (just displayed, not working yet)
    • Full grid Style (i.e. a single style applied to the whole grid is working)
    • Preparatory work for Column and Row styles
    • Initial support for Data Format is implemented
  • DataFrame module:
    • The Data Frame module is an editor and visualizer for R DataFrames
    • It shares 70% of its code base with the Calculation Sheet module
    • At the moment, the editing features are not working. The module is only a data frame viewer
    • At the moment supporting standard data frames + xts, zoo and timeSeries types timeseries
    • Full grid Style (i.e. a single style applied to the whole grid is working)
    • Preparatory work for Column and Row styles
    • Initial support for Data Format is implemented
  • Dynamic Form : Manage assets
    • Initial implementation
    • Searching assets on Yahoo and loading from Yahoo, Google, Oanda, etc.
    • The user can also show already loaded assets
    • Currency is searched on Yahoo and bound to the asset timeseries in a new attribute.
  • Dynamic Form : Manage FOREX
    • Initial implementation
    • Loading FOREX rates from Oanda
    • The user can also show already loaded FOREX
  • Dynamic Form : Portfolio Optimization
    • Initial implementation
    • Loading FOREX rates from Oanda
    • The user can also show already loaded FOREX
    • Supporting more than 1 page of constituents
    • Supporting a date range to work with a subset of the data
  • Several functions implemented in R aimed at working with timeseries, manipulate them, merge them, etc.
  • Several functions implemented in R aimed at manipulated timeseries against FOREX.
  • Added chapters for dyn forms in user documentation
  • Various improvements on the R Log Console
  • Various performance improvements
  • More automated test scripts
  • Lots of bug fixes

AirXCell version 0.3.5

  • Security improvement: the R Server for each session is chrooted
  • Most HTML templates migrated to an HTML 5 compliant syntax
  • Modules can be moved in the workspace tabbar using the context menu on the title
  • CalculationSheet module:
    • Initial support for value alignment within the cell
    • Initial support for merged cells
  • Chart Module:
    • Various improvements of all kind (setting chart parameters, additional curves, etc.)
  • Initial support for "Dynamic Forms".
    • Dynamic forms are small applications maintainted and editor through the AirXCell GUI which is used as a development environment
  • Several refactorings of the javascript utility functions to make them Dojo Compliant
  • Various performance improvements
  • More automated test scripts
  • Lots of bug fixes

AirXCell version 0.3

  • Initial support for file import/export. Currently only text files (R Code Editor) and CSVs (Calculation Sheet)
  • Initial support for Copy/Paste in the console
  • R Code Editor module:
    • Completely rewritten the R Code Editor on top of CodeMirror instead of dijit.Editor
    • Copy Paste support in Editor
    • Find and replace components in toolbar
  • Chart Module:
    • A Very primitive version of the Chart module is implemented
  • CalculationSheet module:
    • Find and replace components in toolbar
    • Basic support for styling at selection level
    • Implemented a "cell range picker"" widget the chart module can use to select ranges of cells in a Sheet
    • Added limitation to the maximum size of a shet
    • Several imporvements on the Calculation Sheet Toolbar
  • Added a context menu on Graphics
  • List of countries is now filled with every possible country in user creation form.
  • Some additional topics covered in user documentation.
  • Improvements on the File Import/Export Dialog
  • More automated test scripts
  • Now a "ping" service keeps the server session opened as long as the UI application is displayed in the browser
  • Updated the set of open-source libraries used by the project (PostgreSQL driver, R server, log4j, etc.)
  • Various Improvements in the Security Framework
  • Various performance improvements
  • Various production-level improvements
  • More automated test scripts
  • Lots of bug fixes

AirXCell version 0.2.5

  • The whole UI application is updated to dojo 1.6
  • The R Log Console can now pop up automatically upon new messages or errors
  • Initial support for Copy Paste
  • CalculationSheet module:
    • Refactoring of the recalculation algorithm (dependency recalculation)
    • Navigation works by entering a cell ID in the field on the leftmost side of the the Formula Bar
    • Rows and columns can be inserted and formulas are correctly shifted
    • More keyboard shortcuts are supported
    • Initial support for the dollar symbol in cell (range) reference to avoid reference shifting in formulas
    • Compaction: cells without any value nor any style are discarded and their resources released (client and server sides)
    • Automatic scrolling on the grid whenever the user reaches a border when making a selection
    • Initial Support for Copy Paste on the Grid
  • Improvement on the client - server communication stack: messages property names are shortened to a few letters only
  • All dialogs are now draggable
  • A workspace can be saved locally in the user machine and loaded (uploaded) from there.
  • Added a 'create account' and a 'contact' links on the login page
  • Implemented a dialog for chaning the user password
  • Implemented a security framework. Every message received server side is now checked against user rights
  • Several refactorings on the core framework
  • Several refactorings on the JRI
  • More automated test scripts
  • Various performance improvements
  • Various production-level improvements
  • Lots of bug fixes

AirXCell version 0.2

  • A new user login form
  • When launching the application for the first time, the user now reaches the "Start Box"
  • Modules can now be renamed
  • Handling of window resized is improved
  • The R Log Console can be opened by clicking on its title
  • Initial support for workspace loading / saving
    • Only server side at the moment
    • Workspace state (also R) as well as modules are correctly stored
    • Initial version of the WorkspaceList components which shows workspaces stored on the AirXCell server
  • Initial user documentation
    • General presentation of the UI
    • Presenting principles and features
    • Presentation of the CalculationSheet module
    • Presentation of the R Code Editor module
  • CalculationSheet module:
    • Columns and rows can be resized
    • Initial support for navigation with PG_UP, PG_DOWN, etc. in the Grid component
    • Basic support for contextual menu on the Grid component
    • Completely rewritten the way the sheet formulas are evaluated within the R environment
      • Better way to regroup recomputation following the dependency tree as batches submited at once to the R environment.
    • Whole rows ranges or columns ranges can be used in formulas
    • Initial support for styling (only cell and selection levels)
    • Initial version of the Format Choose Dialog (styling)
    • Initial support for refreshing the sheet from the R environment
    • Better error reporting upon formula error
  • R Code Editor module:
    • Better fonts, prettier under Windows
  • Graphic module:
    • Graphic can be resized
  • Interactions with the server are shown with a progress bar in the Status Bar
  • Closing a workspace now correctly discards every resources on the server side
  • Better reporting of errors in the console whenever an R command fails
  • Improvements on the client-server communication stack (batching requests)
  • Several refactorings on the core framework
  • Several refactorings on the JRI
  • More automated test scripts
  • Various performance improvements
  • Various production-level improvements
  • Lots of bug fixes

AirXCell version 0.1

  • Initial layout of the project structure with the Java Backend and the Dojo (JS) frontend
  • Initial version of the Maven build system
  • Initial version of the JRI - the Java to R Interface
  • Initial version of the Client-Server communication stack
  • Initial version of the GUI canvas and the module infrastructure
    • The title bar
    • The Menu
    • The place reserved for the workspace
    • The Console
    • The Status Bar (static at the moment)
  • Initial version of the workspace UI component (the collection of modules)
    • Uses a tabbar to present modules as various tabs
  • Initial version of the workspace backend component (the collection of modules)
    • Holds the state of the modules and the R environment
  • Initial version of the Grid UI component used by the CalculationSheet
  • Initial version of the CalculationSheet module
    • Initial version of the formula bar used to input values in cells
    • Initial support for values and formulas
    • Basic formulas results are correctly integrated in the sheet
    • Dependency resolution system for formulas
    • Basic support for selections
  • First administration components
  • User registration form and captcha verification
  • Initial support of the GraphicTracker
    • R charts are correctly captured and returned to the UI in the form of images
    • Initial version of the Graphic module to store and view graphics
  • Initial version of the R console. No input is possible so far, it serves solely to consult the R logs and errors.
  • Initial version of the R CodeEditor module
    • The editor works and command results are shown on the console
  • Lots of automated test scripts

Release notes