[GNC] Online Quotes

[Alex Dorsch]

Hi,

I'm having trouble getting online quotes for share prices in Gnucash.

I'm fiddeling around with finance::quote

While this works:

$ ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage googl
Finance::Quote fields Gnucash uses:
symbol: googl<=== required
  date: 07/22/2020   <=== recommended
  currency: USD  <=== required
  last: 1564.8500<=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

Everything that's not listed in the US does not:

$ gnc-fq-dump sixshares CH0010645932
Finance::Quote fields Gnucash uses:
symbol: CH0010645932 <=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\   
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


$ gnc-fq-dump yahoo_json GB00B24CGK77.L
Use of uninitialized value $json_name in concatenation (.) or string at
/usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 132.
Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 145.
Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 145.
Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 156.
Use of uninitialized value in sprintf at
/usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 178.
Use of uninitialized value in sprintf at
/usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 178.
Finance::Quote fields Gnucash uses:
symbol: GB00B24CGK77.L   <=== required
  date: 07/23/2020   <=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\   
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!

I would be very glad to receive some help. I've been looking around for
portfolio tracking software on linux (jstock, several web based
products, etc.) and haven't found anything satisfactory.

I'd be really happy if I could use Gnucash for all my financial
managing needs, but at this point I find it quite cumbersombe.

Best regards,

Alex

___
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.

[GNC] Online quotes

[TFT]

Running Gnucash 2.2.26 and as far as can tell running finance quote 1.47

Previously had all setup to fetch quotes using Alphavantage then it stopped. I 
have since upgraded to the version above and entered my AV key into the 
software.

Alphavantage is selected in the security editor, when I try to retrieve quotes 
the Perl window opens and the pointer icon spins away - but nothing happens 
until eventually Gnucash stops responding. 

I have followed the wiki as best I can and am sure that all is installed as 
should be.

Please help, or is there another solution?

Sent from my iPad
___
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.

[GNC] Online Quotes

[Anna Scott]

Since installing version 5.0 of gnucash, online quotes has stopped 
working for me. I have tried uninstalling and reinstalling perl and the 
finance quote function several times but no joy. When I try and retrieve 
quotes via the price tool, I get two blank perl screens flash up but not 
error messages and no update. I have looked in the bin directory and 
gnc-fq-dump seems to be missing?? Could this be the problem? How can I 
download it?


Many thanks for any help, Anna

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Online quotes

[Wolfgang Paul Rauchholz]

Good day!

I installed gnucash-5.0 on fedora core 38
perl-Finance-Quote.noarch-1.5400-3.fc38
and perl-Date-Manip.noarch-6.91-1.fc38 are installed too.
It appears that the auxiliary programs
like gnc-fq-dump, gnc-fq-check, gnc-fq-update were not installed during
compilation.
How can I fix this?

Thanks

Regards,


Wolfgang Rauchholz
+34 627 994 977
https://www.linkedin.com/in/wolfgangrauchholz/
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Online Quotes

[Colin]

Hi Alex,

I just set up a test stock in GnuCash with the stock you listed. Yahoo JSON
worked - but you have to use their ticker symbol ("GIVN.SW"). You can find
this on the Yahoo Finance website.

Incidentally, in the Security Editor where Alphavantage is listed, it says
"US" after it, which suggests it only works with US-based items. I use
Yahoo-JSON for all my own assets. It's been reliable, accurate and covers
everything I've needed so far - including cryptocurrency. Now I know it
includes international stocks too.

In GnuCash go to Tools - Security Editor and choose New to add your stock,
or Edit if it already exists. The bottom half of the pop-up window is for
quote information. After selecting "Get Online Quotes", in the Single quote
source section, choose the dropdown. You'll find Yahoo JSON at the bottom
of that list.

Best,
Colin

Date: Thu, 23 Jul 2020 09:23:56 +0200
> From: Alex Dorsch 
> To: gnucash-user@gnucash.org
> Subject: [GNC] Online Quotes
> Message-ID:
> <4be1eabd21d0e2ad2f7bb7c060291d54959370b2.ca...@posteo.net>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi,
>
> I'm having trouble getting online quotes for share prices in Gnucash.
>
> I'm fiddeling around with finance::quote
>
> While this works:
>
> $ ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage googl
> Finance::Quote fields Gnucash uses:
> symbol: googl<=== required
>   date: 07/22/2020   <=== recommended
>   currency: USD  <=== required
>   last: 1564.8500<=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> Everything that's not listed in the US does not:
>
> $ gnc-fq-dump sixshares CH0010645932
> Finance::Quote fields Gnucash uses:
> symbol: CH0010645932 <=== required
>   date: ** missing **<=== recommended
>   currency: ** missing **<=== required
>   last: **missing**  <=\
>nav: **missing**  <=== one of these
>  price: **missing**  <=/
>   timezone:  <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
>
> $ gnc-fq-dump yahoo_json GB00B24CGK77.L
> Use of uninitialized value $json_name in concatenation (.) or string at
> /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 132.
> Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
> eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 145.
> Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
> eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 145.
> Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
> eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 156.
> Use of uninitialized value in sprintf at
> /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 178.
> Use of uninitialized value in sprintf at
> /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 178.
> Finance::Quote fields Gnucash uses:
> symbol: GB00B24CGK77.L   <=== required
>   date: 07/23/2020   <=== recommended
>   currency: ** missing **<=== required
>   last: **missing**  <=\
>nav: **missing**  <=== one of these
>  price: **missing**  <=/
>   timezone:  <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
> I would be very glad to receive some help. I've been looking around for
> portfolio tracking software on linux (jstock, several web based
> products, etc.) and haven't found anything satisfactory.
>
> I'd be really happy if I could use Gnucash for all my financial
> managing needs, but at this point I find it quite cumbersombe.
>
> Best regards,
>
> Alex
>
>
>
___
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.

Re: [GNC] Online Quotes

[John Ralls]

> On Jul 23, 2020, at 12:23 AM, Alex Dorsch  wrote:
> 
> Hi,
> 
> I'm having trouble getting online quotes for share prices in Gnucash.
> 
> I'm fiddeling around with finance::quote
> 
> While this works:
> 
> $ ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage googl
> Finance::Quote fields Gnucash uses:
>symbol: googl<=== required
>  date: 07/22/2020   <=== recommended
>  currency: USD  <=== required
>  last: 1564.8500<=\   
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> Everything that's not listed in the US does not:
> 
> $ gnc-fq-dump sixshares CH0010645932
> Finance::Quote fields Gnucash uses:
>symbol: CH0010645932 <=== required
>  date: ** missing **<=== recommended
>  currency: ** missing **<=== required
>  last: **missing**  <=\   
>   nav: **missing**  <=== one of these
> price: **missing**  <=/
>  timezone:  <=== optional
> 
> ** This stock quote cannot be used by GnuCash!
> 
> 
> $ gnc-fq-dump yahoo_json GB00B24CGK77.L
> Use of uninitialized value $json_name in concatenation (.) or string at
> /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 132.
> Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
> eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 145.
> Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
> eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 145.
> Use of uninitialized value $info{"GB00B24CGK77.L\34currency"} in string
> eq at /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 156.
> Use of uninitialized value in sprintf at
> /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 178.
> Use of uninitialized value in sprintf at
> /usr/share/perl5/site_perl/Finance/Quote/YahooJSON.pm line 178.
> Finance::Quote fields Gnucash uses:
>symbol: GB00B24CGK77.L   <=== required
>  date: 07/23/2020   <=== recommended
>  currency: ** missing **<=== required
>  last: **missing**  <=\   
>   nav: **missing**  <=== one of these
> price: **missing**  <=/
>  timezone:  <=== optional
> 
> ** This stock quote cannot be used by GnuCash!
> 
> I would be very glad to receive some help. I've been looking around for
> portfolio tracking software on linux (jstock, several web based
> products, etc.) and haven't found anything satisfactory.
> 
> I'd be really happy if I could use Gnucash for all my financial
> managing needs, but at this point I find it quite cumbersombe.

Neither GnuCash nor Finance::Quote can magic up a response for a query that the 
website doesn't understand. Both of those queries on the respective websites 
produce "not found" errors. 

That aside, GnuCash is an accounting program. While it has limited features to 
account for investments it is not in any way a portfolio tracking program. 
Sorry.

Regards,
John Ralls

___
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.

Re: [GNC] Online quotes

[Maf. King]

On Tuesday, 24 April 2018 09:01:33 BST TFT wrote:
> Running Gnucash 2.2.26 and as far as can tell running finance quote 1.47
> 

Hi,

can you double check and confirm  the version no. of GC that you are using?  
2.2.26 (if it exists) will be very old code by now.

I don't have any advice to offer about the downloading quotes from 
AlphaVantage, though. 

Maf.

___
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.

Re: [GNC] Online quotes

[Peter Rowed via gnucash-user]

My solution to this problem was to go to Gnucash version 3. Once upgraded you 
have to go into preferences->on line quotes and set the Alphavantge key. As I 
am in Australia I had to append a .AX to each security abbreviation (eg BHP 
becomes BHP.AX) as these are listed on the Australian ASX.

Slower than Yahoo but it works.

Good luck

Sent from ProtonMail mobile

 Original Message 
On 24 Apr. 2018, 18:01, TFT wrote:

> Running Gnucash 2.2.26 and as far as can tell running finance quote 1.47
>
> Previously had all setup to fetch quotes using Alphavantage then it stopped. 
> I have since upgraded to the version above and entered my AV key into the 
> software.
>
> Alphavantage is selected in the security editor, when I try to retrieve 
> quotes the Perl window opens and the pointer icon spins away - but nothing 
> happens until eventually Gnucash stops responding.
>
> I have followed the wiki as best I can and am sure that all is installed as 
> should be.
>
> Please help, or is there another solution?
>
> Sent from my iPad
> ___
> 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.

Re: [GNC] Online quotes

[TFT]

Apologies 2.6.21

Sent from my iPad

> On 24 Apr 2018, at 4:30 pm, Maf. King  wrote:
> 
>> On Tuesday, 24 April 2018 09:01:33 BST TFT wrote:
>> Running Gnucash 2.2.26 and as far as can tell running finance quote 1.47
>> 
> 
> Hi,
> 
> can you double check and confirm  the version no. of GC that you are using?  
> 2.2.26 (if it exists) will be very old code by now.
> 
> I don't have any advice to offer about the downloading quotes from 
> AlphaVantage, though. 
> 
> Maf.
> 
> ___
> 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.

Re: [GNC] Online quotes

[TFT]

Hi Peter


Also in Aus can get American quotes via yahoo JSON but nothing for Aus

Running 2.6.21 and have entered the Alphavantage key but no joy- you talk about 
appending .ax where do you do that?

Sent from my iPad

> On 24 Apr 2018, at 4:46 pm, Peter Rowed  wrote:
> 
> My solution to this problem was to go to Gnucash version 3. Once upgraded you 
> have to go into preferences->on line quotes and set the Alphavantge key. As I 
> am in Australia I had to append a .AX to each security abbreviation (eg BHP 
> becomes BHP.AX) as these are listed on the Australian ASX.
> 
> Slower than Yahoo but it works.
> 
> Good luck
> 
> 
> Sent from ProtonMail mobile
> 
> 
> 
>  Original Message 
> On 24 Apr. 2018, 18:01, TFT < thornefamilytr...@bigpond.com> wrote:
> 
> Running Gnucash 2.2.26 and as far as can tell running finance quote 1.47
> 
> Previously had all setup to fetch quotes using Alphavantage then it stopped. 
> I have since upgraded to the version above and entered my AV key into the 
> software.
> 
> Alphavantage is selected in the security editor, when I try to retrieve 
> quotes the Perl window opens and the pointer icon spins away - but nothing 
> happens until eventually Gnucash stops responding. 
> 
> I have followed the wiki as best I can and am sure that all is installed as 
> should be.
> 
> Please help, or is there another solution?
> 
> Sent from my iPad
> ___
> 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.

Re: [GNC] Online quotes

[TFT]

Hi Peter 

All sorted and working after adding.AX

Thanks Kevin 

Sent from my iPad

> On 24 Apr 2018, at 4:51 pm, TFT  wrote:
> 
> Hi Peter
> 
> 
> Also in Aus can get American quotes via yahoo JSON but nothing for Aus
> 
> Running 2.6.21 and have entered the Alphavantage key but no joy- you talk 
> about appending .ax where do you do that?
> 
> Sent from my iPad
> 
>> On 24 Apr 2018, at 4:46 pm, Peter Rowed  wrote:
>> 
>> My solution to this problem was to go to Gnucash version 3. Once upgraded 
>> you have to go into preferences->on line quotes and set the Alphavantge key. 
>> As I am in Australia I had to append a .AX to each security abbreviation (eg 
>> BHP becomes BHP.AX) as these are listed on the Australian ASX.
>> 
>> Slower than Yahoo but it works.
>> 
>> Good luck
>> 
>> 
>> Sent from ProtonMail mobile
>> 
>> 
>> 
>>  Original Message 
>> On 24 Apr. 2018, 18:01, TFT < thornefamilytr...@bigpond.com> wrote:
>> 
>> Running Gnucash 2.2.26 and as far as can tell running finance quote 1.47
>> 
>> Previously had all setup to fetch quotes using Alphavantage then it stopped. 
>> I have since upgraded to the version above and entered my AV key into the 
>> software.
>> 
>> Alphavantage is selected in the security editor, when I try to retrieve 
>> quotes the Perl window opens and the pointer icon spins away - but nothing 
>> happens until eventually Gnucash stops responding. 
>> 
>> I have followed the wiki as best I can and am sure that all is installed as 
>> should be.
>> 
>> Please help, or is there another solution?
>> 
>> Sent from my iPad
>> ___
>> 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.

Re: [GNC] Online quotes

[Peter Rowed via gnucash-user]

The .AX is appended to the symbol/abbreviation field in the edit security 
function of tools menu

Sent from ProtonMail mobile

 Original Message 
On 24 Apr. 2018, 18:51, TFT wrote:

> Hi Peter
>
> Also in Aus can get American quotes via yahoo JSON but nothing for Aus
>
> Running 2.6.21 and have entered the Alphavantage key but no joy- you talk 
> about appending .ax where do you do that?
>
> Sent from my iPad
>
> On 24 Apr 2018, at 4:46 pm, Peter Rowed  wrote:
>
>> My solution to this problem was to go to Gnucash version 3. Once upgraded 
>> you have to go into preferences->on line quotes and set the Alphavantge key. 
>> As I am in Australia I had to append a .AX to each security abbreviation (eg 
>> BHP becomes BHP.AX) as these are listed on the Australian ASX.
>>
>> Slower than Yahoo but it works.
>>
>> Good luck
>>
>> Sent from ProtonMail mobile
>>
>>  Original Message 
>> On 24 Apr. 2018, 18:01, TFT < thornefamilytr...@bigpond.com> wrote:
>>
>>> Running Gnucash 2.2.26 and as far as can tell running finance quote 1.47
>>>
>>> Previously had all setup to fetch quotes using Alphavantage then it 
>>> stopped. I have since upgraded to the version above and entered my AV key 
>>> into the software.
>>>
>>> Alphavantage is selected in the security editor, when I try to retrieve 
>>> quotes the Perl window opens and the pointer icon spins away - but nothing 
>>> happens until eventually Gnucash stops responding.
>>>
>>> I have followed the wiki as best I can and am sure that all is installed as 
>>> should be.
>>>
>>> Please help, or is there another solution?
>>>
>>> Sent from my iPad
>>> ___
>>> 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.

[GNC] Online quotes problem

[Graham Balin]

Hey guys n gals,

I'm afraid I'm getting a bit out of my depth here. Keep having problems 
getting online updates of stocks. Been through the archives but none of 
it seems relevant to me on this topic.


Tried re-installing the perl installer [on Win 10]and it seemed to be 
fine. Only problem is I still get 'unknown error' message when I try to 
'get quotes'.


As per the guide, I tried c:\Program Files (x86)\gnucash\bin>gnc-fq-dump 
-v yahoo USDEUR=X. .got:


'gnc-fq-dump' is not recognized as an internal or external command,
operable program or batch file.

Then I tried

c:\Program Files (x86)\gnucash\bin>echo (yahoo "CSCO") | perl gnc-fq-helper

and I got:

Use of uninitialized value $year in numeric lt (<) at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 750, <> line 1.
Use of uninitialized value $month in pattern match (m//) at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 768, <> line 1.
Use of uninitialized value $month in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $day in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $month in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $day in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $info{"in substitution (s///) at 
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 233, <> line 1.
Use of uninitialized value within %info in pattern match (m//) at 
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 238, <> line 1.

(#f)
I have no idea what is going on, and would value any tips of where to 
go/what to do.


TIA

--

Cheerio,

Graham


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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.

Re: [GNC] Online quotes

[Ken Farley]

From the release notes:

The Online Quotes facility has been completely rewritten and the old 
gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced 
with finance-quote-wrapper. The functions performed by those programs 
may now be accomplished by passing commands to gnucash-cli -Q, see 
gnucash-cli --help for specifics. The perl module requirements have 
changed with the rewrite: The new version doesn't need Date::Manip but 
needs JSON::Parse instead. gnc-fq-update has been, er, updated to 
reflect that.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Online quotes problem

[Frank H. Ellenberger]

Hi Graham,

Am 08.06.2018 um 18:40 schrieb Graham Balin:
> Hey guys n gals,
> 
> I'm afraid I'm getting a bit out of my depth here. Keep having problems
> getting online updates of stocks. Been through the archives but none of
> it seems relevant to me on this topic.
> 
> Tried re-installing the perl installer [on Win 10]and it seemed to be
> fine. Only problem is I still get 'unknown error' message when I try to
> 'get quotes'.
> 
> As per the guide, I tried c:\Program Files (x86)\gnucash\bin>gnc-fq-dump
> -v yahoo USDEUR=X. .got:

Last November Yahoo has shut down its CSV interface. That was broadly
discussed here. You can find the summary in
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F

> 'gnc-fq-dump' is not recognized as an internal or external command,
> operable program or batch file.
> 
> Then I tried
> 
> c:\Program Files (x86)\gnucash\bin>echo (yahoo "CSCO") | perl gnc-fq-helper
> 
> and I got:
> 
> Use of uninitialized value $year in numeric lt (<) at
> C:/strawberry/perl/site/lib/Finance/Quote.pm line 750, <> line 1.
> Use of uninitialized value $month in pattern match (m//) at
> C:/strawberry/perl/site/lib/Finance/Quote.pm line 768, <> line 1.
> Use of uninitialized value $month in sprintf at
> C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
> Use of uninitialized value $day in sprintf at
> C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
> Use of uninitialized value $month in sprintf at
> C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
> Use of uninitialized value $day in sprintf at
> C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
> Use of uninitialized value $info{" in substitution (s///) at
> C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 233, <>
> line 1.
> Use of uninitialized value within %info in pattern match (m//) at
> C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 238, <>
> line 1.
> (#f)
> I have no idea what is going on, and would value any tips of where to
> go/what to do.
> 
> TIA
> 
> -- 
> 
> Cheerio,
> 
> Graham

Regards
Frank

___
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.

Re: [GNC] Online quotes problem

[Graham Balin]

Many thanks for the reply, but sadly none of this works.
I tried adding an ".AX" stock as described below but that didn't work 
either.
I'm afraid I don't understand the references to API for AlphaVantage - 
is that something I need to find out about?

G

On 09/06/2018 07:38, WasserLand wrote:

Graham,

What follows here is a cut & paste of the recent chain of emails that 
resulted in the resolution of the same problem.  Read from bottom up, 
in blue.  Tell me if I can further elaborate:


Thank you Maf,

The very first thread led me to the answer.  Simply a matter of
adding an ".AX" suffix to the  share code!

How I struggled to resolve the matter prior!  As always the
solution is simple.

Thank again for responding to my outcry.

Dave W



On 06/06/18 23:48, Maf. King wrote:
Hi,

have you tried the list archives?  Try this thread (yes it is Win,
but that
isn't relevant)

https://lists.gnucash.org/pipermail/gnucash-user/2018-May/076983.html

or maybe this

https://lists.gnucash.org/pipermail/gnucash-user/2018-April/075839.html


HTH,
Maf.




On Wednesday, 6 June 2018 13:50:39 BST WasserLand wrote:

I have a problem with getting quotes for my ASX portfolio in GnuCash.
Finance::Quote no longer works.

I am running Ubuntu 16.04.

Any help, please.

Dave W

On 09/06/18 02:40, Graham Balin wrote:


Hey guys n gals,

I'm afraid I'm getting a bit out of my depth here. Keep having 
problems getting online updates of stocks. Been through the archives 
but none of it seems relevant to me on this topic.


Tried re-installing the perl installer [on Win 10]and it seemed to be 
fine. Only problem is I still get 'unknown error' message when I try 
to 'get quotes'.


As per the guide, I tried c:\Program Files 
(x86)\gnucash\bin>gnc-fq-dump -v yahoo USDEUR=X. .got:


'gnc-fq-dump' is not recognized as an internal or external command,
operable program or batch file.

Then I tried

c:\Program Files (x86)\gnucash\bin>echo (yahoo "CSCO") | perl 
gnc-fq-helper


and I got:

Use of uninitialized value $year in numeric lt (<) at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 750, <> line 1.
Use of uninitialized value $month in pattern match (m//) at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 768, <> line 1.
Use of uninitialized value $month in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $day in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $month in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $day in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $info{"\"-//W3C//"...} in substitution (s///) at 
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 233, <> 
line 1.
Use of uninitialized value within %info in pattern match (m//) at 
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 238, <> 
line 1.

(#f)
I have no idea what is going on, and would value any tips of where to 
go/what to do.


TIA

--

Cheerio,

Graham


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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.





--
--

Cheerio,

Graham

___
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.

Re: [GNC] Online quotes problem

[Maf. King]

On Saturday, 9 June 2018 10:22:19 BST Graham Balin wrote:
> Many thanks for the reply, but sadly none of this works.
> I tried adding an ".AX" stock as described below but that didn't work
> either.
> I'm afraid I don't understand the references to API for AlphaVantage -
> is that something I need to find out about?
> G
> 

Hi Graham

OK, back in November Yahoo stopped providing price information.  There was a 
lot of traffic on the list around then and some rapid patches provided by 
various developers to keep the wheels turning.

There are a couple of alternatives you can use - there is a service called 
Alphavantage which is nearly the same as the old Yahoo service.  But you need 
to register with Alphavantage and get an " API key" (a sequence of 
Alphanumeric characters to authorise you on their service) which the Finance 
Quote PERL scripts need to be told, but then can handle getting price info 
from Alphavantage.  The Gnucash FAQ contains details and instructions about 
that.

Another option - it has been reported on the list that Yahoo still have a way 
to get info - but you need to tell F::Q use "yahoo_json" in place of Yahoo.  I 
haven't tried it.  The list archives will have more info if you can search and 
find it!

HTH,
Maf.





___
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.

[GNC] Online quotes for funds

[Graham Balin]

Sorry to be a bore, but having cracked the stock quotes problem, I'm now 
having trouble with funds. I suspect the problem lies in the display 
box. Stocks are easy xyz.L or whatever, but how do I find out what funds 
should be?


I tried putting the ISIN number in but that doesn't work. Can someone 
point me to a source to find out the equivalent of a ticker for a fund?


--

Cheerio,

Graham


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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.

Re: [GNC] Online quotes problem -sorted

[Graham Balin]

Many thanks for the replies all
Going through the API route and altering the environment file has done 
the trick.

G

On 09/06/2018 11:48, Maf. King wrote:

On Saturday, 9 June 2018 10:22:19 BST Graham Balin wrote:

Many thanks for the reply, but sadly none of this works.
I tried adding an ".AX" stock as described below but that didn't work
either.
I'm afraid I don't understand the references to API for AlphaVantage -
is that something I need to find out about?
G


Hi Graham

OK, back in November Yahoo stopped providing price information.  There was a
lot of traffic on the list around then and some rapid patches provided by
various developers to keep the wheels turning.

There are a couple of alternatives you can use - there is a service called
Alphavantage which is nearly the same as the old Yahoo service.  But you need
to register with Alphavantage and get an " API key" (a sequence of
Alphanumeric characters to authorise you on their service) which the Finance
Quote PERL scripts need to be told, but then can handle getting price info
from Alphavantage.  The Gnucash FAQ contains details and instructions about
that.

Another option - it has been reported on the list that Yahoo still have a way
to get info - but you need to tell F::Q use "yahoo_json" in place of Yahoo.  I
haven't tried it.  The list archives will have more info if you can search and
find it!

HTH,
Maf.







--
--

Cheerio,

Graham


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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.

Re: [GNC] Online quotes for funds

[Fred Bone]

On 9 June 2018 at 17:37, Graham Balin said:

> Sorry to be a bore, but having cracked the stock quotes problem, I'm now
> having trouble with funds. I suspect the problem lies in the display box.
> Stocks are easy xyz.L or whatever, but how do I find out what funds should
> be?
> 
> I tried putting the ISIN number in but that doesn't work. Can someone
> point me to a source to find out the equivalent of a ticker for a fund?

Many funds are not listed in quote sources, or not with any regularity.

I just got data for one from Alphavantage: symbol=GB00BJ04HW53.L (which 
is Invesco Perpetual Income Y Accumulator). However, the "last refreshed" 
date is 27 April, making it of doubtful use (and a lot of dates show 
zeros, suggesting Alphavantage didn't get values on those dates).



___
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.

Re: [GNC] Online quotes for funds

[Richard Ullger]

Hi Graham,

> Sorry to be a bore, but having cracked the stock quotes problem, I'm now
> having trouble with funds. I suspect the problem lies in the display
> box. Stocks are easy xyz.L or whatever, but how do I find out what funds
> should be?
> 
> I tried putting the ISIN number in but that doesn't work. Can someone
> point me to a source to find out the equivalent of a ticker for a fund?
> 

Assuming you're in the UK going by the .L you're using, Morningstar, GB
works for me using just the ISIN code.

Regards,

Richard.



signature.asc
Description: OpenPGP digital signature
___
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.

Re: [GNC] Online quotes for funds

[Graham Balin]

On 10/06/2018 22:07, Richard Ullger wrote:

Assuming you're in the UK going by the .L you're using, Morningstar, GB
works for me using just the ISIN code.

Regards,

Richard.

Thanks Richard. Do you enter the account as a fund or a stock? I have 
tried both; I've tried online quotes -'single' morningstar gb and 
'multiple - Funds UK etc' but neither seem to do the trick. Keeps coming 
up as 'unable to retrieve quote'


--
--

Cheerio,

Graham


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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.

Re: [GNC] Online quotes for funds

[Richard Ullger]

Ok, I'll check it out.

On Wed, 13 Jun 2018, 16:19 Graham Balin,  wrote:

> On 10/06/2018 22:07, Richard Ullger wrote:
> > Assuming you're in the UK going by the .L you're using, Morningstar, GB
> > works for me using just the ISIN code.
> >
> > Regards,
> >
> > Richard.
> >
> Thanks Richard. Do you enter the account as a fund or a stock? I have
> tried both; I've tried online quotes -'single' morningstar gb and
> 'multiple - Funds UK etc' but neither seem to do the trick. Keeps coming
> up as 'unable to retrieve quote'
>
> --
> --
>
> Cheerio,
>
> Graham
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
___
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.

Re: [GNC] Online quotes for funds

[Richard Ullger]

Hi Graham,

On 13/06/18 16:19, Graham Balin wrote:
> Thanks Richard. Do you enter the account as a fund or a stock? I have
> tried both; I've tried online quotes -'single' morningstar gb and
> 'multiple - Funds UK etc' but neither seem to do the trick. Keeps coming
> up as 'unable to retrieve quote'
> 

The account is set up as type 'Mutual Fund' but that shouldn't affect
the quote source.

The quote source in the security editor is set up as Single:
Morningstar, GB.

You can try searching on http://www.morningstar.co.uk.

Regards,

Richard.
___
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.

[GNC] Online quotes for Canadian Mutual Funds

[mike823]

I have tried a couple of providers (bmonesbittburns, canadamutual,
fundlibrary) but none of them seems to be working. Any suggestions?

>perl "***\gnucash\bin\gnc-fq-dump" -v bmonesbittburns TDB902
Parsing of undecoded UTF-8 will give garbage when decoding entities at
D:/tools/Strawberry/perl/site/lib/HTML/TableExtract.pm line 204.
Finance::Quote fields Gnucash uses:
symbol: TDB902 (deduced) <=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock TDB902

stock   field  value
-   -  -
TDB902   errormsg: Fund name TDB902 not found, bad symbol name
TDB902   last: **missing**
TDB902nav: **missing**
TDB902  price: **missing**
TDB902 succes: 0


>perl "***\gnucash\bin\gnc-fq-dump" -v canadamutual TDB902
Parsing of undecoded UTF-8 will give garbage when decoding entities at
D:/tools/Strawberry/perl/site/lib/HTML/TableExtract.pm line 204.
Finance::Quote fields Gnucash uses:
symbol: TDB902 (deduced) <=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock TDB902

stock   field  value
-   -  -
TDB902   errormsg: Error determining fund code for TDB902.
TDB902   last: **missing**
TDB902nav: **missing**
TDB902  price: **missing**
TDB902success: 0


>perl "***\gnucash\bin\gnc-fq-dump" -v fundlibrary TDB902
Parsing of undecoded UTF-8 will give garbage when decoding entities at
D:/tools/Strawberry/perl/site/lib/HTML/TableExtract.pm line 204.
Finance::Quote fields Gnucash uses:
symbol: TDB902 (deduced) <=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock TDB902

stock   field  value
-   -  -
TDB902   errormsg: Fund name TDB902 not found
TDB902   last: **missing**
TDB902nav: **missing**
TDB902  price: **missing**
TDB902success: 0


>





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

[GNC] Online quotes for a mutual fund

[Jacob Larsen]

Hi

I am trying to get online quotes for a few mutual funds I am tracking, 
but I am having no luck, mostly because they don't really have any 
symbols, only ISINs. Anyone have any ideas on how I proceed on this one?


They are not available on Yahoo, but I found them on a few others 
without succeeding gnc-fq-dump with any of them, this is one of them:


https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK

https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F0TH8X

https://www.investing.com/funds/nordnet-superfonden-danmark


/Jacob

___
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.

Re: [GNC] Online quotes for a mutual fund

[Ruaraidh Sackville Hamilton]

Finding the right source and symbol seems a challenge! For several years
I've been successfully getting quotes through fq using the single source
"Alphavantage, US" for single UK equities, and the multiple-source "U.K.
funds" for UK funds. However, I can't find anything that works for UK
Treasury gilts (e.g. ISIN GB00BJMHB534, symbol TR29), even though they
appear on the LSE and FT websites. I've tried all sources listed in the GC
help system that seem reasonably possible. Some examples:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump alphavantage TR29.L
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds GB00BJMHB534
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump mstaruk GB00BJMHB534

all generate the error code
** This stock quote cannot be used by GnuCash!

Does anyone have any experience with this?

Regards,

Ruaraidh

On Mon, 17 May 2021 at 01:55, Geoff  wrote:

> Hi Jacob
>
> It looks like the Financial Times' Funds service will provide prices:
>
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds SE0005993078
>  symbol: SE0005993078 <=== required
>date: 05/12/2021   <=== recommended
>currency: DKK  <=== required
>last: 237.96   <=\
> nav: 237.96   <=== one of these
>   price: 237.96   <=/
>timezone:  <=== optional
>
>
>
> Regards
>
> Geoff
> =
>
> On 17/05/2021 7:35 am, Jacob Larsen wrote:
> > Hi
> >
> > I am trying to get online quotes for a few mutual funds I am tracking,
> > but I am having no luck, mostly because they don't really have any
> > symbols, only ISINs. Anyone have any ideas on how I proceed on this one?
> >
> > They are not available on Yahoo, but I found them on a few others
> > without succeeding gnc-fq-dump with any of them, this is one of them:
> >
> >
> https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK
> >
> > https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F0TH8X
> >
> > https://www.investing.com/funds/nordnet-superfonden-danmark
> >
> >
> > /Jacob
> >
> > ___
> > 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Online quotes for a mutual fund

[Geoff]

Hi Ruaraidh

I think you are out of luck with Gilts.  I have checked the web sites of 
Morningstar, Financial Times, Alphavantage, and Yahoo Finance; and none 
of them seem to be able to provide price data for Gilts securities.


I note that you can obtain price data directly from the LSX:-
https://www.londonstockexchange.com/stock/TR29/united-kingdom/company-page
However none of the Finance Quote modules currently use the LSX as a 
data source.



Regards

Geoff
=

On 24/08/2022 6:59 pm, Ruaraidh Sackville Hamilton wrote:
Finding the right source and symbol seems a challenge! For several years 
I've been successfully getting quotes through fq using the single source 
"Alphavantage, US" for single UK equities, and the multiple-source "U.K. 
funds" for UK funds. However, I can't find anything that works for UK 
Treasury gilts (e.g. ISIN GB00BJMHB534, symbol TR29), even though they 
appear on the LSE and FT websites. I've tried all sources listed in the 
GC help system that seem reasonably possible. Some examples:


C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump alphavantage TR29.L
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds GB00BJMHB534
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump mstaruk GB00BJMHB534

all generate the error code
** This stock quote cannot be used by GnuCash!

Does anyone have any experience with this?

Regards,

Ruaraidh

On Mon, 17 May 2021 at 01:55, Geoff > wrote:


Hi Jacob

It looks like the Financial Times' Funds service will provide prices:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds SE0005993078
      symbol: SE0005993078         <=== required
        date: 05/12/2021           <=== recommended
    currency: DKK                  <=== required
        last: 237.96               <=\
         nav: 237.96               <=== one of these
       price: 237.96               <=/
    timezone:                      <=== optional



Regards

Geoff
=

On 17/05/2021 7:35 am, Jacob Larsen wrote:
 > Hi
 >
 > I am trying to get online quotes for a few mutual funds I am
tracking,
 > but I am having no luck, mostly because they don't really have any
 > symbols, only ISINs. Anyone have any ideas on how I proceed on
this one?
 >
 > They are not available on Yahoo, but I found them on a few others
 > without succeeding gnc-fq-dump with any of them, this is one of them:
 >
 >
https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK

 >
 >
https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F0TH8X

 >
 > https://www.investing.com/funds/nordnet-superfonden-danmark

 >
 >
 > /Jacob
 >
 > ___
 > 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Online quotes for Canadian Mutual Funds

[Frank H. Ellenberger]

Hello Mike,

Am 02.03.21 um 17:44 schrieb mike823:
> I have tried a couple of providers (bmonesbittburns, canadamutual,
> fundlibrary) but none of them seems to be working. Any suggestions?
> 
>> perl "***\gnucash\bin\gnc-fq-dump" -v bmonesbittburns TDB902
:

perhaps you should explain, where the symbol "TDB902" stands for and in
which context. Note that symbol A at exchange X may be registered at
exchange Y as B.

regards
Frank
___
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.

Re: [GNC] Online quotes for Canadian Mutual Funds

[mike823]

Just to update you guys, Finance Quote 1.50 RC1 includes fixes for Canadian
Mutual Funds. Tested, everything works fine.


Details  here   



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

[GNC] Online quotes for currencies not working anymore

[mike823]

My GnuCash Installation stopped downloading online quotes for currencies ten
days ago. I am using 5 different currencies and I am only getting "unable to
retrieve quotes for ..." error only for 3 of them. See attached picture.

Looking for some ideea on how to troubleshot something like this. Who is
actually the online quotes provider for currencies? Can it be changed? TIA.

 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

[GNC] Online quotes for currencies not working anymore

[mike823]

My GnuCash Installation stopped downloading online quotes for currencies ten
days ago. I am using 5 different currencies and I am only getting "unable to
retrieve quotes for ..." error only for 3 of them. See attached picture.

Looking for some ideea on how to troubleshot something like this. Who is
actually the online quotes provider for currencies? Can it be changed? TIA.

 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] Online quotes for a mutual fund

[Geoff]

Hi Jacob

It looks like the Financial Times' Funds service will provide prices:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds SE0005993078
symbol: SE0005993078 <=== required
  date: 05/12/2021   <=== recommended
  currency: DKK  <=== required
  last: 237.96   <=\
   nav: 237.96   <=== one of these
 price: 237.96   <=/
  timezone:  <=== optional



Regards

Geoff
=

On 17/05/2021 7:35 am, Jacob Larsen wrote:

Hi

I am trying to get online quotes for a few mutual funds I am tracking, 
but I am having no luck, mostly because they don't really have any 
symbols, only ISINs. Anyone have any ideas on how I proceed on this one?


They are not available on Yahoo, but I found them on a few others 
without succeeding gnc-fq-dump with any of them, this is one of them:


https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK

https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F0TH8X

https://www.investing.com/funds/nordnet-superfonden-danmark


/Jacob

___
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.

Re: [GNC] Online quotes for a mutual fund

[jacob]

On 2021-05-17 02:53, Geoff wrote:

It looks like the Financial Times' Funds service will provide prices:


Thanks for checking this. I get this for the same command, but verbose:

$ gnc-fq-dump -v ftfunds SE0005993078
Finance::Quote fields Gnucash uses:
symbol: SE0005993078 <=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock SE0005993078

stock   field  value
-   -  -
SE0005993078   errormsg: Error - failed to find a price
SE0005993078   last: **missing**
SE0005993078   name: *** UNKNOWN ***
SE0005993078nav: **missing**
SE0005993078  price: **missing**
SE0005993078 source: 
http://funds.ft.com/UK/Tearsheet/Summary?s=SE0005993078

SE0005993078success: 0
SE0005993078 symbol: SE0005993078


This suggests that the issue is with my setup and not the sources as 
such. Would you mind helping me out and send the verbose output from a 
working system?


I have run "sudo gnc-fq-update" before this, and it has ensured than I 
am running Finance::Quote v1.49. It did warn about my perl version being 
v5.26.1, which is the version from Ubuntu 18.04.


I am also running Gnucash 4.5 which I have compiled from sources. So I 
could use a couple of pointers for debugging this.


/Jacob
___
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.

Re: [GNC] Online quotes for a mutual fund

[jacob]

On 2021-05-17 21:29, ja...@larsen.net wrote:
This suggests that the issue is with my setup and not the sources as 
such.


Some more googling finally found me this one: 
http://gnucash.1415818.n4.nabble.com/GNC-Finance-Quote-sort-of-works-almost-td4724226.html


So it turns out that I need to install the unreleased master branch of 
Finance::Quote for this to work, since ftfunds have changed URL, and is 
broken in the latest v1.49 version. I cloned 
https://github.com/finance-quote/finance-quote.git, then copied 
lib/Finance/* to /usr/local/share/perl/5.26.1/Finance/ where my 
Finance::Quote is installed. I then additionally installed these from 
cpan: Web::Scraper, Spreadsheet::XLSX, HTML::TokeParser::Simple.


And now I am able to use the online quotes for all these funds. Thanks.

/Jacob
___
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.

Re: [GNC] Online quotes for currencies not working anymore

[Geoff]

Hi Mike

I believe that you need a valid Alpha Vantage API key for currencies:
GnuCash / Edit / Preferences / Online Quotes.

https://wiki.gnucash.org/wiki/Online_Quotes

For troubleshooting from the command line, try this on Windows:

C:\Program Files (x86)\gnucash\bin>set 
ALPHAVANTAGE_API_KEY=__Your_Actual_Key__


C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
__Your_Actual_Key__

C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl 
gnc-fq-helper
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10 08:40:01") 
(last . #e0.72002) (currency . "GBP")))


C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl 
gnc-fq-helper
(("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 08:45:05") 
(last . #e4.8841) (currency . "RON")))


[The commands are similar on Unix.]

See attached screenshot.

Regards

Geoff
=


On 10/03/2021 2:00 am, mike823 wrote:

My GnuCash Installation stopped downloading online quotes for currencies ten
days ago. I am using 5 different currencies and I am only getting "unable to
retrieve quotes for ..." error only for 3 of them. See attached picture.

Looking for some ideea on how to troubleshot something like this. Who is
actually the online quotes provider for currencies? Can it be changed? TIA.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.