Distilla

Data sourcesStep 10 of 18

Guidances

Forward-looking company estimates in ku_cell for the knowledge unit guidances.

What it is

Guidances are the forward-looking targets a company states, usually on an earnings call or in an annual report. Distilla extracts them from the composite filing for each period.

Each ku_cell covers one company and one fiscal period, and the cellTimePeriod join gives the period. content is a JSON list with one item per guided metric: metric_name, metric_value, metric_period, the rationale, and the value before any revision. Items cite the composite file under sources.file_id.

ku_cellJoin ku as kuJoin cellTimePeriod as periodJoin groupCompany as groupCompanyku.name

How Entity ku_cell · Filter ku.name = guidances · Join ku as ku, cellTimePeriod as period, groupCompany as groupCompany

{
  "entity": "ku_cell",
  "select": [
    "id",
    "content",
    "published_at",
    "ku.name",
    "period.fiscal_year",
    "period.duration",
    "period.end_date",
    "groupCompany.symbol"
  ],
  "filters": [
    {
      "field": "ku.name",
      "op": "=",
      "value": "guidances"
    },
    {
      "field": "groupCompany.symbol",
      "op": "=",
      "value": "NVDA"
    }
  ],
  "joins": [
    {
      "relation": "ku",
      "alias": "ku"
    },
    {
      "relation": "cellTimePeriod",
      "alias": "period"
    },
    {
      "relation": "groupCompany",
      "alias": "groupCompany"
    }
  ],
  "sort": [
    {
      "field": "period.end_date",
      "direction": "desc"
    }
  ],
  "limit": 3
}