[kmymoney4] [Bug 386462] Quote Updates quit working
Thomas Baumgart
thb at net-bembel.de
Tue Nov 14 15:25:32 UTC 2017
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 --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 846 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20171114/25e28eb5/attachment-0001.sig>
More information about the KMyMoney
mailing list