[GNC] Get online quote for Canada Fund

[Kaman Wu]

thanks a lot.  I will try it.

On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér <write2ove at gmail.com> wrote:

> I was looking at the code in cpan, and it looks like the module is using
> this base url
>
> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2&id=
>
> and then adding the code after it, e.g.
> http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2&id=1743
>
> however when trying this url, I get Error 404, unknown web page,
>
> It could be that the module is not current and fails on everything.
>
> if you are comfortable with perl, you could try changing the url in the module.
>
> I tried also to retrieve the mutual fund from my ubuntu based gnucash, and it also fails.
>
> there are contact details for this module on this url: https://metacpan.org/author/ECOCODE
>
> the author of the code may be able to help more.
>
> br Ove.
>
>
>
>
> On Sun, 11 Aug 2019 at 15:44, Kaman Wu <kamanwu at gmail.com> wrote:
>
>> Hello Ove,
>>
>> Thanks for reply my question.  I did try "1743".  Still get the same
>> error message.   I really need solve the problem, otherwise, I have to
>> manually input the price for all funds I have.
>>
>>
>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
>>   1743
>> Finance::Quote fields Gnucash uses:
>>     symbol: 1743 (deduced)       <=== required
>>       date: ** missing **        <=== recommended
>>   currency: ** missing **        <=== required
>>       last:                      <=\
>>        nav:                      <=== one of these
>>      price:                      <=/
>>   timezone:                      <=== optional
>>
>> ** This stock quote cannot be used by GnuCash!
>>
>>
>> All fields returned by Finance::Quote for stock 1743
>>
>> stock           field  value
>> -----           -----  -----
>> 1743         errormsg: Fund name 1743 not found
>> 1743             last: **missing**
>> 1743              nav: **missing**
>> 1743            price: **missing**
>> 1743          success: 0
>>
>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v canadamutual
>>  1743
>> Finance::Quote fields Gnucash uses:
>>     symbol: 1743 (deduced)       <=== required
>>       date: ** missing **        <=== recommended
>>   currency: ** missing **        <=== required
>>       last:                      <=\
>>        nav:                      <=== one of these
>>      price:                      <=/
>>   timezone:                      <=== optional
>>
>> ** This stock quote cannot be used by GnuCash!
>>
>>
>> All fields returned by Finance::Quote for stock 1743
>>
>> stock           field  value
>> -----           -----  -----
>> 1743         errormsg: Error determining fund code for 1743.
>> 1743             last: **missing**
>> 1743              nav: **missing**
>> 1743            price: **missing**
>> 1743          success: 0
>>
>>
>>
>>
>>
>>
>> On Sun, Aug 11, 2019 at 6:56 AM Ove Grunnér <write2ove at gmail.com> wrote:
>>
>>> Hi Kaman,
>>>
>>> according to https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary
>>> "This module uses an id that represents the mutual fund on an id used by
>>> www.fundlibrary.com. There is no easy way of fetching the id except to
>>> jump onto the fundlibrary website, look up the fund and view the url for
>>> clues to its id number."
>>> the url for TDB900 is:
>>>
>>> https://www.fundlibrary.com/MutualFunds/Detail/td-canadian-index-fund-e-series/1743
>>> so try 1743
>>>
>>> br Ove.
>>>
>>> On Sun, 11 Aug 2019 at 04:07, Kaman Wu <kamanwu at gmail.com> wrote:
>>>
>>>> I did some search, and found some old posts which are not very helpful.
>>>>
>>>> I think I can use:
>>>> https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary
>>>> Basing on this module, it use the data from http://www.fundlibrary.com/
>>>>
>>>> I do can search TDB900 on this website and find the correct fund.
>>>>
>>>> BUT when I setup it up in gnucash, I get quote failed.
>>>>
>>>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
>>>> TDB900
>>>> Finance::Quote fields Gnucash uses:
>>>>     symbol: TDB900 (deduced)     <=== required
>>>>       date: ** missing **        <=== recommended
>>>>   currency: ** missing **        <=== required
>>>>       last:                      <=\
>>>>        nav:                      <=== one of these
>>>>      price:                      <=/
>>>>   timezone:                      <=== optional
>>>>
>>>> ** This stock quote cannot be used by GnuCash!
>>>>
>>>>
>>>> All fields returned by Finance::Quote for stock TDB900
>>>>
>>>> stock           field  value
>>>> -----           -----  -----
>>>> TDB900       errormsg: Fund name TDB900 not found
>>>> TDB900           last: **missing**
>>>> TDB900            nav: **missing**
>>>> TDB900          price: **missing**
>>>> TDB900        success: 0
>>>>
>>>>
>>>> Any one know how to fix it? or how (where) to report this problem?
>>>> Thanks.
>>>> _______________________________________________
>>>> 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.
>>>>
>>>
>>
>>
>>