[kmymoney4] [Bug 386462] Quote Updates quit working

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=386462

Thomas Baumgart  changed:

   What|Removed |Added

 CC||mattia.ve...@tiscali.it

--- Comment #22 from Thomas Baumgart  ---
*** Bug 386617 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Ralf Habacker]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #21 from Ralf Habacker  ---
(In reply to Thomas Baumgart from comment #15)
> Please see
> https://forum.kde.org/viewtopic.php?f=69=142715=383426#p383426 for a
> possible workaround.
I'm going to add a fix using this workaround under source name 'Google Finance'
and 'Yahoo Currency' as alias to support the online price update dialog if
there are no objections.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Pete]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #20 from Pete  ---
(In reply to Jack from comment #5)
> There is nothing KMM can do if Yahoo has decided to no longer provide such
> information in a useful way.  The same will happen with any version of KMM. 
> If someone can identify an alternative URL at Yahoo that will work, it can
> be included in KMM, although it seems unlikely that will happen before 5.0. 
> It may be necessary to choose one of the alternate sources for such
> information.

The following URL appears to have all the info required, if you can parse the
page.  It is from Microsoft:

Power Financial (PWF) from the Toronto Stock Exchange (TSE)
https://www.msn.com/en-ca/money/stockdetails/fi-127.1.PWF.TSE?symbol=PWF=PRFIEQ
Note the  parameter can be dispensed with.

Amazon (AMZN) from the (NAS)daq stock exchange
https://www.msn.com/en-ca/money/stockdetails/fi-126.1.AMZN.NAS?symbol=AMZN=PRFIEQ
Note the  parameter can be dispensed with.

International Business Machines Corp (IBM) from (NYS)E (ie: New York)
https://www.msn.com/en-ca/money/stockdetails/fi-126.1.IBM.NYS?symbol=IBM=PRFIEQ
Note the  parameter can be dispensed with.

Rio Tinto PLC (RIO) on the (LON)don stock exchange
https://www.msn.com/en-ca/money/stockdetails/fi-151.1.RIO.LON?symbol=RIO=PRFIEQ
Note the  parameter can be dispensed with.

BNP Parisbas (BNP) on the (PAR)is stock exchange
https://www.msn.com/en-ca/money/stockdetails/fi-160.1.BNP.PAR?symbol=BNP=PRFIEQ
Note the  parameter can be dispensed with.

The quote search box to the right of the company name can be used to find your
desired stock.

en-ca probably determined from my IP address in (ca)nada.

Hope this helps.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=386462

shiz...@teksavvy.com changed:

   What|Removed |Added

 CC||shiz...@teksavvy.com

--- Comment #19 from shiz...@teksavvy.com ---
I update BTC, XAU and XAG (bitcoins, gold and silver) daily and since yahoo
stopped working, I got an API key from https://www.alphavantage.co as suggested
by Robby Engelmann

I hardcoded CAD as currency of choice but I suppose you can put your own or use
%2

Here are the settings to create a new online quote:

URL:
https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE_currency=%1_currency=CAD=your_api_key_goes_here

Symbol: From_Currency\sCode.*(\w+)

Price: Rate.*(\d+\.\d+)

Date: Refreshed.*(\d{4,4}-\d{2,2}-\d{2,2})

Date format: %y-%m-%d

Hope that helps.

Tested and everything's fine.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=386462

Thomas Baumgart  changed:

   What|Removed |Added

 CC||ghfr...@gmail.com

--- Comment #17 from Thomas Baumgart  ---
*** Bug 386524 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=386462

Thomas Baumgart  changed:

   What|Removed |Added

 CC||bilat...@libero.it

--- Comment #18 from Thomas Baumgart  ---
*** Bug 386505 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Joe Byers]

https://bugs.kde.org/show_bug.cgi?id=386462

Joe Byers  changed:

   What|Removed |Added

 CC||ecjb...@aol.com

--- Comment #16 from Joe Byers  ---
All, 
This was an issue with R quantmod.  They found a fix.  If you follow the link
for details: https://github.com/joshuaulrich/quantmod/issues/157

other comments are here: 
https://stackoverflow.com/questions/44015838/cant-download-data-from-yahoo-finance-using-quantmod-in-r

Josh had to encode a cookie crumb to the URL 

i hope helps

Joe

-- 
You are receiving this mail because:
You are the assignee for the bug.

Re: [kmymoney4] [Bug 386462] Quote Updates quit working

[timothy]

Works fine on 4.8.1. Thanks Thomas.

Timothy


On Sat, 2017-11-04 at 07:20 +, Thomas Baumgart wrote:
> https://bugs.kde.org/show_bug.cgi?id=386462
> 
> --- Comment #15 from Thomas Baumgart  ---
> Please see https://forum.kde.org/viewtopic.php?f=69=142715=383426#p383426
> for a possible workaround.
> 

[kmymoney4] [Bug 386462] Quote Updates quit working

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #15 from Thomas Baumgart  ---
Please see https://forum.kde.org/viewtopic.php?f=69=142715=383426#p383426
for a possible workaround.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Robby Engelmann]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #14 from Robby Engelmann  ---
Thats right, there is more data than needed. I only tested it for ETF's and
that worked up to now.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Bob Ewart]

https://bugs.kde.org/show_bug.cgi?id=386462

Bob Ewart  changed:

   What|Removed |Added

 CC||jinni...@bobsown.net

--- Comment #13 from Bob Ewart  ---
Alpha Vantage works for stock prices and gives a lot more data than needed (100
data points.)

It does not appear to work for mutual funds.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=386462

Thomas Baumgart  changed:

   What|Removed |Added

 CC||spr...@usa.net

--- Comment #12 from Thomas Baumgart  ---
*** Bug 386495 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Robby Engelmann]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #11 from Robby Engelmann  ---
Is there a possibility to change the online quote resource for the currencies
away from yahoo currency?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Robby Engelmann]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #10 from Robby Engelmann  ---
Created attachment 108692
  --> https://bugs.kde.org/attachment.cgi?id=108692=edit
example of a csv containing prices from alpha vantage

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Robby Engelmann]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #9 from Robby Engelmann  ---
Is there a good how-to to generate an own online quote entry? One could use
this: https://www.alphavantage.co/documentation/
to get an csv of prices with a free api key.

Via an URL
(https://www.alphavantage.co/query?function=TIME_SERIES_DAILY=IUS7.DE=compact=YOUR_FREE_API_KEY=csv)
you get the csv which has a specific form (example attached). This is to me a
quite reliable resource of historical prices in order to perform data analysis
with R.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Ralf Habacker]

https://bugs.kde.org/show_bug.cgi?id=386462

Ralf Habacker  changed:

   What|Removed |Added

 CC||ralf.habac...@freenet.de

--- Comment #8 from Ralf Habacker  ---
If there is an updated url available please append it to this bug. People using
the mentioned version can update to the new url in their local installation and
it could be included in version 4.8.2 and git master.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Thomas Baumgart]

https://bugs.kde.org/show_bug.cgi?id=386462

Thomas Baumgart  changed:

   What|Removed |Added

 CC||lmun...@skybeam.com

--- Comment #7 from Thomas Baumgart  ---
*** Bug 386465 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

Re: [kmymoney4] [Bug 386462] Quote Updates quit working

[Brendan Coupe]

Keep in mind this is really Verizon. Surprised it took this long.



*Brendan Coupe*

On Thu, Nov 2, 2017 at 5:49 PM, Jack  wrote:

> https://bugs.kde.org/show_bug.cgi?id=386462
>
> Jack  changed:
>
>What|Removed |Added
> 
> 
>  CC|
> |ostroffjh@users.sourceforge
>||.net
>
> --- Comment #5 from Jack  ---
> There is nothing KMM can do if Yahoo has decided to no longer provide such
> information in a useful way.  The same will happen with any version of
> KMM.  If
> someone can identify an alternative URL at Yahoo that will work, it can be
> included in KMM, although it seems unlikely that will happen before 5.0.
> It
> may be necessary to choose one of the alternate sources for such
> information.
>
> --
> You are receiving this mail because:
> You are the assignee for the bug.
>

[kmymoney4] [Bug 386462] Quote Updates quit working

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #6 from bren...@coupeware.com ---
Keep in mind this is really Verizon. Surprised it took this long.



*Brendan Coupe*

On Thu, Nov 2, 2017 at 5:49 PM, Jack  wrote:

> https://bugs.kde.org/show_bug.cgi?id=386462
>
> Jack  changed:
>
>What|Removed |Added
> 
> 
>  CC|
> |ostroffjh@users.sourceforge
>||.net
>
> --- Comment #5 from Jack  ---
> There is nothing KMM can do if Yahoo has decided to no longer provide such
> information in a useful way.  The same will happen with any version of
> KMM.  If
> someone can identify an alternative URL at Yahoo that will work, it can be
> included in KMM, although it seems unlikely that will happen before 5.0.
> It
> may be necessary to choose one of the alternate sources for such
> information.
>
> --
> You are receiving this mail because:
> You are the assignee for the bug.
>

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Jack]

https://bugs.kde.org/show_bug.cgi?id=386462

Jack  changed:

   What|Removed |Added

 CC||ostroffjh@users.sourceforge
   ||.net

--- Comment #5 from Jack  ---
There is nothing KMM can do if Yahoo has decided to no longer provide such
information in a useful way.  The same will happen with any version of KMM.  If
someone can identify an alternative URL at Yahoo that will work, it can be
included in KMM, although it seems unlikely that will happen before 5.0.  It
may be necessary to choose one of the alternate sources for such information.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Pete]

https://bugs.kde.org/show_bug.cgi?id=386462

Pete  changed:

   What|Removed |Added

 CC||peterz...@gmail.com

--- Comment #4 from Pete  ---
For a bit more info and screenshots, please see:

https://bugs.launchpad.net/ubuntu/+source/kmymoney/+bug/1729709

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #3 from akoolw...@gmail.com ---
New error message:

Fetching URL http://finance.yahoo.com/d/quotes.csv?s=ATD-B.TO=sl1d1...
Access denied to
http://download.finance.yahoo.com/d/quotes.csv?s=ATD-B.TO=sl1d1.
Unable to update price for ATD-B.TO (empty quote data)

And from Yahoo:
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Robby Engelmann]

https://bugs.kde.org/show_bug.cgi?id=386462

--- Comment #2 from Robby Engelmann  ---
Did Yahoo change its API?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[kmymoney4] [Bug 386462] Quote Updates quit working

[Robby Engelmann]

https://bugs.kde.org/show_bug.cgi?id=386462

Robby Engelmann  changed:

   What|Removed |Added

 CC||robby.engelm...@igfs-ev.de

--- Comment #1 from Robby Engelmann  ---
The same here using the KF5-based master version under openSUSE Tumbleweed.
Yahoo is for me (ETFs) the only one that ever work reliably.

-- 
You are receiving this mail because:
You are the assignee for the bug.