EVE Technology Lab

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.

=IMPORTXML("https://api.eveonline.com/corp/AccountBalance.xml.aspx?keyID=YOUR_KEYID&vCode=YOUR_vCODE","//row/@accountKey")

This will list the balance for each wallet.

=IMPORTXML("https://api.eveonline.com/corp/AccountBalance.xml.aspx?keyID=YOUR_KEYID&vCode=YOUR_vCODE","//row/@balance")

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:
http://eveonline-third-party-documentation.readthedocs.io/en/latest/xmlapi/character/char_wallettransactions.html

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

=IMPORTXML("https://api.eveonline.com/corp/walletTransactions.xml.aspx?keyID=YOUR_KEYID&vCode=YOUR_vCODE&acountKey=1000","//row/@transactionDateTime")

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