Skip to content

databank.toTable (+databank)

Retrieve time series from databank and arrange them in a table

Syntax

outputTable = databank.toTable(inputDb, ~names, ~dates, ...)

Input arguments

inputDb [ struct | Dictionary ]

Input databank from which the time series (specified by their names) will be extracted.

~names=@all [ string | @all ]

Names of time series that will be extracted from the inputDb; @all means all time series found in the inputDb.

~dates="unbalanced" [ Dater | "unbalanced" | "balanced" ]

Dates for which the time series observations will be retrieved, with the following four text specifications:

  • "unbalanced" means a range from the earliest start date to the latest end date found amongst all the named time series;

  • "balanced" means a range from the latest start date to the earliest end date found;

Output arguments

outputTable [ table ]

Output table with the observations from the names time series at the specified dates organized in columns.

Options

zzz=default [ zzz | ___ ]

Description

Description

Examples

d = struct( );
d.x = Series(qq(2020,1):qq(2025,4), @rand);
d.y = Series(qq(2021,1):qq(2025,1), @rand);
d.z = Series(qq(2020,3):qq(2026,1), @rand);