# audit_log

audit_id: 8af1eb3a-fc0a-4e35-9393-2aac1208bf15
timestamp: 2026-05-16T21:04:03.282882+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1312063c3c8f308163e6e6ba
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:04:03.282882+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:04:03.282882+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_1312063c3c8f308163e6e6ba", "country": "Depositary Receipt", "created_at": "2026-05-16T11:19:38.836191+00:00", "exchange": "HX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T20:09:52.000768+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "HX", "provider_symbol": "BBG012313950", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T20:09:52.000768+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "HX", "isin": null, "provider": "openfigi", "provider_symbol": "BBG012313950", "ticker": "GOOG"}


audit_id: 68abc9d3-a2b5-43c1-bf77-e9f41f32a31e
timestamp: 2026-05-16T21:04:03.293133+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_55995eb991ae96eafffb2af2
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:04:03.293133+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:04:03.293133+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_55995eb991ae96eafffb2af2", "country": "Common Stock", "created_at": "2026-05-16T11:19:38.844962+00:00", "exchange": "UW", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T20:09:52.029248+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "UW", "provider_symbol": "BBG009S3NB30", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T20:09:52.029248+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "UW", "isin": null, "provider": "openfigi", "provider_symbol": "BBG009S3NB30", "ticker": "GOOG"}


audit_id: 4aeec2bd-4109-43de-aa6d-d63b1d3ef772
timestamp: 2026-05-16T21:04:03.304864+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_c4dc44dd56065ca7ab6fe628
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:04:03.304864+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:04:03.304864+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_c4dc44dd56065ca7ab6fe628", "country": "Common Stock", "created_at": "2026-05-16T11:19:38.866693+00:00", "exchange": "VF", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T20:09:52.055263+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "VF", "provider_symbol": "BBG009S3NB30", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T20:09:52.055263+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "VF", "isin": null, "provider": "openfigi", "provider_symbol": "BBG009S3NB30", "ticker": "GOOG"}


audit_id: 8ef00d28-92ab-4c25-b056-7220fd20a4b3
timestamp: 2026-05-16T21:04:03.313491+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_8032214d61d964b08854beaf
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:04:03.313491+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:04:03.313491+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_8032214d61d964b08854beaf", "country": "Depositary Receipt", "created_at": "2026-05-16T11:19:38.875525+00:00", "exchange": "CJ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T20:09:52.080554+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "CJ", "provider_symbol": "BBG012313950", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T20:09:52.080554+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "CJ", "isin": null, "provider": "openfigi", "provider_symbol": "BBG012313950", "ticker": "GOOG"}


audit_id: 0c6d9037-6928-4064-8c59-a2e8651a425a
timestamp: 2026-05-16T21:04:03.321688+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ee9f6fa24fb7c0a07a167b47
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:04:03.321688+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:04:03.321688+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_ee9f6fa24fb7c0a07a167b47", "country": "Common Stock", "created_at": "2026-05-16T11:19:38.883874+00:00", "exchange": "UN", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T20:09:52.111254+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "UN", "provider_symbol": "BBG009S3NB30", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T20:09:52.111254+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "UN", "isin": null, "provider": "openfigi", "provider_symbol": "BBG009S3NB30", "ticker": "GOOG"}


audit_id: 05bfd07c-25bb-4ed0-b2b4-5e4d279c164d
timestamp: 2026-05-16T21:04:03.332638+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1e6ed42fbdbffe1640a342c8
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:04:03.332638+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:04:03.332638+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_1e6ed42fbdbffe1640a342c8", "country": "Depositary Receipt", "created_at": "2026-05-16T11:19:38.897031+00:00", "exchange": "TR", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T20:09:52.136480+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "TR", "provider_symbol": "BBG012313950", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T20:09:52.136480+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "TR", "isin": null, "provider": "openfigi", "provider_symbol": "BBG012313950", "ticker": "GOOG"}


audit_id: 06e44c08-5407-4c7d-b295-a9a6576b439d
timestamp: 2026-05-16T21:04:03.341348+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_214219f8bf1184f2addadb5d
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:04:03.341348+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:04:03.341348+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_214219f8bf1184f2addadb5d", "country": "Common Stock", "created_at": "2026-05-16T11:19:38.907964+00:00", "exchange": "VK", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T20:09:52.162272+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "VK", "provider_symbol": "BBG009S3NB30", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T20:09:52.162272+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "VK", "isin": null, "provider": "openfigi", "provider_symbol": "BBG009S3NB30", "ticker": "GOOG"}


audit_id: 49bf37c7-1f16-42bf-9177-3122eebfbe1b
timestamp: 2026-05-16T21:04:04.755682+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_2200729c76252032015fc3e7
user_text_note: Cache explicit instrument search result from massive
confirmation_timestamp: 2026-05-16T21:04:04.755682+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:04:04.755682+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_2200729c76252032015fc3e7", "country": "US", "created_at": "2026-05-16T11:19:56.782813+00:00", "exchange": "XNAS", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T20:09:53.218463+00:00", "name": "Alphabet Inc. Class C Capital Stock", "normalized_name": "alphabet inc class c capital stock", "notes": "Massive reference ticker result; US-focused fallback; manual selection required", "provider": "massive", "provider_market": "XNAS", "provider_symbol": "GOOG", "sector": null, "source": "massive", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "USD", "updated_at": "2026-05-16T20:09:53.218463+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "XNAS", "isin": null, "provider": "massive", "provider_symbol": "GOOG", "ticker": "GOOG"}


audit_id: a44376d4-fe1d-4694-bae4-49d93c6f48d8
timestamp: 2026-05-16T21:05:42.356278+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_da05f9a2a0e658c5b06e84ae
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.356278+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.356278+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_da05f9a2a0e658c5b06e84ae", "country": "US", "created_at": "2026-05-16T11:19:51.265544+00:00", "exchange": "NASDAQ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US02079K1079", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.690433+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NASDAQ", "provider_symbol": "GOOG", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "USD", "updated_at": "2026-05-16T21:03:57.690433+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 134 characters]


audit_id: ee359009-e844-4144-af04-3d941f82c3a2
timestamp: 2026-05-16T21:05:42.381232+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_bd7843bbf81591282eab948f
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.381232+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.381232+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_bd7843bbf81591282eab948f", "country": "US", "created_at": "2026-05-16T11:19:51.285281+00:00", "exchange": "NASDAQ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US02079K3059", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.714541+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NASDAQ", "provider_symbol": "GOOGL", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GOOGL", "trading_currency": "USD", "updated_at": "2026-05-16T21:03:57.714541+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 136 characters]


audit_id: 0effa820-a4c7-4555-a16a-9b5413b5ed77
timestamp: 2026-05-16T21:05:42.394563+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_9318e0f3c369a4a31b858108
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.394563+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.394563+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_9318e0f3c369a4a31b858108", "country": "IE", "created_at": "2026-05-16T11:19:51.294298+00:00", "exchange": "LSE", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "GBP", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "XS2337100163", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.729380+00:00", "name": "Leverage Shares - 1x Alphabet", "normalized_name": "leverage shares 1x alphabet", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "LSE", "provider_symbol": "GOOG.L", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "GBP", "updated_at": "2026-05-16T21:03:57.729380+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: 5b76a765-828b-4a96-bf32-9d47bf37cfc7
timestamp: 2026-05-16T21:05:42.406634+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b10d0498f30214c55b53ad08
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.406634+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.406634+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b10d0498f30214c55b53ad08", "country": "US", "created_at": "2026-05-16T11:19:51.303235+00:00", "exchange": "NEO", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "CAD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "CA02080K1049", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.740223+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NEO", "provider_symbol": "GOOG.NE", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "CAD", "updated_at": "2026-05-16T21:03:57.740223+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 134 characters]


audit_id: 41f0c658-d8dd-425c-923d-9f1bb60a3a5a
timestamp: 2026-05-16T21:05:42.415683+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_7f21132dc3b92911ef3dfd1c
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.415683+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.415683+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_7f21132dc3b92911ef3dfd1c", "country": "US", "created_at": "2026-05-16T11:19:51.312524+00:00", "exchange": "SIX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "CHF", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US02079K3059", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.750980+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "SIX", "provider_symbol": "GOOGL.SW", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GOOGL", "trading_currency": "CHF", "updated_at": "2026-05-16T21:03:57.750980+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 136 characters]


audit_id: 77a395b9-c72e-41d0-b4c6-82ae0b57d595
timestamp: 2026-05-16T21:05:42.424842+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_eb3a6f7bc4afd7bcec658ab6
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.424842+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.424842+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_eb3a6f7bc4afd7bcec658ab6", "country": "US", "created_at": "2026-05-16T11:19:51.322097+00:00", "exchange": "AMEX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US88634T7900", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.761376+00:00", "name": "YieldMax GOOGL Option Income Strategy ETF", "normalized_name": "yieldmax googl option income strategy etf", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "AMEX", "provider_symbol": "GOOY", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GOOY", "trading_currency": "USD", "updated_at": "2026-05-16T21:03:57.761376+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 132 characters]


audit_id: 4ea4195d-54b8-4f0e-83b3-2c9f7bd04fde
timestamp: 2026-05-16T21:05:42.435807+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b292a113f8d2e11c434ce0d5
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.435807+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.435807+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b292a113f8d2e11c434ce0d5", "country": "CA", "created_at": "2026-05-16T11:19:51.331149+00:00", "exchange": "NEO", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "CAD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "CA02080B1040", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.769221+00:00", "name": "Alphabet (GOOGL) Yield Shares Purpose ETF", "normalized_name": "alphabet googl yield shares purpose etf", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NEO", "provider_symbol": "YGOG.NE", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "YGOG", "trading_currency": "CAD", "updated_at": "2026-05-16T21:03:57.769221+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 134 characters]


audit_id: 25c63997-6244-4278-82e8-b12d8d4a935b
timestamp: 2026-05-16T21:05:42.444427+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1f7f4b826e43efe1ba6c88ea
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.444427+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.444427+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_1f7f4b826e43efe1ba6c88ea", "country": "US", "created_at": "2026-05-16T11:19:51.339978+00:00", "exchange": "NASDAQ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US25461A6010", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.777240+00:00", "name": "Direxion Daily GOOGL Bear 1X ETF", "normalized_name": "direxion daily googl bear 1x etf", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NASDAQ", "provider_symbol": "GGLS", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GGLS", "trading_currency": "USD", "updated_at": "2026-05-16T21:03:57.777240+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 134 characters]


audit_id: 5aa4f9f6-0436-4b3d-b2b2-94b3d2117d94
timestamp: 2026-05-16T21:05:42.453152+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_f69a0f8a2a30d0df4a0df06c
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.453152+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.453152+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_f69a0f8a2a30d0df4a0df06c", "country": "US", "created_at": "2026-05-16T11:19:51.351085+00:00", "exchange": "NASDAQ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US25461A8412", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.787849+00:00", "name": "Direxion Daily GOOGL Bull 2X ETF", "normalized_name": "direxion daily googl bull 2x etf", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NASDAQ", "provider_symbol": "GGLL", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GGLL", "trading_currency": "USD", "updated_at": "2026-05-16T21:03:57.787849+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 134 characters]


audit_id: 0a7f6837-c6e3-4781-8141-795dc8aa47ee
timestamp: 2026-05-16T21:05:42.464365+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_9360a62a59c4b4628409d28a
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.464365+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.464365+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_9360a62a59c4b4628409d28a", "country": "US", "created_at": "2026-05-16T11:19:51.360023+00:00", "exchange": "NASDAQ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US38747R1326", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.795676+00:00", "name": "GraniteShares 2x Long GOOG Daily ETF", "normalized_name": "graniteshares 2x long goog daily etf", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NASDAQ", "provider_symbol": "GOU", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GOU", "trading_currency": "USD", "updated_at": "2026-05-16T21:03:57.795676+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 132 characters]


audit_id: 12e2d816-2d50-4ba1-a388-a8a721949693
timestamp: 2026-05-16T21:05:42.475994+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_940ecb21edc1f107f6368a0e
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.475994+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.475994+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_940ecb21edc1f107f6368a0e", "country": "US", "created_at": "2026-05-16T11:19:51.369086+00:00", "exchange": "CBOE", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US77926X7599", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.804393+00:00", "name": "Roundhill Investments - GOOGL WeeklyPay ETF", "normalized_name": "roundhill investments googl weeklypay etf", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "CBOE", "provider_symbol": "GOOW", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GOOW", "trading_currency": "USD", "updated_at": "2026-05-16T21:03:57.804393+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 132 characters]


audit_id: 29912512-2e4b-49bc-aaa1-765bf5f51301
timestamp: 2026-05-16T21:05:42.484901+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_288d88358aea04fdeebcc5e5
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T21:05:42.484901+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:42.484901+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_288d88358aea04fdeebcc5e5", "country": "US", "created_at": "2026-05-16T11:19:51.380193+00:00", "exchange": "CBOE", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US5009486094", "issuer": null, "last_verified_at": "2026-05-16T21:03:57.814292+00:00", "name": "Kurv Yield Premium Strategy Google (GOOGL) ETF", "normalized_name": "kurv yield premium strategy google googl etf", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "CBOE", "provider_symbol": "GOOP", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "GOOP", "trading_currency": "USD", "updated_at": "2026-05-16T21:03:57.814292+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 132 characters]


audit_id: 8cd0253e-64fb-432c-babb-27f2f786955c
timestamp: 2026-05-16T21:05:51.595479+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_84d6e82f3facec952b717867
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T21:05:51.595479+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.595479+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_84d6e82f3facec952b717867", "country": "US", "created_at": "2026-05-16T11:19:55.483498+00:00", "exchange": "NASDAQ NMS - GLOBAL MARKET", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:01.769349+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": "NASDAQ NMS - GLOBAL MARKET", "provider_symbol": "GOOG", "sector": null, "source": "finnhub", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "USD", "updated_at": "2026-05-16T21:04:01.769349+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 148 characters]


audit_id: e14acf21-f1bc-4b3a-9d5c-514f703549a4
timestamp: 2026-05-16T21:05:51.610031+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b97f13a764002c6e6dcc34d2
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T21:05:51.610031+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.610031+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b97f13a764002c6e6dcc34d2", "country": null, "created_at": "2026-05-16T11:19:55.512584+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:01.788253+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "GOOG.TO", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:01.788253+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 127 characters]


audit_id: 9313bf7c-d7dc-4c85-955d-64dc14816197
timestamp: 2026-05-16T21:05:51.621594+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_0a160775017772328fe5522b
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T21:05:51.621594+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.621594+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_0a160775017772328fe5522b", "country": null, "created_at": "2026-05-16T11:19:55.527313+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:01.800044+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "GOOG.NE", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:01.800044+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 127 characters]


audit_id: a62aacb0-3965-427d-ad2e-038cb2d3de41
timestamp: 2026-05-16T21:05:51.634058+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1e58634b6647b0e9b4ef1122
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T21:05:51.634058+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.634058+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_1e58634b6647b0e9b4ef1122", "country": null, "created_at": "2026-05-16T11:19:55.542045+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:01.809041+00:00", "name": "LS 1X GOOG", "normalized_name": "ls 1x goog", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "GOOG.L", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:01.809041+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 126 characters]


audit_id: c4b7e6ab-8dbf-41f2-a041-a6845f634cdc
timestamp: 2026-05-16T21:05:51.643250+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_e1ac6f83305139d0a46188e1
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T21:05:51.643250+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.643250+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_e1ac6f83305139d0a46188e1", "country": null, "created_at": "2026-05-16T11:19:55.554402+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:01.817654+00:00", "name": "LS 1X GOOG", "normalized_name": "ls 1x goog", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "GOOG.AS", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:01.817654+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 127 characters]


audit_id: 837ef199-994e-42ab-8a5b-551a3c4ce21f
timestamp: 2026-05-16T21:05:51.656738+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_16545992f43aadb6c632ba47
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T21:05:51.656738+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.656738+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_16545992f43aadb6c632ba47", "country": null, "created_at": "2026-05-16T11:19:55.566486+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:01.833740+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "GOOG.MX", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:01.833740+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 127 characters]


audit_id: 77265bc0-45b9-4f90-bc3a-5103bbeb80b1
timestamp: 2026-05-16T21:05:51.667650+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b96d6a52931418fdbddd7f5a
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T21:05:51.667650+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.667650+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b96d6a52931418fdbddd7f5a", "country": null, "created_at": "2026-05-16T11:19:55.591754+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:01.846584+00:00", "name": "Googol Technology Co Ltd", "normalized_name": "googol technology co ltd", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "301510.SZ", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "301510", "trading_currency": null, "updated_at": "2026-05-16T21:04:01.846584+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 131 characters]


audit_id: f7f9b630-93ac-4084-bd0e-82c06cc1c626
timestamp: 2026-05-16T21:05:51.676263+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_2c2ae24c52705ce5cf23fc62
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T21:05:51.676263+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.676263+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_2c2ae24c52705ce5cf23fc62", "country": null, "created_at": "2026-05-16T11:19:55.612221+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:01.859679+00:00", "name": "HuangShan Googe Co Ltd", "normalized_name": "huangshan googe co ltd", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "301581.SZ", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "301581", "trading_currency": null, "updated_at": "2026-05-16T21:04:01.859679+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 131 characters]


audit_id: 40536494-9e16-4b2a-a092-fd86957b11f0
timestamp: 2026-05-16T21:05:51.900932+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_87416c84cd3fa9d232f53263
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.900932+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.900932+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_87416c84cd3fa9d232f53263", "country": "UNITED STATES", "created_at": "2026-05-16T11:19:55.830926+00:00", "exchange": "NASDAQ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.076462+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "NASDAQ", "provider_symbol": "GOOG", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "USD", "updated_at": "2026-05-16T21:04:02.076462+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 131 characters]


audit_id: e7ac8d77-4d80-4c22-8dc6-445309f4b670
timestamp: 2026-05-16T21:05:51.923762+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_8451345bfee7c712834b2bd5
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.923762+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.923762+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_8451345bfee7c712834b2bd5", "country": "MEXICO", "created_at": "2026-05-16T11:19:55.858460+00:00", "exchange": "BMV", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "MXN", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.091081+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "BMV", "provider_symbol": "GOOG", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "MXN", "updated_at": "2026-05-16T21:04:02.091081+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 128 characters]


audit_id: dca85048-baad-4e60-9f67-65647d3134fa
timestamp: 2026-05-16T21:05:51.932645+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b0dcdda9dfea0e57ce5cf77d
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.932645+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.932645+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b0dcdda9dfea0e57ce5cf77d", "country": "CANADA", "created_at": "2026-05-16T11:19:55.887453+00:00", "exchange": "TSX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "CAD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.105194+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "TSX", "provider_symbol": "GOOG", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "CAD", "updated_at": "2026-05-16T21:04:02.105194+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 128 characters]


audit_id: a06aa95c-e1d6-4e30-a043-5466df0bb279
timestamp: 2026-05-16T21:05:51.941578+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_494afccbd80a49454bb20b74
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.941578+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.941578+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_494afccbd80a49454bb20b74", "country": "CANADA", "created_at": "2026-05-16T11:19:55.906977+00:00", "exchange": "NEO", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "CAD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.120274+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "NEO", "provider_symbol": "GOOG", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "CAD", "updated_at": "2026-05-16T21:04:02.120274+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 128 characters]


audit_id: 71f02a13-3b9d-4079-8bf3-d542de8427c3
timestamp: 2026-05-16T21:05:51.952761+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_de92c9f668bf3080f2cc87a9
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.952761+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.952761+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_de92c9f668bf3080f2cc87a9", "country": "PERU", "created_at": "2026-05-16T11:19:55.926099+00:00", "exchange": "BVL", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "PEN", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.129251+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "BVL", "provider_symbol": "GOOG", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "PEN", "updated_at": "2026-05-16T21:04:02.129251+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 128 characters]


audit_id: dde4d426-b4df-4ffc-bf35-6d8826ae2c4b
timestamp: 2026-05-16T21:05:51.961222+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_20140c794e3c38f3de01c426
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.961222+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.961222+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_20140c794e3c38f3de01c426", "country": "UNITED KINGDOM", "created_at": "2026-05-16T11:19:55.948002+00:00", "exchange": "LSE", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "GBP", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.138514+00:00", "name": "Leverage Shares 1x Alphabet Tracker ETP", "normalized_name": "leverage shares 1x alphabet tracker etp", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "LSE", "provider_symbol": "GOOG", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "GBP", "updated_at": "2026-05-16T21:04:02.138514+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 128 characters]


audit_id: b0a9ad1e-7e15-4de8-8700-684064a4a6d1
timestamp: 2026-05-16T21:05:51.970017+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_078839b269710739e37d9bb1
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.970017+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.970017+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_078839b269710739e37d9bb1", "country": "NETHERLANDS", "created_at": "2026-05-16T11:19:55.970003+00:00", "exchange": "EURONEXT", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.148547+00:00", "name": "Leverage Shares 1x Alphabet Tracker ETP", "normalized_name": "leverage shares 1x alphabet tracker etp", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "EURONEXT", "provider_symbol": "GOOG", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "EUR", "updated_at": "2026-05-16T21:04:02.148547+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: 761e81c7-9a5f-484d-94fd-0e9572200cf7
timestamp: 2026-05-16T21:05:51.980775+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_38ea896fed6f79d4fb471ef8
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.980775+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.980775+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_38ea896fed6f79d4fb471ef8", "country": "SWITZERLAND", "created_at": "2026-05-16T11:19:56.003915+00:00", "exchange": "SIX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "CHF", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.156379+00:00", "name": "GOOG", "normalized_name": "goog", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "SIX", "provider_symbol": "GOOG", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "CHF", "updated_at": "2026-05-16T21:04:02.156379+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 128 characters]


audit_id: 18b194d7-7265-4ffd-adc5-06076b9c60ca
timestamp: 2026-05-16T21:05:51.989223+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_5f610c758718f683a134ef51
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.989223+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.989223+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_5f610c758718f683a134ef51", "country": "CHILE", "created_at": "2026-05-16T11:19:55.985645+00:00", "exchange": "BVS", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.164501+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "BVS", "provider_symbol": "GOOG", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "USD", "updated_at": "2026-05-16T21:04:02.164501+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 128 characters]


audit_id: 3b06ccda-450e-493b-978e-b3b1525d0d7c
timestamp: 2026-05-16T21:05:51.997260+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b9f4a3404c1b5fca1cdd3fc7
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T21:05:51.997260+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:51.997260+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b9f4a3404c1b5fca1cdd3fc7", "country": "UNITED STATES", "created_at": "2026-05-16T11:19:56.021748+00:00", "exchange": "NASDAQ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:02.175341+00:00", "name": "Alphabet Inc.", "normalized_name": "alphabet inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "NASDAQ", "provider_symbol": "GOOGL", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "GOOGL", "trading_currency": "USD", "updated_at": "2026-05-16T21:04:02.175341+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: ad641b67-85e9-497e-92d3-56f08f5e56ce
timestamp: 2026-05-16T21:05:52.735216+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_92307d27f0412f2e79587805
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.735216+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.735216+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_92307d27f0412f2e79587805", "country": null, "created_at": "2026-05-16T11:19:38.805268+00:00", "exchange": "NA", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.229412+00:00", "name": "LS 1X GOOG", "normalized_name": "ls 1x goog", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "NA", "provider_symbol": "BBG0113JLLJ1", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.229412+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: 82606559-ceb1-438b-b2e0-ebc5d6b599c9
timestamp: 2026-05-16T21:05:52.759032+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_92a5a42eb05024ae064a90b3
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.759032+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.759032+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_92a5a42eb05024ae064a90b3", "country": null, "created_at": "2026-05-16T11:19:38.817864+00:00", "exchange": "TX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.252762+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "TX", "provider_symbol": "BBG012313950", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.252762+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: bae0f3d3-b498-4cd8-a726-3eead51ada04
timestamp: 2026-05-16T21:05:52.778433+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_6fdf31c2bcd50baebefc3f83
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.778433+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.778433+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_6fdf31c2bcd50baebefc3f83", "country": null, "created_at": "2026-05-16T11:19:38.826831+00:00", "exchange": "TG", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.269557+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "TG", "provider_symbol": "BBG012313950", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.269557+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: 45ae80a7-6096-4e1f-a846-3c1d801ececf
timestamp: 2026-05-16T21:05:52.796024+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1312063c3c8f308163e6e6ba
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.796024+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.796024+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_1312063c3c8f308163e6e6ba", "country": null, "created_at": "2026-05-16T11:19:38.836191+00:00", "exchange": "HX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.282502+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "HX", "provider_symbol": "BBG012313950", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.282502+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: 14c6dc24-ff08-4055-bb88-2a97bed19ab0
timestamp: 2026-05-16T21:05:52.810083+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_55995eb991ae96eafffb2af2
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.810083+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.810083+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_55995eb991ae96eafffb2af2", "country": null, "created_at": "2026-05-16T11:19:38.844962+00:00", "exchange": "UW", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.293042+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "UW", "provider_symbol": "BBG009S3NB30", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.293042+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: b929b0c4-06ed-4286-ad62-12af8f0dabcf
timestamp: 2026-05-16T21:05:52.823262+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_c4dc44dd56065ca7ab6fe628
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.823262+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.823262+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_c4dc44dd56065ca7ab6fe628", "country": null, "created_at": "2026-05-16T11:19:38.866693+00:00", "exchange": "VF", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.304783+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "VF", "provider_symbol": "BBG009S3NB30", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.304783+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: ea6ae68c-04ef-4374-90ec-08911e0347aa
timestamp: 2026-05-16T21:05:52.838736+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_8032214d61d964b08854beaf
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.838736+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.838736+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_8032214d61d964b08854beaf", "country": null, "created_at": "2026-05-16T11:19:38.875525+00:00", "exchange": "CJ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.313410+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "CJ", "provider_symbol": "BBG012313950", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.313410+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: 1f85213e-cbcb-42bf-8883-5323d0f80a46
timestamp: 2026-05-16T21:05:52.852219+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ee9f6fa24fb7c0a07a167b47
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.852219+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.852219+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_ee9f6fa24fb7c0a07a167b47", "country": null, "created_at": "2026-05-16T11:19:38.883874+00:00", "exchange": "UN", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.321607+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "UN", "provider_symbol": "BBG009S3NB30", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.321607+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: fabf9fb3-17af-4f79-a03e-207602e380f8
timestamp: 2026-05-16T21:05:52.868591+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1e6ed42fbdbffe1640a342c8
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.868591+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.868591+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_1e6ed42fbdbffe1640a342c8", "country": null, "created_at": "2026-05-16T11:19:38.897031+00:00", "exchange": "TR", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.332560+00:00", "name": "ALPHABET INC - CDR", "normalized_name": "alphabet inc cdr", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "TR", "provider_symbol": "BBG012313950", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.332560+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: 97394ddb-79dd-4a68-8f1e-42487460161e
timestamp: 2026-05-16T21:05:52.883537+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_214219f8bf1184f2addadb5d
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T21:05:52.883537+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:52.883537+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_214219f8bf1184f2addadb5d", "country": null, "created_at": "2026-05-16T11:19:38.907964+00:00", "exchange": "VK", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:03.341273+00:00", "name": "ALPHABET INC-CL C", "normalized_name": "alphabet inc cl c", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "VK", "provider_symbol": "BBG009S3NB30", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": null, "updated_at": "2026-05-16T21:04:03.341273+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 133 characters]


audit_id: e0b3a32f-7ad5-4d86-8c3b-9269db7cc569
timestamp: 2026-05-16T21:05:53.820473+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_2200729c76252032015fc3e7
user_text_note: Cache explicit instrument search result from massive
confirmation_timestamp: 2026-05-16T21:05:53.820473+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T21:05:53.820473+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_2200729c76252032015fc3e7", "country": "US", "created_at": "2026-05-16T11:19:56.782813+00:00", "exchange": "XNAS", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T21:04:04.755041+00:00", "name": "Alphabet Inc. Class C Capital Stock", "normalized_name": "alphabet inc class c capital stock", "notes": "Massive reference ticker result; US-focused fallback; manual selection required", "provider": "massive", "provider_market": "XNAS", "provider_symbol": "GOOG", "sector": null, "source": "massive", "source_confidence": "medium", "ticker": "GOOG", "trading_currency": "USD", "updated_at": "2026-05-16T21:04:04.755041+00:00", "valuation_policy": "live_price"}

new_values_json:
[cell repeats an earlier one in this file: 126 characters]


audit_id: audit_8efd756064d44a6e
timestamp: 2026-05-16T21:08:41Z
source: vue_dashboard
action: position_confirm
entity_type: position
entity_id: account_89dada5563cc9139ffb4bdf5:instrument_e4b577eae537db4525a86a91
user_text_note: Aktie hinzufügen
confirmation_timestamp: 2026-05-16T21:08:41Z
created_by: user
quality_status: cost_basis_missing;missing_fx
created_at: 2026-05-16T21:08:41Z
new_values_json:
  {"account_id": "account_89dada5563cc9139ffb4bdf5", "asset_class": "stock", "candidate_id": "catalog_da05f9a2a0e658c5b06e84ae", "confirm": true, "cost_basis_original": null, "currency": "USD", "instrument_id": null, "isin": "US02079K1079", "name": "Alphabet Inc.", "note": "Aktie hinzuf\u00fcgen", "preview_id": "preview_e649de88cad34f74", "quantity": "96", "ticker": "GOOG", "trade_date": "2026-05-16", "transaction_type": "Initial Snapshot"}


audit_id: 0d860824-6ecb-4c22-b37c-41e2db268cbc
timestamp: 2026-05-16T23:19:55.608336+00:00
source: vue_dashboard
action: create
entity_type: budget_category
entity_id: bcat_e57f849201df464f
old_values_json: {}
confirmation_timestamp: 2026-05-16T23:19:55.608336+00:00
created_by: user
quality_status: ok
created_at: 2026-05-16T23:19:55.608336+00:00
new_values_json:
  {"category_id": "bcat_e57f849201df464f", "category_type": "expense", "color": null, "icon": null, "name": "UAT12-20260516231955 Kategorie", "parent_category_id": null, "sort_order": 0}


audit_id: ae52f04c-45fc-409e-aa5a-be64e72e5309
timestamp: 2026-05-16T23:19:55.621770+00:00
source: vue_dashboard
action: create
entity_type: budget_category
entity_id: bcat_a8d427befb6c4ab6
old_values_json: {}
confirmation_timestamp: 2026-05-16T23:19:55.621770+00:00
created_by: user
quality_status: ok
created_at: 2026-05-16T23:19:55.621770+00:00
new_values_json:
  {"category_id": "bcat_a8d427befb6c4ab6", "category_type": "expense", "color": null, "icon": null, "name": "UAT12-20260516231955 Unterkategorie", "parent_category_id": "bcat_e57f849201df464f", "sort_order": 0}


audit_id: 36b85ca7-a620-4323-841c-3303b7108979
timestamp: 2026-05-16T23:19:55.645841+00:00
source: vue_dashboard
action: create
entity_type: budget_account
entity_id: bacc_a3d9455124a0482d
old_values_json: {}
confirmation_timestamp: 2026-05-16T23:19:55.645841+00:00
created_by: user
quality_status: ok
created_at: 2026-05-16T23:19:55.645841+00:00
new_values_json:
  {"account_type": "cash", "budget_account_id": "bacc_a3d9455124a0482d", "currency": "CHF", "linked_account_id": null, "name": "UAT12-20260516231955 Konto A", "notes": null}


audit_id: 2cc59d21-a2d1-4d5a-a47d-614cbcbbc9a6
timestamp: 2026-05-16T23:19:55.657360+00:00
source: vue_dashboard
action: create
entity_type: budget_account
entity_id: bacc_b4ea2b8189ae4654
old_values_json: {}
confirmation_timestamp: 2026-05-16T23:19:55.657360+00:00
created_by: user
quality_status: ok
created_at: 2026-05-16T23:19:55.657360+00:00
new_values_json:
  {"account_type": "cash", "budget_account_id": "bacc_b4ea2b8189ae4654", "currency": "CHF", "linked_account_id": null, "name": "UAT12-20260516231955 Konto B", "notes": null}


audit_id: e92b7eba-cfd5-4f1e-9c7b-5e0581c15d36
timestamp: 2026-05-16T23:19:55.670200+00:00
source: vue_dashboard
action: confirm
entity_type: budget_transaction
entity_id: btx_2a1079fbd8394843
old_values_json: {}
user_text_note: Runtime UAT synthetic
confirmation_timestamp: 2026-05-16T23:19:55.670200+00:00
created_by: user
quality_status: ok
created_at: 2026-05-16T23:19:55.670200+00:00
new_values_json:
  {"account_id": "bacc_a3d9455124a0482d", "amount_chf": "1.25", "amount_original": "1.25", "booking_date": null, "budget_transaction_id": "btx_2a1079fbd8394843", "category_id": "bcat_a8d427befb6c4ab6", "currency_original": "CHF", "description": "UAT12-20260516231955 Ausgabe", "fx_rate_to_chf": "1", "fx_status": "not_needed", "merchant_id": null, "notes": "Runtime UAT synthetic", "payee": null, "reversal_of_transaction_id": null, "source_type": "manual", "tag_names": ["UAT12-20260516231955 Tag"], "transaction_date": "2026-01-15", "transaction_type": "expense"}


audit_id: c46d2f8d-9cea-48a3-9d9f-f4258c27a092
timestamp: 2026-05-16T23:19:55.682257+00:00
source: vue_dashboard
action: confirm
entity_type: budget_transaction
entity_id: btx_e1f37a63c4934ee5
old_values_json: {}
user_text_note: Runtime UAT synthetic
confirmation_timestamp: 2026-05-16T23:19:55.682257+00:00
created_by: user
quality_status: ok
created_at: 2026-05-16T23:19:55.682257+00:00
new_values_json:
  {"account_id": "bacc_a3d9455124a0482d", "amount_chf": "2.1", "amount_original": "2.1", "booking_date": null, "budget_transaction_id": "btx_e1f37a63c4934ee5", "category_id": "bcat_e57f849201df464f", "currency_original": "CHF", "description": "UAT12-20260516231955 Einnahme", "fx_rate_to_chf": "1", "fx_status": "not_needed", "merchant_id": null, "notes": "Runtime UAT synthetic", "payee": null, "reversal_of_transaction_id": null, "source_type": "manual", "tag_names": ["UAT12-20260516231955 Tag"], "transaction_date": "2026-01-15", "transaction_type": "income"}


audit_id: 34f06d82-11a2-4bcf-b0cb-26b1b45c2a8c
timestamp: 2026-05-16T23:19:55.697826+00:00
source: vue_dashboard
action: confirm
entity_type: budget_transaction
entity_id: btx_111d241805244890
old_values_json: {}
user_text_note: Runtime UAT synthetic
confirmation_timestamp: 2026-05-16T23:19:55.697826+00:00
created_by: user
quality_status: ok
created_at: 2026-05-16T23:19:55.697826+00:00
new_values_json:
  {"account_id": "bacc_a3d9455124a0482d", "amount_chf": "1.25", "amount_original": "1.25", "booking_date": null, "budget_transaction_id": "btx_111d241805244890", "category_id": null, "currency_original": "CHF", "description": "UAT12-20260516231955 Transfer", "fx_rate_to_chf": "1", "fx_status": "not_needed", "merchant_id": null, "notes": "Runtime UAT synthetic", "payee": null, "reversal_of_transaction_id": null, "source_type": "manual", "tag_names": [], "transaction_date": "2026-01-15", "transaction_type": "transfer"}


audit_id: 0dd2eddf-34f7-481f-8671-805da52f32a9
timestamp: 2026-05-16T23:19:55.706362+00:00
source: vue_dashboard
action: confirm
entity_type: budget_transaction
entity_id: btx_e88f3ae2cef34d18
old_values_json: {}
user_text_note: Runtime UAT synthetic
confirmation_timestamp: 2026-05-16T23:19:55.706362+00:00
created_by: user
quality_status: ok
created_at: 2026-05-16T23:19:55.706362+00:00
new_values_json:
  {"account_id": "bacc_b4ea2b8189ae4654", "amount_chf": "1.25", "amount_original": "1.25", "booking_date": null, "budget_transaction_id": "btx_e88f3ae2cef34d18", "category_id": null, "currency_original": "CHF", "description": "UAT12-20260516231955 Transfer", "fx_rate_to_chf": "1", "fx_status": "not_needed", "merchant_id": null, "notes": "Runtime UAT synthetic", "payee": null, "reversal_of_transaction_id": null, "source_type": "manual", "tag_names": [], "transaction_date": "2026-01-15", "transaction_type": "transfer"}


audit_id: e617c447-7c67-4131-af8d-7430d5f34971
timestamp: 2026-05-16T23:19:55.714791+00:00
source: vue_dashboard
action: confirm
entity_type: budget_transfer
entity_id: btrf_87be1a7612564980
old_values_json: {}
confirmation_timestamp: 2026-05-16T23:19:55.714791+00:00
created_by: user
quality_status: ok
created_at: 2026-05-16T23:19:55.714791+00:00
new_values_json:
  {"amount_chf": "1.25", "amount_original": "1.25", "currency_original": "CHF", "description": "UAT12-20260516231955 Transfer", "from_account_id": "bacc_a3d9455124a0482d", "fx_rate_to_chf": "1", "fx_status": "not_needed", "notes": "Runtime UAT synthetic", "to_account_id": "bacc_b4ea2b8189ae4654", "transaction_date": "2026-01-15", "transfer_id": "btrf_87be1a7612564980"}


audit_id: a7b0fb05-368c-4604-829b-437cdb3c2ee4
timestamp: 2026-05-17T07:51:10.306362+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_bb7f17841aa74fa4
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:51:10.306362+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:51:10.306362+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_insurance", "is_fixed_cost": false, "monthly_amount_chf": "60.80833333333334", "name": "Autoversicherung Mazda", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 2a4a1d72-4d99-4081-81c0-c08c037a67c8
timestamp: 2026-05-17T07:51:41.585319+00:00
source: vue_dashboard
action: create
entity_type: budget_category
entity_id: bcat_38c8f7bf53964431
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:51:41.585319+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:51:41.585319+00:00
new_values_json:
  {"category_id": "bcat_38c8f7bf53964431", "category_type": "expense", "color": null, "icon": null, "name": "Leben", "parent_category_id": null, "sort_order": 0}


audit_id: 4e84ca40-974e-465c-a92f-f96ecc70c2bc
timestamp: 2026-05-17T07:51:52.134074+00:00
source: vue_dashboard
action: create
entity_type: budget_category
entity_id: bcat_3de6e8113d914f21
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:51:52.134074+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:51:52.134074+00:00
new_values_json:
  {"category_id": "bcat_3de6e8113d914f21", "category_type": "expense", "color": null, "icon": null, "name": "Sonstiges", "parent_category_id": null, "sort_order": 0}


audit_id: 5d82ecdb-da73-4890-b419-970269e53008
timestamp: 2026-05-17T07:52:32.480703+00:00
source: vue_dashboard
action: create
entity_type: budget_category
entity_id: bcat_b18ca54eb52041b0
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:52:32.480703+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:52:32.480703+00:00
new_values_json:
  {"category_id": "bcat_b18ca54eb52041b0", "category_type": "expense", "color": null, "icon": null, "name": "Versicherungen", "parent_category_id": null, "sort_order": 0}


audit_id: 00d3849b-91cb-4862-bda4-2a4d4c9a68c7
timestamp: 2026-05-17T07:53:14.017681+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_eae435c8666b4a81
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:53:14.017681+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:53:14.017681+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_b18ca54eb52041b0", "is_fixed_cost": false, "monthly_amount_chf": "24.333333333333332", "name": "MFZ Steuer Mazda", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: f47fc725-9310-4ade-9f99-066c7ca2a2c8
timestamp: 2026-05-17T07:53:33.271344+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_fb78bc2aa6504283
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:53:33.271344+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:53:33.271344+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "1298.75", "name": "Hypothek", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 52ed4cbd-626a-433b-a077-b29edfeb6395
timestamp: 2026-05-17T07:53:50.504458+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_b34436e1cff84201
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:53:50.504458+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:53:50.504458+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "275.0", "name": "Wasser / Strom /Gr\u00fcngutvignette", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 128dd749-9041-4d31-ba72-b2ada989a6f4
timestamp: 2026-05-17T07:54:05.925375+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_56fc0ada262a438d
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:54:05.925375+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:54:05.925375+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "12.97", "name": "Grundgeb\u00fchr Strom", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 3a6dd778-ee90-4b79-8ce1-3911d390f39f
timestamp: 2026-05-17T07:54:13.783918+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_0ace15b91502460d
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:54:13.783918+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:54:13.783918+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "58.0", "name": "Sunrise inkl. Handy Mel", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 3b5def3d-6885-40fe-ae7d-b9880ed0fe2a
timestamp: 2026-05-17T07:54:21.634294+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_cdf53665d0474ac0
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:54:21.634294+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:54:21.634294+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "27.916666666666668", "name": "SERAFE", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 814897b1-469f-498e-a18c-a460eeac1ecd
timestamp: 2026-05-17T07:54:34.885273+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_6b8d885b0647494c
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:54:34.885273+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:54:34.885273+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "204.66666666666666", "name": "Instrumentalunterricht Musikschule Windisch", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 06099ffa-96e6-4464-9a0f-e9af648eef8d
timestamp: 2026-05-17T07:55:25.041779+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_99c2752e356a493f
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:55:25.041779+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:55:25.041779+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "35.0", "name": "Friseur Marcel", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 68603232-f12f-4bc2-b5d0-bb7b1e7228a9
timestamp: 2026-05-17T07:56:26.925377+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_0732c05a39624654
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:56:26.925377+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:56:26.925377+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "4166.666666666667", "name": "Essen / Haushalt / Kleidung / Ausgang / Ausfl\u00fcge / Geschenke / FERIEN / Benzin", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 50bcc585-98d2-46b8-a4f6-ea24e7fdb1e2
timestamp: 2026-05-17T07:56:46.966233+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_b7c37b7afb214183
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:56:46.966233+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:56:46.966233+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "294.82916666666665", "name": "Autoservice + Pneuwechsel Mazda CX5", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 8e7429cd-e064-4085-a4e8-037d724fdec3
timestamp: 2026-05-17T07:56:48.268433+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_7a73a39cf25f46c3
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:56:48.268433+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:56:48.268433+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "416.6666666666667", "name": "Krankenkasse Franchise (Selbstbehalt)", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 0ecee300-8066-4a05-afa1-cb06112fd0b5
timestamp: 2026-05-17T07:56:55.449642+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_0b8aeeaba2324ebc
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:56:55.449642+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:56:55.449642+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "66.66666666666667", "name": "Zahnarzt", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 46cac166-943d-46c3-97a9-a73a19c86919
timestamp: 2026-05-17T07:56:58.273433+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_aad2321561674775
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:56:58.273433+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:56:58.273433+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "12.5", "name": "Tierarzt", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 682cd870-e6cd-4d38-96c6-e356cc513f44
timestamp: 2026-05-17T07:57:19.302489+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_25f6764c26a2402d
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:57:19.302489+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:57:19.302489+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "18.483333333333334", "name": "REGA / Paraplegiker / Spenden", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: cf1fd634-dc59-4fa6-a092-bd95c2313475
timestamp: 2026-05-17T07:57:37.804206+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_7018cd98726d44f6
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:57:37.804206+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:57:37.804206+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_38c8f7bf53964431", "is_fixed_cost": false, "monthly_amount_chf": "583.3333333333334", "name": "Spezielle einmalige Anschaffungen (Pneu, M\u00f6bel, Mathe-Nachhilfe, Pool, Sonnensegel, Reitlager, Eisenhorn, Dreame)", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 6794ab5f-18b8-4372-9c1f-603efb5f5281
timestamp: 2026-05-17T07:57:50.581323+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_75374bc757004eaf
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:57:50.581323+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:57:50.581323+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_3de6e8113d914f21", "is_fixed_cost": false, "monthly_amount_chf": "1153.55", "name": "Kantons- und Gemeindesteuer", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: fc131c43-9ba7-423c-accb-668fa7571220
timestamp: 2026-05-17T07:57:54.324602+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_81194fedcb454a75
old_values_json: {}
confirmation_timestamp: 2026-05-17T07:57:54.324602+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T07:57:54.324602+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_3de6e8113d914f21", "is_fixed_cost": false, "monthly_amount_chf": "131.41666666666666", "name": "Bundessteuer", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 5ab95c53-a23c-4b55-b76f-2c67e1f6d7b4
timestamp: 2026-05-17T08:01:09.547153+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_e724650e328b4c2c
old_values_json: {}
confirmation_timestamp: 2026-05-17T08:01:09.547153+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T08:01:09.547153+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_b18ca54eb52041b0", "is_fixed_cost": false, "monthly_amount_chf": "105.8", "name": "Hausrat, Privathaftpflicht und Rechtschutz", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 61182cfa-02d4-4d10-a097-2f9fa781610f
timestamp: 2026-05-17T08:01:10.998496+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_d6085df5a3fb4529
old_values_json: {}
confirmation_timestamp: 2026-05-17T08:01:10.998496+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T08:01:10.998496+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_b18ca54eb52041b0", "is_fixed_cost": false, "monthly_amount_chf": "49.11666666666667", "name": "AGV", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 521a93f9-fcfd-42f6-a009-dd83af3213db
timestamp: 2026-05-17T08:01:12.812184+00:00
source: vue_dashboard
action: create
entity_type: budget_plan_item
entity_id: bplan_e778a3af477f452a
old_values_json: {}
confirmation_timestamp: 2026-05-17T08:01:12.812184+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T08:01:12.812184+00:00
new_values_json:
  {"annual_amount_chf": null, "cadence": "monthly", "category_id": "bcat_b18ca54eb52041b0", "is_fixed_cost": false, "monthly_amount_chf": "200.0", "name": "Lebensversicherung Helvetia", "notes": "Budget Seed Review 2026", "plan_month": "2026-01", "source_type": "excel_seed_dry_run"}


audit_id: 54116623-c4df-4e40-bcd6-02495e670531
timestamp: 2026-05-17T08:06:14.216573+00:00
source: vue_dashboard
action: archive
entity_type: budget_category
entity_id: bcat_a8d427befb6c4ab6
new_values_json: {"is_active": 0}
confirmation_timestamp: 2026-05-17T08:06:14.216573+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T08:06:14.216573+00:00
old_values_json:
  {"category_id": "bcat_a8d427befb6c4ab6", "category_type": "expense", "color": null, "created_at": "2026-05-16T23:19:55Z", "icon": null, "is_active": 1, "name": "UAT12-20260516231955 Unterkategorie", "parent_category_id": "bcat_e57f849201df464f", "sort_order": 0, "updated_at": "2026-05-16T23:19:55Z"}


audit_id: 32b56d86-18f7-4448-8980-d184f683c622
timestamp: 2026-05-17T08:06:17.222947+00:00
source: vue_dashboard
action: archive
entity_type: budget_category
entity_id: bcat_e57f849201df464f
new_values_json: {"is_active": 0}
confirmation_timestamp: 2026-05-17T08:06:17.222947+00:00
created_by: user
quality_status: ok
created_at: 2026-05-17T08:06:17.222947+00:00
old_values_json:
  {"category_id": "bcat_e57f849201df464f", "category_type": "expense", "color": null, "created_at": "2026-05-16T23:19:55Z", "icon": null, "is_active": 1, "name": "UAT12-20260516231955 Kategorie", "parent_category_id": null, "sort_order": 0, "updated_at": "2026-05-16T23:19:55Z"}


# broker_import_dry_runs

dry_run_id: 465c61a7-855a-494c-bf1f-0d7eedda91b7
source_name: PostFinance
source_platform: PostFinance
source_file_label: [runtime-file-redacted]
source_file_type: docx
source_hash: 59ec092da349092c29187801b3b96d77e7685cf22ca667f56b5703fac3f73040
source_filename_hash: 59ec092da349092c29187801b3b96d77e7685cf22ca667f56b5703fac3f73040
snapshot_date_status: missing
detected_sections_json: ["table_1", "table_2", "table_3", "table_4", "table_5"]
field_coverage_json: {}
created_at: 2026-05-15T09:35:47.590490+00:00
notes: dry-run summary only; no productive ledger writes
quality_flags_json:
  {"cost_basis_uncertain": 33, "missing_isin": 33, "missing_ticker": 33, "needs_manual_review": 34, "snapshot_only": 34}

summary_json:
  {"blocked_positions": 33, "candidate_cash_rows": 1, "candidate_positions": 33, "mapped_positions": 0, "rows_total": 40, "source_file_type": "docx", "source_platform": "PostFinance"}


dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
source_name: True Wealth
source_platform: True Wealth
source_file_label: [runtime-file-redacted]
source_file_type: docx
source_hash: 6d55404a91397dc52b8162663c15de00172f9c806d3803db9114a3e970ec63a8
source_filename_hash: 6d55404a91397dc52b8162663c15de00172f9c806d3803db9114a3e970ec63a8
snapshot_date_status: missing
detected_sections_json: ["table_1"]
field_coverage_json: {}
created_at: 2026-05-15T09:35:47.610688+00:00
notes: dry-run summary only; no productive ledger writes
quality_flags_json:
  {"cost_basis_uncertain": 17, "missing_isin": 17, "missing_ticker": 17, "needs_manual_review": 18, "snapshot_only": 18}

summary_json:
  {"blocked_positions": 17, "candidate_cash_rows": 1, "candidate_positions": 17, "mapped_positions": 0, "rows_total": 19, "source_file_type": "docx", "source_platform": "True Wealth"}


dry_run_id: cc21d566-0eeb-4e1f-ab69-f9b99356073d
source_name: Raiffeisen
source_platform: Raiffeisen
source_file_label: [runtime-file-redacted]
source_file_type: xlsx
source_hash: 67e2f92384bf608c8e06772c90519fbfce8f8f58ed475d4cee5c87dd263d476f
source_filename_hash: 67e2f92384bf608c8e06772c90519fbfce8f8f58ed475d4cee5c87dd263d476f
snapshot_date_status: missing
detected_sections_json: ["sheet_1"]
field_coverage_json: {}
created_at: 2026-05-15T09:35:47.626152+00:00
notes: dry-run summary only; no productive ledger writes
quality_flags_json:
  {"aggregate_only": 4, "cash_snapshot_candidate": 3, "missing_instrument_details": 4, "needs_manual_review": 7}

summary_json:
  {"blocked_positions": 4, "candidate_cash_rows": 3, "candidate_positions": 4, "mapped_positions": 0, "rows_total": 8, "source_file_type": "xlsx", "source_platform": "Raiffeisen"}


# broker_import_execution_plans

execution_plan_id: plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686
dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
review_item_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
source_platform: True Wealth
target_account_id: true-wealth-review-brokerage
target_instrument_id: instrument-US9229087690
transaction_type: initial_position_snapshot
snapshot_date: 2026-05-14
payload_status: ready
payload_quality_flags_json: ["cost_basis_uncertain", "fx_missing"]
source_row_hash: d91dcdb723e0725fc4d721d2c3083d3609a33c1bd04c191d3d548fbfaa55d38a
execution_status: imported
transaction_id: tx-0870b5b9-0c4e-4ffb-94b5-4eef18009b99
created_at: 2026-05-15T10:20:15.960216+00:00
updated_at: 2026-05-15T10:21:23.938094+00:00
executed_at: 2026-05-15T10:21:23.938094+00:00
notes: B6b mini-import executed for exactly one reviewed payload.
planned_write_summary_json:
  {"account_id": "true-wealth-review-brokerage", "cost_basis_quality": "uncertain", "currency_original": "USD", "fx_rate_to_chf": null, "fx_status": "missing", "gross_amount_chf": "36482.67", "instrument_id": "instrument-US9229087690", "price_original": "364.71", "quantity": "128", "snapshot_date": "2026-05-14", "source_id": "9122f3c2-eb76-4f92-b95d-1f9c2a99f686", "source_row_ref": "table1:row14", "source_type": "broker_import_reviewed_snapshot", "trade_date": "2026-05-14", "transaction_type": "initial_position_snapshot"}


execution_plan_id: plan-1c6136ca-852d-4467-ae87-4924ea2bd305
dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
review_item_id: 1c6136ca-852d-4467-ae87-4924ea2bd305
source_platform: True Wealth
target_account_id: true-wealth-review-brokerage
target_instrument_id: instrument-US9220428588
transaction_type: initial_position_snapshot
snapshot_date: 2026-05-14
payload_status: ready
payload_quality_flags_json: ["cost_basis_uncertain", "fx_missing"]
source_row_hash: 69b0d49e21558dff03555e0dd70509e800f81507a014215c18722548f809b63b
execution_status: imported
transaction_id: tx-e13645cf-1681-4ac8-b57d-981aad88098c
created_at: 2026-05-15T10:20:15.960591+00:00
updated_at: 2026-05-15T10:48:28.447099+00:00
executed_at: 2026-05-15T10:48:28.447099+00:00
notes: B6c second controlled mini-import from reviewed True Wealth execution plan; no mass import.
planned_write_summary_json:
  {"account_id": "true-wealth-review-brokerage", "cost_basis_quality": "uncertain", "currency_original": "USD", "fx_rate_to_chf": null, "fx_status": "missing", "gross_amount_chf": "11476.56", "instrument_id": "instrument-US9220428588", "price_original": "59.94", "quantity": "245", "snapshot_date": "2026-05-14", "source_id": "1c6136ca-852d-4467-ae87-4924ea2bd305", "source_row_ref": "table1:row15", "source_type": "broker_import_reviewed_snapshot", "trade_date": "2026-05-14", "transaction_type": "initial_position_snapshot"}


execution_plan_id: plan-8cc9a511-e679-47ee-a57a-30fe53ea72a6
dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
review_item_id: 8cc9a511-e679-47ee-a57a-30fe53ea72a6
source_platform: True Wealth
target_account_id: true-wealth-review-brokerage
target_instrument_id: instrument-US92204A7028
transaction_type: initial_position_snapshot
snapshot_date: 2026-05-14
payload_status: ready
payload_quality_flags_json: ["cost_basis_uncertain", "fx_missing"]
source_row_hash: 4af3459e24c3edf73a406bad31c4ebe4ece6ca7dcefa8acb175c3d1798e49ca1
execution_status: imported
transaction_id: tx-aecd65d3-148f-4e45-9e19-d5c2d85e8133
created_at: 2026-05-15T10:20:15.960672+00:00
updated_at: 2026-05-15T10:58:02.510937+00:00
executed_at: 2026-05-15T10:58:02.510937+00:00
notes: B6d final controlled True Wealth mini-import from reviewed execution plan; no mass import.
planned_write_summary_json:
  {"account_id": "true-wealth-review-brokerage", "cost_basis_quality": "uncertain", "currency_original": "USD", "fx_rate_to_chf": null, "fx_status": "missing", "gross_amount_chf": "32095.35", "instrument_id": "instrument-US92204A7028", "price_original": "113.45", "quantity": "362", "snapshot_date": "2026-05-14", "source_id": "8cc9a511-e679-47ee-a57a-30fe53ea72a6", "source_row_ref": "table1:row17", "source_type": "broker_import_reviewed_snapshot", "trade_date": "2026-05-14", "transaction_type": "initial_position_snapshot"}


# instrument_price_mapping_candidates

candidate_id: ipmc_208b2282a32eef2a4890b7ab
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: openfigi
candidate_provider_symbol: VWO
candidate_exchange: US
candidate_currency: USD
candidate_name: VANGUARD FTSE EMERGING MARKE
candidate_instrument_status: unknown
confidence: high
evidence_source: openfigi_isin_mapping
evidence_note: ISIN match; currency match
review_status: selected
created_at: 2026-05-15T13:22:27.088798+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Name passt fuzzy; OpenFIGI ISIN-Datenquelle


candidate_id: ipmc_5edff637f58a03d45e2785e7
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: yahoo_fallback
candidate_provider_symbol: VWO
candidate_exchange: NYSEArca
candidate_currency: USD
candidate_name: Vanguard Emerging Markets Stock Index Fund
candidate_instrument_status: unknown
confidence: medium
evidence_source: yahoo_finance_search
evidence_note: ticker+exchange match; requires manual review
review_status: rejected
created_at: 2026-05-15T13:22:27.089261+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Name teilweise ähnlich; Yahoo Search Fallback


candidate_id: ipmc_7bfb02f1cc92277e6a744dc0
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: yahoo_fallback
candidate_provider_symbol: VEU.XA
candidate_exchange: CXA
candidate_currency: USD
candidate_name: VWORLDXUS CDI 1:1 [VEU]
candidate_instrument_status: unknown
confidence: low
evidence_source: yahoo_finance_search
evidence_note: name-only or weak provider match; manual review required
review_status: rejected
created_at: 2026-05-15T13:22:27.089323+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: equity
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
recommended_action: reject_candidate
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Yahoo Search Fallback

risk_flags:
  Assetklasse abweichend,Name unsicher,Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden


candidate_id: ipmc_8890e40a9041eafbac939cd2
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: yahoo_fallback
candidate_provider_symbol: VWOB260515C00067000
candidate_exchange: OPR
candidate_currency: USD
candidate_name: VWOB May 2026 67.000 call
candidate_instrument_status: unknown
confidence: medium
evidence_source: yahoo_finance_search
evidence_note: ticker+exchange match; requires manual review
review_status: rejected
created_at: 2026-05-15T13:22:27.089405+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Name unsicher,Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Yahoo Search Fallback


candidate_id: ipmc_e31b9b9f614991e30e953a0f
instrument_id: instrument-US92204A7028
isin: US92204A7028
candidate_provider: openfigi
candidate_provider_symbol: VGT
candidate_exchange: US
candidate_currency: USD
candidate_name: VANGUARD INFO TECH ETF
candidate_instrument_status: unknown
confidence: high
evidence_source: openfigi_isin_mapping
evidence_note: ISIN match; currency match
review_status: selected
created_at: 2026-05-15T13:22:27.968162+00:00
updated_at: 2026-05-15T14:31:47.037509+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Name teilweise ähnlich; OpenFIGI ISIN-Datenquelle


# instrument_import_candidates

candidate_id: instrument_candidate_37cfc02a663c3af46558a155
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 2
raw_name: / / 6 : : Konsolidiert in
raw_ticker: 16:23
raw_currency: CHF
raw_quantity: 14
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Unknown
proposed_ticker: 16:23
proposed_currency: CHF
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.197570+00:00
updated_at: 2026-05-15T20:48:32.707188+00:00
review_note:
  Ticker '16:23' and product name '/ / 6 : : Konsolidiert in' appear to be parsing errors or non-standard identifiers. Cannot map to a valid instrument. Requires manual review.


candidate_id: instrument_candidate_19c943637f01e4d7acc1885d
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 102
raw_name: ADBE
raw_ticker: ADBE
raw_currency: USD
raw_quantity: 20 260.65
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Adobe Inc.
proposed_ticker: ADBE
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198000+00:00
updated_at: 2026-05-15T20:48:32.706450+00:00
review_note:
  ISIN is empty. Ticker ADBE corresponds to Adobe Inc., but without ISIN, exact match cannot be confirmed. Manual verification required.


candidate_id: instrument_candidate_90ea94052680d069c2265925
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 112
raw_name: ANET
raw_ticker: ANET
raw_currency: USD
raw_quantity: 36 143.60
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Arista Networks, Inc.
proposed_ticker: ANET
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198103+00:00
updated_at: 2026-05-15T20:48:32.706843+00:00
review_note:
  ISIN is empty. Ticker ANET corresponds to Arista Networks, but without ISIN, exact match cannot be confirmed. Manual verification required.


candidate_id: instrument_candidate_073d04d4cbe2e793877e6275
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 122
raw_name: APC
raw_ticker: APC
raw_currency: EUR
raw_quantity: 190
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Unknown/Deprecated
proposed_ticker: APC
proposed_currency: EUR
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198251+00:00
updated_at: 2026-05-15T20:48:32.706924+00:00
review_note:
  ISIN is empty. Ticker APC is ambiguous (e.g., Associated Press, or former APC Energy). Currency EUR suggests European listing, but ticker is primarily US. High risk of ambiguity. Manual verification required.


candidate_id: instrument_candidate_92a693b025538e765b52393e
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 132
raw_name: APP
raw_ticker: APP
raw_currency: USD
raw_quantity: 13 372.386
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: DoorDash, Inc.
proposed_ticker: DASH
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198350+00:00
updated_at: 2026-05-15T20:48:32.706965+00:00
review_note:
  ISIN is empty. Ticker APP is currently used by Booking Holdings (formerly Priceline). The product name 'APP' likely refers to DoorDash, which trades under DASH. Ticker mismatch detected. Manual verification required.


candidate_id: instrument_candidate_637d6d093be4a119fce6f939
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 143
raw_name: AVGO
raw_ticker: AVGO
raw_currency: USD
raw_quantity: 56
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Broadcom Inc.
proposed_ticker: AVGO
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198397+00:00
updated_at: 2026-05-15T20:48:32.707013+00:00
review_note:
  ISIN is empty. Ticker AVGO corresponds to Broadcom Inc., but without ISIN, exact match cannot be confirmed. Manual verification required.


candidate_id: instrument_candidate_ea496ba063247a7efbf2fc74
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 163
raw_name: BABA
raw_ticker: BABA
raw_currency: USD
raw_quantity: 46 170.82391
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Alibaba Group Holding Ltd
proposed_ticker: BABA
proposed_exchange: NYSE
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198439+00:00
updated_at: 2026-05-15T20:48:32.707047+00:00
review_note:
  ISIN missing. Ticker BABA corresponds to Alibaba Group Holding Ltd on NYSE. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_19716bb81f8a16940852e7f1
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 172
raw_name: CRWD
raw_ticker: CRWD
raw_currency: USD
raw_quantity: 12 423.00
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: CrowdStrike Holdings Inc
proposed_ticker: CRWD
proposed_exchange: NASDAQ
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198480+00:00
updated_at: 2026-05-15T20:48:32.707077+00:00
review_note:
  ISIN missing. Ticker CRWD corresponds to CrowdStrike Holdings Inc on NASDAQ. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_1ec1155cea3d7ec5750a4c17
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 182
raw_name: GOOG
raw_ticker: GOOG
raw_currency: USD
raw_quantity: 96
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Alphabet Inc Class C
proposed_ticker: GOOG
proposed_exchange: NASDAQ
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198523+00:00
updated_at: 2026-05-15T20:48:32.707106+00:00
review_note:
  ISIN missing. Ticker GOOG corresponds to Alphabet Inc Class C on NASDAQ. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_2f05b84424048fa128f1a705
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 191
raw_name: MCD
raw_ticker: MCD
raw_currency: USD
raw_quantity: 14 129.97071
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: McDonald's Corp
proposed_ticker: MCD
proposed_exchange: NYSE
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198569+00:00
updated_at: 2026-05-15T20:48:32.707156+00:00
review_note:
  ISIN missing. Ticker MCD corresponds to McDonald's Corp on NYSE. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_4f35bed10b8653aff2436c97
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 201
raw_name: MSFT
raw_ticker: MSFT
raw_currency: USD
raw_quantity: 19 402.66
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Microsoft Corporation
proposed_ticker: MSFT
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198611+00:00
updated_at: 2026-05-15T20:48:32.707227+00:00
review_note:
  ISIN is empty. Ticker alone is not enough for confirmation. Manual verification required to assign correct ISIN.


candidate_id: instrument_candidate_73995e5e983c42f19d7e3fde
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 253
raw_name: PANW
raw_ticker: PANW
raw_currency: USD
raw_quantity: 31 168.50
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: PANW
proposed_ticker: PANW
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198847+00:00
updated_at: 2026-05-15T20:48:32.707380+00:00
review_note:
  ISIN is empty. Ticker alone is not sufficient for confirmation. Manual verification required to assign correct ISIN and exchange.


candidate_id: instrument_candidate_d6dd6a84b6e7fc87d2282f7b
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 308
raw_name: BCHE
raw_ticker: BCHE
raw_currency: USD
raw_quantity: 98
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: BCHE
proposed_ticker: BCHE
proposed_currency: USD
proposed_asset_class: etf
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.199052+00:00
updated_at: 2026-05-15T20:48:32.707511+00:00
review_note:
  ISIN is empty. Ticker BCHE is not unique enough for confirmation. Requires manual verification of the underlying asset.


candidate_id: instrument_candidate_bbbdba0e4d56ee9db9072c23
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 317
raw_name: IUIT
raw_ticker: IUIT
raw_currency: USD
raw_quantity: 400
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: IUIT
proposed_ticker: IUIT
proposed_currency: USD
proposed_asset_class: etf
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.199090+00:00
updated_at: 2026-05-15T20:48:32.707541+00:00
review_note:
  ISIN is empty. Ticker IUIT is not unique enough for confirmation. Requires manual verification of the underlying asset.


candidate_id: instrument_candidate_2210109058da8500d7d28d97
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 326
raw_name: WTAI
raw_ticker: WTAI
raw_currency: USD
raw_quantity: 68
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: WTAI
proposed_ticker: WTAI
proposed_currency: USD
proposed_asset_class: etf
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.199141+00:00
updated_at: 2026-05-15T20:48:32.707567+00:00
review_note:
  ISIN is empty. Ticker WTAI is not unique enough for confirmation. Requires manual verification of the underlying asset.


# budget_plan_items

plan_item_id: bplan_7018cd98726d44f6
plan_month: 2026-01
category_id: bcat_38c8f7bf53964431
monthly_amount_chf: 583.3333333333334
cadence: monthly
source_type: excel_seed_dry_run
notes: Budget Seed Review 2026
created_at: 2026-05-17T07:57:37Z
updated_at: 2026-05-17T07:57:37Z
name:
  Spezielle einmalige Anschaffungen (Pneu, Möbel, Mathe-Nachhilfe, Pool, Sonnensegel, Reitlager, Eisenhorn, Dreame)


