[GNC] Get online quote for Canada Fund

[Ove Grunnér]

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.
>>>
>>
>
>
>