[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_163":164,"_165":166},"routes/_app.x.$handle.$name",{"_105":104,"_38":51,"_112":95,"_33":59,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_26":-5,"_123":-5,"_124":-5,"_125":31,"_126":127,"_128":64,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","a6d84cdf-959c-4937-84e6-cb40d2f1d761","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","0e8ee5ea-844d-11f1-83ea-1607ee4eb77e","name","fileType","http","content","/**\n * Portfolio Risk Analysis — Weekly Performance, Drawdown & Attribution\n * =====================================================================\n * Val Town (Deno) port of the Python version. Same logic, ported to\n * TypeScript because val.town runs Deno/TypeScript, not Python.\n *\n * WHAT THIS VAL DOES\n * -------------------\n * 1. Uses the model allocations embedded below (from\n * SecurityModelAllocationsExport_07172026.xlsx — Model Name, Symbol,\n * Allocation %). No file upload needed; the data is baked in so this\n * val is self-contained. Swap ALLOCATIONS for a fetch() from a blob\n * or Google Sheet if you want it to stay live.\n * 2. Pulls daily prices from Alpha Vantage for every unique ticker.\n * 3. Falls back to Yahoo Finance's public chart endpoint (no key needed)\n * for any symbol Alpha Vantage doesn't cover — mostly mutual fund NAV\n * tickers.\n * 4. Computes weekly performance, max drawdown, and attribution\n * (biggest detractor / benefactor) per model.\n * 5. Builds a relative-performance sleeve: every individual stock in the\n * LEADERBOARD model vs. SPY.\n * 6. Returns a plain-text CFA-style memo (default) or JSON (?format=json).\n *\n * ALPHA VANTAGE FREE TIER — IMPORTANT\n * -------------------------------------\n * - Free tier: 5 calls/min, 25 calls/day. This universe has ~90 unique\n * tickers, so you will NOT finish in one run/one day on the free tier.\n * - This val uses Val Town's built-in blob storage (std/blob) to cache\n * every fetched symbol AND to track how many AV calls have been made\n * today. That means you can hit this val's URL repeatedly (e.g. once\n * a day, or via a cron trigger) and it will pick up where it left off\n * — already-cached symbols are never re-fetched.\n * - Set your key as a val.town environment variable named\n * ALPHAVANTAGE_API_KEY (Settings -> Environment Variables), not in code.\n *\n * USAGE\n * -----\n * GET / -> runs the analysis, returns text memo\n * GET /?format=json -> returns the full result as JSON\n * GET /?demo=1 -> synthetic data, no network calls, no key needed\n * GET /?resetCache=1 -> clears the blob cache before running\n */\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// --------------------------------------------------------------------------\n// Embedded allocation data (from SecurityModelAllocationsExport_07172026.xlsx)\n// --------------------------------------------------------------------------\ntype Holding = { model: string; symbol: string; weight: number };\n\nconst ALLOCATIONS: Holding[] = [\n {\n \"model\": \"MSWA Core - Dynamic Income\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"FDVV\", \"weight\": 15.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"SPYI\", \"weight\": 24.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"EFAA\", \"weight\": 7.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"IWMI\", \"weight\": 8.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"VCIT\", \"weight\": 10.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"PMOYX\", \"weight\": 13.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"NPSRX\", \"weight\": 8.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"FICVX\", \"weight\": 4.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"TPYP\", \"weight\": 5.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"EICOX\", \"weight\": 4.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"USD CASH\", \"weight\": 2.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"NNY\", \"weight\": 15.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"MANKX\", \"weight\": 10.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"PNYPX\", \"weight\": 18.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"ONYYX\", \"weight\": 10.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"ETIIX\", \"weight\": 12.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"OMFYX\", \"weight\": 18.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"NVHIX\", \"weight\": 7.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"FDUIX\", \"weight\": 8.0 },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"BSIIX\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"PMOYX\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"FICVX\",\n \"weight\": 9.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"VCSH\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"VCIT\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"IEF\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"CMNIX\",\n \"weight\": 17.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"SFLR\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"GLDM\",\n \"weight\": 4.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"SGIIX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"DGRW\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"SPYI\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"VUG\", \"weight\": 21.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"VTV\", \"weight\": 20.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"VO\", \"weight\": 15.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"XLB\", \"weight\": 5.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"XLV\", \"weight\": 5.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"FTXSX\", \"weight\": 7.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"EICOX\", \"weight\": 7.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"VEA\", \"weight\": 18.0 },\n {\n \"model\": \"MSWA CORE - FOCUSED INCOME\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"ACGYX\", \"weight\": 6.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"VCIT\", \"weight\": 12.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"IEF\", \"weight\": 9.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"BSIIX\", \"weight\": 12.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"ADVNX\", \"weight\": 12.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"PMOYX\", \"weight\": 16.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"AGEYX\", \"weight\": 10.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"PPSIX\", \"weight\": 7.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"VTIP\", \"weight\": 5.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"TPYP\", \"weight\": 9.0 },\n {\n \"model\": \"MSWA CORE - REAL ESTATE PLUS\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"RQI\", \"weight\": 17.5 },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"RFI\", \"weight\": 17.5 },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"MORT\", \"weight\": 12.5 },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"XLRE\", \"weight\": 17.5 },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"AWP\", \"weight\": 17.5 },\n {\n \"model\": \"MSWA CORE - REAL ESTATE PLUS\",\n \"symbol\": \"SIIIX\",\n \"weight\": 15.5,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"QQQ\",\n \"weight\": 23.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"IGM\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"SOXX\",\n \"weight\": 20.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"AIQ\",\n \"weight\": 15.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"CIBR\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"QTUM\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"XTL\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA Core - Downside Risk HELO JPM ETF\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n {\n \"model\": \"MSWA Core - Downside Risk HELO JPM ETF\",\n \"symbol\": \"HELO\",\n \"weight\": 100.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"RSP\",\n \"weight\": 11.0,\n },\n { \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\", \"symbol\": \"VUG\", \"weight\": 8.0 },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"GARP\",\n \"weight\": 12.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"RWK\",\n \"weight\": 12.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"CTSIX\",\n \"weight\": 6.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"IDMO\",\n \"weight\": 9.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"EICOX\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"VCIT\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"AGEYX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"SGIIX\",\n \"weight\": 15.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"HGER\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - DOWNSIDE RISK AWARE 2 JPM HEDGE\",\n \"symbol\": \"JHEQX\",\n \"weight\": 99.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - DOWNSIDE RISK AWARE 2 JPM HEDGE\",\n \"symbol\": \"USD CASH\",\n \"weight\": 1.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"VUG\",\n \"weight\": 21.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"VTV\",\n \"weight\": 20.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"VO\",\n \"weight\": 15.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"XLB\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"XLV\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"FTXSX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"EICOX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"VEA\",\n \"weight\": 18.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE - JP MORGAN HEDGED EQUITY\",\n \"symbol\": \"JHEQX\",\n \"weight\": 98.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE - JP MORGAN HEDGED EQUITY\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE JPM HEDGED SERIES II\",\n \"symbol\": \"JHQDX\",\n \"weight\": 100.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE JPM HEDGED SERIES II\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE JPM HEDGED SERIES II\",\n \"symbol\": \"JHQDX\",\n \"weight\": 100.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE JPM HEDGED SERIES II\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"FDVV\",\n \"weight\": 15.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"SPYI\",\n \"weight\": 24.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"IWMI\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"EFAA\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"VCIT\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"PMOYX\",\n \"weight\": 13.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"NPSRX\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"FICVX\",\n \"weight\": 4.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"TPYP\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"EICOX\",\n \"weight\": 4.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - SENTINEL\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - DOWNSIDE RISK AWARE SWAN\",\n \"symbol\": \"HEGD\",\n \"weight\": 100.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - DOWNSIDE RISK AWARE SWAN\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"ABBV\", \"weight\": 2.33 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AMGN\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AXP\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"LMT\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"HD\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"MCK\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"SCHW\", \"weight\": 2.5 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"SYK\", \"weight\": 2.32 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"WM\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AMZN\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AAPL\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"COST\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"MSFT\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"GOOGL\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"CBOE\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"LDOS\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AVGO\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"CRWD\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"ANET\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"NVDA\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"USD CASH\", \"weight\": 2.0 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"ETN\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"RIO\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"HON\", \"weight\": 2.5 },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"FEZ\",\n \"weight\": 9.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"EICOX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"RSPU\",\n \"weight\": 6.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"ITA\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"VGT\",\n \"weight\": 10.5,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"FELIX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"AIWEX\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"FBTIX\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"DGRW\",\n \"weight\": 23.5,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"VO\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"CTSIX\",\n \"weight\": 10.0,\n },\n];\n\nconst BENCHMARK = \"SPY\";\nconst CALLS_PER_DAY_BUDGET = 25;\nconst SECONDS_BETWEEN_CALLS = 13;\n\n// --------------------------------------------------------------------------\n// Universe helpers\n// --------------------------------------------------------------------------\nfunction getUniverse(allocations: Holding[]) {\n const allSyms = Array.from(new Set(allocations.map((h) => h.symbol))).filter(\n (s) => s !== \"USD CASH\"\n ).sort();\n const leaderboard = allocations.filter((h) =>\n h.model.toUpperCase().includes(\"LEADERBOARD\")\n );\n const equityStocks = Array.from(new Set(leaderboard.map((h) => h.symbol)))\n .filter((s) => s !== \"USD CASH\").sort();\n return { allSyms, equityStocks };\n}\n\nfunction classifySymbol(\n symbol: string,\n equityStocks: string[],\n): \"equity\" | \"etf\" | \"mutual_fund\" {\n if (equityStocks.includes(symbol) || symbol === BENCHMARK) return \"equity\";\n if (symbol.length === 5 && symbol.endsWith(\"X\")) return \"mutual_fund\";\n return \"etf\";\n}\n\nfunction prioritizedSymbolList(allSyms: string[], equityStocks: string[]) {\n const syms = new Set([...allSyms, BENCHMARK]);\n const buckets = {\n equity: [] as string[],\n etf: [] as string[],\n mutual_fund: [] as string[],\n };\n for (const s of syms) buckets[classifySymbol(s, equityStocks)].push(s);\n return [\n ...buckets.equity.sort(),\n ...buckets.etf.sort(),\n ...buckets.mutual_fund.sort(),\n ];\n}\n\n// --------------------------------------------------------------------------\n// Price fetching — Alpha Vantage primary, Yahoo Finance fallback\n// Cached + rate-limited via Val Town blob storage (persists across runs)\n// --------------------------------------------------------------------------\ntype PriceSeries = Record; // ISO date -> close\n\nasync function getCallState(): Promise<{ date: string; calls_made: number }> {\n const today = new Date().toISOString().slice(0, 10);\n const state = await blob.getJSON(\"pra:call_state\") as {\n date: string;\n calls_made: number;\n } | undefined;\n if (state && state.date === today) return state;\n return { date: today, calls_made: 0 };\n}\n\nasync function saveCallState(state: { date: string; calls_made: number }) {\n await blob.setJSON(\"pra:call_state\", state);\n}\n\nasync function fetchAlphaVantage(\n symbol: string,\n apiKey: string,\n state: { date: string; calls_made: number },\n): Promise {\n const cacheKey = `pra:cache:${symbol}`;\n const cached = await blob.getJSON(cacheKey) as {\n fetchedAt: string;\n data: PriceSeries | null;\n } | undefined;\n if (cached) {\n const ageHours = (Date.now() - new Date(cached.fetchedAt).getTime()) /\n 3.6e6;\n if (ageHours < 20) return cached.data;\n }\n\n if (state.calls_made >= CALLS_PER_DAY_BUDGET) {\n throw new Error(\n `Daily Alpha Vantage call budget (${CALLS_PER_DAY_BUDGET}) reached. ` +\n `Re-run later (today's cache is preserved) — already-cached symbols won't be re-fetched.`,\n );\n }\n\n const url =\n `https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=${symbol}&outputsize=compact&apikey=${apiKey}`;\n const resp = await fetch(url);\n const data = await resp.json();\n\n state.calls_made += 1;\n await saveCallState(state);\n await new Promise((r) => setTimeout(r, SECONDS_BETWEEN_CALLS * 1000));\n\n const ts = data[\"Time Series (Daily)\"];\n if (!ts) {\n await blob.setJSON(cacheKey, {\n fetchedAt: new Date().toISOString(),\n data: null,\n });\n return null;\n }\n\n const closes: PriceSeries = {};\n for (const [date, vals] of Object.entries(ts as Record)) {\n closes[date] = parseFloat(vals[\"4. close\"]);\n }\n await blob.setJSON(cacheKey, {\n fetchedAt: new Date().toISOString(),\n data: closes,\n });\n return closes;\n}\n\nasync function fetchYahooFinance(symbol: string): Promise {\n try {\n const url =\n `https://query1.finance.yahoo.com/v8/finance/chart/${symbol}?range=1mo&interval=1d`;\n const resp = await fetch(url, { headers: { \"User-Agent\": \"Mozilla/5.0\" } });\n if (!resp.ok) return null;\n const data = await resp.json();\n const result = data?.chart?.result?.[0];\n if (!result) return null;\n\n const timestamps: number[] = result.timestamp;\n const closes: number[] = result.indicators?.quote?.[0]?.close;\n if (!timestamps || !closes) return null;\n\n const series: PriceSeries = {};\n timestamps.forEach((ts, i) => {\n if (closes[i] != null) {\n const date = new Date(ts * 1000).toISOString().slice(0, 10);\n series[date] = closes[i];\n }\n });\n return Object.keys(series).length ? series : null;\n } catch {\n return null;\n }\n}\n\nasync function fetchUniverse(\n symbols: string[],\n apiKey: string,\n demo: boolean,\n useFallback = true,\n) {\n const prices: Record = {};\n const skipped: { symbol: string; source_tried: string }[] = [];\n\n if (demo) {\n // Synthetic data — deterministic pseudo-random walk, no network needed.\n const dates: string[] = [];\n const d = new Date();\n while (dates.length < 10) {\n if (d.getDay() !== 0 && d.getDay() !== 6) {\n dates.unshift(d.toISOString().slice(0, 10));\n }\n d.setDate(d.getDate() - 1);\n }\n let seed = 42;\n const rand = () => {\n seed = (seed * 9301 + 49297) % 233280;\n return seed / 233280;\n };\n for (const sym of symbols) {\n const drift = (rand() - 0.5) * 0.03;\n const vol = 0.005 + rand() * 0.025;\n let price = 20 + rand() * 480;\n const series: PriceSeries = {};\n for (const date of dates) {\n series[date] = price;\n price = price * (1 + drift + (rand() - 0.5) * vol * 2);\n }\n prices[sym] = series;\n }\n return { prices, skipped };\n }\n\n const state = await getCallState();\n let avBudgetExhausted = false;\n for (const sym of symbols) {\n let series: PriceSeries | null = null;\n let source = \"alpha_vantage\";\n try {\n if (avBudgetExhausted) {\n // Skip AV entirely — go straight to Yahoo Finance\n series = null;\n } else {\n series = await fetchAlphaVantage(sym, apiKey, state);\n }\n } catch (e) {\n console.log(`[AV BUDGET] ${(e as Error).message} — switching to Yahoo Finance for remaining symbols.`);\n avBudgetExhausted = true;\n }\n\n if (series === null && useFallback) {\n series = await fetchYahooFinance(sym);\n source = series ? \"yfinance_endpoint\" : \"none\";\n }\n\n if (series === null) {\n skipped.push({\n symbol: sym,\n source_tried: useFallback ? \"alpha_vantage,yahoo\" : \"alpha_vantage\",\n });\n console.log(`[skip] ${sym}: no data from any source`);\n } else {\n prices[sym] = series;\n console.log(\n `[ok] ${sym}: ${Object.keys(series).length} closes (${source})`,\n );\n }\n }\n\n return { prices, skipped };\n}\n\n// --------------------------------------------------------------------------\n// Analysis: weekly return, drawdown, attribution, relative performance\n// --------------------------------------------------------------------------\nfunction weeklyWindow(\n prices: Record,\n lookbackDays = 5,\n): string[] {\n const ref = prices[BENCHMARK]\n ? Object.keys(prices[BENCHMARK])\n : Array.from(new Set(Object.values(prices).flatMap((s) => Object.keys(s))));\n return ref.sort().slice(-lookbackDays);\n}\n\nfunction buildPriceTable(\n prices: Record,\n window: string[],\n) {\n // symbol -> array of closes aligned to window (forward/back filled)\n const table: Record = {};\n for (const [sym, series] of Object.entries(prices)) {\n const vals: number[] = [];\n let last: number | null = null;\n for (const date of window) {\n if (series[date] != null) last = series[date];\n vals.push(last as number);\n }\n // back-fill leading nulls\n let firstKnown: number | null = null;\n for (const v of vals) {\n if (v != null) {\n firstKnown = v;\n break;\n }\n }\n for (let i = 0; i < vals.length; i++) {\n if (vals[i] == null) vals[i] = firstKnown as number;\n }\n table[sym] = vals;\n }\n return table;\n}\n\nfunction weeklyReturn(closes: number[]): number | null {\n const valid = closes.filter((v) => v != null && !isNaN(v));\n if (valid.length < 2) return null;\n return valid[valid.length - 1] / valid[0] - 1;\n}\n\nfunction modelIndexAndWeights(\n allocations: Holding[],\n modelName: string,\n priceTable: Record,\n windowLen: number,\n) {\n const rows = allocations.filter((h) => h.model === modelName);\n const weights: Record = {};\n for (const row of rows) {\n if (row.symbol === \"USD CASH\" || !priceTable[row.symbol]) continue;\n weights[row.symbol] = (weights[row.symbol] || 0) + row.weight / 100;\n }\n if (Object.keys(weights).length === 0) return null;\n\n const index = new Array(windowLen).fill(100);\n for (let t = 1; t < windowLen; t++) {\n let portRet = 0;\n for (const [sym, w] of Object.entries(weights)) {\n const prev = priceTable[sym][t - 1];\n const cur = priceTable[sym][t];\n const dailyRet = prev ? cur / prev - 1 : 0;\n portRet += w * dailyRet;\n }\n index[t] = index[t - 1] * (1 + portRet);\n }\n return { index, weights };\n}\n\nfunction maxDrawdown(index: number[]): number {\n let runningMax = -Infinity;\n let maxDD = 0;\n for (const v of index) {\n runningMax = Math.max(runningMax, v);\n const dd = v / runningMax - 1;\n if (dd < maxDD) maxDD = dd;\n }\n return maxDD;\n}\n\nfunction analyze(\n allocations: Holding[],\n priceTable: Record,\n window: string[],\n) {\n const modelNames = Array.from(new Set(allocations.map((h) => h.model)));\n const modelRows: any[] = [];\n const contributions: any[] = [];\n\n for (const model of modelNames) {\n const result = modelIndexAndWeights(\n allocations,\n model,\n priceTable,\n window.length,\n );\n if (!result) continue;\n const { index, weights } = result;\n\n const weekRet = index[index.length - 1] / index[0] - 1;\n const dd = maxDrawdown(index);\n\n modelRows.push({\n Model: model,\n \"Weekly Return %\": Math.round(weekRet * 10000) / 100,\n \"Max Drawdown (this week) %\": Math.round(dd * 10000) / 100,\n \"Holdings Priced\": Object.keys(weights).length,\n });\n\n for (const [sym, w] of Object.entries(weights)) {\n const r = weeklyReturn(priceTable[sym]);\n if (r == null) continue;\n contributions.push({\n Model: model,\n Symbol: sym,\n \"Weight %\": Math.round(w * 10000) / 100,\n \"Weekly Return %\": Math.round(r * 10000) / 100,\n \"Contribution (pp)\": Math.round(w * r * 100000) / 1000,\n });\n }\n }\n\n modelRows.sort((a, b) => a[\"Weekly Return %\"] - b[\"Weekly Return %\"]);\n return { modelRows, contributions };\n}\n\nfunction relativePerformanceSleeve(\n priceTable: Record,\n equityStocks: string[],\n) {\n const spyRow = priceTable[BENCHMARK];\n const spyRet = spyRow ? weeklyReturn(spyRow) : null;\n const summary: any[] = [];\n\n for (const sym of equityStocks) {\n if (!priceTable[sym]) continue;\n const r = weeklyReturn(priceTable[sym]);\n if (r == null || spyRet == null) continue;\n summary.push({\n Symbol: sym,\n \"Weekly Return %\": Math.round(r * 10000) / 100,\n \"SPY Weekly Return %\": Math.round(spyRet * 10000) / 100,\n \"Relative to SPY (pp)\": Math.round((r - spyRet) * 10000) / 100,\n });\n }\n summary.sort((a, b) => b[\"Relative to SPY (pp)\"] - a[\"Relative to SPY (pp)\"]);\n return summary;\n}\n\n// --------------------------------------------------------------------------\n// CFA-style memo\n// --------------------------------------------------------------------------\nfunction tableToText(rows: any[]): string {\n if (!rows.length) return \"(no data)\";\n const cols = Object.keys(rows[0]);\n const widths = cols.map((c) =>\n Math.max(c.length, ...rows.map((r) => String(r[c]).length))\n );\n const line = (vals: string[]) =>\n vals.map((v, i) => v.padStart(widths[i])).join(\" \");\n return [\n line(cols),\n ...rows.map((r) => line(cols.map((c, i) => String(r[c])))),\n ].join(\"\\n\");\n}\n\nfunction writeMemo(\n modelRows: any[],\n contributions: any[],\n relRows: any[],\n window: string[],\n) {\n const worst = modelRows.reduce((\n a,\n b,\n ) => (a[\"Max Drawdown (this week) %\"] < b[\"Max Drawdown (this week) %\"]\n ? a\n : b)\n );\n const modelContribs = contributions.filter((c) => c.Model === worst.Model)\n .sort((a, b) => a[\"Contribution (pp)\"] - b[\"Contribution (pp)\"]);\n const detractor = modelContribs[0];\n const benefactor = modelContribs[modelContribs.length - 1];\n const bestRel = relRows[0];\n const worstRel = relRows[relRows.length - 1];\n\n const lines: string[] = [];\n lines.push(\"WEEKLY PORTFOLIO RISK MEMO\");\n lines.push(`Window: ${window[0]} to ${window[window.length - 1]}`);\n lines.push(\"Prepared by: Research Analyst, CFA\");\n lines.push(\"=\".repeat(70));\n lines.push(\"\");\n lines.push(\"1. MODEL PERFORMANCE, RANKED WEAKEST TO STRONGEST\");\n lines.push(tableToText(modelRows));\n lines.push(\"\");\n lines.push(\"2. BIGGEST DRAWDOWN\");\n lines.push(\n `'${worst.Model}' posted the largest intra-week drawdown at ${\n worst[\"Max Drawdown (this week) %\"].toFixed(2)\n }%, on a weekly return of ${worst[\"Weekly Return %\"].toFixed(2)}%.`,\n );\n if (detractor) {\n lines.push(\n ` Biggest detractor: ${detractor.Symbol} (${\n detractor[\"Weight %\"].toFixed(2)\n }% weight, ${detractor[\"Weekly Return %\"].toFixed(2)}% return, ${\n detractor[\"Contribution (pp)\"].toFixed(3)\n }pp drag).`,\n );\n }\n if (benefactor) {\n lines.push(\n ` Biggest benefactor: ${benefactor.Symbol} (${\n benefactor[\"Weight %\"].toFixed(2)\n }% weight, ${benefactor[\"Weekly Return %\"].toFixed(2)}% return, ${\n benefactor[\"Contribution (pp)\"] >= 0 ? \"+\" : \"\"\n }${benefactor[\"Contribution (pp)\"].toFixed(3)}pp contribution).`,\n );\n }\n lines.push(\"\");\n lines.push(\"3. RELATIVE PERFORMANCE SLEEVE — EQUITY HOLDINGS VS. SPY\");\n lines.push(tableToText(relRows));\n if (bestRel && worstRel) {\n lines.push(\"\");\n lines.push(\n `Best relative performer: ${bestRel.Symbol} (${\n bestRel[\"Relative to SPY (pp)\"] >= 0 ? \"+\" : \"\"\n }${bestRel[\"Relative to SPY (pp)\"].toFixed(2)}pp vs. SPY).`,\n );\n lines.push(\n `Worst relative performer: ${worstRel.Symbol} (${\n worstRel[\"Relative to SPY (pp)\"] >= 0 ? \"+\" : \"\"\n }${worstRel[\"Relative to SPY (pp)\"].toFixed(2)}pp vs. SPY).`,\n );\n }\n lines.push(\"\");\n lines.push(\n \"Note: symbols with no coverage from Alpha Vantage or Yahoo Finance were excluded from return calcs.\",\n );\n return lines.join(\"\\n\");\n}\n\n// --------------------------------------------------------------------------\n// HTTP entrypoint (val.town)\n// --------------------------------------------------------------------------\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const demo = url.searchParams.get(\"demo\") === \"1\";\n const format = url.searchParams.get(\"format\") || \"text\";\n const resetCache = url.searchParams.get(\"resetCache\") === \"1\";\n\n if (resetCache) {\n const keys = await blob.list(\"pra:\");\n for (const k of keys) await blob.delete(k.key);\n }\n\n const apiKey = Deno.env.get(\"ALPHAVANTAGE_API_KEY\") || \"\";\n if (!demo && !apiKey) {\n return new Response(\n \"Set ALPHAVANTAGE_API_KEY as a val.town environment variable, or call with ?demo=1 to test.\",\n { status: 400 },\n );\n }\n\n const { allSyms, equityStocks } = getUniverse(ALLOCATIONS);\n const orderedSyms = prioritizedSymbolList(allSyms, equityStocks);\n\n const { prices, skipped } = await fetchUniverse(orderedSyms, apiKey, demo);\n\n if (!prices[BENCHMARK]) {\n console.log(\n \"WARNING: SPY not fetched yet — relative-performance sleeve will be incomplete. Re-run to continue (SPY is first in priority order).\",\n );\n }\n\n const window = weeklyWindow(prices);\n const priceTable = buildPriceTable(prices, window);\n\n const { modelRows, contributions } = analyze(ALLOCATIONS, priceTable, window);\n const relRows = relativePerformanceSleeve(priceTable, equityStocks);\n\n if (format === \"json\") {\n return new Response(\n JSON.stringify(\n { window, modelRows, contributions, relRows, skipped },\n null,\n 2,\n ),\n {\n headers: { \"content-type\": \"application/json\" },\n },\n );\n }\n\n const memo = writeMemo(modelRows, contributions, relRows, window);\n const skippedNote = skipped.length\n ? `\\n\\nSkipped symbols (no data from any source): ${\n skipped.map((s) => s.symbol).join(\", \")\n }`\n : \"\";\n return new Response(memo + skippedNote, {\n headers: { \"content-type\": \"text/plain\" },\n });\n}","/**\n * Portfolio Risk Analysis — Weekly Performance, Drawdown & Attribution\n * =====================================================================\n * Val Town (Deno) port of the Python version. Same logic, ported to\n * TypeScript because val.town runs Deno/TypeScript, not Python.\n *\n * WHAT THIS VAL DOES\n * -------------------\n * 1. Uses the model allocations embedded below (from\n * SecurityModelAllocationsExport_07172026.xlsx — Model Name, Symbol,\n * Allocation %). No file upload needed; the data is baked in so this\n * val is self-contained. Swap ALLOCATIONS for a fetch() from a blob\n * or Google Sheet if you want it to stay live.\n * 2. Pulls daily prices from Alpha Vantage for every unique ticker.\n * 3. Falls back to Yahoo Finance's public chart endpoint (no key needed)\n * for any symbol Alpha Vantage doesn't cover — mostly mutual fund NAV\n * tickers.\n * 4. Computes weekly performance, max drawdown, and attribution\n * (biggest detractor / benefactor) per model.\n * 5. Builds a relative-performance sleeve: every individual stock in the\n * LEADERBOARD model vs. SPY.\n * 6. Returns a plain-text CFA-style memo (default) or JSON (?format=json).\n *\n * ALPHA VANTAGE FREE TIER — IMPORTANT\n * -------------------------------------\n * - Free tier: 5 calls/min, 25 calls/day. This universe has ~90 unique\n * tickers, so you will NOT finish in one run/one day on the free tier.\n * - This val uses Val Town's built-in blob storage (std/blob) to cache\n * every fetched symbol AND to track how many AV calls have been made\n * today. That means you can hit this val's URL repeatedly (e.g. once\n * a day, or via a cron trigger) and it will pick up where it left off\n * — already-cached symbols are never re-fetched.\n * - Set your key as a val.town environment variable named\n * ALPHAVANTAGE_API_KEY (Settings -> Environment Variables), not in code.\n *\n * USAGE\n * -----\n * GET / -> runs the analysis, returns text memo\n * GET /?format=json -> returns the full result as JSON\n * GET /?demo=1 -> synthetic data, no network calls, no key needed\n * GET /?resetCache=1 -> clears the blob cache before running\n */\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// --------------------------------------------------------------------------\n// Embedded allocation data (from SecurityModelAllocationsExport_07172026.xlsx)\n// --------------------------------------------------------------------------\ntype Holding = { model: string; symbol: string; weight: number };\n\nconst ALLOCATIONS: Holding[] = [\n {\n \"model\": \"MSWA Core - Dynamic Income\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"FDVV\", \"weight\": 15.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"SPYI\", \"weight\": 24.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"EFAA\", \"weight\": 7.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"IWMI\", \"weight\": 8.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"VCIT\", \"weight\": 10.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"PMOYX\", \"weight\": 13.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"NPSRX\", \"weight\": 8.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"FICVX\", \"weight\": 4.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"TPYP\", \"weight\": 5.0 },\n { \"model\": \"MSWA Core - Dynamic Income\", \"symbol\": \"EICOX\", \"weight\": 4.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"USD CASH\", \"weight\": 2.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"NNY\", \"weight\": 15.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"MANKX\", \"weight\": 10.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"PNYPX\", \"weight\": 18.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"ONYYX\", \"weight\": 10.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"ETIIX\", \"weight\": 12.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"OMFYX\", \"weight\": 18.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"NVHIX\", \"weight\": 7.0 },\n { \"model\": \"MSWA CORE - TAX AWARE\", \"symbol\": \"FDUIX\", \"weight\": 8.0 },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"BSIIX\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"PMOYX\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"FICVX\",\n \"weight\": 9.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"VCSH\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"VCIT\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"IEF\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"CMNIX\",\n \"weight\": 17.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"SFLR\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"GLDM\",\n \"weight\": 4.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"SGIIX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"DGRW\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"SPYI\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - TACTICAL CAPITAL PRESERVATION\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"VUG\", \"weight\": 21.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"VTV\", \"weight\": 20.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"VO\", \"weight\": 15.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"XLB\", \"weight\": 5.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"XLV\", \"weight\": 5.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"FTXSX\", \"weight\": 7.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"EICOX\", \"weight\": 7.0 },\n { \"model\": \"MSWA CORE - PASSIVE + GROWTH\", \"symbol\": \"VEA\", \"weight\": 18.0 },\n {\n \"model\": \"MSWA CORE - FOCUSED INCOME\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"ACGYX\", \"weight\": 6.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"VCIT\", \"weight\": 12.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"IEF\", \"weight\": 9.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"BSIIX\", \"weight\": 12.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"ADVNX\", \"weight\": 12.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"PMOYX\", \"weight\": 16.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"AGEYX\", \"weight\": 10.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"PPSIX\", \"weight\": 7.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"VTIP\", \"weight\": 5.0 },\n { \"model\": \"MSWA CORE - FOCUSED INCOME\", \"symbol\": \"TPYP\", \"weight\": 9.0 },\n {\n \"model\": \"MSWA CORE - REAL ESTATE PLUS\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"RQI\", \"weight\": 17.5 },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"RFI\", \"weight\": 17.5 },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"MORT\", \"weight\": 12.5 },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"XLRE\", \"weight\": 17.5 },\n { \"model\": \"MSWA CORE - REAL ESTATE PLUS\", \"symbol\": \"AWP\", \"weight\": 17.5 },\n {\n \"model\": \"MSWA CORE - REAL ESTATE PLUS\",\n \"symbol\": \"SIIIX\",\n \"weight\": 15.5,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"QQQ\",\n \"weight\": 23.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"IGM\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"SOXX\",\n \"weight\": 20.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"AIQ\",\n \"weight\": 15.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"CIBR\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"QTUM\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - GROWTH & INNOVATION\",\n \"symbol\": \"XTL\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA Core - Downside Risk HELO JPM ETF\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n {\n \"model\": \"MSWA Core - Downside Risk HELO JPM ETF\",\n \"symbol\": \"HELO\",\n \"weight\": 100.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"RSP\",\n \"weight\": 11.0,\n },\n { \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\", \"symbol\": \"VUG\", \"weight\": 8.0 },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"GARP\",\n \"weight\": 12.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"RWK\",\n \"weight\": 12.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"CTSIX\",\n \"weight\": 6.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"IDMO\",\n \"weight\": 9.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"EICOX\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"VCIT\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"AGEYX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"SGIIX\",\n \"weight\": 15.0,\n },\n {\n \"model\": \"MSWA CORE - DIVERSIFIED GROWTH\",\n \"symbol\": \"HGER\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - DOWNSIDE RISK AWARE 2 JPM HEDGE\",\n \"symbol\": \"JHEQX\",\n \"weight\": 99.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - DOWNSIDE RISK AWARE 2 JPM HEDGE\",\n \"symbol\": \"USD CASH\",\n \"weight\": 1.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"VUG\",\n \"weight\": 21.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"VTV\",\n \"weight\": 20.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"VO\",\n \"weight\": 15.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"XLB\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"XLV\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"FTXSX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"EICOX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - PASSIVE + GROWTH - FAMILY\",\n \"symbol\": \"VEA\",\n \"weight\": 18.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE - JP MORGAN HEDGED EQUITY\",\n \"symbol\": \"JHEQX\",\n \"weight\": 98.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE - JP MORGAN HEDGED EQUITY\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE JPM HEDGED SERIES II\",\n \"symbol\": \"JHQDX\",\n \"weight\": 100.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE JPM HEDGED SERIES II\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE JPM HEDGED SERIES II\",\n \"symbol\": \"JHQDX\",\n \"weight\": 100.0,\n },\n {\n \"model\": \"MSWA CORE - DOWNSIDE RISK AWARE JPM HEDGED SERIES II\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"FDVV\",\n \"weight\": 15.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"SPYI\",\n \"weight\": 24.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"IWMI\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"EFAA\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"VCIT\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"PMOYX\",\n \"weight\": 13.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"NPSRX\",\n \"weight\": 8.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"FICVX\",\n \"weight\": 4.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"TPYP\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE- DYNAMIC INCOME FAMILY\",\n \"symbol\": \"EICOX\",\n \"weight\": 4.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - SENTINEL\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - DOWNSIDE RISK AWARE SWAN\",\n \"symbol\": \"HEGD\",\n \"weight\": 100.0,\n },\n {\n \"model\": \"MSWA CORE CAPITAL - DOWNSIDE RISK AWARE SWAN\",\n \"symbol\": \"USD CASH\",\n \"weight\": 0.0,\n },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"ABBV\", \"weight\": 2.33 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AMGN\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AXP\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"LMT\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"HD\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"MCK\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"SCHW\", \"weight\": 2.5 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"SYK\", \"weight\": 2.32 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"WM\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AMZN\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AAPL\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"COST\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"MSFT\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"GOOGL\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"CBOE\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"LDOS\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"AVGO\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"CRWD\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"ANET\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"NVDA\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"USD CASH\", \"weight\": 2.0 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"ETN\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"RIO\", \"weight\": 4.65 },\n { \"model\": \"MSWA CORE - LEADERBOARD\", \"symbol\": \"HON\", \"weight\": 2.5 },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"USD CASH\",\n \"weight\": 2.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"FEZ\",\n \"weight\": 9.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"EICOX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"RSPU\",\n \"weight\": 6.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"ITA\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"VGT\",\n \"weight\": 10.5,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"FELIX\",\n \"weight\": 7.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"AIWEX\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"FBTIX\",\n \"weight\": 5.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"DGRW\",\n \"weight\": 23.5,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"VO\",\n \"weight\": 10.0,\n },\n {\n \"model\": \"MSWA CORE - MARKET CYCLE APPRECIATION\",\n \"symbol\": \"CTSIX\",\n \"weight\": 10.0,\n },\n];\n\nconst BENCHMARK = \"SPY\";\nconst CALLS_PER_DAY_BUDGET = 25;\nconst SECONDS_BETWEEN_CALLS = 13;\n\n// --------------------------------------------------------------------------\n// Universe helpers\n// --------------------------------------------------------------------------\nfunction getUniverse(allocations: Holding[]) {\n const allSyms = Array.from(new Set(allocations.map((h) => h.symbol))).filter(\n (s) => s !== \"USD CASH\"\n ).sort();\n const leaderboard = allocations.filter((h) =>\n h.model.toUpperCase().includes(\"LEADERBOARD\")\n );\n const equityStocks = Array.from(new Set(leaderboard.map((h) => h.symbol)))\n .filter((s) => s !== \"USD CASH\").sort();\n return { allSyms, equityStocks };\n}\n\nfunction classifySymbol(\n symbol: string,\n equityStocks: string[],\n): \"equity\" | \"etf\" | \"mutual_fund\" {\n if (equityStocks.includes(symbol) || symbol === BENCHMARK) return \"equity\";\n if (symbol.length === 5 && symbol.endsWith(\"X\")) return \"mutual_fund\";\n return \"etf\";\n}\n\nfunction prioritizedSymbolList(allSyms: string[], equityStocks: string[]) {\n const syms = new Set([...allSyms, BENCHMARK]);\n const buckets = {\n equity: [] as string[],\n etf: [] as string[],\n mutual_fund: [] as string[],\n };\n for (const s of syms) buckets[classifySymbol(s, equityStocks)].push(s);\n return [\n ...buckets.equity.sort(),\n ...buckets.etf.sort(),\n ...buckets.mutual_fund.sort(),\n ];\n}\n\n// --------------------------------------------------------------------------\n// Price fetching — Alpha Vantage primary, Yahoo Finance fallback\n// Cached + rate-limited via Val Town blob storage (persists across runs)\n// --------------------------------------------------------------------------\ntype PriceSeries = Record; // ISO date -> close\n\nasync function getCallState(): Promise<{ date: string; calls_made: number }> {\n const today = new Date().toISOString().slice(0, 10);\n const state = await blob.getJSON(\"pra:call_state\") as {\n date: string;\n calls_made: number;\n } | undefined;\n if (state && state.date === today) return state;\n return { date: today, calls_made: 0 };\n}\n\nasync function saveCallState(state: { date: string; calls_made: number }) {\n await blob.setJSON(\"pra:call_state\", state);\n}\n\nasync function fetchAlphaVantage(\n symbol: string,\n apiKey: string,\n state: { date: string; calls_made: number },\n): Promise {\n const cacheKey = `pra:cache:${symbol}`;\n const cached = await blob.getJSON(cacheKey) as {\n fetchedAt: string;\n data: PriceSeries | null;\n } | undefined;\n if (cached) {\n const ageHours = (Date.now() - new Date(cached.fetchedAt).getTime()) /\n 3.6e6;\n if (ageHours < 20) return cached.data;\n }\n\n if (state.calls_made >= CALLS_PER_DAY_BUDGET) {\n throw new Error(\n `Daily Alpha Vantage call budget (${CALLS_PER_DAY_BUDGET}) reached. ` +\n `Re-run later (today's cache is preserved) — already-cached symbols won't be re-fetched.`,\n );\n }\n\n const url =\n `https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=${symbol}&outputsize=compact&apikey=${apiKey}`;\n const resp = await fetch(url);\n const data = await resp.json();\n\n state.calls_made += 1;\n await saveCallState(state);\n await new Promise((r) => setTimeout(r, SECONDS_BETWEEN_CALLS * 1000));\n\n const ts = data[\"Time Series (Daily)\"];\n if (!ts) {\n await blob.setJSON(cacheKey, {\n fetchedAt: new Date().toISOString(),\n data: null,\n });\n return null;\n }\n\n const closes: PriceSeries = {};\n for (const [date, vals] of Object.entries(ts as Record)) {\n closes[date] = parseFloat(vals[\"4. close\"]);\n }\n await blob.setJSON(cacheKey, {\n fetchedAt: new Date().toISOString(),\n data: closes,\n });\n return closes;\n}\n\nasync function fetchYahooFinance(symbol: string): Promise {\n try {\n const url =\n `https://query1.finance.yahoo.com/v8/finance/chart/${symbol}?range=1mo&interval=1d`;\n const resp = await fetch(url, { headers: { \"User-Agent\": \"Mozilla/5.0\" } });\n if (!resp.ok) return null;\n const data = await resp.json();\n const result = data?.chart?.result?.[0];\n if (!result) return null;\n\n const timestamps: number[] = result.timestamp;\n const closes: number[] = result.indicators?.quote?.[0]?.close;\n if (!timestamps || !closes) return null;\n\n const series: PriceSeries = {};\n timestamps.forEach((ts, i) => {\n if (closes[i] != null) {\n const date = new Date(ts * 1000).toISOString().slice(0, 10);\n series[date] = closes[i];\n }\n });\n return Object.keys(series).length ? series : null;\n } catch {\n return null;\n }\n}\n\nasync function fetchUniverse(\n symbols: string[],\n apiKey: string,\n demo: boolean,\n useFallback = true,\n) {\n const prices: Record = {};\n const skipped: { symbol: string; source_tried: string }[] = [];\n\n if (demo) {\n // Synthetic data — deterministic pseudo-random walk, no network needed.\n const dates: string[] = [];\n const d = new Date();\n while (dates.length < 10) {\n if (d.getDay() !== 0 && d.getDay() !== 6) {\n dates.unshift(d.toISOString().slice(0, 10));\n }\n d.setDate(d.getDate() - 1);\n }\n let seed = 42;\n const rand = () => {\n seed = (seed * 9301 + 49297) % 233280;\n return seed / 233280;\n };\n for (const sym of symbols) {\n const drift = (rand() - 0.5) * 0.03;\n const vol = 0.005 + rand() * 0.025;\n let price = 20 + rand() * 480;\n const series: PriceSeries = {};\n for (const date of dates) {\n series[date] = price;\n price = price * (1 + drift + (rand() - 0.5) * vol * 2);\n }\n prices[sym] = series;\n }\n return { prices, skipped };\n }\n\n const state = await getCallState();\n let avBudgetExhausted = false;\n for (const sym of symbols) {\n let series: PriceSeries | null = null;\n let source = \"alpha_vantage\";\n try {\n if (avBudgetExhausted) {\n // Skip AV entirely — go straight to Yahoo Finance\n series = null;\n } else {\n series = await fetchAlphaVantage(sym, apiKey, state);\n }\n } catch (e) {\n console.log(`[AV BUDGET] ${(e as Error).message} — switching to Yahoo Finance for remaining symbols.`);\n avBudgetExhausted = true;\n }\n\n if (series === null && useFallback) {\n series = await fetchYahooFinance(sym);\n source = series ? \"yfinance_endpoint\" : \"none\";\n }\n\n if (series === null) {\n skipped.push({\n symbol: sym,\n source_tried: useFallback ? \"alpha_vantage,yahoo\" : \"alpha_vantage\",\n });\n console.log(`[skip] ${sym}: no data from any source`);\n } else {\n prices[sym] = series;\n console.log(\n `[ok] ${sym}: ${Object.keys(series).length} closes (${source})`,\n );\n }\n }\n\n return { prices, skipped };\n}\n\n// --------------------------------------------------------------------------\n// Analysis: weekly return, drawdown, attribution, relative performance\n// --------------------------------------------------------------------------\nfunction weeklyWindow(\n prices: Record,\n lookbackDays = 5,\n): string[] {\n const ref = prices[BENCHMARK]\n ? Object.keys(prices[BENCHMARK])\n : Array.from(new Set(Object.values(prices).flatMap((s) => Object.keys(s))));\n return ref.sort().slice(-lookbackDays);\n}\n\nfunction buildPriceTable(\n prices: Record,\n window: string[],\n) {\n // symbol -> array of closes aligned to window (forward/back filled)\n const table: Record = {};\n for (const [sym, series] of Object.entries(prices)) {\n const vals: number[] = [];\n let last: number | null = null;\n for (const date of window) {\n if (series[date] != null) last = series[date];\n vals.push(last as number);\n }\n // back-fill leading nulls\n let firstKnown: number | null = null;\n for (const v of vals) {\n if (v != null) {\n firstKnown = v;\n break;\n }\n }\n for (let i = 0; i < vals.length; i++) {\n if (vals[i] == null) vals[i] = firstKnown as number;\n }\n table[sym] = vals;\n }\n return table;\n}\n\nfunction weeklyReturn(closes: number[]): number | null {\n const valid = closes.filter((v) => v != null && !isNaN(v));\n if (valid.length < 2) return null;\n return valid[valid.length - 1] / valid[0] - 1;\n}\n\nfunction modelIndexAndWeights(\n allocations: Holding[],\n modelName: string,\n priceTable: Record,\n windowLen: number,\n) {\n const rows = allocations.filter((h) => h.model === modelName);\n const weights: Record = {};\n for (const row of rows) {\n if (row.symbol === \"USD CASH\" || !priceTable[row.symbol]) continue;\n weights[row.symbol] = (weights[row.symbol] || 0) + row.weight / 100;\n }\n if (Object.keys(weights).length === 0) return null;\n\n const index = new Array(windowLen).fill(100);\n for (let t = 1; t < windowLen; t++) {\n let portRet = 0;\n for (const [sym, w] of Object.entries(weights)) {\n const prev = priceTable[sym][t - 1];\n const cur = priceTable[sym][t];\n const dailyRet = prev ? cur / prev - 1 : 0;\n portRet += w * dailyRet;\n }\n index[t] = index[t - 1] * (1 + portRet);\n }\n return { index, weights };\n}\n\nfunction maxDrawdown(index: number[]): number {\n let runningMax = -Infinity;\n let maxDD = 0;\n for (const v of index) {\n runningMax = Math.max(runningMax, v);\n const dd = v / runningMax - 1;\n if (dd < maxDD) maxDD = dd;\n }\n return maxDD;\n}\n\nfunction analyze(\n allocations: Holding[],\n priceTable: Record,\n window: string[],\n) {\n const modelNames = Array.from(new Set(allocations.map((h) => h.model)));\n const modelRows: any[] = [];\n const contributions: any[] = [];\n\n for (const model of modelNames) {\n const result = modelIndexAndWeights(\n allocations,\n model,\n priceTable,\n window.length,\n );\n if (!result) continue;\n const { index, weights } = result;\n\n const weekRet = index[index.length - 1] / index[0] - 1;\n const dd = maxDrawdown(index);\n\n modelRows.push({\n Model: model,\n \"Weekly Return %\": Math.round(weekRet * 10000) / 100,\n \"Max Drawdown (this week) %\": Math.round(dd * 10000) / 100,\n \"Holdings Priced\": Object.keys(weights).length,\n });\n\n for (const [sym, w] of Object.entries(weights)) {\n const r = weeklyReturn(priceTable[sym]);\n if (r == null) continue;\n contributions.push({\n Model: model,\n Symbol: sym,\n \"Weight %\": Math.round(w * 10000) / 100,\n \"Weekly Return %\": Math.round(r * 10000) / 100,\n \"Contribution (pp)\": Math.round(w * r * 100000) / 1000,\n });\n }\n }\n\n modelRows.sort((a, b) => a[\"Weekly Return %\"] - b[\"Weekly Return %\"]);\n return { modelRows, contributions };\n}\n\nfunction relativePerformanceSleeve(\n priceTable: Record,\n equityStocks: string[],\n) {\n const spyRow = priceTable[BENCHMARK];\n const spyRet = spyRow ? weeklyReturn(spyRow) : null;\n const summary: any[] = [];\n\n for (const sym of equityStocks) {\n if (!priceTable[sym]) continue;\n const r = weeklyReturn(priceTable[sym]);\n if (r == null || spyRet == null) continue;\n summary.push({\n Symbol: sym,\n \"Weekly Return %\": Math.round(r * 10000) / 100,\n \"SPY Weekly Return %\": Math.round(spyRet * 10000) / 100,\n \"Relative to SPY (pp)\": Math.round((r - spyRet) * 10000) / 100,\n });\n }\n summary.sort((a, b) => b[\"Relative to SPY (pp)\"] - a[\"Relative to SPY (pp)\"]);\n return summary;\n}\n\n// --------------------------------------------------------------------------\n// CFA-style memo\n// --------------------------------------------------------------------------\nfunction tableToText(rows: any[]): string {\n if (!rows.length) return \"(no data)\";\n const cols = Object.keys(rows[0]);\n const widths = cols.map((c) =>\n Math.max(c.length, ...rows.map((r) => String(r[c]).length))\n );\n const line = (vals: string[]) =>\n vals.map((v, i) => v.padStart(widths[i])).join(\" \");\n return [\n line(cols),\n ...rows.map((r) => line(cols.map((c, i) => String(r[c])))),\n ].join(\"\\n\");\n}\n\nfunction writeMemo(\n modelRows: any[],\n contributions: any[],\n relRows: any[],\n window: string[],\n) {\n const worst = modelRows.reduce((\n a,\n b,\n ) => (a[\"Max Drawdown (this week) %\"] < b[\"Max Drawdown (this week) %\"]\n ? a\n : b)\n );\n const modelContribs = contributions.filter((c) => c.Model === worst.Model)\n .sort((a, b) => a[\"Contribution (pp)\"] - b[\"Contribution (pp)\"]);\n const detractor = modelContribs[0];\n const benefactor = modelContribs[modelContribs.length - 1];\n const bestRel = relRows[0];\n const worstRel = relRows[relRows.length - 1];\n\n const lines: string[] = [];\n lines.push(\"WEEKLY PORTFOLIO RISK MEMO\");\n lines.push(`Window: ${window[0]} to ${window[window.length - 1]}`);\n lines.push(\"Prepared by: Research Analyst, CFA\");\n lines.push(\"=\".repeat(70));\n lines.push(\"\");\n lines.push(\"1. MODEL PERFORMANCE, RANKED WEAKEST TO STRONGEST\");\n lines.push(tableToText(modelRows));\n lines.push(\"\");\n lines.push(\"2. BIGGEST DRAWDOWN\");\n lines.push(\n `'${worst.Model}' posted the largest intra-week drawdown at ${\n worst[\"Max Drawdown (this week) %\"].toFixed(2)\n }%, on a weekly return of ${worst[\"Weekly Return %\"].toFixed(2)}%.`,\n );\n if (detractor) {\n lines.push(\n ` Biggest detractor: ${detractor.Symbol} (${\n detractor[\"Weight %\"].toFixed(2)\n }% weight, ${detractor[\"Weekly Return %\"].toFixed(2)}% return, ${\n detractor[\"Contribution (pp)\"].toFixed(3)\n }pp drag).`,\n );\n }\n if (benefactor) {\n lines.push(\n ` Biggest benefactor: ${benefactor.Symbol} (${\n benefactor[\"Weight %\"].toFixed(2)\n }% weight, ${benefactor[\"Weekly Return %\"].toFixed(2)}% return, ${\n benefactor[\"Contribution (pp)\"] >= 0 ? \"+\" : \"\"\n }${benefactor[\"Contribution (pp)\"].toFixed(3)}pp contribution).`,\n );\n }\n lines.push(\"\");\n lines.push(\"3. RELATIVE PERFORMANCE SLEEVE — EQUITY HOLDINGS VS. SPY\");\n lines.push(tableToText(relRows));\n if (bestRel && worstRel) {\n lines.push(\"\");\n lines.push(\n `Best relative performer: ${bestRel.Symbol} (${\n bestRel[\"Relative to SPY (pp)\"] >= 0 ? \"+\" : \"\"\n }${bestRel[\"Relative to SPY (pp)\"].toFixed(2)}pp vs. SPY).`,\n );\n lines.push(\n `Worst relative performer: ${worstRel.Symbol} (${\n worstRel[\"Relative to SPY (pp)\"] >= 0 ? \"+\" : \"\"\n }${worstRel[\"Relative to SPY (pp)\"].toFixed(2)}pp vs. SPY).`,\n );\n }\n lines.push(\"\");\n lines.push(\n \"Note: symbols with no coverage from Alpha Vantage or Yahoo Finance were excluded from return calcs.\",\n );\n return lines.join(\"\\n\");\n}\n\n// --------------------------------------------------------------------------\n// HTTP entrypoint (val.town)\n// --------------------------------------------------------------------------\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const demo = url.searchParams.get(\"demo\") === \"1\";\n const yfinanceOnly = url.searchParams.get(\"yfinance\") === \"1\";\n const format = url.searchParams.get(\"format\") || \"text\";\n const resetCache = url.searchParams.get(\"resetCache\") === \"1\";\n\n if (resetCache) {\n const keys = await blob.list(\"pra:\");\n for (const k of keys) await blob.delete(k.key);\n }\n\n const apiKey = Deno.env.get(\"ALPHAVANTAGE_API_KEY\") || \"\";\n if (!demo && !apiKey) {\n return new Response(\n \"Set ALPHAVANTAGE_API_KEY as a val.town environment variable, or call with ?demo=1 to test.\",\n { status: 400 },\n );\n }\n\n const { allSyms, equityStocks } = getUniverse(ALLOCATIONS);\n const orderedSyms = prioritizedSymbolList(allSyms, equityStocks);\n\n const { prices, skipped } = await fetchUniverse(orderedSyms, apiKey, demo);\n\n if (!prices[BENCHMARK]) {\n console.log(\n \"WARNING: SPY not fetched yet — relative-performance sleeve will be incomplete. Re-run to continue (SPY is first in priority order).\",\n );\n }\n\n const window = weeklyWindow(prices);\n const priceTable = buildPriceTable(prices, window);\n\n const { modelRows, contributions } = analyze(ALLOCATIONS, priceTable, window);\n const relRows = relativePerformanceSleeve(priceTable, equityStocks);\n\n if (format === \"json\") {\n return new Response(\n JSON.stringify(\n { window, modelRows, contributions, relRows, skipped },\n null,\n 2,\n ),\n {\n headers: { \"content-type\": \"application/json\" },\n },\n );\n }\n\n const memo = writeMemo(modelRows, contributions, relRows, window);\n const skippedNote = skipped.length\n ? `\\n\\nSkipped symbols (no data from any source): ${\n skipped.map((s) => s.symbol).join(\", \")\n }`\n : \"\";\n return new Response(memo + skippedNote, {\n headers: { \"content-type\": \"text/plain\" },\n });\n}","createdAt",["D",1784561039561],"branchVersion","branchId","cea622cf-f5ab-45dd-b8d8-2c96b9b196a9","id","e9f098f1-9aed-4261-aa6d-db5931ac0c9a","risk_analysis",["D",1784560191658],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","c6cc4a69-37f1-492a-b3b4-f92d779f7bdf","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f7fbe-292a-7566-a0f0-529ce26c7210","tursoName","e9f098f19aed4261aa6ddb5931ac0c9a","tursoHostname","e9f098f19aed4261aa6ddb5931ac0c9a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789472446807],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_111":59},"org",{"_105":104,"_106":59,"_107":59,"_19":61,"_108":109,"_110":31},"branch",{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"isOwned",11,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","cshukla","handle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_49":50,"_38":51,"_44":158,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":159,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":160,"_89":161,"_91":162,"_93":31},"tree",[153],"files",[153],"counts",{"_142":68,"_143":144,"_145":68,"_146":147,"_148":149},"contents",[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":134,"_38":34,"_36":37,"_135":-5,"_47":48,"_46":14,"_136":31,"_44":137,"_13":138,"_39":40,"_41":43,"_30":31,"_139":140,"_33":141},"8bd63dba-bc8d-4dc6-a553-850d23098b84","parentId","latest",["D",1784561039561],6,"label","risk-analysis",[34],"pulls","branches",1,"forks","envVars",{"_150":144,"_152":68},"connections",{"_150":68,"_151":68},"count","unfilledCount","emptyCount",{"_49":134,"_38":34,"_36":37,"_135":-5,"_47":48,"_46":14,"_136":31,"_44":154,"_13":138,"_39":40,"_41":43,"_30":31,"_139":140,"_155":156,"_33":157},["D",1784561039561],"children",[],[34],["D",1784560191658],["D",1789472446807],{"_105":104,"_111":59},{"_105":104,"_106":59,"_107":59,"_19":61,"_108":109,"_110":31},{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"ctx",{"_87":-5,"_130":196,"_197":198,"_199":200,"_201":31,"_202":31,"_203":31,"_204":64,"_205":-5,"_206":-7,"_207":-7,"_208":68,"_209":31,"_210":31,"_211":-5,"_212":31,"_213":31,"_214":31,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":95,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v7