[GNC] gnucash-user Digest, Vol 186, Issue 14

bnichol12 bnichol12 at aol.com
Wed Sep 5 17:41:33 EDT 2018


 
 

 
 Here you go!
 
 
 

 
 
 
 
 
>  
> On Sep 5, 2018 at 3:36 PM,  <gnucash-user-request>  wrote:
>  
>  
>  Send gnucash-user mailing list submissions to gnucash-user at gnucash.org 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 gnucash-user-request at gnucash.org You can reach the person managing the list at gnucash-user-owner at gnucash.org 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  <   >>  frank.h.ellenberger at gmail.com>  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:  <94850103-34ca-42aa-959a-cada37770524 at gmail.com>  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: jralls at ceridwen.us Cc: kg7je at arrl.net, gnucash-user at gnucash.org 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  >  gnucash-user at 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.  >  ------------------------------ 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:  <929AAF0C-03E7-4E0C-96AB-63E426E75B1B at me.com>  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  >>  gnucash-user at 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 at gnucash.org  >  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: gnucash-user at lists.gnucash.org 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: gnucash-user at gnucash.org Subject: Re: [GNC] [OT] Why is Debit abbreviated Dr? Message-ID:  <5B9026C2.7080403 at dialup4less.com>  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: gnucash-user at lists.gnucash.org 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: gnucash-user at gnucash.org 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: gnucash-user at gnucash.org 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  >  gnucash-user at 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.  >  ------------------------------ Subject: Digest Footer _______________________________________________ gnucash-user mailing list gnucash-user at 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. ------------------------------ End of gnucash-user Digest, Vol 186, Issue 14 ********************************************* 
>  
     


More information about the gnucash-user mailing list