These forums have been archived and are now read-only.

The new forums are live and can be found at

EVE Technology Lab

  • Topic is locked indefinitely.

[HELP] Google sheet & Corp Wallet

Hemah ituini
Invicta Scorpius Inc
#1 - 2017-05-13 15:42:14 UTC
Is there any way to import a corporation wallet into a google sheet

What im wanting to do is

Get Wallet Balance for each wallet
Transactions and who made them

Any help would be great
#2 - 2017-05-13 17:12:46 UTC
Yes. You can use the old XML API for this until the features are added into ESI.

This will list the accountKeys for each wallet where 1000 is master wallet.

This will list the balance for each wallet.

So to use this you would have the first one in one column, then the other in the column next to it. The first column would have each account key then the second would show the balance for that wallet division.

For the transactions you can use the same method but with the walletTransactions endpoint. Docs are found here:

Example to get the transaction Datetime of each transaction in the master wallet would be like:

Can use the docs and figure out how you want to set it up.

Hemah ituini
Invicta Scorpius Inc
#3 - 2017-05-14 08:24:47 UTC
Perfect thanks