Companion files · The Private Markets Career Guides

The Equity Sales and Trading Professional

How a Cash Equities Desk Really Works: Covering Institutional Clients, Sales-Trading and Algorithms, Risk Trades, Blocks and Program Trades, Commissions and Broker Votes, US Market Structure, Best Execution and the Career.

These are the companion files of the book. One workbook rebuilds the Halvard Crane case: the Varrick Hollow account, its CSA and wallet share, the Corvane Industrial order and its implementation shortfall against the declined risk price, the Tarrowmere Logistics block with its hedge and grid of exits, the pension client’s program trade with and without its futures hedge, a six-order TCA report and the desk’s 2025 P&L. A toolkit holds the fourteen checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive72 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

Corvane Industrial order540,000 of 600,000 shares filled at $50.31 against an interval VWAP of $50.27: an implementation shortfall of $272,660 (91.1 bps), against $180,000 (60.1 bps) had the risk price of $50.20 been accepted
Tarrowmere Logistics block2,000,000 shares bought at $38.80 for $77.6 million, 1,500,000 placed at $39.00 before the open, 500,000 hedged with a sector fund: a desk P&L of $357,800
The desk in 2025$192.0 million of revenue, $156.0 million of costs, $36.0 million before tax and a pre-tax return of 15.0 percent on $240.0 million of allocated equity

The files are provided as they are, without warranty of any kind. The model is illustrative: Halvard Crane Securities and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is investment, legal or tax advice.

Also by Julian R. Sterling

More in corporate finance, markets and banking, with free companion files. The full list of titles is on the author page.

Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.