Update Stock Prices Fails

Wed Mar 21 13:43:13 UTC 2018

G'day again,

Although I could not get Andy's fix working I did find this on:

https://forum.kde.org/viewtopic.php?f=69&t=142713&p=396250&hilit=Stock+Price+Quotes#p396187

By: mdolnik on Sat Mar 17, 2018 8:26 pm

New / EDIT Online Stock Quote
Add a new Online Stock Quote (or edit the existing Yahoo entry)
Settings > Configure KMyMoney... > Online Quotes
Set values to the following:

Code: Select all
     URL: 
https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=%1
     Symbol: %1
     Price: "regularMarketPrice":((\d+|\d{1,3}(?:[,]\d{3})).\d+)
     Date: "regularMarketTime":([\d]+)
     Date Format: [empty]
     Skip HTML stripping: [checked]

Worked like a charm!

Will see what happens tomorrow ;-)

Cheers....

Mike

Michael CALDER
73/81 Willandra Road,
CROMER NSW 2099
P: 02 9981 6327
M: 0401 478 551

On 21/03/18 23:00, kmymoney-request at kde.org wrote:
> Send KMyMoney mailing list submissions to
> 	kmymoney at kde.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://mail.kde.org/mailman/listinfo/kmymoney
> or, via email, send a message with subject or body 'help' to
> 	kmymoney-request at kde.org
> 
> You can reach the person managing the list at
> 	kmymoney-owner at kde.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of KMyMoney digest..."
> 
> 
> Today's Topics:
> 
>     1. Re: Update Stock Prices Fails (Andy Chung)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Tue, 20 Mar 2018 23:32:25 +0800
> From: Andy Chung <andy.chung.0 at gmail.com>
> To: "KMyMoney Users' mailing list" <kmymoney at kde.org>
> Subject: Re: Update Stock Prices Fails
> Message-ID:
> 	<CA+u-Def12dr10-pa-7ha0LzqqKLisqN6z8YSb1sGi8ZtqBOf6g at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
> 
> Hi there,
> 
> probably u are using google finance (as me) which ceased lately.
> I just changed the setting to use FT (as ref from previous thread).
> You may have to update your trading symbol according to FT.
> 
> Below are settings. 3 sources configured.
> 
> Yahoo currency
> https://markets.ft.com/data/currencies/tearsheet/summary?s=%1%2
> %1%2
> Price \(\w+\)</span><span class="mod-ui-data-list__value">(\d+\.\d+)</span>
> , as of (\w+\s\d+\s\d+)\s([0-9]|0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]\s
> %m %d %y
> Skip html skipping (checked)
> 
> 
> Yahoo (for equities)
> https://markets.ft.com/data/equities/tearsheet/summary?s=%1
> %1
> Price \(\w+\)</span><span
> class="mod-ui-data-list__value">([\d\,]+\.\d+)</span>
> , as of (\w+\s\d+\s\d+)\s([0-9]|0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]\s
> %m %d %y
> Skip html skipping (checked)
> 
> 
> New Quote source (for etfs)
> https://markets.ft.com/data/etfs/tearsheet/summary?s=%1
> %1
> Price \(\w+\)</span><span class="mod-ui-data-list__value">(\d+\.\d+)</span>
> , as of (\w+\s\d+\s\d+)\s([0-9]|0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]\s
> %m %d %y
> Skip html skipping (checked)
> 
> 
> 
> 
> 
> 2018-03-20 5:51 GMT+08:00 Michael CALDER <mikecalder at optusnet.com.au>:
> 
>>
>>
>> G'day ,
>>
>> Looks like Update Stock Prices has failed again.
>>
>> Next work around please ;-)
>>
>> Cheers....
>>
>> Mike
>>
>> Michael CALDER
>> 73/81 Willandra Road,
>> CROMER NSW 2099
>> P: 02 9981 6327
>> M: 0401 478 551
>>
>> On 04/11/17 23:00, kmymoney-request at kde.org wrote:
>>
>>> Send KMyMoney mailing list submissions to
>>>          kmymoney at kde.org
>>>
>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>          https://mail.kde.org/mailman/listinfo/kmymoney
>>> or, via email, send a message with subject or body 'help' to
>>>          kmymoney-request at kde.org
>>>
>>> You can reach the person managing the list at
>>>          kmymoney-owner at kde.org
>>>
>>> When replying, please edit your Subject line so it is more specific
>>> than "Re: Contents of KMyMoney digest..."
>>>
>>>
>>> Today's Topics:
>>>
>>>      1. Update Stock Prices Fails (David Dembrow)
>>>      2. Re: Update Stock Prices Fails (Thomas Baumgart)
>>>      3. Update Stock and Currency Prices - Failure (Michael CALDER)
>>>      4. Re: [kmymoney4] [Bug 386462] Quote Updates quit working (timothy)
>>>      5. Re: Update Stock and Currency Prices - Failure (Doug Lytle)
>>>
>>>
>>> ----------------------------------------------------------------------
>>>
>>> Message: 1
>>> Date: Fri, 3 Nov 2017 09:58:35 -0400
>>> From: David Dembrow <ddembrow at ix.netcom.com>
>>> To: kmymoney at kde.org
>>> Subject: Update Stock Prices Fails
>>> Message-ID: <28c0fb63-af10-e0be-10de-664f4258bf2a at ix.netcom.com>
>>> Content-Type: text/plain; charset=utf-8; format=flowed
>>>
>>> Trying to update all stock prices I get error messages like the
>>> following for every symbol:
>>>
>>>
>>> Access denied to
>>> http://download.finance.yahoo.com/d/quotes.csv?s=BGS&f=sl1d1.
>>>
>>> Unable to update price for BGS (empty quote data)
>>>
>>>
>>> When I try and reach the url listed in a browser it returns the
>>> following message:
>>>
>>>
>>> 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.
>>>
>>>
>>> Is there a way to get this working again or is yahoo no longer an option?
>>>
>>>
>>> Thanks,
>>>
>>> ---d.dembrow
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> Message: 2
>>> Date: Fri, 03 Nov 2017 15:39:34 +0100
>>> From: Thomas Baumgart <thb at net-bembel.de>
>>> To: kmymoney at kde.org, dembrow_david at acm.org
>>> Subject: Re: Update Stock Prices Fails
>>> Message-ID: <5233312.arz5W8KOi8 at thb-nb>
>>> Content-Type: text/plain; charset="utf-8"
>>>
>>> Hi,
>>>
>>> please monitor
>>>
>>> https://bugs.kde.org/show_bug.cgi?id=386462
>>>
>>> or
>>>
>>> https://forum.kde.org/viewtopic.php?f=69&t=142715
>>>
>>> for any news on that.
>>>
>>> Regards
>>>
>>> Thomas
>>>
>>>
>>> On Freitag, 3. November 2017 09:58:35 CET David Dembrow wrote:
>>>
>>> Trying to update all stock prices I get error messages like the
>>>> following for every symbol:
>>>>
>>>>
>>>> Access denied to
>>>> http://download.finance.yahoo.com/d/quotes.csv?s=BGS&f=sl1d1.
>>>>
>>>> Unable to update price for BGS (empty quote data)
>>>>
>>>>
>>>> When I try and reach the url listed in a browser it returns the
>>>> following message:
>>>>
>>>>
>>>> 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.
>>>>
>>>>
>>>> Is there a way to get this working again or is yahoo no longer an option?
>>>>
>>>>
>>>> Thanks,
>>>>
>>>> ---d.dembrow
>>>>
>>>
>>>
> 
> 