[kmymoney4] [Bug 386462] Quote Updates quit working

Andy Chung andy.chung.0 at gmail.com
Tue Nov 14 15:34:31 UTC 2017 

worked. thank you list and thomas :))

[image: 內置圖片 1]

2017-11-14 23:25 GMT+08:00 Thomas Baumgart <thb at net-bembel.de>:

> Hi,
>
> , as of (\w+\s\d+\s\d+^([0-9]|0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]$)GMT
>
> That is pretty complex. You need to replace '^' and '$' with a blank and
> rearrange the parens a bit, so
>
> , as of (\w+\s\d+\s\d+)\s([0-9]|0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]\sGMT
>
> should do better. You only need to catch the date, not the time though it
> could be useful for matching.
>
> Hope that helps
>
> Regards
>
> Thomas
>
> On Dienstag, 14. November 2017 23:09:33 CET Andy Chung wrote:
>
> > Hi all,
> >
> > I am having problem with etf VNQ not avail in google finance so tried
> the FT
> >
> > (a) url change from fund to etf (success)
> > https://markets.ft.com/data/etfs/tearsheet/summary?s=%1
> > https://markets.ft.com/data/etfs/tearsheet/summary?s=VNQ
> >
> > (b) price change to catch USD (success)
> > Price \(USD\)</span><span class="mod-ui-data-list__
> value">(\d+\.\d+)</span>
> >
> > Price (USD)</span><span class="mod-ui-data-list__value">85.36</span>
> >
> > (c) am having problem with catching time where hh:mm GMT is present
> (failed)
> > , as of (\w+\s\d+\s\d+^([0-9]|0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]$)
> GMT.</div>
> >
> > , as of Nov 14 2017 01:00 GMT.</div>
> >
> > help appreciated for (c) catching date time
> >
> > 2017-11-14 6:35 GMT+08:00 Geza Giedke <geza.giedke at gmail.com>:
> > > thanks a lot, with your tips I got it to work:
> > >
> > > either using
> > > http://www.boerse-berlin.com/index.php/Funds?isin=%1
> > > with
> > >
> > > Price: Last</div><div class=".+"><span
> > > class="currency">EUR</span><span class="nc
> > > id_\d+_last">(\d+.\d+)</span>
> > > Date: Date</div><div class=".+"><span class="nc
> > > id_\d+_dateTime">(\d+/\d+/\d+)</span>
> > > Date format: %d %m %y
> > >
> > > or using
> > > https://markets.ft.com/data/funds/tearsheet/summary?s=%1
> > > with
> > > Price: Price \(EUR\)</span><span
> > > class="mod-ui-data-list__value">(\d+\.\d+)</span>
> > > Date: , as of (\w+\s\d+\s\d+)\.</div>
> > > Date Format: %m %d %y
> > >
> > > works for me for all the funds not available in finance.google.com
> > >
> > > Thanks again!
> > >
> > > best regards
> > >
> > >  Geza
> > >
> > > On Mon, Nov 13, 2017 at 9:51 AM, Thomas Baumgart <thb at net-bembel.de>
> > >
> > > wrote:
> > > > Geza,
> > > >
> > > > looking at the source of the page, I can see
> > > >
> > > >    Price (EUR)</span><span class="mod-ui-data-list__
> value">11.13</span>
> > > >
> > > > which needs to be caught by the regex for the price. I would use
> > >
> > > something
> > >
> > > > like
> > > >
> > > >    Price.*</span><span class="mod-ui-data-list__
> value">([\d\.]+)</span>
> > > >
> > > > The date can be found here:
> > > >    , as of Nov 10 2017.</div>
> > > >
> > > > and a corresponding regex would look like
> > > >
> > > >    , as of (\w+\s\d+\s\d+)\.<div>
> > > >
> > > > The date format then is
> > > >
> > > >     %m %d %y
> > > >
> > > > You need to activate the option "Skip HTML stripping" as parts of the
> > >
> > > regexes
> > >
> > > > rely on the HTML tags which would otherwise not be present.
> > > >
> > > > Your mileage may vary as I have not tested any of these.
> > > >
> > > > To get to the source: Firefox has an option which is called 'View
> page
> > >
> > > source'
> > >
> > > > or you can use 'wget' or 'curl' to download the page into a file on
> your
> > >
> > > local
> > >
> > > > system.
> > > >
> > > > Hope that helps.
> > > >
> > > > Regards
> > > >
> > > > Thomas
> > > >
> > > > On Sonntag, 12. November 2017 21:46:47 CET Geza Giedke wrote:
> > > >> thanks Jeff and Salvatore for your help; now I can use
> > > >> finance.google.com for all stocks and most funds (both date and
> price
> > > >> are imported correctly).
> > > >> But some funds are not available there, but, for example, here:
> > > >>
> > > >> http://www.boerse-berlin.com/index.php/Funds?isin=LU0069450319
> > > >>
> > > >> or here:
> > > >>
> > > >> https://markets.ft.com/data/funds/tearsheet/summary?s=
> LU0069450319:EUR
> > > >>
> > > >> While I think I get KMM to access the correct page, I've not managed
> > > >> to extract the data properly: I've tried to follow
> > > >> http://doc.qt.io/qt-4.8/qregexp.html#1 (as linked in the KMM Online
> > > >> help), but my construction (for Boerse Berlin) of
> > > >> Price: LastEUR.(\d+.\d+)
> > > >> and
> > > >> Date: Date.(\d+\D+\d+\D+\d+)
> > > >> does not work ("Unable to update price for LU0069450319 (no price
> or no
> > > >> date)").
> > > >>
> > > >> I wonder if I don't understand the regexps properly or if the text
> > > >> with "all HTML tags removed" that the parser works on looks
> different
> > > >> than I think. How could I get the file that is sent to the page
> > > >> parser?
> > > >>
> > > >> thanks a lot and best regards
> > > >>
> > > >>  Geza
> > > >>
> > > >> On Sun, Nov 12, 2017 at 12:49 AM, Salvatore Dimartino
> > > >>
> > > >> <saldimartino at yahoo.ca> wrote:
> > > >> > I have used the following settings:
> > > >> >
> > > >> > For stock quotes I created a new entry called GoogleFinance with
> the
> > > >> > following parameters:
> > > >> >
> > > >> > URL: https://finance.google.com/finance?q=%1
> > > >> > Symbol: %1
> > > >> > Price: "price"\s+content="((\d+|\d{1,3}(?:[,]\d{3})).\d+)
> > > >> > Date: "quoteTime"\s+content="(\d{4}-\d{2}-\d{2})T
> > > >> > Date Format: %y-%m-%d
> > > >> >
> > > >> > Also, because almost all of my stocks are listed on the TSX in
> > >
> > > Canada, I
> > >
> > > >> > had to modify my stocks with new tickers as follows:
> > > >> >
> > > >> > I changed for example for Bell Canada BCE.TO to TSE:BCE, I had
> to do
> > >
> > > this
> > >
> > > >> > for all my stocks.
> > > >> >
> > > >> >
> > > >> > For currency conversion I modified  Yahoo Currency with the
> following
> > > >> > parameters:
> > > >> >
> > > >> > URL: https://finance.google.com/finance?q=%1%2
> > > >> > Symbol: %1%2
> > > >> > Price: "price"\s+content="((\d+|\d{1,3}(?:[,]\d{3})).\d+)
> > > >> > Date: "quoteTime"\s+content="(\d{4}-\d{2}-\d{2})T
> > > >> > Date Format: %y-%m-%d
> > > >> >
> > > >> > Also, I run KmyMoney on Windows machines, I then copied
> > > >> > c:\user\sal\AppData\Roaming\.kde\share\config\kmymoneyrc
> > > >> > onto all the other windows machines I have, so that I didn't have
> to
> > >
> > > redo
> > >
> > > >> > this work on all my machines.
> > > >> >
> > > >> > Regards
> > > >> > Sal Dimartino
> > > >> >
> > > >> >
> > > >> > On Saturday, November 11, 2017, 4:41:43 PM EST, Geza Giedke
> > > >> > <geza.giedke at gmail.com> wrote:
> > > >> >
> > > >> >
> > > >> > yes, the tip to use finance.google.com for currency also works
> for me
> > > >> > (KMM 4.7.2).
> > > >> >
> > > >> > Has somebody figured out how to also get quotes for stocks, funds
> etc
> > > >> > via finance.google.com? What's the logic behind the syntax used
> for
> > > >> > "symbol", "price", and "date" in the settings?
> > > >> >
> > > >> > regards
> > > >> > Geza
> > > >> >
> > > >> > On Sun, Nov 5, 2017 at 7:18 AM, timothy <timboyle at afrihost.co.za>
> > >
> > > wrote:
> > > >> >> The solution given in the link @ comment #15 by Thomas works
> fine.
> > > >> >> Just go to Settings / Configure Kmymoney / Online Quotes and
> > >
> > > reconfigure
> > >
> > > >> >> 'Yahoo Currency'
> > > >> >> as per link.
> > > >> >>
> > > >> >>
> > > >> >> Works fine on 4.8.1. Thanks Thomas.
> > > >> >>
> > > >> >> Timothy
> > > >> >>
> > > >> >> On Sat, 2017-11-04 at 07:20 +0000, Thomas Baumgart wrote:
> > > >> >>> https://bugs.kde.org/show_bug.cgi?id=386462
> > > >> >>>
> > > >> >>> --- Comment #15 from Thomas Baumgart <tbaumgart at kde.org> ---
> > > >> >>> Please see
> > > >> >>> https://forum.kde.org/viewtopic.php?f=69&t=142715&p=
> 383426#p383426
> > > >> >>> for a possible workaround.
> > > >
> > > > --
> > > >
> > > > Regards
> > > >
> > > > Thomas Baumgart
> > > >
> > > > https://www.telegram.org/       Telegram, the better WhatsApp
> > > > -------------------------------------------------------------
> > > > Why do programmers wear glasses?
> > > > Cause they don't C#.
> > > > -------------------------------------------------------------
>
> --
>
> Regards
>
> Thomas Baumgart
>
> https://www.telegram.org/       Telegram, the better WhatsApp
> -------------------------------------------------------------
> Q: Do you know the golden rule?
> A: The rules are made by those who own the gold!
> -- Frank Stornach
> -------------------------------------------------------------
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20171114/93a59faf/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 21907 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20171114/93a59faf/attachment-0001.png>

More information about the KMyMoney mailing list