EXTRACTION OF FORECAST DATA FOR USE IN EXCEL
by Brian Revell
Hi
when estimating either with OLS, or Univariate ARmax model specifications
(Gretl 2026b)there is a problem extracting the Further Analysis Forecast
data for download into Excel for improved graphi presentation. Copying the
forecast output produces output which appears as below. Whilst visually
pleasing, unfortunately the columns are not separable for the forecasts
2025-30. No matter how one tries to parse the 2025-2030 block of data, it
remains unseparable via the Excel command process of DATA Text to columns.
That command sequence however works for the actual data and prediction
columns pre forecast ie to 2024, but not thereafter. If one cuts and then
pastes the 2025-2030 block of forecasts and repastes them elsewhere in the
spreadsheet it appears that nothing has actually copied. It would really
help if the output were arranged in a file column format. Quite cleary
the PI range occupies one column.Better to use 2 columns for Lower and
Upper PI range values.
[image: image.png]
Any thoughts on workarounds for the meantime, to avoid having to reinput
the forecasts manually into the Excel spreadsheet.
Brian
*Brian Revell*
2 weeks, 1 day
Recession bands and the time series G.U.I.
by climnios＠providence.edu
Hello - just downloaded the latest iteration in case that may have solved my issues, but alas, it's still there.
I do very much enjoy placing the NBER recession bands in my plots, but I noticed as of late that this "push button" option is no longer available in the plot G.U.I.
I suppose I can do this by hand through the command line, but before going down that route I wanted to check in with the group to see if this functionality has been deprecated.
Thanks either way,
//Chris
3 weeks, 2 days
Package updates (April 2026)
by Riccardo (Jack) Lucchetti
Dear all,
this message is to inform the community about the activity in our
function package repository: during the month of April 2026, 2 packages
were updated to a new version:
"color_xy", by myself (color xy plot for time series )
"Winters", by Ignacio Diaz-Emparanza and Allin Cottrell (Winters
forecasting method)
The most important update is, by far, the one to the "Winters" package:
it was prompted by a message that ramakrishnasalagrama(a)gmail.com posted
to the list two months ago on his difficulties to replicate some results
from Rob Hyndman. So Allin wrote some cool improvements to old code by
Ignacio, and here we are, with a brand new version. (And yes, Hyndman's
example can be replicated now.)
As usual, update and enjoy!
--
-------------------------------------------------------
Riccardo (Jack) Lucchetti
Dipartimento di Scienze Economiche e Sociali (DiSES)
Università Politecnica delle Marche
(formerly known as Università di Ancona)
r.lucchetti(a)univpm.it
http://www2.econ.univpm.it/servizi/hpp/lucchetti
-------------------------------------------------------
1 month
gretl 2026b released
by Allin Cottrell
See https://gretl.sourceforge.net/
Here are the changes:
2026-04-30 version 2026b
- new function which() to determine which elements of a
given matrix satisfy a specified condition
- new function fols() for factorized least squares
- new function tsolvepd() for solving Toeplitz linear
systems when the Toeplitz matrix is known to be symmetric
and positive definite
- probability distribution functions: add support for the
truncated normal distribution
- "join" command: fix possible crash on joining data from
two binary gdtb data files in succession
- correlation matrix plot: use graph-names as set by the
"setinfo" command if available
- "add" and "omit" commands with --auto option: attach to
the augmented or reduced $model bundle a list giving the
order in which regressors were added ("add_order") or
omitted ("omit_order")
- "var" command with --lagselect option: show the LR test
P-value for the null of lag order 0
- "vecm" command: in the vecm_info bundle in the $system
accessor we now provide new matrices: "long_run"
(Johansen's C), "cov_long_run" (the covariance of vec(C))
and "se_long_run" (standard errors of the elements of C),
along with additional documentation in the User's Guide
- "foreign" command block: support the --send-data option
when executing a Python script, via Pandas
- "panplot" command: correct suport for the --font option
- matrix "slicing": correct handling of an empty selection
vector, and sypport use of row and column names when
indexing into matrices
- script editor: handle "doc strings" in hansl functions
via "question mark-click"
- geoplot addon: document the cbrange option
- User's Guide: improve documentation of string literals
- GUI: /View/Correlations now shows nonparametric option
- GUI: Augment tooltips for model selection dialog buttons
- GUI: "View code" for function packages: preserve inline
comments
- GUI: fix broken display of complex matrices
- GUI: enhance searching of gretl-curated data files
- GUI: fix handling of scalar arguments in the dialog box
for calling function packages
- GUI: "ui-maker" for functions packages: support setting
a run-time default for a boolean argument
- GUI: fix breakage in Command Log on Windows and macOS
- GUI: fix breakage in string argument selector for
function packages on 32-bit Windows (GTK2)
- launching of gnuplot via gretl: respect the GNUTERM
environment variable on Linux, if present
- Windows ARM64 build: include MPI and make available an
ARM64 build of X-13ARIMA-SEATS (x13as)
- Mac builds: update GTK3 to version 3.24.52
--
Allin Cottrell
Professor Emeritus
Wake Forest University
1 month, 1 week
