Alan
Bugger! My email system added a host of unwanted backslashes to the
updated part of AlphaVantage.pm. To get the right effect they should be
deleted.
On behalf of my email system, I tender apologies.
Eric
============================
On 25/04/2019 13:52, Eric Coates wrote:
Hi Alan
The namespace for LSE is L; thus Symbol/Abbreviation should be SSE.L
Similarly for other LSE quoted stocks
Getting the quotes themselves is a little fraught. In my experience
the only source that "works" is AlphaVantage (the usual suggestion of
using Yahoo-JSON returns prices that are 100 times too large, LSE
quotes prices in pennies Yahoo interprets the numbers as pounds -
you'll look very rich until you note the problem!)
However, there is a problem with AlphaVantage; they throttle the feed
so that you can only get five quotes per minute. there are two
workarounds:
(1) Tick Get Online Quotes (in the Security Editor tool) in just (say)
three stocks, run the price getter; untick those three stocks and tick
the remaining three stocks and re-run the price getter.
(2) the AlphaVantage.pm file can be modified to include a 15 second
pause between price gets - everything goes slowly (but perhaps not too
bad for six shares) but it does go. My experience is on Ubuntu so I
can't tell you where the Alphavantage.pm file is on Windows but if you
can find it (there are probably useful hints on this mailing list) the
change needed is:
right at the end of the file is a bit that looks something like this
/$quantity--;/
//
/select(undef, undef, undef, .7) if ($quantity); sleep(15);/
//
/}/
//
/return wantarray() ? %info : \%info;/
(the italicisation is mine to keep that text separate from the body of
this note) except that it doesn't have the sleep(15). Adding that is
the change needed.
The second way is better if/when you have a larger portfolio but it
can get to be a drag with all those delays!
Good luck
Eric
===================================
On 25/04/2019 11:56, AEG via gnucash-user wrote:
I'm using GnuCash version 2.6.21 on Windows 10 and would appreciate
some help
with setting up investment accounts in the UK.
I have a small portfolio comprising six stocks and, following the
tutorial,
have successfully set up accounts for each one. However, I am not
sure about
the source of online stock prices so I'm hoping there will be a UK
user who
can point me in the right direction.
So far, I have been using a trial and error approach without any
success and
I'm wondering whether my stock symbols might be incorrect. For
example, I
have some Scottish & Southern shares for which I have set the Symbol
to SSE
and in the Security Editor I have set the Namespace to LON.
Any help on resolving this would be much appreciated.
Alan
--
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.
_______________________________________________
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.
