Registered Member
|
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 ! |
Registered Member
|
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. |
Registered Member
|
@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 ? |
Registered Member
|
@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 ... |
Registered Member
|
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. |
Registered Member
|
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. |
Registered Member
|
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 ... |
Registered users: Bing [Bot], blue_bullet, Google [Bot], rockscient, Yahoo [Bot]