I have a couple of questions:

My base currency is GBP but one of my bank accounts is EUR.

1. When reporting transactions by category on the EUR bank account and selecting "Convert values to base curency" the value of the transaction does not change and is still shows the euro amount.
The only difference I can see when the convert box is unticked is that "EUR" appears in front of the amount. I would have expected the value to change.
In order to test I manually entered an exchange rate for the date of a transaction and the "price" column displays the rate I entered.

2. I would like to turn off online currency update but can't seem to find a way to do that. The Tools-> Currencies menu only gives the option to set base currency and define symbol unlike the securities update where I can turn on/off online update. The reason for this is I am only interested in rates at the time I fund the euro account from my sterling account.

Thanks
Martin

Can you go to the Tools menu -> Prices... and check that you have a price entered for the date of the transactions to convert EUR to UK?

Xubuntu 9.0.4
KMyMoney 0.9.3-CVS
(As per my sig

Just updated yesterday from Claydoh (but was the same before).

And yes, I have tried a manual price entry for the day in question which shows in the "price" column as mentioned.

I'm not too bothered about this as in any case I need to export to a spreadsheet to format as I want it and can calculate the correct sterling value from the price and transaction value. Its just not quite what I was expecting.

More important is I need to turn off online currency updates for EUR so I don't have to delete them each time.
I can delete the yahoo finance entry, but that would upset other prices I download so don't want to do that.

Thanks
Martin

You should go the corresponding investment, edit it and turn off the automatic update.

Now, can you send me an anonymous file to verify the other problem, that shouldn't happen with the current version.

It is online currency updates for the euro that I want to turn off and I have been unable to find an equivalent to the Tools->Securities for currencies. Tools->Currencies doesn't give me that option.

No problem to send an anonymous file - what address?

Thanks

N.B. Might be a problem - I just tried saving an anonymous file and the figures in the accounts were silly - seems I'm worth over £100M - I wish...

It's ok. That's what the anonymous file is for. It will scramble all numbers, but that will still be meaningful for me to debug. Send the file to asoliverez [at] gmail.com.

About the auto update, I meant, edit your investment account. There is probably one in Euro currency that is set for auto update.

File on its way.

No euro securities defined in investment accounts - all in GBP

Is the fact I have a euro bank account enough to force euro currency updating? Am I odd in not wanting my euros updated?

The reason is that I want the transactions to be reported at the exchange rate I funded them at when I transferred money from my sterling bank account which I do every few months.

I can see ways to work round this, but nothing so convenient as simply telling KMyMoney not to download EUR-GBP update rates!

Thanks again

Hmmm, the transactions are reported at the rate of the day of transaction, not at the current rate.

An update on the transaction reports. You were right, there is a problem with the way the splits are displayed. They are displayed on the currency of the split, which might be different from the main split, but the currency symbol being used is the one of the main split.

So, if you have a foreign currency where you have made an expense to a category that is based on the base currency, you will see the number on base currency, but the symbol of the foreign currency. Tricky, right?

Ok, the solution to this is to convert all splits to the currency of the main split, which sounds easier than it is, but I will try to have it ready in a couple of days.

Well that's fantastic - thanks very much. If I can have the report display in the base currency then I don't have to export to a spreadsheet and calculate it myself!

The report seem s to "remember" the last previous currency update (manual or online which is again is exactly what is required.

Is there any chance of finding a way to disable on-line currency updates of euro?

As I said previously, I only want the euro rate updated at the time I fund the account from sterling which happens automatically when I enter the transfer.

At the moment I have worked round by removing all the settings for "Yahoo Currency" in Settings->Configure KMyMoney->Online Quotes which does the trick. However I get a "price update failed" when I do a global price update and have to continue. This happens twice, once for GBP->EUR and once for EUR->GBP. That is much quicker than going into the prices editor and removing the downloaded prices. Of course this also disables any other currency updates but I don't need those at present.

I need to report on transactions that are mixed currencies on the basis of the rate at which the currency was funded and KMyMoney handles this situation very well - already much better than MSMoney. Once these small issues are ironed out it will work like a dream!

Thanks again for looking at this for me.

Things are becoming clearer to me - I have been confused...

I recently imported all my accounts by QIF from MSMoney.

MSMoney has no record of the exchange rate at the time of entry of a transaction.

It seems to me that KMyMoney records the exchange rate at the time the transaction is entered.

Therefore importing by QIF means that I have bypassed all that so the exchange rate for imported transactions is garbage (seems to default to 1).

I have demonstrated that to myself by re-entering an imported transaction that had the wrong conversion to base currency, entering the correct rate when prompted. The report then displays the correct amount for the transaction converted to base currency.

So I have a whole lot of historical transactions that are wrong when expressed as base currency. Now that I know, this is not an issue - going forward everything will work out fine. The only way to correct this would be to go to every historical transaction and enter the correct rate I think I'll pass on that. I may just correct this year's transactions.

Not a KMyMoney problem - a deficiency of MSMoney/QIF import.

Editing Tools-Prices does not affect the transactions so I assume the rate is saved as part of the transaction record which makes perfect sense.

So I think three conclusions:

1. In the report the price column shows the latest price from the downloaded prices and not the transaction rate. It would possibly be better to show the transaction conversion rate, but that is not important to me.

2. There is still the issue of the report showing the converted value of a transaction whatever option is selected. I think that should be fixed.

3. I really would like to be able to turn off currency online updating for reasons already discussed.

Ok, we have understood the desire to turn off the auto D/L of conversion rates. Right now, we're in the feature freeze, so it won't happen until we released 1.0. After that, it does not seem to be too hard to add.

Did you already file a feature request on http://sourceforge.net/tracker/?group_i ... tid=354708

I think other people had no problem with the rates. Are you sure there is no way to export a QIF file that contains that information?

Thanks for the steer - I've filed a request as suggested.

Does fixing the bug in the report also need some form of formal request?

Hei Ku wrote:I think other people had no problem with the rates. Are you sure there is no way to export a QIF file that contains that information?

No, I'm not sure - but AFAIK MSMoney doesn't keep historical currency prices. I just had a look at the QIF file that I exported from one of my foreign currency accounts and there's no exchange rate information attached to the transactions.