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 
correctly.

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 mailing list