GNUCash Import QIF - Help Please!

Derek Atkins warlord at MIT.EDU
Fri Jun 19 13:27:30 EDT 2015


Hi,

I'm not sure why you sent this to me directly; you should have sent this
to the gnucash-user mailing list.  I've cc'd the list so please use your
mailer's reply-all to reply to this email.

GT-I9070 H <gti9070h at gmail.com> writes:

> Hi Dev,
>
> I need your help.
>
> I wrote a VBA Code to export transactions from MS Excel to .qif file format.
> It works great, but I would also export transaction exchange rates. Currently
> I export exchange rates to "No." GNUCash field through the "N" .qif file
> field.
>
> Are there any field in .qif file that is imported into the "Exchange
> Rate" field of GNUCash ???
>
> If so, could you tell me what it is?

I'm afraid that there is no such field, because QIF does not handle
multiple currencies, only stocks and mutual finds (which have their own
quantity/price fields within QIF).  But for e.g. USD to CAD, there is no
QIF field that will import into the exchange rate field.

> PS: My VBA code is at your disposal!
>
> Best Reagards
> GTI

-derek

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