How should investments be recognized on a balance sheet?

@jwvanderbeck, ah yes, it’s on the community now:

Using Google Sheets to Track Your Investment Portfolio