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
> > >
> > > [email protected]
> > >
> > > 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.
_______________________________________________
gnucash-user mailing list
[email protected]
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.
