Re: [GNC] Finance Quote - Alphavantage Error - Subscribe to Premium

2024-06-22 Thread David H
Hi John, Yes I was aware of the issues with Alphavantage and I have seen/read Bruce's and also Kalpesh's emails on the subject both here and in FQ-DEV. I was just surprised as any Alphavantage issues seemed to have no real impact on the behaviour of my particular FQ and to suddenly

Re: [GNC] Finance Quote - Alphavantage Error - Subscribe to Premium

2024-06-21 Thread David H
Well Bruce I've only seen this error message today and yesterday, go figure :-) On Sat, 22 Jun 2024 at 09:02, Bruce Schuck wrote: > > On 6/22/24 07:31:44 +1000, David H wrote: > > > It seems Alphavantage have been limiting queries to 25 per day for > > the last coupl

Re: [GNC] Finance Quote - Alphavantage Error - Subscribe to Premium

2024-06-21 Thread Bruce Schuck
On 6/22/24 07:31:44 +1000, David H wrote: It seems Alphavantage have been limiting queries to 25 per day for the last couple of days? Days?! It's been more than a few weeks, if not months. I mentioned this some time ago. As a matter of fact, the throttling mechanism in the AlphaVa

[GNC] Finance Quote - Alphavantage Error - Subscribe to Premium

2024-06-21 Thread David H
It seems Alphavantage have been limiting queries to 25 per day for the last couple of days ? Cheers David H. [image: Aj8nj6XteJ.png] ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe

Re: [GNC] AlphaVantage now restricting users to 25 quotes

2023-11-01 Thread Bruce Schuck
about adding such a feature as there is a risk of corrupting users' data files if not careful. Just my $0.02. I did try using Alphvantage for 25 prices and Yahoo for the remaining ones but that ended up with the prices from Alphavantage being 100 times too high - I was very rich for a while!

Re: [GNC] AlphaVantage now restricting users to 25 quotes

2023-11-01 Thread Adrian Holbrook
than do them all individually. I did try using Alphvantage for 25 prices and Yahoo for the remaining ones but that ended up with the prices from Alphavantage being 100 times too high - I was very rich for a while! I suspect that one uses pence and the pther pounds (or cents and dollars) and Gn

Re: [GNC] AlphaVantage now restricting users to 25 quotes

2023-10-30 Thread Mike Alexander
On 27 Oct 2023, at 3:47, Adrian Holbrook wrote: I have been using Alphavantage for my stock quotes for some time now using F:Q. IRecently it stopped working for me - the last valid quotes I have are dated October 20th 2023. I now get a message that they are restricting quotes to 25 per user

[GNC] AlphaVantage now restricting users to 25 quotes

2023-10-27 Thread Adrian Holbrook
I have been using Alphavantage for my stock quotes for some time now using F:Q. IRecently it stopped working for me - the last valid quotes I have are dated October 20th 2023. I now get a message that they are restricting quotes to 25 per user per day. I currently import around 50 at a time but

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-22 Thread Kaligula
ndled. I'm not going to waste any more time beyond writing this email on this issue. My original question in this thread was asking how many of the users (at least GnuCash users on the email list) used AlphaVantage for non-US traded securities. *No one* responded answering that question, b

Re: [GNC] Finance::Quote - AlphaVantage Trade

2023-07-22 Thread Bruce Schuck
question in this thread was asking how many of the users (at least GnuCash users on the email list) used AlphaVantage for non-US traded securities. *No one* responded answering that question, but John and I had a decent little discussion of the matter. For a real solution, I would urge anybody

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-21 Thread Kaligula
Hi, (Sorry being late here, I'm not watching gnucash-user mailing list). In general the suffix idea looks like a nice workaround – but I'd like to throw in my two cents. 1) There are securities like these ETFs: MVOL.L or ISLN.L – they are traded in USD. 2) If the suffix idea get implemente

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-19 Thread Bruce Schuck
n to say "Hey! I get some LSE traded stock data from AlphaVantage, and doubling the time it takes to get quotes would annoy the heck out of me!". At this point, the only one to raise an issue is someone that could deal with it as is for all I care. To clarify, are you suggesting have Alp

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-18 Thread John Ralls
that are priced in GBX. But you're right >> that it's not something that a user can do now because GBX isn't an >> ISO4217 currency and that's historically how we decide what's a >> currency. Implementing it would require making an exception to that >>

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-18 Thread Bruce Schuck
cause GBX isn't an ISO4217 currency and that's historically how we decide what's a currency. Implementing it would require making an exception to that policy and adding an entry to our currency file. Probably why AlphaVantage and YahooJSON convert GBX quotes to GBP. I started to ge

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread john
gt;> going completely off of looking at the code in the three modules. > > No big deal. I did some searching, and I don't think AlphaVantage has data > for securities traded on the Johannesburg Stock Exchange. If someone else > reading this can supply an example, please post it

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread John Ralls
> On Jul 17, 2023, at 11:11 AM, Bruce Schuck wrote: > > On 7/17/23 10:02 AM, john wrote: > >> It's not all non-US securities. In AlphaVantage it appears to be only >> LSE stocks; JSE stocks aren't supported and Tel Aviv stocks support >> only ILS. The

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread Bruce Schuck
On 7/17/23 10:02 AM, john wrote: It's not all non-US securities. In AlphaVantage it appears to be only LSE stocks; JSE stocks aren't supported and Tel Aviv stocks support only ILS. The Yahoo JSON module adjusts prices for Zac (South Africa) and ILA (Israel) as well as GBX, but

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread john
e was raised about prices from AlphaVantage for > LSE traded stocks (see > https://github.com/finance-quote/finance-quote/issues/281). While there is an > issue, the user's perceived solution was not the answer. Apparently my > attempt to explain that the root cause was that the data retu

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread Bruce Schuck
n of the AlphaVantage API for those using their free API key. "We are pleased to provide free stock API service covering the majority of our datasets for up to 5 API requests per minute and 500 requests per day. If you would like to target a larger API call volume, please visit premi

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread Brad Morrison
xt ### Anyway, some time ago the issue was raised about prices from AlphaVantage for LSE traded stocks (see https://github.com/finance-quote/finance-quote/issues/281). While there is an issue, the user's perceived solution was not the answer. Apparently my attempt to explain that the roo

[GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-16 Thread Bruce Schuck
Hello again, At some point I am going to take a break from F::Q, I thought this weekend I was going to escape. ### For the question, skip to the next ### Anyway, some time ago the issue was raised about prices from AlphaVantage for LSE traded stocks (see https://github.com/finance-quote

Re: [GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API

2022-11-08 Thread Bruce Schuck
Bruce S wrote: >> Go figure. It appears that AlphaVantage >> changed back access to the CURRENCY_EXCHANGE_RATE API. It is no >> longer considered premium. A feature I liked about the >> CURRENCY_EXCHANGE_RATE API over the FX_DAILY API is that the former >> dat

Re: [GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API

2022-11-08 Thread Murugan Muruganandam
hi Bruce thanks, is it possible to keep both the methods with an option to select the preferred . just to be safe in case of any future change from AlphaVantage Saludos Cordiales Murugan From: gnucash-user on behalf of Bruce Schuck Sent: Tuesday

[GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API

2022-11-08 Thread Bruce Schuck
Go figure. It appears that AlphaVantage changed back access to the CURRENCY_EXCHANGE_RATE API. It is no longer considered premium. A feature I liked about the CURRENCY_EXCHANGE_RATE API over the FX_DAILY API is that the former data included Crypto and Precious Metals. Will revert back F::Q in

Re: [GNC] Install Alphavantage Key

2021-11-26 Thread Peter Williamson
Hi everyone Thanks for your assistance with setting up stock quotes. I have now got stock prices downloaded for stocks listed on both the AU & NZ stock exchanges. The method used is that described by Geoff. For NZ share prices I used the NZ stock exchange as the single source provider. Regard

Re: [GNC] Install Alphavantage Key

2021-11-25 Thread Eric Coates via gnucash-user
rce options, I have found that a single source of Yahoo as JSON successfully retrieves quotes for London, Paris, Frankfurt and Madrid and quite quick with it, you may find it works for your shares as well. Note that (from my understanding) you'll still need the AlphaVantage key to get

[GNC] Install Alphavantage Key

2021-11-25 Thread Peter Williamson
Hi I have installed and finance quote for Windows and on checking Gnucash Help, About I get Finance::Quote 1.51. I now have a Source Advantage US key. Please can someone tell me how to install this key to allow download of share prices from the Australian and New Zealand stock exchanges. Peter

Re: [GNC] How to update Finance::Quote, F::Q 1.49 still limited to 5 AlphaVantage quotes?

2019-07-11 Thread rsbrux via gnucash-user
.6.19. I had previously limited currency price quote to 5 currencies because of the known problem with AlphaVantage. Perhaps I have misunderstood, but I was expecting the new version to avoid this limitation. Instead, adding more currencies to quote results in the well-known error message: Unable

[GNC] AlphaVantage

2019-01-07 Thread Les
Over the weekend, I upgraded Linux Mint from 18.2 to 19.1.  With the upgrade, GC upgraded from 2.6.17 to 2.6.21. After updating prices, I no longer was obtaining any quotes for currencies.  If I remember correctly, currencies are being served by AlphaVantage.  I guess that the configuration

Re: [GNC] PriceQuotes and AlphaVantage assistance request

2018-10-05 Thread nvsoar
here is the link: https://lists.gnucash.org/pipermail/gnucash-user/2018-September/079698.html but the workaround posted on Sep 08 by Ameet Sengar, where he provides instructions to delay the requests to Alphavantage, works very well and I am now consistently getting 100% of my 50 plus quotes

Re: [GNC] PriceQuotes and AlphaVantage assistance request

2018-10-05 Thread Frank H. Ellenberger
org/pipermail/gnucash-user/2018-September/079698.html > but the workaround posted on > Sep 08 by Ameet Sengar, where he provides instructions to delay the requests > to Alphavantage, works very well and I am now consistently getting 100% of > my 50 plus quotes. Hopefully this link work

Re: [GNC] PriceQuotes and AlphaVantage assistance request

2018-10-04 Thread Megagrumpy
I do not know how to link to a previous message but the workaround posted on Sep 08 by Ameet Sengar, where he provides instructions to delay the requests to Alphavantage, works very well and I am now consistently getting 100% of my 50 plus quotes. Hopefully this link works - http://gnucash

Re: [GNC] PriceQuotes and AlphaVantage assistance request

2018-10-04 Thread David Carlson
nvsoar, You could look at getting some of your prices via yahoo_json instead of Alphavantage. It is near the bottom of the Single Quote source list in the security editor. That works for me with US stocks. David C On Thu, Oct 4, 2018 at 3:56 PM John Ralls wrote: > > > > On 4 Oct

Re: [GNC] PriceQuotes and AlphaVantage assistance request

2018-10-04 Thread John Ralls
> On 4 Oct 2018, at 13:23, nvsoar wrote: > > Win 10, Strawberry 5.28, Cpan 1.47; GnuCash 3.3 and 2.6.21 on separate > machines. > Please advise what needs to be accomplished so that AlphaVantage can return > more that 4 out of the 20 quotes requested. Until Erik Col

[GNC] PriceQuotes and AlphaVantage assistance request

2018-10-04 Thread nvsoar
Win 10, Strawberry 5.28, Cpan 1.47; GnuCash 3.3 and 2.6.21 on separate machines. Please advise what needs to be accomplished so that AlphaVantage can return more that 4 out of the 20 quotes requested. Thank your for your assistance, nvsoar

Re: [GNC] AlphaVantage Deal

2018-08-27 Thread Richard Ullger
On 27/08/2018 15:23, Ott Kekishev wrote: > Hello Richard,  > > What version of GC are you using? I have been trying to get yahooJSON > working in GC, but had no luck so far. I am using version 3.2. F::Q > works for yahooJSON, but inside GC it does not fetch. Do you know what > files are connected

Re: [GNC] AlphaVantage Deal

2018-08-27 Thread Ott Kekishev
On Mon, 27 Aug 2018 at 14:10, Richard Ullger wrote: > On 27/08/2018 04:34, Ethan Swint wrote: > > Hmm... not a lot of response from the user on this topic. I'll bubble it > to > > the top this time and let it go from there. > > > > The main theme was that the A

Re: [GNC] AlphaVantage Deal

2018-08-27 Thread Richard Ullger
On 27/08/2018 04:34, Ethan Swint wrote: > Hmm... not a lot of response from the user on this topic. I'll bubble it to > the top this time and let it go from there. > > The main theme was that the AlphaVantage team is open to a lower-priced > premium option that would give 120

Re: [GNC] AlphaVantage Deal

2018-08-26 Thread Ethan Swint
Hmm... not a lot of response from the user on this topic. I'll bubble it to the top this time and let it go from there. The main theme was that the AlphaVantage team is open to a lower-priced premium option that would give 120 quotes/minute for up to 128 quotes/day, then revert back down to

Re: [GNC] AlphaVantage Deal

2018-08-23 Thread Bruce Schuck
In my opinion, at $5.00 or more per month one might as well purchase Quicken (which is now a subscription based product I believe). For the F::Q developers, I've been working on module for World Trading Data. Free use is limited to 250 per day, and it's only US traded equities and funds. See pull

Re: [GNC] AlphaVantage deal

2018-08-23 Thread David G Hamblen
n Thu, 23 Aug 2018 at 12:22, floppy5.25 wrote: On Thursday, August 23, 2018 10:51:32 AM -05 Ethan Swint wrote: I recently inquired with AlphaVantage about providing something between their free 1 quote/20 seconds and their $20/month offering of 1 request / 4 seconds with premium support. I thi

Re: [GNC] AlphaVantage deal

2018-08-23 Thread Alun Champion
lues but the first one to get the current quote. -A. On Thu, 23 Aug 2018 at 12:22, floppy5.25 wrote: > On Thursday, August 23, 2018 10:51:32 AM -05 Ethan Swint wrote: > > I recently inquired with AlphaVantage about providing something between > > their free 1 quote/20 seco

Re: [GNC] AlphaVantage deal

2018-08-23 Thread floppy5.25
On Thursday, August 23, 2018 10:51:32 AM -05 Ethan Swint wrote: > I recently inquired with AlphaVantage about providing something between > their free 1 quote/20 seconds and their $20/month offering of 1 request / 4 > seconds with premium support. > > I think most users here are on

[GNC] AlphaVantage deal

2018-08-23 Thread Ethan Swint
I recently inquired with AlphaVantage about providing something between their free 1 quote/20 seconds and their $20/month offering of 1 request / 4 seconds with premium support. I think most users here are on the once-a-day sync between GnuCash and the markets, so I proposed a tier that would

Re: [GNC] Finance::Quote still not working with alphavantage

2018-07-23 Thread Samantha Payn
you all the way, but you'll need to get us to a start point - which OS platform and version of GC are you using? Have you registered with Alphavantage and got your ID number? (Also called "API Key" - but keep it secret! no one needs to know it, but we do ne

Re: [GNC] Finance::Quote still not working with alphavantage

2018-07-23 Thread Maf. King
t - which OS platform and version of GC are you using? Have you registered with Alphavantage and got your ID number? (Also called "API Key" - but keep it secret! no one needs to know it, but we do need to know that it exists!) just a start, someone else may be able to

[GNC] Finance::Quote still not working with alphavantage

2018-07-23 Thread Samantha Payn
Hello all! I see the thread about online currency quotes not working in the mailing list archive and the helpful replies. However I am not a coder/programmer so am unable to fathom what I, a mere mortal, should be doing to re-enable the online currency fetch feature. Can anyone

Re: [GNC] Finance::Quote still not working with alphavantage

2018-07-17 Thread brad
Carlson wrote: Greg, Just so you don't feel like you are alone, I have GnuCash running on for different machines one Windows and three are assorted versions of Uubuntu and Debian. Only one of them (one of the Ubuntu machines) will retrieve quotes successfully through AlphaVantage, and that is ab

[GNC] alphavantage quotes doesn't work

2018-07-13 Thread Nicolas Haller
Hello, I'm trying to fix my automatic quotes import in GnuCash. I switched all my securities to get quotes with alphavantage. I put my key in Preferences->Online Quotes and as an env variable (ALPHAVANTAGE_API_KEY). When I push the "Get Quotes" button, gnucash processes th

Re: [GNC] Alphavantage quote displaying wrong currency and value

2018-07-10 Thread Liz
On Mon, 9 Jul 2018 11:13:19 +0800 Mark Blakeney wrote: > Sorry Fred but that is irrelevant. Of course in general, > Finance::Quote can fetch time+price pairs but that should irrelevant > to GnuCash users. GnuCash only needs and wants the very latest price > at the time the query is done so there

Re: [GNC] Alphavantage quote displaying wrong currency and value

2018-07-08 Thread Mark Blakeney
On 07/09/2018 03:26 AM, Fred Bone wrote: > Your timezone determines when midnight (and hence a new day) occurs > relative to UTC. This may be different from the corresponding offset of a > given quote-source. And you are not "required" to tell Gnucash what > timezone your quote-source uses: there

Re: [GNC] Alphavantage quote displaying wrong currency and value

2018-07-08 Thread Fred Bone
On 08 July 2018 at 9:51, Mark Blakeney said: [...] > Then I eventually discovered the Type/Namespace > field serves no purpose whatever and can be configured to whatever you > want to make up! That field should be removed. The obvious purpose is to let the user group securities by type. If you h

Re: [GNC] Alphavantage quote displaying wrong currency and value

2018-07-08 Thread Chris Good
From: Mark Blakeney Sent: Sunday, 8 July 2018 9:52 AM To: goodchri...@gmail.com Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Alphavantage quote displaying wrong currency and value Chris, Yes thanks. I actually discovered that myself later on. Obviously it was picking up some other US

Re: [GNC] Alphavantage quote displaying wrong currency and value

2018-07-07 Thread Mark Blakeney
: Sat, 7 Jul 2018 10:59:33 +1000 > > From: Mark Blakeney > > To: gnucash-user@gnucash.org > > Subject: [GNC] Alphavantage quote displaying wrong currency and value > > Message-ID: > >> ail.gmail.com> > > Content-Type: text/plain; charset="UTF-8

Re: [GNC] Alphavantage quote displaying wrong currency and value

2018-07-07 Thread Chris Good
> Message: 5 > Date: Sat, 7 Jul 2018 10:59:33 +1000 > From: Mark Blakeney > To: gnucash-user@gnucash.org > Subject: [GNC] Alphavantage quote displaying wrong currency and value > Message-ID: >ail.gmail.com> > Content-Type: text/plain; charset="UTF-8"

[GNC] Alphavantage quote displaying wrong currency and value

2018-07-06 Thread Mark Blakeney
Hi, I'm new to gnucash and trying to set up online quotes via Alphavantage. I am using Arch Linux with stock versions gnucash 3.2-1 and perl-finance-quote 1.47-1. I have my API key configured etc and gnc-fq-dump works correctly as seen at https://imgur.com/a/swf5xto. I have the stock confi

Re: [GNC] Finance::Quote still not working with alphavantage

2018-07-05 Thread David Carlson
Greg, Just so you don't feel like you are alone, I have GnuCash running on for different machines one Windows and three are assorted versions of Uubuntu and Debian. Only one of them (one of the Ubuntu machines) will retrieve quotes successfully through AlphaVantage, and that is about 1/3 t

Re: [GNC] Finance::Quote still not working with alphavantage

2018-07-05 Thread Greg Etling
Reviving this thread - I decided to follow others' recommendation of installing perlbrew, and F::Q is working from the CLI. However, I'm not seeing any change in the Gnucash behavior (v2.6.21, key in the preferences pane, retrieval failing), so I think I'm missing a step on having Gnucash actually

Re: [GNC] Alphavantage Problem

2018-06-23 Thread David Samsury
. Dave S. Sent from Mail for Windows 10 From: Chris Good Sent: Saturday, June 23, 2018 2:56 AM To: gnucash-user@gnucash.org Cc: samsu...@comcast.net Subject: RE: [GNC] Alphavantage Problem > Message: 1 > Date: Sat, 16 Jun 2018 10:33:40 -0700 (MST) > From: samsurd2 > To: gnucash-user

Re: [GNC] Alphavantage Problem

2018-06-23 Thread Chris Good
> Message: 1 > Date: Sat, 16 Jun 2018 10:33:40 -0700 (MST) > From: samsurd2 > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Alphavantage Problem > Message-ID: <1529170420529-0.p...@n4.nabble.com> > Content-Type: text/plain; charset=us-ascii > > I'm run

[GNC] AlphaVantage Quotes

2018-06-19 Thread Bruce Schuck
I believe I'm not the only one experiencing occasional issues getting quotes from AlphaVantage. While poking around I found a similar source, World Trading Data at https://www.worldtradingdata.com/. They use an API Key similar to AlphaVantage, along with a REST based API. While researching

Re: [GNC] Alphavantage Problem

2018-06-16 Thread Les
16th of every month since the switch from Yahoo to AlphaVantage, I've had only limited success getting quotes using Finance-Quote. Admittedly, I have a long list of equities that I track but usually I get them all on the first try. Occasionally, a second pass is required to get one or tw

Re: [GNC] Alphavantage Problem

2018-06-16 Thread samsurd2
I'm running GC 2.6.16 with Finance-Quote 1.47 on Windows 8.1 and Windows 10 machines. I don't have an explanation but I do have an observation. I've noticed that around the 15th or 16th of every month since the switch from Yahoo to AlphaVantage, I've had only limited success

Re: [GNC] Alphavantage Problem

2018-06-16 Thread Les
As of now, I am still unable to download prices. :-(  I have verified that nothing has changed with regard to my setup.  Still using Linux Mint 18.2, GC 2.6.21, AlphaVantage key is still residing in /etc/gnucash/environment.  I can obtain limited quotes using the terminal, but many of the

Re: [GNC] Alphavantage Problem

2018-06-15 Thread Bruce Schuck
> Date: Fri, 15 Jun 2018 16:06:46 -0500 > From: Les > For several months, I have been downloading stock and currency prices > using AlphaVantage.? For the last 2 days, I have not been able to > download any prices.? Is anyone else having this problem? I've noticed the

[GNC] Alphavantage Problem

2018-06-15 Thread Les
For several months, I have been downloading stock and currency prices using AlphaVantage.  For the last 2 days, I have not been able to download any prices.  Is anyone else having this problem? Suggestions? Thanks, Les ___ gnucash-user mailing

Re: [GNC] AlphaVantage Stock Quotes

2018-06-02 Thread John Ralls
at 10:21, John Ralls <mailto:jra...@ceridwen.us>> wrote: > It’s only live when that particular issue is trading; e.g. for a US stock > between 0930 and 1600 Eastern Time. That makes it unsuitable for F::Q. > > Regards, > John Ralls > > > > On Jun 2, 2018, at 6:12

Re: [GNC] AlphaVantage Stock Quotes

2018-06-02 Thread Alun Champion
tern Time. That makes it unsuitable for F::Q. > > Regards, > John Ralls > > > > On Jun 2, 2018, at 6:12 AM, Alun Champion wrote: > > > > Alphavantage does provide a batch stock api, which you only sends the > > latest quote, you can send just one stock to that

Re: [GNC] AlphaVantage Stock Quotes

2018-06-02 Thread John Ralls
It’s only live when that particular issue is trading; e.g. for a US stock between 0930 and 1600 Eastern Time. That makes it unsuitable for F::Q. Regards, John Ralls > On Jun 2, 2018, at 6:12 AM, Alun Champion wrote: > > Alphavantage does provide a batch stock api, which you only

Re: [GNC] AlphaVantage Stock Quotes

2018-06-02 Thread Alun Champion
Alphavantage does provide a batch stock api, which you only sends the latest quote, you can send just one stock to that api call e.g. ( https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES&symbols=MSFT&apikey=), which only returns the latest value. -A. On 31 May 2018 at 20

Re: [GNC] AlphaVantage Stock Quotes

2018-05-31 Thread prl
but as far as I can see, the compact list (last 100 days) is the smallest amount of data that can be requested using the TIME_SERIES_DAILY function in the AlphaVantage API <https://www.alphavantage.co/documentation/>. The only alternative in the documentation is full, which returns daily op

[GNC] AlphaVantage Stock Quotes

2018-05-31 Thread Dave Tapuska
ou add the connection time in here and increase the number of stocks then you just hit a timeout that gnucash is leaving for the requests and it seems it just generally fails all the time. Anyone can validate what I am seeing? Should I move to another data source? Does Alphavantage have any feedback?

RE: FW: alphavantage quotes fix

2018-04-01 Thread Chris Good
@gnucash.org Subject: Re: FW: alphavantage quotes fix Hi Chris, Applied your patches and AlphaVantage worked. For now at least. If I have future issues, may I contact you? <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_

Re: FW: alphavantage quotes fix

2018-04-01 Thread Steven Anter
Hi Chris, Applied your patches and AlphaVantage worked. For now at least. If I have future issues, may I contact you? <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> Virus-free. www.avast.com <

Re: Alphavantage

2018-03-03 Thread Wm
On 02/03/2018 23:54, Les wrote: I have tried for several days to update stocks, currencies, etc. The last update I received for currencies was 02/13/2018 and the last update for stocks was 02/23/2018. I have an Alphavantage API key and it was added to the end of my environment file. I am on

Alphavantage

2018-03-02 Thread Les
I have tried for several days to update stocks, currencies, etc. The last update I received for currencies was 02/13/2018 and the last update for stocks was 02/23/2018. I have an Alphavantage API key and it was added to the end of my environment file. I am on LInux Mint 18.2 and GC 2.7.17

Finance::Quote - ASX problems (alphavantage and ASX sources)

2018-02-08 Thread ln . mailinglists
ese (if any) will be supported in the long term. I'm keeping an eye on this page and when things stabilise, I'll see if I can figure what needs to be changed in ASX.pm. Even then, it may take a while, as it has been more than a decade since I last @$!%// with perl. 2) Alphavantage is kind-

Re: Alphavantage

2018-01-01 Thread Dave H
Check out https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F for instructions Any further questions it would be helpful to quote your OS and gnucash version. Cheers Dave H On 2 January 2018 at 14:42, Gerald Ellis wrote: > I receive an error message "Alphavan

Alphavantage

2018-01-01 Thread Gerald Ellis
I receive an error message "Alphavantage API Key not set". I have retrieved the Free API Key but am not sure how to Set It. Any help? Jerry ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gn

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
VANTAGE_API_KEY=##' first. Then it appears 'perl > gnc-fq-dump -v alphavantage AMZN' works returning this: > "Finance::Quote fields Gnucash uses: > symbol: AMZN <=== required > date: 12/29/2017 <=== recommended &g

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread David Carlson
eded to be in /usr/bin and run 'export ALPHAVANTAGE_API_KEY=##' first. Then it appears 'perl gnc-fq-dump -v alphavantage AMZN' works returning this: "Finance::Quote fields Gnucash uses: symbol: AMZN <=== required date: 12/29/2017

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Ok I think I solved it reading about CPAN on the wiki https://wiki.gnucash.org/wiki/CPAN If I understand it right running 'cpan -D Finance::Quote' reported my CPAN being out of date. So I ran 'sudo cpan' and then 'upgrade' to upgrade it (does that upgrade perl too?).

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Ok took me awhile to realize I needed to be in /usr/bin and run 'export ALPHAVANTAGE_API_KEY=##' first. Then it appears 'perl gnc-fq-dump -v alphavantage AMZN' works returning this: "Finance::Quote fields Gnucash uses: symbol: AMZN <==

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Fross, Michael
​Hi Elias, Take GNUCash out of the equation. If you run : perl gnc-fq-dump -v alphavantage AMZN That should tell you if F:Q can get to alphavantage. I'm not sure if that will be in your path so you might have to find gnc-fq-dump. If that works or not it will help to narrow it down. Mi

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Ah so it is. When I set it to "Yahoo as json" and get quotes it says unable to retrieve quotes. Definitely no Alphavantage source. Version 1.47 is the newest version of Finance:Quote. I've tried to update it separately per the wiki and it says I have the newest version. On Mon, J

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread David Carlson
e this doesn't answer your question, I switched to Alphavantage > > without issue, but then switched to yahoo_json as it's much faster. I > > assume it will go away at some point and I'll have to switch back to > > Alphavantage. > > > > I'm currently

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
January 1, 2018 1:45:51 PM Elias K Gardner wrote: > > > Thanks Michael, yahoo_json does not show up in my unknown sources > either. I > > wonder if that is related to my problem. > > > > On Mon, Jan 1, 2018 at 1:17 PM Fross, Michael wrote: > > > >>

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Derek Atkins
, 2018 at 1:17 PM Fross, Michael wrote: While this doesn't answer your question, I switched to Alphavantage without issue, but then switched to yahoo_json as it's much faster. I assume it will go away at some point and I'll have to switch back to Alphavantage. I'm currentl

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Thanks Michael, yahoo_json does not show up in my unknown sources either. I wonder if that is related to my problem. On Mon, Jan 1, 2018 at 1:17 PM Fross, Michael wrote: > While this doesn't answer your question, I switched to Alphavantage > without issue, but then switched to ya

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Fross, Michael
While this doesn't answer your question, I switched to Alphavantage without issue, but then switched to yahoo_json as it's much faster. I assume it will go away at some point and I'll have to switch back to Alphavantage. I'm currently running on Windows and it's availa

Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Hey there. I've followed the directions on the wiki for switching my online quotes from Yahoo! to Alphavantage but in the security editor alphavantage does not show up under unknown sources. What have I done wrong? I got an Alphavantage API key and I added ALPHAVANTAGE_AP

Re: Alphavantage Not Showing Up In List Sources

2017-12-14 Thread all_else_failed
I was having the same problem, here's what I did to get alphavantage to show up in the source list: Uncheck "Get Online Quotes" for all of the securities, then restart GnuCash. Go back to the Security Editor and alphavantage should now show up. Hopefully it works for everyone havi

Re: Mutual funds quote not working after moving to alphavantage

2017-12-12 Thread Richard Ullger
On 09/12/17 19:38, Andrea Beddoni wrote: > I had already tried to use the Morningstar GB option (I have also tested > the other options listed, i.e. Trustnet) from the security editor but it > hadn't worked. Not sure why and how to fix it. I tested quote retrieval for your fund GB00B4PQW151. While

Re: Mutual funds quote not working after moving to alphavantage

2017-12-09 Thread Andrea Beddoni
Thanks Richard, I had already tried to use the Morningstar GB option (I have also tested the other options listed, i.e. Trustnet) from the security editor but it hadn't worked. Not sure why and how to fix it. I wonder if it has anything to do with date. In my price editor I have dd/mm/ while u

Re: Mutual funds quote not working after moving to alphavantage

2017-12-09 Thread Richard Ullger
On 09/12/17 18:23, Andrea Beddoni wrote: > Thanks for the suggestion. Two questions: > 1. How can I set mstaruk as a source in gnucash security editor? It > works if I run gnc-fq-dump mstaruk but I don't have it as a possible > source in gnucash You can find it in the 'Single' dropdown list of the

Re: Mutual funds quote not working after moving to alphavantage

2017-12-09 Thread Andrea Beddoni
s for your help On 9 December 2017 at 18:05, Richard Ullger wrote: > On 09/12/17 17:09, Andrea Beddoni wrote: > > I have just switched to alphavantage on Gnucash 2.6.12 (Ubuntu 16.04) > > The quotes for ETFs are retrieved (i.e. IGLS) even if with a value 1/100 > of > > the ac

Re: Mutual funds quote not working after moving to alphavantage

2017-12-09 Thread Richard Ullger
On 09/12/17 17:09, Andrea Beddoni wrote: > I have just switched to alphavantage on Gnucash 2.6.12 (Ubuntu 16.04) > The quotes for ETFs are retrieved (i.e. IGLS) even if with a value 1/100 of > the actual (i.e 1.32 instead of 132), however the quotes for mutual funds > (i.e. GB00B4PQW

Mutual funds quote not working after moving to alphavantage

2017-12-09 Thread Andrea Beddoni
I have just switched to alphavantage on Gnucash 2.6.12 (Ubuntu 16.04) The quotes for ETFs are retrieved (i.e. IGLS) even if with a value 1/100 of the actual (i.e 1.32 instead of 132), however the quotes for mutual funds (i.e. GB00B4PQW151) are not retrieved. When trying to get the online quotes I

Re: Alphavantage Not Showing Up In List Sources

2017-12-04 Thread yf
thks your reply. When I type "gnc-fq-check" in terminal, it include alphavantage, and I can got the quote when type "gnc-fq-dump", but can't find alphavantage in the qoute source of gnucash. It seems I'm not the only one with this problem. somebody can help us?

Re: Alphavantage Not Showing Up In List Sources

2017-12-04 Thread Dale Alspach
GnuCash to use a different language, uncomment the two parameters # below and set LANG to your preferred locale # LANG=nl_BE # LANGUAGE={LANG} ALPHAVANTAGE_API_KEY=X gnc-fq-check ("1.45" "adig" "aex" "aiahk" "alphavantage" "am

  1   2   >