GNUCash Import QIF - Help Please!

[David Carlson]

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