[GNC] Get online quote for Canada Fund
Kaman Wu
kamanwu at gmail.com
Mon Aug 12 23:39:41 EDT 2019
I found the place. it should be: C:\Strawberry\perl\site\lib\Finance\Quote
On Mon, Aug 12, 2019 at 10:05 PM 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.
>>>>>>
>>>>>
>>>>
>>>>
>>>>
>>
>>
>>
>
>
More information about the gnucash-user
mailing list