I have tried that and it will just give a formula

Here is the formula in an example cell:

=-SUM(ADGET("gldata.BAL",$A10))