chriscarrollsmith

name	analyzing-sec-filings
description	Retrieves and parses SEC EDGAR filings (10-K, 10-Q, 8-K, DEF 14A) into markdown or structured financial data using the edgartools Python library. Use when working with SEC filings, EDGAR data, XBRL financials, or company fundamental analysis.

Analyzing SEC Filings

Use edgartools for all SEC filing work. Do not use curl, manual HTML parsing, or filing.full_text_submission().

Setup

chriscarrollsmith

import os
import sys
from typing import Any, Dict, List

from openai import OpenAI


def ensure_api_key() -> None:
    if not os.getenv("OPENAI_API_KEY"):
        print("ERROR: Please set OPENAI_API_KEY in your environment.")

chriscarrollsmith

Embedding your downloaded Twitter archive data for semantic search and RAG with llm

Getting your tweets

Twitter allows you to download your archive of tweets. You can do this by going to your account settings and requesting your archive. Once you receive the email with the download link, you can download the zip file.

Exploring the data

Top-level keys of twitter_archive.json (via jq 'keys' twitter_archive.json):

chriscarrollsmith

#!/usr/bin/env bun
// @bun-dependencies: puppeteer@latest puppeteer-extra@latest puppeteer-extra-plugin-stealth@latest

import puppeteer from 'puppeteer';

async function scrapeXTweet(url, metadata) {
  // Launch browser with stealth options
  const browser = await puppeteer.launch({
    headless: true, // or 'new' for new headless mode
    executablePath: '/usr/bin/google-chrome',

chriscarrollsmith

#!/bin/bash

# create-nl-tool.sh - Programmatically create natural language interfaces 
# for CLI tools
# Usage: ./create-nl-tool.sh <tool-name>
# Example: ./create-nl-tool.sh repomix

set -e

if [ $# -eq 0 ]; then

chriscarrollsmith

Projects

Runner-Up: Doctor of Credit

• Creator: Evan Mullen
• Description: Extract structured data about bank deposit bonuses from the Doctor of Credit website.

Prerequisites

Google Chrome CLI entrypoint

chriscarrollsmith

Let's hack on llm!

If you have uv installed (and you should!), you can install llm globally in a uv-managed tool environment with:

uv tool install llm

If you want to use models other than OpenAI models, you'll need some extensions:

chriscarrollsmith

#!/bin/bash

# Pre-push hook to prevent pushing from the template branch
# This allows pulling from template remote but prevents accidental pushes

current_branch=$(git symbolic-ref --short HEAD)

if [ "$current_branch" = "template" ]; then
    echo "ERROR: Pushing from the 'template' branch is not allowed."
    echo "This branch is reserved for pulling updates from the template repository."

chriscarrollsmith

Exploring the Zotero Local Database Schema

On my (Windows) machine, Zotero's local database was located at C:\Users\chris\Zotero\zotero.sqlite. I was able to dump the schema using the sqlite3 command line tool:

sqlite3 zotero.sqlite ".schema" > zotero_schema.sql

Here is the SQL schema dump:

chriscarrollsmith

#!/bin/bash

# Exit on error
set -e

# Load environment variables if .env exists
if [ -f .env ]; then
    export $(cat .env | grep -v '^#' | xargs)
fi