This looks to be working good - thanks so much for sending the file.
Regards,
Bill
-Original Message-
From: Geoff
Sent: Monday, 21 December 2020 4:01 PM
To: dull...@gmail.com; gnucash-user@gnucash.org
Subject: Re: [GNC] ASX quotes not working again?
If you are comfortable accepting co
If you are comfortable accepting code from strangers on the internet,
the attached version seems to be working for me.
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump asx BHP
Finance::Quote fields Gnucash uses:
symbol: BHP <=== required
date: 12/21/2020 <
I don’t understand why "total_amount-(total_amount/2)” doesn’t work. I’m
assuming that two formulae are used:
total_amount/2
&
total_amount-(total_amount/2),
as the OP specifies.
If the amount is odd, the first should be (given consistent truncation of the
dividend by integer division) equivalen
I don't know if the math functions are available, but various languages
have rounding functions. If there's a rounding function, perhaps round up
and round down can be used?
odd_cent_total/2 will have a fractional cent value in the answer, so
round up to the nearest cent for you and down to the
Note, I'm not aware of a 'proper' solution that you are looking for.
Sounds like a lot of effort to avoid changing a single digit on review
when occasionally the original amount is odd.
I would expect your try at "total_amount-(total_amount/2)" to only work
half the time, thus a coin flip. No
The usual recommendation to export reports as HTML and import from Excel
still applies.
To format date differently, review your global preferences found in Edit >
Preferences > Numbers, Date and Time
On Sun, 20 Dec 2020 at 22:41, Ian D Henry wrote:
> I have been using the experimental multi col
I'm not certain about the MySQL or PostgreSQL options, but with SQLite,
I have no such issue. Also with the default XML you shouldn't have any
problem either.
To be clear, separate computers, at separate times, can access the same
file. You should not attempt to access the same file at the sam
I note Australian stock exchange quotes are failing again. I had a fix from
October . maybe they have changed their site again?
Using gnc-fq-dump seems to work fine .
C:\Program Files (x86)\gnucash\bin> perl gnc-fq-dump ASX IAG
Finance::Quote fields Gnucash uses:
symbol: IAG
First up, apologies if this is the wrong place to send this. I looked
through the mailing lists page on the gnucash website and couldn't find any
mailing lists that seem to fit this question so I'm asking it here.
I'd like to set up regular donations to the GnuCash project (because I use
the softw
I have been using the experimental multi col report. Up to the end of
October, the report prints on one page. Now that Nov is included the
document is too wide for the paper and the numbers for November are
truncated. There is no second page with the missing numbers. Once I add
the year end col
David,
It may be that Bayesian matching works but the import matcher window did not
come up in the dialog when I was writing the docs from memory. I have the
same problem - I don't use the QIF import at all. I collected some test
files from my bank which duplicated the OFX import I normally use a
I thought the Bayesian matching worked with QIF imports too. Has that been
discontinued?
Unfortunately, I rarely use the QIF format and I only have one poorly
formed sample easily available to test. That sample fails completely.
On Sun, Dec 20, 2020 at 2:56 AM David Cousens
wrote:
> Bruce
>
>
What do you mean by "remembers"?
Are you asking if it can automatically fill in details when you start
typing a new transaction? Yes, it can if you have entered a similar
transaction before.
If you are asking about something else, please rephrase your question.
On Sun, Dec 20, 2020, 2:20 AM BR
I went to Yahoo! Finance and searched for your company there. Having located
it, it was easy to see their notation on the page and in the URL.
Original Message
From: Richard Solomon
Sent: Sun Dec 20 03:03:51 EST 2020
To: "D."
Cc: David Reiser via gnucash-user
Subject: Re: [G
Bruce
You describe your problem as not remembering transactions. Is what you mean
not remembering which external QIF category and account name map onto which
GnuCash internal account name? That map is constructed the first time you
import records to a particular GnuCash account. Under Tools_>Impo
Hello
I have searched high and low for information on how GnuCash 'remembers
transactions' in checking account registers.
My situation is that I have 3 business checking accounts and when I do my
monthly (haha) reconcile, only one of the accounts 'remembers' the transactions
from the previous
Having problems
Server setup in AWS
When 'save as' the Local host Version into the AWS endpoint Msgbox becomes
non responsive and eventually crashes GnuCash
The tables in cloud db are setup but I can excess any data.
And I can open the cloud db in the Gnucash UI but no accounts (as expected)
Hi,
I've been using gnucash for a few years now, including scheduled
transactions with variables/formulas, but one thing I never figured out is
how to avoid imbalances in them when variables cause "bad" rounding,
requiring me to fix those manually.
Simple example:
I use a scheduled transaction fo
Hi John
To clarify, did you catually load books from database into gnucash from
multiple separate computers (at separate times)? It seems to me that when
using the database option the lock persists after shutting gnucash down,
this effectively making it a single client setup.
--
Sent from: http
It works. Thanks! I I would never have guessed that in a million years.
On 12/20/2020 3:02 PM, D. wrote:
Maybe try Yahoo Json with symbol 4922.T?
Original Message
From: Richard Solomon
Sent: Sun Dec 20 00:32:02 EST 2020
To: "gnucash-user@gnucash.org"
Subject: [GNC] Configur
20 matches
Mail list logo
