Firebird 4.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table tbtrades(id_trade integer, ENTRY_DATE date, EXIT_DATE date, Ergebnis NUMERIC(9,2), zuKonto VARCHAR(3))
EXECUTE BLOCK AS BEGIN
insert into tbtrades values(1, CURRENT_DATE-50, CURRENT_DATE-50, 10, '3');
insert into tbtrades values(2, CURRENT_DATE-50, CURRENT_DATE-40, 20, '4');
insert into tbtrades values(3, CURRENT_DATE-50, CURRENT_DATE-30, 30, '3');
insert into tbtrades values(4, CURRENT_DATE-50, CURRENT_DATE-20, 40, '4');
insert into tbtrades values(5, CURRENT_DATE-50, CURRENT_DATE-10, 50, '3');
END
5 rows affected

SELECT id_trade, EXIT_DATE, Ergebnis,
(
SELECT SUM(Ergebnis)
FROM tbtrades y
WHERE y.EXIT_DATE <= x.EXIT_DATE AND y.id_trade <= x.id_trade AND  zuKonto = '4'
)
FROM tbtrades x
WHERE  (Entry_Date >='27.12.2022' AND Exit_Date <= '31.03.2023') AND  zuKonto = '4'
ORDER BY x.EXIT_DATE, x.id_trade


ID_TRADE
EXIT_DATE
ERGEBNIS
SUM


2
2023-02-17
20.00
20.00

4
2023-03-09
40.00
60.00