[GNC] Get online quote for Canada Fund

David Reiser dbreiser at icloud.com
Tue Aug 13 22:35:48 EDT 2019


First, make sure that _none_ of your stocks are requesting quotes through yahoo. (yahoo_json is OK, though). It took me about 3 tries going through my stocks list to track down the straggling reference. Any stock whose online quote source is yahoo will cause the entire retrieval effort to fail.
--
Dave Reiser
dbreiser at icloud.com





> On Aug 13, 2019, at 9:29 PM, Kaman Wu <kamanwu at gmail.com> wrote:
> 
> Hello,  I still need someone help me.
> 
> I made changes of Cdnfundlibrary.pm.  Now when I run:
> 
> perl .\gnc-fq-dump -v fundlibrary   8282
> 
> I could get:
> 
> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
> 8282
> Finance::Quote fields Gnucash uses:
>    symbol: 8282                 <=== required
>      date: 08/12/2019           <=== recommended
>  currency: CAD                  <=== required
>      last: 14.91                <=\
>       nav:                      <=== one of these
>     price:                      <=/
>  timezone:                      <=== optional
> 
> All fields returned by Finance::Quote for stock 8282
> 
> stock           field  value
> -----           -----  -----
> 8282         currency: CAD
> 8282             date: 08/12/2019
> 8282          isodate: 2019-08-12
> 8282             last: 14.91
> 8282             link: https://www.fundlibrary.com/MutualFunds/Detail/8282
> 8282           method: fundlibrary
> 8282           source: http://www.fundlibrary.com
> 8282          success: 1
> 8282           symbol: 8282
> 
> 
> So the results looks correct to me.  BUT when I go to Tools->Price
> Database, and clicked "Get Quotes" button, I still CANNOT get the results.
> 
> How should I debug this problem?
> 
> Thanks a lot.
> 
> 
> 
> 
> 
> 
> On Tue, Aug 13, 2019 at 1:21 PM Ove Grunnér <write2ove at gmail.com> wrote:
> 
>> Sorry, I don't know, I'm using Linux, so directories will be very
>> different.
>> br Ove.
>> 
>> On Tue, 13 Aug 2019 at 03:05, Kaman Wu <kamanwu at gmail.com> wrote:
>> 
>>> Hello Ove,
>>> 
>>> I try to change the code by myself.  I am using windows 10 right now.
>>> 
>>> I find the perl code
>>> at: C:\Strawberry\cpan\build\Finance-Quote-1.49-0\lib\Finance\Quote\Cdnfundlibrary.pm
>>> 
>>> BUT after I made the change, it looks like the GNC still call the old
>>> code.  Can I change that file directly?
>>> Does GNC keep a copy of this file? (I cannot find the it)
>>> 
>>> Thanks a lot.
>>> 
>>> 
>>> 
>>> On Sun, Aug 11, 2019 at 1:46 PM Kaman Wu <kamanwu at gmail.com> wrote:
>>> 
>>>> 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.
>>>>>>>> 
>>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> 
>>>> 
>>>> 
>>>> 
>>> 
>>> 
> 
> -- 
> =============================
> http://www.GadgetSharp.com
> _______________________________________________
> 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