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 dbrei...@icloud.com
> On Aug 13, 2019, at 9:29 PM, Kaman Wu <kama...@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 <write2...@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 <kama...@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 <kama...@gmail.com> wrote: >>> >>>> thanks a lot. I will try it. >>>> >>>> On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér <write2...@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 <kama...@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 <write2...@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 <kama...@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@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@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@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.