Stock Analysis with Numbers

You: Start the sandbox with ~/reports shared, then create a stock analysis
     report for AAPL in Numbers and export it as PDF.

Cowork: I'll start the sandbox and create the stock analysis report.

[Calls lume_run_vm with name="sandbox", shared_dir="~/reports", no_display=true]
VM 'sandbox' started successfully.

[Calls lume_exec with name="sandbox", command="python3 << 'EOF'
import urllib.request
import json
import csv

# Fetch stock data from a free API
url = \"https://query1.finance.yahoo.com/v8/finance/chart/AAPL?interval=1d&range=1mo\"
req = urllib.request.Request(url, headers={'User-Agent': 'Mozilla/5.0'})
data = json.loads(urllib.request.urlopen(req).read())

# Extract timestamps and prices
timestamps = data['chart']['result'][0]['timestamp']
closes = data['chart']['result'][0]['indicators']['quote'][0]['close']

# Write to CSV
with open('/tmp/aapl_data.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['Date', 'Close'])
    for ts, close in zip(timestamps, closes):
        from datetime import datetime
        date = datetime.fromtimestamp(ts).strftime('%Y-%m-%d')
        writer.writerow([date, f'{close:.2f}'])

print('Data saved to /tmp/aapl_data.csv')
EOF"]
Data saved to /tmp/aapl_data.csv

Now I'll create a Numbers spreadsheet using AppleScript:

[Calls lume_exec with name="sandbox", command="osascript << 'EOF'
tell application \"Numbers\"
    activate
    set newDoc to make new document
    tell table 1 of sheet 1 of newDoc
        set csvData to read POSIX file \"/tmp/aapl_data.csv\"
        set csvLines to paragraphs of csvData
        repeat with i from 1 to count of csvLines
            set csvLine to item i of csvLines
            set AppleScript's text item delimiters to \",\"
            set parts to text items of csvLine
            set AppleScript's text item delimiters to \"\"
            set value of cell 1 of row i to item 1 of parts
            set value of cell 2 of row i to item 2 of parts
        end repeat
    end tell
    tell sheet 1 of newDoc
        set newChart to make new chart with properties {chart type:line_2d}
    end tell
    export newDoc to POSIX file \"/Volumes/My Shared Files/aapl-analysis.pdf\" as PDF
    close newDoc saving no
end tell
EOF"]
Success

Done! I've created the stock analysis report. You can find it at:
~/reports/aapl-analysis.pdf (via the shared folder)

The report contains:
- 30 days of AAPL closing prices
- A line chart showing price trends
- Data table with dates and values

tell application "Numbers"
    -- Create documents
    set newDoc to make new document

    -- Manipulate cells
    tell table 1 of sheet 1 of newDoc
        set value of cell 1 of row 1 to "Hello"
    end tell

    -- Add charts
    make new chart with properties {chart type:line_2d}

    -- Export
    export newDoc to POSIX file "/path/to/output.pdf" as PDF
end tell

# Yahoo Finance (unofficial)
curl "https://query1.finance.yahoo.com/v8/finance/chart/AAPL?interval=1d&range=1mo"

# Alpha Vantage (requires free API key)
curl "https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=AAPL&apikey=YOUR_KEY"