111 KiB

Raw Permalink Blame History

System Prompt

You are executing two skills in sequence:

brain-data-feature-engineering
brain-feature-implementation The following SKILL.md documents are authoritative; follow them exactly.

--- SKILL.md (brain-data-feature-engineering) ---

brain-data-feature-engineering methodology

BRAIN Data Feature Engineering Workflow

Purpose: Automatically transform BRAIN dataset fields into deep, meaningful feature engineering ideas.

Input Requirements

Required Parameters:

data_category: Dataset category (e.g., "fundamental", "analyst", "news", "model")
delay: Data delay setting (0 or 1)
region: Market region (e.g., "USA", "EUR", "ASI")

Optional Parameters:

universe: Trading universe (default: "TOP3000")
dataset_id: Specific dataset ID (if known, skips discovery phase)

Workflow Overview

Step 2: Field Extraction and Deconstruction

Deconstruct each field's meaning:
- What is being measured? (the entity/concept)
- How is it measured? (collection/calculation method)
- Time dimension? (instantaneous, cumulative, rate of change)
- Business context? (why does this field exist?)
- Generation logic? (reliability considerations)
Build field profiles: Structured understanding of each field's essence

Step 3: Reasoning and Analysis

Performs deep analysis based on collected information:

A. Field Relationship Mapping

Analyze logical connections between fields
Identify: independent fields, related fields, complementary fields
Map the "story" the dataset tells
Key question: What relationships are implied by these fields?

B. Limited Attention Information Diffusion Framework (Internal Process)

The skill asks itself these questions and generates feature concepts:

"What captures attention?" → Attention proxies
- Extreme return frequency
- Volume spike intensity
"What is overlooked?" → Information neglect
- Concurrent announcement crowding
- Complex disclosure footnotes
"What diffuses slowly?" → Gradual learning
- Analyst coverage gaps
- Institutional holding changes
"What drives demand?" → Attention pressure
- Retail order flow surges
- Search volume spikes
"What corrects eventually?" → Mean reversion
- Post-attention reversal speed
- Long-horizon convergence
"What competes for focus?" → Attention rivalry
- Cross-asset news conflicts
- Market-wide event clustering
"What is relatively ignored?" → Cross-sectional gaps
- Industry attention deviation
- Historical percentile ranking
"What anchors true value?" → Fundamental baseline
- Cash flow persistence
- Earnings quality adjustment

C. Feature Concept Generation

For each relevant question-field combination:

Formulate feature concept that answers the question
Define the concept clearly
Identify the logical meaning
Consider directionality (what high/low values mean)
Identify boundary conditions
Note potential issues/limitations

Step 4: Feature Documentation

For each generated feature concept, document:

Concept Name: Clear, descriptive name
Definition: One-sentence definition
Logical Meaning: What phenomenon/concept does it represent?
Why It's Meaningful: Why does this feature make sense?
Directionality: Interpretation of high vs. low values
Boundary Conditions: What extremes indicate
Data Requirements: What fields are used and any constraints
Potential Issues: Known limitations or concerns

Step 5: Output Generation

Generate structured markdown report including:

Output the report markdown format in the following format:

{dataset_name} Feature Engineering Analysis Report

Dataset: {dataset_id} Category: {category} Region: {region} Analysis Date: {analysis_date} Fields Analyzed: {field_count}

Executive Summary

Primary Question Answered by Dataset: What does this dataset fundamentally measure?

Key Insights from Analysis:

{insight_1}
{insight_2}
{insight_3}

Critical Field Relationships Identified:

{relationship_1}
{relationship_2}

Most Promising Feature Concepts:

{top_feature_1} - because {reason_1}
{top_feature_2} - because {reason_2}
{top_feature_3} - because {reason_3}

Dataset Deep Understanding

Dataset Description

{dataset_description}

Field Inventory

Field ID	Description	Data Type	Update Frequency	Coverage
{field_1_id}	{field_1_desc}	{type_1}	{freq_1}	{coverage_1}%
{field_2_id}	{field_2_desc}	{type_2}	{freq_2}	{coverage_2}%
{field_3_id}	{field_3_desc}	{type_3}	{freq_3}	{coverage_3}%

(Additional fields as needed)

Field Deconstruction Analysis

{field_1_id}: {field_1_name}

What is being measured?: {measurement_object_1}
How is it measured?: {measurement_method_1}
Time dimension: {time_dimension_1}
Business context: {business_context_1}
Generation logic: {generation_logic_1}
Reliability considerations: {reliability_1}

{field_2_id}: {field_2_name}

What is being measured?: {measurement_object_2}
How is it measured?: {measurement_method_2}
Time dimension: {time_dimension_2}
Business context: {business_context_2}
Generation logic: {generation_logic_2}
Reliability considerations: {reliability_2}

(Additional fields as needed)

Field Relationship Mapping

The Story This Data Tells: {story_description}

Key Relationships Identified:

{relationship_1_desc}
{relationship_2_desc}
{relationship_3_desc}

Missing Pieces That Would Complete the Picture:

{missing_1}
{missing_2}

Feature Concepts by Question Type

Q1: "What is stable?" (Invariance Features)

Concept: {stability_feature_1_name}

Sample Fields Used: fields_used_1
Definition: {definition_1}
Why This Feature: {why_1}
Logical Meaning: {logical_meaning_1}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario.
Directionality: {directionality_1}
Boundary Conditions: {boundaries_1}
Implementation Example: {implementation_1}

Concept: {stability_feature_2_name}

Sample Fields Used: fields_used_2
Definition: {definition_2}
Why This Feature: {why_2}
Logical Meaning: {logical_meaning_2}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_2}
Boundary Conditions: {boundaries_2}
Implementation Example: {implementation_2}

Q2: "What is changing?" (Dynamics Features)

Concept: {dynamics_feature_1_name}

Sample Fields Used: fields_used_3
Definition: {definition_3}
Why This Feature: {why_3}
Logical Meaning: {logical_meaning_3}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_3}
Boundary Conditions: {boundaries_3}
Implementation Example: {implementation_3}

Concept: {dynamics_feature_2_name}

Sample Fields Used: fields_used_4
Definition: {definition_4}
Why This Feature: {why_4}
Logical Meaning: {logical_meaning_4}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_4}
Boundary Conditions: {boundaries_4}
Implementation Example: {implementation_4}

Q3: "What is anomalous?" (Deviation Features)

Concept: {anomaly_feature_1_name}

Sample Fields Used: fields_used_5}
Definition: {definition_5}
Why This Feature: {why_5}
Logical Meaning: {logical_meaning_5}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_5}
Boundary Conditions: {boundaries_5}
Implementation Example: {implementation_5}

Concept: {anomaly_feature_2_name}

Sample Fields Used: fields_used_6}
Definition: {definition_6}
Why This Feature: {why_6}
Logical Meaning: {logical_meaning_6}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_6}
Boundary Conditions: {boundaries_6}
Implementation Example: {implementation_6}

Q4: "What is combined?" (Interaction Features)

Concept: {interaction_feature_1_name}

Sample Fields Used: fields_used_7}
Definition: {definition_7}
Why This Feature: {why_7}
Logical Meaning: {logical_meaning_7}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_7}
Boundary Conditions: {boundaries_7}
Implementation Example: {implementation_7}

Concept: {interaction_feature_2_name}

Sample Fields Used: fields_used_8}
Definition: {definition_8}
Why This Feature: {why_8}
Logical Meaning: {logical_meaning_8}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_8}
Boundary Conditions: {boundaries_8}
Implementation Example: {implementation_8}

Q5: "What is structural?" (Composition Features)

Concept: {structure_feature_1_name}

Sample Fields Used: fields_used_9}
Definition: {definition_9}
Why This Feature: {why_9}
Logical Meaning: {logical_meaning_9}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_9}
Boundary Conditions: {boundaries_9}
Implementation Example: {implementation_9}

Concept: {structure_feature_2_name}

Sample Fields Used: fields_used_10}
Definition: {definition_10}
Why This Feature: {why_10}
Logical Meaning: {logical_meaning_10}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_10}
Boundary Conditions: {boundaries_10}
Implementation Example: {implementation_10}

Q6: "What is cumulative?" (Accumulation Features)

Concept: {accumulation_feature_1_name}

Sample Fields Used: fields_used_11}
Definition: {definition_11}
Why This Feature: {why_11}
Logical Meaning: {logical_meaning_11}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_11}
Boundary Conditions: {boundaries_11}
Implementation Example: {implementation_11}

Concept: {accumulation_feature_2_name}

Sample Fields Used: fields_used_12}
Definition: {definition_12}
Why This Feature: {why_12}
Logical Meaning: {logical_meaning_12}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_12}
Boundary Conditions: {boundaries_12}
Implementation Example: {implementation_12}

Q7: "What is relative?" (Comparison Features)

Concept: {relative_feature_1_name}

Sample Fields Used: fields_used_13}
Definition: {definition_13}
Why This Feature: {why_13}
Logical Meaning: {logical_meaning_13}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_13}
Boundary Conditions: {boundaries_13}
Implementation Example: {implementation_13}

Concept: {relative_feature_2_name}

Sample Fields Used: fields_used_14}
Definition: {definition_14}
Why This Feature: {why_14}
Logical Meaning: {logical_meaning_14}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_14}
Boundary Conditions: {boundaries_14}
Implementation Example: {implementation_14}

Q8: "What is essential?" (Essence Features)

Concept: {essence_feature_1_name}

Sample Fields Used: fields_used_15}
Definition: {definition_15}
Why This Feature: {why_15}
Logical Meaning: {logical_meaning_15}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_15}
Boundary Conditions: {boundaries_15}
Implementation Example: {implementation_15}

Concept: {essence_feature_2_name}

Sample Fields Used: fields_used_16}
Definition: {definition_16}
Why This Feature: {why_16}
Logical Meaning: {logical_meaning_16}
Is filling nan necessary: We have some operators to fill nan value like ts_backfill() or group_mean() etc. however, in some cases, if the nan value itself has some meaning, then we should not fill it blindly since it may introduce some bias. so before filling nan value, we should think about whether the nan value has some meaning in the specific scenario. If yes, do use appropriate method to fill nan value in the following implementation example.
Directionality: {directionality_16}
Boundary Conditions: {boundaries_16}
Implementation Example: {implementation_16}

Implementation Considerations

Data Quality Notes

Coverage: {coverage_note}
Timeliness: {timeliness_note}
Accuracy: {accuracy_note}
Potential Biases: {bias_note}

Computational Complexity

Lightweight features: {simple_features}
Medium complexity: {medium_features}
Heavy computation: {complex_features}

Recommended Prioritization

Tier 1 (Immediate Implementation):

{priority_1_feature} - {priority_1_reason}
{priority_2_feature} - {priority_2_reason}
{priority_3_feature} - {priority_3_reason}

Tier 2 (Secondary Priority):

{priority_4_feature} - {priority_4_reason}
{priority_5_feature} - {priority_5_reason}

Tier 3 (Requires Further Validation):

{priority_6_feature} - {priority_6_reason}

Critical Questions for Further Exploration

Unanswered Questions:

{unanswered_question_1}
{unanswered_question_2}
{unanswered_question_3}

Recommended Additional Data:

{additional_data_1}
{additional_data_2}
{additional_data_3}

Assumptions to Challenge:

{assumption_1}
{assumption_2}
{assumption_3}

Methodology Notes

Analysis Approach: This report was generated by:

Deep field deconstruction to understand data essence
Question-driven feature generation (8 fundamental questions)
Logical validation of each feature concept
Transparent documentation of reasoning

Design Principles:

Focus on logical meaning over conventional patterns
Every feature must answer a specific question
Clear documentation of "why" for each suggestion
Emphasis on data understanding over prediction

Report generated: {generation_timestamp} Analysis depth: Comprehensive field deconstruction + 8-question framework Next steps: Implement Tier 1 features, validate assumptions, gather additional data as needed

Core Analysis Principles

From Data Essence: Start with what data truly means, not what it's traditionally used for
Autonomous Reasoning: Skill performs all thinking, no user input required
Question-Driven: Internal question bank guides feature generation
Meaning Over Patterns: Prioritize logical meaning over conventional combinations
Transparency: Show reasoning process in output

Example Output Structure

When analyzing dataset 'BEME' (Balance Sheet and Market Data), the output would include:

Dataset Understanding

Fields Analyzed: book_value, market_cap, book_to_market, etc. Key Observations: Dataset compares accounting values with market valuations

Field Deconstruction

book_value: Accountant's calculation of net asset value (quarterly, audited, historical cost-based)
market_cap: Market participants' valuation (continuous, forward-looking, sentiment-influenced)
book_to_market: Ratio comparing these two valuation perspectives

Feature Concepts Generated

From "What is stable?"

"Market reevaluation stability": Rolling coefficient of variation of book_to_market
Logic: Measures whether market opinion is stable or volatile
Meaning: Stable values suggest consensus, volatile values suggest disagreement/uncertainty

From "What is changing?"

"Value creation vs. market reevaluation decomposition": Separate book_value growth from market_cap growth
Logic: Distinguish fundamental value creation from market sentiment changes
Meaning: Which component drives changes in book_to_market?

From "What is combined?"

"Intangible value proportion": (market_cap - book_value) / enterprise_value
Logic: Quantify proportion of value from intangibles (brand, growth, etc.)
Meaning: What percentage of valuation isn't captured on the balance sheet?

(Additional question-based features would follow...)

Implementation Notes

The skill should:

Analyze first, then generate: Fully understand dataset before proposing features
Show reasoning: Explain why each feature concept makes sense
Be specific: Reference actual field names and their characteristics
Be critical: Question assumptions and identify limitations
Be creative: Look beyond traditional financial metrics

The skill should NOT:

Ask users to think: All thinking is internal to the skill
Provide generic templates: Each analysis should be specific to the dataset
Rely on conventional wisdom: Challenge traditional approaches
Output patterns without meaning: Every suggestion must have clear logic

Quality Assurance

Self-Check Process:

All fields analyzed, not just skimmed
Field meanings understood beyond descriptions
Multiple question types explored
Each feature has clear logical meaning
Reasoning is explicit, not implicit
Limitations are acknowledged
Output is dataset-specific, not generic

Validation Questions:

Would this analysis help someone truly understand the data?
Are feature concepts novel yet meaningful?
Is the reasoning process transparent?
Does it avoid conventional thinking traps?

This skill performs deep analysis of BRAIN datasets, generating meaningful feature engineering concepts based on data essence and logical reasoning.

--- SKILL.md (brain-feature-implementation) ---

name: brain-feature-implementation description: Automate conversion of Brain idea documents into actionable Alpha expressions using local CSV data.

Brain Feature Implementation

Description

This skill automates the process of converting a WorldQuant Brain idea document (Markdown) into actionable Alpha expressions.

Instructions

Analyze the Idea Document
- Read the provided markdown file.
- Extract the following metadata:
  - Dataset ID (e.g., analyst15)
  - Region (e.g., GLB)
  - Delay (e.g., 1 or 0)
- If any metadata is missing, ask the user to clarify.
Plan Implementation
- Scan the markdown file for Feature Definitions or Formulas.
- Look for patterns like Definition: <formula> or code blocks describing math.
- Use the manage_todo_list tool to create a plan with one entry for each unique idea/formula found.
  - Title: The Idea Name or ID (e.g., "3.1.1 Estimate Stability Score").
  - Description: The specific template formula (e.g., template: "{st_dev} / abs({mean})").
Execute Implementation
- For each item in the Todo List:
  - Construct the Template:
    - Use Python format string syntax {variable}.
    - The {variable} must be the exact suffix of the fields in the dataset as listed in the fields input.
    - CRITICAL: Do NOT include the dataset prefix (e.g., anl14_) or horizon in the template. The script auto-detects these.
    - Time Window Handling: For datasets with multiple time horizons (e.g., _fy1, _fy2, _fp1, _fp2), you MUST specify the time window in the variable. Use the full suffix as it appears in the field ID after removing the dataset prefix.
    - Correct Example: For field anl14_mean_roe_fy1, use template: {mean_roe_fy1}.
    - Incorrect Example: {mean_roe} (missing time window), {anl14_mean_roe_fy1} (includes prefix).
    - Note: The script ONLY accepts --template and --dataset. Do not pass any other arguments like --filters or --groupby.
  - Verify the output (number of expressions generated).
  - Mark the Todo item as completed.

"allowed_operators": [{'name': 'add', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Adds two or more inputs element wise. Set filter=true to treat NaNs as 0 before summing.', 'definition': 'add(x, y, filter = false), x + y'}, {'name': 'abs', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Returns the absolute value of a number, removing any negative sign.', 'definition': 'abs(x)'}, {'name': 'log', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Calculates the natural logarithm of the input value. Commonly used to transform data that has positive values.', 'definition': 'log(x)'}, {'name': 'subtract', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Subtracts inputs left to right: x ? y ? … Supports two or more inputs. Set filter=true to treat NaNs as 0 before subtraction.', 'definition': 'subtract(x, y, filter=false), x - y'}, {'name': 'signed_power', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'x raised to the power of y such that final result preserves sign of x', 'definition': 'signed_power(x, y)'}, {'name': 'sign', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Returns the sign of a number: +1 for positive, -1 for negative, and 0 for zero. If the input is NaN, returns NaN.\r\n\r\nInput: Value of 7 instruments at day t: (2, -3, 5, 6, 3, NaN, -10)\r\nOutput: (1, -1, 1, 1, 1, NaN, -1)', 'definition': 'sign(x)'}, {'name': 'reverse', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': '\xa0- x', 'definition': 'reverse(x)'}, {'name': 'power', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'x ^ y', 'definition': 'power(x, y)'}, {'name': 'multiply', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Multiplies two or more inputs element wise. Set filter=true to treat NaNs as 0 before multiplication', 'definition': 'multiply(x ,y, ... , filter=false), x * y'}, {'name': 'min', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Minimum value of all inputs. At least 2 inputs are required', 'definition': 'min(x, y ..)'}, {'name': 'max', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Maximum value of all inputs. At least 2 inputs are required', 'definition': 'max(x, y, ..)'}, {'name': 'inverse', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': '1 / x', 'definition': 'inverse(x)'}, {'name': 'sqrt', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Returns the non negative square root of x. Equivalent to power(x, 0.5); for signed roots use signed_power(x, 0.5).', 'definition': 'sqrt(x)'}, {'name': 's_log_1p', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Confine function to a shorter range using logarithm such that higher input remains higher and negative input remains negative as an output of resulting function and -1 or 1 is an asymptotic value', 'definition': 's_log_1p(x)'}, {'name': 'densify', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'Converts a grouping field of many buckets into lesser number of only available buckets so as to make working with grouping fields computationally efficient', 'definition': 'densify(x)'}, {'name': 'divide', 'category': 'Arithmetic', 'scope': "['REGULAR']", 'description': 'x / y', 'definition': 'divide(x, y), x / y'}, {'name': 'not', 'category': 'Logical', 'scope': "['REGULAR']", 'description': 'Returns the logical negation of x. Returns 0 when x is 1 (‘true’) and 1 when x is 0 (‘false’).', 'definition': 'not(x)'}, {'name': 'and', 'category': 'Logical', 'scope': "['REGULAR']", 'description': "Returns 1 ('true') if both inputs are 1 ('true'). Otherwise, returns 0 ('false').", 'definition': 'and(input1, input2)'}, {'name': 'less', 'category': 'Logical', 'scope': "['REGULAR']", 'description': "Returns 1 ('true') if input1 is a smaller than input2. Otherwise, returns 0 ('false').", 'definition': 'input1 < input2'}, {'name': 'equal', 'category': 'Logical', 'scope': "['REGULAR']", 'description': "Returns 1 ('true') if input1 and input2 are the same. Otherwise, returns 0 ('false').", 'definition': 'input1 == input2'}, {'name': 'or', 'category': 'Logical', 'scope': "['REGULAR']", 'description': 'Returns 1 if either input is true (either input1 or input2 has a value of 1), otherwise it returns 0.', 'definition': 'or(input1, input2)'}, {'name': 'not_equal', 'category': 'Logical', 'scope': "['REGULAR']", 'description': "Returns 1 ('true') if input1 and input2 are different numbers. Otherwise, returns 0 ('false').", 'definition': 'input1!= input2'}, {'name': 'greater', 'category': 'Logical', 'scope': "['REGULAR']", 'description': "Returns 1 ('true') if input1 is a larger than input2. Otherwise, returns 0 ('false').", 'definition': 'input1 > input2'}, {'name': 'greater_equal', 'category': 'Logical', 'scope': "['REGULAR']", 'description': "Returns 1 ('true') if input1 is a larger or the same as input2. Otherwise, returns 0 ('false').", 'definition': 'input1 >= input2'}, {'name': 'less_equal', 'category': 'Logical', 'scope': "['REGULAR']", 'description': "Returns 1 ('true') if input1 is a smaller or the same as input2. Otherwise, returns 0 ('false').", 'definition': 'input1 <= input2'}, {'name': 'is_nan', 'category': 'Logical', 'scope': "['REGULAR']", 'description': 'If (input == NaN) return 1 else return 0', 'definition': 'is_nan(input)'}, {'name': 'if_else', 'category': 'Logical', 'scope': "['REGULAR']", 'description': 'The if_else operator returns one of two values based on a condition. If the condition is true, it returns the first value; if false, it returns the second value.', 'definition': 'if_else(input1, input2, input 3)'}, {'name': 'ts_sum', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Sum values of x for the past d days.', 'definition': 'ts_sum(x, d)'}, {'name': 'ts_scale', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Scales a time series to a 0–1 range based on its minimum and maximum values over a specified period, with an optional constant shift.', 'definition': 'ts_scale(x, d, constant = 0)'}, {'name': 'ts_mean', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Calculates the simple average (mean) value of a variable x over the past d days.', 'definition': 'ts_mean(x, d)'}, {'name': 'ts_zscore', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': "Calculates the Z-score of a time series, showing how far today's value is from the recent average, measured in standard deviations. Useful for standardizing and comparing values over time.", 'definition': 'ts_zscore(x, d)'}, {'name': 'ts_std_dev', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Calculates the standard deviation of a data series x over the past d days, measuring how much the values deviate from their mean during that period.', 'definition': 'ts_std_dev(x, d)'}, {'name': 'kth_element', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Returns the K-th value from a time series by looking back over a specified number of (‘d’) days, with the option to ignore certain values. Commonly used for backfilling missing data.', 'definition': 'kth_element(x, d, k, ignore=“NaN”)'}, {'name': 'inst_tvr', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Total trading value / Total holding value in the past d days\r\n\r\nInput: Value of 1 instrument in past 5 days where first element is the latest: (105, 102, 99, 101,100)\r\nOutput: 0.022 from (1+2+3+3)/(105+102+99+101)', 'definition': 'inst_tvr(x, d)'}, {'name': 'ts_corr', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Calculates the Pearson correlation between two variables, x and y, over the past d days, showing how closely they move together.', 'definition': 'ts_corr(x, y, d)'}, {'name': 'ts_count_nans', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Counts the number of missing (NaN) values in a data series over a specified number of days.', 'definition': 'ts_count_nans(x ,d)'}, {'name': 'ts_target_tvr_decay', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Tune "ts_decay" to have a turnover equal to a certain target, with optimization weight range between lambda_min, lambda_max', 'definition': 'ts_target_tvr_decay(x, lambda_min=0, lambda_max=1, target_tvr=0.1)'}, {'name': 'ts_median', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Returns median value of x for the past d days', 'definition': 'ts_median(x, d)'}, {'name': 'ts_covariance', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Calculates the covariance between two time-series variables, y and x, over the past d days. Useful for measuring how two variables move together within a specified historical window.', 'definition': 'ts_covariance(y, x, d)'}, {'name': 'ts_decay_linear', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Applies a linear decay to time-series data over a set number of days, smoothing the data by averaging recent values and reducing the impact of older or missing data.', 'definition': 'ts_decay_linear(x, d, dense = false)'}, {'name': 'ts_product', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Returns the product of the values of x over the past d days. Useful for calculating geometric means and compounding returns or growth rates.', 'definition': 'ts_product(x, d)'}, {'name': 'ts_regression', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Returns various parameters related to regression function', 'definition': 'ts_regression(y, x, d, lag = 0, rettype = 0)'}, {'name': 'ts_delta_limit', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Limit the change in the Alpha position x between dates to a specified fraction of y. The "limit_volume" can be in the range of 0 to 1. Also, please be aware of the scaling for x and y. Besides setting y as adv20 or volume related data, you can also set y as a constant.', 'definition': 'ts_delta_limit(x, y, limit_volume=0.1)'}, {'name': 'ts_step', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Returns a counter of days, incrementing by one each day.', 'definition': 'ts_step(1)'}, {'name': 'ts_decay_exp_window', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Returns exponential decay of x with smoothing factor for the past d days', 'definition': 'ts_decay_exp_window(x, d, factor = f)'}, {'name': 'ts_quantile', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Calculates the ts_rank of the input and transforms it using the inverse cumulative distribution function (quantile function) of a specified probability distribution (default: Gaussian/normal). This helps to normalize or reshape the distribution of your data over a rolling window.', 'definition': 'ts_quantile(x,d, driver="gaussian" )'}, {'name': 'days_from_last_change', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Calculates the number of days since the last change in the value of a given variable.', 'definition': 'days_from_last_change(x)'}, {'name': 'hump', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Limits amount and magnitude of changes in input (thus reducing turnover)', 'definition': 'hump(x, hump = 0.01)'}, {'name': 'last_diff_value', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Returns the most recent value of x from the past d days that is different from the current value of x.', 'definition': 'last_diff_value(x, d)'}, {'name': 'ts_arg_max', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': "Returns the number of days since the maximum value occurred in the last d days of a time series. If today's value is the maximum, returns 0; if it was yesterday, returns 1, and so on.", 'definition': 'ts_arg_max(x, d)'}, {'name': 'ts_arg_min', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': "Returns the number of days since the minimum value occurred in a time series over the past d days. If today's value is the minimum, returns 0; if it was yesterday, returns 1, and so on.", 'definition': 'ts_arg_min(x, d)'}, {'name': 'ts_av_diff', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Calculates the difference between a value and its mean over a specified period, ignoring NaN values in the mean calculation. In short, it returns x – ts_mean(x, d) with NaNs ignored.', 'definition': 'ts_av_diff(x, d)'}, {'name': 'ts_backfill', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Replaces missing (NaN) values in a time series with the most recent valid value from a specified lookback window, improving data coverage and reducing risk from missing data.', 'definition': 'ts_backfill(x,lookback = d, k=1)'}, {'name': 'ts_rank', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Ranks the value of a variable for each instrument over a specified number of past days, returning the rank of the current value (optionally adjusted by a constant). Useful for normalizing time-series data and highlighting relative performance over time.', 'definition': 'ts_rank(x, d, constant = 0)'}, {'name': 'ts_delay', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Returns the value of a variable x from d days ago. Use this operator to access historical data points by specifying the desired time lag in days.', 'definition': 'ts_delay(x, d)'}, {'name': 'ts_delta', 'category': 'Time Series', 'scope': "['REGULAR']", 'description': 'Calculates the difference between a value and its delayed version over a specified period. Useful for measuring changes or momentum in time-series data.', 'definition': 'ts_delta(x, d)'}, {'name': 'winsorize', 'category': 'Cross Sectional', 'scope': "['REGULAR']", 'description': 'Winsorizes x to make sure that all values in x are between the lower and upper limits, which are specified as multiple of std.\r\n\r\nInput: Value of 7 instruments at day t: (2, 4, 5, 6, 3, 8, 10), std: 1\r\nOutput: (2.81, 4, 5, 6, 3, 8, 8.03) from SD. = 2.61, mean = 5.42', 'definition': 'winsorize(x, std=4)'}, {'name': 'truncate', 'category': 'Cross Sectional', 'scope': "['REGULAR']", 'description': 'Operator truncates all values of x to maxPercent. Here, maxPercent is in decimal notation', 'definition': 'truncate(x,maxPercent=0.01)'}, {'name': 'regression_neut', 'category': 'Cross Sectional', 'scope': "['REGULAR']", 'description': 'Conducts the cross-sectional regression on the stocks with Y as target and X as the independent variable', 'definition': 'regression_neut(y, x)'}, {'name': 'scale', 'category': 'Cross Sectional', 'scope': "['REGULAR']", 'description': 'Scales input to booksize. We can also scale the long positions and short positions to separate scales by mentioning additional parameters to the operator', 'definition': 'scale(x, scale=1, longscale=1, shortscale=1)'}, {'name': 'rank', 'category': 'Cross Sectional', 'scope': "['REGULAR']", 'description': 'Ranks the input among all the instruments and returns an equally distributed number between 0.0 and 1.0. For precise sort, use the rate as 0', 'definition': 'rank(x, rate=2)'}, {'name': 'quantile', 'category': 'Cross Sectional', 'scope': "['REGULAR']", 'description': 'Rank the raw vector, shift the ranked Alpha vector, apply distribution (gaussian, cauchy, uniform). If driver is uniform, it simply subtract each Alpha value with the mean of all Alpha values in the Alpha vector', 'definition': 'quantile(x, driver = gaussian, sigma = 1.0)'}, {'name': 'normalize', 'category': 'Cross Sectional', 'scope': "['REGULAR']", 'description': 'Calculates the mean value of all valid alpha values for a certain date, then subtracts that mean from each element', 'definition': 'normalize(x, useStd = false, limit = 0.0)'}, {'name': 'zscore', 'category': 'Cross Sectional', 'scope': "['REGULAR']", 'description': "Z-score is a numerical measurement that describes a value's relationship to the mean of a group of values. Z-score is measured in terms of standard deviations from the mean", 'definition': 'zscore(x)'}, {'name': 'vec_min', 'category': 'Vector', 'scope': "['REGULAR']", 'description': 'Minimum value form vector field x', 'definition': 'vec_min(x)'}, {'name': 'vec_count', 'category': 'Vector', 'scope': "['REGULAR']", 'description': 'Number of elements in vector field x', 'definition': 'vec_count(x)'}, {'name': 'vec_stddev', 'category': 'Vector', 'scope': "['REGULAR']", 'description': 'Standard Deviation of vector field x', 'definition': 'vec_stddev(x)'}, {'name': 'vec_range', 'category': 'Vector', 'scope': "['REGULAR']", 'description': 'Difference between maximum and minimum element in vector field x', 'definition': 'vec_range(x)'}, {'name': 'vec_avg', 'category': 'Vector', 'scope': "['REGULAR']", 'description': 'Taking mean of the vector field x\r\n\r\nInput: Vector of value of 1 instrument in a day: (2, 3, 5, 6, 3, 8, 10)\r\nOutput: 37 / 7 = 5.29', 'definition': 'vec_avg(x)'}, {'name': 'vec_sum', 'category': 'Vector', 'scope': "['REGULAR']", 'description': 'Sum of vector field x\r\n\r\nInput: Vector of value of 1 instrument in a day: (2, 3, 5, 6, 3, 8, 10)\r\nOutput: 2 + 3 + 5 + 6 + 3 + 8 + 10 = 37', 'definition': 'vec_sum(x)'}, {'name': 'vec_max', 'category': 'Vector', 'scope': "['REGULAR']", 'description': 'Maximum value form vector field x', 'definition': 'vec_max(x)'}, {'name': 'left_tail', 'category': 'Transformational', 'scope': "['REGULAR']", 'description': 'NaN everything greater than maximum, maximum should be constant', 'definition': 'left_tail(x, maximum = 0)'}, {'name': 'trade_when', 'category': 'Transformational', 'scope': "['REGULAR']", 'description': 'Used in order to change Alpha values only under a specified condition and to hold Alpha values in other cases. It also allows to close Alpha positions (assign NaN values) under a specified condition', 'definition': 'trade_when(x, y, z)'}, {'name': 'right_tail', 'category': 'Transformational', 'scope': "['REGULAR']", 'description': 'NaN everything less than minimum, minimum should be constant', 'definition': 'right_tail(x, minimum = 0)'}, {'name': 'bucket', 'category': 'Transformational', 'scope': "['REGULAR']", 'description': 'Convert float values into indexes for user-specified buckets. Bucket is useful for creating group values, which can be passed to GROUP as input', 'definition': 'bucket(rank(x), range="0, 1, 0.1" or buckets = "2,5,6,7,10")'}, {'name': 'group_rank', 'category': 'Group', 'scope': "['REGULAR']", 'description': 'Each elements in a group is assigned the corresponding rank in this group', 'definition': 'group_rank(x, group)'}, {'name': 'group_cartesian_product', 'category': 'Group', 'scope': "['REGULAR']", 'description': 'Merge two groups into one group. If originally there are len_1 and len_2 group indices in g1 and g2, there will be len_1 * len_2 indices in the new group.', 'definition': 'group_cartesian_product(g1, g2)'}, {'name': 'group_backfill', 'category': 'Group', 'scope': "['REGULAR']", 'description': 'If a certain value for a certain date and instrument is NaN, from the set of same group instruments, calculate winsorized mean of all non-NaN values over last d days', 'definition': 'group_backfill(x, group, d, std = 4.0)'}, {'name': 'group_mean', 'category': 'Group', 'scope': "['REGULAR']", 'description': 'All elements in group equals to the mean', 'definition': 'group_mean(x, weight, group)'}, {'name': 'group_neutralize', 'category': 'Group', 'scope': "['REGULAR']", 'description': 'Neutralizes Alpha against groups. These groups can be subindustry, industry, sector, country or a constant', 'definition': 'group_neutralize(x, group)'}, {'name': 'group_normalize', 'category': 'Group', 'scope': "['REGULAR']", 'description': "Normalizes input such that each group's absolute sum is 1", 'definition': 'group_normalize(x, group, constantCheck=False, tolerance=0.01, scale=1)'}, {'name': 'group_median', 'category': 'Group', 'scope': "['REGULAR']", 'description': 'All elements in group equals to the median value of the group.', 'definition': 'group_median(x, group)'}, {'name': 'group_scale', 'category': 'Group', 'scope': "['REGULAR']", 'description': 'Normalizes the values in a group to be between 0 and 1. (x - groupmin) / (groupmax - groupmin)', 'definition': 'group_scale(x, group)'}, {'name': 'group_zscore', 'category': 'Group', 'scope': "['REGULAR']", 'description': "Calculates group Z-score - numerical measurement that describes a value's relationship to the mean of a group of values. Z-score is measured in terms of standard deviations from the mean. zscore = (data - mean) / stddev of x for each instrument within its group.\r\n\r\nInput: Value of 5 instruments of Group A: (100, 0, 50, 60, 25)\r\nOutput: (1.57, -1.39, 0.09, 0.39, -0.65)", 'definition': 'group_zscore(x, group)'}]

CRITICAL OUTPUT RULES (to ensure implement_idea.py can generate expressions):

Every Implementation Example MUST be a Python format template using {variable}.
Every {variable} MUST be constructed from the actual field suffixes provided in the fields list. Do NOT invent variable names.
The suffix must match exactly how it appears in the field ID after removing the dataset prefix (e.g., for anl14_mean_roe_fy1, use {mean_roe_fy1}, not {mean_roe} or {roe}).
When you implement ideas, ONLY use operators from allowed_operators provided.
Do NOT include dataset codes/prefixes/horizons in {variable} beyond the suffix itself.
If you show raw field ids in tables, use backticks `like_this`, NOT {braces}.
Include these metadata lines verbatim somewhere near the top: Dataset: <dataset_id> Region: Delay:

User Prompt

{ "instructions": { "output_format": "Fill OUTPUT_TEMPLATE.md with concrete content.", "implementation_examples": "Each Implementation Example must be a template with {variable} placeholders. Use only suffixes derived from the provided fields list. Always include time window suffixes (e.g., _fy1, _fp1) when present in the fields.", "no_code_fences": true, "do_not_invent_placeholders": true }, "dataset_context": { "dataset_id": "analyst4", "dataset_name": null, "dataset_description": null, "category": "Analyst", "region": "USA", "delay": 1, "universe": "TOP3000", "field_count": 653 }, "fields": [{'id': 'total_goodwill_reported_value', 'description': 'Total Goodwill - Actual Value in Millions'}, {'id': 'total_goodwill_amount', 'description': 'Total Goodwill - Value'}, {'id': 'total_goodwill_actual_value', 'description': 'Total Goodwill - announced financial value'}, {'id': 'total_assets_reported_value', 'description': 'Total Assets - actual value'}, {'id': 'total_assets_amount', 'description': 'Total Assets - actual value'}, {'id': 'tangible_book_value_per_share_max_guidance', 'description': 'Tangible Book Value per Share - Maximum guidance value'}, {'id': 'stock_option_expense_max_guidance_qtr', 'description': 'Stock option expense - maximum guidance value'}, {'id': 'shares_outstanding_max_guidance', 'description': 'Maximum guidance value for Shares'}, {'id': 'shareholders_equity_total_2', 'description': "Shareholder's Equity - Total Value"}, {'id': 'shareholders_equity_reported_value', 'description': "Shareholders' Equity - Total Value"}, {'id': 'shareholders_equity_min_guidance', 'description': 'Minimum guidance value for Share Equity'}, {'id': 'shareholders_equity_max_guidance', 'description': "The maximum guidance value for Shareholder's Equity on an annual basis."}, {'id': 'shareholders_equity_actual_value', 'description': "Shareholders' Equity - Total Value"}, {'id': 'sg_and_admin_min_guidance_value', 'description': 'Minimum guidance value for Selling, General & Administrative Expense on an annual basis.'}, {'id': 'selling_general_admin_expense_reported_value', 'description': 'Selling, General & Administrative Expense value'}, {'id': 'selling_general_admin_expense_max_guidance_qtr', 'description': 'Selling, General & Admin Expenses - Maximum guidance value'}, {'id': 'selling_general_admin_expense_actual_value', 'description': 'Selling, General & Administrative Expense - actual value'}, {'id': 'selling_general_admin_expense', 'description': 'Selling, General & Administrative Expense Value'}, {'id': 'sales_previous_estimate_value', 'description': 'The previous estimation of Sales'}, {'id': 'sales_min_guidance_value', 'description': 'Minimum sales guidance for the annual period.'}, {'id': 'sales_min_guidance_quarterly', 'description': 'Minimum guidance value for Sales'}, {'id': 'sales_max_guidance_value', 'description': 'Maximum guidance value for annual sales'}, {'id': 'sales_max_guidance_quarterly', 'description': 'The maximum guidance value for sales.'}, {'id': 'sales_guidance_value_quarterly', 'description': 'Sales - guidance value'}, {'id': 'sales_guidance_value', 'description': 'Sales - Guidance value for the annual period'}, {'id': 'sales_estimate_value', 'description': 'Sales - Estimated value'}, {'id': 'sales_estimate_stddev_quarterly', 'description': 'Standard deviation of Sales estimations'}, {'id': 'sales_estimate_standard_deviation', 'description': 'Sales - standard deviation of estimations'}, {'id': 'sales_estimate_minimum_quarterly', 'description': 'Sales - The lowest estimation'}, {'id': 'sales_estimate_minimum', 'description': 'Sales - The lowest estimation'}, {'id': 'sales_estimate_median_value', 'description': 'Sales - Median value among forecasts'}, {'id': 'sales_estimate_median_quarterly', 'description': 'Sales - median of estimations'}, {'id': 'sales_estimate_maximum_quarterly', 'description': 'Sales - The highest estimation'}, {'id': 'sales_estimate_maximum', 'description': 'Sales - The highest estimation'}, {'id': 'sales_estimate_dispersion', 'description': 'Standard deviation of Sales estimations for the annual period.'}, {'id': 'sales_estimate_count_quarterly', 'description': 'Sales - number of estimations'}, {'id': 'sales_estimate_count_2', 'description': 'Number of Sales estimates'}, {'id': 'sales_estimate_count', 'description': 'Sales - number of estimations'}, {'id': 'sales_estimate_average_quarterly', 'description': 'Sales - mean of estimations'}, {'id': 'sales_estimate_average_annual', 'description': 'Sales - mean of estimations'}, {'id': 'sales_estimate_average', 'description': 'Sales - mean of estimations with a delay of 1 quarter'}, {'id': 'research_development_max_guidance', 'description': 'The maximum guidance value for Research and Development Expense on an annual basis.'}, {'id': 'research_development_expense_reported_value', 'description': 'Research & Development (Income Statement) Value in Millions'}, {'id': 'research_development_expense_actual_value', 'description': 'Research and Development Expense- announced financial value'}, {'id': 'research_development_expense', 'description': 'Research & Development Expense - Actual Value (Annual)'}, {'id': 'reporting_currency_code_9', 'description': 'Home currency of instrument'}, {'id': 'previous_recommendation_value', 'description': 'The previous estimation of financial item for recommendation'}, {'id': 'previous_quarterly_guidance_estimate', 'description': 'The previous estimation of finanicial item'}, {'id': 'previous_guidance_value_annual', 'description': 'The previous estimation of finanicial item'}, {'id': 'previous_guidance_estimate', 'description': 'The previous estimation of financial item - annual frequency'}, {'id': 'pretax_income_total', 'description': 'Pretax Profit - Value for the annual period'}, {'id': 'pretax_income_standalone_value', 'description': 'Pretax Profit - actual value for the quarter'}, {'id': 'pretax_income_reported_value', 'description': 'Reported Pretax income - actual value for the quarter'}, {'id': 'pretax_income_reported_min_guidance_qtr', 'description': 'Reported Pretax income- minimum guidance value'}, {'id': 'pretax_income_reported_min_guidance', 'description': 'Reported Pretax income - minimum guidance value'}, {'id': 'pretax_income_reported', 'description': 'Reported Pretax income - actual value for the annual fiscal period'}, {'id': 'pretax_income_max_guidance_qtr', 'description': 'The maximum guidance value for Pretax income.'}, {'id': 'pretax_income_actual_reported_value', 'description': 'Reported Pretax income- announced financial value'}, {'id': 'operating_profit_max_guidance_qtr', 'description': 'The maximum guidance value for Earnings Before Interest and Taxes.'}, {'id': 'operating_profit_before_interest_tax', 'description': 'Earnings Before Interest and Taxes (EBIT) - Actual Value'}, {'id': 'operating_profit_before_depr_amort_min_guidance_qtr', 'description': 'Minimum guidance value for Earnings before interest, taxes, depreciation and amortization'}, {'id': 'operating_profit_before_depr_amort_max_guidance_qtr', 'description': 'Max guidance value for Earnings before interest, taxes, depreciation and amortization'}, {'id': 'operating_profit_before_depr_amort', 'description': 'EBITDA value - Annual'}, {'id': 'operating_cashflow_reported_value', 'description': 'Cash Flow from Operations - Value'}, {'id': 'net_profit_reported_value', 'description': 'Net profit- announced financial value'}, {'id': 'net_profit_adjusted_value', 'description': 'Adjusted net income- announced financial value'}, {'id': 'net_profit_adjusted_min_guidance', 'description': 'The minimum guidance value for adjusted net profit on an annual basis.'}, {'id': 'net_income_total_2', 'description': 'Net profit- announced financial value for annual data'}, {'id': 'net_income_adjusted', 'description': 'Adjusted net income- announced financial value for annual frequency'}, {'id': 'net_debt_reported_value', 'description': 'Net Debt value for the quarter'}, {'id': 'net_debt_min_guidance_qtr', 'description': 'Minimum guidance value for Net Debt'}, {'id': 'net_debt_max_guidance_qtr', 'description': 'Maximum guidance value for Net Debt'}, {'id': 'net_debt_amount', 'description': 'Net debt - actual value for the annual period'}, {'id': 'net_debt_actual_value', 'description': 'Net debt- announced financial value'}, {'id': 'minimum_guidance_value', 'description': 'Minimum guidance value for basic annual financials'}, {'id': 'min_total_goodwill_guidance', 'description': 'Total Goodwill - The lowest guidance value'}, {'id': 'min_total_assets_guidance_2', 'description': 'Minimum guidance value for Total Assets on an annual basis'}, {'id': 'min_total_assets_guidance', 'description': 'Minimum guidance value for Total Assets'}, {'id': 'min_tangible_book_value_per_share_guidance_2', 'description': 'Tangible Book Value per Share - Minimum guidance value'}, {'id': 'min_tangible_book_value_per_share_guidance', 'description': 'Tangible Book Value per Share - minimum guidance value'}, {'id': 'min_stock_option_expense_guidance_2', 'description': 'Minimum guidance value for stock option expense on an annual basis'}, {'id': 'min_stock_option_expense_guidance', 'description': 'Stock option expense - minimum guidance value'}, {'id': 'min_shares_outstanding_guidance', 'description': 'Minimum guidance value for Shares'}, {'id': 'min_shareholders_equity_guidance', 'description': "Minimum guidance value for Shareholders' Equity"}, {'id': 'min_share_count_guidance', 'description': 'Minimum guidance for shares on an annual basis'}, {'id': 'min_share_buyback_guidance', 'description': 'Shares Basic - Minimum guidance value for the annual period'}, {'id': 'min_sg_and_a_expense_guidance', 'description': 'Selling, General & Administrative Expense - Minimum guidance value'}, {'id': 'min_research_development_expense_guidance_2', 'description': 'Minimum guidance value for Research & Development Expense on an annual basis'}, {'id': 'min_research_development_expense_guidance', 'description': 'Minimum guidance value for Research & Development Expense'}, {'id': 'min_reported_eps_guidance', 'description': 'Reported Earnings Per Share - Minimum guidance value for the annual period'}, {'id': 'min_pretax_profit_guidance_2', 'description': 'The minimum guidance value for Pretax income on an annual basis.'}, {'id': 'min_pretax_profit_guidance', 'description': 'Minimum guidance value for Pretax income'}, {'id': 'min_operating_cashflow_guidance', 'description': 'Minimum guidance value for Cash Flow from Operations'}, {'id': 'min_net_profit_guidance', 'description': 'Minimum guidance value for Net Profit on an annual basis'}, {'id': 'min_net_income_guidance', 'description': 'Net profit - minimum guidance value'}, {'id': 'min_net_debt_guidance', 'description': 'The minimum guidance value for Net Debt on an annual basis.'}, {'id': 'min_investing_cashflow_guidance_2', 'description': 'Cash Flow From Investing - Minimum guidance value for the annual period'}, {'id': 'min_investing_cashflow_guidance', 'description': 'Cash Flow From Investing - Minimum guidance value'}, {'id': 'min_gross_income_guidance_2', 'description': 'The minimum guidance for Gross Income on an annual basis.'}, {'id': 'min_gross_income_guidance', 'description': 'The minimum guidance value for Gross Income.'}, {'id': 'min_funds_from_operations_guidance', 'description': 'Funds from operation - minimum guidance value for annual period'}, {'id': 'min_free_cashflow_per_share_guidance', 'description': 'Free cash flow per share - minimum guidance value'}, {'id': 'min_free_cashflow_guidance', 'description': 'Minimum guidance value for Free Cash Flow'}, {'id': 'min_free_cash_flow_per_share_guidance', 'description': 'Free cash flow per share - minimum guidance value for the annual period'}, {'id': 'min_free_cash_flow_guidance', 'description': 'The minimum guidance value for Free Cash Flow on an annual basis.'}, {'id': 'min_financing_cashflow_guidance_2', 'description': 'Minimum guidance value for Cash Flow From Financing on an annual basis'}, {'id': 'min_financing_cashflow_guidance', 'description': 'Minimum guidance value for Cash Flow From Financing'}, {'id': 'min_ebitda_guidance', 'description': 'Minimum guidance value for Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) - Annual'}, {'id': 'min_ebit_guidance_2', 'description': 'Minimum guidance value for Earnings Before Interest and Taxes (EBIT) on an annual basis.'}, {'id': 'min_ebit_guidance', 'description': 'Minimum guidance value for Earnings Before Interest and Taxes (EBIT)'}, {'id': 'min_customized_eps_guidance', 'description': 'Customized Earnings per share - Minimum guidance value for the annual period'}, {'id': 'min_custom_eps_guidance', 'description': 'Custom Earnings per share - Minimum guidance value'}, {'id': 'min_capital_expenditure_guidance', 'description': 'Minimum guidance value for Capital Expenditures'}, {'id': 'min_capex_guidance', 'description': 'Minimum guidance value for Capital Expenditures'}, {'id': 'min_book_value_per_share_guidance', 'description': 'Book value per share - minimum guidance value for the annual period'}, {'id': 'min_basic_shares_guidance', 'description': 'Shares Basic - Minimum guidance value'}, {'id': 'min_adjusted_net_income_guidance', 'description': 'Adjusted net income - minimum guidance value'}, {'id': 'min_adjusted_funds_from_operations_guidance_2', 'description': 'Adjusted funds from operation - minimum guidance for the annual period'}, {'id': 'min_adjusted_funds_from_operations_guidance', 'description': 'Funds from operation - minimum guidance value'}, {'id': 'min_adjusted_funds_from_operations_adj_guidance', 'description': 'Minimum guidance value for Adjusted funds from operation'}, {'id': 'median_sales_estimate', 'description': 'Sales - median of estimations'}, {'id': 'maximum_guidance_value', 'description': 'Maximum guidance value for basic annual financials'}, {'id': 'max_total_goodwill_guidance_2', 'description': 'The maximum guidance value for Total Goodwill on an annual basis.'}, {'id': 'max_total_goodwill_guidance', 'description': 'The maximum guidance value for Total Goodwill.'}, {'id': 'max_total_assets_guidance_2', 'description': 'The maximum guidance value for Total Assets'}, {'id': 'max_total_assets_guidance', 'description': 'The maximum guidance value for Total Assets.'}, {'id': 'max_tangible_book_value_per_share_guidance', 'description': 'Tangible Book Value per Share - maximum guidance value'}, {'id': 'max_stock_option_expense_guidance', 'description': 'Stock option expense - Maximum guidance value for the annual period'}, {'id': 'max_shares_outstanding_guidance', 'description': 'The maximum guidance for Shares'}, {'id': 'max_shareholders_equity_guidance', 'description': "The maximum guidance value for Total Shareholders' Equity."}, {'id': 'max_share_buyback_guidance', 'description': 'Maximum guidance value for Shares Basic - Annual'}, {'id': 'max_selling_general_admin_guidance', 'description': 'The maximum guidance value for Selling, General & Administrative Expense'}, {'id': 'max_research_development_expense_guidance', 'description': 'The maximum guidance value for Research and Development Expense.'}, {'id': 'max_reported_pretax_income_guidance_2', 'description': 'Reported Pretax income- maximum guidance value'}, {'id': 'max_reported_pretax_income_guidance', 'description': 'Reported Pretax income- maximum guidance value'}, {'id': 'max_reported_eps_guidance_2', 'description': 'Reported Earnings Per Share - Maximum guidance value for the annual period'}, {'id': 'max_reported_eps_guidance', 'description': 'Reported Earnings Per Share - Maximum guidance value'}, {'id': 'max_pretax_profit_guidance', 'description': 'The maximum guidance value for Pretax income on an annual basis.'}, {'id': 'max_operating_cashflow_guidance_2', 'description': 'The maximum guidance value for Cash Flow from Operations on an annual basis.'}, {'id': 'max_operating_cashflow_guidance', 'description': 'The maximum guidance value for Cash Flow from Operations.'}, {'id': 'max_net_profit_guidance', 'description': 'The maximum guidance value for net profit on an annual basis.'}, {'id': 'max_net_income_guidance', 'description': 'The maximum guidance value for net profit.'}, {'id': 'max_net_debt_guidance', 'description': 'The maximum guidance value for Net Debt on an annual basis.'}, {'id': 'max_investing_cashflow_guidance_2', 'description': 'The maximum guidance value for Cash Flow from Investing activities on an annual basis.'}, {'id': 'max_investing_cashflow_guidance', 'description': 'The maximum guidance value for Cash Flow from Investing.'}, {'id': 'max_gross_income_guidance_2', 'description': 'The maximum guidance for Gross Income on an annual basis.'}, {'id': 'max_gross_income_guidance', 'description': 'The maximum guidance value for Gross Income.'}, {'id': 'max_free_cashflow_per_share_guidance', 'description': 'The maximum guidance value for free cash flow per share.'}, {'id': 'max_free_cashflow_guidance', 'description': 'The maximum guidance value for Free Cash Flow.'}, {'id': 'max_free_cash_flow_guidance', 'description': 'The maximum guidance value for Free Cash Flow on an annual basis.'}, {'id': 'max_financing_cashflow_guidance', 'description': 'Cash Flow From Financing - Maximum guidance value'}, {'id': 'max_ebitda_guidance', 'description': 'The maximum guidance value for Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) on an annual basis.'}, {'id': 'max_ebit_guidance', 'description': 'The maximum guidance value for Earnings Before Interest and Taxes (EBIT) on an annual basis.'}, {'id': 'max_customized_eps_guidance', 'description': 'The maximum guidance value for custom earnings per share on an annual basis.'}, {'id': 'max_custom_eps_guidance', 'description': 'Custom Earnings per share - The highest guidance value'}, {'id': 'max_capital_expenditure_guidance', 'description': 'The maximum guidance value for Capital Expenditures on an annual basis.'}, {'id': 'max_book_value_per_share_guidance_2', 'description': 'Book value per share - Maximum guidance value for the annual period'}, {'id': 'max_book_value_per_share_guidance', 'description': 'Book value per share - Maximum value among forecasts'}, {'id': 'max_adjusted_net_profit_guidance', 'description': 'The maximum guidance value for adjusted net profit on an annual basis.'}, {'id': 'max_adjusted_net_income_guidance', 'description': 'The maximum guidance value for Adjusted net income.'}, {'id': 'max_adjusted_funds_from_operations_guidance_2', 'description': 'Adjusted funds from operation - maximum guidance value for the annual period'}, {'id': 'max_adjusted_funds_from_operations_guidance', 'description': 'Max guidance value for Funds from operation'}, {'id': 'max_adjusted_funds_from_operations_adj_guidance', 'description': 'Adjusted funds from operation - Maximum guidance value'}, {'id': 'max_adjusted_eps_guidance_2', 'description': 'The maximum guidance value for adjusted earnings per share on an annual basis.'}, {'id': 'max_adjusted_eps_guidance', 'description': 'The maximum guidance value for adjusted earnings per share.'}, {'id': 'lowest_sales_estimate', 'description': 'Sales - The lowest estimation for the annual period'}, {'id': 'investing_cashflow_reported_value', 'description': 'Cash Flow from Investing - Value'}, {'id': 'highest_sales_estimate', 'description': 'Sales - The highest estimation for the annual period'}, {'id': 'guidance_value_currency_code_qtr', 'description': 'Home currency of instrument'}, {'id': 'guidance_reporting_currency', 'description': 'Pricing Currency where the security trades - Annual'}, {'id': 'guidance_previous_estimate_value_qtr', 'description': 'The previous estimation of finanicial item'}, {'id': 'guidance_estimate_value', 'description': 'Estimated value for basic annual financial guidance'}, {'id': 'gross_income_total', 'description': 'Gross Income value on an annual basis'}, {'id': 'gross_income_reported_value', 'description': 'Gross Income value for the quarter'}, {'id': 'goodwill_min_guidance_qtr', 'description': 'Minimum guidance value for Total Goodwill'}, {'id': 'funds_from_operations_max_guidance', 'description': 'The maximum guidance value for Funds from operation - annual'}, {'id': 'free_cash_flow_total', 'description': 'Free Cash Flow value - Annual'}, {'id': 'free_cash_flow_reported_value', 'description': 'Free cash flow value for the quarter.'}, {'id': 'free_cash_flow_per_share_reported_value', 'description': 'Free cash flow per share- announced financial value'}, {'id': 'free_cash_flow_per_share_max_guidance', 'description': 'The maximum guidance value for Free Cash Flow Per Share on an annual basis.'}, {'id': 'free_cash_flow_per_share_actual_value', 'description': 'Free cash flow per share- announced financial value'}, {'id': 'free_cash_flow_per_share', 'description': 'Free cash flow per share - actual financial value for the annual period'}, {'id': 'financing_cashflow_reported_value', 'description': 'Cash Flow From Financing - Value'}, {'id': 'estimate_value_currency_code_qtr', 'description': 'Home currency of instrument'}, {'id': 'estimate_value_currency_code_detail_qtr', 'description': 'Home currency of instrument'}, {'id': 'estimate_value_currency_code', 'description': 'Home currency of instrument'}, {'id': 'est_tot_goodwill', 'description': 'Total Goodwill - mean of estimations'}, {'id': 'est_tot_assets', 'description': 'Total Assets - mean of estimations'}, {'id': 'est_tbv_ps', 'description': 'Tangible Book Value per Share - mean of estimations'}, {'id': 'est_shequity', 'description': 'Mean of SH Equity segment - mean of estimations'}, {'id': 'est_sga', 'description': 'SGA - mean of estimations'}, {'id': 'est_sales', 'description': 'Sales - mean of estimations'}, {'id': 'est_rd_expense', 'description': 'Research and Development Expense - mean of estimations'}, {'id': 'est_ptpr', 'description': 'Reported pretax income - mean of estimations'}, {'id': 'est_ptp', 'description': 'Pretax income - mean of estimations'}, {'id': 'est_netprofit_adj', 'description': 'Adjusted net income - Mean of estimations'}, {'id': 'est_netprofit', 'description': 'Net profit - mean of estimations'}, {'id': 'est_netdebt', 'description': 'Net debt - mean of estimations'}, {'id': 'est_grossincome', 'description': 'Gross income - Mean of estimations'}, {'id': 'est_ffo', 'description': 'Funds From Operation - Summary on Estimations, Mean'}, {'id': 'est_fcf_ps', 'description': 'Free Cash Flow Per Share - Mean of Estimations'}, {'id': 'est_fcf', 'description': 'Free Cash Flow - Mean of Estimations'}, {'id': 'est_epsr', 'description': 'GAAP Earnings per share - mean of estimations'}, {'id': 'est_epsa', 'description': 'Earnings per share adjusted by excluding extraordinary items and stock option expenses - average of estimations'}, {'id': 'est_eps', 'description': 'Earnings per share - mean of estimations'}, {'id': 'est_ebitda', 'description': 'Earnings before interest, taxes, depreciation, and amortization - mean of estimations'}, {'id': 'est_ebit', 'description': 'Earnings before interest and taxes - mean of estimations'}, {'id': 'est_dividend_ps', 'description': 'Dividend per share - average of estimations'}, {'id': 'est_cashflow_ps', 'description': 'Cash Flow Per Share - average of estimations'}, {'id': 'est_cashflow_op', 'description': 'Cash Flow From Operations - mean of estimations'}, {'id': 'est_cashflow_invst', 'description': 'Cash Flow From Investing - mean of estimations'}, {'id': 'est_cashflow_fin', 'description': 'Cash Flow From Financing - mean of estimations'}, {'id': 'est_capex', 'description': 'Capital Expenditures - mean of estimations'}, {'id': 'est_bookvalue_ps', 'description': 'Book value per share - average of estimations'}, {'id': 'eps_reported_min_guidance_qtr', 'description': 'Reported Earnings Per Share - Minimum guidance value'}, {'id': 'eps_previous_estimate_value', 'description': 'The previous estimation of Earnings Per Share'}, {'id': 'eps_min_guidance_quarterly', 'description': 'Minimum guidance value for Earnings per Share'}, {'id': 'eps_max_guidance_quarterly', 'description': 'The maximum guidance value for Earnings Per Share.'}, {'id': 'eps_guidance_value_quarterly', 'description': 'Earnings Per Share - Basic value'}, {'id': 'eps_estimate_value', 'description': 'Earnings per share - estimation value'}, {'id': 'eps_adjusted_min_guidance_value', 'description': 'The minimum guidance value for adjusted earnings per share excluding extraordinary items and stock option expenses on an annual basis.'}, {'id': 'eps_adjusted_min_guidance_qtr', 'description': 'Minimum guidance value for adjusted Earnings per share excluding extraordinary items and stock option expenses.'}, {'id': 'ebitda_reported_value', 'description': 'EBITDA value for the quarter.'}, {'id': 'ebit_reported_value', 'description': 'Earnings Before Interest & Taxes - actual value for the quarter'}, {'id': 'earnings_per_share_standard_deviation', 'description': 'Earnings per share - standard deviation of estimations'}, {'id': 'earnings_per_share_reported_value', 'description': 'Reported Earnings Per Share - Actual Value'}, {'id': 'earnings_per_share_reported', 'description': 'Reported Earnings Per Share - Actual Value'}, {'id': 'earnings_per_share_nongaap_value', 'description': 'Non-GAAP Earnings Per Share - Actual Value'}, {'id': 'earnings_per_share_minimum', 'description': 'Earnings per share - The lowest estimation'}, {'id': 'earnings_per_share_min_guidance', 'description': 'Minimum guidance value for Earnings Per Share on an annual basis.'}, {'id': 'earnings_per_share_median_value', 'description': 'Earnings per share - median of estimations'}, {'id': 'earnings_per_share_maximum', 'description': 'Earnings per share - The highest estimation'}, {'id': 'earnings_per_share_max_guidance', 'description': 'The maximum guidance value for Earnings Per Share on an annual basis.'}, {'id': 'earnings_per_share_guidance_value', 'description': 'Earnings Per Share - guidance value for annual frequency'}, {'id': 'earnings_per_share_estimate_count', 'description': 'Earnings per share - number of estimations'}, {'id': 'earnings_per_share_average', 'description': 'Earnings per share - mean of estimations'}, {'id': 'dividend_previous_estimate_value', 'description': 'The previous estimation of dividend'}, {'id': 'dividend_min_guidance_value', 'description': 'Minimum guidance value for Dividend per share on an annual basis'}, {'id': 'dividend_min_guidance_quarterly', 'description': 'Minimum guidance value for Dividend per share'}, {'id': 'dividend_max_guidance_value', 'description': 'The maximum guidance value for Dividend per share on an annual basis.'}, {'id': 'dividend_max_guidance_quarterly', 'description': 'Maximum guidance value for Dividend per share'}, {'id': 'dividend_estimate_value', 'description': 'Dividend per share - estimated value'}, {'id': 'dividend_estimate_stddev_quarterly', 'description': 'Dividend per share - standard deviation of estimations'}, {'id': 'dividend_estimate_standard_deviation', 'description': 'Dividend per share - standard deviation of estimations'}, {'id': 'dividend_estimate_minimum', 'description': 'Dividend per share - The lowest value among forecasts - D1'}, {'id': 'dividend_estimate_median_value', 'description': 'Dividend per share - median of estimations'}, {'id': 'dividend_estimate_maximum', 'description': 'Dividend per share - The highest value among forecasts with a delay of 1 quarter'}, {'id': 'dividend_estimate_count', 'description': 'Dividend per share - number of estimations with a delay of 1 quarter'}, {'id': 'dividend_estimate_average', 'description': 'Dividend per share - average of estimations - delay 1'}, {'id': 'cashflow_per_share_minimum', 'description': 'Cash Flow Per Share - The lowest estimation, delay 1 quarter'}, {'id': 'cashflow_per_share_min_guidance_quarterly', 'description': 'Minimum guidance value for Cash Flow Per Share'}, {'id': 'cashflow_per_share_min_guidance', 'description': 'Cash Flow Per Share - Minimum guidance value for the annual period'}, {'id': 'cashflow_per_share_median_value', 'description': 'Cash Flow Per Share - Median value among forecasts'}, {'id': 'cashflow_per_share_maximum', 'description': 'Cash Flow - The highest estimation, per share, with a delay of 1 quarter'}, {'id': 'cashflow_per_share_max_guidance_quarterly', 'description': 'The maximum guidance value for Cash Flow Per Share.'}, {'id': 'cashflow_per_share_max_guidance', 'description': 'The maximum guidance value for Cash Flow Per Share on an annual basis.'}, {'id': 'cashflow_per_share_estimate_count', 'description': 'Cash Flow Per Share - number of estimations - delay1'}, {'id': 'cashflow_per_share_average', 'description': 'Cash Flow Per Share - average of estimations with a delay of 1 quarter'}, {'id': 'cash_flow_operations_min_guidance', 'description': 'Minimum guidance value for Cash Flow from Operations on an annual basis.'}, {'id': 'cash_flow_from_operations', 'description': 'Cash Flow from Operations - Value for the annual period'}, {'id': 'cash_flow_from_investing', 'description': 'Cash Flow from Investing - Value'}, {'id': 'cash_flow_from_financing', 'description': 'Cash Flow From Financing - Value'}, {'id': 'cash_flow_financing_max_guidance', 'description': 'Cash Flow From Financing - Maximum guidance value provided annually'}, {'id': 'capital_expenditure_reported_value', 'description': 'Capital Expenditures - Total (Cash Flow/Investing) (Millions)'}, {'id': 'capital_expenditure_max_guidance_qtr', 'description': 'The maximum guidance value for Capital Expenditures'}, {'id': 'capital_expenditure_guidance_value', 'description': 'Capital Expenditures - Total value for the annual guidance'}, {'id': 'capital_expenditure_amount', 'description': 'Capital Expenditures - Total value'}, {'id': 'book_value_per_share_reported_value', 'description': 'Book Value Per Share - Actual Value'}, {'id': 'book_value_per_share_min_guidance_qtr', 'description': 'Book value per share - minimum guidance value'}, {'id': 'book_value_per_share_2', 'description': 'Book Value Per Share - Actual Value'}, {'id': 'basic_shares_max_guidance_qtr', 'description': 'The maximum guidance value for Basic Shares.'}, {'id': 'anl4_under', 'description': 'The number of Underweight recommendations'}, {'id': 'anl4_totgw_number', 'description': 'Total Goodwill - number of estimations'}, {'id': 'anl4_totgw_median', 'description': 'Total Goodwill - median of estimations'}, {'id': 'anl4_totgw_mean', 'description': 'Total Goodwill - mean of estimations'}, {'id': 'anl4_totgw_low', 'description': 'Total Goodwill - The lowest estimation'}, {'id': 'anl4_totgw_high', 'description': 'Total Goodwill - The highest estimation'}, {'id': 'anl4_totassets_value', 'description': 'Total Assets - actual value'}, {'id': 'anl4_totassets_std', 'description': 'Total Assets - standard deviation of estimations'}, {'id': 'anl4_totassets_number', 'description': 'Total Assets - number of estimations'}, {'id': 'anl4_totassets_median', 'description': 'Total Assets - median of estimations'}, {'id': 'anl4_totassets_mean', 'description': 'Total Assets - mean of estimations'}, {'id': 'anl4_totassets_low', 'description': 'Total Assets - The lowest estimation'}, {'id': 'anl4_totassets_high', 'description': 'Total Assets - The highest estimation'}, {'id': 'anl4_totassets_flag', 'description': 'Total Assets - forecast type (revision/new/...)'}, {'id': 'anl4_total_rec', 'description': 'The total number of recommendations'}, {'id': 'anl4_tot_gw_ft', 'description': 'Total Goodwill - forecast type (revision/new/...)'}, {'id': 'anl4_tbvps_number', 'description': 'Tangible Book Value per Share - number of estimations'}, {'id': 'anl4_tbvps_median', 'description': 'Tangible Book Value per Share - median of estimations'}, {'id': 'anl4_tbvps_mean', 'description': 'Tangible Book Value per Share - mean of estimations'}, {'id': 'anl4_tbvps_low', 'description': 'Tangible Book Value per Share - The lowest estimation'}, {'id': 'anl4_tbvps_high', 'description': 'Tangible Book Value per Share - The highest estimation'}, {'id': 'anl4_tbve_ft', 'description': 'Tangible Book Value per Share - forecast type (revision/new/...)'}, {'id': 'anl4_rd_exp_number', 'description': 'Research and Development Expense - Number of Estimations'}, {'id': 'anl4_rd_exp_median', 'description': 'Research and Development Expense - Median of estimations'}, {'id': 'anl4_rd_exp_mean', 'description': 'Research and Development Expense - mean of estimations'}, {'id': 'anl4_rd_exp_low', 'description': 'Research and Development Expense - the lowest estimation'}, {'id': 'anl4_rd_exp_high', 'description': 'Research and Development Expense - the highest estimation'}, {'id': 'anl4_rd_exp_flag', 'description': 'Research and Development Expense - forecast type (revision/new/...)'}, {'id': 'anl4_qfv4_minguidance', 'description': 'Min guidance value'}, {'id': 'anl4_qfv4_median_eps', 'description': 'Earnings per share - median of estimations'}, {'id': 'anl4_qfv4_maxguidance', 'description': 'Max guidance value'}, {'id': 'anl4_qfv4_eps_number', 'description': 'Earnings per share - number of estimations'}, {'id': 'anl4_qfv4_eps_mean', 'description': 'Earnings per share - mean of estimations'}, {'id': 'anl4_qfv4_eps_low', 'description': 'Earnings per share - The lowest estimation'}, {'id': 'anl4_qfv4_eps_high', 'description': 'Earnings per share - The highest estimation'}, {'id': 'anl4_qfv4_dts_spe', 'description': 'Earnings per share - standard deviation of estimations'}, {'id': 'anl4_qfv4_div_number', 'description': 'Dividend - number of estimations'}, {'id': 'anl4_qfv4_div_median', 'description': 'Dividend per share - median of estimations'}, {'id': 'anl4_qfv4_div_mean', 'description': 'Dividend per share - mean of estimations'}, {'id': 'anl4_qfv4_div_low', 'description': 'Dividend per share - The lowest estimation'}, {'id': 'anl4_qfv4_div_high', 'description': 'Dividend per share - The highest estimation'}, {'id': 'anl4_qfv4_cfps_number', 'description': 'Cash Flow Per Share - number of estimations'}, {'id': 'anl4_qfv4_cfps_median', 'description': 'Cash Flow Per Share - Median value among forecasts'}, {'id': 'anl4_qfv4_cfps_mean', 'description': 'Cash Flow Per Share - average of estimations'}, {'id': 'anl4_qfv4_cfps_low', 'description': 'Cash Flow Per Share - The lowest estimation'}, {'id': 'anl4_qfv4_cfps_high', 'description': 'Cash Flow Per Share - The highest estimation for the quarter'}, {'id': 'anl4_qfv4_actual', 'description': 'Announced financial data'}, {'id': 'anl4_qfd1_azeps', 'description': 'EPS - aggregation on estimations, 50th percentile'}, {'id': 'anl4_qfd1_az_wol_vid', 'description': 'Dividend per share - The lowest value among forecasts'}, {'id': 'anl4_qfd1_az_wol_spfc', 'description': 'Cash Flow Per Share - The lowest estimation'}, {'id': 'anl4_qfd1_az_wol_spe', 'description': 'Earnings per share - The lowest estimation'}, {'id': 'anl4_qfd1_az_hgih_vid', 'description': 'Dividend per share - The highest estimation'}, {'id': 'anl4_qfd1_az_hgih_spfc', 'description': 'Cash Flow - The highest estimation, per share'}, {'id': 'anl4_qfd1_az_hgih_spe', 'description': 'Earnings per share - The highest estimation'}, {'id': 'anl4_qfd1_az_eps_number', 'description': 'Earnings per share - number of estimations'}, {'id': 'anl4_qfd1_az_dts_spe', 'description': 'Earnings per share - std of estimations'}, {'id': 'anl4_qfd1_az_div_number', 'description': 'Dividend per share - number of estimations'}, {'id': 'anl4_qfd1_az_div_median', 'description': 'Dividend per share - median of estimations'}, {'id': 'anl4_qfd1_az_cfps_number', 'description': 'Cash Flow Per Share - number of estimations'}, {'id': 'anl4_qfd1_az_cfps_median', 'description': 'Cash Flow Per Share - Median value among forecasts'}, {'id': 'anl4_qf_az_wol_vid', 'description': 'Dividend per share - The lowest value among forecasts'}, {'id': 'anl4_qf_az_wol_spfc', 'description': 'Cash Flow Per Share - The lowest estimation'}, {'id': 'anl4_qf_az_wol_spe', 'description': 'Earnings per share - The lowest estimation'}, {'id': 'anl4_qf_az_hgih_vid', 'description': 'Dividend per share - The highest estimation'}, {'id': 'anl4_qf_az_hgih_spfc', 'description': 'Cash Flow - The highest estimation, per share'}, {'id': 'anl4_qf_az_hgih_spe', 'description': 'Earnings per share - The highest estimation'}, {'id': 'anl4_qf_az_eps_number', 'description': 'Earnings per share - number of estimations'}, {'id': 'anl4_qf_az_eps_mean', 'description': 'Earnings per share - mean of estimations'}, {'id': 'anl4_qf_az_eps', 'description': 'EPS - aggregation on estimations, 50th percentile'}, {'id': 'anl4_qf_az_dts_spe', 'description': 'Earnings per share - std of estimations'}, {'id': 'anl4_qf_az_div_number', 'description': 'Dividend per share - number of estimations'}, {'id': 'anl4_qf_az_div_median', 'description': 'Dividend per share - median of estimations'}, {'id': 'anl4_qf_az_div_mean', 'description': 'Dividend per share - average of estimations'}, {'id': 'anl4_qf_az_cfps_number', 'description': 'Cash Flow Per Share - number of estimations'}, {'id': 'anl4_qf_az_cfps_median', 'description': 'Cash Flow Per Share - Median value among forecasts'}, {'id': 'anl4_qf_az_cfps_mean', 'description': 'Cash Flow Per Share - average of estimations'}, {'id': 'anl4_ptpr_number', 'description': 'Reported Pretax Income - number of estimations'}, {'id': 'anl4_ptpr_median', 'description': 'Reported pretax income - Median of estimations'}, {'id': 'anl4_ptpr_mean', 'description': 'Reported Pretax income - mean of estimations'}, {'id': 'anl4_ptpr_low', 'description': 'Reported Pretax Income - The Lowest Estimation'}, {'id': 'anl4_ptpr_high', 'description': 'Reported pretax income - the highest estimation'}, {'id': 'anl4_ptpr_flag', 'description': 'Reported Pretax income - forecast type (revision/new/...)'}, {'id': 'anl4_ptp_value', 'description': 'Pretax income- announced financial value'}, {'id': 'anl4_ptp_number', 'description': 'Pretax Income - number of estimations'}, {'id': 'anl4_ptp_median', 'description': 'Pretax income - median of estimations'}, {'id': 'anl4_ptp_mean', 'description': 'Pretax income - mean of estimations'}, {'id': 'anl4_ptp_low', 'description': 'Pretax income - the lowest estimation'}, {'id': 'anl4_ptp_high', 'description': 'Pretax income - the highest estimation'}, {'id': 'anl4_ptp_flag', 'description': 'Pretax income - forecast type (revision/new/...)'}, {'id': 'anl4_norec', 'description': 'The number of brokers with no recommendation'}, {'id': 'anl4_netprofita_value', 'description': 'Adjusted net income- announced financial value'}, {'id': 'anl4_netprofita_std', 'description': 'Adjusted net income - std of estimations'}, {'id': 'anl4_netprofita_number', 'description': 'Adjusted net income - number of estimations'}, {'id': 'anl4_netprofita_median', 'description': 'Adjusted net income - median of estimations'}, {'id': 'anl4_netprofita_mean', 'description': 'Adjusted net income - mean of estimations'}, {'id': 'anl4_netprofita_low', 'description': 'Adjusted net income - the lowest estimation'}, {'id': 'anl4_netprofita_high', 'description': 'Adjusted Net Income - the highest estimation'}, {'id': 'anl4_netprofit_value', 'description': 'Net profit- announced financial value'}, {'id': 'anl4_netprofit_std', 'description': 'Net profit - standard deviation of estimations'}, {'id': 'anl4_netprofit_number', 'description': 'Net profit - number of estimations'}, {'id': 'anl4_netprofit_median', 'description': 'Net profit - Median of estimations'}, {'id': 'anl4_netprofit_mean', 'description': 'Net profit - mean of estimations'}, {'id': 'anl4_netprofit_low', 'description': 'Net Profit - The Lowest Estimation'}, {'id': 'anl4_netprofit_high', 'description': 'Net Profit - The highest estimation'}, {'id': 'anl4_netprofit_flag', 'description': 'Net profit - forecast type (revision/new/...)'}, {'id': 'anl4_netdebt_number', 'description': 'Net debt - Number of estimations'}, {'id': 'anl4_netdebt_median', 'description': 'Net Debt - median of estimations'}, {'id': 'anl4_netdebt_mean', 'description': 'Net debt - mean of estimations'}, {'id': 'anl4_netdebt_low', 'description': 'Net debt - the lowest estimation'}, {'id': 'anl4_netdebt_high', 'description': 'Net debt - the highest estimation'}, {'id': 'anl4_netdebt_flag', 'description': 'Net debt - forecast type (revision/new/...)'}, {'id': 'anl4_medianepsbfam', 'description': 'Earnings before interest, taxes, depreciation and amortization - median of estimations'}, {'id': 'anl4_median_epsreported', 'description': 'GAAP Earnings per share - median of estimations'}, {'id': 'anl4_median_capexp', 'description': 'Capital Expenditures - median of estimations'}, {'id': 'anl4_mark', 'description': 'Recommendation consensus score'}, {'id': 'anl4_hold', 'description': 'The number of recommendations not clear about short or long the instrument'}, {'id': 'anl4_guiqfv4_est', 'description': 'Estimation value'}, {'id': 'anl4_guibasicqfv4_est', 'description': 'Estimation value'}, {'id': 'anl4_guiafv4_est', 'description': 'Estimation value'}, {'id': 'anl4_gric_value', 'description': 'Gross income- announced financial value'}, {'id': 'anl4_gric_std', 'description': 'Gross income - std of estimations'}, {'id': 'anl4_gric_number', 'description': 'Gross income - number of estimations'}, {'id': 'anl4_gric_median', 'description': 'Gross income - median of estimations'}, {'id': 'anl4_gric_mean', 'description': 'Gross income - mean of estimations'}, {'id': 'anl4_gric_low', 'description': 'Gross income - The lowest estimation'}, {'id': 'anl4_gric_high', 'description': 'Gross income - The highest estimation'}, {'id': 'anl4_gric_flag', 'description': 'Gross income - forecast type (revision/new/...)'}, {'id': 'anl4_fsguidanceqfv4_minguidance', 'description': 'Min guidance value'}, {'id': 'anl4_fsguidanceqfv4_maxguidance', 'description': 'Max guidance value'}, {'id': 'anl4_fsguidanceqfv4_item', 'description': 'Financial item'}, {'id': 'anl4_fsguidancebasicqfv4_item', 'description': 'Financial item'}, {'id': 'anl4_fsguidanceafv4_minguidance', 'description': 'Min guidance value'}, {'id': 'anl4_fsguidanceafv4_maxguidance', 'description': 'Maximum guidance value'}, {'id': 'anl4_fsguidanceafv4_item', 'description': 'Financial item'}, {'id': 'anl4_fsgdncbscv4_minguidance', 'description': 'Minimum guidance value'}, {'id': 'anl4_fsgdncbscv4_maxguidance', 'description': 'Max guidance value'}, {'id': 'anl4_fsdtlestmtsafv4_item', 'description': 'Financial item'}, {'id': 'anl4_fsdtlestmtqfv4_item', 'description': 'Financial item'}, {'id': 'anl4_fsdtlestmtbscv104_item', 'description': 'Financial item'}, {'id': 'anl4_fsdtlestmtbscqv104_item', 'description': 'Financial item'}, {'id': 'anl4_fsdtlestmtafv4_item', 'description': 'Financial item'}, {'id': 'anl4_fsdetailrecv4v104_item', 'description': 'Financial item'}, {'id': 'anl4_fsdetailltv4v104_item', 'description': 'Financial item'}, {'id': 'anl4_fsactualqfv4_item', 'description': 'Financial item'}, {'id': 'anl4_fsactualqfv4_actual', 'description': 'Announced financial data'}, {'id': 'anl4_fsactualafv4_item', 'description': 'Financial item'}, {'id': 'anl4_fsactualafv4_actual', 'description': 'Announced financial data'}, {'id': 'anl4_flag_erbfintax', 'description': 'Earnings before interest and taxes - forecast type (revision/new/...)'}, {'id': 'anl4_ffo_flag', 'description': 'Funds from Operation - forecast type (revision/new/...)'}, {'id': 'anl4_fcfps_number', 'description': 'Free Cash Flow per Share - number of estimations'}, {'id': 'anl4_fcfps_median', 'description': 'Free cash flow - summary on estimations, 50th-percentile, per share'}, {'id': 'anl4_fcfps_mean', 'description': 'Free cash flow per share - mean of estimations'}, {'id': 'anl4_fcfps_low', 'description': 'Free Cash Flow Per Share - the lowest estimation'}, {'id': 'anl4_fcfps_high', 'description': 'Free Cash Flow Per Share - the highest estimation'}, {'id': 'anl4_fcfps_flag', 'description': 'Free cash flow per share - forecast type (revision/new/...)'}, {'id': 'anl4_fcf_value', 'description': 'Free cash flow- announced financial value'}, {'id': 'anl4_fcf_number', 'description': 'Free Cash Flow - number of estimations'}, {'id': 'anl4_fcf_median', 'description': 'Free cash flow - aggregation on estimations, 50th percentile'}, {'id': 'anl4_fcf_mean', 'description': 'Free Cash Flow - mean of estimations'}, {'id': 'anl4_fcf_low', 'description': 'Free Cash Flow - The lowest estimation'}, {'id': 'anl4_fcf_high', 'description': 'Free cash flow - aggregation on estimations, max'}, {'id': 'anl4_fcf_flag', 'description': 'Free cash flow - forecast type (revision/new/...)'}, {'id': 'anl4_epsr_value', 'description': 'GAAP Earnings per share - announced financial value'}, {'id': 'anl4_epsr_number', 'description': 'GAAP Earnings per share - number of estimations'}, {'id': 'anl4_epsr_mean', 'description': 'GAAP Earnings per share - mean of estimations'}, {'id': 'anl4_epsr_low', 'description': 'GAAP Earnings per share - The lowest estimation'}, {'id': 'anl4_epsr_high', 'description': 'GAAP Earnings per share - The highest estimation'}, {'id': 'anl4_epsr_flag', 'description': 'GAAP Earnings - estimation type (revision/new/...), per share'}, {'id': 'anl4_epsa_flag', 'description': 'Earnings per share adjusted by excluding extraordinary items and stock option expenses - forecast type (revision/new/...)'}, {'id': 'anl4_ebitda_value', 'description': 'Earnings before interest, taxes, depreciation and amortization - announced financial value'}, {'id': 'anl4_ebitda_std', 'description': 'Earnings before interest, taxes, depreciation, and amortization - standard deviation of estimations'}, {'id': 'anl4_ebitda_number', 'description': 'Earnings before interest, taxes, depreciation and amortization - number of estimations'}, {'id': 'anl4_ebitda_mean', 'description': 'Earnings before interest, taxes, depreciation and amortization - mean of estimations'}, {'id': 'anl4_ebitda_low', 'description': 'Earnings before interest, taxes, depreciation and amortization - The lowest estimation'}, {'id': 'anl4_ebitda_high', 'description': 'Earnings before interest, taxes, depreciation, and amortization - the highest estimation'}, {'id': 'anl4_ebitda_flag', 'description': 'Earnings before interest, taxes, depreciation and amortization - forecast type (revision/new/...)'}, {'id': 'anl4_ebit_value', 'description': 'Earnings before interest and taxes - announced financial value'}, {'id': 'anl4_ebit_std', 'description': 'Earnings before interest and taxes - standard deviation of estimations'}, {'id': 'anl4_ebit_number', 'description': 'Earnings before interest and taxes - number of estimations'}, {'id': 'anl4_ebit_median', 'description': 'Earnings before interest and taxes - median of estimations'}, {'id': 'anl4_ebit_mean', 'description': 'Earnings before interest and taxes - mean of estimations'}, {'id': 'anl4_ebit_low', 'description': 'Earnings before interest and taxes - The lowest estimation'}, {'id': 'anl4_ebit_high', 'description': 'Earnings before interest and taxes - The highest estimation'}, {'id': 'anl4_eaz2lrec_ratingvalue', 'description': 'Score on the given instrument'}, {'id': 'anl4_eaz2lrec_person', 'description': 'Broker Id'}, {'id': 'anl4_eaz2lrec_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_eaz2lqfv110_prevval', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_eaz2lqfv110_person', 'description': 'Broker Id'}, {'id': 'anl4_eaz2lqfv110_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_eaz2lqfv110_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_eaz2lltv110_prevval', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_eaz2lltv110_person', 'description': 'Broker Id'}, {'id': 'anl4_eaz2lltv110_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_eaz2lltv110_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_eaz2lafv110_prevval', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_eaz2lafv110_person', 'description': 'Broker Id'}, {'id': 'anl4_eaz2lafv110_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_eaz2lafv110_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_eaz1lqfv110_prevval', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_eaz1lqfv110_person', 'description': 'Broker Id'}, {'id': 'anl4_eaz1lqfv110_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_eaz1lqfv110_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_eaz1laf_prevval', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_eaz1laf_person', 'description': 'Broker Id'}, {'id': 'anl4_eaz1laf_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_eaz1laf_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_dts_rspe', 'description': 'Reported Earnings per share - standard deviation of estimations'}, {'id': 'anl4_dts_ptp', 'description': 'Pretax income - std of estimations'}, {'id': 'anl4_dez1safv4_preest', 'description': 'The previous estimation of finanicial item'}, {'id': 'anl4_dez1safv4_est', 'description': 'Estimation value'}, {'id': 'anl4_dez1qfv4_preest', 'description': 'The previous estimation of finanicial item'}, {'id': 'anl4_dez1qfv4_est', 'description': 'Estimation value'}, {'id': 'anl4_dez1basicqfv4v104_preest', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_dez1basicqfv4v104_est', 'description': 'Estimation value'}, {'id': 'anl4_dez1basicqfv4_preest', 'description': 'The previous estimation of finanicial item'}, {'id': 'anl4_dez1basicqfv4_est', 'description': 'Estimation value'}, {'id': 'anl4_dez1basicafv4v104_preest', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_dez1basicafv4v104_est', 'description': 'Estimation value'}, {'id': 'anl4_dez1basicafv4_preest', 'description': 'The previous estimation of finanicial item'}, {'id': 'anl4_dez1basicafv4_est', 'description': 'Estimation value'}, {'id': 'anl4_dez1afv4_preest', 'description': 'The previous estimation of finanicial item'}, {'id': 'anl4_dez1afv4_est', 'description': 'Estimation value'}, {'id': 'anl4_detailrecv4v104_est', 'description': 'Estimation value'}, {'id': 'anl4_detailrecv4_est', 'description': 'Estimation value for recommendation detail'}, {'id': 'anl4_detailltv4v104_preest', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_detailltv4v104_est', 'description': 'Estimation value'}, {'id': 'anl4_detailltv4_preest', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_detailltv4_est', 'description': 'Long term estimation value'}, {'id': 'anl4_dei3lrec_item', 'description': 'Financial item'}, {'id': 'anl4_dei3lqfv110_item', 'description': 'Financial item'}, {'id': 'anl4_dei3lltv110_item', 'description': 'Financial item'}, {'id': 'anl4_dei3lafv110_item', 'description': 'Financial item'}, {'id': 'anl4_dei2lqfv110_item', 'description': 'Financial item'}, {'id': 'anl4_dei2laf_item', 'description': 'Financial item'}, {'id': 'anl4_cuo1guidaf_minguidance', 'description': 'Minimum guidance value'}, {'id': 'anl4_cuo1guidaf_maxguidance', 'description': 'Max guidance value'}, {'id': 'anl4_cuo1guidaf_item', 'description': 'Financial item'}, {'id': 'anl4_cuo1detailqfv110_item', 'description': 'Financial item'}, {'id': 'anl4_cuo1detailafv110_item', 'description': 'Financial item'}, {'id': 'anl4_cuo1conqfv110_item', 'description': 'Financial item'}, {'id': 'anl4_cuo1conafv110_item', 'description': 'Financial item'}, {'id': 'anl4_cuo1actualqfv110_item', 'description': 'Financial item'}, {'id': 'anl4_cuo1actualqfv110_actual', 'description': 'Announced financial data'}, {'id': 'anl4_cfo_value', 'description': 'Cash Flow From Operations - announced financial value'}, {'id': 'anl4_cfo_number', 'description': 'Cash Flow From Operations - number of estimations'}, {'id': 'anl4_cfo_median', 'description': 'Cash Flow From Operations - median of estimations'}, {'id': 'anl4_cfo_mean', 'description': 'Cash Flow From Operations - mean of estimations'}, {'id': 'anl4_cfo_low', 'description': 'Cash Flow From Operations - The lowest estimation'}, {'id': 'anl4_cfo_high', 'description': 'Cash Flow From Operations - The highest value among forecasts'}, {'id': 'anl4_cfo_flag', 'description': 'Cash Flow From Operations - forecast type (revision/new/...)'}, {'id': 'anl4_cfi_value', 'description': 'Cash Flow From Investing - announced financial value'}, {'id': 'anl4_cfi_number', 'description': 'Cash Flow From Investing - number of estimations'}, {'id': 'anl4_cfi_median', 'description': 'Cash Flow From Investing - median of estimations'}, {'id': 'anl4_cfi_mean', 'description': 'Cash Flow From Investing - mean of estimations'}, {'id': 'anl4_cfi_low', 'description': 'Cash Flow From Investing - The lowest estimation'}, {'id': 'anl4_cfi_high', 'description': 'Cash Flow From Investing - The highest estimation'}, {'id': 'anl4_cfi_flag', 'description': 'Cash Flow From Investing - forecast type (revision/new/...)'}, {'id': 'anl4_cff_value', 'description': 'Cash Flow From Financing - announced financial value'}, {'id': 'anl4_cff_number', 'description': 'Cash Flow From Financing - number of estimations'}, {'id': 'anl4_cff_median', 'description': 'Cash Flow From Financing Activities - Median value among forecasts'}, {'id': 'anl4_cff_mean', 'description': 'Cash Flow From Financing - mean of estimations'}, {'id': 'anl4_cff_low', 'description': 'Cash Flow From Financing - The lowest estimation'}, {'id': 'anl4_cff_high', 'description': 'Cash Flow From Financing - The highest of forecasted values'}, {'id': 'anl4_cff_flag', 'description': 'Cash Flow From Financing Activities - forecast type (revision/new/...)'}, {'id': 'anl4_capex_value', 'description': 'Capital Expenditures - announced financial value'}, {'id': 'anl4_capex_std', 'description': 'Capital Expenditures - standard deviation of estimations'}, {'id': 'anl4_capex_number', 'description': 'Capital Expenditures - number of estimations'}, {'id': 'anl4_capex_mean', 'description': 'Capital Expenditures - mean of estimations'}, {'id': 'anl4_capex_low', 'description': 'Capital Expenditures - The lowest estimation'}, {'id': 'anl4_capex_high', 'description': 'Capital Expenditures - The highest estimation'}, {'id': 'anl4_capex_flag', 'description': 'Capital Expenditures - forecast type (revision/new/...)'}, {'id': 'anl4_bvps_value', 'description': 'Book value per share - announced financial value'}, {'id': 'anl4_bvps_number', 'description': 'Book value per share - number of estimations'}, {'id': 'anl4_bvps_median', 'description': 'Book value per share - Median value among forecasts'}, {'id': 'anl4_bvps_mean', 'description': 'Book value per share - average of estimations'}, {'id': 'anl4_bvps_low', 'description': 'Book value - the lowest estimation, per share'}, {'id': 'anl4_bvps_high', 'description': 'Book value - the highest estimation, per share'}, {'id': 'anl4_bvps_flag', 'description': 'Book value per share - forecast type (revision/new/...)'}, {'id': 'anl4_buy', 'description': 'The number of recommendations to long the instrument'}, {'id': 'anl4_baz1v110_prevval', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_baz1v110_person', 'description': 'Broker Id'}, {'id': 'anl4_baz1v110_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_baz1v110_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_basicqfv4_minguidance', 'description': 'Min guidance value'}, {'id': 'anl4_basicqfv4_maxguidance', 'description': 'Max guidance value'}, {'id': 'anl4_basicqfv4_actual', 'description': 'Announced financial data'}, {'id': 'anl4_basicdetailrec_ratingvalue', 'description': 'Score on the given instrument'}, {'id': 'anl4_basicdetailrec_person', 'description': 'Broker Id'}, {'id': 'anl4_basicdetailrec_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_basicdetailqfv110_prevval', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_basicdetailqfv110_person', 'description': 'Broker Id'}, {'id': 'anl4_basicdetailqfv110_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_basicdetailqfv110_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_basicdetaillt_prevval', 'description': 'The Previous Estimation of Financial Item'}, {'id': 'anl4_basicdetaillt_person', 'description': 'Broker Id'}, {'id': 'anl4_basicdetaillt_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_basicdetaillt_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_basicconqfv110_pu', 'description': 'The number of upper estimations'}, {'id': 'anl4_basicconqfv110_numest', 'description': 'The number of forecasts counted in aggregation'}, {'id': 'anl4_basicconqfv110_median', 'description': 'Median of estimations'}, {'id': 'anl4_basicconqfv110_mean', 'description': 'Mean of estimations'}, {'id': 'anl4_basicconqfv110_low', 'description': 'The lowest estimation'}, {'id': 'anl4_basicconqfv110_high', 'description': 'The highest estimation'}, {'id': 'anl4_basicconqfv110_down', 'description': 'Number of lower estimations'}, {'id': 'anl4_basicconltv110_pu', 'description': 'The number of upper estimations'}, {'id': 'anl4_basicconltv110_numest', 'description': 'The number of forecasts counted in aggregation'}, {'id': 'anl4_basicconltv110_median', 'description': 'Median of estimations'}, {'id': 'anl4_basicconltv110_mean', 'description': 'Mean of estimations'}, {'id': 'anl4_basicconltv110_low', 'description': 'The lowest estimation'}, {'id': 'anl4_basicconltv110_high', 'description': 'The highest estimation'}, {'id': 'anl4_basicconltv110_down', 'description': 'Number of lower estimations'}, {'id': 'anl4_basicconafv110_pu', 'description': 'The number of upper estimations'}, {'id': 'anl4_basicconafv110_numest', 'description': 'The number of forecasts counted in aggregation'}, {'id': 'anl4_basicconafv110_median', 'description': 'Median of estimations'}, {'id': 'anl4_basicconafv110_mean', 'description': 'Mean of estimations'}, {'id': 'anl4_basicconafv110_low', 'description': 'The lowest estimation'}, {'id': 'anl4_basicconafv110_high', 'description': 'The highest estimation'}, {'id': 'anl4_basicconafv110_down', 'description': 'Number of lower estimations'}, {'id': 'anl4_basicafv4_actual', 'description': 'Announced financial data for the annual period.'}, {'id': 'anl4_bac1detailrec_item', 'description': 'Financial item'}, {'id': 'anl4_bac1detailqfv110_item', 'description': 'Financial item'}, {'id': 'anl4_bac1detaillt_item', 'description': 'Financial item'}, {'id': 'anl4_bac1detailafv110_item', 'description': 'Financial item'}, {'id': 'anl4_bac1conrecv110_item', 'description': 'Financial item'}, {'id': 'anl4_bac1conqfv110_item', 'description': 'Financial item'}, {'id': 'anl4_bac1conltv110_item', 'description': 'Financial item'}, {'id': 'anl4_bac1conafv110_item', 'description': 'Financial item'}, {'id': 'anl4_bac1actualqfv110_item', 'description': 'Financial item'}, {'id': 'anl4_bac1actualqfv110_actual', 'description': 'Announced financial data'}, {'id': 'anl4_afv4_minguidance', 'description': 'Min guidance value'}, {'id': 'anl4_afv4_median_eps', 'description': 'Earnings per share - median of estimations'}, {'id': 'anl4_afv4_maxguidance', 'description': 'Max guidance value'}, {'id': 'anl4_afv4_eps_number', 'description': 'Earnings per share - number of estimations for annual frequency'}, {'id': 'anl4_afv4_eps_mean', 'description': 'Earnings per share - mean of estimations for annual frequency'}, {'id': 'anl4_afv4_eps_low', 'description': 'Earnings per share - The lowest estimation for annual frequency'}, {'id': 'anl4_afv4_eps_high', 'description': 'Earnings per share - The highest estimation'}, {'id': 'anl4_afv4_dts_spe', 'description': 'Earnings per share - standard deviation of estimations'}, {'id': 'anl4_afv4_div_std', 'description': 'Dividend per share - standard deviation of estimations'}, {'id': 'anl4_afv4_div_number', 'description': 'Number of estimations for Dividend per share - annually'}, {'id': 'anl4_afv4_div_median', 'description': 'Dividend per share - Median value among forecasts'}, {'id': 'anl4_afv4_div_mean', 'description': 'Dividend per share - average of estimations for annual frequency'}, {'id': 'anl4_afv4_div_low', 'description': 'Dividend - The lowest estimation for the annual forecast'}, {'id': 'anl4_afv4_div_high', 'description': 'Dividend per share - The highest estimation for the annual forecast.'}, {'id': 'anl4_afv4_cfps_number', 'description': 'Cash Flow Per Share - number of estimations for annual frequency'}, {'id': 'anl4_afv4_cfps_median', 'description': 'Cash Flow Per Share - Median value among forecasts for the annual frequency'}, {'id': 'anl4_afv4_cfps_mean', 'description': 'Cash Flow Per Share - average of estimations for the annual frequency'}, {'id': 'anl4_afv4_cfps_low', 'description': 'Cash Flow Per Share - The lowest estimation for the upcoming fiscal year'}, {'id': 'anl4_afv4_cfps_high', 'description': 'Cash Flow Per Share - The highest estimation for the annual forecast'}, {'id': 'anl4_afv4_actual', 'description': 'Announced financial data'}, {'id': 'anl4_af_eps_value', 'description': 'Earnings Per Share - Actual Value'}, {'id': 'anl4_af_div_value', 'description': 'Dividend - Actual value'}, {'id': 'anl4_af_cfps_value', 'description': 'Cash Flow Per Share - Actual Value'}, {'id': 'anl4_ady_pu', 'description': 'The number of upper estimations'}, {'id': 'anl4_ady_numest', 'description': 'The number of forecasts counted in aggregation'}, {'id': 'anl4_ady_median', 'description': 'Median of estimations'}, {'id': 'anl4_ady_mean', 'description': 'Mean of estimations'}, {'id': 'anl4_ady_low', 'description': 'The lowest estimation'}, {'id': 'anl4_ady_high', 'description': 'The highest estimation'}, {'id': 'anl4_ady_down', 'description': 'Number of lower estimations'}, {'id': 'anl4_adxqfv110_pu', 'description': 'The number of upper estimations'}, {'id': 'anl4_adxqfv110_numest', 'description': 'The number of forecasts counted in aggregation'}, {'id': 'anl4_adxqfv110_median', 'description': 'Median of estimations'}, {'id': 'anl4_adxqfv110_mean', 'description': 'Mean of estimations'}, {'id': 'anl4_adxqfv110_low', 'description': 'The lowest estimation'}, {'id': 'anl4_adxqfv110_high', 'description': 'The highest estimation'}, {'id': 'anl4_adxqfv110_down', 'description': 'Number of lower estimations'}, {'id': 'anl4_ads1detailqfv110_prevval', 'description': 'The previous estimation of financial item'}, {'id': 'anl4_ads1detailqfv110_person', 'description': 'Broker Id'}, {'id': 'anl4_ads1detailqfv110_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_ads1detailqfv110_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_ads1detailafv110_prevval', 'description': 'The Previous Estimation of Financial Item'}, {'id': 'anl4_ads1detailafv110_person', 'description': 'Broker Id'}, {'id': 'anl4_ads1detailafv110_estvalue', 'description': 'Estimation value'}, {'id': 'anl4_ads1detailafv110_bk', 'description': 'Broker name (int)'}, {'id': 'anl4_adjusted_netincome_ft', 'description': 'Adjusted net income - forecast type (revision/new/...)'}, {'id': 'actuals_value_currency_code', 'description': 'Pricing Currency where the security trades'}, {'id': 'actuals_reporting_currency', 'description': 'Home currency of instrument'}, {'id': 'actual_sales_value_quarterly', 'description': 'Sales - Value in financial services income statement (in millions)'}, {'id': 'actual_sales_value_annual', 'description': 'Sales - Actual Value'}, {'id': 'actual_eps_value_quarterly', 'description': 'Earnings Per Share (Income Statement/Per Share) (Actual)'}, {'id': 'actual_dividend_value_quarterly', 'description': 'Dividend - Actual value for the quarter'}, {'id': 'actual_cashflow_per_share_value_quarterly', 'description': 'Cash Flow Per Share - actual value for the quarter'}] }

111 KiB Raw Permalink Blame History