.. index:: single: G7 New; For 2015 *G7*: New for 2015 =============================== Work in 2015 provided new features, improvements to existing features, and a variety of bug fixes. The most important improvements and new capabilities provided in the *G7* software are these: - Improved Documentation: The *G7* documentation was revised heavily in 2012 and has been updated again in 2015, with new Help files, Users' Guide, Reference Manual, Tutorial, and `other documentation `_. `Companion documents `_ in HTML and PDF formats also were updated. In particular, recent software improvements and extensions have been documented, and cross reference hyperlinks have been added to the Reference Manual. - Excel Interface Improvements: a) Introduced ability to read a range of dates with the :ref:`xl read command `, and then to recover the dates and components with keywords and to read a corresponding range of data with possibly non-contiguous dates. The set of dates are stored in Excel date format, where a single date may be recovered with the %xldate :ref:`keyword`. The same may be recovered in *G7* date format with %xlgdate, or the date components may be recovered as %xlyear, %xlquarter, %xlmonth, and %xlday. b) Introduced corresponding :ref:`xl setfrequency command ` to clarify the intended frequency of the dates read with the :ref:`xl read command `. c) Made :ref:`xl write command ` print floating point values or integers to the spreadsheet when numbers are specified as text. Previously, numbers were written as strings, though strings still can be forced with "'". - Graphical Interface Improvements: a) Added :ref:`Run-To-Here F11 shortcut ` in *G7* editor. b) :ref:`Added keywords ` to recover main window and editor window color and font settings. c) Added commands to specify :ref:`main window ` and :ref:`editor window ` color and font settings. d) Added Close (Esc) to gridtype menu. e) Began revisions of BankOpen GUI. - Miscellaneous Improvements: a) Added :ref:`setveclag command ` to get|set number of lags for a vector in the default vam file. b) Added 'c|r' option to the :ref:`coef command ` to divide columns (default) | rows by corresponding elements the given vector. c) Began work to allow regressions equations to be saved in *G7* equation format with the "gf" option with the :ref:`save command `. Change regression coefficient printing to save files to avoid "+-" sequences with negative parameter values. d) Added an optional numerical argument for the :ref:`pause command ` to wait for the specified number of seconds before continuing. e) Add check to the :ref:`mcopy command ` to ensure that source bank frequency matches destination bank frequency and that both match *fdates* frequency or specified date range frequency. f) When *addprint* is off, do not print "add " statements to screen. - An Abridged Listing of Bug Fixes: a) Added sanity checks to reading of g.ini file and improved default values. b) Improved reading of g.cfg, and eliminated infinite loop when valid g.cfg file is not found. c) Fixed memory problems related to series titles in *graph* routine. d) Fixed buffer overflow problem with *gtf*-*gti* and long titles that appeared when printing data to file. e) Fixed bad printing of graph series names. f) Fixed error message in showcmd. g) Consecutive views of packed matrices in the *show* window could fail to display changes made to the data by *pmatin*; forced storage of loaded vector at top of *pmatin*, as this will force all subsequent commands to reload data and thus should fix the problem. h) Fixed bugs in the *show* and *ras* commands. i) Fixed up *rs ctrlmatrows* command. j) Fixed problems affecting *xl freeze* and similar commands, where changes were not made to the intended worksheet. k) Fixed problems in *xl vecwrite*. l) Revised *coef* command code to avoid numerical problems. Improvements also were made to the companion software *Compare*. - *Compare*: a) Added intelligent search for .pmx file locations for packed matrices. Improved error handling for matrix listing. b) Improved control of printing zeros with the :ref:`\\nzr command ` when multiple banks are loaded, and fix problems with *\nzr* when printing to .xls files. c) Improved :ref:`.in config file ` reading to allow "..\\filename" specification, etc. d) Added checks, error messages, and error handling to :ref:`sort routines `, particularly to the maximum number of sectors to be sorted. .. EXCEL INTERFACE IMPROVEMENTS: -Introduce ability to read a range of dates in xl, and then recover date and components with keywords and to read a corresponding range of data with possibly non-contiguous dates. xl read date [ ] # If range is given, then either col1=col2 or row1=row2 xl setfrequency # Specify from valid G7 date frequencies: 1, 2, 4, 12 (note ambiguity with Excel dates, e.g. for quarterly frequency) xl read "xldates" # Read data, storing to given date set. -The set of dates are stored in Excel date format, where a single date may be recovered with the %xldate keyword. The same may be recovered in G7 date format with %xlgdate, or the date components may be recovered as %xlyear, %xlquarter, %xlmonth, and %xlday. -Make 'xl write "<>"' print floating point values or integers to the spreadsheet when numbers are provided; previously, numbers were written as strings, though strings still can be forced with "'". MISC CHANGES -Add check to mcopy to ensure that source bank frequency matches destination bank frequency and that both match fdates frequency or specified date range frequency. -When addprint is off, do not print "add " statments to screen. MISC IMPROVEMENTS -Added setveclag [<# lags>] to get|set number of lags for a vector in the default vam file. -Began work to allow regressions equations to be saved in G7 equation format with the "gf" option with the save command. Change regression coefficient printing to save files to avoid "+ -" sequences with negative parameter values. -Added 'c|r' option to coef to divide columns (default) | rows by the given vector. G7.389 GUI -Began revisions of BankOpen GUI. -Added Close (Esc) to gridtype menu. BUGS -Added sanity checks to reading of ini file and improved default values. -Improved reading of g.cfg, and tried to eliminate infinite loop when valid g.cfg file was not found. -Attempt to fix memory problems related to series titles in graph routine. -Attempt to fix buffer overflow problem with gtf/gti and long titles that appeared when printing data to file. -Attempt to fix bad printing of graph series names. -Fixed error message in showcmd. -Consecutive views of packed matrices in showcmd can fail to display changes made to the data by pmatin; force store of loaded vector at top of pmatin, as this will force all subsequent commands to reload data and thus should fix the problem. -Attempt to fix bugs in the show and ras commands. -Fix up rs ctrlmatrows command. -Fixed problems affecting xl freeze and similar commands, where changes were not made to the intended worksheet. -Fixed problems in xl vecwrite. -Revised coef command code to avoid numerical problems. COMPARE -Add intelligent search for pmx file location, copied from G7. Added return codes for matrix listing. -Improve control of printing zeros with the \nzr command when multiple banks are loaded, and fix problems with \nzr when printing to xls files. -Improve .in config file reading to allow "..\filename" specification, etc. Add checks, error messages, and error handling to sort routines.