Bet it took you three times because you didn't realize that you can open Tools>Securities, go to the right end of the header, click the little arrow and select Source to add the quote source to the display columns, then click that column header to sort on it.
Namespace (e.g. NYSE) is still the primary sort key, but inside each namespace the securities will be sorted by the quote source making it much easier to find "bad" sources. Regards, John Ralls > On Aug 13, 2019, at 7:35 PM, David Reiser via gnucash-user > <gnucash-user@gnucash.org> wrote: > > 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. _______________________________________________ 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.
