What’s new?

  • The latest official release is Gekko 2.2 (see below). A stable version 2.4 will be released in the summer of 2018, containing among other things array-timeseries, GAMS interaction, more stable Excel interaction, and quite a few other enhancements.
  • In the fall of 2018, Gekko 3.0 will be released. This marks a major upgrade, with syntax clarification, more flexible data objects (and storing of these in databanks), and generally a lot of new features.
  • Gekko 2.2 was released in February 2017. Among other things, this version contains a lot of PLOT improvements (see new features or the new PLOT gallery.). You can download Gekko 2.2 here.
  • You can track what is going on between releases by following the development page (and/or the changelog), or in even more detail at github, where every change in the source code is recorded.


New in Gekko 2.2

(This section is copied from the user manual)

Gekko 2.2 most notably adds a lot of new graphing capabilities (PLOT) to Gekko.

  • PLOT command completely overhauled, see demo graphs here. Graphs can be controlled in a lot of new ways, either as options in the PLOT command, or in a schema file (.gpt), or both. Histograms/bars/boxes are supported, too. There is a special handy option to separate boxes and lines vertically: PLOT<separate>, and many other possibilities.
  • OPEN<edit> should be used instead of OPEN<prim>, and LOCK/UNLOCK commands can lock/unlock already opened databanks. Opened databanks (OPEN without options) are now opened last in the list of databanks. Opened databanks are now protected (non-editable) per default.
  • OLS command improved, including linear restrictions on parameters.
  • INTERPOLATE and REBASE commands implemented.
  • XEDIT command to open up a dedicated and in-built xml editor (for graph and table schemas).
  • MATRIX command allows all kinds of indexers on left-hand side.
  • SHEET<import matrix> imports a matrix from an Excel sheet.
  • IMPORT accepts dates.
  • PIPE improvements.
  • Random number functions, see rseed(), runif() and rnorm(). Functions pchy(), dify() and dlogy() to handle yearly differences. Functions movavg(), movsum() for moving averages/sums. Function chol() for Cholesky decomposition of matrices. See here.
  • Some new table options: ‘mdateformat’, ‘decimalseparator’, ‘thousandsseparator’ and ‘stamp’. See under OPTION, in the OPTION table … section. With these options, a number like 12345.67 can be printed as 12,345.67 or 12.345,67, and monthly dates can be formatted as for instance ‘Jan. 2020’ instead of ‘2020m1’. Menu files accept links to .gcm files.
  • The .gbk databank file format now uses a datafile called ‘’ internally (instead of ‘databank.bin’). The old name caused problems when sending databank files over email. To produce a databank file suitable for Gekko 2.0 or 1.8, see the note in the WRITE help file.
  • Options: see the end of the OPTION command regarding new options in Gekko 2.2.