MacroLens quick-reference card
On this page
Address: https://macrolens.sixtyfour.ee · Support: henrik.aavik@sixtyfour.ee · support form · Guide: https://macrolens.sixtyfour.ee/help
Search
| Query | Meaning |
|---|---|
unemployment rate |
all words (also matched by their beginning) |
"harmonised index" |
exact phrase |
gdp OR bvp |
any of the words |
unemployment -youth |
without the word |
Filters: region (country, aggregate or country group), source, frequency, category — can be combined.
Periods and frequencies
2024 year (A) · 2024-S2 half-year (S) · 2024-Q3 quarter (Q) · 2024-07 month (M) · 2024-W27 week (W) · 2024-07-15 day (D)
Common operations
| Goal | Formula |
|---|---|
| Year-on-year change, % | yoy(s) |
| Quarter-on-quarter / month-on-month change, % | qoq(s) / mom(s) |
| Change relative to a reference point | changeref(s, "2019-Q4", "pct") |
| Log change | logdiff(s, 1) |
| Frequency to quarterly (average / sum) | convert(s, "Q", "average") / convert(s, "Q", "sum") |
| Index, 2015 = 100 | rebase(s, "2015") |
| Lag / lead | lag(s, 1) / lead(s, 1) |
| 12-month rolling sum | rolling(s, 12, "sum") |
| Year-to-date sum | ytd(s, "sum") |
| Weighted average | wavg(s1, s2, weights=[0.6, 0.4]) |
| Trend (HP) / cycle, % | trend(s, "hp") / cycle(s, "hp", output="pct") |
| Seasonal adjustment | sa(s, "x13") |
| HP filter / moving average | hp(s, 1600, "trend") / smooth(s, "ma", 3) |
| Another database / user series | S("key") / U("code") |
Operators: + - * / **; the decimal separator in formulas is a point. All functions: function reference.
Statistical analysis (Statistics tab)
Correlation · cross-correlation · descriptive statistics and standard deviation · simple and multiple regression · VAR · PCA · unit root tests (ADF, KPSS, PP) · period comparison.
Saving, export and printing
| What | Formats |
|---|---|
| Data, tables | XLSX, CSV, copy to clipboard |
| Charts | PNG, SVG |
| Reports | DOCX, XLSX, PDF |
| Presentations | PPTX, XLSX, PDF, present mode |
| Any page | print — Ctrl+P |
Work is stored on the server — reachable from any computer. Shared items are visible to colleagues.
Excel
Add-in: Home → MacroLens → Sign in with my MacroLens account (e-mail, password and two-factor code) → search → insert → refresh. Power Query (personal access token — My account): Data → Get Data → From Web, Basic credentials (e-mail + token), refresh with Ctrl+Alt+F5.
Service levels
Available around the clock (planned maintenance announced in advance) · updated source data within 24 hours · disruptions that prevent you from using MacroLens fixed within 1 working day.