For those that are tracking performance/trades in Excel, how do you account for spin-offs and M&A transactions in Excel. For example, when stock X automatically converts into stock Y after being bought out. Or in a spin-off when you automatically get new stock A?
