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

[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 masse from one provider
to another rather than do them all individually.


I crafted some commands using XMLStarlet to manipulate quote sources en 
masse. Those using an SQL backend that are familiar with SQL queries can 
probably do the same. I can see why the GnuCash developers may be 
cautious 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! I suspect
that one uses pence and the pther pounds (or cents and dollars) and
Gnucash can only use one conversion. Would be interested to
understand this a bit more.


There was a discussion on this some time back, it may have been on a 
Finance::Quote Github issue or pull request and not here. As you 
noticed, some LSE traded securities are priced in pounds, and others in 
pence. There are few others that are similar. The JSON returned when 
fetching data from AlphaVantage does not include an indicator for which 
currency is used. It *can* be looked up from AV using another API, and 
hence another hit on your API's daily counter. The workaround if one did 
not want to use another quote source is to add an additional ".X" the 
symbol used for the security. For example GBP.L data from AV is in Great 
Britain Pence. But if you set the symbol to GBP.L.X 
Finance::Quote::AlphaVantage will convert the close, high, low, open 
pricing to pounds.


There has been some work in the last year to fix or add a few quote 
sources. Fool, GoogleWeb, MarketWatch, YahooWeb, and YahooJSON were 
successfully tested when they were last updated within the last year.


Bruce S.
___
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] AlphaVantage now restricting users to 25 quotes

[Adrian Holbrook]

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 masse from one provider to another rather 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 Gnucash 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, 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 per day. I currently import around
> 50 at a time but only around once per month and to do this I now need
> a Premium key which would cost $25 per month. Has anyone found a way
> around this? Is there a way to update in batches as opposed to all at
> once? Is there another provider?

I use yahooweb which works again (for the moment) in F::Q version 1.58.
It will probably break again but it still works now.

Mike
___
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] AlphaVantage now restricting users to 25 quotes

[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 per day. I currently import around 
50 at a time but only around once per month and to do this I now need 
a Premium key which would cost $25 per month. Has anyone found a way 
around this? Is there a way to update in batches as opposed to all at 
once? Is there another provider?


I use yahooweb which works again (for the moment) in F::Q version 1.58.  
It will probably break again but it still works now.


Mike
___
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] AlphaVantage now restricting users to 25 quotes

[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 only around once 
per month and to do this I now need a Premium key which would cost $25 per 
month. Has anyone found a way around this? Is there a way to update in batches 
as opposed to all at once? Is there another provider?
___
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] Finance::Quote - AlphaVantage Trade Currencies

[Kaligula]

Please, calm down, Bruce :) That was just an idea.

If I knew Perl as much as I know JavaScript I'd submit a PR yesterday. 
(I know, I made a few modules for private use, they're on my GitHub – 
but it involved much much much more learning than actual writing, and it 
was long ago).


Nevermind. Have a nice day :)

Best regards,
Kaligula

W dniu 22.07.2023 o 19:53, Bruce Schuck pisze:

On 07/21/2023 at 18:34 EDT Kaligula wrote:

In general the suffix idea looks like a nice workaround – but I'd 
like to throw in my two cents.


So maybe a general solution in case of AV module pricing errors – a 
".???" suffix (to any ticker, not only LSE ones) where the "???" is 
the currency that the security is traded in? (Or even better with a 
":???" suffix, to avoid confusion with stock exchange suffixes). This

would allow the user to inform the AV module about changes in
default currency – e.g. "GBP.L:GPX" or "MVOL.L:USD".

Kaligula,

Please don't disturb the horse. It's well beyond deceased and we're 
not trying to make glue. At least I am not. I've made my decision on 
how it's going to be handled. 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, 
but John and I had a decent little discussion of the matter.


For a real solution, I would urge anybody using AlphaVantage for quote 
data to contact AV's support and request that the trade currency be 
added to the JSON returned from the GLOBAL_QUOTE API.


As always, F::Q is community supported software. So anyone is welcome 
to submit a pull request.


Bruce S

P.S. Likely any further responses with suggestions or ideas related to 
this issue will be ignored. Please let the Equus ferus caballus rest 
in peace.

___
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] Finance::Quote - AlphaVantage Trade

[Bruce Schuck]

On 07/21/2023 at 18:34 EDT Kaligula wrote:

In general the suffix idea looks like a nice workaround – but I'd 
like to throw in my two cents.


So maybe a general solution in case of AV module pricing errors – a 
".???" suffix (to any ticker, not only LSE ones) where the "???" is 
the currency that the security is traded in? (Or even better with a 
":???" suffix, to avoid confusion with stock exchange suffixes). This

would allow the user to inform the AV module about changes in
default currency – e.g. "GBP.L:GPX" or "MVOL.L:USD".

Kaligula,

Please don't disturb the horse. It's well beyond deceased and we're not 
trying to make glue. At least I am not. I've made my decision on how 
it's going to be handled. 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, but John 
and I had a decent little discussion of the matter.


For a real solution, I would urge anybody using AlphaVantage for quote 
data to contact AV's support and request that the trade currency be 
added to the JSON returned from the GLOBAL_QUOTE API.


As always, F::Q is community supported software. So anyone is welcome to 
submit a pull request.


Bruce S

P.S. Likely any further responses with suggestions or ideas related to 
this issue will be ignored. Please let the Equus ferus caballus rest in 
peace.

___
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] Finance::Quote - AlphaVantage Trade Currencies

[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 implemented, wouldn't it be better to set the 
suffix to ".GBX" or ".GBp"? (or any?) It would give the idea of what it 
is for.


So maybe a general solution in case of AV module pricing errors – a 
".???" suffix (to any ticker, not only LSE ones) where the "???" is the 
currency that the security is traded in? (Or even better with a ":???" 
suffix, to avoid confusion with stock exchange suffixes). This would 
allow the user to inform the AV module about changes in default currency 
– e.g. "GBP.L:GPX" or "MVOL.L:USD".


Best regards,
Kaligula

___
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] Finance::Quote - AlphaVantage Trade Currencies

[Bruce Schuck]

On 7/18/23 10:34 AM, John Ralls wrote:


YahooJSON and now YahooWeb are already doing the GBX->GBP
conversion (not my doing). Easy because both of those sources have
the pricing currency in the data returned. I hope you are not
suggesting that the conversion is removed from both of those
modules?



I'm not. I'm pointing out the disadvantages of handling the pricing
issue on the client side.


Okay. I think it would be reasonable assumption that Finance::Quote
returns pricing in ISO-4217 currencies. But definitely a quagmire when
faced with an issue like this one.


Roger, but slowing AV down to 5 quotes/2 minutes will make it pretty
useless for anyone with even a small number of LSE stocks. Users
already gripe about the 5/sec throttling.


Which is why I posed the original question. Aside from the two of us
having this wonderful exchange of ideas, no one else stepped in 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 AlphaVantage check for the
additional (let's say ".X") suffix? Or any quote source? Much
easier to accomplish on a per module basis, than F::Q in general.
But as stated, that means the user needs to know to use GBP.L.X
(Global Petroleum) for AV to return GBP, but YahooJSON does not
need the extra ".X". Then again, that's what man pages are for...
;)



Yes, I think that's the best alternative to asking AV for the
currency. Another that we haven't discussed would be caching the
results somewhere, but that conflicts with F::Q's stateless design.


Alright. At some point I'll have AlphaVantage look for symbols supplied 
with an additional '.X' suffix. If it's given, divide the pricing info 
by 100. If not, leave it be. Of course I'll add info on this to the 
manpage/POD. I'll also ping AV support again. I was told they would look 
into adding the currency to the JSON returned from the GLOBAL_QUOTE API 
which would make my job a zillion times easier.


Thanks again John.

Bruce S.
___
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] Finance::Quote - AlphaVantage Trade Currencies

[John Ralls]

> On Jul 18, 2023, at 10:12 AM, Bruce Schuck  wrote:
> 
> On 7/17/23 9:06 PM, john wrote:
> 
>> Well, a user wouldn't want to set GBX as their default currency,
>> just to create an account in their tree denominated in it to be a
>> parent for stock accounts 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
>> policy and adding an entry to our currency file.
> 
> Probably why AlphaVantage and YahooJSON convert GBX quotes to GBP. I
> started to get involved with Finance::Quote after AV was added because a
> Google finance API was discontinued.
> 
>> To be pure it would also require F::Q to leave the GBX->GBP conversion to 
>> the client program, because while it's reasonable to expect a user who owns 
>> GBP.L shares to know that they trade in GBX it's not reasonable to expect 
>> them to know that it's one of the exceptions that doesn't get adjusted 
>> automatically when getting the price from AlphaVantage, but *does* get 
>> adjusted automatically when retrieved from Yahoo!.
> 
> YahooJSON and now YahooWeb are already doing the GBX->GBP conversion
> (not my doing). Easy because both of those sources have the pricing
> currency in the data returned. I hope you are not suggesting that the
> conversion is removed from both of those modules?

I'm not. I'm pointing out the disadvantages of handling the pricing issue on 
the client side.

> 
> There-in lies why I figure the additional lookup to get the correct
> currency is needed. So the user doesn't need to worry about what modules
> may or may not be doing GBX->GBP or ZAc->ZAR conversion. Consistent with
> two Yahoo modules, AV would return the ISO currency. At least that was
> my thinking.

Roger, but slowing AV down to 5 quotes/2 minutes will make it pretty useless 
for anyone with even a small number of LSE stocks. Users already gripe about 
the 5/sec throttling. 

> 
>> And repeating myself for emphasis, that's how GnuCash could handle it
>> but I have no idea if it's reasonable for other programs. From that
>> standpoint the extra suffix is more straightforward: Just add it and
>> F::Q will unconditionally multiply the price by 100. That will work
>> for any client and is pretty easy to explain to users.
> To clarify, are you suggesting have AlphaVantage check for the additional 
> (let's say ".X") suffix? Or any quote source? Much easier to accomplish on a 
> per module basis, than F::Q in general. But as stated, that means the user 
> needs to know to use GBP.L.X (Global Petroleum) for AV to return GBP, but 
> YahooJSON does not need the extra ".X". Then again, that's what man pages are 
> for... ;)

Yes, I think that's the best alternative to asking AV for the currency. Another 
that we haven't discussed would be caching the results somewhere, but that 
conflicts with F::Q's stateless design.

> 
> Definitely validates what I tried to explain in the F::Q issue, where the 
> solution is *not* just a simple "remove the adjustment".
> 
> I may just shelve this for a while longer. Thanks for the discussion and 
> insight.

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

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

[Bruce Schuck]

On 7/17/23 9:06 PM, john wrote:


Well, a user wouldn't want to set GBX as their default currency,
just to create an account in their tree denominated in it to be a
parent for stock accounts 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
policy and adding an entry to our currency file.


Probably why AlphaVantage and YahooJSON convert GBX quotes to GBP. I
started to get involved with Finance::Quote after AV was added because a
Google finance API was discontinued.

To be pure it would also require F::Q to leave the GBX->GBP 
conversion to the client program, because while it's reasonable to 
expect a user who owns GBP.L shares to know that they trade in GBX 
it's not reasonable to expect them to know that it's one of the 
exceptions that doesn't get adjusted automatically when getting the 
price from AlphaVantage, but *does* get adjusted automatically when 
retrieved from Yahoo!.


YahooJSON and now YahooWeb are already doing the GBX->GBP conversion
(not my doing). Easy because both of those sources have the pricing
currency in the data returned. I hope you are not suggesting that the
conversion is removed from both of those modules?

There-in lies why I figure the additional lookup to get the correct
currency is needed. So the user doesn't need to worry about what modules
may or may not be doing GBX->GBP or ZAc->ZAR conversion. Consistent with
two Yahoo modules, AV would return the ISO currency. At least that was
my thinking.


And repeating myself for emphasis, that's how GnuCash could handle it
but I have no idea if it's reasonable for other programs. From that
standpoint the extra suffix is more straightforward: Just add it and
F::Q will unconditionally multiply the price by 100. That will work
for any client and is pretty easy to explain to users.
To clarify, are you suggesting have AlphaVantage check for the 
additional (let's say ".X") suffix? Or any quote source? Much easier to 
accomplish on a per module basis, than F::Q in general. But as stated, 
that means the user needs to know to use GBP.L.X (Global Petroleum) for 
AV to return GBP, but YahooJSON does not need the extra ".X". Then 
again, that's what man pages are for... ;)


Definitely validates what I tried to explain in the F::Q issue, where 
the solution is *not* just a simple "remove the adjustment".


I may just shelve this for a while longer. Thanks for the discussion and 
insight.


Bruce S.
___
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] Finance::Quote - AlphaVantage Trade Currencies

[john]

Bruce forgot to copy the list on this and couldn't find it to resend, and then 
so did I on the reply!

> On Jul 17, 2023, at 18:57, Bruce Schuck  wrote:
> On 7/17/23 5:28 PM, John Ralls wrote:
> 
>> Sorry, I can't provide any examples of JSE or TASE stocks, I was
>> 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.
> 
>> Yes, both of my suggestions transfer the responsibility for knowing
>> what currency a stock is traded in to the user. In GnuCash's case
>> that responsibility is already there. GnuCash doesn't use the
>> currency returned from F::Q, it assumes that the price is denominated
>> in the currency of the nearest parent account denominated in a
>> currency. We don't get that many users who miss that detail and it's
>> pretty easy for them to fix their books. I don't know about other
>> programs using F::Q.
> 
> Now here's where I am cloudy. Since GBX is *not* a standard ISO 4217 currency 
> code, a user cannot choose GBX as their default currency, or am I missing 
> something? Currently, without the AlphaVantage module modifying prices for 
> securities such as GBP.L, GnuCash would assume the price is GBP, and it would 
> be wrong. GnuCash would assume the price is 0.18 GBP, when it's 0.18 GBX or 
> 0.0018 GBP.
> 
> Which is likely why Erik added the "fix" back in 2017. Since all (or most?) 
> the LSE traded stocks have the ".L" suffix in AV, they all get mapped to GBP. 
> Erik may have tested with a GBp priced security and make the adjusting logic 
> match ".GBP" or ".GBX". Likely he also didn't realize that the suffix ".GBX" 
> was impossible, since it's not in the currency map in the module.
> 
> With this in mind, I think the currency check and extra API call needs to be 
> done so securities traded in GBX get adjusted to GBP and GBP priced 
> securities are left alone. To me, that's the simplest fix although for users 
> with a good amount of LSE traded securities, it will slow down the AV 
> throttling.

Well, a user wouldn't want to set GBX as their default currency, just to create 
an account in their tree denominated in it to be a parent for stock accounts 
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 policy and adding an entry to our currency file.

To be pure it would also require F::Q to leave the GBX->GBP conversion to the 
client program, because while it's reasonable to expect a user who owns GBP.L 
shares to know that they trade in GBX it's not reasonable to expect them to 
know that it's one of the exceptions that doesn't get adjusted automatically 
when getting the price from AlphaVantage, but *does* get adjusted automatically 
when retrieved from Yahoo!. And repeating myself for emphasis, that's how 
GnuCash could handle it but I have no idea if it's reasonable for other 
programs. From that standpoint the extra suffix is more straightforward: Just 
add it and F::Q will unconditionally multiply the price by 100. That will work 
for any client and is pretty easy to explain to users. 

I guess since YohooWeb *does* report the currency that simply documenting that 
it's a problem is an alternative, and users can be directed to use that instead 
when they have pricing problems.

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

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

[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 Yahoo JSON module adjusts prices for Zac (South Africa)
>> and ILA (Israel) as well as GBX, but Yahoo JSON apparently includes a
>> currency code to make that easy. That seems to be missing from
>> YahooWeb, perhaps an oversight on Vincent's part. The currency is
>> available on https://finance.yahoo.com/quote/GBP.L 
>> <https://finance.yahoo.com/quote/GBP.L> prefixed by "Currency In" in
>> div id="quote-header-info".
> 
> The currency is being captured by YahooWeb. For GBP.L (traded in GBp/GBX) has 
> its price converted to GBP and currency reported as such. At the time of this 
> writing, GBP.L was 0.1850 GBp, F::Q v1.57 yahooweb returns 0.00185 GBP.
> 
> % gnc-fq-dump -v yahooweb GBP.L
> 
> stock   field  value
> -   -  -
> GBP.Lcurrency: GBP
> GBP.Ldate: 07/17/2023
> GBP.Lexchange: LSE - LSE Delayed Price
> GBP.L isodate: 2023-07-17
> GBP.Llast: 0.00185
> GBP.L  method: yahooweb
> GBP.Lname: Global Petroleum Limited
> GBP.L success: 1
> GBP.L  symbol: GBP.L
> 
> > So for AlphaVantage it seems only .L and .IL suffix securities would
> > need to be queried, and maybe only .L unless there are known
> > instances where .IL-suffixed symbols are priced in GBP.
> 
> I will change the AlphaVantage.pm fix I'm working on to only execute the 
> extra API call for securities ending with '.L'.
> 
>> Rather than spending an extra query maybe AlphaVantage.pm could
>> accept a special extra suffix indicating that the user wants quotes
>> to be multiplied by 100, perhaps X, so a request for GBP.L priced in
>> GBP would be GBP.L.X.
> 
> If I understand, this method assumes the user knows that the data from AV for 
> GBP.L is priced in GBp/GBX. Correct?
> 
>> Alternatively we could create a GBX, ZAX, and ILA pseudo-currencies
>> in GnuCash and users would create parent accounts in those currencies
>> for stocks quoted that way. That would take a little finessing on
>> users' part because using it would depend both on the currency the
>> stock is quoted in and whether F::Q converts it to the "real"
>> currency.
> 
> F::Q currently sets currency based on suffix. '.L' gets mapped to 'GBP'. I 
> just checked, currently no map in AV for ZAR. By chance, you don't have an 
> example for me? Thanks. Like the previous comment, this also expects users to 
> know what currencies the different securities are reports as coming from the 
> AV module, correct? While I like the idea on a high level, I think that is 
> asking for trouble reports from users having pricing issues.
> 

Bruce,

Sorry, I can't provide any examples of JSE or TASE stocks, I was going 
completely off of looking at the code in the three modules.

Yes, both of my suggestions transfer the responsibility for knowing what 
currency a stock is traded in to the user. In GnuCash's case that 
responsibility is already there. GnuCash doesn't use the currency returned from 
F::Q, it assumes that the price is denominated in the currency of the nearest 
parent account denominated in a currency. We don't get that many users who miss 
that detail and it's pretty easy for them to fix their books. I don't know 
about other programs using F::Q.

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

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

[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 Yahoo JSON apparently includes a
currency code to make that easy. That seems to be missing from
YahooWeb, perhaps an oversight on Vincent's part. The currency is
available on https://finance.yahoo.com/quote/GBP.L 
<https://finance.yahoo.com/quote/GBP.L> prefixed by "Currency In" in

div id="quote-header-info".


The currency is being captured by YahooWeb. For GBP.L (traded in 
GBp/GBX) has its price converted to GBP and currency reported as such. 
At the time of this writing, GBP.L was 0.1850 GBp, F::Q v1.57 yahooweb 
returns 0.00185 GBP.


% gnc-fq-dump -v yahooweb GBP.L

stock   field  value
-   -  -
GBP.Lcurrency: GBP
GBP.Ldate: 07/17/2023
GBP.Lexchange: LSE - LSE Delayed Price
GBP.L isodate: 2023-07-17
GBP.Llast: 0.00185
GBP.L  method: yahooweb
GBP.Lname: Global Petroleum Limited
GBP.L success: 1
GBP.L  symbol: GBP.L

> So for AlphaVantage it seems only .L and .IL suffix securities would
> need to be queried, and maybe only .L unless there are known
> instances where .IL-suffixed symbols are priced in GBP.

I will change the AlphaVantage.pm fix I'm working on to only execute the 
extra API call for securities ending with '.L'.



Rather than spending an extra query maybe AlphaVantage.pm could
accept a special extra suffix indicating that the user wants quotes
to be multiplied by 100, perhaps X, so a request for GBP.L priced in
GBP would be GBP.L.X.


If I understand, this method assumes the user knows that the data from 
AV for GBP.L is priced in GBp/GBX. Correct?



Alternatively we could create a GBX, ZAX, and ILA pseudo-currencies
in GnuCash and users would create parent accounts in those currencies
for stocks quoted that way. That would take a little finessing on
users' part because using it would depend both on the currency the
stock is quoted in and whether F::Q converts it to the "real"
currency.


F::Q currently sets currency based on suffix. '.L' gets mapped to 'GBP'. 
I just checked, currently no map in AV for ZAR. By chance, you don't 
have an example for me? Thanks. Like the previous comment, this also 
expects users to know what currencies the different securities are 
reports as coming from the AV module, correct? While I like the idea on 
a high level, I think that is asking for trouble reports from users 
having pricing issues.


Thanks again.

Bruce S.
___
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] Finance::Quote - AlphaVantage Trade Currencies

[john]

> On Jul 16, 2023, at 15:52, Bruce Schuck  wrote:
> 
> 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/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 returned from the AV 
> "GLOBAL_QUOTE" API did *NOT* contain the currency used for the pricing 
> returned.
> 
> What the AV module does is assign a currency based on the suffix of the 
> lookup symbol. So stocks like GBP.L and GBPG.L get mapped to GBP. The problem 
> is that GBP.L (Global Petroleum Limited) is traded in GBX (aka GBp) and 
> GBPG.L (Goldman Sachs Access UK Gilts 1-10) is traded in GBP. But the AV 
> module as written cannot differentiate since the currency used is not part of 
> the data. Stocks from South Africa have a similar issue.
> 
> Needless to say, since I was not ready to dig into the root cause and not 
> wanting to remove the fix that was meant to convert GBp pricing to GBP 
> pricing based solely on the symbol's suffix, the user decided to go on a rant 
> and throw a tantrum in the comments and had to be blocked from the 
> Finance::Quote repository.
> 
> ### Question here ###
> 
> The currency for the trades can be gotten from AV, but an additional call 
> using the "SYMBOL_SEARCH" API is necessary. Obviously this would impact the 
> throttling limitation of AlphaVantage. For non-US stocks, this means that 
> including an additional currency lookup an average of 2.5 securities can be 
> fetched per minute. I am curious how many of you all use AV for non-US traded 
> securities? Has the pricing discrepancy affect you, and would you want it 
> corrected even though that means increasing retrieval time due to the extra 
> API usage?

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 Yahoo JSON apparently includes a currency code to make that 
easy. That seems to be missing from YahooWeb, perhaps an oversight on Vincent's 
part. The currency is available on https://finance.yahoo.com/quote/GBP.L 
prefixed by "Currency In" in div id="quote-header-info <>".

So for AlphaVantage it seems only .L and .IL suffix securities would need to be 
queried, and maybe only .L unless there are known instances where .IL-suffixed 
symbols are priced in GBP.

Rather than spending an extra query maybe AlphaVantage.pm could accept a 
special extra suffix indicating that the user wants quotes to be multiplied by 
100, perhaps X, so a request for GBP.L priced in GBP would be GBP.L.X.

Alternatively we could create a GBX, ZAX, and ILA pseudo-currencies in GnuCash 
and users would create parent accounts in those currencies for stocks quoted 
that way. That would take a little finessing on users' part because using it 
would depend both on the currency the stock is quoted in and whether F::Q 
converts it to the "real" currency.

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

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

[Bruce Schuck]

On 7/17/23 03:48 PDT AM, Brad Morrison wrote:


Does it also make sense to post this situation & question to the
other 6 GnuCash Mailman 2 mailing lists that are not in English? 
https://wiki.gnucash.org/wiki/Mailing_Lists  & 
https://lists.gnucash.org/mailman/listinfo


If someone cares to translate and cross-post, be my guest. I would think 
that those GnuCash users who can understand English may be subscribed to 
gnucash-user in addition to the gnucash-?? list of their native language.



2.5 securities per minute seems really slow!


Not a limitation of the module, a limitation 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 
premium membership."


The currency is *not* supplied in the JSON returned when fetching the 
price data. So for securities such as GBP.L (GBX/GBp) or GBPG.L (GBP), a 
second API call is required to determine the currency. Otherwise that 
module maps '.L' to GBP which would be incorrect for GBP.L. So, for 
non-US stocks, 2 API calls are needed for one security.


Thanks.

Bruce S.
___
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] Finance::Quote - AlphaVantage Trade Currencies

[Brad Morrison]

Hi Bruce/all,

Thank you for all your hard work with F::Q!

Does it also make sense to post this situation & question to the other 6 
GnuCash Mailman 2 mailing lists that are not in English? 
https://wiki.gnucash.org/wiki/Mailing_Lists & 
https://lists.gnucash.org/mailman/listinfo


I have never used F::Q in GnuCash (or at all), so maybe my point is 
useless or maybe you already are signed up for those other language 
lists. I was just thinking that there may be many more users of AV for 
non-US traded securities on the other language lists than English - ?


In my work for a tax & wealth management firm (on the tax side), I most 
frequently interact with non-US traded stocks when an IRS form 1099DIV 
(https://www.irs.gov/forms-pubs/about-form-1099-div) or 1099B 
(https://www.irs.gov/forms-pubs/about-form-1099-b) indicates that 
foreign taxes were paid and my role is account for those foreign taxes 
paid & to determine whether an IRS form 1116 
(https://www.irs.gov/forms-pubs/about-form-1116) is needed.


While I am mentioning the GnuCash mailing lists, does anyone know if 
there are plans to upgrade from Mailman 2 to Mailman 3? 
https://www.gnu.org/software/mailman/ & 
https://en.wikipedia.org/wiki/GNU_Mailman


2.5 securities per minute seems really slow!

Brad


On 7/16/23 15:52, Bruce Schuck wrote:

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/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 
returned from the AV "GLOBAL_QUOTE" API did *NOT* contain the currency 
used for the pricing returned.


What the AV module does is assign a currency based on the suffix of 
the lookup symbol. So stocks like GBP.L and GBPG.L get mapped to GBP. 
The problem is that GBP.L (Global Petroleum Limited) is traded in GBX 
(aka GBp) and GBPG.L (Goldman Sachs Access UK Gilts 1-10) is traded in 
GBP. But the AV module as written cannot differentiate since the 
currency used is not part of the data. Stocks from South Africa have a 
similar issue.


Needless to say, since I was not ready to dig into the root cause and 
not wanting to remove the fix that was meant to convert GBp pricing to 
GBP pricing based solely on the symbol's suffix, the user decided to 
go on a rant and throw a tantrum in the comments and had to be blocked 
from the Finance::Quote repository.


### Question here ###

The currency for the trades can be gotten from AV, but an additional 
call using the "SYMBOL_SEARCH" API is necessary. Obviously this would 
impact the throttling limitation of AlphaVantage. For non-US stocks, 
this means that including an additional currency lookup an average of 
2.5 securities can be fetched per minute. I am curious how many of you 
all use AV for non-US traded securities? Has the pricing discrepancy 
affect you, and would you want it corrected even though that means 
increasing retrieval time due to the extra API usage?


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


___
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] Finance::Quote - AlphaVantage Trade Currencies

[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/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 
returned from the AV "GLOBAL_QUOTE" API did *NOT* contain the currency 
used for the pricing returned.


What the AV module does is assign a currency based on the suffix of the 
lookup symbol. So stocks like GBP.L and GBPG.L get mapped to GBP. The 
problem is that GBP.L (Global Petroleum Limited) is traded in GBX (aka 
GBp) and GBPG.L (Goldman Sachs Access UK Gilts 1-10) is traded in GBP. 
But the AV module as written cannot differentiate since the currency 
used is not part of the data. Stocks from South Africa have a similar issue.


Needless to say, since I was not ready to dig into the root cause and 
not wanting to remove the fix that was meant to convert GBp pricing to 
GBP pricing based solely on the symbol's suffix, the user decided to go 
on a rant and throw a tantrum in the comments and had to be blocked from 
the Finance::Quote repository.


### Question here ###

The currency for the trades can be gotten from AV, but an additional 
call using the "SYMBOL_SEARCH" API is necessary. Obviously this would 
impact the throttling limitation of AlphaVantage. For non-US stocks, 
this means that including an additional currency lookup an average of 
2.5 securities can be fetched per minute. I am curious how many of you 
all use AV for non-US traded securities? Has the pricing discrepancy 
affect you, and would you want it corrected even though that means 
increasing retrieval time due to the extra API usage?


Bruce S.
___
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] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API

[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 Metals.

>> Will revert back F::Q in the next release.

On 11/8/22 4:06 PM, Murugan Muruganandam wrote:


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


Well, technically it is possible. But then any software that utilizes 
F::Q such as GnuCash would need to be modified to pass that 
option/argument to F::Q upon invocation. In my opinion, adding 
complexity to account for "what ifs" is a start down the rabbit hole.


- Bruce S

___
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] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API

[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, 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 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 the next release.

- Bruce S.
___
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.
___
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] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API

[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 the next release.

- Bruce S.
___
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] Install Alphavantage Key

[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.
Regards
Peter
> On 26/11/2021 13:04 Geoff  wrote:
> 
>  
> Hi Peter
> 
> As Eric said, you need to enter your key via:-
>   Edit / Preferences / Online Quotes
> 
> However I believe that Alpha Vantage no longer provide prices for 
> Australian securities.
> 
> I have been using the method below to reliably retrieve prices from the 
> Australian Securities Exchange (ASX) for a number of years.  I can't 
> help you with New Zealand.
> 
> Before doing anything in GnuCash, you should verify that the latest 
> version of the Perl Finance::Quote module (v1.51) is installed correctly:-
> http://finance-quote.sourceforge.net/
> 
> On Windows, you can do this from a Command prompt as follows:
>  >perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-dump" asx CBA
> 
> Which should result in something like this:-
> Finance::Quote fields Gnucash uses:
>  symbol: CBA  <=== required
>date: 11/26/2021   <=== recommended
>currency: AUD  <=== required
>last: 96.1 <=\
> nav:  <=== one of these
>   price: 96.1 <=/
>timezone:  <=== optional
> 
> 
> Then you can open GnuCash and set up your portfolio as follows:-
> (1) Create your Securities and link them to the ASX via:-
>   Tools / Security Editor
> 
> (2) Create your Accounts (as Account Type of "Stock") and link them to 
> those Securities.
> 
> (3) Retrieve prices via:-
>   Tools / Price Database / GetQuotes
> 
> See the attached screenshot for a detailed working example.
> 
> Hope this helps.
> 
> Regards
> 
> Geoff
> =
> 
> On 26/11/2021 8:48 am, Peter Williamson wrote:
> > 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
> > ___
> > 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] Install Alphavantage Key

[Eric Coates via gnucash-user]

Hi

Via Edit>Preferences there is a tab for online quotes; enter your Alpha 
Vantage key into the box provided.


However; that may not allow you to get Australian/NZ quotes and even if 
it does it may be painfully slow.  In the Securities Editor tool it is 
possible to select other source 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 currency conversions.

Good luck

Eric
===

On 25/11/2021 21:48, Peter Williamson wrote:

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



___
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] Install Alphavantage Key

[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 
___
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] AlphaVantage

[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 of AlphaVantage did not 
follow the upgrade.


Questions:  Does GC 2.6.21 have a location in the Preferences or is that 
only for the 3.0 version?


If I need to configure AlphaVantage manually, can someone point me to 
the instructions for this?


Thanks,

Les


___
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] PriceQuotes and AlphaVantage assistance request

[nvsoar]

On 10/05/18 10:20, Frank H. Ellenberger wrote:

Hi Megagrumpy,

Am 05.10.18 um 08:46 schrieb Megagrumpy:

I do not know how to link to a previous message

go to https://lists.gnucash.org/pipermail/gnucash-user/ and select the
month i.e. by thread it should look similar to your inbox.

Finally 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. Hopefully this link works -

HTH
Frank


Many thanks to those who responded.
Yahoo Json worked very well on GnuCash v3.3; resulted in 'program not 
responding' on v2.6.21.

nvsoar


___
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] PriceQuotes and AlphaVantage assistance request

[Frank H. Ellenberger]

Hi Megagrumpy,

Am 05.10.18 um 08:46 schrieb Megagrumpy:
> I do not know how to link to a previous message

go to https://lists.gnucash.org/pipermail/gnucash-user/ and select the
month i.e. by thread it should look similar to your inbox.

Finally 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. Hopefully this link works - 

HTH
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] PriceQuotes and AlphaVantage assistance request

[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.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=user_nodes=378289



--
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] PriceQuotes and AlphaVantage assistance request

[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 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 Colson gets around to releasing F::Q 1.48 the only thing that
> you can do is to install Finance::Quote from the git repository:
> https://github.com/financequote/financequote.git.
>
> 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.
>
___
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] PriceQuotes and AlphaVantage assistance request

[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 Colson gets around to releasing F::Q 1.48 the only thing that you 
can do is to install Finance::Quote from the git repository: 
https://github.com/financequote/financequote.git.

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.

[GNC] PriceQuotes and AlphaVantage assistance request

[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

___
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] AlphaVantage Deal

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

Hi Ott,

I'm using v3.2 Build ID: git 3.2-48-gc444729db+ (2018-07-16) built from
git running on Linux. F::Q is v1.47.

The perl scripts for each download source are stored in
/usr/share/perl5/vendor_perl/Finance/Quote/ on my Linux system, which is
where I found YahooJSON.pm.

Other than that, I'm not a gc developer and don't know, nor have taken
the time to find out, how the quotes are actually loaded into gnucash.

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.

Re: [GNC] AlphaVantage Deal

[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

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 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 the 5 quotes/minute. It works perfectly for me,
> as
> > I have many securities that I'm tracking, but only use GNC to sync once a
> > day. If you are interested in something along similar lines, feel free to
> > email me separately and let me know how much you think this service is
> > worth to you.
> >
> > I'll have to pull Bruce's implementation and kick the tires on it - that
> > could be the solution that works for me.
> >
> > Regards,
> > Ethan
> >
>
> Personally, I gave up with AlphaVantage some time ago as I found them
> too unreliable.
>
> Apart from the issue of missing stock quotes due to the volume issues
> that have been discussed, I also had the following issues.
>
> - I usually download prices at least 60 minutes after market close each
> day. If I didn't get to download prices on a Friday evening and ended up
> downloading them on a Saturday or Sunday, the prices would download 100
> times too small. I would notice this because my total assets would take
> a dive.
>
> - Frequently, downloaded prices would be way off the actual closing
> price for many stocks.
>
> - Currency rates would fail to load 100% of the time.
>
> I moved to yahoo_json which is working well for me. I had an initial
> issue where prices for securities quoted on the LSE were downloaded 100
> times too big in pence rather than £'s but that was easily fixed by
> amending the YahooJSON.pm perl script to divide the prices by 100.
>
> Also since moving stock price download away from AlphaVantage, currency
> rates are now updating due to the reduced volume.
>
> 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.
___
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] AlphaVantage Deal

[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 to 128 quotes/day,
> then revert back down to the 5 quotes/minute. It works perfectly for me, as
> I have many securities that I'm tracking, but only use GNC to sync once a
> day. If you are interested in something along similar lines, feel free to
> email me separately and let me know how much you think this service is
> worth to you.
> 
> I'll have to pull Bruce's implementation and kick the tires on it - that
> could be the solution that works for me.
> 
> Regards,
> Ethan
> 

Personally, I gave up with AlphaVantage some time ago as I found them
too unreliable.

Apart from the issue of missing stock quotes due to the volume issues
that have been discussed, I also had the following issues.

- I usually download prices at least 60 minutes after market close each
day. If I didn't get to download prices on a Friday evening and ended up
downloading them on a Saturday or Sunday, the prices would download 100
times too small. I would notice this because my total assets would take
a dive.

- Frequently, downloaded prices would be way off the actual closing
price for many stocks.

- Currency rates would fail to load 100% of the time.

I moved to yahoo_json which is working well for me. I had an initial
issue where prices for securities quoted on the LSE were downloaded 100
times too big in pence rather than £'s but that was easily fixed by
amending the YahooJSON.pm perl script to divide the prices by 100.

Also since moving stock price download away from AlphaVantage, currency
rates are now updating due to the reduced volume.

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.

Re: [GNC] AlphaVantage Deal

[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 the 5 quotes/minute. It works perfectly for me, as
I have many securities that I'm tracking, but only use GNC to sync once a
day. If you are interested in something along similar lines, feel free to
email me separately and let me know how much you think this service is
worth to you.

I'll have to pull 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...@asgard-systems.com>
Content-Type: text/plain; charset="utf-8"

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 request #88 on the F::Q github site. It
needs a little polishing, but it has been working for me.

- Bruce S.
___
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] AlphaVantage Deal

[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 request #88 on the F::Q github site. It
needs a little polishing, but it has been working for me.

- Bruce S.




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] AlphaVantage deal

[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 (`
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 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 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 provide 128 queries/day at 2
queries/second before dropping back down to the free level of 1 quote /

20

seconds for a monthly fee of USD$5/month. AlphaVantage expressed
willingness to provide something along those lines - what do you folks
think? Would this be something worth $5/mo, $10/mo, or are most users

happy

at the free levels?

Regards,
Ethan

I would gladly pay $10/mo for reliable quotes as long as I can get a wide
range of sources. Many funds that I use are not supported by AlphaVantage.

My $0.2


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



--
dhamb...@afrinc.com
home phone (207) 633-4342
Cell Phone (207) 350-0440

___
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] AlphaVantage deal

[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 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 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 provide 128 queries/day at 2
> > queries/second before dropping back down to the free level of 1 quote /
> 20
> > seconds for a monthly fee of USD$5/month. AlphaVantage expressed
> > willingness to provide something along those lines - what do you folks
> > think? Would this be something worth $5/mo, $10/mo, or are most users
> happy
> > at the free levels?
> >
> > Regards,
> > Ethan
>
> I would gladly pay $10/mo for reliable quotes as long as I can get a wide
> range of sources. Many funds that I use are not supported by AlphaVantage.
>
> My $0.2
>
>
> ___
> 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] AlphaVantage deal

[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 sync between GnuCash and the
> markets, so I proposed a tier that would provide 128 queries/day at 2
> queries/second before dropping back down to the free level of 1 quote / 20
> seconds for a monthly fee of USD$5/month. AlphaVantage expressed
> willingness to provide something along those lines - what do you folks
> think? Would this be something worth $5/mo, $10/mo, or are most users happy
> at the free levels?
> 
> Regards,
> Ethan

I would gladly pay $10/mo for reliable quotes as long as I can get a wide 
range of sources. Many funds that I use are not supported by AlphaVantage.

My $0.2


___
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] AlphaVantage deal

[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 provide 128 queries/day at 2
queries/second before dropping back down to the free level of 1 quote / 20
seconds for a monthly fee of USD$5/month. AlphaVantage expressed
willingness to provide something along those lines - what do you folks
think? Would this be something worth $5/mo, $10/mo, or are most users happy
at the free levels?

Regards,
Ethan
___
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] Finance::Quote still not working with alphavantage

[Samantha Payn]

   Hi Maf/

   Windows 10 64 bit with all the updates etc

   GNUcash Version: 3.1
   Build ID: 3.0-118-gd2ef5fd0f+ (2018-04-28)
   Finance::Quote: 1.47

   Yes I have the API Key and quotes (I just need two currencies) were
   updating nicely until about a week ago.

   Any help gratefully received.

   --
   Samantha

 On 23 July 2018 at 16:24 "Maf. King"  wrote:

 On Monday, 23 July 2018 15:55:01 BST Samantha Payn wrote:

 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 spell it out to me in words of one syllable please?

 Very many thanks :)

 Hi Samantha,

 I'm not sure I can get 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
 need to
 know that it exists!)

 just a start, someone else may be able to help more with the actual
 set up in
 due course.

 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] Finance::Quote still not working with alphavantage

[Maf. King]

On Monday, 23 July 2018 15:55:01 BST Samantha Payn wrote:
>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 spell it out to me in words of one syllable please?
> 
>Very many thanks :)
> 

Hi Samantha,

I'm not sure I can get 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 need to 
know that it exists!)

just a start, someone else may be able to help more with the actual set up in 
due course.

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] Finance::Quote still not working with alphavantage

[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 spell it out to me in words of one syllable please?

   Very many thanks :)

   --
   Samantha Payn
   Tel: 01770 820655
   Mob: 07977 150053
___
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] Finance::Quote still not working with alphavantage

[brad]

I just updated to xubuntu 18.04 and the packaged gnucash 2.6.19, and I 
still have to update Quote.pm with this.


https://raw.githubusercontent.com/mtalexander/finance-quote/6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote.pm


From the list:
On Sat, Mar 31, 2018 at 9:49 PM, Chris Good  wrote:


Hi Steven,



Please see my mail below but get the Quote.pm + AlphaVantage.pm from Mike
Alexander’s git hub instead of mine as he has also put the 1 second delay
between each request for a currency and you will need that.



Get from Quote.pm from

https://raw.githubusercontent.com/mtalexander/finance-quote/
6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote.pm



Get AlphaVantage.pm from

https://github.com/mtalexander/finance-quote/blob/
6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote/AlphaVantage.pm



Regards,



Chris Good



On 07/05/2018 02:45 PM, David 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 about 1/3 to 1/2 of
the U.S. stocks and mutual funds in my list on a given try.  In two or
three tries I think that I get most of them. All of my machines are running
some GnuCash release between 2.6.12 and 2.6.17 and I think that I have gone
through all the steps that have been mentioned in this thread on most of
the machines but GnuCash still does not even tell me that it did not get
any of those stocks or mutual funds.

I suspect that GnuCash may not even be able to find the environment setting
or something.


David C

On Thu, Jul 5, 2018 at 1:05 PM, Greg Etling  wrote:


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 use the perlbrew version of perl. Can anyone let me know what I'm
likely forgetting?

Thanks

Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred by dust and sweat and blood; who strives valiantly; who errs, who
comes short again and again, because there is no effort without error and
shortcoming" -Theodore Roosevelt

On Sun, Nov 19, 2017 at 4:59 PM, Frank Saporito <
frank.saporito...@gmail.com

wrote:
Hi Greg

Is this what you are looking for?

$ ONLINE_TEST=1 prove -lvof t/alphavantage.t
Cannot determine source for t/alphavantage.t at
/usr/share/perl5/App/Prove.pm line 496

thanks



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-

f1415819.html

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.


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

[GNC] alphavantage quotes doesn't work

[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 a dialog box saying


8<
"Unable to retrieve quotes for these items:
ETF Canada:VGRO.TO
ETF US:QQQ
[...]
Continue using only the good quotes?"
>8


I tried gnc-fq-dump and it works well:

8<
nicolas@sylvestre:~$ gnc-fq-dump alphavantage VGRO.TO
Finance::Quote fields Gnucash uses:
symbol: VGRO.TO  <=== required
  date: 07/13/2018   <=== recommended
  currency: CAD  <=== required
  last: 25.3100  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:      <=== optional
nicolas@sylvestre:~$ gnc-fq-dump alphavantage QQQ
Finance::Quote fields Gnucash uses:
symbol: QQQ  <=== required
  date: 07/13/2018   <=== recommended
  currency: USD  <=== required
  last: 179.6100 <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional
>8


I tried to run gnucash with -debug and -extra but gnucash or 
Finance::Quotes are pretty quiet. So I don't know how to investigate 
further. Could somebody help me?


I'm running Gnucash 3.2+ (2018-06-24) with Finance::Quote: 1.47 under 
Debian Sid.


Thanks

--
Nicolas
___
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] Alphavantage quote displaying wrong currency and value

[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 is zero justification asking
> the user to configure anything about time. Between them, GnuCash and
> Finance::Quote, should be able to fetch the "latest available" price.

I don't use online quoting, so I may be incorrect here

Gnucash stores historical data about the prices. For that it needs date
and time, and presumably the timezone of the date, in case you use
several sources. 

Liz
___
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] Alphavantage quote displaying wrong currency and value

[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 is a default.

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 is zero justification asking the user to configure 
anything about time. Between them, GnuCash and Finance::Quote, should be 
able to fetch the "latest available" price.


___
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] Alphavantage quote displaying wrong currency and value

[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 
have no use for such a distinction, you can choose to ignore it.

> Also, why is it required to
> configure a timezone? The software is only after the latest quote price
> and should be able to hide that complexity from the user.

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 is a default.

___
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] Alphavantage quote displaying wrong currency and value

[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 stock called WES.

 

I find this online quote stuff needlessly confusing though. I fretted trying to 
work out what to configure as the "Type" for my stocks given none of the 
default ones (NASDAQ, EUREX, etc) seemed appropriate to my ASX stocks. Also, 
that field is confusingly called "Namespace" when you look in the securities 
editor. 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. Also, why is it required to configure a timezone? The 
software is only after the latest quote price and should be able to hide that 
complexity from the user.

 
--
Mark Blakeney.

 

On Sun, Jul 8, 2018 at 9:29 AM Chris Good mailto:goodchri...@gmail.com> > wrote:

> Message: 5
> Date: Sat, 7 Jul 2018 10:59:33 +1000
> From: Mark Blakeney  <mailto:mark.blake...@bullet-systems.net> >
> To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
> Subject: [GNC] Alphavantage quote displaying wrong currency and value
> Message-ID:
>ail.gmail.com <http://ail.gmail.com> >
> Content-Type: text/plain; charset="UTF-8"
> 
> 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 in gnucash as https://imgur.com/a/mblUFvj. My
> default currency is Australian dollars (AUD) everywhere.
> 
> However the online quote is displayed with the wrong currency (US) and
value as
> seen at https://imgur.com/a/gnS8Aau.
> 
> Does anybody know why?

Hi Mark,

You need to add suffix ".AX" to the "Symbol" in the Security Editor.
E.g. CBA.AX <http://CBA.AX> 
This tells Finance::Quote to use the price from the ASX using currency AUD.

Regards, Chris Good

 

Hi Mark,

I believe the security Type/Namespace is used to group securities in the 
security editor and Price Editor.

For those with many securities that is probably very useful. You should 
probably create a type called ASX for your aussie stocks. That’s what I did 
IIRC.

I don’t know why the timezone is needed but presumably it is.

The documentation could use some updating. The Help manual section about the 
Security Editor needs updating re Yahoo stopping providing most stock prices. 
Any help gratefully accepted :-)

Regards, Chris

 

___
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] Alphavantage quote displaying wrong currency and value

[Mark Blakeney]

Chris,

Yes thanks. I actually discovered that myself later on. Obviously it was
picking up some other US stock called WES.

I find this online quote stuff needlessly confusing though. I fretted
trying to work out what to configure as the "Type" for my stocks given none
of the default ones (NASDAQ, EUREX, etc) seemed appropriate to my ASX
stocks. Also, that field is confusingly called "Namespace" when you look in
the securities editor. 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. Also, why is it required to
configure a timezone? The software is only after the latest quote price and
should be able to hide that complexity from the user.

--
Mark Blakeney.

On Sun, Jul 8, 2018 at 9:29 AM Chris Good  wrote:

> > 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"
> >
> > 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 in gnucash as https://imgur.com/a/mblUFvj.
> My
> > default currency is Australian dollars (AUD) everywhere.
> >
> > However the online quote is displayed with the wrong currency (US) and
> value as
> > seen at https://imgur.com/a/gnS8Aau.
> >
> > Does anybody know why?
>
> Hi Mark,
>
> You need to add suffix ".AX" to the "Symbol" in the Security Editor.
> E.g. CBA.AX
> This tells Finance::Quote to use the price from the ASX using currency AUD.
>
> Regards, Chris Good
>
>
___
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] Alphavantage quote displaying wrong currency and value

[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"
> 
> 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 in gnucash as https://imgur.com/a/mblUFvj. My
> default currency is Australian dollars (AUD) everywhere.
> 
> However the online quote is displayed with the wrong currency (US) and
value as
> seen at https://imgur.com/a/gnS8Aau.
> 
> Does anybody know why?

Hi Mark,

You need to add suffix ".AX" to the "Symbol" in the Security Editor.
E.g. CBA.AX
This tells Finance::Quote to use the price from the ASX using currency AUD.

Regards, Chris Good

___
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] Alphavantage quote displaying wrong currency and value

[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 in gnucash as https://imgur.com/a/mblUFvj. My
default currency is Australian dollars (AUD) everywhere.

However the online quote is displayed with the wrong currency (US) and
value as seen at https://imgur.com/a/gnS8Aau.

Does anybody know why?
___
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] Finance::Quote still not working with alphavantage

[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 to 1/2 of
the U.S. stocks and mutual funds in my list on a given try.  In two or
three tries I think that I get most of them. All of my machines are running
some GnuCash release between 2.6.12 and 2.6.17 and I think that I have gone
through all the steps that have been mentioned in this thread on most of
the machines but GnuCash still does not even tell me that it did not get
any of those stocks or mutual funds.

I suspect that GnuCash may not even be able to find the environment setting
or something.


David C

On Thu, Jul 5, 2018 at 1:05 PM, Greg Etling  wrote:

> 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 use the perlbrew version of perl. Can anyone let me know what I'm
> likely forgetting?
>
> Thanks
>
> Greg
> 917-664-0083
> http://gregetling.com
> --
> "The credit belongs to the man who is actually in the arena, whose face is
> marred by dust and sweat and blood; who strives valiantly; who errs, who
> comes short again and again, because there is no effort without error and
> shortcoming" -Theodore Roosevelt
>
> On Sun, Nov 19, 2017 at 4:59 PM, Frank Saporito <
> frank.saporito...@gmail.com
> > wrote:
>
> > Hi Greg
> >
> > Is this what you are looking for?
> >
> > $ ONLINE_TEST=1 prove -lvof t/alphavantage.t
> > Cannot determine source for t/alphavantage.t at
> > /usr/share/perl5/App/Prove.pm line 496
> >
> > thanks
> >
> >
> >
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > 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.
> >
> ___
> 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] Finance::Quote still not working with alphavantage

[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 use the perlbrew version of perl. Can anyone let me know what I'm
likely forgetting?

Thanks

Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred by dust and sweat and blood; who strives valiantly; who errs, who
comes short again and again, because there is no effort without error and
shortcoming" -Theodore Roosevelt

On Sun, Nov 19, 2017 at 4:59 PM, Frank Saporito  wrote:

> Hi Greg
>
> Is this what you are looking for?
>
> $ ONLINE_TEST=1 prove -lvof t/alphavantage.t
> Cannot determine source for t/alphavantage.t at
> /usr/share/perl5/App/Prove.pm line 496
>
> thanks
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
>
___
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] Alphavantage Problem

[David Samsury]

Chris,

Thanks for the information regarding Finance::Quote and Alpha Vantage. I’ll 
give it a try.
BTW, being a cautious type, when I do implement the procedure, I’ll probably 
save copies of the original .pm files somewhere before overwriting them. Stuff 
happens and Murphy has a keyboard too.

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@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 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
> 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
> two quotes that are missing initially. However, for whatever the reason, I
have
> difficulty getting the majority around the 15th or 16th of every month. I
usually
> request updated quotations once a week early on Saturday morning. Today
was
> no exception and, as usual, the list for which no quotes were available
was a
> long one. Fortunately, I'm able to download the complete list of the prior
day's
> closing values from another source so that I can manually enter the quotes
that
> Finance-Quote missed.
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> 
> 
> --

Hi Samsurd2,

You may find these fixes to AlphaVantage helpful:

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

Regards, Chris Good





---
This email has been checked for viruses by AVG.
https://www.avg.com
___
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] Alphavantage Problem

[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 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
> 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
> two quotes that are missing initially. However, for whatever the reason, I
have
> difficulty getting the majority around the 15th or 16th of every month. I
usually
> request updated quotations once a week early on Saturday morning. Today
was
> no exception and, as usual, the list for which no quotes were available
was a
> long one. Fortunately, I'm able to download the complete list of the prior
day's
> closing values from another source so that I can manually enter the quotes
that
> Finance-Quote missed.
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> 
> 
> --

Hi Samsurd2,

You may find these fixes to AlphaVantage helpful:

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

Regards, Chris Good


___
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] AlphaVantage Quotes

[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 API I did come across two issues so far. The first is
that their free service allows just 250 requests per day. Still,
adequate for many investors. The second issue is that they do not have
data for mutual funds, at least not using the expected ticker symbols.

My Perl skills are rusty, having evolved into more of a systems
engineer/architect since my programming days. But on my Mac I did create
a Finance::Quote::WorldTrading module and used it to successfully update
the NYSE and NASDAQ stocks in my GnuCash accounts.

Should I perhaps post the module to the
finance-quote-de...@lists.sourceforge.net list for possible inclusion in
future releases of Finance::Quote?

- Bruce S.



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] Alphavantage Problem

[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 listed in several countries and about 8 currencies.)


Les
On 06/16/2018 12:33 PM, samsurd2 wrote:

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 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 two quotes that are missing initially. However, for
whatever the reason, I have difficulty getting the majority around the 15th
or 16th of every month. I usually request updated quotations once a week
early on Saturday morning. Today was no exception and, as usual, the list
for which no quotes were available was a long one. Fortunately, I'm able to
download the complete list of the prior day's closing values from another
source so that I can manually enter the quotes that Finance-Quote missed.



--
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] Alphavantage Problem

[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 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 two quotes that are missing initially. However, for
whatever the reason, I have difficulty getting the majority around the 15th
or 16th of every month. I usually request updated quotations once a week
early on Saturday morning. Today was no exception and, as usual, the list
for which no quotes were available was a long one. Fortunately, I'm able to
download the complete list of the prior day's closing values from another
source so that I can manually enter the quotes that Finance-Quote missed.



--
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] Alphavantage Problem

[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 quotes cojntain "deduced" with no data.


Any suggestions on how to resolve this issue, greatly appreciated.

Les


On 06/16/2018 12:09 AM, Bruce Schuck wrote:

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 (High Sierra), also the last two
days. Although it did manage to update most of my stock this afternoon.

Bruce S.
___
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] Alphavantage Problem

[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 (High Sierra), also the last two
days. Although it did manage to update most of my stock this afternoon.

Bruce S.
___
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] Alphavantage Problem

[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 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] AlphaVantage Stock Quotes

[John Ralls]

From https://www.alphavantage.co/documentation/ 
<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 above (which have richer content 
but are symbol-specific).

“Given the specifications of our data provider (IEX), we currently only offer 
US stock quotes during US market hours through this API. If you would like to 
query international stocks, ETFs, and mutual funds traded on major global 
exchanges, please refer to our core stock time series APIs”

The documentation might be wrong or Erik and I might be misinterpreting it, but 
IIUC that’s what he’s relying on.

Regards,
John Ralls

> On Jun 2, 2018, at 8:40 AM, Alun Champion  wrote:
> 
> 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: 
> https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT,FB,AAPL=demo
>  
> <https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT,FB,AAPL=demo>
>  and it shows MSFT, FB as of 16:01 yesterday. This is the same when I use my 
> API Key.
>-A.
> 
> On 2 June 2018 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 AM, Alun Champion  > <mailto:l...@achampion.net>> wrote:
> > 
> > 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=
> >  
> > <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  > <mailto:p...@ozemail.com.au>> wrote:
> > 
> >> 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 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/ 
> >> <https://www.alphavantage.co/documentation/>>. The only alternative in the
> >> documentation is full, which returns daily opening and closing prices for
> >> up to the last 20 years.
> >> 
> >> Peter
> >> 
> >> 
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> >> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists 
> >> <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 <mailto:gnucash-user@gnucash.org>
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> > <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists 
> > <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] AlphaVantage Stock Quotes

[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:
https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT,FB,AAPL=demo
and it shows MSFT, FB as of 16:01 yesterday. This is the same when I use my
API Key.
   -A.

On 2 June 2018 at 10:21, John Ralls  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 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 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 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 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 opening and closing prices
> for
> >> up to the last 20 years.
> >>
> >> Peter
> >>
> >>
> >> ___
> >> 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] AlphaVantage Stock Quotes

[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
> 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 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 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 opening and closing prices for
>> up to the last 20 years.
>> 
>> Peter
>> 
>> 
>> ___
>> 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] AlphaVantage Stock Quotes

[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 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 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 opening and closing prices for
> up to the last 20 years.
>
> Peter
>
>
> ___
> 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] AlphaVantage Stock Quotes

[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 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 opening and closing 
prices for up to the last 20 years.


Peter

___
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] AlphaVantage Stock Quotes

[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 per request) and it appears that there is throttling in the
perl module of Finance::Quote to work around rate limiting on the server
side. (See
https://github.com/finance-quote/finance-quote/blob/master/lib/Finance/Quote/AlphaVantage.pm#L252;
causing a delay of 700ms) per request.

If you 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?

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

dave.
___
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: FW: alphavantage quotes fix

[Chris Good]

Hi Steven,

 

You can but you should ask the gnucash-user email list first as many other 
people are interested, may have more available time and may have answers I 
don’t have.

 

Regards, Chris Good

 

From: Steven Anter <ante...@gmail.com> 
Sent: Monday, 2 April 2018 9:26 AM
To: Chris Good <goodchri...@gmail.com>; gnucash-user@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_source=link_campaign=sig-email_content=webmail_term=icon>
 

Virus-free.  
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=link>
 www.avast.com 

 

On Sat, Mar 31, 2018 at 9:49 PM, Chris Good <goodchri...@gmail.com 
<mailto:goodchri...@gmail.com> > wrote:

Hi Steven,

 

Please see my mail below but get the Quote.pm + AlphaVantage.pm from Mike 
Alexander’s git hub instead of mine as he has also put the 1 second delay 
between each request for a currency and you will need that. 

 

Get from Quote.pm from

https://raw.githubusercontent.com/mtalexander/finance-quote/6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote.pm

 

Get AlphaVantage.pm from

https://github.com/mtalexander/finance-quote/blob/6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote/AlphaVantage.pm

 

Regards,

 

Chris Good

 

From: Chris Good <goodchri...@gmail.com <mailto:goodchri...@gmail.com> > 
Sent: Sunday, 18 March 2018 6:54 PM
To: finance-quote-de...@lists.sourceforge.net 
<mailto:finance-quote-de...@lists.sourceforge.net> 
Cc: lordpaul...@gmail.com <mailto:lordpaul...@gmail.com> 
Subject: RE: alphavantage quotes fix 

 

Message: 1 
Date: Sat, 3 Mar 2018 07:49:34 -0600 
From: Paul Bates <lordpaul...@gmail.com <mailto:lordpaul...@gmail.com> > 
To: finance-quote-de...@lists.sourceforge.net 
<mailto:finance-quote-de...@lists.sourceforge.net>  
Subject: [Finance-quote-devel] alphavantage quotes fix 
Message-ID: 
<cal7glafoitanvhwrvtmopy5odnzwgjbdzkfwztusddb4gaj...@mail.gmail.com 
<mailto:cal7glafoitanvhwrvtmopy5odnzwgjbdzkfwztusddb4gaj...@mail.gmail.com> > 
Content-Type: text/plain; charset="utf-8" 

I have been using the alphavantage module with gnucash to get quotes for 
stocks.  The list is well over 40, so it has become nonfunctional in the 
last couple of months.  I am not a perl programmer, so the fix took several 
hours and more cups of coffee.  I hope a perl programmer can add error 
checks and possibly while loops to catch the occasional double message. 
Currently It seems to miss one or two stocks on the list. 

In alphavantage.pm <http://alphavantage.pm>I inserted the following code in 
the sub alphavantage : 

my $code = $reply->code; 
my $desc = HTTP::Status::status_message($code); 
my $body = $reply->content; 
if ($code != 200) { 
$info{ $stock, 'success' } = 0; 
$info{ $stock, 'errormsg' } = $desc; 
next; 
} 

my $json_data; 
eval {$json_data = JSON::decode_json $body}; 

# 
### Insert 
# 
# attempt to handle the Information message 
if ( $json_data->{'Information'} ) { 
   sleep (20); 
   $reply = $ua->request( GET $url); 
   $code = $reply->code; 
   $desc = HTTP::Status::status_message($code); 
   $body = $reply->content; 
   eval {$json_data = JSON::decode_json $body}; 
} 
### 

if ($@) { 
$info{ $stock, 'success' } = 0; 
$info{ $stock, 'errormsg' } = $@; 
} 

I am sure there are better ways to handle this, but I am not used to the 
developers lists and hate to leave alphavantage being blamed for a problem 
that is not theirs. 

Paul Bates 

Hi Paul,

 

I have modified AlphaVantage.pm as you requested.

If it fails with an Information message, it will try again 4 times, with a 20 
second delay between each try.

It tests OK for me but I don’t usually use AlphaVantage and it has never failed 
with an Information message for me, so can you please get my code from

https://github.com/goodvibes2/finance-quote/blob/FqIss83AlphaVantage/lib/Finance/Quote/AlphaVantage.pm

and test it?

 

After you test it, I will create a Pull Request to get this change incorporated 
in Finance::Quote.

 

Just for completeness, can you tell us what is in the Information messages you 
are getting?

 

Regards, Chris Good

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

Re: FW: alphavantage quotes fix

[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_source=link_campaign=sig-email_content=webmail_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sat, Mar 31, 2018 at 9:49 PM, Chris Good <goodchri...@gmail.com> wrote:

> Hi Steven,
>
>
>
> Please see my mail below but get the Quote.pm + AlphaVantage.pm from Mike
> Alexander’s git hub instead of mine as he has also put the 1 second delay
> between each request for a currency and you will need that.
>
>
>
> Get from Quote.pm from
>
> https://raw.githubusercontent.com/mtalexander/finance-quote/
> 6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote.pm
>
>
>
> Get AlphaVantage.pm from
>
> https://github.com/mtalexander/finance-quote/blob/
> 6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote/AlphaVantage.pm
>
>
>
> Regards,
>
>
>
> Chris Good
>
>
>
> *From:* Chris Good <goodchri...@gmail.com>
> *Sent:* Sunday, 18 March 2018 6:54 PM
> *To:* finance-quote-de...@lists.sourceforge.net
> *Cc:* lordpaul...@gmail.com
> *Subject:* RE: alphavantage quotes fix
>
>
>
> Message: 1
> Date: Sat, 3 Mar 2018 07:49:34 -0600
> From: Paul Bates <lordpaul...@gmail.com>
> To: finance-quote-de...@lists.sourceforge.net
> Subject: [Finance-quote-devel] alphavantage quotes fix
> Message-ID:
> <cal7glafoitanvhwrvtmopy5odnzwgjbdzkfwztusddb4gaj...@mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> I have been using the alphavantage module with gnucash to get quotes for
> stocks.  The list is well over 40, so it has become nonfunctional in the
> last couple of months.  I am not a perl programmer, so the fix took
> several
> hours and more cups of coffee.  I hope a perl programmer can add error
> checks and possibly while loops to catch the occasional double message.
> Currently It seems to miss one or two stocks on the list.
>
> In alphavantage.pm   I inserted the following code in the sub
> alphavantage :
>
> my $code = $reply->code;
> my $desc = HTTP::Status::status_message($code);
> my $body = $reply->content;
> if ($code != 200) {
> $info{ $stock, 'success' } = 0;
> $info{ $stock, 'errormsg' } = $desc;
> next;
> }
>
> my $json_data;
> eval {$json_data = JSON::decode_json $body};
>
> #
> ### Insert
> #
> # attempt to handle the Information message
> if ( $json_data->{'Information'} ) {
>sleep (20);
>$reply = $ua->request( GET $url);
>$code = $reply->code;
>$desc = HTTP::Status::status_message($code);
>$body = $reply->content;
>eval {$json_data = JSON::decode_json $body};
> }
> ###
>
> if ($@) {
> $info{ $stock, 'success' } = 0;
> $info{ $stock, 'errormsg' } = $@;
> }
>
> I am sure there are better ways to handle this, but I am not used to the
> developers lists and hate to leave alphavantage being blamed for a problem
> that is not theirs.
>
> Paul Bates
>
> Hi Paul,
>
>
>
> I have modified AlphaVantage.pm as you requested.
>
> If it fails with an Information message, it will try again 4 times, with a
> 20 second delay between each try.
>
> It tests OK for me but I don’t usually use AlphaVantage and it has never
> failed with an Information message for me, so can you please get my code
> from
>
> https://github.com/goodvibes2/finance-quote/blob/FqIss83AlphaVantage/lib/
> Finance/Quote/AlphaVantage.pm
>
> and test it?
>
>
>
> After you test it, I will create a Pull Request to get this change
> incorporated in Finance::Quote.
>
>
>
> Just for completeness, can you tell us what is in the Information messages
> you are getting?
>
>
>
> Regards, Chris Good
>
___
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: Alphavantage

[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 LInux Mint 18.2 and GC 2.7.17 (getdebs).  I also have the lasted 
F::Q update I have set all my stocks to unknown: Alphavantage.  My 
stocks are listed on Asx Tsx and others.  My currencies are AUD, CAD, 
CHF, HKD, CNY, SGD, MOP, THB and USD.


Any suggestions?

Thanks,

Les

I have the same setup on the latest MacOS and GC 2.6.19.  Same results.


I think alphavantage may have bitten off more than they can chew as I 
(and I presume others) sometimes get prices and at other times don't.


I presume you know alphavantage isn't actually anything to do with gnc 
as such ?


The only advice I have is "leave it for a bit and try again at least an 
hour later".  Yes, I know that doesn't seem very helpful but I think it 
is the right advice and at least you know it isn't personal :)


P.S. If you haven't ever got a price for something that is a different 
query.


--
Wm

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

Alphavantage

[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 (getdebs).  I also have the lasted 
F::Q update I have set all my stocks to unknown: Alphavantage.  My 
stocks are listed on Asx Tsx and others.  My currencies are AUD, CAD, 
CHF, HKD, CNY, SGD, MOP, THB and USD.


Any suggestions?

Thanks,

Les

I have the same setup on the latest MacOS and GC 2.6.19.  Same results.

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

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

[ln . mailinglists]

Hi All,

Just a quick heads up that neither source for ASX share prices is
working properly/consistently at the moment (or at least I haven't
worked out the consistency issues with alpha vantage). 

1) The old (and most reliable) "Single" source data feed direct from
the ASX stopped working on/around 21st January. See the following
whirlpool link for more details:

http://forums.whirlpool.net.au/archive/2678938

This forum page suggests that there are couple of alternative feeds
now available from the ASX. However, the ASX hasn't provided any
information on which of these (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-of working. You can definitely pull data using
.AX. However, the feed is somewhat inconsistent. To show the problem,
at the of end of this message, I've included a dump at from for
Telstra generated by the following alpha vantage web page:

https://www.alphavantage.co/query?function=TIME_SERIES_DAILY=TLS.AX=***.

The problem with the alpha vantage data is all about dates. I
generated the dump below on the morning of the 9th of February. The
first problem is that the most recent data in the Telstra data set is
for the 7th, when it should be showing the 8th. Unfortunately, there
is also a consistency problem - if I do a similar dump for VAS or STW,
then both of them provide data for the 8th.

I think this may be a time zone problem - but if so, it's a slightly
odd one, where normal run of the mill ASX stocks (TLS, WEL, FMG) 
will need to be collected based on one time zone, whereas ETFs (VAS,
STW, etc.) need to be collected on another. I picked this up because
I've used the local time zone for pulling data, and this results in
some, but not all ASX valuations being off by one day.

I'll update this when I've done a bit more digging, but I thought
other users of the ASX data sets would be interested to know about
this anomaly.

Cheers,

Larry

{ "Meta Data": { "1. Information": "Daily Prices (open, high, low,
close) and Volumes", "2. Symbol": "TLS.AX", "3. Last Refreshed":
"2018-02-07", "4. Output Size": "Compact", "5. Time Zone":
"US/Eastern" }, "Time Series (Daily)": { "2018-02-07": { "1. open":
"3.4900", "2. high": "3.5700", "3. low": "3.4900", "4. close":
"3.5600", "5. volume": "22698598" }, "2018-02-06": { "1. open":
"3.5400", "2. high": "3.5700", "3. low": "3.5000", "4. close":
"3.5000", "5. volume": "27375575" }, "2018-02-05": { "1. open":
"3.5600", "2. high": "3.5600", "3. low": "3.4800", "4. close":
"3.5100", "5. volume": "53276602" }, "2018-02-04": { "1. open":
"3.6400", "2. high": "3.6400", "3. low": "3.6050", "4. close":
"3.6200", "5. volume": "21058372" }, "2018-02-01": { "1. open":
"3.6300", "2. high": "3.6750", "3. low": "3.5900", "4. close":
"3.6700", "5. volume": "30491033" }, "2018-01-31": { "1. open":
"3.6800", "2. high": "3.6800", "3. low": "3.6200", "4. close":
"3.6400", "5. volume": "38593165" }, "2018-01-30": { "1. open":
"3.6000", "2. high": "3.6900", "3. low": "3.5750", "4. close":
"3.6700", "5. volume": "38783867" }, "2018-01-29": { "1. open":
"3.6100", "2. high": "3.6350", "3. low": "3.6000", "4. close":
"3.6000", "5. volume": "14138824" },
 


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

Alphavantage

[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/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: Alphavantage not an option in unknown online source list

[Elias K Gardner]

Yes gnucash was closed, I had admin rights, and I checked the spelling. I
believe thats fine because it works in gnucash now.

On Mon, Jan 1, 2018 at 6:43 PM David Carlson <david.carlson@gmail.com>
wrote:

> Elias,
>
> Have you rechecked your gnucash environment file for spelling, leading
> comment characters, etc?
>
> You did have admin rights when you edited it?
>
> Did you quit gnucash before editing it?
>
> David C
>
> On Jan 1, 2018 4:56 PM, "Elias K Gardner" <zork...@gmail.com> wrote:
>
> 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 <=== required
>   date: 12/29/2017   <=== recommended
>   currency: USD  <=== required
>   last: 1169.4700<=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> All fields returned by Finance::Quote for stock AMZN
>
> stock   field  value
> -   -  -
> AMZNclose: 1169.4700
> AMZN currency: USD
> AMZN   currency_set_by_fq: 1
> AMZN date: 12/29/2017
> AMZN     high: 1184.
> AMZN  isodate: 2017-12-29
> AMZN last: 1169.4700
> AMZN  low: 1167.5000
> AMZN   method: alphavantage
> AMZN open: 1182.3500
> AMZN  success: 1
> AMZN   symbol: AMZN
> AMZN   volume: 2625283"
>
> So does this mean that gnucash is somehow not able to access my
> alphavantage API key?
>
>
> On Mon, Jan 1, 2018 at 4:24 PM Fross, Michael <mich...@fross.org> wrote:
>
>> ​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.
>>
>> Michael
>>
>> On Mon, Jan 1, 2018 at 1:34 PM, Elias K Gardner <zork...@gmail.com>
>> wrote:
>>
>>> 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, Jan 1, 2018 at 2:13 PM David Carlson <
>>> david.carlson@gmail.com> wrote:
>>>
>>>> I think Yahoo_json is under the Single source tab in the get quotes
>>>> section of the security editor.  In GnuCash 2.6.18 Windows Alpha Vantage is
>>>> the second choice under Other.  I have not investigated updating
>>>> Finance:Quote in Linux yet, but as is mentioned in the wiki, it probably
>>>> needs to be updated separately from GnuCash.
>>>>
>>>> On Mon, Jan 1, 2018 at 12:45 PM, Elias K Gardner <zork...@gmail.com>
>>>> 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 <mich...@fross.org>
>>>>> 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 currently running on Windows and it's available in unknown
>>>>> sources so
>>>>> > I'm not much help there.
>>>>> >
>>>>> > Michael
>>>>> >
>>>>> > On Mon, Jan 1, 2018 at 11:41 AM, Elias K Gardner <zork...@gmail.com>
>>>>> > wrote:
>>>>> >
>>>>> >> 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
>>>>>

Re: Alphavantage not an option in unknown online source list

[David Carlson]

Elias,

Have you rechecked your gnucash environment file for spelling, leading
comment characters, etc?

You did have admin rights when you edited it?

Did you quit gnucash before editing it?

David C

On Jan 1, 2018 4:56 PM, "Elias K Gardner" <zork...@gmail.com> wrote:

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 <=== required
  date: 12/29/2017   <=== recommended
  currency: USD  <=== required
  last: 1169.4700<=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock AMZN

stock   field  value
-   -  -
AMZNclose: 1169.4700
AMZN currency: USD
AMZN   currency_set_by_fq: 1
AMZN date: 12/29/2017
AMZN high: 1184.
AMZN  isodate: 2017-12-29
AMZN last: 1169.4700
AMZN  low: 1167.5000
AMZN   method: alphavantage
AMZN open: 1182.3500
AMZN  success: 1
AMZN   symbol: AMZN
AMZN   volume: 2625283"

So does this mean that gnucash is somehow not able to access my
alphavantage API key?


On Mon, Jan 1, 2018 at 4:24 PM Fross, Michael <mich...@fross.org> wrote:

> ​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.
>
> Michael
>
> On Mon, Jan 1, 2018 at 1:34 PM, Elias K Gardner <zork...@gmail.com> wrote:
>
>> 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, Jan 1, 2018 at 2:13 PM David Carlson <david.carlson@gmail.com>
>> wrote:
>>
>>> I think Yahoo_json is under the Single source tab in the get quotes
>>> section of the security editor.  In GnuCash 2.6.18 Windows Alpha Vantage is
>>> the second choice under Other.  I have not investigated updating
>>> Finance:Quote in Linux yet, but as is mentioned in the wiki, it probably
>>> needs to be updated separately from GnuCash.
>>>
>>> On Mon, Jan 1, 2018 at 12:45 PM, Elias K Gardner <zork...@gmail.com>
>>> 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 <mich...@fross.org>
>>>> 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 currently running on Windows and it's available in unknown
>>>> sources so
>>>> > I'm not much help there.
>>>> >
>>>> > Michael
>>>> >
>>>> > On Mon, Jan 1, 2018 at 11:41 AM, Elias K Gardner <zork...@gmail.com>
>>>> > wrote:
>>>> >
>>>> >> 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_API_KEY=##
>>>> >> (with the actual key instead of #s) to my environment file
>>>> >> (/etc/gnucash/environment).
>>>> >> This is gnucash 2.6.17 with finance::quote 1.47 on ubuntu 17.10.
>>>> >>
>>>> > ___
>>>> >> gnucash-user mailing list
>>>> >> gnucash-user@gnucash.org
>>>> >> 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.
>>>> >>
>>>> >
>>>> >
>>>> ___
>>>> gnucash-user mailing list
>>>> gnucash-user@gnucash.org
>>>> 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.
>>>>
>>>
>>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not an option in unknown online source list

[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?). Anyway alphavantage now shows up in gnucash.
Thanks for all the help everyone.


On Mon, Jan 1, 2018 at 5:56 PM Elias K Gardner <zork...@gmail.com> wrote:

> 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 <=== required
>   date: 12/29/2017   <=== recommended
>   currency: USD  <=== required
>   last: 1169.4700<=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> All fields returned by Finance::Quote for stock AMZN
>
> stock   field  value
> -   -  -
> AMZNclose: 1169.4700
> AMZN currency: USD
> AMZN   currency_set_by_fq: 1
> AMZN date: 12/29/2017
> AMZN high: 1184.
> AMZN  isodate: 2017-12-29
> AMZN last: 1169.4700
> AMZN  low: 1167.5000
> AMZN   method: alphavantage
> AMZN open: 1182.3500
> AMZN  success: 1
> AMZN   symbol: AMZN
> AMZN   volume: 2625283"
>
> So does this mean that gnucash is somehow not able to access my
> alphavantage API key?
>
>
> On Mon, Jan 1, 2018 at 4:24 PM Fross, Michael <mich...@fross.org> wrote:
>
>> ​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.
>>
>> Michael
>>
>> On Mon, Jan 1, 2018 at 1:34 PM, Elias K Gardner <zork...@gmail.com>
>> wrote:
>>
>>> 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, Jan 1, 2018 at 2:13 PM David Carlson <
>>> david.carlson@gmail.com> wrote:
>>>
>>>> I think Yahoo_json is under the Single source tab in the get quotes
>>>> section of the security editor.  In GnuCash 2.6.18 Windows Alpha Vantage is
>>>> the second choice under Other.  I have not investigated updating
>>>> Finance:Quote in Linux yet, but as is mentioned in the wiki, it probably
>>>> needs to be updated separately from GnuCash.
>>>>
>>>> On Mon, Jan 1, 2018 at 12:45 PM, Elias K Gardner <zork...@gmail.com>
>>>> 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 <mich...@fross.org>
>>>>> 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 currently running on Windows and it's available in unknown
>>>>> sources so
>>>>> > I'm not much help there.
>>>>> >
>>>>> > Michael
>>>>> >
>>>>> > On Mon, Jan 1, 2018 at 11:41 AM, Elias K Gardner <zork...@gmail.com>
>>>>> > wrote:
>>>>> >
>>>>> >> 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?
>>

Re: Alphavantage not an option in unknown online source list

[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 <=== required
  date: 12/29/2017   <=== recommended
  currency: USD  <=== required
  last: 1169.4700<=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock AMZN

stock   field  value
-   -  -
AMZNclose: 1169.4700
AMZN currency: USD
AMZN   currency_set_by_fq: 1
AMZN date: 12/29/2017
AMZN high: 1184.
AMZN  isodate: 2017-12-29
AMZN last: 1169.4700
AMZN  low: 1167.5000
AMZN   method: alphavantage
AMZN open: 1182.3500
AMZN  success: 1
AMZN   symbol: AMZN
AMZN   volume: 2625283"

So does this mean that gnucash is somehow not able to access my
alphavantage API key?

On Mon, Jan 1, 2018 at 4:24 PM Fross, Michael <mich...@fross.org> wrote:

> ​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.
>
> Michael
>
> On Mon, Jan 1, 2018 at 1:34 PM, Elias K Gardner <zork...@gmail.com> wrote:
>
>> 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, Jan 1, 2018 at 2:13 PM David Carlson <david.carlson@gmail.com>
>> wrote:
>>
>>> I think Yahoo_json is under the Single source tab in the get quotes
>>> section of the security editor.  In GnuCash 2.6.18 Windows Alpha Vantage is
>>> the second choice under Other.  I have not investigated updating
>>> Finance:Quote in Linux yet, but as is mentioned in the wiki, it probably
>>> needs to be updated separately from GnuCash.
>>>
>>> On Mon, Jan 1, 2018 at 12:45 PM, Elias K Gardner <zork...@gmail.com>
>>> 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 <mich...@fross.org>
>>>> 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 currently running on Windows and it's available in unknown
>>>> sources so
>>>> > I'm not much help there.
>>>> >
>>>> > Michael
>>>> >
>>>> > On Mon, Jan 1, 2018 at 11:41 AM, Elias K Gardner <zork...@gmail.com>
>>>> > wrote:
>>>> >
>>>> >> 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_API_KEY=##
>>>> >> (with the actual key instead of #s) to my environment file
>>>> >> (/etc/gnucash/environment).
>>>> >> This is gnucash 2.6.17 with finance::quote 1.47 on ubuntu 17.10.
>>>> >>
>>>> > ___
>>>> >> gnucash-user mailing list
>>>> >> gnucash-user@gnucash.org
>>>> >> 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.
>>>> >>
>>>> >
>>>> >
>>>> ___
>>>> gnucash-user mailing list
>>>> gnucash-user@gnucash.org
>>>> 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.
>>>>
>>>
>>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not an option in unknown online source list

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

Michael

On Mon, Jan 1, 2018 at 1:34 PM, Elias K Gardner <zork...@gmail.com> wrote:

> 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, Jan 1, 2018 at 2:13 PM David Carlson <david.carlson@gmail.com>
> wrote:
>
>> I think Yahoo_json is under the Single source tab in the get quotes
>> section of the security editor.  In GnuCash 2.6.18 Windows Alpha Vantage is
>> the second choice under Other.  I have not investigated updating
>> Finance:Quote in Linux yet, but as is mentioned in the wiki, it probably
>> needs to be updated separately from GnuCash.
>>
>> On Mon, Jan 1, 2018 at 12:45 PM, Elias K Gardner <zork...@gmail.com>
>> 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 <mich...@fross.org> 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 currently running on Windows and it's available in unknown sources
>>> so
>>> > I'm not much help there.
>>> >
>>> > Michael
>>> >
>>> > On Mon, Jan 1, 2018 at 11:41 AM, Elias K Gardner <zork...@gmail.com>
>>> > wrote:
>>> >
>>> >> 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_API_KEY=##
>>> >> (with the actual key instead of #s) to my environment file
>>> >> (/etc/gnucash/environment).
>>> >> This is gnucash 2.6.17 with finance::quote 1.47 on ubuntu 17.10.
>>> >>
>>> > ___
>>> >> gnucash-user mailing list
>>> >> gnucash-user@gnucash.org
>>> >> 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.
>>> >>
>>> >
>>> >
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> 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.
>>>
>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not an option in unknown online source list

[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, Jan 1, 2018 at 2:13 PM David Carlson <david.carlson@gmail.com>
wrote:

> I think Yahoo_json is under the Single source tab in the get quotes
> section of the security editor.  In GnuCash 2.6.18 Windows Alpha Vantage is
> the second choice under Other.  I have not investigated updating
> Finance:Quote in Linux yet, but as is mentioned in the wiki, it probably
> needs to be updated separately from GnuCash.
>
> On Mon, Jan 1, 2018 at 12:45 PM, Elias K Gardner <zork...@gmail.com>
> 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 <mich...@fross.org> 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 currently running on Windows and it's available in unknown sources
>> so
>> > I'm not much help there.
>> >
>> > Michael
>> >
>> > On Mon, Jan 1, 2018 at 11:41 AM, Elias K Gardner <zork...@gmail.com>
>> > wrote:
>> >
>> >> 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_API_KEY=##
>> >> (with the actual key instead of #s) to my environment file
>> >> (/etc/gnucash/environment).
>> >> This is gnucash 2.6.17 with finance::quote 1.47 on ubuntu 17.10.
>> >>
>> > ___
>> >> gnucash-user mailing list
>> >> gnucash-user@gnucash.org
>> >> 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.
>> >>
>> >
>> >
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not an option in unknown online source list

[Elias K Gardner]

gnc-fq-check returns 1.47 as the first value in quotes I believe this means
I have version 1.47.

On Mon, Jan 1, 2018 at 1:47 PM Derek Atkins <de...@ihtfp.com> wrote:

> What version of F::Q do you have installed?
>
> -derek
> Sent using my mobile device. Please excuse any typos.
>
>
>
> On January 1, 2018 1:45:51 PM Elias K Gardner <zork...@gmail.com> 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 <mich...@fross.org> 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 currently running on Windows and it's available in unknown sources
> so
> >> I'm not much help there.
> >>
> >> Michael
> >>
> >> On Mon, Jan 1, 2018 at 11:41 AM, Elias K Gardner <zork...@gmail.com>
> >> wrote:
> >>
> >>> 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_API_KEY=##
> >>> (with the actual key instead of #s) to my environment file
> >>> (/etc/gnucash/environment).
> >>> This is gnucash 2.6.17 with finance::quote 1.47 on ubuntu 17.10.
> >>>
> >> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> 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.
> >>>
> >>
> >>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > 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.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not an option in unknown online source list

[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 <mich...@fross.org> 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 currently running on Windows and it's available in unknown sources so
> I'm not much help there.
>
> Michael
>
> On Mon, Jan 1, 2018 at 11:41 AM, Elias K Gardner <zork...@gmail.com>
> wrote:
>
>> 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_API_KEY=##
>> (with the actual key instead of #s) to my environment file
>> (/etc/gnucash/environment).
>> This is gnucash 2.6.17 with finance::quote 1.47 on ubuntu 17.10.
>>
> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage Not Showing Up In List Sources

[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 having this problem.


GnuCash v2.6.17
F::Q v1.47
Ubuntu 17.10



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Mutual funds quote not working after moving to alphavantage

[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 gnucash
managed to retrieve a price, it was in pence so 100 times too large for
gnucash to use.

I got the same result using gnc-fq-dump...

gnc-fq-dump mstaruk GB00B4PQW151
Finance::Quote fields Gnucash uses:
symbol: GB00B4PQW151 <=== required
  date: 12/11/2017   <=== recommended
  currency: GBP  <=== required
  last: 191.08   <=\
   nav: 191.08   <=== one of these
 price: 191.08   <=/
  timezone:  <=== optional

Regards,

Richard.



signature.asc
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Mutual funds quote not working after moving to alphavantage

[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 using gnc-fq-dump returns mm/dd/

Any help would be greatly appreciated

On 9 December 2017 at 19:28, Richard Ullger  wrote:

> 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 'Type of quote
> source' as 'Morningstar GB'
>
> > 2. The quotes I get running gnc-fq-dump mstaruk are for the 12/08/17. Is
> > this correct?
>
> Yes, that is Friday 8 Dec, the last day the market was open.
>
>


-- 
Kind Regards,

Andrea Beddoni


___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Mutual funds quote not working after moving to alphavantage

[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 'Type of quote
source' as 'Morningstar GB'

> 2. The quotes I get running gnc-fq-dump mstaruk are for the 12/08/17. Is
> this correct?

Yes, that is Friday 8 Dec, the last day the market was open.



signature.asc
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Mutual funds quote not working after moving to alphavantage

[Andrea Beddoni]

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
2. The quotes I get running gnc-fq-dump mstaruk are for the 12/08/17. Is
this correct?

Thanks for your help

On 9 December 2017 at 18:05, Richard Ullger <rull...@gmail.com> 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 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 get the message that Gnucash is
> > unable to retrieve quotes for all the funds
>
> Try mstaruk quote source for UK funds, except on a weekend when prices
> are 100 times too large (in pence).
>
> gnc-fq-dump mstaruk GB00B4PQW151
> Finance::Quote fields Gnucash uses:
> symbol: GB00B4PQW151 <=== required
>   date: 12/08/2017   <=== recommended
>   currency: GBP  <=== required
>   last: 190.12   <=\
>nav: 190.12   <=== one of these
>  price: 190.12   <=/
>   timezone:  <=== optional
>
> When downloaded during the week they are ok for use in gnucash (ie £1.9012)
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
>



-- 
Kind Regards,

Andrea Beddoni

<https://uk.linkedin.com/pub/andrea-beddoni/19/46b/470>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Mutual funds quote not working after moving to alphavantage

[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. GB00B4PQW151) are not retrieved.
> 
> When trying to get the online quotes I get the message that Gnucash is
> unable to retrieve quotes for all the funds

Try mstaruk quote source for UK funds, except on a weekend when prices
are 100 times too large (in pence).

gnc-fq-dump mstaruk GB00B4PQW151
Finance::Quote fields Gnucash uses:
symbol: GB00B4PQW151 <=== required
  date: 12/08/2017   <=== recommended
  currency: GBP  <=== required
  last: 190.12   <=\
   nav: 190.12   <=== one of these
 price: 190.12   <=/
  timezone:  <=== optional

When downloaded during the week they are ok for use in gnucash (ie £1.9012)



signature.asc
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Mutual funds quote not working after moving to alphavantage

[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 get the message that Gnucash is
unable to retrieve quotes for all the funds

Any help on how to fix this would be greatly appreciated.

Thanks
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage Not Showing Up In List Sources

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



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage Not Showing Up In List Sources

[Dale Alspach]

I have this working. Here is what I have but it seems to be the same as
what you have except the version of Finance::Quote.

Mint 18.2
GnuCash 2.6.12  This copy was built from rev ed11f6d+ on 2016-04-18
perl: /usr/bin/perl5.22-x86_64-linux-gnu

Tail of /etc/gnucash/environment

# If you wish 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" "amfiindia" "asegr" "asia"
"asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil"
"bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse"
"deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity"
"fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner"
"finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct"
"fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary"
"hustock" "indiamutual" "known_currencies" "lerevenu" "maninv"
"morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx"
"platinum" "romania" "seb_funds" "sixfunds" "sixshares"
"stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk"
"troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts"
"ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo"
"yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
"yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")

Security editor window shot attached.

Dale


On 12/04/2017 02:36 PM, yf wrote:
> I have the same problem, too.
> 
> I used Mint 18.2
> gnucash 2.6.17
> Finance::Quote 1.47
> Pear 5.22.1
> 
> had added ALPHAVANTAGE API key in the end of the environment file,
> but the ALPHAVANTAGE didn't list at the security quote source.
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage Not Showing Up In List Sources

[yf]

I have the same problem, too.

I used Mint 18.2
gnucash 2.6.17
Finance::Quote 1.47
Pear 5.22.1

had added ALPHAVANTAGE API key in the end of the environment file,
but the ALPHAVANTAGE didn't list at the security quote source.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage Not Showing Up In List Sources

[jdfoote]

I am having this same problem. did you figure it out?

How can I tell whether GnuCash is using the new package?

(I'm on Ubuntu 17.10)



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

Alphavantage intermittently failing to return ASX quotes

[prl]

I'm having problems this morning (3 Dec 11:30 Eastern Australian Summer 
time, 3 Dec 00:30 UTC) with Alphavantage intermittently failing to 
return quotes for the four ASX (Australian Stock Exchange) stocks that 
we hold:


gnc-fq-dump -v alphavantage CBA.AX IAG.AX QAN.AX TLS.AX
Finance::Quote fields Gnucash uses:
    symbol: CBA.AX   <=== required
  date: 11/30/2017   <=== recommended
  currency: AUD  <=== required
  last: 79.1700  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock CBA.AX

stock   field  value
-   -  -
CBA.AX  close: 79.1700
CBA.AX   currency: AUD
CBA.AX currency_set_by_fq: 1
CBA.AX   date: 11/30/2017
CBA.AX   high: 79.9500
CBA.AX    isodate: 2017-11-30
CBA.AX   last: 79.1700
CBA.AX    low: 78.8800
CBA.AX method: alphavantage
CBA.AX   open: 79.7100
CBA.AX    success: 1
CBA.AX symbol: CBA.AX
CBA.AX volume: 2462019

=

Finance::Quote fields Gnucash uses:
    symbol: IAG.AX   <=== required
  date: 11/30/2017   <=== recommended
  currency: AUD  <=== required
  last: 7.1200   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock IAG.AX

stock   field  value
-   -  -
IAG.AX  close: 7.1200
IAG.AX   currency: AUD
IAG.AX currency_set_by_fq: 1
IAG.AX   date: 11/30/2017
IAG.AX   high: 7.2200
IAG.AX    isodate: 2017-11-30
IAG.AX   last: 7.1200
IAG.AX    low: 7.1050
IAG.AX method: alphavantage
IAG.AX   open: 7.2000
IAG.AX    success: 1
IAG.AX symbol: IAG.AX
IAG.AX volume: 3320131

=


Finance::Quote fields Gnucash uses:
    symbol: QAN.AX (deduced) <=== required
  date: ** missing **    <=== recommended
  currency: ** missing **    <=== required
  last:  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock QAN.AX

stock   field  value
-   -  -
QAN.AX   errormsg: json_data doesn't contain Last Refreshed
QAN.AX   last: **missing**
QAN.AX    nav: **missing**
QAN.AX  price: **missing**
QAN.AX    success: 0

=


Finance::Quote fields Gnucash uses:
    symbol: TLS.AX (deduced) <=== required
  date: ** missing **    <=== recommended
  currency: ** missing **    <=== required
  last:  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock TLS.AX

stock   field  value
-   -  -
TLS.AX   errormsg: json_data doesn't contain Last Refreshed
TLS.AX   last: **missing**
TLS.AX    nav: **missing**
TLS.AX  price: **missing**
TLS.AX    success: 0

It's not always the same stocks that fail. Occasionally I get them all.

Is anyone else seeing this sort of behaviour from Alphavantage?

Peter

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not working in gnucash 2.6.17

[Patrick Alken]

On 11/28/2017 12:01 PM, John Ralls wrote:
> gnucash -log gnc.scm=debug

Thank you! This told me which stock symbol was causing the problem. It
turns out I missed one single stock which was still set to yahoo which
caused the error.

As a feature request, it would be incredibly useful if there was a
"default" source for online quotes, so the user can set individual
stocks to use the default source (alphavantage). This way when we want
to switch to a new quote source we just have to change where the default
setting points to.

Of course individual securities should still be able to be customized to
use a different source if needed. Such a feature would have saved me a
lot of time!

Anyway thanks for making this great software.

Patrick

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not working in gnucash 2.6.17

[John Ralls]

> On Nov 28, 2017, at 9:30 AM, Patrick Alken <al...@colorado.edu> wrote:
> 
> I always start it from the command line. The --debug option didn't show 
> anything in the log file related to quotes
> 
> On 11/28/2017 10:27 AM, John Ralls wrote:
>> 
>>> On Nov 28, 2017, at 8:46 AM, Patrick Alken <al...@colorado.edu> wrote:
>>> 
>>> My OS is Ubuntu linux 17.10
>>> 
>>> and I installed F::Q via CPAN (gnc-fq-dump and gnc-fq-helper work ok from 
>>> the commandline with alphavantage)
>>> 
>>> On 11/28/2017 07:50 AM, John Ralls wrote:
>>>>> On Nov 27, 2017, at 9:57 PM, Patrick Alken <al...@colorado.edu> wrote:
>>>>> 
>>>>> Apologies if this has already been asked, but I couldn't find this exact
>>>>> issue in the recent mailings.
>>>>> 
>>>>> I have:
>>>>> 
>>>>> gnucash: 2.6.17
>>>>> 
>>>>> F::Q: 1.47
>>>>> 
>>>>> My F::Q works from the command line:
>>>>> 
>>>>> --
>>>>> 
>>>>> $ gnc-fq-dump alphavantage CSCO
>>>>> Finance::Quote fields Gnucash uses:
>>>>> symbol: CSCO <=== required
>>>>>   date: 11/27/2017   <=== recommended
>>>>>   currency: USD  <=== required
>>>>>   last: 36.8700  <=\
>>>>>nav:  <=== one of these
>>>>>  price:  <=/
>>>>>   timezone:  <=== optional
>>>>> --
>>>>> 
>>>>> However inside gnucash price editor I still get the "unknown error when
>>>>> retrieving price quotes".
>>>>> 
>>>>> I have unchecked the "Get Online Quotes" flag from ALL of my stocks in
>>>>> the security editor. However the price editor still gives me the same
>>>>> error (unknown error).
>>>>> 
>>>>> gnucash --debug shows nothing related to quotes. I only get lines like 
>>>>> this:
>>>>> 
>>>>> ----
>>>>> 
>>>>> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/1
>>>>> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  
>>>>> baln=0/100
>>>>> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  
>>>>> baln=0/100
>>>>> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  
>>>>> baln=0/100
>>>>> 
>>>>> 
>>>>> 
>>>>> Can anyone advise how to diagnose the issue?
>>>> What OS and how did you install F::Q?
>> 
>> Do you normally start GnuCash from the command line? If not, does quote 
>> retrieval work if you do?


Right. To get debug messages from the price import code run `gnucash -log 
gnc.scm=debug`. I don't know if that will yield anything useful.

You might also see if `echo "(alphavantage CSCO)" | gnc-fq-helper` yields any 
errors.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not working in gnucash 2.6.17

[Patrick Alken]

I always start it from the command line. The --debug option didn't show 
anything in the log file related to quotes


On 11/28/2017 10:27 AM, John Ralls wrote:



On Nov 28, 2017, at 8:46 AM, Patrick Alken <al...@colorado.edu> wrote:

My OS is Ubuntu linux 17.10

and I installed F::Q via CPAN (gnc-fq-dump and gnc-fq-helper work ok from the 
commandline with alphavantage)

On 11/28/2017 07:50 AM, John Ralls wrote:

On Nov 27, 2017, at 9:57 PM, Patrick Alken <al...@colorado.edu> wrote:

Apologies if this has already been asked, but I couldn't find this exact
issue in the recent mailings.

I have:

gnucash: 2.6.17

F::Q: 1.47

My F::Q works from the command line:

--

$ gnc-fq-dump alphavantage CSCO
Finance::Quote fields Gnucash uses:
 symbol: CSCO <=== required
   date: 11/27/2017   <=== recommended
   currency: USD  <=== required
   last: 36.8700  <=\
nav:  <=== one of these
  price:  <=/
   timezone:  <=== optional
--

However inside gnucash price editor I still get the "unknown error when
retrieving price quotes".

I have unchecked the "Get Online Quotes" flag from ALL of my stocks in
the security editor. However the price editor still gives me the same
error (unknown error).

gnucash --debug shows nothing related to quotes. I only get lines like this:



* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/1
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100



Can anyone advise how to diagnose the issue?

What OS and how did you install F::Q?


Do you normally start GnuCash from the command line? If not, does quote 
retrieval work if you do?

Regards,
John Ralls



___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not working in gnucash 2.6.17

[John Ralls]

> On Nov 28, 2017, at 8:46 AM, Patrick Alken <al...@colorado.edu> wrote:
> 
> My OS is Ubuntu linux 17.10
> 
> and I installed F::Q via CPAN (gnc-fq-dump and gnc-fq-helper work ok from the 
> commandline with alphavantage)
> 
> On 11/28/2017 07:50 AM, John Ralls wrote:
>> 
>>> On Nov 27, 2017, at 9:57 PM, Patrick Alken <al...@colorado.edu> wrote:
>>> 
>>> Apologies if this has already been asked, but I couldn't find this exact
>>> issue in the recent mailings.
>>> 
>>> I have:
>>> 
>>> gnucash: 2.6.17
>>> 
>>> F::Q: 1.47
>>> 
>>> My F::Q works from the command line:
>>> 
>>> --
>>> 
>>> $ gnc-fq-dump alphavantage CSCO
>>> Finance::Quote fields Gnucash uses:
>>> symbol: CSCO <=== required
>>>   date: 11/27/2017   <=== recommended
>>>   currency: USD  <=== required
>>>   last: 36.8700  <=\
>>>nav:  <=== one of these
>>>  price:  <=/
>>>   timezone:  <=== optional
>>> --
>>> 
>>> However inside gnucash price editor I still get the "unknown error when
>>> retrieving price quotes".
>>> 
>>> I have unchecked the "Get Online Quotes" flag from ALL of my stocks in
>>> the security editor. However the price editor still gives me the same
>>> error (unknown error).
>>> 
>>> gnucash --debug shows nothing related to quotes. I only get lines like this:
>>> 
>>> 
>>> 
>>> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/1
>>> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
>>> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
>>> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
>>> 
>>> 
>>> 
>>> Can anyone advise how to diagnose the issue?
>> What OS and how did you install F::Q?


Do you normally start GnuCash from the command line? If not, does quote 
retrieval work if you do?

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not working in gnucash 2.6.17

[Patrick Alken]

My OS is Ubuntu linux 17.10

and I installed F::Q via CPAN (gnc-fq-dump and gnc-fq-helper work ok 
from the commandline with alphavantage)


On 11/28/2017 07:50 AM, John Ralls wrote:



On Nov 27, 2017, at 9:57 PM, Patrick Alken <al...@colorado.edu> wrote:

Apologies if this has already been asked, but I couldn't find this exact
issue in the recent mailings.

I have:

gnucash: 2.6.17

F::Q: 1.47

My F::Q works from the command line:

--

$ gnc-fq-dump alphavantage CSCO
Finance::Quote fields Gnucash uses:
 symbol: CSCO <=== required
   date: 11/27/2017   <=== recommended
   currency: USD  <=== required
   last: 36.8700  <=\
nav:  <=== one of these
  price:  <=/
   timezone:  <=== optional
--

However inside gnucash price editor I still get the "unknown error when
retrieving price quotes".

I have unchecked the "Get Online Quotes" flag from ALL of my stocks in
the security editor. However the price editor still gives me the same
error (unknown error).

gnucash --debug shows nothing related to quotes. I only get lines like this:



* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/1
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100



Can anyone advise how to diagnose the issue?

What OS and how did you install F::Q?

Regards,
John Ralls



___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Alphavantage not working in gnucash 2.6.17

[John Ralls]

> On Nov 27, 2017, at 9:57 PM, Patrick Alken <al...@colorado.edu> wrote:
> 
> Apologies if this has already been asked, but I couldn't find this exact
> issue in the recent mailings.
> 
> I have:
> 
> gnucash: 2.6.17
> 
> F::Q: 1.47
> 
> My F::Q works from the command line:
> 
> --
> 
> $ gnc-fq-dump alphavantage CSCO
> Finance::Quote fields Gnucash uses:
> symbol: CSCO <=== required
>   date: 11/27/2017   <=== recommended
>   currency: USD  <=== required
>   last: 36.8700  <=\  
>nav:  <=== one of these
>  price:  <=/   
>   timezone:  <=== optional
> --
> 
> However inside gnucash price editor I still get the "unknown error when
> retrieving price quotes".
> 
> I have unchecked the "Get Online Quotes" flag from ALL of my stocks in
> the security editor. However the price editor still gives me the same
> error (unknown error).
> 
> gnucash --debug shows nothing related to quotes. I only get lines like this:
> 
> 
> 
> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/1
> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
> * 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
> 
> 
> 
> Can anyone advise how to diagnose the issue?

What OS and how did you install F::Q?

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Finance::Quote still not working with alphavantage

[Frank Saporito]

Hi Greg

Is this what you are looking for?

$ ONLINE_TEST=1 prove -lvof t/alphavantage.t
Cannot determine source for t/alphavantage.t at
/usr/share/perl5/App/Prove.pm line 496

thanks



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