Unfortunately, there is probably no easy way of doing this. You can try to sum the book value and proceeding amount into 2 periods using google sheet or excel(Period 1 - Transactions before June 24 and Period 2 - Transactions post that date) and use the total amount.
