updating currencies and stocks is failing

MMEX4Desktop, incl. Windows, macOS (10.10 or newer), and Most Unix variants using the GTK+ toolkit

Moderator: Renato

Post Reply
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

updating currencies and stocks is failing

Post by mr108 »

Hi,

Suddenly I cannot update the currencies exchange rates and stocks from the internet - the Error is "Cannot get data from WWW"
Her is the screenshot: https://s5.postimg.org/4lt1vbmd3/mmex_error.jpg
My internet connection works OK.

How to fix it?

Thanks
Last edited by mr108 on Thu Nov 02, 2017 9:45 am, edited 1 time in total.
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

I tried another version - mmex-1.4.0-ALPHA-3 - and getting the same error message.

Checked the firewall and antivirus and neither is blocking it.

What's wrong???
Damian_pl
New User
Posts: 18
Joined: Sat Jan 10, 2009 8:03 pm
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by Damian_pl »

I have the same problem (and the same message) since several days...
JohnD
New User
Posts: 8
Joined: Thu Jul 20, 2017 9:18 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by JohnD »

Hi

I am been having the same problem with updating currencies for a few days now. Same error message. What has changed and how to fix it?

I do not use the stock price part of MMEX though.

John
Joe91
New User
Posts: 4
Joined: Wed Jan 04, 2017 11:09 pm
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by Joe91 »

I believe it may be to do with this?

YahooCare @YahooCare
Replying To: @JDMMIG
It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com .

https://yahoo.sdx.socialdynamx.com/port ... n/19248672
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

Perhaps the developers of MMEX could change the source for getting this info - Google and Morningstar are also providing it.

Any way to bring this problem to the attention of the developers?
Are they frequently looking through the posts on this forum?
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

I tested the Android version and there you can chose from what service you get the price updates.

Getting the updates from Yahoo is not working.
Currencies exchange rates from Morningstar does not work either.
But updating the stock prices from Morningstar works OK.
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: updating currencies and stocks is failing

Post by Renato »

this update doesn't work for me either, because you cannot enter the courses manually, a solution would be urgently needed.
Renato Forum Administrator
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

I found following free services for updating currencies and stock prices 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!

https://www.alphavantage.co/
https://www.alphavantage.co/support/#api-key

http://www.jarloo.com/real-time-google-stock-api/

https://1forge.com/forex-data-api/pricing (1,000 requests per day)

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
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

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?
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: updating currencies and stocks is failing

Post by Renato »

It is disappointing that no one from the MMEX team wants to comment on this Problem.

I'd be satisfied if I could record the prices of stock prices by hand, but I'm not allowed to do that by the deactivated grey buttons.
Renato Forum Administrator
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

Renato wrote:It is disappointing that no one from the MMEX team wants to comment on this Problem.

I'd be satisfied if I could record the prices of stock prices by hand, but I'm not allowed to do that by the deactivated grey buttons.
Even better than modifying stock prices by hand would be to modify the code to enable manual input of API services. I listed many such services in my recent posts here and most of the free ones have limitations on daily usage. But each user could sign up for such an API service and enter their personal API code in the options and then no one would exceed the daily limits. I cannot imagine that such a small modification of the code would require much work.
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: updating currencies and stocks is failing

Post by Renato »

what worries me much more is the fact that the developers of MMEX apparently don't visit the forum anymore.
This presumably indicates that the development of MMEX is currently at a standstill.
Renato Forum Administrator
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

Renato wrote:what worries me much more is the fact that the developers of MMEX apparently don't visit the forum anymore.
This presumably indicates that the development of MMEX is currently at a standstill.
Someone else asked a question if this is The END.

I already started to look for some other software but definitely MMEX is BEST. But if they don't fix these currencies and stock prices I'll have to switch to the other one that is being maintained and developed. They have the same issue now but the developer is working on it.
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: updating currencies and stocks is failing

Post by Renato »

Since the MMEX team cannot offer us a solution, I have searched for other solutions and found them.

For Google Chrome there is an extension JADE (JAvacript based Database Editor) = SQLite Editor, so that the MMEX database (. mmb) can be edited.

You can enter the current exchange rate in table STOCK_V1 under CURRENTPRICE.

You can adjust the exchange rates in table CURRENCYHISTORY_V1 in CURRVALUE.

Important: make a backup copy of the. mmb file and close MMEX.
Renato Forum Administrator
aker54
New User
Posts: 4
Joined: Tue Dec 05, 2017 2:05 pm
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by aker54 »

Is there still no solution for this problem? I love mmex but to have currencies up to date is pretty important for me.
aker54
New User
Posts: 4
Joined: Tue Dec 05, 2017 2:05 pm
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by aker54 »

Is there still no solution for this problem? I love mmex but to have currencies up to date is very important for me.
FlameOfMoney
New User
Posts: 2
Joined: Mon Dec 11, 2017 12:31 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by FlameOfMoney »

So, I peaked at the source code/documentation. The use of Yahoo to fetch stock quotes is specified in the Tools->Options menu.

Click on the bottom icon and at the top there is a URL for Yahoo:

http://finance.yahoo.com/echarts?s=%s

I changed mine to

http://finance.google.com/finance?q=%s

to fetch quotes from Google. This allows me to view stocks on the Edit Stock Investment dialog box when I click on the little house icon by the notes.
It does not fix the automatic update of stock prices. That must be somewhere else in the source code.

The source code module stockspanel.cpp fetches data from yahoo using the URL like:

http://finance.yahoo.com/d/quotes.csv?s ... c4n&e=.csv

this is an example from the code. I think is the URL that Yahoo disabled which downloaded the stock quotes as a CSV file.
aker54
New User
Posts: 4
Joined: Tue Dec 05, 2017 2:05 pm
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by aker54 »

Is there still no solution from the mmex development team?
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

aker54 wrote:Is there still no solution for this problem? I love mmex but to have currencies up to date is very important for me.
Try Renato's suggestion, just above on this thread.
Or install the Android app that is updating the currencies and stocks and after the update either upload the database to the dropbox and download to your computer for use with the Windows version or copy directly from your mobile to the computer.
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

To all the users who are waiting for this fix, see this post:
https://github.com/moneymanagerex/money ... ssues/1367

and find the response from stef145g who commented on Dec 9, 2017 and who is the developer of MMEX .
He answers the question: "Is this a dead program now?"

Not dead, just in hibernation.
As developers of MMEX, we do this on a voluntary basis. Also there are not many of us that are active developers. We all have periods of time where other commitments such as work and family take precedence. There will be times where all developers are in this state, making it look that the project has no activity.
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

Still not working on the version 1.4.0 alpha 3
Without updating currencies and stocks this software is useless.
mr108
Senior User
Posts: 37
Joined: Sun Oct 29, 2017 11:22 am
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by mr108 »

mr108 wrote:Still not working on the version 1.4.0 alpha 3
Without updating currencies and stocks this software is useless.
I got it working now, it's OK.
hina
New User
Posts: 2
Joined: Sun May 05, 2019 4:04 pm
Are you a spam bot?: No

Re: updating currencies and stocks is failing

Post by hina »

mr108 wrote:
mr108 wrote:Still not working on the version 1.4.0 alpha 3
Without updating currencies and stocks this software is useless.
I got it working now, it's OK.
How did it work for you?
Post Reply