Delivery Note — AskLivermore Portfolio Tracker (Thinkorswim RTD)

Prepared for: Jill Delivery date: June 23, 2026 Package location: delivery-package/portfolio-tracker/

What Was Completed

Your portfolio tracker has been converted to use Thinkorswim as the single source of truth for all market pricing.

Preserved without change:

• All worksheets (Core Portfolio Holdings, 10X Portfolio Holdings, FAQs)
• Excel tables (Core, Aggressive)
• Gain/Loss, Current Value, and allocation calculations
• Formatting and layout

Added:

• TOS Quotes sheet (first tab) — 57 tickers, 7 live fields each (LAST, BID, ASK, MARK, NET CHANGE, PERCENT CHANGE, VOLUME)
• Named ranges for quote columns (QuoteLast, QuoteBid, etc.)
• Audit and formula verification reports (see package contents below)

How to Use the Workbook

1. Start Thinkorswim on the same Windows PC and log in to your account. 2. Open AskLivermore Portfolio Tracker - Jill (TOS RTD).xlsx in Microsoft Excel (Windows). 3. Confirm Excel calculation is set to Automatic (Formulas → Calculation Options → Automatic). 4. Go to the TOS Quotes tab — prices should populate within a few seconds. 5. Switch to Core Portfolio Holdings or 10X Portfolio Holdings — Current Price columns update automatically from the quote sheet. Gain/Loss, Current Value, and allocation metrics recalculate from there.

Adding a New Holding

1. Add the ticker symbol to column A on TOS Quotes (next empty row). 2. Copy the RTD formulas from the row above across columns B–H. 3. Add the holding row on the appropriate portfolio sheet as you normally would. 4. The Current Price column will resolve via the existing INDEX/MATCH formula pattern.

System Requirements

Live RTD data flows from the Thinkorswim desktop platform through Excel’s RTD COM interface (tos.rtd). Thinkorswim must be running before or when you open the workbook for quotes to stream.

Known Limitations

• Runtime dependency: If Thinkorswim is not running, quote cells may show blank or #N/A until the platform connects. This is expected RTD behavior, not a workbook defect.
• Symbol coverage: Tickers must be valid and accessible in your Thinkorswim account. Symbols outside your subscription or with non-standard formats may not resolve.
• After-hours: LAST and related fields reflect Thinkorswim’s session rules; some fields may show last close or mark when markets are closed.
• Current Price uses LAST: Portfolio sheets pull column B (LAST) from TOS Quotes. BID, ASK, and MARK are available on the quote sheet if you want to reference them separately.
• Pre-open validation: Formula structure was verified programmatically. Live price accuracy was not tested in this delivery environment because Thinkorswim was not available on the build machine. Recommend a 2-minute smoke test after opening: confirm TOS Quotes populates, then spot-check 2–3 holdings on each portfolio tab.

Package Contents

Acceptance Audit Summary

Independent customer acceptance audit — 23 of 23 checks passed:

• Workbook exists and opens
• TOS Quotes is the centralized, first-tab quote source (57 tickers)
• All 59 holdings reference TOS Quotes (0 Google Finance, 0 hardcoded prices)
• No RTD formulas embedded in portfolio sheets
• No #REF, #N/A, or #NAME? in formula definitions
• Named ranges and Excel tables intact
• README documents Thinkorswim + Windows Excel RTD requirements
• All required delivery artifacts present

Unresolved issues at delivery: None.

Ready to Send?

Yes — this package is ready to send to the customer, with the recommendation that Jill perform a brief live smoke test on her Windows machine with Thinkorswim running to confirm RTD connectivity and symbol resolution for her account.

*Questions or issues after opening the workbook? Check that Thinkorswim is running first, then review workbook-audit-report.md for architecture details.*