Hello-

I know similar questions have been posted on this topic but I cannot seem to find a basic solution to update my mutual fund prices. I am running Windows 10. All of the quote sources that I have used including Google result in an error message- failed to receive a quote for " mutual fund" from Google.

There must be a solution for this. Thanks for your help!

Hi,

It is difficult to answer without knowing a bit more which funds you are talking about and through which website you are trying to update the prices.
But, for an example of settings that work, mine are in my last post:
viewtopic.php?f=69&t=160390

Here they are, at least as a help of the type of format you may use:

URL: https://www.boursorama.com/bourse/opcvm/cours/%1
Identified by: Identification number
Skip HTML stripping: ticked
Date format: %d.%m.%y

Then, I had to make a difference between trackers and OPCVM (hence created two templates):
Trackers:
Price: class="c-faceplate__price"><span class="c-instrument c-instrument--last" data-ist-last>([\d, ]+\.\d+)</span>
Date: Valeur liquidative au (.*) /

OPCVM:
Price: faceplate__price--inline"><span class="c-instrument c-instrument--last" data-ist-last>([\d, ]+\.\d+)</span>
Date: dernier cours connu au\ (.*)</div>

I hope these may help.

Thanks much for your reply. Sorry I didn't give more info. So I have tried all of the websites that are available in the online quotes section in version 4.8.3. The latest I tried is Google with these settings:

URL: https://finance.google.com/finance?q=%1
In the Symbol box add %1
In the Price box add "price"\s+content="((\d+|\d{1,3}(?:[,]\d{3})).\d+)
In the Date box add "quoteTime"\s+content="(\d{4}-\d{2}-\d{2})T
In the Date Format add %y-%m-%d
Check the Skip HTML stripping box

The funds that I am trying to update are from T. Rowe Price, and Vanguard. One example of a mutual fund that I tried to update is: VOO.

Everytime I try from any site I get the same error message, failed to retrieve a quote for VOO from :


I tried your settings, but am getting the same error, failed to retrieve a quote. However, when you mentioned the trackers and OPCVM and creating two templates, I lost you there and have no idea what you are referring to. Could you please clarify what you are referring to and what I need to do? Thanks!

Using finance.google.com seems not to work:

Code: Select all

thb@thb-nb:~$ wget  https://finance.google.com/finance?q=VOO
--2019-06-02 15:11:48--  https://finance.google.com/finance?q=VOO
Resolving finance.google.com (finance.google.com)... 172.217.16.78, 2a00:1450:4005:800::200e
Connecting to finance.google.com (finance.google.com)|172.217.16.78|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://www.google.com/search?q=VOO [following]
--2019-06-02 15:11:48--  https://www.google.com/search?q=VOO
Resolving www.google.com (www.google.com)... 216.58.213.228, 2a00:1450:4005:80b::2004
Connecting to www.google.com (www.google.com)|216.58.213.228|:443... connected.
HTTP request sent, awaiting response... 403 Forbidden
2019-06-02 15:11:50 ERROR 403: Forbidden.


whereas boursorama at least yields a result ( I have not tried to extract the data at this point):

Code: Select all

thb@thb-nb:~$ wget https://www.boursorama.com/bourse/opcvm/cours/VOO
--2019-06-02 15:12:26--  https://www.boursorama.com/bourse/opcvm/cours/VOO
Resolving www.boursorama.com (www.boursorama.com)... 193.41.83.19
Connecting to www.boursorama.com (www.boursorama.com)|193.41.83.19|:443... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://www.boursorama.com/bourse/opcvm/cours/VOO/ [following]
--2019-06-02 15:12:26--  https://www.boursorama.com/bourse/opcvm/cours/VOO/
Reusing existing connection to www.boursorama.com:443.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: /recherche/VOO [following]
--2019-06-02 15:12:26--  https://www.boursorama.com/recherche/VOO
Reusing existing connection to www.boursorama.com:443.
HTTP request sent, awaiting response... 302 Found
Location: /cours/1yVOO/ [following]
--2019-06-02 15:12:27--  https://www.boursorama.com/cours/1yVOO/
Reusing existing connection to www.boursorama.com:443.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: /bourse/trackers/cours/1yVOO/ [following]
--2019-06-02 15:12:27--  https://www.boursorama.com/bourse/trackers/cours/1yVOO/
Reusing existing connection to www.boursorama.com:443.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: ‘VOO’

VOO                        [     <=>                   ] 618.65K   706KB/s    in 0.9s   

2019-06-02 15:12:28 (706 KB/s) - ‘VOO’ saved [633493]


Using grep to verify the regexes I get:

Code: Select all

thb@thb-nb:~$ grep "Valeur liquidativ" VOO
                        (Valeur liquidative au 31.05.19 / 22:00:00)


and

Code: Select all

thb@thb-nb:~$ grep 'class="c-faceplate__price"><span class="c-instrument c-instrument--last" data-ist-last>'  VOO
            </a></h1><div class="c-faceplate__info"><div class="c-faceplate__values"><div class="c-faceplate__price"><span class="c-instrument c-instrument--last" data-ist-last>252.8800</span><span class="c-faceplate__price-currency"> USD</span></div><div class="c-faceplate__real-time">


So, finance.google.com not working with KMyMoney is not a KMyMoney problem