I'm trying to automatize the process of import financial data from my stock broker to Gnucash. I'm looking for a way of export the Excel data from my broker to QIF of other suitable format to be imported by GnuCash. Here is an example:
Date Action Memo Stock code quantity Unity value
13/10/2017 Buy RNGO11 108 Buy RNGO11 108 77,26
I transfer money from my other account to my broker account and after I buy or sell the stocks. So, in the transaction above, I have a certain amount of money transferred from my bank account to my broker account and I want to register the buying of 108 units of stock RNGO11 at 77,26 each unit. I have a destination account called RNGO11 to receive the stock quantities.
Is it possible to do it by CSV or by QIF (using XLF2QIF tool)?