This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Updating from FT does not work anymore.

Tags: None
(comma "," separated)
pasis
Registered Member
Posts
44
Karma
0
on 5.1 I cannot update stock prices anymore from financial times and I do not know how to fix the filter.

I have following settings:

url:http://funds.ft.com/uk/Tearsheet/Summary?s=%1
identifiy by identification number.
Price Price\D+([\d,]*\d+\.\d+)
Date Data delayed at least 15 minutes, as of\ (.*)\.
Date format: %m %d %y

If I replace %1 for example with AINV, and paste to browser I get right information, but when i try to update I get following error (with every security).

Fetching URL http://funds.ft.com/uk/Tearsheet/Summary?s=AINV...
Identifier found: ''
Unable to update price for AINV (no price or no date)

So I assume something wrong with Date or time formats but I am not familiar with parameters here so I cannot fix filter.

Any help?

With copy/paste url and identifier i get .

Apollo Investment Corp
AINV:NSQ
Actions

Price (USD)9.20Today's Change-0.55 / -5.64%Shares traded148.70k1 Year change-42.89%Beta1.8655

Data delayed at least 15 minutes, as of Aug 07 2020 14:34 BST.
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
I only get information in the browser when I use https://markets.ft.com/data/equities/te ... s=AINV:NSQ as URL. Also, they might have changed the way the price is presented on the web-site. I see
Code: Select all
Price (USD)</span><span class="mod-ui-data-list__value">9.06</span>
but that does not match the existing RegEx. Probably needs some adjustment. Welcome to the world of web-scraping.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
pasis
Registered Member
Posts
44
Karma
0
ipwizard wrote:I only get information in the browser when I use https://markets.ft.com/data/equities/te ... s=AINV:NSQ as URL. Also, they might have changed the way the price is presented on the web-site. I see
Code: Select all
Price (USD)</span><span class="mod-ui-data-list__value">9.06</span>
but that does not match the existing RegEx. Probably needs some adjustment. Welcome to the world of web-scraping.


I suspect that the time (14:34 BST.) might be the issue (not sure) but i do not know if it can be added somehow to Date format...
stephanesp
Registered Member
Posts
31
Karma
0
Hello,

For equities, here is what I have (I have had to change it recently)

URL: https://markets.ft.com/data/equities/te ... summary?s=%1
Identify by: Identification number
Price: Price\D+([\d,]*\d+\.\d+)
Date: Data delayed at least (15|20) minutes, as of\ (.*)\.
Date format: %m %d %y
Skip html stripping: Ticked

I have noted that the delay time in not the same for all equities (it looks like it is 20 mns for UK shares), hence the (15|20).

In the case in this discussion, identification number will be the AINV:NSQ and this works for me for this particular example.

Steven


Bookmarks



Who is online

Registered users: Bing [Bot], Evergrowing, Google [Bot]