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

2023-11-01 Thread Bruce Schuck
On 11/1/23 10:43 AM, Adrian Holbrook wrote: Thanks for that - I changed all mine to Yahoo as JSON and it works, as you say, for now. Wasn't long ago that I chenged them all from Yahhoo to Alphvantage! Bit of a chore with over 50 to do. Would be a very useful feature to be able to switch en

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

2023-11-01 Thread Adrian Holbrook
can only use one conversion. Would be interested to understand this a bit more. From: Mike Alexander Sent: 31 October 2023 06:19 To: Adrian Holbrook Cc: gnucash-user@gnucash.org Subject: Re: [GNC] AlphaVantage now restricting users to 25 quotes On 27 Oct 2023

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

2023-10-31 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] 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 >> data included Crypto and Precious

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

2022-11-08 Thread Murugan Muruganandam
, November 8, 2022 8:12 PM To: gnucash-user@gnucash.org Subject: [GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API 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

[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

[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] 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
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 in GC to this yahooJSON fetching? Best regards, Ott

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 quotes/minute for up

Re: [GNC] AlphaVantage Deal

2018-08-26 Thread Ethan Swint
Bruce's implementation and kick the tires on it - that could be the solution that works for me. Regards, Ethan Date: Thu, 23 Aug 2018 14:00:44 -0700 From: Bruce Schuck To: gnucash-user@gnucash.org Subject: Re: [GNC] AlphaVantage Deal Message-ID: <1667719d-52b6-b423-ec4d-8f72c5955...@asg

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
It's apparently only for US securities, which might be ok for a subset of users.  There is an alphavantage_batch.pm out there. https://github.com/finance-quote/finance-quote/issues/77 On 08/23/2018 04:22 PM, Alun Champion wrote: Any reason not to move to the batch API (`

Re: [GNC] AlphaVantage deal

2018-08-23 Thread Alun Champion
Any reason not to move to the batch API (` https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT,AXP,...=XXX`) then you could get all the current quotes with a single call. It seems inefficient to get the stock history one stock at a time to discard all the values but the first one to

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 the once-a-day

[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

[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 things and gives me

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

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&q

[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 configured

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 running

[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 their

Re: [GNC] Alphavantage Problem

2018-06-16 Thread Les
Thanks for the information. Although I haven't documented failures as you have, I have experience times when obtaining quotes was near impossible.  I just tried again with the same results (no quotes). It usually takes me several attempts before I can obtain all my quotes.  (I have stocks

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 getting quotes using

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 same thing on my Mac

[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
From https://www.alphavantage.co/documentation/ : "The batch stock quotes API enables the querying of multiple stock quotes with a single API request, updated realtime. It may serve as a lightweight alternative to our core stock time series APIs

Re: [GNC] AlphaVantage Stock Quotes

2018-06-02 Thread Alun Champion
Hmm, that has not been my observation but I'm sure there are some nuances, for me it shows the last price during the trading day (as in it doesn't show after market prices) but the call can happen any time, e.g. here is the demo linl:

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 sends the >

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=MSFT=), which only returns the latest value. -A. On 31 May 2018 at 20:12, prl wrote: > On

Re: [GNC] AlphaVantage Stock Quotes

2018-05-31 Thread prl
On 31/05/2018 12:59, Dave Tapuska wrote: >From the gnucash point of view it only uses the latest quote so even returning the compact list (which is the last 100 days) is far overkill. Perhaps a lighter weight request returning the last closing value would be sufficient. That would be ideal, but

[GNC] AlphaVantage Stock Quotes

2018-05-31 Thread Dave Tapuska
So I've constantly run into issues getting quotes for stocks I have listed. Sometimes it loads some of them, and it seems completely random. I'm using 3.0-118-gd2ef5fd0f+ (2018-04-28) with Finance Quote 1.47. I had a closer look at why the individual requests were taking so long. (Upwards of 1s