GNUCash Import QIF - Help Please!

[GT-I9070 H]

Hi David,

Thanks for the tip!

But I do not want the Internet exchange rates, I want to exchange rates
(currency prices) that I practiced on that date in every transaction that I
have written in an MS Excel spreadsheet.

Regards
GTI

2015-06-22 18:17 GMT-04:00 David Carlson <david.carlson.417 at gmail.com>:

> On 6/22/2015 11:49 AM, GT-I9070 H wrote:
> > 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
> >>
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> It is possible to download currency prices with the Price Editor via the
> Internet similar to retrieving stock prices.  See
>
> http://www.gnucash.org/docs/v2.4/C/gnucash-guide/currency_howto1.html#currency_howto_Auto
> .
>
>
> David C
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>