OFX Import via AQBanking
Stephen R. Besch
sbesch at buffalo.edu
Mon May 11 12:27:17 EDT 2009
At the current time, importing transactions using "Actions...Online
Actions...Get Transactions" only supports bank and credit card
transactions. I have been working on extending the OFX importer in
aqbanking to also import investment transactions. Up to now, I have the
transaction list builder working and importing dividend and income
transactions into GnuCash. These additions have been committed to
aqbanking svn as of r1692. However, I need some additional help to
finish the project and get stock trades (buy, sells, etc) to importing
What happens now, with all transactions posted to one list, is that
stock trades show up as cash transactions in the same account as the
dividend and interest postings. The rest of the security data is
ignored. I believe that part of what needs to be done is to generate a
separate account Info structure (AB_ImExporterAccountInfo) for each
stock and then put all buy/sell transactions for that stock in the list
attached to that specific AB_ImExporterAccountInfo object. That way
GnuCash should be able to associate each returned list with it's own
subaccount and put the transactions into the correct account.
What I don't know, and what I need help with, is:
1) Whether GnuCash will see and deal with multiple
AB_ImExporterAccountInfo objects coming back on a single job request.
2) Will GnuCash recognize and properly handle trade price, share
units, CUSIP numbers, etc. If not, why not?
3) Is the current failure to properly import stocks simply because I
have lumped all transactions into one list?
4) Who else is working on the GnuCash half of the online OFX importer?
Stephen R. Besch
Platform: x86_64 GNU/Linux 2.6.24-24-generic/SMP
GnuCash version: 2.2.99 - svn trunk r18066
Gwenhwyfar version: svn trunk r1539
Aqbanking version: 3.99.11 svn trunk r1696.
More information about the gnucash-devel