currency conversion
Moderator: Renato
-
- New User
- Posts: 8
- Joined: Mon Apr 07, 2014 11:25 am
- Are you a spam bot?: No
currency conversion
I use 2 currencies in my accounts, £ and US$, predominantly the former. In the accounts it shows the currency symbols but does not convert the $ to £ when totalling up the accounts. Also I have some investments in $ and these do not seem to be able to be shown in the different currency. Am I doing something wrong or missing something?
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: currency conversion
if more than 1 acounts created then possible to assign any currency to any account. One account - one currency
-
- New User
- Posts: 8
- Joined: Mon Apr 07, 2014 11:25 am
- Are you a spam bot?: No
Re: currency conversion
Thanks for this. I have now made separate accounts for the different currencies. The one for US$ seems to work ok, but the one in Euros when I enter the purchase price with a decimal of euro (ie 73.9) it enters it as 739.00. Similarly for the updated price. This gives a totally incorrect figure for the value of the holding. Again, am I doing something wrong or is there a problem?
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: currency conversion
Please check currency settings for EUR in currency manager
-
- New User
- Posts: 8
- Joined: Mon Apr 07, 2014 11:25 am
- Are you a spam bot?: No
Re: currency conversion
I seem to be getting there.
I have just downloaded the latest version 1.00.3 and see that in the investment accounts there now is no "refresh" button. Each share has the ability to go to dispaly its web page but one cannot refresh the "latest price".
I also have a problem with one share in Euros. It is C&C Group (CCR.L). Whenever it updates the price it always goes back to a figure of 0.05 despit the actual price being 4.61 per the web page.
Sorry to keep bugging you like this.
I have just downloaded the latest version 1.00.3 and see that in the investment accounts there now is no "refresh" button. Each share has the ability to go to dispaly its web page but one cannot refresh the "latest price".
I also have a problem with one share in Euros. It is C&C Group (CCR.L). Whenever it updates the price it always goes back to a figure of 0.05 despit the actual price being 4.61 per the web page.
Sorry to keep bugging you like this.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: currency conversion
Share prices update button
-
- New User
- Posts: 8
- Joined: Mon Apr 07, 2014 11:25 am
- Are you a spam bot?: No
Re: currency conversion
I am still having some problem with the updating of 2 shares. One, CCR.L, is in a Euro account and the other, QIF.L, is in a US$ account. When automatically updating the price it enters a figure which has the decimal point 2 places too far left. ie. it shows 0.016 instead of 1.6. Other shares in these 2 accounts update correctly.
Also when updating the two currencies, Euro and US$, it says for each "invalid value".
Can you help, please
Kind reagrds
Mike
Also when updating the two currencies, Euro and US$, it says for each "invalid value".
Can you help, please
Kind reagrds
Mike
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: currency conversion
In one hand we have some prices (testing with wget):
wget "http://finance.yahoo.com/d/quotes.csv?s ... f=snd1l1t1" -qO-
"QIF.L","QATAR INVEST USD","4/16/2014",1.315,"9:44am"
wget "http://finance.yahoo.com/d/quotes.csv?s ... f=snd1l1t1" -qO-
"CCR.L","C&C GROUP","4/16/2014",4.482,"9:53am"
In other hand some notes in the source code:
here http://finance.yahoo.com/echarts?s=CCR.L
Currency in EUR.
https://finance.yahoo.com/echarts?s=HSBA.L
Currency in GBp.
After update QIF.L=0.0132 & CCR.L=0.0447
Seems best way is remove HACK and add one more currency GBp.
wget "http://finance.yahoo.com/d/quotes.csv?s ... f=snd1l1t1" -qO-
"QIF.L","QATAR INVEST USD","4/16/2014",1.315,"9:44am"
wget "http://finance.yahoo.com/d/quotes.csv?s ... f=snd1l1t1" -qO-
"CCR.L","C&C GROUP","4/16/2014",4.482,"9:53am"
In other hand some notes in the source code:
Code: Select all
//**** HACK HACK HACK
// Note:
// 1. If the share is a UK share (e.g. HSBA.L), its downloaded value in pence (outdated???????)
// 2. If the share is not a UK share (e.g. 0005.HK) while we are using UK Yahoo finance, we do not need
// to modify the price
//// UK finance apparently downloads values in pence
//if (!yahoo_->Server_.CmpNoCase("uk.finance.yahoo.com"))
// dPrice = dPrice / 100;
//// ------------------
Currency in EUR.
https://finance.yahoo.com/echarts?s=HSBA.L
Currency in GBp.
After update QIF.L=0.0132 & CCR.L=0.0447
Seems best way is remove HACK and add one more currency GBp.
Re: currency conversion
Hello. I have a little bit of problem. Our country are changing currency and I do not want to create new accounts. Is there any way, to convert all my transactions to the other currency with exact conversion rate?
If I change account currency, it only changes prefix symbol, but does not convert all my transactions.
If I change Base Currency, it only changes the Grand total.
Thanks for help.
If I change account currency, it only changes prefix symbol, but does not convert all my transactions.
If I change Base Currency, it only changes the Grand total.
Thanks for help.
- GabrieleV
- Developer
- Posts: 158
- Joined: Wed Apr 09, 2014 7:45 pm
- Are you a spam bot?: No
- Location: Italy
Re: currency conversion
Currently I don't think that there is an interface solution:
if you know something about SQL you could try with a direct update on DB.
if you know something about SQL you could try with a direct update on DB.