Re: Trading Accounts for Securities

When I set up a trading account for a USD stock, gnucash diligently added transactions in the trading account for the stock and for USD. The stock trading account simply tracks the number of shares in the account (which is what the asset account for the stock already does). The USD trading account

Re: Purpose of Accounting Period? Benefit to closing books?

> > > -- Forwarded message -- > From: Mike or Penny Novack > To: gnucash-user@gnucash.org > Cc: > Bcc: > Date: Thu, 22 Feb 2018 17:35:43 -0500 > Subject: Re: Purpose of Accounting Period? Benefit to closing books? > On 2/22/2018 4:21 PM, Dan

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

Thanks for the explanation Larry.  Now I understand.  I just don't know why I am unable to update currency quotes since 02/13/2018. Perhaps Alphavantage is just not robust enough to support all the users of GC plus what they were supporting before Yahoo went south last year. I appreciate what

Finance-Quote 1.47 Unable to retrieve Currency quotes

If you take a look in the Quote.pm perl module, the currency conversion method calls the alpha vantage CURRENCY_EXCHANGE_RATE function. As far as I can see this is the *only* source of exchange rate data available in Finance::Quote (at least assuming you are using version 1.47). Given this, any

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

You can't change the quote source for currencies. Currency retrieval in Finance::Quote needs two symbols, one for each currency, while stock symbols require only one. Finance::Quote has the currency source hardwired: Formerly to Yahoo! now to Alphavantage. I was able to get a currency price

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

I forgot to add that the last update I received for currencies (all 9 of them) was 02/13/2018. On 02/22/2018 03:09 AM, ln.mailingli...@iinet.net.au wrote: Hi Richard, It's definitely alphavantage for currency - you can check the data URL early in the Quote.pm module. I'd agree with Adriano's

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

Maybe I am missing something but when I go to Security Editor, click on currencies and then select unknown and then alphavantage and save it reverts back to single, currency. So how is the quote (when I get one) coming from alphavantage? Confused, Les On 02/22/2018 03:09 AM,

Re: Purpose of Accounting Period? Benefit to closing books?

On 2/22/2018 4:21 PM, Dan Carpenter wrote: Adrien, general accounting principles close the books at the end of the fiscal year. This process in most accounting software updates the Equity with the profit or loss balances and then zeros the income and expense accounts to begin fresh for the

Re: gnu cash v 2.6.19 on Mac OS X 10.13.3 Income Expense problem solved.

No probs, glad you got it sorted. Cheers Dave H On 23 Feb. 2018 7:48 am, "Dan Carpenter" wrote: > OK, it is now working. When I first set up the “Sales” top level I must > have missed the account type somehow. Thank you for your time. I did > check out the

Re: Purpose of Accounting Period? Benefit to closing books?

2018-02-22 15:01, Adrien Monteleone wrote: > ... > This comes in handy when you are entering historical data and need to run > several reports. By defining the period in Preferences, you get this as the > default date range for reports like the Income Statement, otherwise, you’d > have to set

Re: Purpose of Accounting Period? Benefit to closing books?

Dan, Yes, I know of these practices. They are not always necessary depending on the use case or the software. Gnucash is such an example. The reports in Gnucash roll Income and Expenses into Equity automatically, without closing books. While other software does retain the end of period data

Re: gnu cash v 2.6.19 on Mac OS X 10.13.3

Dan, You’re seeing that for the following reason: The account you currently have highlighted is NOT an income/expense account. Gnucash defaults to creating a new account as a sub account of the one which is currently selected. Select either the main expense account, or a sub-account of

Re: Purpose of Accounting Period? Benefit to closing books?

On 2018-02-22 14:15, Derek Atkins wrote: > You must be reading old manuals. I read what's on line, and what installed with 2.6.19. > Closing the books just zeros out the Income and Expense accounts, rolling > them up into Equity. The reports can do this on their own, so really the > only

Re: Purpose of Accounting Period? Benefit to closing books?

Adrien, general accounting principles close the books at the end of the fiscal year. This process in most accounting software updates the Equity with the profit or loss balances and then zeros the income and expense accounts to begin fresh for the new year. I am just starting with testing

Re: gnu cash v 2.6.19 on Mac OS X 10.13.3

> On Feb 22, 2018, at 1:05 PM, Dan Carpenter wrote: > > Thank you Dave H. for your quick response. > > The Account Type display box shows only: Bank, Cash, Asset, Credit Card, > Liability, Stock, Mutual Fund, A/Receivable and A/Payable. > > “Expense" and “Income"

Re: gnu cash v 2.6.19 on Mac OS X 10.13.3

Thank you Dave H. for your quick response. The Account Type display box shows only: Bank, Cash, Asset, Credit Card, Liability, Stock, Mutual Fund, A/Receivable and A/Payable. “Expense" and “Income" are NOT showing up in the Account Type box. That is my question. How do I fix that?

Re: gnu cash v 2.6.19 on Mac OS X 10.13.3

Click on Accounts tab if not already the focus, click New icon (Create a New Account), select "New top level account" in Parent Account listbox, select "Expense" in Account Type listbox and click OK to create a top level expense account, Then create your expense accounts under the top level

gnu cash v 2.6.19 on Mac OS X 10.13.3

Hello, While attempting to set up a chart of accounts, account type does not include Income or Expense. Is there a fix or a table I can update? Thank you. I am testing this system for simple accounting/bookkeeping for a friend’s small business. Dan

Re: Purpose of Accounting Period? Benefit to closing books?

> On Feb 22, 2018, at 1:11 PM, Stan Brown wrote: > > New user here. I understand double-entry accounting pretty well, but I'm > struggling to adapt that knowledge to GnuCash's take on double-entry > accounting. > > Why do we specify an accounting period? How is it

Re: Purpose of Accounting Period? Benefit to closing books?

Hi, You must be reading old manuals. Closing the books just zeros out the Income and Expense accounts, rolling them up into Equity. The reports can do this on their own, so really the only benefit is that your Income and Expense accounts will return to $0 instead of showing you a grand total

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

Thank you Adrien. Your comments have been very helpful. I'm running IIS and MySQL on my PC as I do some database work... having moved from Micrsoft Access... but I don't want to make all our small staff to have to be running a server and mysql. The way we have it setup is the gnuCash file is

Re: Printing no longer works on Windows 10 Pro

My Windows 7 computer has now become inconsistent in the specific failure. This morning I tried the check printing module again and printing a report and somewhere in the sequence I got a "not enough memory" error and GnuCash crashed. This machine has 24 Gig of RAM and 296 Gig free on the C

Re: One account for both Income and Expenses possible?

Looking over the Wiki, I see this point was left out, so I added this text to the netiquette section. It’s a bit wordy, but I wanted users to understand why this is the preferred method. (since those who would do otherwise, obviously don’t understand the implications of disrupting threads) "If

Re: Trading Accounts for Securities

Thanks, Derek. I get that. I guess trading accounts do not provide for a use case I need. Keith On Wed, Feb 21, 2018 at 12:10 PM, Derek Atkins wrote: > Hi, > > Trading accounts do not show you UNREALIZED gains. They exist to help you > balance out REALIZED gains once you

Re: Monthly Billings Report ? (How much business did we book/Invoice during month X)

Hi, Fran_3 via gnucash-user writes: > Re: Converting to MySQL... > When I develop in MySQL on Windows I install IIS localhost server and > MySQL... but that is not practical on other office computers. > 1 - I'm not familiar with sqLite but a quick Google makes me

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

Cunning stuff Adriano! Here's someone else finding that implementing a delay doesn't seem to work: https://www.alpha-vantage.community/post/how-to-reduce-api-call-frequency-tried-up-to-sleep80-between-curls-but-still-hitting-9655828 I suspect it's throttled on the basis of 'x requests allowed

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

Hello Richard You can't introduce a delay in Gnucash but you can modify the Finance::Quote module that Gnucash use. For the currency is Quote.pm (for me is in /usr/local/share/perl/5.22.1/Finance/ ) and I try tho chance it : #

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

I think they have introduced rate limiting. As an experiment, I put this URL in my browser: https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE_currency=USD_currency=GBP=[my key] After about 6 browser refreshes with a second or two between, I got: "Thank you for using the

Re: One account for both Income and Expenses possible?

On 22 February 2018 at 11:04, Norbert Klein wrote: > Thank, Maf, > > your advice was very clear and helpful - I rearranged what I had used > before accordingly. > > But you advised me also: > > Let me start by saying that you should have started a new thread for your >> question

Re: One account for both Income and Expenses possible?

Thank, Maf, your advice was very clear and helpful - I rearranged what I had used before accordingly. But you advised me also: Let me start by saying that you should have started a new thread for your question and not hijacked the existing thread I am sorry - but when I started my mail with

Finance-Quote 1.47 Unable to retrieve Currency quotes

Hi Richard, It's definitely alphavantage for currency - you can check the data URL early in the Quote.pm module. I'd agree with Adriano's assessment that the problem is server side.  I did a test this morning where I repeatedly requested quotes from gnucash - the first four attempts sucessfully

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

Sorry I couldn't reply to this before Adriano - I've been finding using this list a bit too difficult for me! (A confusion between my @gmail and @googlemail email domain identities) I think you are probably on to something in trying to throttle your requests. But may I ask - how are you adding

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

But I wonder - does GNUCash actually use alphavantage for currencies? I see this: "There are 3 types of sources of which the first - currency - is hardcoded and responsible to fetch ISO currencies. The other two can be selected in the security editor." https://www.gnucash.org/docs/

Re: Language change mystery mysteriously solved

The Accounts tab is protected to avoid confusion if people accidentally try to close it. I had figured out a complicated way to work around this, and then thought of another by editing yet another file. I'll spare you the details. Here's the easiest solution: Click on the accounts/cuentas tab