I do not use yahoo (Just use yahoo_json) when I use gnc-fq-helper, I got: (("8282" (symbol . "8282") (gnc:time-no-zone . "2019-08-12 12:00:00") (last . #e14.91) (currency . "CAD")))
Is #e14.91 a problem? Thanks, On Tue, Aug 13, 2019 at 10:35 PM David Reiser <dbrei...@icloud.com> 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. > > -- ============================= 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.