[GNC] CSV import of fund transactions

[Geert Janssens]

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.