SQL - 一次根据多个实体的先前行值计算行值

I have the following situation: I have a list of transactions belonging to many investments. A transaction record contains the investment identifier, date and gross amount but NOT the running balance. I have the following situation: I have a list o