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 a
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/
v2.6/C/gnucash
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 the
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 gra
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
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 and not hijacked
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&from_currency=USD&to_currency=GBP&apikey=[my
key]
After about 6 browser refreshes with a second or two between, I got:
"Thank you for usin
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 :
# ===
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 fro
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 think it is a
> way to run My
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 have a sale transact
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
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 drive.
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 sav
Scott,
Thanks for your comments. As I mentioned to Adrien, I don't think I'm going to
charge off and start developing my own gnuCash queries using any tool. We are
going to just use it out of the box and develop work-arrounds where necessary/
We are still learn the application but so far really
Fran3, consider this option down the road should you take the SQL/Gnucash
plunge:
Setup a cloud instance (if you’re comfortable with that) to house your GnuCash
data file and MySQL server. (or setup access for the users to the IIS server
accordingly) I suppose you could also just point the IIS/
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 used in GnuCash?
I assumed it was related to closing the books, but section 8.9 in the
help
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 for
> 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 used in GnuCash?
The accoun
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
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
expense
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?
kind
> 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" are NOT showing up in the A
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 this
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 benefit
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 expens
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 for
Select the new top level account entry as I said then look at the account
types
On Fri, 23 Feb 2018 at 7:05 am, 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/
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 th
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
documentation but couldn’t find anything.
Learning curves.
Dan
On Feb 22, 2018, at 4:42 PM, Dave H wrote:
Select the new top level acco
On 2018-02-21 12:00, Keith Bellairs wrote:
> In the end I do not see that I get anything from using trading accounts. I
> can see that they would be useful for currency if I had to track the
> exchange rate on every foreign currency transaction. But the IRS lets me
> use an average rate for my CDN
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 documentation but couldn’t find anyt
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 ne
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, ln.mailingli...
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 a
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 (E
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 set
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
>
>
> -- 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 Carpenter wrote:
>
>> Adrien, general ac
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
40 matches
Mail list logo
