{"ok":true,"status":"PROBLEM_DETECTED","readonly":true,"write_enabled":false,"writes_executed":false,"trading_hub_changed":false,"driver":"psycopg","version":"TSC Portfolio Center V6.4.2 Hotfix 2 – Existing PAYPAL Wrong BUY Repair Preview","repair_preview_version":"V6.4.2-HF2","problem_summary":{"wrong_buy_transaction_count":3,"wrong_buy_draft_count":1,"active_paypal_xtb_position_count":0,"active_cash_row_count":0},"repair_plan":{"recommended_next_step":"REPAIR_PREVIEW_ONLY","preview_only":true,"write_enabled":false,"position_damage":{"position_count":0,"quantity":0.0,"cost_basis_eur":0.0,"cost_basis_formatted":"0,00 €","market_value_eur":0.0,"market_value_formatted":"0,00 €","price_missing_count":0},"cash_damage":{"suspicious_transaction_count":3,"current_wrong_cash_effect_eur":-354.18,"current_wrong_cash_effect_formatted":"-354,18 €","if_neutralized_cash_delta_eur":354.18,"if_neutralized_cash_delta_formatted":"354,18 €","if_converted_to_sell_cash_delta_eur":708.36,"if_converted_to_sell_cash_delta_formatted":"708,36 €","explanation":{"neutralize":"Entfernt/neutralisiert die falsche BUY-Wirkung: -140 wird zu 0, Cash steigt um 140.","convert_to_sell":"Wandelt BUY -140 in SELL +140: Cash-Differenz wäre +280, aber nur korrekt bei vorhandener Alt-Position."}},"repair_options":[{"key":"NEUTRALIZE_WRONG_TEST_BUY","recommended":true,"description":"Falsche PAYPAL-BUY-Testtransaktion neutralisieren/als fehlerhaft ausschließen.","expected_effect":["PAYPAL-XTB-Position verschwindet nach Rebuild.","Cash-Effekt der falschen BUY-Transaktion wird neutralisiert.","Geeignet, wenn die XTB-Zeile ein Test-/Demo-Verkauf ohne vorhandene Altposition war."],"estimated_cash_delta_eur":354.18,"estimated_cash_delta_formatted":"354,18 €","requires_safety_ack_later":"REPAIR_PAYPAL_WRONG_BUY_NEUTRALIZE","executes_now":false},{"key":"CONVERT_BUY_TO_SELL","recommended":false,"description":"Falsche BUY-Transaktion in SELL korrigieren.","expected_effect":["Cash-Effekt würde von negativ auf positiv wechseln.","Nur korrekt, wenn es vor dem Verkauf bereits eine passende PAYPAL-Position gab.","Ohne vorhandene Altposition kann FIFO/Positionslogik einen Sell ohne Lot erzeugen."],"estimated_cash_delta_eur":708.36,"estimated_cash_delta_formatted":"708,36 €","requires_safety_ack_later":"REPAIR_PAYPAL_WRONG_BUY_CONVERT_TO_SELL","executes_now":false},{"key":"ONLY_SET_PAYPAL_PRICE","recommended":false,"description":"Nur Kurs setzen, ohne die falsche Transaktion zu reparieren.","expected_effect":["PRICE_MISSING verschwindet.","Die fachlich falsche BUY-Position bleibt aber bestehen.","Nicht empfohlen, solange der Importfehler nicht repariert ist."],"requires_safety_ack_later":"NONE","executes_now":false}]},"suspicious_transactions":[{"id":"0ee1cbdd-5ab2-42d2-9526-cc183e5adf60","transaction_date":"2025-12-15","transaction_time":"02:16:46","transaction_type":"BUY","broker_id":"cb6df3b8-9266-496d-a95a-7c408533ac8a","asset_id":"c978f0f9-8c93-4915-8fd3-0bb647fca7a5","quantity":3.0,"price":52.563333,"gross_amount":157.689999,"fees":0.0,"taxes":0.0,"net_amount":157.69,"currency":"USD","fx_rate_to_eur":0.85482734,"amount_eur":157.69,"source":"google_sheet_v6103d","source_reference":"v6103d_row_27_sig_1e30ff868c6d","external_id":"TX-000042","notes":"XTB Stock purchase / ID 1052977717 / OPEN BUY 3 @ 61.49 / IMPORT_CENTER_V1:zgDWGEzvnIFL7t83Y8 | source_id=TX-000042","is_deleted":false,"deleted_at":null,"created_at":"2026-06-30T22:24:52.653753+02:00","updated_at":"2026-06-30T22:24:52.653753+02:00","draft_id":null,"draft_key":null,"commit_gate_version":"V6.10.3d","commit_ack":"IMPORT_CONFIRMED","commit_note":"Imported from Google Sheet migration after V6.10.2 clean plan","commit_status":"COMMITTED","committed_at":"2026-06-30T22:24:52.653753+02:00","rollback_note":null,"rolled_back_at":null,"broker_key":"XTB","asset_key":"PAYPAL","cash_effect_eur":-157.69,"payload_json":{"source":"google_sheet_v6103d","version":"TSC Portfolio Center V6.10.3d Productive Reset + Real Import Fixed Mapping","original":{"name":"PayPal","type":"Kauf","broker":"XTB","ticker":"NASDAQ:PYPL","fee_eur":0.0,"currency":"USD","gross_eur":157.689999,"total_eur":157.69,"fee_original":0.0,"fx_rate_to_eur":0.85482734,"price_original":61.49},"source_id":"TX-000042","source_row":27,"dedupe_signature":"1e30ff868c6df768343bf6b83991bebdeab68185"},"preview_json":{"date":"2025-12-15","type":"BUY","quantity":3.0,"asset_key":"PAYPAL","signature":"1e30ff868c6d","amount_eur":157.69,"broker_key":"XTB","cash_effect_eur":-157.69},"deleted_reason":null,"_detected_problem":"PAYPAL_XTB_BUY_WITH_NEGATIVE_CASH","_raw_says_sell":false,"_cash_effect_eur":-157.69},{"id":"5d26dcea-7520-4e58-8344-d1c85540ac04","transaction_date":"2025-11-07","transaction_time":"02:16:46","transaction_type":"BUY","broker_id":"cb6df3b8-9266-496d-a95a-7c408533ac8a","asset_id":"c978f0f9-8c93-4915-8fd3-0bb647fca7a5","quantity":0.43,"price":56.953489,"gross_amount":24.49000027,"fees":0.0,"taxes":0.0,"net_amount":24.49,"currency":"USD","fx_rate_to_eur":0.86832579,"amount_eur":24.49,"source":"google_sheet_v6103d","source_reference":"v6103d_row_39_sig_b480ca247423","external_id":"TX-000054","notes":"XTB Stock purchase / ID 1007744340 / OPEN BUY 0.43 @ 65.59 / IMPORT_CENTER_V1:4nJaOpwlO-8atnJx-D | source_id=TX-000054","is_deleted":false,"deleted_at":null,"created_at":"2026-06-30T22:24:54.397663+02:00","updated_at":"2026-06-30T22:24:54.397663+02:00","draft_id":null,"draft_key":null,"commit_gate_version":"V6.10.3d","commit_ack":"IMPORT_CONFIRMED","commit_note":"Imported from Google Sheet migration after V6.10.2 clean plan","commit_status":"COMMITTED","committed_at":"2026-06-30T22:24:54.397663+02:00","rollback_note":null,"rolled_back_at":null,"broker_key":"XTB","asset_key":"PAYPAL","cash_effect_eur":-24.49,"payload_json":{"source":"google_sheet_v6103d","version":"TSC Portfolio Center V6.10.3d Productive Reset + Real Import Fixed Mapping","original":{"name":"PayPal","type":"Kauf","broker":"XTB","ticker":"NASDAQ:PYPL","fee_eur":0.0,"currency":"USD","gross_eur":24.49000027,"total_eur":24.49,"fee_original":0.0,"fx_rate_to_eur":0.86832579,"price_original":65.59},"source_id":"TX-000054","source_row":39,"dedupe_signature":"b480ca247423511bc879c4826f569a23f2b0bdb6"},"preview_json":{"date":"2025-11-07","type":"BUY","quantity":0.43,"asset_key":"PAYPAL","signature":"b480ca247423","amount_eur":24.49,"broker_key":"XTB","cash_effect_eur":-24.49},"deleted_reason":null,"_detected_problem":"PAYPAL_XTB_BUY_WITH_NEGATIVE_CASH","_raw_says_sell":false,"_cash_effect_eur":-24.49},{"id":"4bc7a1b0-9875-4c6f-83ee-059302502c63","transaction_date":"2025-10-17","transaction_time":"02:16:46","transaction_type":"BUY","broker_id":"cb6df3b8-9266-496d-a95a-7c408533ac8a","asset_id":"c978f0f9-8c93-4915-8fd3-0bb647fca7a5","quantity":3.0,"price":57.333333,"gross_amount":171.999999,"fees":0.0,"taxes":0.0,"net_amount":172.0,"currency":"USD","fx_rate_to_eur":0.86086086,"amount_eur":172.0,"source":"google_sheet_v6103d","source_reference":"v6103d_row_42_sig_5985d901730a","external_id":"TX-000058","notes":"XTB Stock purchase / ID 980130257 / OPEN BUY 3 @ 66.60 / IMPORT_CENTER_V1:jYGfxG9TC6wjWUbh2i | source_id=TX-000058","is_deleted":false,"deleted_at":null,"created_at":"2026-06-30T22:24:54.833723+02:00","updated_at":"2026-06-30T22:24:54.833723+02:00","draft_id":null,"draft_key":null,"commit_gate_version":"V6.10.3d","commit_ack":"IMPORT_CONFIRMED","commit_note":"Imported from Google Sheet migration after V6.10.2 clean plan","commit_status":"COMMITTED","committed_at":"2026-06-30T22:24:54.833723+02:00","rollback_note":null,"rolled_back_at":null,"broker_key":"XTB","asset_key":"PAYPAL","cash_effect_eur":-172.0,"payload_json":{"source":"google_sheet_v6103d","version":"TSC Portfolio Center V6.10.3d Productive Reset + Real Import Fixed Mapping","original":{"name":"PayPal","type":"Kauf","broker":"XTB","ticker":"NASDAQ:PYPL","fee_eur":0.0,"currency":"USD","gross_eur":171.999999,"total_eur":172.0,"fee_original":0.0,"fx_rate_to_eur":0.86086086,"price_original":66.6},"source_id":"TX-000058","source_row":42,"dedupe_signature":"5985d901730a153b7703a892902ae9bb4a7d3bb4"},"preview_json":{"date":"2025-10-17","type":"BUY","quantity":3.0,"asset_key":"PAYPAL","signature":"5985d901730a","amount_eur":172.0,"broker_key":"XTB","cash_effect_eur":-172.0},"deleted_reason":null,"_detected_problem":"PAYPAL_XTB_BUY_WITH_NEGATIVE_CASH","_raw_says_sell":false,"_cash_effect_eur":-172.0}],"suspicious_drafts":[{"id":"375f18bb-620a-41a8-8cf3-658c5935d1f8","draft_key":"TXD-AAE1745BC41C446DAE0C","draft_status":"COMMITTED","transaction_type":"BUY","transaction_date":"2026-06-28","broker_key":"XTB","asset_key":"PAYPAL","currency":"EUR","gross_amount":null,"net_amount":null,"amount_eur":140.0,"cash_effect_eur":-140.0,"payload_json":{"date":"2026-06-28","note":"Converted from import IMP-2f53bc5677fe482faf2ba4df6f468bea row 3 by V6.3.4","type":"BUY","price":70.0,"source":"xtb_csv_mapper_v631","fee_eur":0.0,"tax_eur":0.0,"currency":"EUR","fees_eur":0.0,"quantity":2.0,"asset_key":"PAYPAL","price_eur":70.0,"taxes_eur":0.0,"amount_eur":140.0,"broker_key":"XTB","cash_effect_eur":-140.0,"gross_amount_eur":140.0,"transaction_date":"2026-06-28","transaction_type":"BUY","converter_version":"V6.3.4","source_import_key":"IMP-2f53bc5677fe482faf2ba4df6f468bea","source_import_type":"XTB_CSV_MAPPER_V631","source_import_row_id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","source_import_row_index":3,"source_import_broker_key":"XTB"},"preview_json":{"ok":true,"errors":[],"status":"TRANSACTION_DRAFT_PREVIEW_FROM_IMPORT","warnings":[],"candidate":{"ready":true,"errors":[],"raw_row":{"id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","raw_json":{"raw_dict":{"typ":"Verkauf","isin":"US70450Y1038","name":"PayPal","datum":"2026-06-28","menge":"2","preis":"70","betrag":"140","steuer":"0","symbol":"PYPL.US","gebuehr":"0","waehrung":"EUR"},"raw_cells":["2026-06-28","Verkauf","PYPL.US","PayPal","US70450Y1038","2","70","140","0","0","EUR"]},"raw_text":"2026-06-28;Verkauf;PYPL.US;PayPal;US70450Y1038;2;70;140;0;0;EUR","row_index":3,"created_at":"2026-06-28T22:28:34.560376+02:00","import_key":"IMP-2f53bc5677fe482faf2ba4df6f468bea","row_status":"DRAFT","errors_json":[],"detected_type":"BUY","warnings_json":[],"normalized_json":{"detected_type":"BUY","source_mapper":"xtb_csv_mapper_v631","mapper_confidence":100,"transaction_candidate":true,"normalized_transaction":{"isin":"US70450Y1038","name":"PayPal","source":"xtb_csv_mapper_v631","symbol":"PYPL.US","tax_eur":0.0,"currency":"EUR","fees_eur":0.0,"quantity":2.0,"raw_text":"2026-06-28;Verkauf;PYPL.US;PayPal;US70450Y1038;2;70;140;0;0;EUR","price_eur":70.0,"broker_key":"XTB","asset_key_guess":"PAYPAL","cash_effect_eur":-140.0,"gross_amount_eur":140.0,"transaction_date":"2026-06-28","transaction_type":"BUY","asset_match_reason":"exact:PayPal","transaction_date_raw":"2026-06-28"}}},"warnings":[],"asset_key":"PAYPAL","row_index":3,"broker_key":"XTB","row_status":"DRAFT","detected_type":"BUY","draft_payload":{"date":"2026-06-28","note":"Converted from import IMP-2f53bc5677fe482faf2ba4df6f468bea row 3 by V6.3.4","type":"BUY","price":70.0,"source":"xtb_csv_mapper_v631","fee_eur":0.0,"tax_eur":0.0,"currency":"EUR","fees_eur":0.0,"quantity":2.0,"asset_key":"PAYPAL","price_eur":70.0,"taxes_eur":0.0,"amount_eur":140.0,"broker_key":"XTB","cash_effect_eur":-140.0,"gross_amount_eur":140.0,"transaction_date":"2026-06-28","transaction_type":"BUY","converter_version":"V6.3.4","source_import_key":"IMP-2f53bc5677fe482faf2ba4df6f468bea","source_import_type":"XTB_CSV_MAPPER_V631","source_import_row_id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","source_import_row_index":3,"source_import_broker_key":"XTB"},"import_row_id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","transaction_date":"2026-06-28","transaction_type":"BUY","normalized_transaction":{"isin":"US70450Y1038","name":"PayPal","source":"xtb_csv_mapper_v631","symbol":"PYPL.US","tax_eur":0.0,"currency":"EUR","fees_eur":0.0,"quantity":2.0,"raw_text":"2026-06-28;Verkauf;PYPL.US;PayPal;US70450Y1038;2;70;140;0;0;EUR","price_eur":70.0,"broker_key":"XTB","asset_key_guess":"PAYPAL","cash_effect_eur":-140.0,"gross_amount_eur":140.0,"transaction_date":"2026-06-28","transaction_type":"BUY","asset_match_reason":"exact:PayPal","transaction_date_raw":"2026-06-28"}},"draft_payload":{"date":"2026-06-28","note":"Converted from import IMP-2f53bc5677fe482faf2ba4df6f468bea row 3 by V6.3.4","type":"BUY","price":70.0,"source":"xtb_csv_mapper_v631","fee_eur":0.0,"tax_eur":0.0,"currency":"EUR","fees_eur":0.0,"quantity":2.0,"asset_key":"PAYPAL","price_eur":70.0,"taxes_eur":0.0,"amount_eur":140.0,"broker_key":"XTB","cash_effect_eur":-140.0,"gross_amount_eur":140.0,"transaction_date":"2026-06-28","transaction_type":"BUY","converter_version":"V6.3.4","source_import_key":"IMP-2f53bc5677fe482faf2ba4df6f468bea","source_import_type":"XTB_CSV_MAPPER_V631","source_import_row_id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","source_import_row_index":3,"source_import_broker_key":"XTB"},"writes_executed":false,"readonly_preview":true,"converter_version":"V6.3.4"},"safety_gate_version":"V6.0.6","safety_ack":"COMMIT_REAL_TRANSACTION","safety_note":null,"source":"xtb_csv_mapper_v631","created_at":"2026-06-28T20:47:55.123917+02:00","updated_at":"2026-06-29T00:25:24.931900+02:00","discarded_at":null,"committed_at":null,"source_import_key":"IMP-2f53bc5677fe482faf2ba4df6f468bea","source_import_row_id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","source_import_row_index":3,"source_import_type":"XTB_CSV_MAPPER_V631","source_import_broker_key":"XTB","converter_version":"V6.3.4","import_payload_json":{"source":"import_to_transaction_draft_converter_v634","candidate":{"ready":true,"errors":[],"raw_row":{"id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","raw_json":{"raw_dict":{"typ":"Verkauf","isin":"US70450Y1038","name":"PayPal","datum":"2026-06-28","menge":"2","preis":"70","betrag":"140","steuer":"0","symbol":"PYPL.US","gebuehr":"0","waehrung":"EUR"},"raw_cells":["2026-06-28","Verkauf","PYPL.US","PayPal","US70450Y1038","2","70","140","0","0","EUR"]},"raw_text":"2026-06-28;Verkauf;PYPL.US;PayPal;US70450Y1038;2;70;140;0;0;EUR","row_index":3,"created_at":"2026-06-28T22:28:34.560376+02:00","import_key":"IMP-2f53bc5677fe482faf2ba4df6f468bea","row_status":"DRAFT","errors_json":[],"detected_type":"BUY","warnings_json":[],"normalized_json":{"detected_type":"BUY","source_mapper":"xtb_csv_mapper_v631","mapper_confidence":100,"transaction_candidate":true,"normalized_transaction":{"isin":"US70450Y1038","name":"PayPal","source":"xtb_csv_mapper_v631","symbol":"PYPL.US","tax_eur":0.0,"currency":"EUR","fees_eur":0.0,"quantity":2.0,"raw_text":"2026-06-28;Verkauf;PYPL.US;PayPal;US70450Y1038;2;70;140;0;0;EUR","price_eur":70.0,"broker_key":"XTB","asset_key_guess":"PAYPAL","cash_effect_eur":-140.0,"gross_amount_eur":140.0,"transaction_date":"2026-06-28","transaction_type":"BUY","asset_match_reason":"exact:PayPal","transaction_date_raw":"2026-06-28"}}},"warnings":[],"asset_key":"PAYPAL","row_index":3,"broker_key":"XTB","row_status":"DRAFT","detected_type":"BUY","draft_payload":{"date":"2026-06-28","note":"Converted from import IMP-2f53bc5677fe482faf2ba4df6f468bea row 3 by V6.3.4","type":"BUY","price":70.0,"source":"xtb_csv_mapper_v631","fee_eur":0.0,"tax_eur":0.0,"currency":"EUR","fees_eur":0.0,"quantity":2.0,"asset_key":"PAYPAL","price_eur":70.0,"taxes_eur":0.0,"amount_eur":140.0,"broker_key":"XTB","cash_effect_eur":-140.0,"gross_amount_eur":140.0,"transaction_date":"2026-06-28","transaction_type":"BUY","converter_version":"V6.3.4","source_import_key":"IMP-2f53bc5677fe482faf2ba4df6f468bea","source_import_type":"XTB_CSV_MAPPER_V631","source_import_row_id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","source_import_row_index":3,"source_import_broker_key":"XTB"},"import_row_id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","transaction_date":"2026-06-28","transaction_type":"BUY","normalized_transaction":{"isin":"US70450Y1038","name":"PayPal","source":"xtb_csv_mapper_v631","symbol":"PYPL.US","tax_eur":0.0,"currency":"EUR","fees_eur":0.0,"quantity":2.0,"raw_text":"2026-06-28;Verkauf;PYPL.US;PayPal;US70450Y1038;2;70;140;0;0;EUR","price_eur":70.0,"broker_key":"XTB","asset_key_guess":"PAYPAL","cash_effect_eur":-140.0,"gross_amount_eur":140.0,"transaction_date":"2026-06-28","transaction_type":"BUY","asset_match_reason":"exact:PayPal","transaction_date_raw":"2026-06-28"}},"draft_payload":{"date":"2026-06-28","note":"Converted from import IMP-2f53bc5677fe482faf2ba4df6f468bea row 3 by V6.3.4","type":"BUY","price":70.0,"source":"xtb_csv_mapper_v631","fee_eur":0.0,"tax_eur":0.0,"currency":"EUR","fees_eur":0.0,"quantity":2.0,"asset_key":"PAYPAL","price_eur":70.0,"taxes_eur":0.0,"amount_eur":140.0,"broker_key":"XTB","cash_effect_eur":-140.0,"gross_amount_eur":140.0,"transaction_date":"2026-06-28","transaction_type":"BUY","converter_version":"V6.3.4","source_import_key":"IMP-2f53bc5677fe482faf2ba4df6f468bea","source_import_type":"XTB_CSV_MAPPER_V631","source_import_row_id":"15d11a0c-da2c-4a59-9aac-330a3f7b7da5","source_import_row_index":3,"source_import_broker_key":"XTB"},"converter_version":"V6.3.4"},"conversion_warnings_json":[],"conversion_errors_json":[],"is_archived":true,"archived_at":"2026-06-29T00:25:24.931900+02:00","archived_by":"portfolio_repair_v642_hf3","archive_reason":"paypal_wrong_buy_repaired","archive_note":"Archived by V6.4.2-HF3 after controlled neutralization repair.","_detected_problem":"XTB_RAW_SELL_MAPPED_AS_BUY","_raw_says_sell":true,"_cash_effect_eur":-140.0}],"active_paypal_positions":[],"active_cash_rows":[],"next_safe_checkpoint":"TSC Portfolio Center V6.4.2 Hotfix 3 – Controlled PAYPAL Wrong BUY Repair","duration_ms":208.27,"checked_at_utc":"2026-07-16T21:09:54+00:00"}