Here you go!
 
 
 

 
 
 
 
 
>  
> On Sep 5, 2018 at 3:36 PM,  <gnucash-user-request>  wrote:
>  
>  
>  Send gnucash-user mailing list submissions to [email protected] To 
> subscribe or unsubscribe via the World Wide Web, visit 
> https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a 
> message with subject or body 'help' to [email protected] You 
> can reach the person managing the list at [email protected] When 
> replying, please edit your Subject line so it is more specific than "Re: 
> Contents of gnucash-user digest..." Today's Topics: 1. Re: Finance Quotes 
> Using Yahoo json (Fross, Michael) 2. Re: Finance Quotes Using Yahoo json (Dan 
> Nelms) 3. Re: Balance Sheet Issue (Paul Schwartz) 4. Re: [OT] Why is Debit 
> abbreviated Dr? (Geoff Jankowski) 5. Re: [OT] Why is Debit abbreviated Dr? 
> (Christian Kluge) 6. Re: [OT] Why is Debit abbreviated Dr? (Mike or Penny 
> Novack) 7. Re: [OT] Why is Debit abbreviated Dr? (Christian Kluge) 8. Online 
> Price Retrieval Fails (nvsoar) 9. Re:  Finance Quotes Using Yahoo json (Dale 
> Alspach) ----------------------
------------------------------------------------ Message: 1 Date: Wed, 5 Sep 
2018 11:15:06 -0500 From: "Fross, Michael" To: Dan Nelms Cc: "Frank H. 
Ellenberger" , Gnucash-User Subject: Re: [GNC] Finance Quotes Using Yahoo json 
Message-ID: Content-Type: text/plain; charset="UTF-8" Don't know what else to 
try other than perhaps some of the other F:Q quote sources. Of course after 
this discussion, I'm sure my Yahoo_JSON quotes will soon start to fail....... 
:-) Michael On Wed, Sep 5, 2018 at 9:54 AM, Dan Nelms wrote:  >  Hi Michael,  > 
  >  I tried your securities (ACN and FBIOX) with yahoo_json. Got unable to  >  
retrieve...  >   >  I tried a couple of my securities with alphavantage. It 
worked fine.  >   >  I tried your sec with Yahoo together with mine with alphaV 
at same time.  >  It got mine and yours were unable...  >   >  I tried your 
securities with alphaV and got the prices fine.  >   >  Results are the price 
database is working and alphavantage is working, but  >  for me Yahoo
 json fails in all cases.  >   >  Dan  >   >  On 9/5/2018 6:09 AM, Fross, 
Michael wrote:  >   >  Hello Dan,  >   >  I just looked at my GNC Price 
Database and the following quotes are  >  returned successfully for me with 
Yahoo_JSON. Why don't you try a few of  >  these and see if they work for you. 
They are current as of September 4,  >  2018 for me.  >   >  Stock: ACN  >  
Fund: FBIOX, FBMPX, FCYIX  >   >  Regards,  >   >  Michael  >   >  On Tue, Sep 
4, 2018 at 3:29 PM, Dan Nelms wrote:  >   >>  Thanks Michael for your comments 
about using Yahoo_json for some of your  >>  security quotes. My needs are also 
very mild, but they number more than 4.  >>   >>  I am running GnuCash version 
3.2, Finance::Quote 1.47 (Strawberry) on a  >>  Windows 10 machine.  >>   >>  I 
tried using Yahoo_json with the GnuCash security editor and each time I  >>  
get the "could not get quotes for the following...." message. I tried 2  >>  
mutual funds, 2 NYSE stocks and 1 NASDAQ stock. They all failed. I tri
ed  >>  closing and restarting Gnucash just to be the changes in the security  
>>  editor got loaded, still all failures. Yahoo_json is either not working for 
 >>  me or I am doing something wrong. Damn, I was hoping for an easy solution. 
 >>   >>  Alphavantage works fine but only for the first 4 securities.  >>   >> 
 Dan  >>   >>  On 9/3/2018 6:59 AM, Fross, Michael wrote:  >>   >>  Hello Dan,  
>>   >>  My needs are fairly mild, but yes I currently use Yahoo_JSON for all 
of  >>  my quotes. Most of my investments are in US mutual funds although I do  
>>  have several individual stocks.  >>   >>  I simply use "*Single: Yahoo as 
JSON"* in the security editor. I had  >>  switched to AlphaVantage when 
everyone else did and it worked most of the  >>  time, although it was very 
slow. I think it's worse now so I'm happy  >>  Yahoo_JSON continues to 
work...at least for the time being. I pull down 37  >>  quotes, so not that 
many but if Alphavantage allows 5 quotes / min, it  >>  would take m
e 7+ minutes do download those.  >>   >>  Now I don't believe it will handle 
currencies and I'm not sure about  >>  non-US exchanges, but this does work for 
me. You can always do the ones it  >>  supports via Yahoo_JSON and just the 
others via AlphaVantage depending on  >>  your situation.  >>   >>  Michael  >> 
  >>  On Sun, Sep 2, 2018 at 8:10 PM, Frank H. Ellenberger  <   >>  
[email protected]>  wrote:  >>   >>>  Hi Dan,  >>>   >>>  Am 
03.09.2018 um 00:10 schrieb Dan Nelms:  >>>   >  Micheal, I noticed in one of 
your replies to a user having  >>>  Finance:Quote  >>>   >  problems that are 
still getting quotes from Yahoo_json for most of your  >>>   >  quotes. Are you 
doing that through the GnuCash Security setup? If so  >>>   >  what button do 
you use, ie Single, Multiple or Unknown? I would like to  >>>   >  try it. 
Thanks. Dan  >>>   >>>  RTFM:  >>>  
https://code.gnucash.org/docs/C/gnucash-help/fq-sources.html  >>>  
#idm139753655191424  >>>  ;-)  >>>   >>>  Frank  >>>
   >>>   >>   >>   >   >  ------------------------------ Message: 2 Date: Wed, 
5 Sep 2018 09:31:19 -0700 From: Dan Nelms To: "Fross, Michael" Cc: "Frank H. 
Ellenberger" , Gnucash-User Subject: Re: [GNC] Finance Quotes Using Yahoo json 
Message-ID:  <[email protected]>  Content-Type: 
text/plain; charset=utf-8 Could I be missing some type of variable setting in 
the environment file? I know that when I first setup AlphaVantage (before the 
update to 3.2) I had to put my Alphavantage key in the environment file. Since 
Yahoo was not an option when 3.2 came out, maybe a variable that made Yahoo 
work before got deleted from the upgrade? I only throw this out because it is 
way over my head technically, but maybe somebody knows something about this. 
Just grasping at straws with insufficient knowledge. On 9/5/2018 9:15 AM, 
Fross, Michael wrote:  >  Don't know what else to try other than perhaps some 
of the other F:Q  >  quote sources.? Of course after this discussion
, I'm sure my  >  Yahoo_JSON quotes will soon start to fail....... :-)  >   >  
Michael  >   >  On Wed, Sep 5, 2018 at 9:54 AM, Dan Nelms  >  wrote:  >   >  Hi 
Michael,  >   >  I tried your securities (ACN and FBIOX) with yahoo_json. Got  
>  unable to retrieve...  >   >  I tried a couple of my securities with 
alphavantage. It worked fine.  >   >  I tried your sec with Yahoo together with 
mine with alphaV at same  >  time. It got mine and yours were unable...  >   >  
I tried your securities with alphaV and got the prices fine.  >   >  Results 
are the price database is working and alphavantage is  >  working, but for me 
Yahoo json fails in all cases.  >   >  Dan  >   >   >  On 9/5/2018 6:09 AM, 
Fross, Michael wrote:  >>  Hello Dan,  >>   >>  I just looked at my GNC Price 
Database and the following quotes  >>  are returned successfully for me with 
Yahoo_JSON.? Why don't you  >>  try a few of these and see if they work for 
you.? They are  >>  current as of September 4, 2018 for me.  >>   
>>  Stock:? ACN  >>  Fund: FBIOX, FBMPX, FCYIX  >>   >>  Regards,  >>   >>  
>> Michael  >>   >>  On Tue, Sep 4, 2018 at 3:29 PM, Dan Nelms  >   >  wrote:  
>> >>   >>  Thanks Michael for your comments about using Yahoo_json for  >>  
>> some of your security quotes. My needs are also very mild,  >>  but they 
>> number more than 4.  >>   >>  I am running GnuCash version 3.2, 
>> Finance::Quote 1.47  >>  (Strawberry) on a Windows 10 machine.  >>   >>  I 
>> tried using Yahoo_json with the GnuCash security editor and  >>  each time I 
>> get the "could not get quotes for the  >>  following...." message. I tried 2 
>> mutual funds, 2 NYSE stocks  >>  and 1 NASDAQ stock. They all failed. I 
>> tried closing and  >>  restarting Gnucash just to be the changes in the 
>> security  >>  editor got loaded, still all failures. Yahoo_json is either  
>> >>  not working for me or I am doing something wrong. Damn, I was  >>  
>> hoping for an easy solution.  >>   >>  Alphavantage works fine but only for 
>> the first 4 securities.  >>   >>  Dan  >
>   >>   >>  On 9/3/2018 6:59 AM, Fross, Michael wrote:  >>>  Hello Dan,  >>>   
> >>>  My needs are fairly mild, but yes I currently use Yahoo_JSON  >>>  for 
> all of my quotes.? Most of my investments are in US  >>>  mutual funds 
> although I do have several individual stocks.??  >>>   >>>  I simply use 
> "*Single: Yahoo as JSON"* in the security  >>>  editor.? I had switched to 
> AlphaVantage when everyone else  >>>  did and it worked most of the time, 
> although it was very  >>>  slow.? I think it's worse now so I'm happy 
> Yahoo_JSON  >>>  continues to work...at least for the time being.? I pull  
> >>>  down 37 quotes, so not that many but if Alphavantage allows  >>>  5 
> quotes / min, it would take me 7+ minutes do download those.  >>>   >>>  Now 
> I don't believe it will handle currencies and I'm not  >>>  sure about non-US 
> exchanges, but this does work for me.? You  >>>  can always do the ones it 
> supports via Yahoo_JSON and just  >>>  the others via AlphaVantage depending 
> on your situation.  >>> 
  >>>  Michael  >>>   >>>  On Sun, Sep 2, 2018 at 8:10 PM, Frank H. Ellenberger 
 >>>   >>   >  wrote:  >>>   >>>  Hi Dan,  >>>   >>>  Am 03.09.2018 um 00:10 
schrieb Dan Nelms:  >>>   >  Micheal, I noticed in one of your replies to a 
user  >>>  having Finance:Quote  >>>   >  problems that are still getting 
quotes from Yahoo_json  >>>  for most of your  >>>   >  quotes. Are you doing 
that through the GnuCash  >>>  Security setup? If so  >>>   >  what button do 
you use, ie Single, Multiple or  >>>  Unknown? I would like to  >>>   >  try 
it. Thanks. Dan  >>>   >>>  RTFM:  >>>  
https://code.gnucash.org/docs/C/gnucash-help/fq-sources.html#idm139753655191424 
 >>>   >>>  ;-)  >>>   >>>  Frank  >>>   >>>   >>   >>   >   >  
------------------------------ Message: 3 Date: Wed, 5 Sep 2018 11:19:43 -0600 
From: Paul Schwartz To: [email protected] Cc: [email protected], 
[email protected] Subject: Re: [GNC] Balance Sheet Issue Message-ID: 
Content-Type: text/plain; charset="UTF-8" First added ba
lance-sheet.scm and then commodity-utilities.scm. There was no 
commodity-utilities.scm file in the .19 release. The report changed but it 
didn't give the same result as the .12 version. Any more suggestions? Thanks 
Paul On Tue, Sep 4, 2018 at 9:34 PM John Ralls wrote:  >   >   >   >  On Sep 4, 
2018, at 4:05 PM, Stephen M. Butler wrote:  >   >   >   >  On 09/04/2018 02:53 
PM, Paul Schwartz wrote:  >   >>  If I want to reproduce the Balance Sheet 
Report I get from version  >  2.6.12  >   >>  in version 2.6.19, are there 
files that I can othe copy from one to the  >   >>  other?  >   >>   >   >>  
Paul  >   >  I forgot which OS you have. On Ubuntu (local build) they are in  > 
  >  /usr/local/share/gnucash/scm/gnucash/report/standard-reports  >   >   >   
>  I think it is one file (if you are talking about the non-eguile one):  >   > 
 balance_sheet.scm (try searching your installed software location).  >   >   > 
  >  The eguile version is up one level from there.  >   >  You may also want 
files from .../report/report-system, in particular  >  commodity-utilities.scm. 
 >   >  Regards,  >  John Ralls  >  
_______________________________________________  >  gnucash-user mailing list  
>  [email protected]  >  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.  >  ------------------------------ Message: 4 
Date: Wed, 05 Sep 2018 20:42:50 +0200 From: Geoff Jankowski To: gnucash-user 
Subject: Re: [GNC] [OT] Why is Debit abbreviated Dr? Message-ID:  
<[email protected]>  Content-Type: text/plain; 
charset=utf-8 David I would love to agree with you but?.. In standard journal 
notation cr is a debt and dr an asset. This is because it is nothing 
to do with credit (+ve) and debit (-ve) in any sense (or tense) but to do with 
a creditor (to whom we owe) and a debtor (who owes us). Hence dr and cr relate 
to debtor and creditor and not to any form of debit or credit. For example, if 
I take cash from the cash box and deposit it at the bank I enter a cr to the 
cashbook and a dr to the bank account. Totally counterintuitive which is why 
accountancy is a black art and should be banned. I am also an engineer that has 
been a finance director for many years (but that does not necessarily give me 
the right to write what is right). Geoff +44 20 7100 1092 +44 7770 58 48 38 +33 
5 46 97 13 89 +33 6 22 93 00 53  >  On 5 Sep 2018, at 17:08, Colin Law wrote:  
>   >  Wow, well now we know (or actually don't know), but we know we don't  >  
know in great depth and detail :)  >   >  Colin  >  On Wed, 5 Sep 2018 at 
16:01, David Cousens wrote:  >>   >>  Derek  >>   >>  Latin past participles of 
creditum and debitum are debere and credere are a possib
le explanation. Another theory is the  >>  Dr stands for debit record and Cr 
credit record. Another is that Dr is from debtors and Cr is from creditors. I 
favour  >>  the first because Luca Pacciola who is often attributed (wrongly) 
with the first known treatise in 1494 (Summa de  >>  Arithmetica, Geometria, 
Proportioni et Proportionalita) which had a section on double entry accounting 
and formulated  >>  the first documented use of the accounting equation used 
the terms debere (to owe) and credere (to entrust) to describe  >>  the two 
sides of the basic accounting equation but there is also evidence that Pacciola 
used Per (from) and A (to) in  >>  journal entries. I don't know if any 
originals of Pacciola's original treatise have survived and most of the 
comments  >>  are from an English translation in 1633 where Handson used Dr 
from the English debtor. Another translator Geejsbeek in  >>  1914 suggested Dr 
comes from "in dare" (give) and "in havere" (receive). Pacciola apparently l
earned his accounting from  >>  Arab traders in North Africa where his father 
was a merchant. Benedikt Kotruljevic in 1458 also described double entry  >>  
accounting in a 1458 work on the Art of Trade published in Dubrovnik. I suspect 
both were describing methodology used by  >>  the Arab traders.There is also 
evidence that double entry might have been used in 10th century Muslim tax 
office but  >>  there is no definitive evidence. We will probably never know 
where the usage of the notation actually came from and the  >>  historians will 
continue to argue about it forever.  >>  David Cousens  >>   >>   >>   >>  On 
Wed, 2018-09-05 at 09:59 -0400, Derek Atkins wrote:  >>>  Hi All,  >>>   >>>  
I'm an Engineer by training; I've picked up a ton of accounting  >>>  knowledge 
just by being involved here for the past few decades, but  >>>  there's one 
thing I've seen recently that I honestly don't underdstand  >>>  and would 
appreciate if a CPA or Accounting Historian could answer.  >>>   >
>>  Specifically, I've seen people show a transaction as:  >>>   >>>  Dr ... / 
>> Cr ...  >>>   >>>  So CR as an abbreviation for Credit makes sense to me 
>> (CRedit). But why  >>>  is Debit abbreviated as DR? There is no "R" in 
>> DEBIT. So where does  >>>  that come from? I would have expected it to be 
>> "Db".  >>>   >>>  Just curious.  >>>   >>>  -derek  >>>   >>  
>> _______________________________________________  >>  gnucash-user mailing 
>> list  >>  [email protected]  >>  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  >  [email protected]  >  To update your subscription 
>> preferences or to u
nsubscribe:  >  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. ------------------------------ Message: 5 
Date: Wed, 5 Sep 2018 20:50:49 +0200 From: Christian Kluge To: 
[email protected] Subject: Re: [GNC] [OT] Why is Debit abbreviated 
Dr? Message-ID: Content-Type: text/plain; charset=utf-8 Hi Am 05.09.2018 um 
16:58 schrieb David Cousens:  >  Derek  >   >  [?] the first documented use of 
the accounting equation used the terms debere (to owe) and credere (to entrust) 
to describe  >  the two sides of the basic accounting equation but there is 
also evidence that Pacciola used Per (from) and A (to) in  >  journal entries. 
He just used ?Per? and ?A? in journal entries. Apparently a similiar form of 
journal entry was also used in Engl
ish just with words ?By? and ?To? which sounds nicer than saying credit and 
debit all the time. https://archive.org/stream/studiesinhistory00litt#page/223  
>  I don't know if any originals of Pacciola's original treatise have survived 
[?]  >  Another translator Geejsbeek in  >  1914 suggested Dr comes from "in 
dare" (give) and "in havere" (receive). His translation, with facsimilies of 
Pacioli?s original can be read here: 
https://archive.org/details/ancientdoubleent00geijuoft Kind regards Christian 
Kluge ------------------------------ Message: 6 Date: Wed, 05 Sep 2018 14:56:02 
-0400 From: Mike or Penny Novack To: [email protected] Subject: Re: 
[GNC] [OT] Why is Debit abbreviated Dr? Message-ID:  
<[email protected]>  Content-Type: text/plain; charset=UTF-8; 
format=flowed On 9/5/2018 2:42 PM, Geoff Jankowski via gnucash-user wrote:  >  
David  >   >  I would love to agree with you but?..  >   >  In standard journal 
notation cr is a debt and dr an asset. This is bec
ause it is nothing to do with credit (+ve) and debit (-ve) in any sense (or 
tense) but to do with a creditor (to whom we owe) and a debtor (who owes us). 
Hence dr and cr relate to debtor and creditor and not to any form of debit or 
credit.  >  Ah but it does, and will make sense once you realize that the 
origins of double entry goes back in time long enough that educated Europeans 
still used Latin for some purposes. Not "a debit" or "a credit" but Latin for 
"he owes" (me) and "he trusts" (me). Thus assets were debits (amounts somebody 
owed one) and liabilities credits (what one owed somebody). Michael D Novack 
------------------------------ Message: 7 Date: Wed, 5 Sep 2018 21:05:15 +0200 
From: Christian Kluge To: [email protected] Subject: Re: [GNC] 
[OT] Why is Debit abbreviated Dr? Message-ID: Content-Type: text/plain; 
charset=utf-8 Am 05.09.2018 um 20:42 schrieb Geoff Jankowski via gnucash-user:  
>  David  >   >  I would love to agree with you but?..  >   >  In standar
d journal notation cr is a debt and dr an asset. This is because it is nothing 
to do with credit (+ve) and debit (-ve) in any sense (or tense) but to do with 
a creditor (to whom we owe) and a debtor (who owes us). Hence dr and cr relate 
to debtor and creditor and not to any form of debit or credit.  >   >  For 
example, if I take cash from the cash box and deposit it at the bank I enter a 
cr to the cashbook and a dr to the bank account. Actually you should a transit 
account for the period in between taking and out of the cash box and that 
journal entry and the day the bank actually books this deposit on your banking 
statement.  >  Totally counterintuitive which is why accountancy is a black art 
and should be banned. Every form of accounting assumes that the debit side will 
give its value back one day as the original Italian formulations ?deve dare? 
?shall give? and ?deve avere? ?shall have?, everyone knows that?s never going 
to happen but still, nothing counterintuitive there. Kind re
gards Christian Kluge ------------------------------ Message: 8 Date: Wed, 5 
Sep 2018 12:26:59 -0700 From: nvsoar To: [email protected] Subject: 
[GNC] Online Price Retrieval Fails Message-ID: Content-Type: text/plain; 
charset=utf-8; format=flowed Running Win 10 - Install online price retrieval 
(GnuCash version 2.6.21) reports DateManip could not be found; reports the 
following at the end. * Run gnc-fq-helper Can't locate Date/Manip.pm in @INC 
(you may need to install the Date::Manip module) (@INC contains: 
C:/strawberry/perl/site/lib C:/strawberry/perl/vendor/lib 
C:/strawberry/perl/lib .) at gnc-fq-helper line 29. BEGIN failed--compilation 
aborted at gnc-fq-helper line 29. An error occurred, see above. Press any key 
to continue . . . Have know idea for the meaning of @INC, or where to put the 
Date::Manip module. Same fault for GnuCash version 2.6.17 Please advise. Thank 
you for your assistance. nvsoar ------------------------------ Message: 9 Date: 
Wed, 5 Sep 2018 14:36:19 -05
00 From: Dale Alspach To: [email protected] Subject: Re: [GNC] Finance 
Quotes Using Yahoo json Message-ID: Content-Type: text/plain; charset=utf-8 
Have you tried to see whether the perl code itself works? (Below is on linux 
but something similar should work in perl on windows.) Assuming you have 
fnc-fq-dump installed, from a command prompt something like (perhaps prefixed 
by perl. See https://wiki.gnucash.org/wiki/Online_Quotes) gnc-fq-dump -v 
yahoo_json CSCO should yield Finance::Quote fields Gnucash uses: symbol: CSCO  
<=== required date: 09/05/2018  <=== required currency: USD  <=== required 
last: 47.365  <=\ nav:  <=== one of these price:  <=/ timezone:  <=== optional 
All fields returned by Finance::Quote for stock CSCO stock field value ----- 
----- ----- CSCO currency: USD CSCO date: 09/05/2018 CSCO exchange: Sourced 
from Yahoo Finance (as JSON) CSCO isodate: 2018-09-05 CSCO last: 47.365 CSCO 
method: yahoo_json CSCO name: CSCO (Cisco Systems, Inc.) CSCO success: 1 CSCO sy
mbol: CSCO CSCO type: EQUITY CSCO volume: 13728025 Dale On 09/05/2018 11:31 AM, 
Dan Nelms wrote:  >  Could I be missing some type of variable setting in the 
environment  >  file? I know that when I first setup AlphaVantage (before the 
update to  >  3.2) I had to put my Alphavantage key in the environment file. 
Since  >  Yahoo was not an option when 3.2 came out, maybe a variable that made 
 >  Yahoo work before got deleted from the upgrade? I only throw this out  >  
because it is way over my head technically, but maybe somebody knows  >  
something about this. Just grasping at straws with insufficient knowledge.  >   
>   >  On 9/5/2018 9:15 AM, Fross, Michael wrote:  >>  Don't know what else to 
try other than perhaps some of the other F:Q  >>  quote sources.? Of course 
after this discussion, I'm sure my  >>  Yahoo_JSON quotes will soon start to 
fail....... :-)  >>   >>  Michael  >>   >>  On Wed, Sep 5, 2018 at 9:54 AM, Dan 
Nelms  >   >  wrote:  >>   >>  Hi Michael,  >>   >>  I tried yo
ur securities (ACN and FBIOX) with yahoo_json. Got  >>  unable to retrieve...  
>>   >>  I tried a couple of my securities with alphavantage. It worked fine.  
>>   >>  I tried your sec with Yahoo together with mine with alphaV at same  >> 
 time. It got mine and yours were unable...  >>   >>  I tried your securities 
with alphaV and got the prices fine.  >>   >>  Results are the price database 
is working and alphavantage is  >>  working, but for me Yahoo json fails in all 
cases.  >>   >>  Dan  >>   >>   >>  On 9/5/2018 6:09 AM, Fross, Michael wrote:  
>>>  Hello Dan,  >>>   >>>  I just looked at my GNC Price Database and the 
following quotes  >>>  are returned successfully for me with Yahoo_JSON.? Why 
don't you  >>>  try a few of these and see if they work for you.? They are  >>> 
 current as of September 4, 2018 for me.  >>>   >>>  Stock:? ACN  >>>  Fund: 
FBIOX, FBMPX, FCYIX  >>>   >>>  Regards,  >>>   >>>  Michael  >>>   >>>  On 
Tue, Sep 4, 2018 at 3:29 PM, Dan Nelms  >>   >  wrote:  >>
>   >>>  Thanks Michael for your comments about using Yahoo_json for  >>>  some 
> of your security quotes. My needs are also very mild,  >>>  but they number 
> more than 4.  >>>   >>>  I am running GnuCash version 3.2, Finance::Quote 
> 1.47  >>>  (Strawberry) on a Windows 10 machine.  >>>   >>>  I tried using 
> Yahoo_json with the GnuCash security editor and  >>>  each time I get the 
> "could not get quotes for the  >>>  following...." message. I tried 2 mutual 
> funds, 2 NYSE stocks  >>>  and 1 NASDAQ stock. They all failed. I tried 
> closing and  >>>  restarting Gnucash just to be the changes in the security  
> >>>  editor got loaded, still all failures. Yahoo_json is either  >>>  not 
> working for me or I am doing something wrong. Damn, I was  >>>  hoping for an 
> easy solution.  >>>   >>>  Alphavantage works fine but only for the first 4 
> securities.  >>>   >>>  Dan  >>>   >>>   >>>  On 9/3/2018 6:59 AM, Fross, 
> Michael wrote:  >>>>  Hello Dan,  >>>>   >>>>  My needs are fairly mild, but 
> yes I current
ly use Yahoo_JSON  >>>>  for all of my quotes.? Most of my investments are in 
US  >>>>  mutual funds although I do have several individual stocks.??  >>>>   
>>>>  I simply use "*Single: Yahoo as JSON"* in the security  >>>>  editor.? I 
had switched to AlphaVantage when everyone else  >>>>  did and it worked most 
of the time, although it was very  >>>>  slow.? I think it's worse now so I'm 
happy Yahoo_JSON  >>>>  continues to work...at least for the time being.? I 
pull  >>>>  down 37 quotes, so not that many but if Alphavantage allows  >>>>  
5 quotes / min, it would take me 7+ minutes do download those.  >>>>   >>>>  
Now I don't believe it will handle currencies and I'm not  >>>>  sure about 
non-US exchanges, but this does work for me.? You  >>>>  can always do the ones 
it supports via Yahoo_JSON and just  >>>>  the others via AlphaVantage 
depending on your situation.  >>>>   >>>>  Michael  >>>>   >>>>  On Sun, Sep 2, 
2018 at 8:10 PM, Frank H. Ellenberger  >>>>   >>>   >  wrote:  >>>>
   >>>>  Hi Dan,  >>>>   >>>>  Am 03.09.2018 um 00:10 schrieb Dan Nelms:  >>>>  
 >  Micheal, I noticed in one of your replies to a user  >>>>  having 
Finance:Quote  >>>>   >  problems that are still getting quotes from Yahoo_json 
 >>>>  for most of your  >>>>   >  quotes. Are you doing that through the 
GnuCash  >>>>  Security setup? If so  >>>>   >  what button do you use, ie 
Single, Multiple or  >>>>  Unknown? I would like to  >>>>   >  try it. Thanks. 
Dan  >>>>   >>>>  RTFM:  >>>>  
https://code.gnucash.org/docs/C/gnucash-help/fq-sources.html#idm139753655191424 
 >>>>   >>>>  ;-)  >>>>   >>>>  Frank  >>>>   >>>>   >>>   >>>   >>   >>   >   
>  _______________________________________________  >  gnucash-user mailing 
list  >  [email protected]  >  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.  >  ------------------------------ 
Subject: Digest Footer _______________________________________________ 
gnucash-user mailing list [email protected] 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. ------------------------------ End 
of gnucash-user Digest, Vol 186, Issue 14 
********************************************* 
>  
     
_______________________________________________
gnucash-user mailing list
[email protected]
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.

Reply via email to