Apex Scout — market intel

APEX SCOUT

\n 🔒 UNLISTED\n \n \n

\n \n 100%\n \n

\n\n

\n \n

live

\n \n

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

Player	Growth	Role	Age	Rank	Ceiling	Fog	Salary	Buy now	Time Left

\n\n

\n \n

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

Player	\n Growth▾ \n \n Growth Class \n \n ★ Prodigy\n Veteran\n Amateur\n Novice\n \n \n \n	\n Age▾ \n \n Filter Age \n \n \n \n \n \n \n	\n Market Rank▾ \n \n Market Rank \n All Clear \n \n \n \n	\n Market Pot▾ \n \n Market Potential \n All Clear \n \n \n \n	\n Fog▾ \n \n Filter Fog % \n \n \n \n \n \n \n	\n Ret Rank▾ \n \n Retired Rank \n All Clear \n \n \n \n	\n Ret Pot▾ \n \n Retired Potential \n All Clear \n \n \n \n	\n Salary▾ \n \n Filter Salary \n \n \n \n \n \n \n	\n Pot Δ▾ \n \n Potential Tier Change \n \n \n \n \n \n \n	Resolved

\n \n

\n\n

Advanced Signal Analysis

\n \n

A+ / S-Tier Potential Hit Rate Matrix

Market grade pairs (45%–85% Fog, Sample ≥ 25) ranked by likelihood of revealing ≥ A+ potential.

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

Grade Pair (Rank / Pot)	Sample (N)	Avg Fog	Avg Salary	≥ A+ Hits	≥ A+ Rate	S-Tier (S-/S/S+)	Avg Rev. True	Avg Rev. Pot

\n\n \n

Reached ≥ A- potential, by fog band

Percentage of resolved players in each fog band that reached or exceeded the selected grade threshold.

\n \n \n

Age Cohort vs. Upside Decay

Conversion probability of hitting A- and S- tier ceilings across player age brackets.

\n\n \n

Salary vs Revealed Rating

Market salary vs revealed rating — highlighting hidden S-tier players under 6,000 cr/wk.

\n\n \n

Ceiling Grade Distribution

Displayed potential grades split by player growth archetype.

\n\n \n

Roster Development Tracker

\n\n \n\n

\n \n

\n\n\n\n`;",[],[324],"52f2df96-bed7-44a7-bf25-dbc54e582e4b","main.ts","f693e3b8-9bd1-11f1-bfe0-1607ee4eb77e",["D",1787147006802],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb } from \"./db.ts\";\n\n// Run this once (or any time) to initialize the schema and see current state.\nawait initDb();\n\nconst l = await sqlite.execute(`SELECT COUNT(*) AS c FROM listings`);\nconst r = await sqlite.execute(`SELECT COUNT(*) AS c FROM retired`);\nconst g = await sqlite.execute(`SELECT COUNT(*) AS c FROM retired WHERE is_gem = 1`);\nconst p = await sqlite.execute(`SELECT COUNT(*) AS c FROM player_checks`);\n\nconsole.log(`apexGemTracker status`);\nconsole.log(` listings: ${l.rows[0]?.c ?? 0}`);\nconsole.log(` retired: ${r.rows[0]?.c ?? 0}`);\nconsole.log(` gems found: ${g.rows[0]?.c ?? 0}`);\nconsole.log(` players checked: ${p.rows[0]?.c ?? 0}`);\n",[],[333],["D",1787584929217],[],[18],"f5a7613f-a27f-4556-ab78-9a37cf407e76","collect.ts","f18cf222-9bd3-11f1-8fbb-1607ee4eb77e",80,["D",1787353789910],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb } from \"./db.ts\";\n\nconst API = \"https://apexmanager.rootsxo.studio/api/auctions\";\n\nexport default async function collect(_interval: Interval) {\n await initDb();\n\n // Ensure end_at column exists in listings table\n try {\n await sqlite.execute(`ALTER TABLE listings ADD COLUMN end_at INTEGER`);\n } catch (_e) {\n // Column already exists\n }\n\n const token = Deno.env.get(\"APEX_TOKEN\");\n if (!token) throw new Error(\"Missing APEX_TOKEN\");\n\n const resp = await fetch(API, { headers: { Authorization: `Bearer ${token}` } });\n if (!resp.ok) throw new Error(`API error: ${resp.status} ${resp.statusText}`);\n const data = await resp.json();\n const auctions = Array.isArray(data) ? data : (data.auctions ?? data.items ?? []);\n const now = Date.now();\n\n const activeAuctionIds: string[] = [];\n\n for (const a of auctions) {\n if (a.kind !== \"player\" || !a.player) continue;\n activeAuctionIds.push(a.id);\n const p = a.player;\n const intel = p.fogConfidence ?? 0;\n const fogPct = Math.round((1 - intel) * 100);\n const endAtMs = a.endAt ? new Date(a.endAt).getTime() : null;\n\n await sqlite.execute(\n `INSERT INTO listings\n (auction_id, player_id, name, role, age, growth_class, archetype,\n est_rank, est_potential, intel, fog_pct, salary, starting_bid, current_bid,\n first_seen_at, last_seen_at, end_at, left_at, player_json)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,NULL,?)\n ON CONFLICT(auction_id) DO UPDATE SET\n last_seen_at = excluded.last_seen_at,\n end_at = COALESCE(excluded.end_at, listings.end_at),\n current_bid = excluded.current_bid,\n left_at = NULL,\n player_json = excluded.player_json`,\n [\n a.id, p.id, p.name, p.role, p.age, p.growthClass, p.archetype ?? null,\n p.estimatedRank, p.estimatedPotential, intel, fogPct, p.salary ?? null,\n a.startingBid ?? null, a.currentBid ?? null,\n now, now, endAtMs, JSON.stringify(p),\n ],\n );\n }\n\n // If a listing wasn't in the active auctions response, mark it as left the market immediately\n if (activeAuctionIds.length > 0) {\n const placeholders = activeAuctionIds.map(() => \"?\").join(\",\");\n await sqlite.execute(\n `UPDATE listings SET left_at = ? WHERE left_at IS NULL AND auction_id NOT IN (${placeholders})`,\n [now, ...activeAuctionIds],\n );\n }\n\n const n = await sqlite.execute(`SELECT COUNT(*) AS c FROM listings`);\n const c = n.rows[0]?.c ?? 0;\n console.log(`Collect: ${auctions.length} auctions, ${c} tracked listings.`);\n}",[],[343],"1d03028a-9d90-413c-a890-1d9e163eabb4","check.ts","f1983bdc-9bd3-11f1-8fbb-1607ee4eb77e",74,["D",1787347872727],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb, isGem } from \"./db.ts\";\n\nconst API = \"https://apexmanager.rootsxo.studio/api/players/\";\nconst RE_CHECK_MS = 10 * 60 * 1000; // Retry unresolved/active players every 10 minutes\n\nasync function getCard(id: string): Promise {\n const token = Deno.env.get(\"APEX_TOKEN\");\n try {\n const r = await fetch(API + id, {\n headers: { Authorization: `Bearer ${token}` },\n });\n return r.ok ? await r.json() : null;\n } catch {\n return null;\n }\n}\n\nexport default async function check(_interval: Interval) {\n await initDb();\n const token = Deno.env.get(\"APEX_TOKEN\");\n if (!token) throw new Error(\"Missing APEX_TOKEN\");\n\n const now = Date.now();\n\n // Query ONLY players whose listings have definitively left the market (left_at IS NOT NULL)\n // regardless of whether their auction lasted 15 minutes, 6 hours, or 24 hours.\n const rows = await sqlite.execute(\n `SELECT l.player_id, l.name, MAX(l.left_at) AS left_market_at\n FROM listings l\n LEFT JOIN player_checks c ON c.player_id = l.player_id\n WHERE l.left_at IS NOT NULL\n AND (c.player_id IS NULL OR c.retired = 0)\n AND (c.player_id IS NULL OR c.last_checked_at < ?)\n GROUP BY l.player_id\n ORDER BY left_market_at ASC\n LIMIT 100`,\n [now - RE_CHECK_MS],\n );\n\n let checked = 0;\n let retiredFound = 0;\n\n for (const r of rows.rows as any[]) {\n const pid = r.player_id;\n const card = await getCard(pid);\n if (!card) continue;\n\n checked++;\n if (card.isRetired || card.trueRating != null) {\n // Retrieve earliest market display listing for this player\n const m = await sqlite.execute(\n `SELECT est_rank, est_potential, intel, fog_pct, salary, age\n FROM listings \n WHERE player_id = ? \n ORDER BY first_seen_at ASC \n LIMIT 1`,\n [pid],\n );\n const d = m.rows[0] as any;\n const gem = isGem(\n d?.est_potential ?? null,\n card.estimatedPotential ?? null,\n );\n\n await sqlite.execute(\n `INSERT INTO retired\n (player_id, name, market_est_rank, market_est_potential, market_intel,\n market_fog_pct, market_age, market_salary, true_rating, potential_rating, peak_rating,\n retired_rank, retired_potential, retired_at, checked_at, is_gem, card_url)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ON CONFLICT(player_id) DO UPDATE SET\n true_rating = excluded.true_rating,\n potential_rating = excluded.potential_rating,\n peak_rating = excluded.peak_rating,\n retired_rank = excluded.retired_rank,\n retired_potential = excluded.retired_potential,\n checked_at = excluded.checked_at,\n is_gem = excluded.is_gem,\n card_url = excluded.card_url`,\n [\n pid,\n card.name ?? r.name,\n d?.est_rank ?? null,\n d?.est_potential ?? null,\n d?.intel ?? null,\n d?.fog_pct ?? null,\n d?.age ?? null,\n d?.salary ?? null,\n card.trueRating ?? null,\n card.potentialRating ?? null,\n card.peakRating ?? null,\n card.estimatedRank ?? null,\n card.estimatedPotential ?? null,\n now,\n now,\n gem ? 1 : 0,\n `https://apexmanager.rootsxo.studio/player/${pid}`,\n ],\n );\n\n await sqlite.execute(\n `INSERT INTO player_checks (player_id, name, last_checked_at, retired)\n VALUES (?,?,?,1)\n ON CONFLICT(player_id) DO UPDATE SET retired = 1, last_checked_at = excluded.last_checked_at`,\n [pid, card.name ?? r.name, now],\n );\n retiredFound++;\n } else {\n await sqlite.execute(\n `INSERT INTO player_checks (player_id, name, last_checked_at, retired)\n VALUES (?,?,?,0)\n ON CONFLICT(player_id) DO UPDATE SET last_checked_at = excluded.last_checked_at`,\n [pid, card.name ?? r.name, now],\n );\n }\n }\n\n console.log(\n `Check: ${checked} cards checked, ${retiredFound} retired/resolved.`,\n );\n}",[],[351],"f891a401-9930-473b-aa49-7822ef06dc32","AGENTS.md","85cb48e2-9bd6-11f1-8663-1607ee4eb77e",102,["D",1787505538235],"# apexGemTracker — Core Architecture & Context\n\nThis Val tracks Apex Manager market listings to find \"hidden gems\": players who displayed BELOW A- potential on the market but actually retired with A- or higher potential (i.e., fog hid their true quality)[cite: 1]. This is strictly a data collection and comparison pipeline with a web dashboard, entirely separate from notification/alert Vals[cite: 1].\n\n## ⚠️ Core Business Logic\n\n1. **The Gem Rule (`db.ts`)**\n `is_gem = isBelowAMinus(marketPotential) && !isBelowAMinus(retiredPotential)`[cite: 1, 4]\n *CRITICAL:* Always compare LETTER GRADES (`estimatedRank` / `estimatedPotential`), never the numeric `trueRating` or `potentialRating`[cite: 1]. The game's numeric ratings do not map to a reliable letter grade scale (e.g., a potential rating of 1986 might retire as a C/B, not an A)[cite: 1]. The authoritative \"true\" grade is the revealed letter grade on the retired card at 100% confidence[cite: 1].\n\n2. **Fog Semantics**\n `fogConfidence` (API) = INTEL[cite: 1]. Displayed \"Fog %\" = 100 - (fogConfidence * 100)[cite: 3]. High intel (low fog) = well-scouted; low intel (high fog) = obscured/lottery[cite: 1].\n\n## Data Model (SQLite)\n\n* **`listings`**: Snapshot of every market listing (keyed by `auction_id`)[cite: 1]. Captures the first-seen state (est rank/potential, intel, fog, salary, full `player_json`)[cite: 1, 3]. Upserted every run[cite: 1]. `left_at` is set when a listing stops appearing in the active auctions API[cite: 1, 3].\n* **`retired`**: Resolved players[cite: 1]. Compares market display vs. retired revealed grade (`retired_rank` / `retired_potential`)[cite: 1]. Stores market age/salary snapshot + true numeric ratings + `is_gem` flag + `card_url`[cite: 1, 2].\n* **`player_checks`**: Dedupe and backoff tracking table (checked every 10 minutes) so we don't spam the API for unresolved players[cite: 1, 2].\n\n## Scheduled Jobs (Cron)\n\n* **`collect.ts` (*/15 mins)**: Snapshots all `/api/auctions` listings[cite: 1]. Inserts new listings and updates `left_at` for expired auctions[cite: 3].\n* **`check.ts` (Hourly)**: Looks at listings that left the market >=1h ago[cite: 1]. Fetches `/api/players/{id}`[cite: 1]. If retired, calculates gem status and moves to `retired` table[cite: 1, 2]. If still active, backs off and checks again later[cite: 1]. \n\n## Web & API Endpoints (HTTP)\n\n* **`site.ts`**: The main frontend UI and API router[cite: 9]. Serves a rich HTML/JS dashboard at the root (`/`) with tabs for Live Market, Retired Players, and Advanced Analytics charts[cite: 6, 9]. Serves JSON endpoints at `/api/stats`, `/api/live`, `/api/retired`, and `/api/analytics`[cite: 9].\n* **`report.ts`**: Spreadsheet export router[cite: 1, 7]. Serves raw JSON and CSVs (e.g., `/csv` for gems, `/csv/listings` for active market)[cite: 1, 7]. Designed to be ingested directly by Google Sheets using the `IMPORTDATA()` function[cite: 1].\n* **`main.ts`**: A utility script to initialize the DB schema and print current table row counts[cite: 1, 5]. \n\n## Environment\n\n* `APEX_TOKEN`: The bearer token required to authenticate against the Apex Manager API[cite: 1]. All scripts will fail if this is missing or expired[cite: 1, 2, 3].",[],[359],["D",1787146151215],["D",1789491713377],{"_11":12,"_225":80},{"_11":12,"_220":221,"_79":80,"_30":78,"_222":223,"_224":24},{"_49":211,"_13":16,"_43":46,"_212":172,"_213":-5,"_214":-5,"_215":-5,"_216":-5,"_217":-5,"_218":14,"_219":12},"ctx",{"_63":-5,"_244":404,"_405":406,"_407":408,"_409":24,"_410":24,"_411":24,"_412":185,"_413":-5,"_414":-7,"_415":-7,"_416":26,"_417":24,"_418":24,"_419":-5,"_420":24,"_421":24,"_422":24,"_423":-5},"ENV",{"_375":376,"_377":378,"_379":16,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403},"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"]

History · db.ts