Global companies. Same schema.

from valuein_sdk import ValueinClient, ValueinError sql = """-- Foreign private issuers file 20-F; the full set is on Pro and Institutional.WITH annual AS (    -- Annual revenue from 20-F filings, latest-filed vintage per year.    -- fact has no form type: join filing on accession_id for it.    SELECT f.entity_id, f.period_end, f.numeric_value, f.reporting_currency    FROM fact f    JOIN filing fi ON fi.accession_id = f.accession_id    WHERE fi.form_type IN ('20-F', '20-F/A')      AND f.standard_concept = 'TotalRevenue'      AND f.fiscal_period = 'FY'    QUALIFY ROW_NUMBER() OVER (        PARTITION BY f.entity_id, f.period_end ORDER BY f.accepted_at DESC    ) = 1),growth AS (    SELECT *,        LAG(numeric_value, 2) OVER (PARTITION BY entity_id ORDER BY period_end) AS revenue_2y_ago    FROM annual    QUALIFY ROW_NUMBER() OVER (PARTITION BY entity_id ORDER BY period_end DESC) = 1)SELECT    r.symbol, r.name, r.sector, r.exchange,    g.period_end,    g.reporting_currency,                          -- values are in this currency    ROUND(g.numeric_value / 1e9, 2)                AS revenue_b,    ROUND(POWER(g.numeric_value / NULLIF(g.revenue_2y_ago, 0), 0.5) - 1, 3) AS cagr_2yrFROM growth gJOIN "references" r ON r.cik = g.entity_id AND r.is_active AND r.is_primary_tickerORDER BY cagr_2yr DESC NULLS LASTLIMIT 30""" try:    with ValueinClient() as client:        df = client.run_query(sql)        print(df)except ValueinError as e:    print(f"Valuein error: {e}")

from valuein_sdk import ValueinClient, ValueinError sql = """-- Foreign private issuers file 20-F; the full set is on Pro and Institutional.WITH latest AS (    -- Latest annual gross profit and revenue, tagged with the form they came from.    SELECT f.entity_id, f.standard_concept, f.numeric_value, fi.form_type    FROM fact f    JOIN filing fi ON fi.accession_id = f.accession_id    WHERE fi.form_type IN ('10-K', '20-F')      AND f.fiscal_period = 'FY'      AND f.standard_concept IN ('GrossProfit', 'TotalRevenue')    QUALIFY ROW_NUMBER() OVER (        PARTITION BY f.entity_id, f.standard_concept        ORDER BY f.period_end DESC, f.accepted_at DESC    ) = 1),margins AS (    SELECT        entity_id,        CASE WHEN MAX(form_type) = '20-F' THEN 'Foreign private issuer (20-F)'             ELSE 'US domestic (10-K)' END AS listing_type,        MAX(CASE WHEN standard_concept = 'GrossProfit'  THEN numeric_value END)          / NULLIF(MAX(CASE WHEN standard_concept = 'TotalRevenue' THEN numeric_value END), 0) AS gross_margin    FROM latest    GROUP BY entity_id)SELECT    g.listing_type,    COUNT(*)                                AS companies,    ROUND(AVG(g.gross_margin) * 100, 1)     AS avg_gross_margin_pct,    ROUND(MEDIAN(g.gross_margin) * 100, 1)  AS median_gross_margin_pctFROM margins gJOIN "references" r ON r.cik = g.entity_id AND r.is_active AND r.is_primary_tickerWHERE r.sector = 'Information Technology'  AND g.gross_margin BETWEEN 0 AND 1GROUP BY g.listing_type""" try:    with ValueinClient() as client:        df = client.run_query(sql)        print(df)except ValueinError as e:    print(f"Valuein error: {e}")

from valuein_sdk import ValueinClient, ValueinError sql = """-- Foreign private issuers file 20-F; the full set is on Pro and Institutional.WITH annual AS (    SELECT f.entity_id, f.period_end, f.standard_concept, f.numeric_value, f.reporting_currency    FROM fact f    JOIN filing fi ON fi.accession_id = f.accession_id    WHERE fi.form_type IN ('20-F', '20-F/A')      AND f.fiscal_period = 'FY'      AND f.standard_concept IN ('OperatingCashFlow', 'CAPEX', 'NetIncome')    QUALIFY ROW_NUMBER() OVER (        PARTITION BY f.entity_id, f.standard_concept, f.period_end ORDER BY f.accepted_at DESC    ) = 1),latest AS (    SELECT        entity_id,        period_end,        ANY_VALUE(reporting_currency)                                                AS currency,        MAX(CASE WHEN standard_concept = 'OperatingCashFlow' THEN numeric_value END) AS ocf,        MAX(CASE WHEN standard_concept = 'CAPEX'             THEN numeric_value END) AS capex,        MAX(CASE WHEN standard_concept = 'NetIncome'         THEN numeric_value END) AS net_income    FROM annual    GROUP BY entity_id, period_end    HAVING ocf IS NOT NULL AND capex IS NOT NULL    QUALIFY ROW_NUMBER() OVER (PARTITION BY entity_id ORDER BY period_end DESC) = 1)SELECT    r.symbol, r.name, r.sector, r.exchange,    l.period_end,    l.currency,                                              -- values are in this currency    ROUND(l.ocf / 1e9, 2)                                    AS cfo_b,    ROUND(ABS(l.capex) / 1e9, 2)                             AS capex_b,    ROUND((l.ocf - ABS(l.capex)) / 1e9, 2)                   AS fcf_b,    ROUND(l.net_income / 1e9, 2)                             AS net_income_b,    ROUND((l.ocf - ABS(l.capex)) / NULLIF(l.net_income, 0), 2) AS fcf_conversionFROM latest lJOIN "references" r ON r.cik = l.entity_id AND r.is_active AND r.is_primary_tickerORDER BY fcf_conversion DESC NULLS LASTLIMIT 20""" try:    with ValueinClient() as client:        df = client.run_query(sql)        print(df)except ValueinError as e:    print(f"Valuein error: {e}")

from valuein_sdk import ValueinClient, ValueinError sql = """-- Foreign private issuers file 20-F; the full set is on Pro and Institutional.-- Amounts are in each filer's reporting currency (reporting_currency on fact).WITH latest AS (    SELECT f.entity_id, f.standard_concept, f.numeric_value, fi.form_type    FROM fact f    JOIN filing fi ON fi.accession_id = f.accession_id    WHERE fi.form_type IN ('10-K', '20-F')      AND f.fiscal_period = 'FY'      AND f.standard_concept IN ('LongTermDebt', 'StockholdersEquity', 'TotalAssets')    QUALIFY ROW_NUMBER() OVER (        PARTITION BY f.entity_id, f.standard_concept        ORDER BY f.period_end DESC, f.accepted_at DESC    ) = 1),leverage AS (    SELECT        entity_id,        CASE WHEN MAX(form_type) = '20-F' THEN 'International' ELSE 'US' END AS universe,        MAX(CASE WHEN standard_concept = 'LongTermDebt'       THEN numeric_value END) AS long_term_debt,        MAX(CASE WHEN standard_concept = 'StockholdersEquity' THEN numeric_value END) AS equity,        MAX(CASE WHEN standard_concept = 'TotalAssets'        THEN numeric_value END) AS total_assets    FROM latest    GROUP BY entity_id)SELECT    r.symbol, r.name, r.exchange,    l.universe,    ROUND(l.long_term_debt / NULLIF(l.equity, 0), 2) AS debt_to_equity,    ROUND(l.long_term_debt / 1e9, 2)                 AS long_term_debt_b,    ROUND(l.total_assets / 1e9, 1)                   AS total_assets_bFROM leverage lJOIN "references" r ON r.cik = l.entity_id AND r.is_active AND r.is_primary_tickerWHERE r.sector = 'Industrials'  AND l.total_assets > 5e9ORDER BY debt_to_equity ASC NULLS LAST""" try:    with ValueinClient() as client:        df = client.run_query(sql)    print(df.groupby("universe")["debt_to_equity"].describe())except ValueinError as e:    print(f"Valuein error: {e}")