Eve Excel Addin Formulas: Isk in wallet and in Corporation

Perhaps the most common question any Trader will have is what is the ISK balance for a given character and / or Corporation.

Using the Eve Excel Addin:

In the formulas below, Cell B9 is the character id number

Character ISK Balance

 

This is perhaps one of the most straight forward formulas.

=EVEONLINE.CHARACTER_WALLET_BALANCE(B9)

Nothing more to say.

Corporation ISK Balance

=SUM(EVEONLINE.CORPORATION_WALLETS(B9).balance)

lets break this down:

This is a little more complicated.

Firstly, you will be aware that a Corporation Wallet has a number of Divisions.

Secondly, the data is held at character level.  Hence, you don't use the Corporation ID, you use the CEO id (technically you can use any character that has access to all the wallet slots, but the CEO seems the most obvious to me).

EVEONLINE.CORPORATION_WALLETS(B9) will give a list of the Divisions with the ISK amount in each division.

The first step is to use the .balance method to call up the isk balance in each division.

EVEONLINE.CORPORATION_WALLETS(B9).balance

And then use the excel SUM function to add those isk balances up:

=SUM(EVEONLINE.CORPORATION_WALLETS(B9).balance)