On works...

---

Well , it has been a hard work these last days, but we are happy since we have got to make transfers work ,and also fetching account balances is much quicker now

I want to send a huge thanks to @luisan00 , he helped a lot working in the Node Api , also he installed a full bitshares node where we can test , he is quite new at steemit and I would appreciate if you give some steem to him ,so he gets mhis community ore involved in it

---

This is the fourth post focused in this development ,our idea was to be able to work in the Openledger DEX from an Excel Workbook

The reason is that since the current wallet is great , we think that when you want to work with many accounts, the Excel user interface is much better since it is thought to work with large amounts of data

---

We get account balances much quicker now , in the gif you can see how we retrieve 10 account balances in approx 1 second , I guess fetching 100 accounts wont me more than 5 or 6 seconds

---

We decided to use the MSXML objects , which are available in any Excel versions and does not require to any installation to work as the first approach

the contras of this option is that we do not know how to call the bitshare node directly , so we have created a NodeJS API which communicates with a full node

---

In this gif you can see some of the coding for this api

)

---

Pulling many account balances to the Excel is cool ,but we think that the really powerfull use of this tool is to make changes to the blockchain

And we have created a first sample where we double-click on a returned balance , and the info is moved to the transfer box, later with a single click we can make many transfers ,We hope this clarify what is our objective

---

)

---

And well , as I already said at the beginning it has really been a busy days , we are going to take this next days more relaxed , controlling the errors and debugging the code before adding more functionalities

We want to explore in the permissions , to be able to manage multiowned accounts and look for new ideas

but before is time for going back to other paid projects we left aside for focusing on this project , since we have to pay bills ,food,cigs and other staff :)

Thanks for reading , and please comment if you like this or have any suggestions