exporting balance and exposure to Excel

[brecki]

Hi,

is there any possibility to get the balance and exposure shown in Excel exported by BA ? And how can it be updated regularly?

Thx.

[GaryRussell]

Yes. When you set up the Excel link tick "Show balance". The balance is output to cell I2 and the exposure to L2.
The balance is only auto updated when you change markets. To update in between you need to insert "U" in J2. You will need to use VBA instead of a formula to do this because it clears the cell after updating the balance to prevent a continuous update.