[GNC] Get online quote for Canada Fund
Kaman Wu
kamanwu at gmail.com
Tue Aug 13 23:38:01 EDT 2019
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 <dbreiser at 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
> 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.
>
>
--
=============================
http://www.GadgetSharp.com
More information about the gnucash-user
mailing list