WealthTrack

\n\n

\n \n\n \n

กำลังโหลด…

Asset Allocation

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

Holdings

ดึงราคาจาก Yahoo Finance · ราคาสด ราคาเก่า

⬡

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

\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 const json = (data: unknown, status = 200) =>\n new Response(JSON.stringify(data), { status, headers: { \"Content-Type\": \"application/json\" } });\n\n // ── GET /api/portfolio?base=THB ─────────────────────────────────────────────\n if (path === \"/api/portfolio\" && method === \"GET\") {\n const base = url.searchParams.get(\"base\") || \"THB\";\n return json(await calcPortfolio(base));\n }\n\n // ── GET /api/price?symbol=PTT&market=TH ────────────────────────────────────\n if (path === \"/api/price\" && method === \"GET\") {\n const symbol = url.searchParams.get(\"symbol\") || \"\";\n const market = url.searchParams.get(\"market\") || \"US\";\n const result = await getPrice(symbol, market);\n return json(result);\n }\n\n // ── GET /api/prices ─────────────────────────────────────────────────────────\n if (path === \"/api/prices\" && method === \"GET\") {\n const r = await sqlite.execute(\n \"SELECT symbol,price,currency,source,fetched_at FROM price_cache ORDER BY fetched_at DESC\"\n );\n return json(r.rows);\n }\n\n // ── POST /api/prices/refresh ────────────────────────────────────────────────\n if (path === \"/api/prices/refresh\" && method === \"POST\") {\n const result = await refreshAllPrices();\n return json(result);\n }\n\n // ── GET /api/fx ──────────────────────────────────────────────────────────────\n if (path === \"/api/fx\" && method === \"GET\") {\n const r = await sqlite.execute(\n \"SELECT pair,rate,fetched_at FROM fx_cache ORDER BY fetched_at DESC\"\n );\n return json(r.rows);\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 // Also cache price\n await sqlite.execute(\n \"INSERT OR IGNORE INTO price_cache(symbol,price,currency,source,fetched_at) VALUES(?,?,?,?,datetime('now','-13 hours'))\",\n [b.symbol, b.price, b.currency || \"THB\", \"manual\"]\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) return json({ reply: \"⚠️ กรุณาตั้งค่า ANTHROPIC_API_KEY ใน Val.town Environment Variables ก่อน\" });\n\n const portfolioContext = b.portfolioSummary\n ? `\\n\\nพอร์ตปัจจุบันของผู้ใช้: ${b.portfolioSummary.holdings} หุ้น, มูลค่ารวม ${b.portfolioSummary.totalValue?.toFixed(2)} ${b.portfolioSummary.baseCurrency}, กำไร/ขาดทุน ${b.portfolioSummary.totalPL?.toFixed(2)} ${b.portfolioSummary.baseCurrency}`\n : \"\";\n\n const r = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", \"x-api-key\": key, \"anthropic-version\": \"2023-06-01\" },\n body: JSON.stringify({\n model: \"claude-opus-4-5\",\n max_tokens: 1024,\n system: `คุณคือที่ปรึกษาการลงทุนผู้เชี่ยวชาญ ตอบเป็นภาษาไทย วิเคราะห์หุ้นไทยและต่างประเทศ\nให้ความรู้ด้านการวิเคราะห์ทางเทคนิค (RSI, MACD, Moving Average) และปัจจัยพื้นฐาน\nตอบกระชับ ชัดเจน และมีประโยชน์ พร้อมตัวเลขและข้อมูลเมื่อเป็นไปได้${portfolioContext}`,\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 // ── Serve HTML ──────────────────────────────────────────────────────────────\n return new Response(html(), { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n}","deleted","label","children",[],[106],"files",[165],"counts",{"_188":33,"_189":127,"_190":33,"_191":192,"_195":196},"pulls","branches","forks","envVars",{"_193":33,"_194":33},"count","emptyCount","connections",{"_193":33,"_197":33},"unfilledCount","contents",[],"file",{"_111":166,"_102":106,"_167":168,"_169":-5,"_170":153,"_171":108,"_172":22,"_113":202,"_107":174,"_175":176,"_177":178,"_179":22,"_180":-5,"_105":203},["D",1776354600960],[106],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_100":101,"_102":103,"_104":48,"_107":108,"_105":106,"_109":212,"_163":217,"_184":222,"_200":223,"_198":226,"_227":-5,"_228":-5,"_229":-5,"_230":-5,"_231":232,"_191":-5},{"_111":112,"_102":103,"_113":213,"_115":-5,"_116":22,"_117":118,"_119":-5,"_120":-5,"_14":121,"_122":-5,"_123":22,"_124":-5,"_125":-5,"_126":127,"_16":128,"_129":-5,"_130":-5,"_131":-5,"_132":-5,"_133":134,"_135":134,"_136":137,"_138":137,"_139":137,"_140":134,"_141":134,"_23":214,"_145":215,"_150":216,"_162":22},["D",1776339053170],{"_100":101,"_143":144},{"_100":101,"_147":144,"_14":121,"_148":149},{"_107":152,"_102":48,"_111":153,"_154":112,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":103,"_161":101},[218],{"_111":166,"_102":106,"_167":168,"_169":-5,"_170":153,"_171":108,"_172":22,"_113":219,"_107":174,"_175":176,"_177":178,"_179":22,"_180":-5,"_181":220,"_105":221},["D",1776354600960],[],[106],[218],{"_111":166,"_102":106,"_167":168,"_169":-5,"_170":153,"_171":108,"_172":22,"_113":224,"_107":174,"_175":176,"_177":178,"_179":22,"_180":-5,"_105":225},["D",1776354600960],[106],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

purinut1997

untitled-8871