Re: [GNC] Online Price Retrieval Fails

[nvsoar]

On 09/05/18 17:27, John Ralls wrote:



On Sep 5, 2018, at 12:26 PM, nvsoar  wrote:

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


Run the Online Price Retrieval Setup program. Date::Manip is a required perl 
module.

Regards,
John Ralls



That's what did not work.  Downloaded v2.6.21; went GnuCash menu and 
selected "Install Online Price Retrieval for GnuCash."  This action 
resulted in the message above at the end of the process. Observing the 
process running on the terminal showed a message similar to "could not 
find DateManip" part way through.


I apologize for not being clear in the initial report.

All the best,
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] Negative assets!

[John Ralls]

> On Sep 5, 2018, at 5:51 PM, Muhammad Bashir Al-Noimi  
> wrote:
> 
> On 09/06/2018 03:25 AM, John Ralls wrote:
>> That’s Assets:Current Assets on the Accounts page, right? Not an entry in 
>> the summary bar at the bottom of the page?
> YES; It's an account in Accounts tree defined as a placeholder.
> 
>> Might you have hidden accounts with negative balances?
> I'm pretty sure all the sub accounts in Assets are in positive values.

Well, make completely sure. With the accounts page open, select View>Filter 
By... and make sure that all of the account types are selected on the “Account 
Type" tab and that Show hidden accounts is selected on the “Other” tab. There’s 
another way to get there as well: You can select Current Assets and select 
Edit>Open Subaccounts, which will open a register showing all of the 
transactions from Current Assets and all of its sub accounts in the normal 
order. That might help you see the transactions that drive it to a negative 
balance.

How much is the discrepancy? IOW, if you add up all of the (positive) totals 
showing in the first-level sub accounts and then add the opposite of the 
(negative) total showing in Current Assets, what’s the difference?

Are there any transactions in Current Assets? Being a placeholder prevents you 
from adding transactions from the register, but there are other ways that 
transactions can get into it, including being transferred there when you delete 
a sub-account. Double clicking on it won’t work because it’s a placeholder so 
you have to use Edit>Open Account or pick Open from the context menu when 
Current Assets is selected.

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.

Re: [GNC] Balance Sheet Issue

[Paul Schwartz]

I have stocks that either distribute cash as return-of-capital or report
income/losses that change the basis of the stock. The balance sheet in
2.6.12 calculates the proper value for the stock. 2.6.19 does not.

Paul

On Wed, Sep 5, 2018 at 5:44 PM Stephen M. Butler  wrote:

> I'm out of ideas.  I ended up modifying the Eguile version to get the
> behavior my wife wanted.
>
> What is it that the report isn't doing?
>
>
> On 09/05/2018 10:19 AM, Paul Schwartz wrote:
> > First added balance-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@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.
> >
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
>
___
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] [OT] Why is Debit abbreviated Dr?

[prl]

For what it's worth, both my oldish Macquarie Australian Dictionary and 
my even older Shorter Oxford agree that Dr is an abbreviation for 
debtor. Neither gives any etymology for the abbreviation and the Oxford 
doesn't give any historical reference for it. The online free Oxford 
dictionary https://en.oxforddictionaries.com/definition/dr gives it as a 
abbreviation for debit without any further information.


Peter


On 6/09/2018 00:58, David Cousens wrote:

Derek

Latin past participles of creditum and debitum are debere and credere are a 
possible 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 learned 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@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] Negative assets!

[Muhammad Bashir Al-Noimi]

   On 09/06/2018 03:25 AM, John Ralls wrote:

   That’s Assets:Current Assets on the Accounts page, right? Not an entry
   in the summary bar at the bottom of the page?

   YES; It's an account in Accounts tree defined as a placeholder.

   Might you have hidden accounts with negative balances?

   I'm pretty sure all the sub accounts in Assets are in positive values.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] Online Price Retrieval Fails

[John Ralls]

> On Sep 5, 2018, at 12:26 PM, nvsoar  wrote:
> 
> 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
> 

Run the Online Price Retrieval Setup program. Date::Manip is a required perl 
module.

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.

Re: [GNC] Negative assets!

[John Ralls]

> On Sep 5, 2018, at 8:09 AM, Muhammad Bashir Al-Noimi  
> wrote:
> 
> On 09/05/2018 06:06 PM, Muhammad Bashir Al-Noimi wrote:
>> On 09/04/2018 05:55 PM, John Ralls wrote:
>>> When you deleted the accounts, what did you tell GnuCash to do with the 
>>> transactions?
>> I don't remember exactly.
>> 
>>> Do you have any Imbalance-XXX accounts?
>> Yes I've these accounts but they are empty.
> BTW, All the accounts are correct. I couldn't find any strange transaction 
> just the negative -red- value of "Current Assets" account.

That’s Assets:Current Assets on the Accounts page, right? Not an entry in the 
summary bar at the bottom of the page?

Might you have hidden accounts with negative balances?

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.

Re: [GNC] Balance Sheet Issue

[John Ralls]

> On Sep 5, 2018, at 10:19 AM, Paul Schwartz  wrote:
> 
> First added balance-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.

It was there, otherwise the report wouldn’t have worked at all. The default 
price source also changed in there somewhere so make sure that it’s Average 
Cost.

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] Finance Quotes Using Yahoo json

[Dan Nelms]

Thanks for your help.

I went to my Windows directory where gnc-fq-dump resides.

I entered:

perl gnc-fq-dump -v yahoo_json JPM

It sucessfully returned the price for JPM. So I guess the Perl code is
working.

However, Price Editor in GnuCash still says Unable to retrieve.



___
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] Balance Sheet Issue

[Stephen M. Butler]

I'm out of ideas.  I ended up modifying the Eguile version to get the
behavior my wife wanted.

What is it that the report isn't doing?


On 09/05/2018 10:19 AM, Paul Schwartz wrote:
> First added balance-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@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.
>

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Nabble Editor

[David Cousens]

Derek,

My problem seemed to be a result of either the interaction between Nabble
and Mailman and may even get down to the settings users are using in the
editor to compose mail putting in hard returns. The Nabble interface itself
is a scaleable window and only soft wraps on display at the window edge.  I
was putting hard returns in at the end of lines which were greater than a
limit of ~ 75 characters. Perhaps a post created on Nabble is sent to
Mailman and then echoed back to Nabble for display and somewhere in that
trip a line length limit is imposeed

Apparently Hugo who setup the original Nabble forum mirror of the GnuCash
archives and was listed as its administrator is no longer associated with
Nabble. They have asked if someone on the GnuCash side wanted to take over
reponsibility for administering it, as the Nabble interface is now an orphan
on their end.

When I get free of a few things I am working on out of the way I will try
and experiment and see if I can more clearly identify what caused my issue.

David



-
David Cousens
--
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] [OT] Why is Debit abbreviated Dr?

[David Cousens]

On Wed, 2018-09-05 at 16:08 +0100, 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

I think that pretty well sums up the arguments between various accountancy 
historians.

David
___
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] re-adding billable expenses to an invoice

[Matthew Pounsett]

I accidentally flubbed some keyboard entry while putting together an
invoice and messed up a billable expense item which had been automatically
added when the invoice was created.  Since there is no "Undo" the best
option seemed to be to delete the entry and start over, but I can't find a
way to instruct GnuCash to add billable items to an invoice.  It seems to
do it automatically at invoice creation, and no other way.

Am I missing something?

GnuCash 2.6.21.

Thanks!
   Matt
___
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] [OT] Why is Debit abbreviated Dr?

[David Cousens]

Geoff

On Wed, 2018-09-05 at 20:42 +0200, Geoff Jankowski via gnucash-user wrote:
> 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. 

I don't find the above really counterintuitive. It treats the cash book and 
bank account  as though they were someone
else holding your money for you, i.e. (who owes us). There is obviously an 
implicit assumption both on behalf of the
cashbox and the bank that when we take money out (who we owe) that we are going 
to have to put it back at some point. We
do that in a sense when we purchase an asset and enter the value of the asset 
as a debit entry in the account that
records it or as a debit entry in an Expense account.

Luca Pacciola, who was Leonardo DaVinci's maths tutor, was the first to make it 
less of a black art by spelling out the
mathematical basis behind double entry accounting in a codified sense. My own 
background is in mathematics and physics
but I did an accountancy degree several years before I retired, so once the 
accounting equation was laid out, what had
previously been an arcane mystery while accounting for a business I ran, 
suddenly became clear to me.

Jane Gleeson White's book, Double Entry: How the merchants of Venice shaped the 
modern world is an interesting read on
the history. The recorded western historical literature on accounting goes back 
to the Babylonian cultures and what
survives is mainly associated with recording tax collections and disbursements. 
Both the Japanese and Chinese also have
recorded accounting systems very early on.

Benedikta Kotruljevića's work, Book on the Art of Trade, originally written in 
1458 in handwritten form in Croatia, but
not published and more widely distributed until the mid 1500s (which is 
possibly why Pacciola received all the credit), 
has been recently re-relased in translation. Pacciola's treatise, really on 
mathematics not accounting specifically, was
widely translated and distributed throughout Europe shortly after being 
originally released.

David
___
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] Downloading Ciurrency Prices

[Les]

Hoping someone can help.  I am using GC 2.6.17 on Linux Mint 18.2.  Up 
till 20180904, I was getting quotes for AUD, CAD, HKD and USD.  
Beginning 20180904, I am no longer obtaining quotes for AUD and CAD.  (I 
only have the above quotes set in Security Editor due to Alphavantage's 
limit of 4.


Sometime back, it was recommended to switch to Yahoo as Json. That 
solved my stock quotes in multiple jurisdictions.  Now the problem is 
currencies. :-(


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] gnucash-user Digest, Vol 186, Issue 14

[bnichol12 via gnucash-user]

 
 

 
 Here you go!
 
 
 

 
 
 
 
 
>  
> On Sep 5, 2018 at 3:36 PM,wrote:
>  
>  
>  Send gnucash-user mailing list submissions to gnucash-user@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-requ...@gnucash.org You 
> can reach the person managing the list at gnucash-user-ow...@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.ellenber...@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  

Re: [GNC] [OT] Why is Debit abbreviated Dr?

[Stephen M. Butler]

On 09/05/2018 12:05 PM, Christian Kluge wrote:
> Am 05.09.2018 um 20:42 schrieb Geoff Jankowski via gnucash-user:
>> 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. 
> 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.
>>  

Which is why I, as a software/database guy, just cringe when my wife,
the accountant, yells out, "You reversed the journal entries again!"

I tried to reason it out know I got it wrong last time by trying to
reason it out from the time before when I also got it wrong.  I'm no
longer sure that three rights make a left.  I'm pretty sure that two
rights make a U turn of which I am doing a lot lately.
> 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 regards
>
>
> Christian Kluge
>
> ___
> 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.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] [OT] Why is Debit abbreviated Dr?

[Roger Miskowicz]

I thought that debit and credit only existed in double entry accounting and
simply identified columns as either Left or Right?

On Wed, Sep 5, 2018 at 2:43 PM Geoff Jankowski via gnucash-user <
gnucash-user@gnucash.org> wrote:

> 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 possible 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 learned 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@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:
> 

Re: [GNC] Finance Quotes Using Yahoo json

[Dale Alspach]

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   symbol: 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 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

[GNC] Online Price Retrieval Fails

[nvsoar]

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

___
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] [OT] Why is Debit abbreviated Dr?

[Christian Kluge]

Am 05.09.2018 um 20:42 schrieb Geoff Jankowski via gnucash-user:
> 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. 

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 regards


Christian Kluge

___
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] [OT] Why is Debit abbreviated Dr?

[Mike or Penny Novack]

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

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
___
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] [OT] Why is Debit abbreviated Dr?

[Christian Kluge]

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

___
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] [OT] Why is Debit abbreviated Dr?

[Geoff Jankowski via gnucash-user]

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 
>> possible 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 learned 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@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] Balance Sheet Issue

[Paul Schwartz]

First added balance-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@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 Quotes Using Yahoo json

[Dan Nelms]

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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your 

Re: [GNC] Finance Quotes Using Yahoo json

[Fross, Michael]

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 <
>> frank.h.ellenber...@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
>>>
>>>
>>
>>
>
>
___
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] Negative assets!

[Muhammad Bashir Al-Noimi]

   On 09/05/2018 06:06 PM, Muhammad Bashir Al-Noimi wrote:

   On 09/04/2018 05:55 PM, John Ralls wrote:

When you deleted the accounts, what did you tell GnuCash to do with the transact
ions?

 I don't remember exactly.

Do you have any Imbalance-XXX accounts?

 Yes I've these accounts but they are empty.

   BTW, All the accounts are correct. I couldn't find any strange
   transaction just the negative -red- value of "Current Assets" account.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] [OT] Why is Debit abbreviated Dr?

[Colin Law]

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 
> possible 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 learned 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@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] Negative assets!

[Muhammad Bashir Al-Noimi]

   On 09/04/2018 05:55 PM, John Ralls wrote:

When you deleted the accounts, what did you tell GnuCash to do with the transact
ions?

   I don't remember exactly.


Do you have any Imbalance-XXX accounts?

   Yes I've these accounts but they are empty.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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] [OT] Why is Debit abbreviated Dr?

[David Cousens]

Derek

Latin past participles of creditum and debitum are debere and credere are a 
possible 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 learned 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@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 Quotes Using Yahoo json

[Dan Nelms]

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

___
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] [OT] Why is Debit abbreviated Dr?

[Geoff Jankowski via gnucash-user]

Debtor = dr
Creditor = cr




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 15:59, 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
> 
> -- 
>   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>   Member, MIT Student Information Processing Board  (SIPB)
>   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>   warl...@mit.eduPGP key available
> ___
> 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] [OT] Why is Debit abbreviated Dr?

[Derek Atkins]

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

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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 Quotes Using Yahoo json

[Fross, Michael]

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 <
> frank.h.ellenber...@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
>>
>>
>
>
___
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] GNC] Chart of Accounts sort order in v3.2 - Help

[Alan Maddocks]

I re-installed version 2.6.6 and that has 3 Account sort options: the choice of 
alphabetical and reverse alphabetical and also the order that the accounts were 
entered in.  I have already spent time entering the account codes.  As you have 
mentioned the many problems reported with version 3.x and Windows, I think I 
will stick with version 2.6.6 for the time being.

Regards,

Alan.

-Original Message-
From: Stan Brown  
Sent: 04 September 2018 23:03
To: gnucash-user@gnucash.org
Cc: sunfis...@yahoo.com; alan.maddo...@hotmail.co.uk
Subject: Re: GNC] Chart of Accounts sort order in v3.2 - Help

I can confirm that the change did NOT happen between 2.x and 3.2.  I have 
2.6.19, and when I click on Amount Name, in the Accounts tab, I get only the 
choice of alphabetical and reverse alphabetical. GTK3 has seemed like a step 
backwards in user convenience, in several matters, but this is not one of them. 
(I don't blame the GC developers for keeping current with GTK; I blame the GTK 
developers.)

I understand, Alan, that you don't want to spend time entering account codes. 
But it would not be just for the sorting of the Accounts view.
You can also use the account code, just like the name, when entering 
transactions in the registers. (That's true in 2.6.19; I haven't tried 3.x 
because so many problems have been reported with that version and Windows 
operating system. Hopefully they'll be fixed in 3.3.)

--
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.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] UK Shares and Yahoo as JSON

[Eric Coates]

Graham

I have used Morningstar GB sucessfully for Unit Trust prices for quite a 
while now.


I've just tried it for (a selection of my UK) shares but no luck.

Thanks for the suggestion.

Eric

On 05/09/18 07:03, Graham Balin wrote:

Have you tried single-Morningstar GB as your source?

Cheerio

Graham

On Tue, 4 Sep 2018, 8:15 pm Eric Coates, > wrote:


Hi

Context: I’m running GnuCash 2.16.7 on Ubuntu 1604 with
Finance-Quote 1.47.

Like many others I have been using AlphaVantage as the source for my
online share price retrievals and been experiencing difficulties.
Following up on hints in the mailing list I have tried using
Single/Yahoo as JSON as an alternative source.

Having set the source as Single/Yahoo as JSON for all my shares and
clicking Get Quotes I got very rich! Unfortunately, a quick
investigation revealed that, although my European shares had received
(what looked like) good quotes, the prices received for my UK shares
come back 100 times too big.

As I have relatively few shares and usually only update the prices at
the end of the month it is not totally ridiculous to input UK share
prices by hand. But it would be so much nicer to be able to do it
automatically.

Assuming that others are having the same problem with UK shares and
Yahoo as JSON (are they?), is there a known (and hopefully simple)
way
to correct the Yahoo prices?

I wonder if there is a possible alternative: It has been hinted here
that GnuCash 3 has a much improved CSV importer and (if I understand
properly) it is possible to input share prices using it. It would be
possible to get the list of shares and their prices from my broker
account. Is the GnuCash 3 importer documented (I can't find
anything) so
as to make the import easy? (But that means upgrading and, again, my
ignorance means I need simple instructions.)

As always, my thanks to the developers and the documentation team and
other users of this list for their time and efforts

Best wishes

Eric

PS: Please forgive this aside:

On the Securities Editor page, for me, it is not possible to
un-tick the
box in the Get Quote column. Should it be?

___
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] GNC] Chart of Accounts sort order in v3.2 - Help

[Fred Bone]

On 04 September 2018 at 18:03, Stan Brown said:

> I can confirm that the change did NOT happen between 2.x and 3.2.  I
> have 2.6.19, and when I click on Amount Name, in the Accounts tab, I get
> only the choice of alphabetical and reverse alphabetical. 

I'm running 2.6.21 (on Windows 10) and I see three orders for account 
name. I have mine in alphabetical order (first top level is Assets); one 
click on the heading results in reverse alphabetical; second click puts 
"Income" first; third click back where we started.

I haven't tried 3.x yet.


___
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] UK Shares and Yahoo as JSON

[Graham Balin]

Have you tried single-Morningstar GB as your source?

Cheerio

Graham

On Tue, 4 Sep 2018, 8:15 pm Eric Coates,  wrote:

> Hi
>
> Context: I’m running GnuCash 2.16.7 on Ubuntu 1604 with Finance-Quote 1.47.
>
> Like many others I have been using AlphaVantage as the source for my
> online share price retrievals and been experiencing difficulties.
> Following up on hints in the mailing list I have tried using
> Single/Yahoo as JSON as an alternative source.
>
> Having set the source as Single/Yahoo as JSON for all my shares and
> clicking Get Quotes I got very rich! Unfortunately, a quick
> investigation revealed that, although my European shares had received
> (what looked like) good quotes, the prices received for my UK shares
> come back 100 times too big.
>
> As I have relatively few shares and usually only update the prices at
> the end of the month it is not totally ridiculous to input UK share
> prices by hand. But it would be so much nicer to be able to do it
> automatically.
>
> Assuming that others are having the same problem with UK shares and
> Yahoo as JSON (are they?), is there a known (and hopefully simple) way
> to correct the Yahoo prices?
>
> I wonder if there is a possible alternative: It has been hinted here
> that GnuCash 3 has a much improved CSV importer and (if I understand
> properly) it is possible to input share prices using it. It would be
> possible to get the list of shares and their prices from my broker
> account. Is the GnuCash 3 importer documented (I can't find anything) so
> as to make the import easy? (But that means upgrading and, again, my
> ignorance means I need simple instructions.)
>
> As always, my thanks to the developers and the documentation team and
> other users of this list for their time and efforts
>
> Best wishes
>
> Eric
>
> PS: Please forgive this aside:
>
> On the Securities Editor page, for me, it is not possible to un-tick the
> box in the Get Quote column. Should it be?
>
> ___
> 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.