Can the worksheet generate a summary for each individual investment?

You can see a list of transactions for any asset (or account, or date range, etc.) by using the built-in filters on the Worksheet tab.