Re: [GNC] Report question

2023-02-10 Thread Eric Coates via gnucash-user
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

[GNC] Report question

2023-02-09 Thread Eric Coates via gnucash-user
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

Re: [GNC] Reconciliation - Again

2023-02-01 Thread Eric Coates via gnucash-user
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

[GNC] Reconciliation - Again

2023-01-31 Thread Eric Coates via gnucash-user
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,

Re: [GNC] Finance-Quote 1.53 released!

2022-10-09 Thread Eric Coates via gnucash-user
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

Re: [GNC] Blue line in checking account register window

2022-07-09 Thread Eric Coates via gnucash-user
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

Re: [GNC] Bitcoin is legal currency in El Salvador - why not add BTC?

2021-12-07 Thread Eric Coates via gnucash-user
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

Re: [GNC] Install Alphavantage Key

2021-11-25 Thread Eric Coates via gnucash-user
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

Re: [GNC] Difficulties entering share purchases

2021-08-24 Thread Eric Coates via gnucash-user
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 wrote: Thus

Re: [GNC] Help Selling & Buying Securities

2021-08-10 Thread Eric Coates via gnucash-user
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

Re: [GNC] Difficulties entering share purchases

2021-07-28 Thread Eric Coates via gnucash-user
David I'm not sure I understand the significance of much of your second paragraph but ... I have installed Ubuntu 21.04 on a different machine and installed GnuCash 4.4 thereon and the behaviour I reported earlier is NOT apparent. Using my customary practice of cloning an earlier share

Re: [GNC] Difficulties entering share purchases

2021-07-28 Thread Eric Coates via gnucash-user
stent." 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 GnuCash 3.

Re: [GNC] Transparent background on selected Transfer choice

2021-05-28 Thread Eric Coates via gnucash-user
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.

Re: [GNC] Bank & Credit Card account balance

2021-05-23 Thread Eric Coates via gnucash-user
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

Re: [GNC] Possible Ubuntu problems/"Transparency" problem

2021-05-23 Thread Eric Coates via gnucash-user
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

Re: [GNC] Possible Ubuntu problems

2021-05-19 Thread Eric Coates via gnucash-user
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

[GNC] Possible Ubuntu problems

2021-05-19 Thread Eric Coates via gnucash-user
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

Re: [GNC] Transparent background on selected Transfer choice

2021-05-15 Thread Eric Coates via gnucash-user
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

Re: [GNC] Transparent background on selected Transfer choice

2021-05-14 Thread Eric Coates via gnucash-user
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

Re: [GNC] Securities disposals: pooling (not FIFO/LIFO/average costing) for UK cgt purposes: average price and identity (GNUCash v.4.5)

2021-04-23 Thread Eric Coates via gnucash-user
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

Re: [GNC] Account Sort Order

2021-02-26 Thread Eric Coates via gnucash-user
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

Re: [GNC] Apparent Miscalculation

2020-11-16 Thread Eric Coates via gnucash-user
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

Re: [GNC] Apparent Miscalculation

2020-11-15 Thread Eric Coates via gnucash-user
ny 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" I agree that the bottom three am

Re: [GNC] Apparent Miscalculation

2020-11-14 Thread Eric Coates via gnucash-user
* * 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

[GNC] Apparent Miscalculation

2020-11-14 Thread Eric Coates via gnucash-user
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

Re: [GNC] Deleting test data

2020-10-28 Thread Eric Coates via gnucash-user
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

Re: [GNC] Difficulty with online price retrieval

2020-07-15 Thread Eric Coates via gnucash-user
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

Re: [GNC] Reconcile also opens Interest Payment box?

2020-07-12 Thread Eric Coates via gnucash-user
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

Re: [GNC] Accessing online currency rates

2020-07-05 Thread Eric Coates via gnucash-user
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

Re: [GNC] Accessing online currency rates

2020-07-04 Thread Eric Coates via gnucash-user
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

Re: [GNC] Price of gold

2020-04-08 Thread Eric Coates via gnucash-user
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

Re: [GNC] Price of gold

2020-04-08 Thread Eric Coates via gnucash-user
rtfolio 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 gnucash-user wrote: Good Afternoon

[GNC] Price of gold

2020-04-08 Thread Eric Coates via gnucash-user
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

Re: [GNC] How to enter Gold?

2019-07-22 Thread Eric Coates via gnucash-user
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