Re: [GNC] Downloading stock prices in the UK
Eric Success!! Thank you very much for your detailed help with this problem. Quite by chance, I looked at "Preferences" and in "Online Quotes" discovered the need for an Alpha Vantage API key, which I hadn't seen any mention of in the tutorial. Once I had obtained and applied that key, the downloads worked perfectly for all stocks without a hitch. Prior to your suggestion, I had been put off the use of AlphaVantage by its US suffix and had tried all of the GB suffixed sources before concluding that it must be the Symbol or Namespace Type that was causing the problem. Reassurance from you and Fred helped to clarify that aspect so I was then able to focus on AlphaVantage again, initially without success until I discovered the need for a key! Thanks again; I'm very grateful for all the help given. Best wishes Alan Eric Coates wrote > Alan > > Before commenting about the failure of Get Online Quotes to get anything > useful a small amplification of Fred Bone's comment that *Type* can be > anything you want (Fred has given his choice, I use a different set - > LSE for London quoted shares, EUREX for shares quoted on continental > European bourses, Fund for unit trusts - use whatever works for you ) so > can the *F**ull Name* - for example you could use SSE or Scottish and > Southern Electricity or even its full formal name SSE Plc Ord 50p. > > As for why you're not getting even one quote ... > > You've obviously got an internet connection and you're?? ticking the *Get > Online Quotes* box and (I assume) you've updated the AphaVantage.pm file > so I'm close to the edge of my knowledge. > > On the basis of those assumptions, I'd try something a little "left > field". Safeguard your data and try changing the source of quotes to > *Single - Yahoo as JSON*. As I said earlier Yahoo is seen as reliable (I > use it for my European shares) but I'd expect you to get a price that > will be 100 times too big (just try one share then if you're > brave/foolhardy enough to risk your live data it's easy to delete the > wrong value). The result of this experiment may (just may) give us > something to get our teeth into. And when I say "us"/"our" I mean the > community at large - as I said I'm staring into the dark. > > Best wishes > > Eric > > PS: But there's a small niggle that I've just noticed: I've just > upgraded my operating system and got an upgraded gnuCash as a bonus (I'm > now running gnuCash 3.4 with Finance::Quote 1.47 on Ubuntu 19.04 all of > which, I believe, are the most up-to-date versions). In the Edit > Security window what used to appear as *AlphaVantage* in the *Unknown* > category now appears as *Alphavantage, US* under *Single*. Even though > the name has changed Alphavantage, US gives me legitimate values for UK > shares. Did the US put you off? It seems unlikely. > > > == -- 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] Downloading stock prices in the UK
Eric, Just for completeness, v3.5 is the most current. But 3.4 is what is in the 19.04 repos. For now, if you want 3.5 you’ll need to build from source. (easy to do) One list user is working on re-packaging a .deb of 3.5 to work on 19.04 and there is an unpublicized (and very experimental) Flatpak floating around, though I don’t know if it is at 3.5 yet. I don’t keep up with FQ version numbers to know if there is a more recent one packaged with 3.5. Regards, Adrien > On Apr 25, 2019, at 4:22 PM, Eric Coates wrote: > > Alan > > Before commenting about the failure of Get Online Quotes to get anything > useful a small amplification of Fred Bone's comment that *Type* can be > anything you want (Fred has given his choice, I use a different set - LSE for > London quoted shares, EUREX for shares quoted on continental European > bourses, Fund for unit trusts - use whatever works for you ) so can the > *F**ull Name* - for example you could use SSE or Scottish and Southern > Electricity or even its full formal name SSE Plc Ord 50p. > > As for why you're not getting even one quote ... > > You've obviously got an internet connection and you're?? ticking the *Get > Online Quotes* box and (I assume) you've updated the AphaVantage.pm file so > I'm close to the edge of my knowledge. > > On the basis of those assumptions, I'd try something a little "left field". > Safeguard your data and try changing the source of quotes to *Single - Yahoo > as JSON*. As I said earlier Yahoo is seen as reliable (I use it for my > European shares) but I'd expect you to get a price that will be 100 times too > big (just try one share then if you're brave/foolhardy enough to risk your > live data it's easy to delete the wrong value). The result of this experiment > may (just may) give us something to get our teeth into. And when I say > "us"/"our" I mean the community at large - as I said I'm staring into the > dark. > > Best wishes > > Eric > > PS: But there's a small niggle that I've just noticed: I've just upgraded my > operating system and got an upgraded gnuCash as a bonus (I'm now running > gnuCash 3.4 with Finance::Quote 1.47 on Ubuntu 19.04 all of which, I believe, > are the most up-to-date versions). In the Edit Security window what used to > appear as *AlphaVantage* in the *Unknown* category now appears as > *Alphavantage, US* under *Single*. Even though the name has changed > Alphavantage, US gives me legitimate values for UK shares. Did the US put you > off? It seems unlikely. > > > == > ___ 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] Downloading stock prices in the UK
Alan Before commenting about the failure of Get Online Quotes to get anything useful a small amplification of Fred Bone's comment that *Type* can be anything you want (Fred has given his choice, I use a different set - LSE for London quoted shares, EUREX for shares quoted on continental European bourses, Fund for unit trusts - use whatever works for you ) so can the *F**ull Name* - for example you could use SSE or Scottish and Southern Electricity or even its full formal name SSE Plc Ord 50p. As for why you're not getting even one quote ... You've obviously got an internet connection and you're?? ticking the *Get Online Quotes* box and (I assume) you've updated the AphaVantage.pm file so I'm close to the edge of my knowledge. On the basis of those assumptions, I'd try something a little "left field". Safeguard your data and try changing the source of quotes to *Single - Yahoo as JSON*. As I said earlier Yahoo is seen as reliable (I use it for my European shares) but I'd expect you to get a price that will be 100 times too big (just try one share then if you're brave/foolhardy enough to risk your live data it's easy to delete the wrong value). The result of this experiment may (just may) give us something to get our teeth into. And when I say "us"/"our" I mean the community at large - as I said I'm staring into the dark. Best wishes Eric PS: But there's a small niggle that I've just noticed: I've just upgraded my operating system and got an upgraded gnuCash as a bonus (I'm now running gnuCash 3.4 with Finance::Quote 1.47 on Ubuntu 19.04 all of which, I believe, are the most up-to-date versions). In the Edit Security window what used to appear as *AlphaVantage* in the *Unknown* category now appears as *Alphavantage, US* under *Single*. Even though the name has changed Alphavantage, US gives me legitimate values for UK shares. Did the US put you off? It seems unlikely. == On 25/04/2019 20:01, AEG via gnucash-user wrote: I think I've just figured out the Namespace/Security type from your first sentence Eric, which is that the name LSE should be used. However, I'm still not having any success with downloading quotes, even with just one stock at the time. Alan GnuCash - User mailing list wrote Hi Eric, Thank you for your help with this. I understand that the Symbol/Abbreviation should be SSE.L and that agrees with what I used to use with AceMoney, but I'm a little confused about what should appear under the heading "Namespace" in the GnuCash Security Editor and under the heading "Security" in the Price Editor. The existing security types are listed as AMEX, EUREX, FUND, NASDAQ and NYSE, none of which appears relevant for me, which is why I created the LON type. I did this because, when I looked up SSE.L in Google, it came back with the code LON: SSE and when I did the same thing for AMZN it came back with NASDAQ: AMZN , so I concluded that LON ought to work. If that is not right, what should my security type be? Alan Hi Alan The namespace for LSE is L; thus Symbol/Abbreviation should be SSE.L Similarly for other LSE quoted stocks -- 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.
Re: [GNC] Downloading stock prices in the UK
I think I've just figured out the Namespace/Security type from your first sentence Eric, which is that the name LSE should be used. However, I'm still not having any success with downloading quotes, even with just one stock at the time. Alan GnuCash - User mailing list wrote > Hi Eric, > > Thank you for your help with this. > I understand that the Symbol/Abbreviation should be SSE.L and that agrees > with what I used to use with AceMoney, but I'm a little confused about > what > should appear under the heading "Namespace" in the GnuCash Security Editor > and under the heading "Security" in the Price Editor. > > The existing security types are listed as AMEX, EUREX, FUND, NASDAQ and > NYSE, none of which appears relevant for me, which is why I created the > LON > type. I did this because, when I looked up SSE.L in Google, it came back > with the code LON: SSE and when I did the same thing for AMZN it came back > with NASDAQ: AMZN , so I concluded that LON ought to work. > > If that is not right, what should my security type be? > > Alan > > >> Hi Alan >> >> The namespace for LSE is L; thus Symbol/Abbreviation should be SSE.L >> Similarly for other LSE quoted stocks -- 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] Downloading stock prices in the UK
On 25 April 2019 at 9:56, AEG said: > Hi Eric, > > Thank you for your help with this. > I understand that the Symbol/Abbreviation should be SSE.L and that agrees > with what I used to use with AceMoney, but I'm a little confused about > what should appear under the heading "Namespace" in the GnuCash Security > Editor and under the heading "Security" in the Price Editor. > > The existing security types are listed as AMEX, EUREX, FUND, NASDAQ and > NYSE, none of which appears relevant for me, which is why I created the > LON type. I did this because, when I looked up SSE.L in Google, it came > back with the code LON: SSE and when I did the same thing for AMZN it came > back with NASDAQ: AMZN , so I concluded that LON ought to work. > > If that is not right, what should my security type be? Anything you like; it's only used to group the entries for your convenience. I use "LSE" (or "Paris" for Eurotunnel), and when something ceases to be quoted (ICI; BG) I move the entry to "LSE-". ___ 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] Downloading stock prices in the UK
Hi Eric, Thank you for your help with this. I understand that the Symbol/Abbreviation should be SSE.L and that agrees with what I used to use with AceMoney, but I'm a little confused about what should appear under the heading "Namespace" in the GnuCash Security Editor and under the heading "Security" in the Price Editor. The existing security types are listed as AMEX, EUREX, FUND, NASDAQ and NYSE, none of which appears relevant for me, which is why I created the LON type. I did this because, when I looked up SSE.L in Google, it came back with the code LON: SSE and when I did the same thing for AMZN it came back with NASDAQ: AMZN , so I concluded that LON ought to work. If that is not right, what should my security type be? Alan 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.
Re: [GNC] Downloading stock prices in the UK
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.
Re: [GNC] Downloading stock prices in the UK
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.
[GNC] Downloading stock prices in the UK
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.