[GNC] CSV import of fund transactions

[Alaeddin Aydiner]

Hi Geert,

You are right. The solution involves just adding a "Transaction 
Commodity" column and entering USD (in my case) for both lines. I feel 
this is a documentation issue, which this email thread is already 
fixing; so I will personally not bother to file a ticket on this.

Date,Description,Transaction Commodity,Account,Deposit,Price

04/5/2020,Fund Dividend REINVESTMENT @ 31.5244,USD,Brokerage 
Account:Mutual Fund:Fund,0.03902,31.522296258329064

,,USD,Income:Dividend Income,-1.23,1.0

Thanks & regards,

Alaeddin.

On 4/10/20 2:02 AM, Geert Janssens wrote:
>
> Ok, I see.
>
> The problem is likely your csv file doesn't provide a transaction 
> currency. In that case the currency of the first split will be used as 
> transaction currency. That would not work correctly in your case as 
> the first line is actually in the foreign currency (with exchange rate).
>
> I haven't tested yet, but you could try two things:
>
> - Either add a column that sets the transaction currency
>
> - Or swap the split data such that the split in the native currency is 
> the first in the transaction.
>
> I vaguely remember this issue was mentioned in the past, but I don't 
> know if there is a bug report for this already. Can you please file 
> one in bugzilla [1] ?
>
> Thank you.
>
> Regards,
>
> Geert
>
> [1] Refer to http://wiki.gnucash.org/wiki/Bugzilla on how to use our 
> bug tracker
>
> Op vrijdag 10 april 2020 09:25:05 CEST schreef Alaeddin Aydiner:
>
> > I just compiled 3.9 from its sources as you suggested. The GUI's about
>
> > window confirms that:
>
> >
>
> > Version: 3.9 Build ID: 3.9+(2020-03-28) Finance::Quote: 1.47
>
> >
>
> > But I am afraid the bug is still not fixed. With the 3-lines of CSV
>
> > below, the fund is still priced as $1 and its price on the order of $31
>
> > is ignored. Everything else is properly handled in the multi-split 
> import.
>
> >
>
> > Regards,
>
> >
>
> > Alaeddin.
>
> >
>
> > On 4/9/20 1:27 AM, Geert Janssens wrote:
>
> > > Hi,
>
> > >
>
> > > I have fixed a bug wrt to this for gnucash 3.9. Can you retry with
>
> > > that version and report back whether it works now ?
>
> > >
>
> > > Regards,
>
> > >
>
> > > Geert
>
> > >
>
> > > Op donderdag 9 april 2020 08:04:07 CEST schreef Alaeddin Aydiner via
>
> > >
>
> > > gnucash-user:
>
> > > > Hello,
>
> > > >
>
> > > >
>
> > > >
>
> > > > I could not get the price of a mutual fund imported to GnuCash 
> 3.6 and
>
> > > >
>
> > > > 3.7 through a CSV. Everything else seems to get imported just 
> fine. Has
>
> > > >
>
> > > > anyone managed to achieve this?
>
> > > >
>
> > > >
>
> > > >
>
> > > > The CSV looks like the following for a mini dividend reinvestment:
>
> > > >
>
> > > >
>
> > > >
>
> > > > Date,Description,Account,Deposit,Price
>
> > > >
>
> > > > 04/5/2020,Fund Divident REINVESTMENT @ 31.5244,Brokerage 
> Account:Mutual
>
> > > >
>
> > > > Fund:Fund,0.03902,31.522296258329064
>
> > > >
>
> > > > ,,Income:Dividend Income,-1.23,1.0
>
> > > >
>
> > > >
>
> > > >
>
> > > > When this is imported, the split transaction is imported 
> correctly but
>
> > > >
>
> > > > the price of the fund is not. I tried the fractional form of the 
> price
>
> > > >
>
> > > > as well. I can put it in any required format as the CSV is 
> generated by
>
> > > >
>
> > > > a script already. BTW, if there is a GnuCash python example, I'd 
> be fine
>
> > > >
>
> > > > with that too.
>
> > > >
>
> > > >
>
> > > >
>
> > > > Thanks in advance!
>
> > > >
>
> > > >
>
> > > >
>
> > > > _______________________________________________
>
> > > >
>
> > > > gnucash-user mailing list
>
> > > >
>
> > > > gnucash-user at gnucash.org
>
> > > >
>
> > > > To update your subscription preferences or to unsubscribe:
>
> > > >
>
> > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> > > >
>
> > > > If you are using Nabble or Gmane, please see
>
> > > >
>
> > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more 
> information. -----
>
> > > >
>
> > > > Please remember to CC this list on all your replies.
>
> > > >
>
> > > > You can do this by using Reply-To-List or Reply-All.
>