Daily Amount

Hi,

 I have account number, account suffix, amount, name and trandate. I try to make a calculation. customer made his first transaction at 30/09/2015 which positive number and this means it is a investing money. There is also negative numbers which has - before it means taking money.  I try to calculate customer's daily amount. In this example customer invest money at 30/09/2015. after this draw money. after that again draw money. I want to calculate end of day balance. Additionally, as you see the customer did not make any transaction at 03/10/2015. In this case last balance amount must be written to 03/10/2015 day balance. To sum up, I want to calculate daily balance whether the customers make transactions or not on calendar date. The date can be start beginning of the 2015 and can end on end of the 2025. If the calendar day before customer's first transaction day it can be null. I can not find any solution for this.

PS: The data has 5 million rows so i can face with memory problems.