RECURSIVE CALCULUS

I have a DB built in the following way:

Item | Date | stock | purchase orders | forecast

I would like to obtain a column calculate in the following way:

stock of the previous period+Purchase orders-forecast

in order to get a stock projection over time.

the formula should be the following: