GNUCash Import QIF - Help Please!

[Derek Atkins]

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