Free teaching worksheet

Stock share cash ledger

One declared linear-share entry, up to two exits, signed cash events and account-currency translation. No live quotes or broker connection.

Incomplete: enter every required assumption.

Realised price outcome / quote
Unknown
Share-weighted exit price
Unknown
Shares still open
Unknown
Complete-position net / account
Unknown

Completed fictional example

Long 100 shares at 40. Forty exit at 42 and sixty at 39. Gross is 20 quote units; weighted exit is 40.20. Cash events +10 and costs 5 yield 25 net quote units, translated at .8 to 20 account units. Short direction reverses only the price component; the signed cash event retains its declared meaning.

If only forty exit, realised price outcome is 80 and sixty remain open. The tool refuses to present a complete-position net result. Costs and cash events are treated as complete-position amounts, not automatically allocated to the partial exit. Zero share quantity permits a blank unused exit price; positive quantity requires a strictly positive price.

What this ledger does not establish

All inputs are declarations, not authenticated market or provider records. Fractional share quantities are arithmetic only and do not establish broker eligibility. Prices, shares and conversions have bounded input magnitudes, and excessively large output arithmetic is rejected. Blank required inputs do not silently become zero.

Use actual fills or clearly label hypothetical prices. Execution differences already embodied in actual fills must not be deducted again as separate slippage. No distribution entitlement, costs, exchange rate, capital denominator, taxes, short borrow or appropriate share size is inferred. An export is a saved calculation, not an audit or investment recommendation.