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

Howto get French and other European Funds in Online Quotes

Tags: None
(comma "," separated)
gnull
Registered Member
Posts
21
Karma
0
OS
Hi all

I was struggling since months with KMyMoney, because of its lack of native capability to import online quotes related to French (and some other European) Funds

I have finally succeeded , solution is explained below .
Please note this solution was only tested for KMyMoney 4.7..x and 4.8.0, onto Windows 7 and Windows 10)

Step 1 : creation of a new Quote Source
Go into Settings/Configure KyMyMoney
Select Online Quotes
New source is configured with following parameters :
URL = http://funds.ft.com/uk/Tearsheet/Summary?s=%1:EUR
Symbole = data-display-symbol="(.*):
Quotation = td class="text first">([0-9,]*\.*[0-9]*)<
Date = As of market close (.*)\.
Date Format = %m %d %y

Press « Update » Button
I have saved this new source with name “FT Funds for EUR”



Step 2 : creation of an new investment
I have used here fund FR0000295230 , named “Renaissance Europe C”, from Comgest as example

Open Wizard for Investment Creation
Create new investment as “fund”
Select Next
Market = “EUREX”
Identification = FR0000295230
Currency = EUR
Select Next button

on next Screen
Use Finance::Quote = not selected
Online Quotes = “FT Funds for EUR”
Select Finish button

Voila !
You have now a new investment using FT as online Source Quote
Every time you will request a quote update, this one will produce more message than native Sources for Online Quotes, but it works !
zebulon
Registered Member
Posts
417
Karma
2
OS
I have some French funds from the time I lived in France. I update them online using Yahoo. I have two kinds of funds: the ones whose trading symbol starts with FR and the ones whose symbol is LU. I specify Yahoo for the online source and I append .PA (dot-PA) to the symbol (PAris stock exchange). I don't know what to do for the LU funds. .PA, .LX, .LU: nothing works.

BTW Your method also fails. I get Unable to update price for LUxxxxxxxxx (no price or no date), but then, I get that for FR funds as well. When going to the site in a browser, it replaces uk by us. Maybe that's the problem: they don't allow you to search across the atlantic.
gnull
Registered Member
Posts
21
Karma
0
OS
@Zebulon :
You will have noticed that I am NOT using yahoo as source for fund quotes, because I had noticed that quotes for french (and european) funds are not provided anymore into yahoo, since a while.
-> In my solution, I am using Financial Times as source for quotes.
I have a big doubt that Financial Times would restrict access to its site, based on client location, because this would just limit their audience , not what a newspaper wants ... Maybe if you expose into which country you are , this would help ?

Anyway in order to check if there is effective location restriction from your country to Financial Times website, I suggest the following method :
copy paste the following url into your browser : http://funds.ft.com/uk/Tearsheet/Summar ... 295230:EUR
If this URL returns you the detailed characteristics of fund FR0000295230, this means there is no restriction, and that you can have access to ft.com
If no answer this could mean that , there is a restriction, but maybe that could be a restriction at your brower level (Antivirus, AdBlock, ...) preventing windows to open ?
gnull
Registered Member
Posts
21
Karma
0
OS
@zebulon (2)

Sorry I made a mistake into url to entered into browser for testing , this should be http://funds.ft.com/us/Tearsheet/Summar ... 295230:EUR

NB) it seems indeed that ft.com quote service must be accessed with different url, based onto client country location.
So as example, assuming your are located into USA, the url must contain /us/ and not /uk/

Please try and let me know ...
zebulon
Registered Member
Posts
417
Karma
2
OS
Hi gnull:

Thanks for replying. Right; I just get the funds.ft.com/us page. And that page does not find any of the FR or LU funds. As said, yahoo works for me for the FR funds but not for the LU funds.
gregoryf
Registered Member
Posts
1
Karma
0
I am using KmyMoney 5.0.8 on Linux (Mint 20, 64-bit).
I am trying to use online stock quotes using the Financial Times site but always get an error saying no price or date available.
Under Configure, I have:

URL: https://markets.ft.com/data/equities/te ... summary?s=
CSV [blank]
Identifier: [blank - since I use Symbol]
Identify By: Symbol
Price: \(\w+\)</span><span class="mod-ui-data-list__value">(\d+\.\d
+)</span>
Date:, as of (\w+\s\d+\s\d+)\s([0-9]|0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]\s
Date Format: %m %d %y [which is correct for the Financial Times]

e.g. looking up the price for OXIG.LSE, I get:

Fetching URL https://markets.ft.com/data/equities/te ... mmary?s=...
Identifier found: ''
Unable to update price for OXIG.LSE (no price or no date)

I confess I don´t understand the formats for Price and Date - I copied them from another user on a bulletin board.

Any help would be gratefully received.
gnull
Registered Member
Posts
21
Karma
0
OS
Hello

I think you are using the wrong symbol, as into Financial Time the correct symbol should be OXIG:LSE , instead of OXIG.LSE.

example
if you use URL below FT site returns a result
https://markets.ft.com/data/equities/te ... s=OXIG:LSE
if you use URL below FT site doesn't returns a result
https://markets.ft.com/data/equities/te ... s=OXIG.LSE

PS) you have landed on this topic maybe because you were searching about Financial Time, but the purpose of the topic was to discuss retrieve of FUNDs quotation. It seems you are only interested by EQUITIES. In that case online quotation with Yahoo is working perfectly out of the box ...


Bookmarks



Who is online

Registered users: Bing [Bot], blue_bullet, Google [Bot], rockscient, Yahoo [Bot]