← Home

Indicateurs cash drag et portefeuille

Source: crowddata-479915.crowddata_warehouse_poc.warehouse_transactions_poc (EU)
Reference: 06 déc. 2025
Compte: Tous
Interets: Interets bruts
Cumul jusqu'au 31 déc. 2025
La date sert de point de reference pour les sections ci-dessous (J-6 … J, premiers/derniers jours des 12 derniers mois). Colonnes: Cash drag, Portefeuille, Investi, les 3 variantes d'interets (brut/net/bonus) et le ratio Cash drag / Portefeuille.

7 derniers jours 06 déc. 2025

DateCash dragPortefeuilleInvestiInt. brutsInt. netsInt. bonusRatio CD/Port. (%)
30 nov. 2025 219,53 26 399,06 -26 179,52 3 739,38 3 739,38 3 739,38 0,83%
01 déc. 2025 1 068,77 26 406,17 -25 337,39 3 746,49 3 746,49 3 746,49 4,05%
02 déc. 2025 1 068,77 26 406,17 -25 337,39 3 746,49 3 746,49 3 746,49 4,05%
03 déc. 2025 1 068,77 26 406,17 -25 337,39 3 746,49 3 746,49 3 746,49 4,05%
04 déc. 2025 1 068,77 26 406,17 -25 337,39 3 746,49 3 746,49 3 746,49 4,05%
05 déc. 2025 1 068,77 26 406,17 -25 337,39 3 746,49 3 746,49 3 746,49 4,05%
06 déc. 2025 1 068,77 26 406,17 -25 337,39 3 746,49 3 746,49 3 746,49 4,05%

Premiers jours des 12 derniers mois

DateCash dragPortefeuilleInvestiInt. brutsInt. netsInt. bonusRatio CD/Port. (%)
01 déc. 2025 1 068,77 26 406,17 -25 337,39 3 746,49 3 746,49 3 746,49 4,05%
01 nov. 2025 175,87 26 267,45 -26 091,57 3 607,77 3 607,77 3 607,77 0,67%
01 oct. 2025 330,04 26 124,49 -25 794,44 3 464,81 3 464,81 3 464,81 1,26%
01 sept. 2025 188,20 25 990,67 -25 802,46 3 330,99 3 330,99 3 330,99 0,72%
01 août 2025 1 642,46 25 850,01 -24 207,54 3 190,33 3 190,33 3 190,33 6,35%
01 juil. 2025 470,25 24 209,03 -23 738,77 3 049,35 3 049,35 3 049,35 1,94%
01 juin 2025 1 167,84 22 100,16 -20 932,31 2 940,48 2 940,48 2 940,48 5,28%
01 mai 2025 1 028,95 19 997,90 -18 968,94 2 838,22 2 838,22 2 838,22 5,15%
01 avr. 2025 194,53 17 896,15 -17 701,61 2 736,47 2 736,47 2 736,47 1,09%
01 mars 2025 233,71 17 815,82 -17 582,10 2 656,14 2 656,14 2 656,14 1,31%
01 févr. 2025 167,91 17 705,27 -17 537,35 2 545,59 2 545,59 2 545,59 0,95%
01 janv. 2025 864,90 17 646,14 -16 781,23 2 486,46 2 486,46 2 486,46 4,90%

Derniers jours des 12 derniers mois

DateCash dragPortefeuilleInvestiInt. brutsInt. netsInt. bonusRatio CD/Port. (%)
31 déc. 2025 1 068,77 26 406,17 -25 337,39 3 746,49 3 746,49 3 746,49 4,05%
30 nov. 2025 219,53 26 399,06 -26 179,52 3 739,38 3 739,38 3 739,38 0,83%
31 oct. 2025 169,98 26 266,66 -26 096,67 3 606,98 3 606,98 3 606,98 0,65%
30 sept. 2025 160,98 26 116,00 -25 955,01 3 456,32 3 456,32 3 456,32 0,62%
31 août 2025 172,55 25 978,40 -25 805,84 3 318,72 3 318,72 3 318,72 0,66%
31 juil. 2025 1 634,54 25 842,09 -24 207,54 3 182,41 3 182,41 3 182,41 6,33%
30 juin 2025 1 075,70 24 203,72 -23 128,01 3 044,04 3 044,04 3 044,04 4,44%
31 mai 2025 1 167,84 22 100,16 -20 932,31 2 940,48 2 940,48 2 940,48 5,28%
30 avr. 2025 1 028,95 19 997,90 -18 968,94 2 838,22 2 838,22 2 838,22 5,15%
31 mars 2025 190,70 17 892,87 -17 702,16 2 733,19 2 733,19 2 733,19 1,07%
28 févr. 2025 233,71 17 815,82 -17 582,10 2 656,14 2 656,14 2 656,14 1,31%
31 janv. 2025 167,91 17 705,27 -17 537,35 2 545,59 2 545,59 2 545,59 0,95%
Debug 
{
  "account": "(all)",
  "reference_date": "2025-12-06",
  "sign_cases": {
    "cashdrag": "CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 1 WHEN 'FIAT_WITHDRAWAL' THEN -1 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN -1 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN -1 WHEN 'FIAT_DATA_RECOVERY' THEN 1 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 1 WHEN 'FIAT_CAPITAL_GAIN' THEN 1 WHEN 'FIAT_CAPITAL_LOSS' THEN -1 WHEN 'CRYPTO_DEPOSIT' THEN 1 WHEN 'CRYPTO_WITHDRAWAL' THEN -1 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 1 WHEN 'PRINCIPAL_REPAYMENT' THEN 1 WHEN 'INVESTMENT' THEN -1 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN -1 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 1 WHEN 'UNCATEGORIZED' THEN 1 ELSE 1 END",
    "portfolio": "CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 1 WHEN 'FIAT_WITHDRAWAL' THEN -1 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN -1 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN -1 WHEN 'FIAT_DATA_RECOVERY' THEN 1 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 1 WHEN 'FIAT_CAPITAL_GAIN' THEN 1 WHEN 'FIAT_CAPITAL_LOSS' THEN -1 WHEN 'CRYPTO_DEPOSIT' THEN 1 WHEN 'CRYPTO_WITHDRAWAL' THEN -1 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 0 WHEN 'PRINCIPAL_REPAYMENT' THEN 0 WHEN 'INVESTMENT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 0 WHEN 'UNCATEGORIZED' THEN 1 ELSE 0 END",
    "invested": "CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 0 WHEN 'FIAT_WITHDRAWAL' THEN 0 WHEN 'FIAT_INTEREST_PAYMENT' THEN 0 WHEN 'FIAT_FEES' THEN 0 WHEN 'FIAT_BONUSES' THEN 0 WHEN 'FIAT_TAXES' THEN 0 WHEN 'FIAT_DATA_RECOVERY' THEN 0 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 0 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 0 WHEN 'FIAT_PROFIT_SHARING' THEN 0 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 0 WHEN 'FIAT_CAPITAL_GAIN' THEN 1 WHEN 'FIAT_CAPITAL_LOSS' THEN -1 WHEN 'CRYPTO_DEPOSIT' THEN 0 WHEN 'CRYPTO_WITHDRAWAL' THEN 0 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 1 WHEN 'PRINCIPAL_REPAYMENT' THEN 1 WHEN 'INVESTMENT' THEN -1 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN -1 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 1 WHEN 'UNCATEGORIZED' THEN 0 ELSE 0 END",
    "interest_brut": "CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 0 WHEN 'FIAT_WITHDRAWAL' THEN 0 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN 0 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN 0 WHEN 'FIAT_DATA_RECOVERY' THEN 0 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 0 WHEN 'FIAT_CAPITAL_GAIN' THEN 0 WHEN 'FIAT_CAPITAL_LOSS' THEN 0 WHEN 'CRYPTO_DEPOSIT' THEN 0 WHEN 'CRYPTO_WITHDRAWAL' THEN 0 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 0 WHEN 'PRINCIPAL_REPAYMENT' THEN 0 WHEN 'INVESTMENT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 0 WHEN 'UNCATEGORIZED' THEN 0 ELSE 0 END",
    "interest_net": "CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 0 WHEN 'FIAT_WITHDRAWAL' THEN 0 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN 0 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN -1 WHEN 'FIAT_DATA_RECOVERY' THEN 0 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 0 WHEN 'FIAT_CAPITAL_GAIN' THEN 0 WHEN 'FIAT_CAPITAL_LOSS' THEN 0 WHEN 'CRYPTO_DEPOSIT' THEN 0 WHEN 'CRYPTO_WITHDRAWAL' THEN 0 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 0 WHEN 'PRINCIPAL_REPAYMENT' THEN 0 WHEN 'INVESTMENT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 0 WHEN 'UNCATEGORIZED' THEN 0 ELSE 0 END",
    "interest_bonus": "CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 0 WHEN 'FIAT_WITHDRAWAL' THEN 0 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN 0 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN 0 WHEN 'FIAT_DATA_RECOVERY' THEN 0 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 0 WHEN 'FIAT_CAPITAL_GAIN' THEN 0 WHEN 'FIAT_CAPITAL_LOSS' THEN 0 WHEN 'CRYPTO_DEPOSIT' THEN 0 WHEN 'CRYPTO_WITHDRAWAL' THEN 0 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 0 WHEN 'PRINCIPAL_REPAYMENT' THEN 0 WHEN 'INVESTMENT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 0 WHEN 'UNCATEGORIZED' THEN 0 ELSE 0 END"
  },
  "query": "\nSELECT DATE(date) AS d,\n       SUM(SAFE_CAST(amount_converted AS NUMERIC) * CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 1 WHEN 'FIAT_WITHDRAWAL' THEN -1 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN -1 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN -1 WHEN 'FIAT_DATA_RECOVERY' THEN 1 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 1 WHEN 'FIAT_CAPITAL_GAIN' THEN 1 WHEN 'FIAT_CAPITAL_LOSS' THEN -1 WHEN 'CRYPTO_DEPOSIT' THEN 1 WHEN 'CRYPTO_WITHDRAWAL' THEN -1 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 1 WHEN 'PRINCIPAL_REPAYMENT' THEN 1 WHEN 'INVESTMENT' THEN -1 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN -1 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 1 WHEN 'UNCATEGORIZED' THEN 1 ELSE 1 END) AS cashdrag,\n       SUM(SAFE_CAST(amount_converted AS NUMERIC) * CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 1 WHEN 'FIAT_WITHDRAWAL' THEN -1 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN -1 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN -1 WHEN 'FIAT_DATA_RECOVERY' THEN 1 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 1 WHEN 'FIAT_CAPITAL_GAIN' THEN 1 WHEN 'FIAT_CAPITAL_LOSS' THEN -1 WHEN 'CRYPTO_DEPOSIT' THEN 1 WHEN 'CRYPTO_WITHDRAWAL' THEN -1 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 0 WHEN 'PRINCIPAL_REPAYMENT' THEN 0 WHEN 'INVESTMENT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 0 WHEN 'UNCATEGORIZED' THEN 1 ELSE 0 END) AS portfolio,\n       SUM(SAFE_CAST(amount_converted AS NUMERIC) * CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 0 WHEN 'FIAT_WITHDRAWAL' THEN 0 WHEN 'FIAT_INTEREST_PAYMENT' THEN 0 WHEN 'FIAT_FEES' THEN 0 WHEN 'FIAT_BONUSES' THEN 0 WHEN 'FIAT_TAXES' THEN 0 WHEN 'FIAT_DATA_RECOVERY' THEN 0 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 0 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 0 WHEN 'FIAT_PROFIT_SHARING' THEN 0 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 0 WHEN 'FIAT_CAPITAL_GAIN' THEN 1 WHEN 'FIAT_CAPITAL_LOSS' THEN -1 WHEN 'CRYPTO_DEPOSIT' THEN 0 WHEN 'CRYPTO_WITHDRAWAL' THEN 0 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 1 WHEN 'PRINCIPAL_REPAYMENT' THEN 1 WHEN 'INVESTMENT' THEN -1 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN -1 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 1 WHEN 'UNCATEGORIZED' THEN 0 ELSE 0 END) AS invested,\n       SUM(SAFE_CAST(amount_converted AS NUMERIC) * CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 0 WHEN 'FIAT_WITHDRAWAL' THEN 0 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN 0 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN 0 WHEN 'FIAT_DATA_RECOVERY' THEN 0 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 0 WHEN 'FIAT_CAPITAL_GAIN' THEN 0 WHEN 'FIAT_CAPITAL_LOSS' THEN 0 WHEN 'CRYPTO_DEPOSIT' THEN 0 WHEN 'CRYPTO_WITHDRAWAL' THEN 0 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 0 WHEN 'PRINCIPAL_REPAYMENT' THEN 0 WHEN 'INVESTMENT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 0 WHEN 'UNCATEGORIZED' THEN 0 ELSE 0 END) AS interest_brut,\n       SUM(SAFE_CAST(amount_converted AS NUMERIC) * CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 0 WHEN 'FIAT_WITHDRAWAL' THEN 0 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN 0 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN -1 WHEN 'FIAT_DATA_RECOVERY' THEN 0 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 0 WHEN 'FIAT_CAPITAL_GAIN' THEN 0 WHEN 'FIAT_CAPITAL_LOSS' THEN 0 WHEN 'CRYPTO_DEPOSIT' THEN 0 WHEN 'CRYPTO_WITHDRAWAL' THEN 0 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 0 WHEN 'PRINCIPAL_REPAYMENT' THEN 0 WHEN 'INVESTMENT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 0 WHEN 'UNCATEGORIZED' THEN 0 ELSE 0 END) AS interest_net,\n       SUM(SAFE_CAST(amount_converted AS NUMERIC) * CASE TRIM(UPPER(type)) WHEN 'OPEN' THEN 0 WHEN 'CLOSE' THEN 0 WHEN 'FIAT_DEPOSIT' THEN 0 WHEN 'FIAT_WITHDRAWAL' THEN 0 WHEN 'FIAT_INTEREST_PAYMENT' THEN 1 WHEN 'FIAT_FEES' THEN 0 WHEN 'FIAT_BONUSES' THEN 1 WHEN 'FIAT_TAXES' THEN 0 WHEN 'FIAT_DATA_RECOVERY' THEN 0 WHEN 'FIAT_DIVIDENDE_PAYMENT' THEN 1 WHEN 'FIAT_INCENTIVE_PAYMENT' THEN 1 WHEN 'FIAT_PROFIT_SHARING' THEN 1 WHEN 'FIAT_TOP_UPS_RECEIVED' THEN 0 WHEN 'FIAT_CAPITAL_GAIN' THEN 0 WHEN 'FIAT_CAPITAL_LOSS' THEN 0 WHEN 'CRYPTO_DEPOSIT' THEN 0 WHEN 'CRYPTO_WITHDRAWAL' THEN 0 WHEN 'AGGREGATE_AMOUNT' THEN 0 WHEN 'PRINCIPAL_BUYBACK' THEN 0 WHEN 'PRINCIPAL_REPAYMENT' THEN 0 WHEN 'INVESTMENT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_BOUGHT' THEN 0 WHEN 'SECONDARY_MARKET_PRINCIPAL_SOLD' THEN 0 WHEN 'UNCATEGORIZED' THEN 0 ELSE 0 END) AS interest_bonus\nFROM `crowddata-479915.crowddata_warehouse_poc.warehouse_transactions_poc`\nWHERE date IS NOT NULL\n  AND amount_converted IS NOT NULL\n  AND DATE(date) <= DATE(\"2025-12-31\")\n  AND (@account = '' OR UPPER(TRIM(account)) = UPPER(@account))\nGROUP BY d\nORDER BY d",
  "params": {
    "account": "",
    "location": "EU"
  },
  "rows_raw_count": 325,
  "target_values": [
    [
      "2025-01-01",
      {
        "cashdrag": 864.8988630000009,
        "portfolio": 17646.139594000007,
        "invested": -16781.233347,
        "interest_brut": 2486.462209999998,
        "interest_net": 2486.462209999998,
        "interest_bonus": 2486.462209999998
      }
    ],
    [
      "2025-01-31",
      {
        "cashdrag": 167.90886300000025,
        "portfolio": 17705.269594000012,
        "invested": -17537.353346999997,
        "interest_brut": 2545.5922099999975,
        "interest_net": 2545.5922099999975,
        "interest_bonus": 2545.5922099999975
      }
    ],
    [
      "2025-02-01",
      {
        "cashdrag": 167.90886300000025,
        "portfolio": 17705.269594000012,
        "invested": -17537.353346999997,
        "interest_brut": 2545.5922099999975,
        "interest_net": 2545.5922099999975,
        "interest_bonus": 2545.5922099999975
      }
    ],
    [
      "2025-02-28",
      {
        "cashdrag": 233.70886299999998,
        "portfolio": 17815.819594000004,
        "invested": -17582.103346999993,
        "interest_brut": 2656.1422099999977,
        "interest_net": 2656.1422099999977,
        "interest_bonus": 2656.1422099999977
      }
    ],
    [
      "2025-03-01",
      {
        "cashdrag": 233.70886299999998,
        "portfolio": 17815.819594000004,
        "invested": -17582.103346999993,
        "interest_brut": 2656.1422099999977,
        "interest_net": 2656.1422099999977,
        "interest_bonus": 2656.1422099999977
      }
    ],
    [
      "2025-03-31",
      {
        "cashdrag": 190.69886299999993,
        "portfolio": 17892.869594,
        "invested": -17702.16334699999,
        "interest_brut": 2733.1922099999983,
        "interest_net": 2733.1922099999983,
        "interest_bonus": 2733.1922099999983
      }
    ],
    [
      "2025-04-01",
      {
        "cashdrag": 194.52886299999994,
        "portfolio": 17896.149594,
        "invested": -17701.61334699999,
        "interest_brut": 2736.4722099999985,
        "interest_net": 2736.4722099999985,
        "interest_bonus": 2736.4722099999985
      }
    ],
    [
      "2025-04-30",
      {
        "cashdrag": 1028.9488630000005,
        "portfolio": 19997.899594,
        "invested": -18968.943346999986,
        "interest_brut": 2838.222209999998,
        "interest_net": 2838.222209999998,
        "interest_bonus": 2838.222209999998
      }
    ],
    [
      "2025-05-01",
      {
        "cashdrag": 1028.9488630000005,
        "portfolio": 19997.899594,
        "invested": -18968.943346999986,
        "interest_brut": 2838.222209999998,
        "interest_net": 2838.222209999998,
        "interest_bonus": 2838.222209999998
      }
    ],
    [
      "2025-05-31",
      {
        "cashdrag": 1167.8388630000002,
        "portfolio": 22100.159594,
        "invested": -20932.31334699999,
        "interest_brut": 2940.482209999998,
        "interest_net": 2940.482209999998,
        "interest_bonus": 2940.482209999998
      }
    ],
    [
      "2025-06-01",
      {
        "cashdrag": 1167.8388630000002,
        "portfolio": 22100.159594,
        "invested": -20932.31334699999,
        "interest_brut": 2940.482209999998,
        "interest_net": 2940.482209999998,
        "interest_bonus": 2940.482209999998
      }
    ],
    [
      "2025-06-30",
      {
        "cashdrag": 1075.6988630000003,
        "portfolio": 24203.719594000006,
        "invested": -23128.013346999986,
        "interest_brut": 3044.0422099999982,
        "interest_net": 3044.0422099999982,
        "interest_bonus": 3044.0422099999982
      }
    ],
    [
      "2025-07-01",
      {
        "cashdrag": 470.24886300000026,
        "portfolio": 24209.029594000007,
        "invested": -23738.773346999984,
        "interest_brut": 3049.352209999998,
        "interest_net": 3049.352209999998,
        "interest_bonus": 3049.352209999998
      }
    ],
    [
      "2025-07-31",
      {
        "cashdrag": 1634.5388630000004,
        "portfolio": 25842.089594,
        "invested": -24207.54334699998,
        "interest_brut": 3182.4122099999977,
        "interest_net": 3182.4122099999977,
        "interest_bonus": 3182.4122099999977
      }
    ],
    [
      "2025-08-01",
      {
        "cashdrag": 1642.4588630000005,
        "portfolio": 25850.009594,
        "invested": -24207.54334699998,
        "interest_brut": 3190.3322099999978,
        "interest_net": 3190.3322099999978,
        "interest_bonus": 3190.3322099999978
      }
    ],
    [
      "2025-08-31",
      {
        "cashdrag": 172.5488630000008,
        "portfolio": 25978.399593999984,
        "invested": -25805.843346999976,
        "interest_brut": 3318.7222099999985,
        "interest_net": 3318.7222099999985,
        "interest_bonus": 3318.7222099999985
      }
    ],
    [
      "2025-09-01",
      {
        "cashdrag": 188.1988630000008,
        "portfolio": 25990.669593999984,
        "invested": -25802.463346999975,
        "interest_brut": 3330.9922099999985,
        "interest_net": 3330.9922099999985,
        "interest_bonus": 3330.9922099999985
      }
    ],
    [
      "2025-09-30",
      {
        "cashdrag": 160.9788630000007,
        "portfolio": 26115.999593999983,
        "invested": -25955.013346999975,
        "interest_brut": 3456.32221,
        "interest_net": 3456.32221,
        "interest_bonus": 3456.32221
      }
    ],
    [
      "2025-10-01",
      {
        "cashdrag": 330.0388630000007,
        "portfolio": 26124.489593999984,
        "invested": -25794.443346999975,
        "interest_brut": 3464.8122099999996,
        "interest_net": 3464.8122099999996,
        "interest_bonus": 3464.8122099999996
      }
    ],
    [
      "2025-10-31",
      {
        "cashdrag": 169.97886300000096,
        "portfolio": 26266.659593999986,
        "invested": -26096.673346999978,
        "interest_brut": 3606.98221,
        "interest_net": 3606.98221,
        "interest_bonus": 3606.98221
      }
    ]
  ],
  "max_date_param": "2025-12-31",
  "interest_variant": "interest_brut"
}