GNUCash Import QIF - Help Please!

[GT-I9070 H]

Many, many thanks to you!

Now I know which way to continue my work.

Regards
GTI

2015-06-22 12:01 GMT-04:00 Derek Atkins <warlord at mit.edu>:

> Hi,
>
> GT-I9070 H <gti9070h at gmail.com> writes:
>
> > 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) ???
>
> As far as I know, no, there is no way to import an exchange rate for
> currency transactions.  (It's possible that OFX might be able to do so,
> but I'm not sure).
>
> > Regards
> > GTI
>
> -derek
>
> > 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
> >
>
> --
>        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
>