Adrien wrote:
"When starting a new topic, rather than replying to an existing one,
simply send a new message to the list address. Otherwise, it might not
get noticed
Sorry. Although I did start with an existing post I changed the Subject
and I thought that would have removed the antecedents
Good afternoon
I've decided to do some exploration of the Reports option in GnuCash,
specifically the Reports/Income & Expense/Profit & loss.
The default settings give me much of what I want but ...
I have two classes of Expenses, "Ordinary" and "Exceptional"; I want the
full breakdown of th
Phyllis, Simon
Thanks, that's as I hoped.
The heads up on the (potential) problem if the account on the other side
of the transaction has also been reconciled has been noted.
Thanks again
Eric
___
gnucash-user mailing list
gnucash-user@gnucash.org
Good Afternoon
I fully understand that changing the Payment/Charge (on a credit card
account) or the Increase/Decrease (on a bank account) will create
difficulties with future reconciliations.
However, is it possible to change the contents of other fields (Date,
Description and, particularl
There's a lot of people involved! Thanks to all of them
Eric
==
On 09/10/2022 02:35, Bruce Schuck wrote:
New version 1.52 (*sic*) of Finance-Quote is available with the
following changes:
___
gnucash-user mailing list
gnucash-use
Hi
As others have said, entries below the blue line are in the future. I
find that feature very useful; even more useful if I select "Future
transactions after blanks transaction" in Preferences/Register/Layout
Eric
=
On 2022 Jul 9, at 07-09 14:33:05, Barry G. Hall wrote:
Hi
To (slightly) misquote John Ralls
"Bitcoin is neither a major nor a minor currency. It's not a currency at
all:...[it is] a speculation vehicle, not a currency."
but as shares are also "speculation vehicles" a possibility arises.
Starting from Dustin Henning's comment, some trivial experim
Hi
Via Edit>Preferences there is a tab for online quotes; enter your Alpha
Vantage key into the box provided.
However; that may not allow you to get Australian/NZ quotes and even if
it does it may be painfully slow. In the Securities Editor tool it is
possible to select other source options
Hi
For those who remember this topic (and to sign it off):
It's been a while but I've finally got round to reinstalling Ubuntu onto
my main machine and the problem has gone away.
Take care
Eric
=
On 28/07/2021 20:32, Eric Coates via gnucash-user wro
Jack
I'm assuming that your "Invest Account - ABC" is set up as a stock
(check using the Edit Account button) and you have set an opening
balance of 100 shares of ABC in that account. If that is correct you
sell them by an entry similar to the one shown in the attached Sell
Shares png but you
e errant machine is running Ubuntu 21.04 (with
all security patches installed) with Gnucash 4.4 and F::Q 1.49; I always
install GnuCash using Synaptic and the standard repositories for the
version of Ubuntu installed.
Of course, if there's any further information I can pro
onsistent." and asking me "Which value would you like to have
recalculated?" Shares / Price / Value.
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 28/07/2021 1:23 am, Eric Coates via gnucash-user wrote:
In January this year,whilst running Ubuntu 20.10 and
Good Morning All
Hi David (dgpick...@aol.com) + Eric (twistedw...@talktalk.net),
Can you please test the fix Geert found in
https://bugs.gnucash.org/show_bug.cgi?id=797493#c12
and let us know how you go?
Can you reconfirm the Linux distro and version too please so I can document
in the bug.
R
In addition to David Carlson's answer:
On the Accounts tab use the down arrow (at the right end end of the top
line to display Present(GBP) (in my case, your base currency will
appear) as well as the Total. (There are lots of other options as well.)
The former is today's balance, the latter tak
Hi
Following on from my earlier note:
I have done a complete rebuild of Ubuntu 21.04 (to replace my
incrementally upgraded system) and I can report that, for me at least,
the "transparency problem" can be removed by using Gnome Tweaks (aka
Tweaks) to change the Applications theme (under Appea
David, Geert, Chris (a consolidated reply)
As you responded I take it I'm forgiven!
Under Ubuntu 18.04 I used Gnome Tweaks (as it is called using Synaptic)
to apply a degree of transparency (to the Dash). It survived the
upgrades to 20.04, 20.10 and 21.04. David Carlson suggested a work
aroun
Hello
Not exactly a GnuCash topic (classic British understatement!) but ...
There have been a few problem reported recently with the headings
"Transparent background on selected Transfer choice" and "Cannot always
over-type, clear selected amounts". They may, I suspect, be an effect
of the u
Good Morning
In response to Chris Good's enquiry:
At initial startup this morning the theme selected was Light and the
transparency effect was apparent;
Changed the theme to Dark and rebooted, the transparency effect was
still apparent;
Changed the theme to Standard and rebooted, the trans
Hi
Sorry to disagree!
I have been having his problem on Ubuntu 20.10 for some time. Yesterday
evening I tried the workarounds in the bug report with no discernable
effect.
Today I have done the upgrade to 21.04, the effect was still apparent,
the workarounds still had no effect.
Also (and thi
On 22/04/2021 19:23, RW Jones via gnucash-user wrote:
2). as a subordinate question: *can one input on investments
(securities) purchases but also on sales, (a) broker commission and
(b) governmental taxes (e.g. stamp duty/UK SDRT) as separate /
discrete items from each other on top of the p
Another idea:
Set the Cash account as a separate sub-account under the broker account.
Please see attached screen shot. (Sorry about the rather
over-complicated account names but they work for me!) For non-UK users
(but of no real consequence): An ISA (Individual Savings Account) is a
tax-lig
Hi
SAP 19 shares @ €102.00 equals €1938.00 @ (€0.89662 = £1) thus value
=£1737.65 *NOT £1831.77*
You avoided answering the question about your recorded EUR-GBP rate.
Mea culpa!
It should have read "€1 = £0.89662" - and I spent over an hour writing that
email! On the bright side the calculation
one as well: See if there are any entries for the stocks in GBP.
Regards,
John Ralls
On Nov 14, 2020, at 1:23 PM, Eric Coates via gnucash-user
wrote:
John
The heading for the column starting with £15824.56 is "Present(GBP)"
... for the column starting €14805.44 is "Total"
*
*
On 14/11/2020 17:30, John Ralls wrote:
On Nov 14, 2020, at 8:28 AM, Eric Coates via gnucash-user
wrote: Hi I appear to have found a
significant miscalculation in GnuCash - no disrespect or criticism
intended. The "base currency" I use in my accounts is GBP (£) but I
have some su
Hi
I appear to have found a significant miscalculation in GnuCash - no
disrespect or criticism intended.
The "base currency" I use in my accounts is GBP (£) but I have some
sub-accounts that are denominated in Euros (€).
I attach a screen shot of part of my chart of accounts (the two column
Hi
If you've done a lot of work setting up various accounts and you want to
preserve that work the following is a way of doing that:
File > Export > Export Account Tree to CSV
Progress through the various stages (be sure to remember the file name and its
location)
File > New File
Progress thr
A few days ago it was reported that AlphaVantage was no longer serving
price information (something to do with them not having the appropriate
licences apparently). The general advice seems to be use Yahoo as JSON
which works fine for me perhaps it would for you.
Eric
=
Hi
As removing the facilities simplifies the programming I'm in favour of
removing them.
I find the pop-ups annoying and I never make use of them
Take care
Eric
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription
John
Thanks for the information, now I know a little more than I did!
Eric
=
On 04/07/2020 23:14, John Ralls wrote:
On Jul 4, 2020, at 2:26 PM, Eric Coates via gnucash-user
wrote:
Good Evening
A query of absolutely no real consequence.
In the past (a) for as
Good Evening
A query of absolutely no real consequence.
In the past (a) for as long as I can remember, currency conversion rates
appeared "by magic" on demand and (b) I used AlphaVantage to get the
price of shares and thus, of course, had to have an AlphaVantage key.
But it became possible to
Adrien
OK. Now that I understand where GnuCash's gold price comes from I've
come to the conclusion that what I called the "retail price" of gold is
a mirage!
My gold is in the form of Sovereigns (each of about 7.5gms) and I guess
that the only reliable way to get a value of it is by offeri
S:As I only revalue my portfolio on a monthly basis it's no big deal to
enter a gold price manually so, as I say, it's just out of interest.
Thanks for indulging me.
==
On 08/04/2020 16:40, John Ralls wrote:
On Apr 8, 2020, at 7:31 AM, Eric Coates via gnu
Good Afternoon
On 08/04/2020 10:08, Frank H. Ellenberger wrote:
The quotes are not from ISO-4217:XAU (troy ounce Gold), but from
NASDAQ:XAU an share index of gold and silver producers.
So, is there a relationship between this NASDAQ:XAU figure and (what
might be termed) the real price of gol
Hi - for some reason, recently whenever I open gnu cash, all the dialogue boxes
open with the bottom buttons barely visible and unusable until I drag the box
sides to make each one bigger. This is extremely inconvenient and annoying.
Anyone have an idea as to what I did to make this happen
Michael
I wonder what???s the best practice on how to enter physical Gold into GNC. Is
there anybody who has done that before?
I added gold to my list of "thingies" fairly recently.
The way I did it:
(1) Right click on the Assets class and choose New Account
(2) In the window that appear
Hi
The Finance-Quote team are a modest bunch!
As well as the changes noted (see below) 1.49 also correctly reports
prices London quoted (London Stock Exchange, LSE) securities when
Yahoo-JSON is chosen as the source. Taking advantage of this means the
"price getting" procedure is a lot faste
Alan
A couple of suggestions that may help you - but note that I've found
these on my 3.5 version of GnuCash on Ubuntu, may not be the same on
2.6.21/Windows.
Working in the register associated with my current (checking) account:
(1) Right clicking somewhere in the title bar (Date/Num/etc) b
unt??? as lines you can display to see
if you are projected to cross a danger zone.
Regards,
Adrien
On May 29, 2019, at 4:05 PM, Eric Coates wrote:
Adrien (and any others sufficiently interested)
I'm assuming the question was meant for me (or is that just ego?):
It's a personal re
earning fun, even, or especially if you
take detours)
Regards,
Adrien
On May 29, 2019, at 2:40 PM, Eric Coates wrote:
Hi
My requirement is that on the first of the month all transactions due before the last day of the month are
entered. My method does that but the one proposed by Bert Ridin
can really help.
Take care
Eric
==
On 29/05/2019 15:27, Stephen M. Butler wrote:
On 5/29/19 2:16 AM, Eric Coates wrote:
Hi
1)?? How can you enter a scheduled transaction before it's due date?
(Used to check cash flow)
Adrien Monteleone has given one method, I use a
Hi
1) How can you enter a scheduled transaction before it's due date?
(Used to check cash flow)
Adrien Monteleone has given one method, I use a different one.
Without going through my entire boring "scheme of works" for the last
day of the month I do want to enter all scheduled transact
Hi
On 4th May Stephen Butler posted a mail to the list on how to use his
GnuCash-3.5 package to install GnuCash on Ubuntu 19.04. Having done it,
I can testify that it works - with a slight niggle if you use
AlphaVantage (see my note of 5th May).
It requires the use of the Terminal but all-in
ave me all the information I needed (I don't
know why - some things I just accept). Try it, it may work for ASX
shares as well - we can but hope.
Can you help me further please. What other information should I
provide?
Hopefully, that's sufficient for you
Best wishes
Eric
==
de to resemble the html version as closely as
possible. Some mail clients simply strip all the markup, others replace it
with symbolic pseudo-markup (like the asterisks or slashes). What these
replacements are depend on your mail client.
Regards,
Geert
Op maandag 13 mei 2019 11:28:24 CEST schr
On 13/05/2019 08:10, Geert Janssens wrote:
Hi Eric,
Your change seems to have fixed the editing. I now see your html message
properly formatted.
Regards,
Geert
Op zaterdag 11 mei 2019 22:17:08 CEST schreef Eric Coates:
Gert
Thank you for the tip. I have (I think!) found the "offen
Gert
Thank you for the tip. I have (I think!) found the "offending" setting.
I have unset it.
I think it's possibly something to do with the mailing list - sending a
message with *bold* and /italic/ text to another of my email addresses
shows no problems.
Everybody
Please forgive the sm
important
bits - I'm going to have to rethink how that's possible.
Eric
On 11/05/2019 11:12, Eric Coates wrote:
Hi (again!)
OK, if you had AlphaVantage working at some time you'll have an
AlphAvantage API key.
(In GnuCash 3.5 you can
Hi (again!)
OK, if you had AlphaVantage working at some time you'll have an
AlphAvantage API key.
(In GnuCash 3.5 you can confirm this by going through*Edit > Preferences
> Online Quotes *and confirming that the key appears there)
It sounds as if you've hit the problem with AlphaVantage thr
download them one at a time it keeps them as
individual files and saves the effort of unzipping them.
Colin
On Sat, 4 May 2019 at 22:23, Eric Coates wrote:
Colin, Ronal
Thanks for taking the time to respond.
It's possible/probable that I used the wrong files. In my Download
folder I had a
es
Eric
==
On 04/05/2019 21:12, Colin Law wrote:
Did you make sure there were no other similar files already in the
folder you downloaded to and that you downloaded the correct files?
Colin
On Sat, 4 May 2019 at 19:26, Eric Coates wrote:
Stephan
Althoug
Stephan
Although I???m about to relate some problems I???ve had with your GnuCash
3.5 on Ubuntu 19.04 before I do I want to say that I appreciate your
efforts (and those of your ???hand holders???!) on providing tools to the
community. Sincerely, thank you.
My situation is that I upgraded to
ds.
Eric
=
On 02/05/2019 01:06, John Ralls wrote:
On May 1, 2019, at 1:34 PM, Eric Coates wrote:
Hi
This is so weird it must be me ??? otherwise pandemonium would have reigned
here!
About two weeks ago I upgraded my system to Ubuntu 18.10 and a few days later
to 19.04 (ironically, I was try
Hi
This is so weird it must be me ??? otherwise pandemonium would have
reigned here!
About two weeks ago I upgraded my system to Ubuntu 18.10 and a few days
later to 19.04 (ironically, I was trying to get around some problems)
and installed GnuCash from the standard repository; so I am runni
Alan
Before commenting about the failure of Get Online Quotes to get anything
useful a small amplification of Fred Bone's comment that *Type* can be
anything you want (Fred has given his choice, I use a different set -
LSE for London quoted shares, EUREX for shares quoted on continental
Europ
Alan
Bugger! My email system added a host of unwanted backslashes to the
updated part of AlphaVantage.pm. To get the right effect they should be
deleted.
On behalf of my email system, I tender apologies.
Eric
On 25/04/2019 13:52, Eric Coates wrote:
Hi Alan
Hi Alan
The namespace for LSE is L; thus Symbol/Abbreviation should be SSE.L
Similarly for other LSE quoted stocks
Getting the quotes themselves is a little fraught. In my experience the
only source that "works" is AlphaVantage (the usual suggestion of using
Yahoo-JSON returns prices that ar
/usr/lib/per5. For non-root installations ~/perl5 or
~/lib/perl5 are common.
Regards,
John Ralls
On Mar 6, 2019, at 2:23 AM, Eric Coates wrote:
John
Thanks for the explanations - and the bonus of explaining what the padlock
means, the directory belongs (in this case) to root.
But, in my i
shes
Eric
===
On 05/03/2019 19:54, John Ralls wrote:
On Mar 5, 2019, at 9:36 AM, Eric Coates wrote:
I am running GnuCash 2.9.16 (with Finance Quote 1.47) on Ubuntu 16.04.
In the course of some fairly standard (for me) work I have come across a couple of
"funnies" and I'm w
My apologies. It appears that a messgae I sent with the heading "Getting
security prices - Funnies" has appeared, twice!, under the title "Re:
[GNC] Payroll Management with Time Attendance Machine" as well as under
its own title
I have no idea how this happened.
Sorry
Eric
It's also poss
I am running GnuCash 2.9.16 (with Finance Quote 1.47) on Ubuntu 16.04.
In the course of some fairly standard (for me) work I have come across a
couple of "funnies" and I'm wondering whether they are deliberate,
"features" (from Microsoft's vocabulary meaning a bug that won't be
fixed), bugs or
Hi
OK, that's clear enough - even for me! Many thanks.
I'll try making the mod tomorrow (taking all the precautions I can think
of) and try to download prices in the evening (when a new lot become
available).
Best wishes
Eric
___
gnucash-user ma
Hi
I am about to expose my ignorance - sensitive people should look away now!
I have found the file referred to (I think); on my Ubuntu system I found
it at
~/.cpan/build/Finance-Quote-1.47-JrEF3h/lib/Finance/quote
The last few lines of the file are:
# divide USD quotes by 100 if
Hi
Apologies. It seems that my email system has developed a mind of its own
and sent an early and incomplete version of this note.
I've been away for some time. Since returning I have not been able to
find any information about an upgrade to Finance::Quote.
It seemed from the work done by E
ingle-Morningstar GB as your source?
Cheerio
Graham
On Tue, 4 Sep 2018, 8:15 pm Eric Coates, <mailto:eric.coa...@sky.com>> 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
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 JS
Hi
First off: I would like to pay tribute to all those who have worked on
GnuCash to provide a valuable tool and to those who have worked to
circumvent the recent problems caused by Yahoo. To all of them, my thanks.
But I have a problem (probably caused by my own ignorance). I am running
Gn
Hi Ken
I had a similar problem when I started with gnuCash - and so, it seems,
have lots of other people:
I am guessing that when you look at the tab for your current account two
of the headings are "Debit" and "Credit" and when you pay your salary
into the account the number appears in the
This is by way of a sign off note on this issue.
Based on (my understanding of) Fred Bone's suggestion that it may be old
prices that were causing the problem I deleted all the old prices in the
pricing database and, as already noted, the problem went away - ie I was
getting a correct current
e to have to lose it
(D) Should I care if I have a working solution?
I will now go back to my real accounts and using the ideas gathered so
far try to come up with a simpler structure than I've currently got.
I'll be keeping my fingers crossed all the time!
Eric
On 09/06/17 1
=== required
date: 06/08/2017 <=== recommended
currency: EUR <=== required
last: 73.50<=\
nav: <=== one of these
price: 73.50<=/
timezone: <==
e dividend I receive is
£12.34 would it be possible to credit €12.34 to “Cash Euro” and transfer
it to “Cash Pounds” at an exchange rate of 1:1 without screwing up
something else?
I suppose I could just live with the “error” but what is accounting
without ac
71 matches
Mail list logo