product_feature

Data license: CC-BY-4.0 · Data source: bankproducts.info

2 rows where product_id = "ce_nyon:titres"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id feature_key feature_value note source_page
ce_nyon:titres:pf:obligations_caisse_no_custody Compte Titres ce_nyon:titres pricing_condition Obligations de Caisse CEN and cédules hypothécaires: NO custody fees, NO brokerage Verbatim: "Aucun courtage ni droits de garde ne sont appliqués pour la gestion des obligations de caisse CEN et/ou de vos cédules hypothécaires". CEN waives both courtage AND droits de garde on its own bonds and on customers' mortgage documents (cédules hypothécaires). Strong incentive to hold CEN bonds and to manage CEN-financed mortgages through CEN custody. Common Swiss small-Sparkasse practice but explicitly published here.  
ce_nyon:titres:pf:titres_courtage_050_min_120_droits_garde_dual_015_15chf_pos_min_70 Compte Titres ce_nyon:titres pricing_condition CEN Titres Dual-Fee-Struktur: **Courtage 0.5% (min CHF 120) + Frais de bourse et timbre federal en sus**. **Droits de garde annuels: 0.15% de la valeur en depot + CHF 15/position (min CHF 70/annee)**. Novel: 2-Layer-Depot-Preisung (Prozent + Position-Fixgebuehr). Novel Cross-Bank-Muster: Depot-Preisung mit Position-Additiv. Cross-Bank-Vergleich: die meisten Banken haben nur Prozent-basierte Depot-Preisung (SGKB 0.15-0.25% Batch 33, Vontobel bis 0.35% Batch 27). CEN CHF 15/Position addiert Fix-Kosten fuer kleine Portfolio (100 Positionen = zusaetzlich CHF 1'500/Jahr). 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE product_feature (
    id          TEXT PRIMARY KEY,
    product_id  TEXT NOT NULL REFERENCES product(id),
    feature_key TEXT NOT NULL,          -- withdrawal_limit_free, notice_period, daily_limit, monthly_limit,
                                        -- interest_late_payment, max_balance, included_services, ...
    feature_value TEXT,
    note        TEXT,
    source_page INTEGER
);
CREATE INDEX idx_product_feature_product ON product_feature(product_id);
CREATE INDEX idx_product_feature_key ON product_feature(feature_key);