V 5.1.1 on Linux
I am a new user trying to find my way.
I have a number of securities that are supported online by FT.
However the KMyMoney Source Financial Times does not seem to work for me.
Looking under SETTINGS – CONFIGURE KMYMONEY – ONLINE QUOTES – FINANCIAL TIMES I noticed the the URL was not the one found when using FT on the web.
I set up a new source using https://markets.ft.com/data/funds/tearsheet/summary?s=%1
with all the other settings as existing Financial Times source. This worked with a few exceptions.
I think I can see the issue with these exceptions but don’t know how to fix them.
Looking at FT webb page for a security that works the price appears as a number less than a thousand. However if any price is over a thousand and thus includes a comma, it does not work.
In the price field is Price\D+([d,]*\d+\.\d+) can this be modified. Will I need to set up a new source to cover this?
Along the same lines for dates the date field reads
Data delayed at least 15 minutes, as of\ (.*)\.
Some dates lines on the FT site read
Data delayed at least 15 minutes, as of Mar 19 2021.
and work. Others include extra text
Data delayed at least 20 minutes, as of Mar 19 2021 16:25 BST.
I tried changing Data delayed at least 15 minutes, as of\ (.*)\. to as of\ (.*)\.
It did not help but did not break the securities that were working.
So I guess its the extra text 16:25 BST. that needs to be taken into account.
What do I need to do?

Thanks

To get along with the extra timestamp (and the different amount of timeout), you can modify the date extraction regular expression from

Code: Select all

Data delayed at least 15 minutes, as of\ (.*)\.

to

Code: Select all

Data delayed at least \d+ minutes, as of\ (.*)[\. ]

Regarding the price regex, the original value is

Code: Select all

Price\D+([\d,]*\d+\.\d+)

and should cover numbers over a thousand including a comma. You mention something else - one backslash is missing in your post. Please double check your settings. If you still can't get it to work, please let us know the symbol you try to extract so we can see ourselves.

BTW, there's no need to create a new source.

Great, that worked.
You are certainly the man!
Thanks again.