Capital gain import - qif or ofx?

Jeff Carneal jeff-ml at soldmy.net
Tue Feb 13 13:10:26 EST 2007


Any ideas about the OFX importer?

Or any hints how would I get started customizing the current QIF  
importer to do it?

Thanks,
Jeff


On Feb 12, 2007, at 9:17 AM, Derek Atkins wrote:

> I think you're right that the QIF importer wont do this.
>
> -derek
>
> Jeff Carneal <jeff-ml at soldmy.net> writes:
>
>> Ok, so I have an account that provides me CSV format transactions
>> that in the past I converted to QIF for import.  I'm sure that will
>> still work with gnucash with one added wrinkle:  accounting for
>> realized capital gains.
>>
>> I'd like to account for them as provided in example 8.7.1 here:
>>
>> http://www.gnucash.org/docs/v2.0/C/gnucash-guide/invest-sell1.html
>>
>> I can easily get the following parts of the transaction to work on
>> QIF import:
>>
>> Assets:Bank                    3525
>> Assets:Stock:SYMBOL              3600
>> Expenses:Commissions   75
>>
>> The part I am unable to get to import correctly is:
>>
>> Assets:Stock:SYMBOL   1600    (shares=0, price=0)
>> Income:Capital Gains                  1600
>>
>> No matter what I try, I cannot get a valid QIF file to import with
>> those two.  The best I've been able to do is the following:
>>
>> Imbalance-USD:       1600
>> Income:Capital Gains             1600
>>
>> It appears that the import cannot reconcile 0 shares for 0 dollars to
>> a total of $1600 so it throws it into the Imbalance account instead.
>>
>> So my questions are:
>>
>> 1)  Can someone show me a .qif entry that will import as this example
>> is written?
>>
>> 2)  If not, is what I am going for possible with an OFX import and
>> can someone give me an example?
>>
>> 3)  Are there hooks such that I could learn scheme (ack!) and write
>> my own importer for exactly this?  Where do I begin?
>>
>> Thanks,
>> Jeff
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>
> -- 
>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>        Member, MIT Student Information Processing Board  (SIPB)
>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>        warlord at MIT.EDU                        PGP key available
>



More information about the gnucash-user mailing list