display(arg, n)

Specify the data to display in each table row. arg can be “first”, “last” or “year”.

“first” or “last” will display annual totals, plus the first, or last, n observations in each row.

“year” will display observations for n years of data per row.

firstfreq(freq)

Sets the frequency for the first column grouping: freq can be “n”(native), “a”(annual), “q”(quarterly), “m”(monthly).

secfreq(freq)

Sets the frequency for the second column grouping: freq can be “none” (none), “n”(native), “a”(annual), “q”(quarterly), “m”(monthly).

nalabel(“arg”)

Sets the label for NA values to arg.

+/-displayname

Use display names as default labels.

transform(row, trans)

Set the transformation method for row row. trans can be: “l”(level), “d”(1 period diff), “yd”(year difference), “pc”(1 period % change), “pca”(1 period % chg-AR), “pcy”(year % chg).

freqconv(row, conv)

Set the frequency conversion method for the specified row. conv can be “avgtran” (avg then transform), “tranavg” (transform then avg), “sumtran” (sum then transform), “first” (first period), “last”(last period).

format(fmt= new_format, units=new_units, prefix=” “, suffix=” “, +/-thousand, +/-comma, +/-parens)

Assign a custom prefix/suffix to the number, add a separator (comma or point) to denote thousands, replace a comma with a decimal point, or bracket negative numbers with parenthesis:

fmt can be: “f[.prec]”(fixed decimal), “c[.prec]”(fixed characters), “auto”, “serformat”(series format).

units can be: “N”(native), “P”(percent), “T”(thousands), “M”(millions), “B”(billions), “TR”(trillions)

colheader(+/-b, +/- i)

Sets column headers to bold or italic style.

rowheader(+/-b, +/- i)

Sets row headers to bold or italic style.

fillcolor(arg)

Set the table row background color to that specified by arg. arg may be one of the predefined color keywords, or it may be specified using individual red-green-blue (RGB) components using the “@RGB” or “@HEX” functions. The arguments to the @RGB function are a set of three integers from 0 to 255, representing the RGB values of the color. The arguments to the “@HEX” function are a set of six characters representing the RGB values of the color in hexadecimal. Each two character set represents a red, green or blue component in the range '00' to 'FF'. For a description of the available color keywords see “Color definitions”.

altfillcolor(colorspec)

Set the table alternate row background color to colorspec. colorspec may consist of an @rgb(r,g,b) or @hex specification or it may be the name of a basic color such as “white”, “blue”, “red”, “black”, etc.

font(row, “name”, size, +/–b, +/–I, +/–s, +/–u)

Sets the font, size and style. name should be the quoted name of the font, size should be an integer size value. You may use +b, +i, +s or +u to set bold, italic, strikeout or underline respectively.

yrformat(arg)

Sets the date format for year date labels. arg may be “YYYY” (4-digit years) or “YY” (2 digit years).

qtrformat(arg)

Sets the date format for quarterly date labels. arg may be “QR” (upper-case Roman numerals), “qr” (lower-case Roman numerals), “[Q]Q” (“Q” followed by the quarter number), “Q” (quarter number), “Mon” (3 letter month abbreviation for first month in quarter), “Month” (full month name for first month in quarter).

monformat(arg)

Sets the date format for monthly date labels. arg may be “[M]mm” (“M” followed by month number), “mm” (month number), “MM” (month number with preceding zero), “[M]MM” (“M” followed by month number with preceding zero) “Mon” (3 letter month abbreviation), “Month” (full month name), “M” (upper-case first letter of month name), or “m” (lower-case first letter of month name).

qtryrformat(arg)

Sets the joint date format for quarter and year. Only applicable if “Display(first)” or “Display(last)” is used.

arg may be: “YYYY[q]Q]”, “YYYY[Q]Q”, “YYYY:Q”, “YY[q]Q”, “YY[Q]Q”, “YY:Q”, “YYYY QR”, “YYYYqr”, “YYYY qr”, “YY QR”, “YYqr”, “YY qr”, “Mon YYYY”, “Mon YY”, or “Month YYYY”.

See description of “yrformat” and “qtrformat” above for details.

monyrformat(arg)

Sets the joint date format for month and year. Only applicable if “Display(first)” or “Display(last)” is used.

arg may be: “YYYY[m]mm]”, “YYYY[M]mm”, “YYYY[m]MM”, “YYYY:M”, “YY[m]mm”, “YY[M]mm”, “YY[m]MM”, “YY:mm”, “YY:MM”, “Mon YYYY”, “Mon YY”, “Month YYYY”, “Month YY”, “YYMon”, or “YY-Mon”.

See description of “yrformat” and “monformat” above for details on each.

+/– endperiod

Use end of period date labels.