AI Portfolio Manager

\n \n\n\n`;\n\n// เสิร์ฟหน้า HTML\napp.get(\"*\", (c) => c.html(HTML));\n\nexport default app.fetch;","deleted","label","children",[],[166],{"_110":185,"_102":186,"_167":187,"_169":-5,"_170":152,"_171":188,"_172":22,"_112":189,"_106":190,"_175":191,"_177":192,"_179":22,"_180":-5,"_181":193,"_105":194},"ba92c8be-39a4-11f1-9969-42b51c65c3df","update_stock_prices","ae1a12b8-39a4-11f1-87b9-42b51c65c3df",32,["D",1776351509259],3,"interval","// Learn more: https://docs.val.town/vals/cron/\nexport default async function (interval: Interval) {\n console.log(interval);\n}",[],[186],"files",[164,184],"counts",{"_199":33,"_200":126,"_201":33,"_202":203,"_206":207},"pulls","branches","forks","envVars",{"_204":33,"_205":33},"count","emptyCount","connections",{"_204":33,"_208":33},"unfilledCount","contents",[211,214],{"_110":165,"_102":166,"_167":168,"_169":-5,"_170":152,"_171":107,"_172":22,"_112":212,"_106":174,"_175":176,"_177":178,"_179":22,"_180":-5,"_105":213},["D",1776351530336],[166],{"_110":185,"_102":186,"_167":187,"_169":-5,"_170":152,"_171":188,"_172":22,"_112":215,"_106":190,"_175":191,"_177":192,"_179":22,"_180":-5,"_105":216},["D",1776351509259],[186],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_108":226,"_106":107,"_231":232},{"_110":111,"_102":103,"_112":227,"_114":-5,"_115":22,"_116":117,"_118":-5,"_119":-5,"_14":120,"_121":-5,"_122":22,"_123":-5,"_124":-5,"_125":126,"_16":127,"_128":-5,"_129":-5,"_130":-5,"_131":-5,"_132":133,"_134":133,"_135":136,"_137":136,"_138":136,"_139":133,"_140":133,"_23":228,"_144":229,"_149":230,"_161":22},["D",1776339053170],{"_100":101,"_142":143},{"_100":101,"_146":143,"_14":120,"_147":148},{"_106":151,"_102":48,"_110":152,"_153":111,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":103,"_160":101},"changes",[233],{"_217":234,"_236":237,"_179":22,"_105":166,"_239":240},{"_167":168,"_102":166,"_175":176,"_177":178,"_112":235,"_171":107,"_170":152},["D",1776351530336],"previous",{"_167":168,"_102":166,"_175":176,"_177":238},"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n// ─── Database Setup ────────────────────────────────────────────────────────────\nasync function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS transactions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n symbol TEXT NOT NULL,\n name TEXT,\n market TEXT DEFAULT 'TH',\n type TEXT NOT NULL CHECK(type IN ('BUY','SELL')),\n shares REAL NOT NULL,\n price REAL NOT NULL,\n fee REAL DEFAULT 0,\n currency TEXT DEFAULT 'THB',\n date TEXT NOT NULL,\n notes TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS dividends (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n symbol TEXT NOT NULL,\n amount REAL NOT NULL,\n tax_withheld REAL DEFAULT 0,\n currency TEXT DEFAULT 'THB',\n ex_date TEXT NOT NULL,\n pay_date TEXT,\n notes TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )\n `);\n}\n\n// ─── Mock Price Feed ─────────────────────────────────────────────────────────\nfunction mockPrice(symbol: string): number {\n const prices: Record = {\n PTT: 35.25, KBANK: 142.5, AOT: 68.75, SCB: 108.0, CPALL: 62.25,\n ADVANC: 198.0, GULF: 41.5, BTS: 6.85, TRUE: 8.3, SCC: 225.0,\n AAPL: 175.5, MSFT: 415.2, GOOGL: 175.8, NVDA: 875.4, TSLA: 245.3,\n AMZN: 185.6, META: 505.8, VTI: 245.0, QQQ: 438.0,\n };\n return prices[symbol.toUpperCase()] ?? 100 + Math.random() * 100;\n}\n\n// ─── Portfolio Calculator ──────────────────────────────────────────────────────\nasync function calcPortfolio() {\n const r = await sqlite.execute(`\n SELECT symbol, name, market, currency,\n SUM(CASE WHEN type='BUY' THEN shares ELSE -shares END) AS net_shares,\n SUM(CASE WHEN type='BUY' THEN shares*price+fee ELSE -(shares*price-fee) END) AS net_cost,\n SUM(CASE WHEN type='SELL' THEN shares*price-fee ELSE 0 END) AS realized\n FROM transactions\n GROUP BY symbol, market, currency\n HAVING net_shares > 0.0001\n ORDER BY net_cost DESC\n `);\n\n let totalMV = 0, totalCost = 0, totalRealized = 0;\n const holdings = r.rows.map((row) => {\n const [symbol, name, market, currency, shares, cost, realized] = row as [\n string, string, string, string, number, number, number,\n ];\n const price = mockPrice(symbol);\n const mv = shares * price;\n const upl = mv - cost;\n const uplPct = cost > 0 ? (upl / cost) * 100 : 0;\n totalMV += mv;\n totalCost += cost;\n totalRealized += realized ?? 0;\n return {\n symbol, name: name || symbol, market, currency, shares,\n avgCost: cost / shares, currentPrice: price, marketValue: mv,\n cost, unrealizedPL: upl, unrealizedPLPct: uplPct, realized: realized ?? 0,\n };\n });\n\n return {\n holdings, totalValue: totalMV, totalCost,\n totalPL: totalMV - totalCost,\n totalPLPct: totalCost > 0 ? ((totalMV - totalCost) / totalCost) * 100 : 0,\n totalRealized,\n };\n}\n\n// ─── HTML Shell ───────────────────────────────────────────────────────────────\nfunction html(): string {\n const sourceUrl = parseVal().links.self.val;\n return `\n\n\n\n\nWealthTrack — Investment Portfolio\n\n\n\n\n\n\n\n

\n\n\n\n\n\n\n\n\n

\n \n\n \n

กำลังโหลด…

\n \n Asset Allocation\n

\n \n กำไร/ขาดทุน รายตัว\n

Holdings

ราคาจาก mock feed (ต่อ production: Yahoo Finance / Settrade)

💎

ยังไม่มีข้อมูล

เพิ่มรายการซื้อขายเพื่อเริ่มติดตามพอร์ต

\n\n \n \n\n \n \n\n \n \n\n \n \n\n

\n\n

\n\n\n\n`;\n}\n\n// ─── Main HTTP Handler ─────────────────────────────────────────────────────────\nexport default async function (req: Request): Promise {\n await initDB();\n const url = new URL(req.url);\n const path = url.pathname;\n const method = req.method;\n\n const json = (data: unknown, status = 200) =>\n new Response(JSON.stringify(data), {\n status,\n headers: { \"Content-Type\": \"application/json\" },\n });\n\n // ── GET /api/portfolio\n if (path === \"/api/portfolio\" && method === \"GET\") {\n return json(await calcPortfolio());\n }\n\n // ── GET /api/transactions\n if (path === \"/api/transactions\" && method === \"GET\") {\n const r = await sqlite.execute(\n \"SELECT id,symbol,name,market,type,shares,price,fee,currency,date,notes FROM transactions ORDER BY date DESC, id DESC\",\n );\n return json(r.rows);\n }\n\n // ── POST /api/transactions\n if (path === \"/api/transactions\" && method === \"POST\") {\n const b = await req.json();\n await sqlite.execute(\n \"INSERT INTO transactions(symbol,name,market,type,shares,price,fee,currency,date,notes) VALUES(?,?,?,?,?,?,?,?,?,?)\",\n [b.symbol, b.name || b.symbol, b.market || \"TH\", b.type, b.shares, b.price, b.fee ?? 0, b.currency || \"THB\", b.date, b.notes || \"\"],\n );\n return json({ ok: true });\n }\n\n // ── DELETE /api/transactions/:id\n if (path.startsWith(\"/api/transactions/\") && method === \"DELETE\") {\n const id = path.split(\"/\").pop();\n await sqlite.execute(\"DELETE FROM transactions WHERE id=?\", [id]);\n return json({ ok: true });\n }\n\n // ── GET /api/dividends\n if (path === \"/api/dividends\" && method === \"GET\") {\n const r = await sqlite.execute(\n \"SELECT id,symbol,amount,tax_withheld,currency,ex_date,pay_date,notes FROM dividends ORDER BY ex_date DESC\",\n );\n return json(r.rows);\n }\n\n // ── POST /api/dividends\n if (path === \"/api/dividends\" && method === \"POST\") {\n const b = await req.json();\n await sqlite.execute(\n \"INSERT INTO dividends(symbol,amount,tax_withheld,currency,ex_date,pay_date,notes) VALUES(?,?,?,?,?,?,?)\",\n [b.symbol, b.amount, b.tax_withheld ?? 0, b.currency || \"THB\", b.ex_date, b.pay_date || \"\", b.notes || \"\"],\n );\n return json({ ok: true });\n }\n\n // ── DELETE /api/dividends/:id\n if (path.startsWith(\"/api/dividends/\") && method === \"DELETE\") {\n const id = path.split(\"/\").pop();\n await sqlite.execute(\"DELETE FROM dividends WHERE id=?\", [id]);\n return json({ ok: true });\n }\n\n // ── POST /api/chat\n if (path === \"/api/chat\" && method === \"POST\") {\n const b = await req.json();\n const key = Deno.env.get(\"ANTHROPIC_API_KEY\") ?? \"\";\n if (!key) {\n return json({\n reply: \"⚠️ กรุณาตั้งค่า ANTHROPIC_API_KEY ใน Val.town Environment Variables ก่อน\",\n });\n }\n\n const r = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"x-api-key\": key,\n \"anthropic-version\": \"2023-06-01\",\n },\n body: JSON.stringify({\n model: \"claude-sonnet-4-20250514\",\n max_tokens: 1024,\n system: `คุณคือที่ปรึกษาการลงทุนผู้เชี่ยวชาญ ตอบเป็นภาษาไทย วิเคราะห์หุ้นไทยและต่างประเทศ \nให้ความรู้ด้านการวิเคราะห์ทางเทคนิค (RSI, MACD, Moving Average) และปัจจัยพื้นฐาน \nตอบกระชับ ชัดเจน และมีประโยชน์ พร้อมตัวเลขและข้อมูลเมื่อเป็นไปได้`,\n messages: b.messages ?? [],\n }),\n });\n const d = await r.json();\n const reply = d.content?.[0]?.text ?? \"ไม่สามารถตอบได้ในขณะนี้\";\n return json({ reply });\n }\n\n // ── GET /source\n if (path === \"/source\") {\n return new Response(null, {\n status: 302,\n headers: { Location: parseVal().links.self.val },\n });\n }\n\n // ── Serve HTML\n return new Response(html(), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","latestPath","Wealthtrack.ts","actionData","errors"]

purinut1997

untitled-8871