GNUCash Import QIF - Help Please!

[GT-I9070 H]

Hi Atkins,

Thank you very much for your attention!

Excuse me,
I did not know that there is a correct way to make contact with you, I need
your help and this was the way I found. I will start to participate in the
gnucash-user mailing list. Forgive me.

Would you know tell me if GNUCash Desktop can import exchange rates into
transactions from some file format (CSV, OFX or another) ???

Regards
GTI

2015-06-19 13:27 GMT-04:00 Derek Atkins <warlord at mit.edu>:

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