Hi Timothy I've changed the subject and I'm copying this to the list also, as it may be that others, with experience in this area may be able to help.
On Fri, 20 May 2011 20:40:49 +0200 timothy <timbo...@afrihost.co.za> wrote: > Hi > > barclays.csv > date,transaction,#units,message,unitprice,cost/amount > do not know what CHG means, but always interest > Yes barclays is a savings account in England so I treat it as an > investment account with the exchange rate as the unit price here in > South Africa - a throwback from the original MsMoney account. > > > The iobexport.csv is exactly what I get from Barclays Bank. I > > > then awk it into barclays.csv. If I understand correctly, you get a file from your UK bank from an account which is actually a savings account, and you translate that to another file, applying the exchange rate as the currency exchange rate, and treat it as an investment account? Is that correct? If so, why? You may have a personal reason for doing it that way, but it is a bit obscure. Would it not be more straight-forward to have a savings account denominated in GBP, and then make transfers to your cheque account, which I assume is denominated in ZAR? Kmm would then take care of the currency conversion automatically, except perhaps you will need to provide the current rate. However, It would appear that that need two transactions. To avoid that, unless, anyone knows better, make it an investment account denominated in GBP, and use DIVX to transfer automatically to your cheque account. Allan (Anderson) _______________________________________________ KMyMoney-devel mailing list KMyMoney-devel@kde.org https://mail.kde.org/mailman/listinfo/kmymoney-devel
