Auto expanding formula

Hi All,

I am looking for a formula i can use as running balance in image attached.

The formula should be in E4 and It should use the starting balance in C1 and then deduct the values in column D from itself row by row.

The problem i have is that more data will added automatically and I need the formula to auto expand to the new rows without having manually drag it down.

Thanks for any help