/* Fincr 2.0 — Add assets: multi-broker CSV import (P1 Task 2, [C2-D34]). Net-position snapshot reconciliation: parse CSV file(s) from any broker, extract atomic transactions, net buys/sells/staking per ticker, preview, then import the selected net positions into the store. Strategy (decisions.md [C2-D34..D38]): - Net-position snapshot, not full-ledger replay. Each ticker becomes ONE synthetic buy (qty = netQty, price = DCA) via addPosition()/addTxn(). - Staking adds quantity at €0, lowering DCA. In net-position mode it is folded into the single net buy — never emitted as a standalone 'staking' txn (f2DeriveHolding treats any non-'buy' kind as a sell). This realises [C2-D35]'s intent: staking adds qty and lowers cost basis, never subtracts. - Fully-sold tickers (netQty <= 1e-6) are dropped ([C2-D36] — realized P&L deferred to Cycle 2). - CSV date used when present, else today; never synthesise fake history ([C2-D37]). - Broker auto-detected by header substring; unknown brokers fall back to a manual column mapper ([C2-D38]). Store contracts (verified against store2.jsx): - actions.addPosition({ ticker, name, type, price, color, qty, buyPrice, date }) creates a holding (or appends a buy if the ticker already exists). When `color` is omitted the store assigns the next palette colour. - actions.addTxn(ticker, { kind, date, qty, price }) appends a txn to an EXISTING holding (no-op if the ticker is unknown — so we always check store.holdings first and route new tickers to addPosition). Live prices: GET /crypto-prices?tickers= (batch) and /stock-price?ticker= are public (no key) and return EUR — same endpoints store2 Phase 3 uses. */ /* Pure parsing + netting. No React / window / DOM dependency — this block is unit-tested directly in V8 (see importcheck.py). */ /* @@PURE_START */ /* CSV line splitter that respects double-quoted fields (commas inside quotes are not delimiters). Mirrors v1's parser. */ function f2ParseCsvLine(line) { const out = []; let cur = '', inQ = false; for (let i = 0; i < line.length; i++) { const ch = line[i]; if (ch === '"') { inQ = !inQ; continue; } if (ch === ',' && !inQ) { out.push(cur.trim()); cur = ''; continue; } cur += ch; } out.push(cur.trim()); return out; } /* Split raw CSV text into { headers, rows }. Tolerates \r\n and blank lines. */ function f2ParseCsv(text) { const lines = String(text == null ? '' : text).replace(/\r\n?/g, '\n').split('\n').filter((l) => l.trim().length); if (!lines.length) return { headers: [], rows: [] }; return { headers: f2ParseCsvLine(lines[0]), rows: lines.slice(1).map(f2ParseCsvLine) }; } /* Numeric parser: strips a leading 3-letter currency code ("EUR 12,30"), drops any other non-numeric symbols (€, $, spaces), and normalises the decimal separator. If both ',' and '.' appear the LAST one is the decimal and the other is treated as a thousands separator (handles "1.234,56" and "1,234.56"). A lone ',' is a decimal comma (European). Returns 0 on failure. Generalises v1's stripCurrency + the spec §3/§9 decimal rule. */ function f2ToNumber(s) { let v = String(s == null ? '' : s).trim(); v = v.replace(/^[A-Za-z]{3}\s+/, ''); // leading currency code + space v = v.replace(/[^0-9.,\-]/g, ''); // strip €, $, spaces, letters if (v.indexOf(',') >= 0 && v.indexOf('.') >= 0) { if (v.lastIndexOf(',') > v.lastIndexOf('.')) v = v.replace(/\./g, '').replace(',', '.'); else v = v.replace(/,/g, ''); } else if (v.indexOf(',') >= 0) { v = v.replace(',', '.'); } const n = parseFloat(v); return isNaN(n) ? 0 : n; } /* Ticker normaliser. Upper-cases, strips a SPACE-separated leading fiat prefix ("EUR NEAR" -> "NEAR", "USD BTC" -> "BTC"), then removes any remaining whitespace. Deliberately keyed on the space so a legitimate ticker like "EURN" is never truncated — a small, intent-preserving refinement of the spec's literal strip order (see BUILD_NOTES). This is the Run-6 footgun surface: a company-name column mapped to ticker yields garbage; the preview validates and flags it. */ function f2NormalizeTicker(raw) { let tk = String(raw == null ? '' : raw).toUpperCase().trim(); tk = tk.replace(/^(EUR|USD)\s+/, ''); tk = tk.replace(/\s+/g, ''); return tk; } /* Best-effort date parser. Accepts ISO (yyyy-mm-dd[...]), European dd-mm-yyyy / dd/mm/yyyy, else falls back to the engine's Date(). Returns 'yyyy-mm-dd' or null when unparseable (caller then defaults to today — [C2-D37], never a fabricated historical date). */ function f2ParseDate(raw) { const s = String(raw == null ? '' : raw).trim(); if (!s) return null; let m = s.match(/^(\d{4})-(\d{2})-(\d{2})/); if (m) return m[1] + '-' + m[2] + '-' + m[3]; m = s.match(/^(\d{2})[-/](\d{2})[-/](\d{4})/); if (m) return m[3] + '-' + m[2] + '-' + m[1]; const d = new Date(s); if (!isNaN(d.getTime())) return d.toISOString().slice(0, 10); return null; } function f2Today() { return new Date().toISOString().slice(0, 10); } /* Stock tickers must look like real symbols; crypto is always accepted (its symbols are free-form). Same regex as api.py /stock-price + v1 preview. */ function f2ValidTicker(ticker, type) { if (type === 'crypto') return true; return /^[A-Z0-9]{1,5}(\.[A-Z]{1,3})?$/.test(ticker); } /* ── Broker auto-detection profiles ─────────────────────────────────────── ORDER MATTERS: Trading 212 exports also contain an ISIN column, so it must be tested before DEGIRO (which detects on 'isin') or a 212 file would be misread as DEGIRO. Column accessors return a header index (-1 = absent). */ const F2_BROKER_PROFILES = [ { key: 'bitvavo', label: 'Bitvavo', assetType: 'crypto', detect: (h) => h.some((c) => c.toLowerCase().includes('quote price')), ticker: (h) => h.findIndex((c) => c.toLowerCase() === 'currency'), qty: (h) => h.findIndex((c) => c.toLowerCase() === 'amount'), price: (h) => h.findIndex((c) => c.toLowerCase().includes('quote price')), type: (h) => h.findIndex((c) => c.toLowerCase() === 'type'), date: (h) => h.findIndex((c) => c.toLowerCase() === 'date'), status: (h) => h.findIndex((c) => c.toLowerCase() === 'status'), buyVal: 'buy', sellVal: 'sell', stakeVal: 'staking', skipTypes: ['deposit', 'withdrawal'], skipTickers: ['EUR', 'USD'], statusOk: ['completed', 'distributed'], }, { key: 'trading212', label: 'Trading 212', assetType: 'stock', detect: (h) => h.some((c) => c.toLowerCase().includes('no. of shares')), ticker: (h) => h.findIndex((c) => c.toLowerCase() === 'ticker'), qty: (h) => h.findIndex((c) => c.toLowerCase().includes('no. of shares')), price: (h) => h.findIndex((c) => c.toLowerCase().includes('price / share')), type: (h) => h.findIndex((c) => c.toLowerCase() === 'action'), date: (h) => h.findIndex((c) => c.toLowerCase() === 'time'), buyVal: 'buy', sellVal: 'sell', stakeVal: '', skipTypes: [], skipTickers: [], statusOk: [], }, { key: 'degiro', label: 'DEGIRO', assetType: 'stock', detect: (h) => h.some((c) => c.toLowerCase().includes('isin')), ticker: (h) => h.findIndex((c) => c.toLowerCase() === 'product'), qty: (h) => h.findIndex((c) => c.toLowerCase() === 'quantity'), price: (h) => h.findIndex((c) => c.toLowerCase() === 'price'), type: () => -1, // no type column — kind inferred from the sign of quantity date: (h) => h.findIndex((c) => c.toLowerCase() === 'date'), buyVal: '', sellVal: '', stakeVal: '', skipTypes: [], skipTickers: [], statusOk: [], }, { key: 'revolut', label: 'Revolut', assetType: 'stock', detect: (h) => h.some((c) => c.toLowerCase().includes('price per share')), ticker: (h) => h.findIndex((c) => c.toLowerCase() === 'ticker'), qty: (h) => h.findIndex((c) => c.toLowerCase() === 'quantity'), price: (h) => h.findIndex((c) => c.toLowerCase().includes('price per share')), type: (h) => h.findIndex((c) => c.toLowerCase() === 'type'), date: (h) => h.findIndex((c) => c.toLowerCase() === 'date'), buyVal: 'buy', sellVal: 'sell', stakeVal: '', skipTypes: [], skipTickers: [], statusOk: [], }, ]; /* First profile whose detector matches the header row, else null (-> manual mapper). */ function f2DetectBroker(headers) { for (let i = 0; i < F2_BROKER_PROFILES.length; i++) { if (F2_BROKER_PROFILES[i].detect(headers)) return F2_BROKER_PROFILES[i]; } return null; } /* Resolve a column index from a cfg that may be an auto-profile (cfg[key] is a fn(headers)->idx) or a manual mapping (cfg[key+'Idx'] is a number). */ function f2ColIdx(cfg, key, headers) { if (typeof cfg[key] === 'function') return cfg[key](headers); if (typeof cfg[key + 'Idx'] === 'number' && !isNaN(cfg[key + 'Idx'])) return cfg[key + 'Idx']; return -1; } /* Resolve the kind of a row. CORRECTNESS NOTE (deviates from the spec's literal pseudo-code, intentionally — see BUILD_NOTES): when a type column exists the kind comes from the buy/sell/staking VALUES only — NOT the quantity sign. Bitvavo / Trading 212 / Revolut all report positive quantities on sell rows alongside a type column, so the spec's "|| qty > 0 => buy" clause would mislabel every sell as a buy and corrupt netting. The quantity sign is used ONLY when there is no type column (DEGIRO). This matches v1 exactly. */ function f2InferKind(typeRaw, qty, cfg, hasTypeCol) { if (!hasTypeCol) return qty > 0 ? 'buy' : (qty < 0 ? 'sell' : null); const tr = (typeRaw || '').toLowerCase(); const buyVal = (cfg.buyVal || '').toLowerCase(); const sellVal = (cfg.sellVal || '').toLowerCase(); const stakeVal = (cfg.stakeVal || '').toLowerCase(); if (stakeVal && tr.includes(stakeVal)) return 'staking'; if (buyVal && tr.includes(buyVal)) return 'buy'; if (sellVal && tr.includes(sellVal)) return 'sell'; if (!buyVal && !sellVal && qty > 0) return 'buy'; // type col mapped but no buy/sell labels return null; // unrecognised -> skipped } /* Extract atomic transactions from one file given a profile or manual cfg. Output rows: { ticker, qty (absolute), price (unit, EUR), kind, assetType, date }. Skips transfers, fiat tickers, non-completed Bitvavo rows, zero-qty rows, and price-less buys — mirroring v1. */ function f2ExtractTransactions(headers, rows, cfg) { const iT = f2ColIdx(cfg, 'ticker', headers); const iQ = f2ColIdx(cfg, 'qty', headers); const iP = f2ColIdx(cfg, 'price', headers); const iTot = f2ColIdx(cfg, 'total', headers); const iTy = f2ColIdx(cfg, 'type', headers); const iDate = f2ColIdx(cfg, 'date', headers); const iStatus = f2ColIdx(cfg, 'status', headers); const hasTypeCol = iTy >= 0; const skipTypes = new Set((cfg.skipTypes || []).map((s) => String(s).toLowerCase())); const skipTickers = new Set((cfg.skipTickers || []).map((s) => String(s).toUpperCase())); const statusOk = (cfg.statusOk || []).map((s) => String(s).toLowerCase()); const assetType = cfg.assetType || 'crypto'; const txs = []; for (const row of rows) { const ticker = f2NormalizeTicker(iT >= 0 ? row[iT] : ''); if (!ticker || skipTickers.has(ticker)) continue; // Bitvavo: only completed/distributed rows are real ownership changes. if (iStatus >= 0 && statusOk.length) { const st = String(row[iStatus] || '').trim().toLowerCase(); if (!statusOk.includes(st)) continue; } const typeRaw = iTy >= 0 ? String(row[iTy] || '').trim().toLowerCase() : ''; if (skipTypes.has(typeRaw)) continue; // deposit / withdrawal const qty = iQ >= 0 ? f2ToNumber(row[iQ]) : 0; const absQty = Math.abs(qty); if (absQty === 0) continue; const rawPrice = iP >= 0 ? f2ToNumber(row[iP]) : 0; const total = iTot >= 0 ? Math.abs(f2ToNumber(row[iTot])) : 0; const unitPrice = rawPrice > 0 ? rawPrice : (total > 0 ? total / absQty : 0); const kind = f2InferKind(typeRaw, qty, cfg, hasTypeCol); if (!kind) continue; // Suspicious buy with no resolvable price -> skip (v1 rule). Sells keep a // 0 price (price is irrelevant to net-position qty/DCA). Staking is €0. if (kind === 'buy' && unitPrice === 0) continue; const date = iDate >= 0 ? f2ParseDate(row[iDate]) : null; txs.push({ ticker, qty: absQty, price: kind === 'staking' ? 0 : unitPrice, kind, assetType, date, }); } return txs; } /* Net every transaction (across ALL files) by ticker+type. Returns { positions, dropped }: positions — kept net positions, sorted by € size desc, each: { ticker, type, netQty, avgBuy, buyCount, sellCount, stakingQty, valid, date } dropped — tickers netted to <= 1e-6 (fully sold; excluded from import). DCA: avgBuy = Σ(buyQty·buyPrice) / (totalBought + stakingQty). Staking adds qty at €0, lowering DCA ([C2-D35] intent). */ function f2NetPositions(txns, todayStr) { const today = todayStr || f2Today(); const groups = {}; for (const tx of txns) { const key = tx.ticker + '|' + tx.assetType; if (!groups[key]) groups[key] = { ticker: tx.ticker, type: tx.assetType, buys: [], soldQty: 0, stakingQty: 0, sellCount: 0, dates: [] }; const g = groups[key]; if (tx.kind === 'buy') g.buys.push({ qty: tx.qty, price: tx.price }); else if (tx.kind === 'sell') { g.soldQty += tx.qty; g.sellCount += 1; } else if (tx.kind === 'staking') g.stakingQty += tx.qty; if (tx.date) g.dates.push(tx.date); } const positions = [], dropped = []; Object.keys(groups).forEach((k) => { const g = groups[k]; const totalBought = g.buys.reduce((s, b) => s + b.qty, 0); const netQty = totalBought + g.stakingQty - g.soldQty; if (netQty <= 1e-6) { dropped.push({ ticker: g.ticker, type: g.type, netQty: netQty }); return; } const totalCost = g.buys.reduce((s, b) => s + b.qty * b.price, 0); const denom = totalBought + g.stakingQty; const avgBuy = denom > 0 ? totalCost / denom : 0; const date = g.dates.length ? g.dates.slice().sort().slice(-1)[0] : today; positions.push({ ticker: g.ticker, type: g.type, netQty: +netQty.toFixed(8), avgBuy: avgBuy, buyCount: g.buys.length, sellCount: g.sellCount, stakingQty: g.stakingQty, valid: f2ValidTicker(g.ticker, g.type), date: date, }); }); positions.sort((a, b) => (b.netQty * b.avgBuy) - (a.netQty * a.avgBuy)); return { positions, dropped }; } /* @@PURE_END */ /* ============================ React component ============================ */ function ImportTab2({ go }) { const t = useTheme2(); const F = window.FINCR; const store = useStore2(); // Loaded & parsed files: { name, broker, rowCount, txns, headers, rows, profileKey } const [files, setFiles] = React.useState([]); // A single file awaiting manual column mapping (unknown broker). const [pending, setPending] = React.useState(null); const [mapDraft, setMapDraft] = React.useState(null); // Net positions after Calculate: { positions, dropped } | null const [calc, setCalc] = React.useState(null); const [sel, setSel] = React.useState([]); // parallel to calc.positions const [busy, setBusy] = React.useState(false); const [result, setResult] = React.useState(null); // { imported, failed, estimated } const [err, setErr] = React.useState(null); const [toast, setToast] = React.useState(null); const [drag, setDrag] = React.useState(false); const inputRef = React.useRef(null); const goTimer = React.useRef(null); React.useEffect(() => () => { if (goTimer.current) clearTimeout(goTimer.current); }, []); // Files dropped while the mapper is open, or queued behind an unknown-broker // file in a multi-file drop, wait here and are processed once the current // mapper resolves — nothing is ever silently discarded. const fileQueue = React.useRef([]); // Sync is disabled without an API key — imports still apply locally, they // just don't reach the backend until the key is set (store2 same behaviour). const hasKey = !!(typeof localStorage !== 'undefined' && localStorage.getItem('fincr-api-key')); /* ── File reading ── */ const readFile = (file) => new Promise((resolve) => { const reader = new FileReader(); reader.onload = (e) => resolve({ text: String((e.target && e.target.result) || '') }); reader.onerror = () => resolve({ text: null, error: true }); reader.readAsText(file); }); const addFiles = async (fileList) => { const incoming = Array.from(fileList || []); if (!incoming.length) return; // A mapper is already open — don't clobber its in-progress column choices. // Queue the new files; the [pending] effect drains them once it closes. if (pending) { fileQueue.current = fileQueue.current.concat(incoming); setErr('Finish mapping ' + pending.name + ' first — ' + incoming.length + ' more file(s) queued.'); return; } // Accumulate every per-file problem so a multi-file batch surfaces them all // at once, instead of only the last setErr surviving the loop. const problems = []; const accepted = []; const known = new Set(files.map((f) => f.name)); for (let i = 0; i < incoming.length; i++) { const file = incoming[i]; if (!/\.csv$/i.test(file.name)) { problems.push('Skipped ' + file.name + ' — not a .csv'); continue; } if (known.has(file.name) || accepted.some((f) => f.name === file.name)) { problems.push('Already loaded: ' + file.name + ' (remove it to re-upload)'); continue; } const { text, error } = await readFile(file); if (error || text == null) { problems.push('Could not read ' + file.name); continue; } const { headers, rows } = f2ParseCsv(text); if (!headers.length || !rows.length) { problems.push('No rows found in ' + file.name); continue; } const profile = f2DetectBroker(headers); if (profile) { const txns = f2ExtractTransactions(headers, rows, profile); if (!txns.length) { problems.push('No valid transactions in ' + file.name + ' (all rows skipped)'); continue; } accepted.push({ name: file.name, broker: profile.label, rowCount: txns.length, txns: txns, headers: headers, rows: rows, profileKey: profile.key }); } else { // Unknown broker — queue any files still behind this one, then open the // mapper. The [pending] effect resumes the queue once it resolves, so // trailing files are never lost. fileQueue.current = fileQueue.current.concat(incoming.slice(i + 1)); openMapper({ name: file.name, headers: headers, rows: rows }); break; } } if (accepted.length) { // Dedupe against committed state inside the updater so two near-simultaneous // reads (or a queue drain) can't double-add the same filename. setFiles((fs) => fs.concat(accepted.filter((a) => !fs.some((f) => f.name === a.name)))); setCalc(null); setResult(null); } setErr(problems.length ? problems.join(' · ') : null); }; // Resume any queued files once the manual mapper closes (applied or cancelled). React.useEffect(() => { if (!pending && fileQueue.current.length) { const q = fileQueue.current; fileQueue.current = []; addFiles(q); } }, [pending]); const removeFile = (i) => { setFiles((fs) => fs.filter((_, j) => j !== i)); setCalc(null); setResult(null); }; const clearAll = () => { fileQueue.current = []; setFiles([]); setCalc(null); setSel([]); setPending(null); setMapDraft(null); setResult(null); setErr(null); }; /* ── Manual column mapper (unknown brokers) ── */ const openMapper = (file) => { setPending(file); setMapDraft({ ticker: '-1', qty: '-1', price: '-1', total: '-1', type: '-1', buyVal: 'buy', sellVal: 'sell', stakeVal: '', skipTypes: '', skipTickers: '', assetType: 'crypto' }); }; const cancelMapper = () => { setPending(null); setMapDraft(null); }; const setMap = (k) => (v) => setMapDraft((d) => Object.assign({}, d, { [k]: v })); const applyMapping = () => { if (!pending || !mapDraft) return; const num = (id) => parseInt(mapDraft[id], 10); const cfg = { key: 'manual', label: 'Manual map', assetType: mapDraft.assetType, tickerIdx: num('ticker'), qtyIdx: num('qty'), priceIdx: num('price'), totalIdx: num('total'), typeIdx: num('type'), dateIdx: pending.headers.findIndex((c) => /date|time/i.test(c)), buyVal: mapDraft.buyVal.trim().toLowerCase(), sellVal: mapDraft.sellVal.trim().toLowerCase(), stakeVal: mapDraft.stakeVal.trim().toLowerCase(), skipTypes: mapDraft.skipTypes.split(',').map((s) => s.trim()).filter(Boolean), skipTickers: mapDraft.skipTickers.split(',').map((s) => s.trim().toUpperCase()).filter(Boolean), statusOk: [], }; if (!(cfg.tickerIdx >= 0) || !(cfg.qtyIdx >= 0)) { setErr('Map at least the Ticker and Quantity columns.'); return; } const txns = f2ExtractTransactions(pending.headers, pending.rows, cfg); if (!txns.length) { setErr('No valid transactions parsed with that mapping — check the columns.'); return; } const added = { name: pending.name, broker: 'Manual map', rowCount: txns.length, txns: txns, headers: pending.headers, rows: pending.rows, profileKey: 'manual' }; setFiles((fs) => fs.some((f) => f.name === added.name) ? fs : fs.concat([added])); setPending(null); setMapDraft(null); setCalc(null); setResult(null); setErr(null); }; /* ── Calculate net positions across the whole pool ── */ const calculate = () => { setErr(null); setResult(null); const allTxns = files.reduce((acc, f) => acc.concat(f.txns), []); if (!allTxns.length) { setErr('Load at least one broker CSV first.'); return; } const out = f2NetPositions(allTxns, f2Today()); setCalc(out); setSel(out.positions.map((p) => p.valid)); // valid pre-checked, invalid off }; const positions = calc ? calc.positions : []; const selectedCount = sel.filter(Boolean).length; const validCount = positions.filter((p) => p.valid).length; const allValidSelected = validCount > 0 && positions.every((p, i) => !p.valid || sel[i]); const toggleRow = (i) => setSel((s) => s.map((v, j) => (j === i ? !v : v))); const toggleAll = () => { const target = !allValidSelected; setSel(positions.map((p) => (p.valid ? target : false))); }; /* ── Live price (EUR) for a single ticker — public endpoints, no key ── */ const fetchLivePrice = async (ticker, type) => { const base = 'https://fincr.duckdns.org'; try { if (type === 'crypto') { const r = await fetch(base + '/crypto-prices?tickers=' + encodeURIComponent(ticker)); if (!r.ok) return null; const m = await r.json(); const p = m && m[ticker.toUpperCase()]; return typeof p === 'number' ? p : null; } const r = await fetch(base + '/stock-price?ticker=' + encodeURIComponent(ticker)); if (!r.ok) return null; const d = await r.json(); return d && typeof d.price === 'number' ? d.price : null; } catch (e) { return null; } }; /* ── Import the selected net positions ── */ const doImport = async () => { const rows = positions.filter((p, i) => sel[i] && p.valid); if (!rows.length) return; setBusy(true); setErr(null); // Snapshot existing positions ONCE, keyed by ticker+type (same key the // netting uses, and matching V1) so a same-symbol stock and crypto never // collide: new -> addPosition, existing -> addTxn. (The store actions still // match on ticker alone, so a held stock + imported crypto of the identical // symbol would still merge — a rare, documented limitation; this key at // least stops two same-symbol/different-type import rows colliding.) const keyOf = (x) => x.ticker + '|' + x.type; const existing = new Set((store.holdings || []).map(keyOf)); const newRows = rows.filter((r) => !existing.has(keyOf(r))); // Fetch live prices for new positions in parallel (existing ones keep their // own live price; addTxn never sets price). Failures fall back to DCA. const priceByKey = {}; await Promise.all(newRows.map(async (r) => { priceByKey[keyOf(r)] = await fetchLivePrice(r.ticker, r.type); })); // Apply synchronously so React batches every setHoldings into one render -> // exactly one POST /holdings sync (not one per row). const failed = [], estimated = []; const today = f2Today(); rows.forEach((r) => { try { if (existing.has(keyOf(r))) { store.actions.addTxn(r.ticker, { kind: 'buy', date: r.date || today, qty: r.netQty, price: r.avgBuy }); } else { const live = priceByKey[keyOf(r)]; if (live == null) estimated.push(r.ticker); store.actions.addPosition({ ticker: r.ticker, name: r.ticker, type: r.type, qty: r.netQty, buyPrice: r.avgBuy, price: live != null ? live : r.avgBuy, date: r.date || today, }); } } catch (e) { failed.push(r.ticker); if (typeof console !== 'undefined') console.warn('[import] failed for ' + r.ticker, e); } }); const imported = rows.length - failed.length; setResult({ imported: imported, failed: failed, estimated: estimated }); setToast({ tone: failed.length ? 'watch' : 'ok', msg: 'Imported ' + imported + ' position' + (imported === 1 ? '' : 's') + (failed.length ? ' · ' + failed.length + ' failed' : ''), }); setBusy(false); // Brief confirmation, then land on Overview where the updated book shows. if (typeof go === 'function') { goTimer.current = setTimeout(() => go('overview'), 1150); } }; /* ── Render ── */ const headerCols = ['', 'Ticker', 'Type', 'Net qty', 'Avg buy', 'Buys', 'Sells']; const pvCols = '28px 1.3fr 0.7fr 1fr 1fr 0.6fr 0.6fr'; return (
{!hasKey && (
Sync disabled — no API key on this device. Imports stay local until you authenticate.
)} {err && (
!{err}
)} {/* ── 01 · Upload ── */} Upload from any broker

Drop CSV exports from any number of brokers. Fincr pools every transaction before netting — a sell on one broker correctly cancels a buy on another. Bitvavo, DEGIRO, Trading 212 and Revolut are detected automatically; anything else opens a quick column mapper.

{ addFiles(e.target.files); e.target.value = ''; }} />
inputRef.current && inputRef.current.click()} onDragOver={(e) => { e.preventDefault(); setDrag(true); }} onDragLeave={() => setDrag(false)} onDrop={(e) => { e.preventDefault(); setDrag(false); addFiles(e.dataTransfer.files); }} style={{ border: `1.5px dashed ${drag ? t.accent : t.inputBorder}`, borderRadius: 14, padding: '32px 24px', textAlign: 'center', background: drag ? t.accentSoft : t.hover, cursor: 'pointer', transition: 'all 0.15s' }}>
Drop CSV files here
or browse · multiple files supported
{/* Loaded files list */} {files.length > 0 && (
Clear all} style={{ marginBottom: 8 }}>Loaded files · {files.length} {files.map((f, i) => (
{f.name}
{f.broker} · {f.rowCount} transaction{f.rowCount === 1 ? '' : 's'}
PARSED
))}
)} {/* Manual column mapper for an unknown broker */} {pending && mapDraft && (
Map columns — {pending.name}
Unrecognised broker. Tell Fincr which column is which.
{[['ticker', 'Ticker *'], ['qty', 'Quantity *'], ['price', 'Price / unit'], ['total', 'Total value'], ['type', 'Type / action']].map(([key, label]) => ( ))}
Apply mapping Cancel
)} {/* ── 02 · Net positions preview ── */} {selectedCount} OF {validCount} SELECTED : null} style={{ marginBottom: 14 }}>Net positions preview {!calc && (
Calculate net positions across all files → {files.length ? 'Pools every file, applies cross-broker sells.' : 'Load a CSV above to begin.'}
)} {calc && positions.length === 0 && (
No open positions after netting{calc.dropped.length ? ' — ' + calc.dropped.length + ' ticker' + (calc.dropped.length === 1 ? '' : 's') + ' netted to zero (fully sold).' : '.'} setCalc(null)}>Recalculate
)} {calc && positions.length > 0 && (
{headerCols.slice(1).map((c, i) => ( {c} ))}
{positions.map((p, i) => (
{p.ticker} {!p.valid && check}
{p.type}
{(+p.netQty.toFixed(p.netQty < 1 ? 6 : 4)).toString()} {p.avgBuy ? F.eur(p.avgBuy, 2) : '—'} {p.buyCount}{p.stakingQty ? '+s' : ''} {p.sellCount}
))} {calc.dropped.length > 0 && (
{calc.dropped.length} ticker{calc.dropped.length === 1 ? '' : 's'} netted to zero (fully sold) and {calc.dropped.length === 1 ? 'was' : 'were'} excluded.
)} {validCount < positions.length && (
{positions.length - validCount} ticker{positions.length - validCount === 1 ? '' : 's'} look like a name, not a symbol — fix the column mapping to import {positions.length - validCount === 1 ? 'it' : 'them'}.
)}
setCalc(null)}>Recalculate
)} {/* ── 03 · Import ── */} Import {!result && (
{busy ? 'Importing…' : 'Import ' + selectedCount + ' selected'} {selectedCount ? 'New tickers are created; existing ones get a buy at the new average. Live prices fetched on import.' : 'Select positions above to import.'}
)} {result && (
Imported {result.imported} position{result.imported === 1 ? '' : 's'}
{result.failed.length > 0 &&
Failed: {result.failed.join(', ')}
} {result.estimated.length > 0 &&
Price estimated from cost basis (live fetch failed): {result.estimated.join(', ')}
}
Opening your overview…
)} {/* Toast */} {toast && (
{toast.msg}
)}
); } window.ImportTab2 = ImportTab2;