{
  "name": "Sharemaestro SVQF schema",
  "entities": {
    "SvqfRun": [
      {
        "name": "id",
        "type": "BigAutoField",
        "help_text": ""
      },
      {
        "name": "exchange",
        "type": "ForeignKey",
        "help_text": ""
      },
      {
        "name": "week_end_date",
        "type": "DateField",
        "help_text": ""
      },
      {
        "name": "ran_at",
        "type": "DateTimeField",
        "help_text": ""
      },
      {
        "name": "status",
        "type": "CharField",
        "help_text": ""
      },
      {
        "name": "w_ev_ebit",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "w_roc",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "w_fcfy",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "provider",
        "type": "CharField",
        "help_text": ""
      },
      {
        "name": "verbose",
        "type": "BooleanField",
        "help_text": ""
      },
      {
        "name": "stats",
        "type": "JSONField",
        "help_text": ""
      },
      {
        "name": "error_summary",
        "type": "TextField",
        "help_text": ""
      }
    ],
    "SvqfTickerSnapshot": [
      {
        "name": "id",
        "type": "BigAutoField",
        "help_text": ""
      },
      {
        "name": "run",
        "type": "ForeignKey",
        "help_text": ""
      },
      {
        "name": "ticker",
        "type": "ForeignKey",
        "help_text": ""
      },
      {
        "name": "market_cap",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "enterprise_value",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "ebit",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "free_cash_flow",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "acq_multiple",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "earnings_yield",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "roc",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "fcf_yield",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "cash_conversion",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "rank_acq",
        "type": "IntegerField",
        "help_text": ""
      },
      {
        "name": "rank_ey",
        "type": "IntegerField",
        "help_text": ""
      },
      {
        "name": "rank_roc",
        "type": "IntegerField",
        "help_text": ""
      },
      {
        "name": "rank_fcfy",
        "type": "IntegerField",
        "help_text": ""
      },
      {
        "name": "magic_formula_rank_sum",
        "type": "IntegerField",
        "help_text": ""
      },
      {
        "name": "composite_score",
        "type": "DecimalField",
        "help_text": ""
      },
      {
        "name": "ev_source",
        "type": "CharField",
        "help_text": ""
      },
      {
        "name": "ebit_source",
        "type": "CharField",
        "help_text": ""
      },
      {
        "name": "fcf_source",
        "type": "CharField",
        "help_text": ""
      },
      {
        "name": "created",
        "type": "DateTimeField",
        "help_text": ""
      }
    ]
  },
  "field_groups": {
    "identity": [
      "run_id",
      "week_end_date",
      "rank",
      "mode"
    ],
    "ticker": [
      "uuid",
      "symbol",
      "name",
      "exchange",
      "country",
      "currency",
      "sector",
      "industry"
    ],
    "fundamentals": [
      "market_cap",
      "enterprise_value",
      "ebit",
      "free_cash_flow"
    ],
    "ratios": [
      "acq_multiple",
      "earnings_yield",
      "roc",
      "fcf_yield",
      "cash_conversion"
    ],
    "ranks": [
      "rank_acq",
      "rank_ey",
      "rank_roc",
      "rank_fcfy",
      "magic_formula_rank_sum",
      "composite_score"
    ],
    "provenance": [
      "ev_source",
      "ebit_source",
      "fcf_source",
      "created"
    ]
  },
  "modes": {
    "composite": {
      "label": "Sharemaestro Composite",
      "description": "Balanced value plus quality ranking. Lower composite score is better.",
      "sort": [
        "composite_score",
        "magic_formula_rank_sum",
        "rank_acq",
        "ticker__symbol"
      ]
    },
    "magic": {
      "label": "SQF",
      "description": "Strong quality factor screen: EBIT/EV plus EBIT/(NWC + Net PPE). Lower rank sum is better.",
      "sort": [
        "magic_formula_rank_sum",
        "rank_ey",
        "rank_roc",
        "ticker__symbol"
      ]
    },
    "acq": {
      "label": "SVF",
      "description": "Strong value factor screen: EV/EBIT. Lower positive multiple ranks better.",
      "sort": [
        "rank_acq",
        "acq_multiple",
        "ticker__symbol"
      ]
    }
  },
  "filters": {
    "exchange": "Exchange symbol, e.g. NYSE, NASDAQ, LSE.",
    "mode": "composite, magic, or acq.",
    "sector": "Exact sector label.",
    "industry": "Exact industry label.",
    "q": "Ticker symbol or company name search.",
    "week_end": "YYYY-MM-DD completed SVQF run week.",
    "limit": "1-250 rows.",
    "offset": "Zero-based row offset."
  }
}