GNUCash Import QIF - Help Please!

[David Carlson]

On 6/22/2015 10:25 PM, GT-I9070 H wrote:
> 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
>

I am still not fully understanding what you are looking for.  If a given
transaction involves two (or more) currencies, it will have an inherent
exchange rate which should be correct therein if it is entered
correctly.  I.e., if I buy a bag of candy marked US$5.00 and pay for it
with a certain number of Euros, there is an exact exchange rate within
the transaction. 

Conversely, if I buy a bag of candy priced in Euros and pay in Euros,
then there are no US dollars involved in that transaction and there is
no exchange rate to track.

Both of those cases can be tracked correctly in GnuCash, although the
first case is more difficult to enter correctly, and may need to be
post-edited if it was imported from an external source. 

To accomplish the first case, there would need to be an expense account
for candy expressed in US dollars, and the second case would use an
expense account for candy expressed in Euros.  To keep those straight,
one would probably need to somehow code the currency names into the
account names, say by calling one Candy$ and the other Candy€.

David C