[GNC] Get online quote for Canada Fund
John Ralls
jralls at ceridwen.us
Tue Aug 13 23:59:02 EDT 2019
No, the #e means that it's an exact number (1491/100) instead of a floating-point one. That's a Good Thing™.
Are you getting the "Unable to create price quotes for these items" dialog?
Regards,
John Ralls
> On Aug 13, 2019, at 8:38 PM, Kaman Wu <kamanwu at gmail.com> wrote:
>
> 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
> _______________________________________________
> 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