[GNC] weird price for LU0067412154
D.
sunfish62 at yahoo.com
Thu Mar 18 09:41:05 EDT 2021
Well, considering that the NAV in the example is "USD 2150.31" and the 5366.43 in the example actually represents the fund size, I'd imagine you should get the former as the NAV.
-------- Original Message --------
From: Peter West <pbw at pbw.id.au>
Sent: Thu Mar 18 09:24:34 EDT 2021
To: Geoff <cleanoutmyshed at gmail.com>
Cc: gnucash-user at gnucash.org, Derek Atkins <derek at ihtfp.com>
Subject: Re: [GNC] weird price for LU0067412154
If I take this HTML, get rid of all the linefeeds (so it becomes a single line), and feed it into a simple perl script that uses the RE to extract components, I get the following four values:
17/03/2021 USD 5366.43 2.40
which is what I expect from the RE.
What is it supposed to be getting?
Peter
—
pbw at ehealth.id.au
“…you refuse to come to me that you may have life.”
> On 18 Mar 2021, at 5:27 pm, Geoff <cleanoutmyshed at gmail.com> wrote:
>
> Firefox "View Source" reveals the following (I've inserted line breaks after each td for legibility):
>
>
> <td class="line heading">NAV<span class="heading"><br />17/03/2021</span></td>
> <td class="line"> </td>
> <td class="line text">USD 2150.31</td>
> </tr>
> <tr>
> <td class="line heading">Day Change</td>
> <td class="line"> </td>
> <td class="line text">0.26%</td>
> </tr>
> <tr>
> <td class="line heading">Morningstar Category™</td>
> <td class="line"> </td>
> <td class="line value text"><a href="/uk/fundquickrank/default.aspx?category=EUCA000504" style="width:100%!important;">China Equity</a>
> </td>
> </tr>
> <tr>
> <td class="line heading">ISIN</td>
> <td class="line"> </td>
> <td class="line text">LU0067412154</td>
> </tr>
> <tr>
> <td class="line heading">Fund Size (Mil)<span class="heading"><br />17/03/2021</span></td>
> <td class="line"> </td>
> <td class="line text">USD 15667.00</td>
> </tr>
> <tr>
> <td class="line heading">Share Class Size (Mil)<span class="heading"><br />17/03/2021</span></td>
> <td class="line"> </td>
> <td class="line text">USD 5366.43</td>
> </tr>
> <tr>
> <td class="line heading">Max Initial Charge</td>
> <td class="line"> </td>
> <td class="line text">5.00%</td>
> </tr>
> <tr>
> <td class="line heading">Ongoing Charge<span class="heading"><br />11/03/2021</span></td>
> <td class="line"> </td>
> <td class="line text">2.40%</td>
> </tr>
> </table>
>
>
> IMHO it would be more maintainable to use individual expressions to extract the 4 fields separately.
>
> I don't use this data source and currently don't have time to fix it.
>
> Geoff
> =====
>
> On 18/03/2021 3:22 pm, Peter West wrote:
>> Here’s the RE.
>> m[<td class="line heading">NAV<span class="heading"><br />([0-9]{2}/[0-9]{2}/[0-9]{4})</span>.*([A-Z]{3}).([0-9\.]+).*>([0-9\.\-]+)]
>> There is no trailing modifier, so this has to be a single line in the html.
>> So it will start looking with the initial literal string including NAV and ending with the '<br />’ which shows in pretty-print as ‘<br>’. That won’t match if it’s actually like that, of course. What is the full raw html text of the <td class=“line heading”> in which the $5356.02 appears?
>> —
>> pbw at ehealth.id.au <mailto:pbw at ehealth.id.au>
>> “…you refuse to come to me that you may have life.”
>>> On 18 Mar 2021, at 11:57 am, Peter West <pbw at pbw.id.au <mailto:pbw at pbw.id.au>> wrote:
>>>
>>> The pretty-printed elements from the Developer menu won’t be matched by the RE. Can you see the raw html?
>>>
>>> Peter
>>> —
>>> pbw at ehealth.id.au <mailto:pbw at ehealth.id.au>
>>> “…an hour is coming when all who are in the tombs will hear his voice and come out…”
>>>
>>>> On 18 Mar 2021, at 10:09 am, Geoff <cleanoutmyshed at gmail.com> wrote:
>>>>
>>>> This looks like a problem with Finance Quote's MStaruk.pm module. Did Morningstar change their web site recently?
>>>>
>>>> Testing the recent Finance Quote v1.50 release candidate, without using any GnuCash code, I get the same results.
>>>>
>>>> See attached screenshot - I think the problem lies with the long regular expression on line 160. It contains a couple of "greedy" matches that are probably causing a match on the last decimal number (Share Class Size) instead of the first (NAV).
>>>>
>>>> Geoff
>>>> =====
>>>>
>>>> On 18/03/2021 6:48 am, Andrea Borgia wrote:
>>>>> Il 17/03/21 20:32, Derek Atkins ha scritto:
>>>>>> The screenshot didn't make it through the email, most likely because you
>>>>>> sent it as an embedded image in HTML instead of as a text with attachment.
>>>>> Yes and I never had any issues before. Weird.
>>>>> My apologies.
>>>>>>> gnc-fq-dump morningstarch LU0067412154
>>>>>> When I run this, I get:
>>>>>>
>>>>>> gnc-fq-dump morningstarch LU0067412154
>>>>>> Finance::Quote fields Gnucash uses:
>>>>>> symbol: LU0067412154 <=== required
>>>>>> date: 03/17/2021 <=== recommended
>>>>>> currency: USD <=== required
>>>>>> last: 2150.31 <=\
>>>>>> nav: 2150.31 <=== one of these
>>>>>> price: 2150.31 <=/
>>>>>> timezone: <=== optional
>>>>>>
>>>>>>
>>>>>>> gnc-fq-dump mstaruk LU0067412154
>>>>>> This gives me different results:
>>>>>>
>>>>>> gnc-fq-dump mstaruk LU0067412154
>>>>>> Finance::Quote fields Gnucash uses:
>>>>>> symbol: LU0067412154 <=== required
>>>>>> date: 03/17/2021 <=== recommended
>>>>>> currency: USD <=== required
>>>>>> last: 5356.02 <=\
>>>>>> nav: 5356.02 <=== one of these
>>>>>> price: 5356.02 <=/
>>>>>> timezone: <=== optional
>>>>>>
>>>>>> So I would say the issue is upstream, possibly with the quote sources.
>>>>> Hmm, the UK site of MorningStar gives a totally reasonable value.
>>>>> That's why I asked.
>>>>> Pity, the screenshot of the website is missing as well.
>>>>> _______________________________________________
>>>>> gnucash-user mailing list
>>>>> gnucash-user at gnucash.org
>>>>> To update your subscription preferences or to unsubscribe:
>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>>> -----
>>>>> Please remember to CC this list on all your replies.
>>>>> You can do this by using Reply-To-List or Reply-All.
>>>> <gnc_fq_mstaruk.jpg>_______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>> -----
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user
mailing list