Function reference
Functions shown with the ES. prefix of the
flagship EnergyScope deployment. Every function works identically against
every source type; the analytics marked ◆ compute inside the add-in and work
fully offline.
Data
| Function | What it does |
|---|---|
=ES.Get(series, start, end) | Fetch a series — spills period | value |
=ES.GetMulti(range, start, end) | Fetch many series from a range of IDs |
=ES.Table(ids, start, end, fill, freq) | Pivoted table: continuous dates as rows, one column per series, Bloomberg-style forward fill |
=ES.Col / =ES.ColX(...) | Formatted data columns aligned to a dates column — ColX adds change tracking: new-value borders, revision comments |
=ES.Monthly(monthly, weekly, ...) | Monthly series synthesised from monthly + weekly inputs (day-weighted) |
=ES.Dates(start, end, freq) | Date column generator — D, W, M, ME, Q, A |
=ES.Search(keyword) ◆ | Search the catalog by words — series_id, name, frequency, units |
=ES.Latest(ids) ◆ | Latest value per series with name and units |
Freshness
| Function | What it does |
|---|---|
=ES.NewData(ids, [baseline], [secs]) ◆ | TRUE when the source has newer data than your last refresh (or an explicit baseline) — per column, self-rechecking |
=ES.LastDate(ids) ◆ | Latest data date across series |
=ES.Refresh() | Re-fetch everything; advances freshness baselines |
=ES.RefreshStats() | Last-refresh telemetry: source, timings, rows, new/revised counts |
Analytics — offline suite ◆
Computed inside the add-in from your files.
| Function | What it does |
|---|---|
=ES.Stats(series) | Descriptive statistics: count, mean, median, stdev, skew, kurtosis, percentiles |
=ES.Transform(series, op, window) | diff, pct, log, logdiff, lag, ma, ema, cumsum, zscore |
=ES.Corr(ids) · =ES.RollingCorr(a, b, window) | Correlation matrix · rolling correlation |
=ES.Spread(a, b) | Pair spread: z-score, percentile, half-life, rolling z + series |
=ES.CrackSpread(ratio) | Refining cracks: 3-2-1, gasoline, diesel |
=ES.Volatility(series, window) | Rolling + EWMA volatility, annualised |
=ES.Returns(series) | Log returns, cumulative, drawdown analysis |
=ES.Percentile / =ES.Seasonal / =ES.Changes | Where-are-we-now context: rank vs history, vs same period in prior years, significant movers |
=ES.ACF / =ES.Outliers / =ES.Interpolate | Autocorrelation · outlier detection · gap filling incl. splines |
Analytics — server engine
Model fitting runs on a live server (any tier with connectivity; Enterprise for private deployments).
| Function | What it does |
|---|---|
=ES.Forecast / =ES.ARIMA / =ES.Prophet / =ES.Theta / =ES.Smooth | Forecasting: gradient boosting, auto-ARIMA, Prophet, theta, exponential smoothing |
=ES.VAR / =ES.ElasticNet / =ES.QuantileReg / =ES.LPIRF / =ES.MIDAS | Multivariate & regression toolkits |
=ES.UnitRoot / =ES.Cointegration / =ES.Breakpoints / =ES.BubbleTest | Statistical tests & regime detection |
=ES.Seasonality / =ES.HPFilter / =ES.BandPass | Decomposition & filters |
Plumbing
| Function | What it does |
|---|---|
=ES.Version() | Which build am I running |
=ES.Server(endpoint) | Show or change the data source from a cell |
=ES.Fetch / =ES.FetchSearch | Synchronous variants for VBA automation |