I've used Google sheets to retrieve prices which can be imported into GnuCash.
In the referenced message, it should be simple to set whatever date you want.
https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html
David T.
On Dec 30, 2022, 7:48 AM, at 7:48 AM, Geoff wrote:
I'm sure he read what you wrote and assumed you were running Gnucash 4.12
on MacOS Ventura :-) If not please advise OS and Gnucash version.
If that is indeed the case check out
https://lists.gnucash.org/pipermail/gnucash-user/2022-November/103465.html
and
I just performed a trivial test in release 4.8 (Build ID: 4.8a+(2021-09-28)
in Lubuntu 22.04 by adding a bogus transaction to a register then saving
the file, opening the reconciliation window, right clicking the desired
split in the right panel of the reconciliation window, and clicking
delete.
I haven't needed to do a reconciliation yet since this thread started, but
perhaps in the next few days.
In the meantime, I didn't even realize that you could right click split
lines in that screen and do things. If that works successfully, wonderful.
I have always used the menu to navigate to
No.
As far as I know the Finance::Quote module that GnuCash uses has no
provision to fetch historical prices.
If you are into scripting and web scraping, checkout Selenium which has
a nice Python interface.
Good luck!
Geoff
=
P.S. Always include gnucash-user@gnucash.org on all
Hi Michael
You can't do this.
Alternatives:-
1. Key the prices directly into the Price Database:-
(Tools / Price Data Database / Add)
2. Import from a CSV file:-
(File / Import / Import prices from a CSV file)
Historical prices are available from, inter alia, https://finance.yahoo.com/
How can I tell GNU Cash to update its "Price Database" for all known
currencies, stocks, bonds, mutual funds, etc for a *specific* day?
I'm trying trying to prepare a report for a date in the past. I've set the
`Options` for the report to `nearest in time` so that it will grab the prices
for
I guess you didn't read what I wrote. So, let me say it again (via the
magic of copy/paste):
"I was right-clicking on a transaction in the right (credit) column. It
was already highlighted, and there was no other transaction highlighted.
The right-click context menu appeared alongside the mouse
Correct. You need to scrub each Account separately.
Geoff
=
On 30/12/2022 1:57 pm, m...@tgr66.me wrote:
Assuming one creates a separate account to track each stock (for example,
“Joint Brokerage:AAPL” and “Joint Brokerage:AMZN” doesn’t a user have to scrub
for each symbol? Or am I
Assuming one creates a separate account to track each stock (for example,
“Joint Brokerage:AAPL” and “Joint Brokerage:AMZN” doesn’t a user have to scrub
for each symbol? Or am I misunderstanding and it *should* work at the “Joint
Brokerage” level?
> On Dec 29, 2022, at 20:04, Geoff wrote:
>
Hi Tim
Lot scrubbing has nothing to do with internationali[sz]ation. It is
just one possible method** to match your buys and sells for a particular
stock account and thus calculate your gains and losses.
Each sale transaction is applied consecutively to each buy transaction,
and the
It’s no biggie changing the date and many programs default on the.current date
or the last entered. It’s fine with me if you just leave it alone. Besides,
unless I’m mistaken, when I pull in a QFX, the system uses the date it cleared
the bank, not the date entered or written.
> On Dec 29,
Hi Chris,
I, too, enter the receipts immediately. If I buy something online, it's
actually exactly the same time as the purchase. If it's a real store, it
gets entered once I'm home. Having it default to "today" is the right
answer for me.
Michael
On Thu, Dec 29, 2022 at 5:23 PM Chris
I searched the mailing list and didn’t really get any hits from the past six
years, so I’m starting a new thread.
I understand the concept of lots, and I *think* I understand _why_ GnuCash uses
the scrubbing concept (i.e., internationalization?).
In any case, I’m a little worried about the
FWIW, I'm another who enters most txn's on the same day I make them.
IMHO, one of the great and beautiful advantages of GnuCash over
Quickbooks Online (which I must use to do our church's accounts) - is
that GC opens basically instantaneously. There's no network latency, no
login,
That sounds like a GTK bug. You were raising a context menu on what was
selected, not where the mouse pointer was located. If you had a line in
the left pane selected, that is what got deleted.
Maybe reverting to a backup file and making it your main file would be
in order for restoring your
I was reconciling several credit card statements for the same card and had
noticed that a subscription payment I had set up as an automatic entry was
showing up even though I had canceled the subscription. Clearly, I hadn't
discontinued the automatic transaction entry in GnuCash. I ignored
Two items: I understand what you wrote about legally tendering something,
but I was thinking of mailing bills... I may write them on Monday, and drop
them into the mail, but until the mail is received by the creditor, it
isn't paid. But yes, I have looked at US IRS regulations, and (for
example),
The supported formats are, IIRC:
y-m-d
y-d-m
d-m-y
m-d-y
Every time you start an import it will begin with the full list and use
the dates in the file to rule out from the list; if there remains more
than one once all the file is loaded, then it asks you. If the set is
empty once the file is
If you read Derek's reply again, he stated that you must use numbers only;
month names are not acceptable.
Dan
On December 29, 2022 3:14:02 PM Peter West wrote:
What date formats ARE supported by the GNC QIF import process? 29 December
2022 is unambiguous, but apparently unsupported by GNC.
What date formats ARE supported by the GNC QIF import process? 29 December 2022
is unambiguous, but apparently unsupported by GNC.
Happy 6th day of Christmas!
—
Peter West
p...@pbw.id.au
And the angel said to them, “Fear not, for behold, I bring you good news of
great joy that will be for all
Thank you Derek,
I understood *why* it was happening, and I do realize that in reality, as the
file size grows, the chance of having all days <= 12 is pretty darn slim :-)
I appreciate the quick response.
Tim
> On Dec 29, 2022, at 12:55, Derek Atkins wrote:
>
> Not particularly.
> The
Not particularly.
The issue is that 11/12 is ambiguous. Is it November 12 or December 11?
Using a 2-digit year doesn't help.
The best way is to ensure you have a day > 12 in the mix (and a year > 31).
So using 12/29/2022 should give you a unique format.
You cannot use month names, only
On 2022-12-29 09:03, Adrien Monteleone wrote:
> Such restrictions would have no bearing as to if they should be separate
> or not. It has nothing to do with GnuCash or even accounting.
>
> If the respective governments simply treat them as equivalent to paper,
> coins, or other current digital
I’m developing QIF files to import my old investments. I get asked every time
to confirm the date format (the entire import process is a bit long imo). The
QIF specification says I ought to be able to enter a date using `dd month
year`; for example: 29 December 2022. However, this results in an
hi David
With the roll out of ISO 20022 from March 2023 we hope to see more digital
assets complying with the protocol ( if i remember there were around 10 of them
already compliant). Morover CBDC will take advantage of this to enable cross
border transfers. Swift had already announced that
Such restrictions would have no bearing as to if they should be separate
or not. It has nothing to do with GnuCash or even accounting.
If the respective governments simply treat them as equivalent to paper,
coins, or other current digital blips, then they likely will not get
separate currency
On Thu, 29 Dec 2022 at 07:15, LI Daobing wrote:
> CBDCs also can constrain the usage of money. like some money can only be
> used to pay rent, and some other money can only be used to buy food.
>
All the more reason that I don’t like them.
However, that gives a greater need to be able to
Murugan - I am suspecting it is likely a bug between GNC and the Perl module
interface. I have not used currency exchanges so far thus I am not familiar
with that part of the function or help in troubleshooting.
-- Original Message --
Received: Thu, 29 Dec 2022 09:54:23 AM EST
From:
thanks Kalpesh, Frank
I read the help page but as Kalpesh pointed out, it was not clear that it
updates without any intervention.
i took the install online route and it perfectly installed 1.54
I have a issue though, Couple of currency rates are not getting updated in
GNUcash when i run
You *can* create a proforma invoice or quote and turn that into an invoice.
Just create an invoice, but instead of giving it a number, use the word
PROFORMA or QUOTE, and don't post it. Then use the invoice printing
facility to print it (to find the proforma or quote, you can search, e.g.
by
31 matches
Mail list logo