Opening & Closing Balanaces

Hi All   I'm trying to return the opening and closing balances of a data set and I'm either getting the formula wrong or my data needs some corrections.   Below is a filtered sample of the data s...