Visible Alpha Actuals & Consensus

Actuals and consensus estimates from Visible Alpha. This is only available to users with a Visible Alpha subscription.

Usage

va_actual(parameter, period='q', alignment='afp')
Parameters
  • parameter (int/str) – The parameter (line item) to retrieve. Specify either the numeric parameter id or the parameter name. Note that only a small set of parameter names is supported (see list below). For all other parameters, the parameter id must be specified - this can be retrieved from the Visible Alpha terminal by clicking on a line item and looking up the “Excel Code”. For example, the “Total revenue” parameter has a parameter id of 190.

  • period (str) – Which period to fetch the number for. One of 'q' (quarterly), 's' (semi-annually), 'a' (annually). The default value is 'q'.

  • alignment (str) – How to align the data. Either 'rd' (report date - the day the report impacted trading), 'afp' (actual fiscal period end date) or 'fp' (fiscal period end date normalised to the last day of month). The default value is 'afp'.

va_consensus(parameter, statistic_type_name='mean', period='q', alignment='afp', unreported_periods=None)
Parameters
  • parameter (int/str) – The parameter (line item) to retrieve. Specify either the numeric parameter id or the parameter name. Note that only a small set of parameter names is supported (see list below). For all other parameters, the parameter id must be specified - this can be retrieved from the Visible Alpha terminal by clicking on a line item and looking up the “Excel Code”. For example, the “Total revenue” parameter has a parameter id of 190.

  • statistic_type_name (str) – The type of the statistic to fetch. The options are 'mean' and 'count'. The default value is 'mean'.

  • period (str) – Which period to fetch the number from. One of 'q' (quarterly), 's' (semi-annually), 'a' (annually). The default value is 'q'.

  • alignment (str) – How to align the data. Either 'rd' (report date - the day the report impacted trading), 'afp' (actual fiscal period end date) or 'fp' (fiscal period end date normalised to the last day of month). The default value is 'afp'.

  • unreported_periods (int) – Number of unreported periods to return. Default is None, which returns all unreported periods.

va_revisions(parameter, period, statistic_type_name='mean')

Retrieve revisions of the consensus estimate for a given accounting period.

Parameters
  • parameter (int/str) – The parameter (line item) to retrieve. Specify either the numeric parameter id or the parameter name. Note that only a small set of parameter names is supported (see list below). For all other parameters, the parameter id must be specified - this can be retrieved from the Visible Alpha terminal by clicking on a line item and looking up the “Excel Code”. For example, the “Total revenue” parameter has a parameter id of 190.

  • period (str) – The accounting period the data should be retrieved for. Three kinds of periods can be specified: for companies reporting quarterly, use the format '4Q-2022', for companies reporting semi-anually, use '2H-2022', and for fiscal year estimates, use 'FY-2022'.

  • statistic_type_name (str) – The type of the statistic to fetch. The options are 'mean' and 'count'. The default value is 'mean'.

Examples

Retrieve quarterly total revenue:

va_actual('Total revenue')

Retrieve annual total revenue:

va_actual('Total revenue', period='a')

Retrieve quarterly gross margin, aligned to report date:

va_actual('Gross margin', alignment='rd')

Retrieve quarterly estimates for total revenue:

va_consensus('Total revenue')

Retrieve quarterly estimates for total revenue, but only include estimates for one unreported quarter:

va_consensus('Total revenue', unreported_periods=1)

Parameter names

  • Total revenue

  • Gross profit / (loss)

  • Gross margin

  • EBITDA

  • EBITDA margin

  • Operating income / (loss)

  • Operating margin

  • Net income / (loss)

  • Net margin

  • Total assets

  • Total liabilities

  • Receivables, net

  • Accounts receivable

  • Inventories, net

  • Accounts payable

  • Total debt

  • Capital expenditures

  • Free cash flow

  • EPS-Basic

  • EPS-Diluted

  • Dividend per share

  • Weighted average shares outstanding-Basic

  • Weighted average shares outstanding-Diluted