[{"_1":2,"_267":-5,"_268":-5},"loaderData",{"_3":4,"_91":92,"_259":260,"_266":-5},"root",{"_5":6,"_32":33,"_60":61},"ctx",{"_7":8,"_19":20,"_21":-5,"_22":23,"_24":25,"_26":27,"_28":27,"_29":27,"_30":31},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_selection_ai","notification_count",0,"ENV",{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","d94067e151e8bb59a097e28eb98e3525d9498699","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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/","API_URL","https://api.val.town","WORKER_FINGERPRINT","fd7e47ba602df66e0f857b45e802b861","clerkState",{"_62":63},"__internal_clerk_state",{"_64":65,"_66":43,"_67":68,"_69":68,"_70":27,"_71":68,"_72":68,"_73":68,"_74":68,"_75":68,"_76":68,"_77":68,"_78":68,"_79":80,"_89":27,"_90":27},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_81":27,"_82":68,"_83":84,"_85":68,"_86":43,"_87":27,"_88":68},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":-7,"_98":68,"_99":-7,"_100":101,"_142":143,"_223":224,"_225":226,"_232":233,"_255":-5,"_256":-5,"_257":27,"_258":27},"handle","xpipko","name","e424b5","branchName","path","version","project",{"_102":103,"_95":96,"_104":105,"_106":-5,"_107":27,"_108":109,"_110":111,"_112":-5,"_12":113,"_114":115,"_116":117,"_118":119,"_120":31,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":27,"_21":130,"_133":134},"id","dd7b94b8-1b1f-11f0-b922-569c3dd06744","createdAt",["D",1744848412225],"deletedAt","legacyEnvVars","privacy","public","description","Pulling EDGAR 424B5 information","imageUrl","b03cc8c0-1a1e-11f0-8ab1-47a735ce6e99","pinnedFileId","4d274974-1b20-11f0-b3bf-569c3dd06744","pinPreview",true,"screenshotVersion",228,"likeCount","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","isOwned",{"_93":94,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydm02WHdCckRrN1NHZ1RlZHBaOFh6dnNMd3YifQ","branch",{"_99":135,"_95":41,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5},229,"dd7bf30e-1b1f-11f0-b922-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectUserId","tree",[144,164,174,184,194,204,213],{"_102":145,"_95":146,"_147":148,"_149":-5,"_150":136,"_151":135,"_152":117,"_104":153,"_99":154,"_155":156,"_157":158,"_159":27,"_160":-5,"_161":162,"_98":163},"f8e444ea-1bb3-11f0-a61f-569c3dd06744","env","fileId","1fbdfa64-1b2f-11f0-becc-569c3dd06744","parentId","branchId","branchVersion","latest",["D",1744912023717],21,"fileType","script","content","export function env(flag: string) {\n var e = {};\n\n e.headers = {\n \"User-Agent\": \"CANONICAL THEORY PERTURBATION I, INC connor@ctp.ventures\",\n \"Accept-Encoding\": \"gzip, deflate\",\n \"Host\": \"www.sec.gov\",\n \"Accept\": \"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8\",\n \"Accept-Language\": \"en-US,en;q=0.5\",\n \"Connection\": \"keep-alive\",\n \"Upgrade-Insecure-Requests\": \"1\",\n \"Referer\": \"https://www.sec.gov/\",\n };\n\n e.prompt_424b5 = `\n You are given a PDF of an SEC Form 424(b)(5) block trade prospectus supplement.\n Extract the \"Selling Stockholders\" section and run OCR to capture its table.\n Group affiliates exactly as shown in the PDF.\n \n For each reported beneficial owner:\n - Determine beginning balances for each class of shares.\n - Extract all conversions with from/to classes and share counts. Make sure that there are two rows for each conversion\n - Extract all trades with class, signed share change, and action.\n - Compute ending balances for each class.\n \n Output a json table with these columns:\n - ReportedBeneficialOwner, \n - Owner\n - OwnerType\n - Ticker, Security\n - Shares BoP\n - Shares Change\n - Shares EoP\n - Action\n - Note\n \n Return only the json table, with no additional text or commentary.\n`;\n\n e.STEEL_API_KEY =\n \"ste-5xoiBAdiZBIfoSogmi2tScH1MhLyVnHLiIjDWPWdIkbqormzMXE2De7hWyfNMQnUywmusBrv92zgW55dwBjlmdPqNuHSi90iGFp\";\n\n e.other = \"other\";\n\n return e;\n}","deleted","label","children",[],[146],{"_102":165,"_95":166,"_147":167,"_149":-5,"_150":136,"_151":168,"_152":117,"_104":169,"_99":170,"_155":156,"_157":171,"_159":27,"_160":-5,"_161":172,"_98":173},"b53310ee-1b33-11f0-bf45-569c3dd06744","getCikFromTicker","6a832b2c-1b2b-11f0-880c-569c3dd06744",118,["D",1744856934568],47,"import { env } from \"https://esm.town/v/xpipko/e424b5/env\";\n\n// Function to get CIK for a ticker symbol\nexport async function getCikFromTicker(ticker: string) {\n // Convert ticker to uppercase to ensure consistent formatting\n try {\n // The SEC provides a JSON file with ticker to CIK mappings\n const response = await fetch(\"https://www.sec.gov/files/company_tickers.json\", {\n headers: env().headers,\n });\n const data = await response.json();\n\n // Search through the entries to find matching ticker\n // ticker = ticker.toUpperCase();\n for (const key in data) {\n const company = data[key];\n if (company.ticker === ticker) {\n // Convert CIK to string and pad with leading zeros to 10 digits\n // SEC often requires CIKs to be 10 digits with leading zeros\n return String(company.cik_str).padStart(10, \"0\");\n }\n }\n\n // If no match is found\n return null;\n } catch (error) {\n console.error(\"Error fetching CIK:\", error);\n throw error;\n }\n}",[],[166],{"_102":175,"_95":176,"_147":177,"_149":-5,"_150":136,"_151":119,"_152":117,"_104":178,"_99":179,"_155":180,"_157":181,"_159":27,"_160":-5,"_161":182,"_98":183},"85ef669e-1baf-11f0-9cdb-569c3dd06744","getEdgarFilingHtmUrl","8fe986bc-1ba9-11f0-a73e-569c3dd06744",["D",1744910112867],7,"http","import { getEdgarFilingIndex } from \"https://esm.town/v/xpipko/e424b5/getEdgarFilingIndex\";\n\nexport async function getEdgarFilingHtmUrl(cik: string, accession: string): Promise {\n const js = await getEdgarFilingIndex(cik, accession);\n const url = js[0].url;\n return url;\n}\n\nexport default async function view(request: Request): Promise {\n const url = new URL(request.url);\n const cik = url.searchParams.get(\"cik\") || \"1866368\";\n const accession = url.searchParams.get(\"accession\") || \"000162828024047247\";\n\n try {\n const accessions = await getEdgarFilingHtmUrl(cik, accession);\n\n return new Response(\n JSON.stringify({\n accessions: accessions,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n } catch (error) {\n return new Response(\n JSON.stringify({\n error: \"Processing error\",\n details: error.message,\n }),\n {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n}",[],[176],{"_102":185,"_95":186,"_147":187,"_149":-5,"_150":136,"_151":188,"_152":117,"_104":189,"_99":190,"_155":180,"_157":191,"_159":27,"_160":-5,"_161":192,"_98":193},"3046b4ee-1bab-11f0-a7d0-569c3dd06744","getEdgarFilingIndex","142d0b0e-1b20-11f0-9d80-569c3dd06744",225,["D",1744908251169],18,"import { env } from \"https://esm.town/v/xpipko/e424b5/env\";\n\nexport async function getEdgarFilingIndex(cik: string, accession: string) {\n const baseUrl = \"https://www.sec.gov/Archives/edgar/data/\";\n const indexUrl = `${baseUrl}${cik}/${accession}/${accession.slice(0, 10)}-${accession.slice(10, 12)}-${\n accession.slice(12)\n }-index.html`;\n\n try {\n // Fetch the index.html file with strict redirect handling\n const indexResponse = await fetch(indexUrl, {\n headers: env().headers,\n redirect: \"manual\", // Use manual redirect to prevent infinite loops\n });\n\n const indexHtml = await indexResponse.text();\n const fileLinks = parseIndex(indexHtml, indexUrl);\n return fileLinks;\n } catch (error) {\n console.error(`Error fetching ${indexUrl}:`, error);\n }\n throw new Error(`Could not fetch index file for CIK: ${cik}, Accession: ${accession}`);\n}\n\nfunction parseIndex(html: string, baseUrl: string): Array<{\n filename: string;\n url: string;\n type: string;\n}> {\n // Regular expression to find href links in the HTML\n\n const mainTableMatch = html.match(/]*>[\\s\\S]*?<\\/table>/i);\n if (!mainTableMatch) return files;\n\n const tableHtml = mainTableMatch[0];\n const linkRegex = /href=\"([^\"]+)\"/g;\n const files: Array<{ filename: string; fullUrl: string; type: string }> = [];\n\n let match;\n while ((match = linkRegex.exec(tableHtml)) !== null) {\n const relativeLink = match[1];\n\n // Skip irrelevant links\n if (relativeLink.startsWith(\"?\") || relativeLink === \"../\") continue;\n\n // Construct full URL\n const url = new URL(relativeLink, baseUrl).href;\n\n // Determine file type based on extension\n let type = \"unknown\";\n if (relativeLink.endsWith(\".pdf\")) type = \"pdf\";\n if (relativeLink.endsWith(\".txt\")) type = \"text\";\n if (relativeLink.endsWith(\".htm\") || relativeLink.endsWith(\".html\")) type = \"html\";\n\n files.push({\n filename: relativeLink,\n url,\n type,\n });\n }\n\n return files;\n}\n\n// ************ VIEW ************\n\nexport default async function view(request: Request): Promise {\n const url = new URL(request.url);\n const cik = url.searchParams.get(\"cik\") || \"1866368\";\n const accession = url.searchParams.get(\"accession\") || \"000162828024047247\";\n\n try {\n const accessions = await getEdgarFilingIndex(cik, accession);\n\n return new Response(\n JSON.stringify({\n accessions: accessions,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n } catch (error) {\n return new Response(\n JSON.stringify({\n error: \"Processing error\",\n details: error.message,\n }),\n {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n}",[],[186],{"_102":195,"_95":196,"_147":197,"_149":-5,"_150":136,"_151":198,"_152":117,"_104":199,"_99":200,"_155":180,"_157":201,"_159":27,"_160":-5,"_161":202,"_98":203},"ed55832a-1b93-11f0-b9ac-569c3dd06744","getEdgarFilings","7ea1b1a0-1b26-11f0-99da-569c3dd06744",205,["D",1744898260431],76,"import { env } from \"https://esm.town/v/xpipko/e424b5/env\";\nimport { getCikFromTicker } from \"https://esm.town/v/xpipko/e424b5/getCikFromTicker\";\n\nexport async function getEdgarFilings(ticker: string, formTypes, limit = 100) {\n try {\n const r = await getEdgarJSON(ticker, formTypes, limit);\n const f = await filterEdgarJSON(r, formTypes, limit);\n return f;\n } catch (error) {\n return error;\n }\n}\n\nexport async function getEdgarJSON(ticker: string, formTypes, limit = 100) {\n const cik = await getCikFromTicker(ticker);\n const baseUrl = \"https://data.sec.gov/submissions/CIK\";\n const url = `${baseUrl}${cik}.json`;\n\n console.log(url);\n\n try {\n const indexResponse = await fetch(url, {\n headers: env().headers,\n });\n const js = JSON.parse(await indexResponse.text());\n return js;\n } catch (error) {\n return error;\n }\n}\n\nexport async function filterEdgarJSON(data, formTypes, limit = 100) {\n // Normalize formTypes to array\n const formTypesArray = Array.isArray(formTypes) ? formTypes : [formTypes];\n\n console.log(data);\n\n // Create results object\n const result = {\n metadata: {\n cik: data.cik,\n entityName: data.name,\n tickers: data.tickers,\n },\n filings: [],\n };\n\n // Access the recent filings section\n const recentFilings = data.filings?.recent;\n\n // Extract key arrays from the columnar data structure\n const formArray = recentFilings.form;\n const accessionNumberArray = recentFilings.accessionNumber;\n const filingDateArray = recentFilings.filingDate;\n const reportDateArray = recentFilings.reportDate;\n const primaryDocDescriptionArray = recentFilings.primaryDocDescription || [];\n const fileNumArray = recentFilings.fileNumber || [];\n const primaryDocArray = recentFilings.primaryDocument || [];\n\n console.log(formArray);\n\n // Filter by form type and build result array\n for (let i = 0; i < formArray.length && result.filings.length < limit; i++) {\n if (formTypesArray.includes(formArray[i])) {\n result.filings.push({\n form: formArray[i],\n accessionNumber: accessionNumberArray[i],\n filingDate: filingDateArray[i],\n reportDate: reportDateArray[i],\n primaryDocDescription: primaryDocDescriptionArray[i] || null,\n fileNumber: fileNumArray[i] || null,\n primaryDocument: primaryDocArray[i] || null,\n viewUrl: `https://www.sec.gov/Archives/edgar/data/${data.cik.replace(/^0+/, \"\")}/${\n accessionNumberArray[i].replace(/-/g, \"\")\n }/`,\n documentUrl: primaryDocArray[i]\n ? `https://www.sec.gov/Archives/edgar/data/${data.cik.replace(/^0+/, \"\")}/${\n accessionNumberArray[i].replace(/-/g, \"\")\n }/${primaryDocArray[i]}`\n : null,\n });\n }\n }\n\n // If there's an files array for older filings, note that more are available\n if (data.filings?.files && data.filings.files.length > 0) {\n result.metadata.olderFilingsAvailable = true;\n result.metadata.olderFilingsPaths = data.filings.files;\n }\n\n return result;\n}\n\n/**\n * Helper function to get all available form types for a CIK\n *\n * @param {string} cik - The CIK number (e.g., \"0001866368\")\n * @returns {Promise

Environment variables