Attached is a spreadsheet showing how to calculate time weighted return for a share. However my data has multiple shares in it. Is there a way the formula can be adapted to only read data matching a certain criteria. For example on read for data for BHP, then FXL etc.
Thank you kindly for any assistance.
