1.3.3. Multiple Currencies not working correctly
Moderator: Renato
-
- New User
- Posts: 8
- Joined: Thu Jul 20, 2017 9:18 am
- Are you a spam bot?: No
1.3.3. Multiple Currencies not working correctly
I have been using multiple currencies for a very long time with MMEX.
However around the end of October this feature effectively no longer works correctly. This is the case when using the online update function OR the manual changing of currency rates.
The root cause appears to be that the online update of currency values no longer works (I get an error message - cannot get data from WWW!). This in turn appears to be caused by the YAHOO service no longer being available (see https://yahoo.sdx.socialdynamx.com/port ... n/19248672). In other words YAHOO have disabled this service (there are of course other sources for the same information)
If I try to manually update the currency values, the new value appears in the currency dialog, BUT importantly the grand totals on MMEX do not change. So entering manually the current currency exchange rate seems to have no effect.
So for me, the MMEX multiple currency function now no longer works correctly.
This has been reported partly in post by mr108 on the 1st November (the issue for him being stock prices and currency updates not working - for presumably the same reason).
Is there a work around that actually works?
Regards
John
However around the end of October this feature effectively no longer works correctly. This is the case when using the online update function OR the manual changing of currency rates.
The root cause appears to be that the online update of currency values no longer works (I get an error message - cannot get data from WWW!). This in turn appears to be caused by the YAHOO service no longer being available (see https://yahoo.sdx.socialdynamx.com/port ... n/19248672). In other words YAHOO have disabled this service (there are of course other sources for the same information)
If I try to manually update the currency values, the new value appears in the currency dialog, BUT importantly the grand totals on MMEX do not change. So entering manually the current currency exchange rate seems to have no effect.
So for me, the MMEX multiple currency function now no longer works correctly.
This has been reported partly in post by mr108 on the 1st November (the issue for him being stock prices and currency updates not working - for presumably the same reason).
Is there a work around that actually works?
Regards
John
- GabrieleV
- Developer
- Posts: 158
- Joined: Wed Apr 09, 2014 7:45 pm
- Are you a spam bot?: No
- Location: Italy
Re: 1.3.3. Multiple Currencies not working correctly
You need to add value to currency history.
If at least one value is present in currency history, the one nearest to transaction date will be used.
Fixed change rate on currency it's used only if currency history is completely empty.
Inviato dal mio Nexus 5X utilizzando Tapatalk
If at least one value is present in currency history, the one nearest to transaction date will be used.
Fixed change rate on currency it's used only if currency history is completely empty.
Inviato dal mio Nexus 5X utilizzando Tapatalk
-
- Senior User
- Posts: 37
- Joined: Sun Oct 29, 2017 11:22 am
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
I already have 4 values in the current history and now I added manually another one and it's still not working - getting "Cannot get data from WWW!" error message.GabrieleV wrote:You need to add value to currency history.
If at least one value is present in currency history, the one nearest to transaction date will be used.
Fixed change rate on currency it's used only if currency history is completely empty.
Any other ideas how to fix it?
-
- New User
- Posts: 8
- Joined: Thu Jul 20, 2017 9:18 am
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
GabrieleV wrote
--------------------------------------------------------------------
"Sun Nov 05, 2017 4:14 am
You need to add value to currency history.
If at least one value is present in currency history, the one nearest to transaction date will be used.
Fixed change rate on currency it's used only if currency history is completely empty.
Inviato dal mio Nexus 5X utilizzando Tapatalk"
------------------------------------------------------------------
Many thanks for the reply, BUT unfortunately it still does not work (and I have many historical exchange rates)! By adding a new value manually, the table of currency exchange rates is updated BUT it is not applied to the totals shown on the Home page. When the online update facility was working (which it is not now), the new values were applied to the home page.
I have tried adding different values manually which have updated the screen list of exchange rates, but are never applied to the home page (obviously an ERROR in the code).. I have also tried closing and restarting MMEX but the new manual values are NOT applied. i.e. The new (manually entered) values are shown on the "organise currency" window, but are not applied to the values shown on the home page.
Therefore for me, Multiple currencies are still not working. There appears to be two separate issues here:-
1. Manually entered exchange rates update the "Organise currencies" window but are not applied.
2. The online update of currencies is no longer working (probably due to changes at yahoo - see my original post above).
One of the above problems needs fixing quickly (or a work around that actually does work) or I have to forget using MMEX for multiple currencies (which means for me using other software). Additionally, I believe that the second problem above is also causing stock price update problems (see two other posts on the forum below mine). So the implications are far greater than I have listed above. I have been using MMEX for a very long time, and have been very happy with it, but this error makes it unusable for me.
Any help would be appreciated.
Regards
John
--------------------------------------------------------------------
"Sun Nov 05, 2017 4:14 am
You need to add value to currency history.
If at least one value is present in currency history, the one nearest to transaction date will be used.
Fixed change rate on currency it's used only if currency history is completely empty.
Inviato dal mio Nexus 5X utilizzando Tapatalk"
------------------------------------------------------------------
Many thanks for the reply, BUT unfortunately it still does not work (and I have many historical exchange rates)! By adding a new value manually, the table of currency exchange rates is updated BUT it is not applied to the totals shown on the Home page. When the online update facility was working (which it is not now), the new values were applied to the home page.
I have tried adding different values manually which have updated the screen list of exchange rates, but are never applied to the home page (obviously an ERROR in the code).. I have also tried closing and restarting MMEX but the new manual values are NOT applied. i.e. The new (manually entered) values are shown on the "organise currency" window, but are not applied to the values shown on the home page.
Therefore for me, Multiple currencies are still not working. There appears to be two separate issues here:-
1. Manually entered exchange rates update the "Organise currencies" window but are not applied.
2. The online update of currencies is no longer working (probably due to changes at yahoo - see my original post above).
One of the above problems needs fixing quickly (or a work around that actually does work) or I have to forget using MMEX for multiple currencies (which means for me using other software). Additionally, I believe that the second problem above is also causing stock price update problems (see two other posts on the forum below mine). So the implications are far greater than I have listed above. I have been using MMEX for a very long time, and have been very happy with it, but this error makes it unusable for me.
Any help would be appreciated.
Regards
John
-
- New User
- Posts: 8
- Joined: Thu Jul 20, 2017 9:18 am
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
Multiple currencies - Temporary Manual work around
========================================
Whilst the original two problems exist, I have at last come up with a work around that does work. The original problems still need resolving though.
WORK AROUND (MANUAL UPDATE)
---------------------------------------------------
To update the currency exchange rate manually, you need to do the following:-
> Tools
>Organise Currency...
Then select/highlight the currency you want to update in the list of currencies.
Then select Edit on the bottom left hand side of the window (opens a currency manager window)
Overwrite the "Conversion to Baserate" value with the new exchange rate.
Select OK (to close window)
Click Close (to close Currency Dialog window).
The new exchange rate is then applied by MMEX.
PROBLEMS that still exist
1. Manual updates of the currency history in the Currency Dialog window, only change the currency exchange rate listed in this window and are not applied by MMEX when reporting multiple currencies (e.g. home page totals etc). This may be because no update is being applied to the currency exchange rate listed on the currency manager window. This error also needs to be investigated, as it is not clear where the fault actually lies.
2. Online Update does not work (since end of October 2017). This is due to the Yahoo service being discontinued (as mentioned above).
I have tested the development version 1.4 today and the two problems above exist in this version also.
Regards
John
========================================
Whilst the original two problems exist, I have at last come up with a work around that does work. The original problems still need resolving though.
WORK AROUND (MANUAL UPDATE)
---------------------------------------------------
To update the currency exchange rate manually, you need to do the following:-
> Tools
>Organise Currency...
Then select/highlight the currency you want to update in the list of currencies.
Then select Edit on the bottom left hand side of the window (opens a currency manager window)
Overwrite the "Conversion to Baserate" value with the new exchange rate.
Select OK (to close window)
Click Close (to close Currency Dialog window).
The new exchange rate is then applied by MMEX.
PROBLEMS that still exist
1. Manual updates of the currency history in the Currency Dialog window, only change the currency exchange rate listed in this window and are not applied by MMEX when reporting multiple currencies (e.g. home page totals etc). This may be because no update is being applied to the currency exchange rate listed on the currency manager window. This error also needs to be investigated, as it is not clear where the fault actually lies.
2. Online Update does not work (since end of October 2017). This is due to the Yahoo service being discontinued (as mentioned above).
I have tested the development version 1.4 today and the two problems above exist in this version also.
Regards
John
-
- Senior User
- Posts: 37
- Joined: Sun Oct 29, 2017 11:22 am
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
I found following services for updating currencies but since I'm not a programmer I don't know if that can be used.
Hopefully MMEX developers can look into this soon - THANKS!
http://fixer.io/
Fixer is a free API for current and historical foreign exchange rates published by the European Central Bank.
The rates are updated daily around 4PM CET every working day.
https://www.alphavantage.co/
https://www.alphavantage.co/support/#api-key
http://www.mycurrency.net/page/Free+Cur ... verter+API
http://www.jarloo.com/real-time-google-stock-api/
https://1forge.com/forex-data-api/pricing (1,000 requests per day)
https://www.nbp.pl/homen.aspx?f=/kursy/ ... ut_en.html
https://www.barchart.com/ondemand/free-market-data-api
Up to 100 symbols per query, and up to 2,500 queries per day
https://api.tiingo.com/
https://api.tiingo.com/pricing
Requests Per Day 20,000
Hopefully MMEX developers can look into this soon - THANKS!
http://fixer.io/
Fixer is a free API for current and historical foreign exchange rates published by the European Central Bank.
The rates are updated daily around 4PM CET every working day.
https://www.alphavantage.co/
https://www.alphavantage.co/support/#api-key
http://www.mycurrency.net/page/Free+Cur ... verter+API
http://www.jarloo.com/real-time-google-stock-api/
https://1forge.com/forex-data-api/pricing (1,000 requests per day)
https://www.nbp.pl/homen.aspx?f=/kursy/ ... ut_en.html
https://www.barchart.com/ondemand/free-market-data-api
Up to 100 symbols per query, and up to 2,500 queries per day
https://api.tiingo.com/
https://api.tiingo.com/pricing
Requests Per Day 20,000
-
- Senior User
- Posts: 37
- Joined: Sun Oct 29, 2017 11:22 am
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
I tested again with the latest version of Android MMEX and it can now update both currencies exchange rates and stock prices.
Exchange rates are updated with Fixer
http://fixer.io/
Fixer is a free API for current and historical foreign exchange rates published by the European Central Bank.
The rates are updated daily around 4PM CET every working day.
although this one https://www.alphavantage.co/ could be better since it can provide the cryptocurrencies prices as well
https://www.alphavantage.co/support/#api-key
and
Stock prices are updated with Morningstar.
and https://www.alphavantage.co/ is also providing stock prices
Perhaps same thing could be done with the desktop app?
Exchange rates are updated with Fixer
http://fixer.io/
Fixer is a free API for current and historical foreign exchange rates published by the European Central Bank.
The rates are updated daily around 4PM CET every working day.
although this one https://www.alphavantage.co/ could be better since it can provide the cryptocurrencies prices as well
https://www.alphavantage.co/support/#api-key
and
Stock prices are updated with Morningstar.
and https://www.alphavantage.co/ is also providing stock prices
Perhaps same thing could be done with the desktop app?
- Renato
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: 1.3.3. Multiple Currencies not working correctly
it is really not necessary to post the same post in three different forums.
Renato Forum Administrator
-
- Senior User
- Posts: 37
- Joined: Sun Oct 29, 2017 11:22 am
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
Yes, Renato, I know, but I thought that maybe the developers may miss it otherwise.Renato wrote:it is really not necessary to post the same post in three different forums.
I'm really eager to get it working properly, that's why...
I'm so eager to get it fixed that I even made a donation right now - perhaps more users could do it and inspire the developers to keep on working on the app since it's really a good one.
Cheers
- Renato
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: 1.3.3. Multiple Currencies not working correctly
Apparently the developers are currently on holiday (or not in the mood) and there is no point in annoying forum users with the same posts.
By the way: I also hope for a solution, unfortunately I deleted my old MMEX version.
cheers
By the way: I also hope for a solution, unfortunately I deleted my old MMEX version.
cheers
Renato Forum Administrator
-
- Senior User
- Posts: 37
- Joined: Sun Oct 29, 2017 11:22 am
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
Sorry that you got annoyed but I posted the message on different threads with different people on them (except one that did not complain anyway) - most of the posters subscribe to just their own posts. So there was no harm done - the whole issue is not worth mentioning.Renato wrote:Apparently the developers are currently on holiday (or not in the mood) and there is no point in annoying forum users with the same posts.
cheers
Take care and be happy when the app gets fixed
-
- New User
- Posts: 3
- Joined: Mon Jan 15, 2018 3:02 pm
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
Hi.
As of today, I'm experiencing all problems related in this post regarding multiple currencies operations in MMEX 1.3.3.
The suggested workaround to change the "conversion to base rate" (tools>organize currency>edit) does affect the rates in home page, but it also changes all conversion rates even from transactions that were already reconciled. Since, this process will mess the data from reconciled transactions, it should be avoided.
So at the end it seems multiple currencies are nod working correctly indeed.
Are these issues bugs indeed?
Thanks,
Carlos
As of today, I'm experiencing all problems related in this post regarding multiple currencies operations in MMEX 1.3.3.
The suggested workaround to change the "conversion to base rate" (tools>organize currency>edit) does affect the rates in home page, but it also changes all conversion rates even from transactions that were already reconciled. Since, this process will mess the data from reconciled transactions, it should be avoided.
So at the end it seems multiple currencies are nod working correctly indeed.
Are these issues bugs indeed?
Thanks,
Carlos
-
- New User
- Posts: 3
- Joined: Mon Jan 15, 2018 3:02 pm
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
Hi.
As of today, I'm experiencing all problems related in this post regarding multiple currencies operations in MMEX 1.3.3.
The suggested workaround to change the "conversion to base rate" (tools>organize currency>edit) does affect the rates in home page, but it also changes all conversion rates even from transactions that were already reconciled. Since, this process will mess the data from reconciled transactions, it should be avoided.
So at the end it seems multiple currencies are nod working correctly indeed.
Are these issues bugs indeed?
Thanks,
Carlos
As of today, I'm experiencing all problems related in this post regarding multiple currencies operations in MMEX 1.3.3.
The suggested workaround to change the "conversion to base rate" (tools>organize currency>edit) does affect the rates in home page, but it also changes all conversion rates even from transactions that were already reconciled. Since, this process will mess the data from reconciled transactions, it should be avoided.
So at the end it seems multiple currencies are nod working correctly indeed.
Are these issues bugs indeed?
Thanks,
Carlos
-
- New User
- Posts: 2
- Joined: Wed Oct 03, 2018 3:40 pm
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
thanks for the link.mr108 wrote:I tested again with the latest version of Android MMEX and it can now update both currencies exchange rates and stock prices.
Exchange rates are updated with Fixer
http://fixer.io/
Fixer is a free API for current and historical foreign exchange rates published by the European Central Bank.
The rates are updated daily around 4PM CET every working day.
although this one https://www.alphavantage.co/ could be better since it can provide the cryptocurrencies prices as well
https://www.alphavantage.co/support/#api-key
and
Stock prices are updated with Morningstar.
and https://www.alphavantage.co/ is also providing stock prices
Perhaps same thing could be done with the desktop app?
-
- New User
- Posts: 2
- Joined: Wed Oct 03, 2018 3:40 pm
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
thanks for the link.mr108 wrote:I found following services for updating currencies but since I'm not a programmer I don't know if that can be used.
Hopefully MMEX developers can look into this soon - THANKS!
http://fixer.io/
Fixer is a free API for current and historical foreign exchange rates published by the European Central Bank.
The rates are updated daily around 4PM CET every working day.
https://www.alphavantage.co/
https://www.alphavantage.co/support/#api-key
http://www.mycurrency.net/page/Free+Cur ... verter+API
http://www.jarloo.com/real-time-google-stock-api/
https://1forge.com/forex-data-api/pricing (1,000 requests per day)
https://www.nbp.pl/homen.aspx?f=/kursy/ ... ut_en.html
https://www.barchart.com/ondemand/free-market-data-api
Up to 100 symbols per query, and up to 2,500 queries per day
https://api.tiingo.com/
https://api.tiingo.com/pricing
Requests Per Day 20,000
-
- Senior User
- Posts: 21
- Joined: Wed Aug 19, 2009 7:40 pm
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
Hi,
Did anyone manage to get the currency quotes API pull into the MMEX desktop (macOS) to work so far? if yes, any hint please?
I've tried fixer and alpha vintage API in the Options>Others>StockQuoteWebPage as
https://www.alphavantage.co/query
?function=CURRENCY_EXCHANGE_RATE
&from_currency=%s
&to_currency=CHF
&apikey=<MY_API_KEY>
thanks a lot.
Regards,
Frank
Did anyone manage to get the currency quotes API pull into the MMEX desktop (macOS) to work so far? if yes, any hint please?
I've tried fixer and alpha vintage API in the Options>Others>StockQuoteWebPage as
https://www.alphavantage.co/query
?function=CURRENCY_EXCHANGE_RATE
&from_currency=%s
&to_currency=CHF
&apikey=<MY_API_KEY>
thanks a lot.
Regards,
Frank
-
- New User
- Posts: 2
- Joined: Mon Apr 29, 2019 11:24 am
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
I found after organizations for invigorating money related gauges yet since I'm not a product engineer I don't have the foggiest thought whether that can be used. In a perfect world MMEX creators can research this soon.
-
- New User
- Posts: 2
- Joined: Mon Apr 29, 2019 11:24 am
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
I found after organizations for invigorating money related gauges yet since I'm not a product engineer I don't have the foggiest thought whether that can be used. In a perfect world MMEX creators can research this soon.
-
- New User
- Posts: 2
- Joined: Sun May 05, 2019 4:04 pm
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
Is there any fix for this issue? I downloaded the latest version today and the issue still persists. Would appreciate some help here. Thanks
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: 1.3.3. Multiple Currencies not working correctly
https://github.com/moneymanagerex/moneymanagerex/tagshina wrote:Is there any fix for this issue? I downloaded the latest version today and the issue still persists. Would appreciate some help here. Thanks
Currency exchange rate online update fixed in ver. 1.4
(Backup DB file before use)
-
- Senior User
- Posts: 21
- Joined: Wed Aug 19, 2009 7:40 pm
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
This sounds promising; thanks!Nikolay wrote:https://github.com/moneymanagerex/moneymanagerex/tagshina wrote:Is there any fix for this issue? I downloaded the latest version today and the issue still persists. Would appreciate some help here. Thanks
Currency exchange rate online update fixed in ver. 1.4
(Backup DB file before use)
When can we expect a compiled version for Mac? (On the Unstable version Link I see "Error: Web link not found")
Regards,
Frank
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: 1.3.3. Multiple Currencies not working correctly
MMEX Desktop v1.3.4.rc.5 is ready !!!!
It's support prices update from Yahoo as it was before.
It's support prices update from Yahoo as it was before.
-
- Senior User
- Posts: 21
- Joined: Wed Aug 19, 2009 7:40 pm
- Are you a spam bot?: No
Re: 1.3.3. Multiple Currencies not working correctly
Thanks for the note;
Unfortunately the *.rc.7 (*.rc.5 I can't find) does not seem to work on my Mac. I always get that the app is corrupt and needs to me move d to the bin, whenever I start it.
Thanks for any pointer.
Unfortunately the *.rc.7 (*.rc.5 I can't find) does not seem to work on my Mac. I always get that the app is corrupt and needs to me move d to the bin, whenever I start it.
Thanks for any pointer.