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
untu 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 provide I will be happy to do so. E

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] menu sizes

2019-07-24 Thread Eric Coates
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

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

Re: [GNC] Finance-Quote 1.49 released!

2019-07-10 Thread Eric Coates
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

Re: [GNC] Future transactions

2019-06-02 Thread Eric Coates
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)

Re: [GNC] Misc Newbie Questions

2019-05-30 Thread Eric Coates
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 requirement in two senses (

Re: [GNC] Misc Newbie Questions

2019-05-29 Thread Eric Coates
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 Riding seems to be better. ("Seems" o

Re: [GNC] Misc Newbie Questions

2019-05-29 Thread Eric Coates
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 different

Re: [GNC] Misc Newbie Questions

2019-05-29 Thread Eric Coates
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

Re: [GNC] Trustworthy easy way to install gnucash 3.5 on ubuntu?

2019-05-14 Thread Eric Coates
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

Re: [GNC] Price Editor Problems

2019-05-14 Thread Eric Coates
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 ===== On Sat, 11 May 2019 11:20:11 +0

Re: [GNC] Mail formatting

2019-05-13 Thread Eric Coates
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 schreef Eric Coates: Hi Gert For you (and other

Re: [GNC] Mail formatting

2019-05-13 Thread Eric Coates
, 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 "offending" setting. I

Re: [GNC] Price Editor Problems

2019-05-11 Thread Eric Coates
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

Re: [GNC] Price Editor Problems

2019-05-11 Thread Eric Coates
the 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 confirm

Re: [GNC] Price Editor Problems

2019-05-11 Thread Eric Coates
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

Re: [GNC] GnC 3.5 for Disco

2019-05-05 Thread Eric Coates
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 directory gnucash_3.5 and a zipped

Re: [GNC] GnC 3.5 for Disco

2019-05-04 Thread Eric Coates
019 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 Although I???m about to relate some problems I???ve had with your G

Re: [GNC] GnC 3.5 for Disco

2019-05-04 Thread Eric Coates
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

Re: [GNC] Problems with getting European share prices

2019-05-02 Thread Eric Coates
= 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 trying to get

[GNC] Problems with getting European share prices

2019-05-01 Thread Eric Coates
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

Re: [GNC] Downloading stock prices in the UK

2019-04-25 Thread Eric Coates
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

Re: [GNC] Downloading stock prices in the UK

2019-04-25 Thread Eric Coates
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

Re: [GNC] Downloading stock prices in the UK

2019-04-25 Thread Eric Coates
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

Re: [GNC] Getting security prices - Funnies

2019-03-09 Thread Eric Coates
nstallations ~/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 ignorance, I don't follow yo

Re: [GNC] Getting security prices - Funnies

2019-03-06 Thread Eric Coates
=== 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 wonderi

[GNC] Apologies

2019-03-05 Thread Eric Coates
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

[GNC] Getting security prices - Funnies

2019-03-05 Thread Eric Coates
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

Re: [GNC] When will there be a new Finance::Quote version on CPAN?

2018-12-02 Thread Eric Coates
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

Re: [GNC] When will there be a new Finance::Quote version on CPAN?

2018-12-01 Thread Eric Coates
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

Re: [GNC] Next release of F::Q

2018-10-30 Thread Eric Coates
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

Re: [GNC] UK Shares and Yahoo as JSON

2018-09-05 Thread Eric Coates
-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 sour

[GNC] UK Shares and Yahoo as JSON

2018-09-04 Thread Eric Coates
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

Error - possibly caused by incorrect F::Q update

2017-11-20 Thread Eric Coates
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

Re: Transfer query.

2017-06-13 Thread Eric Coates
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

Re: Inability to correct GBP value for Euro priced shares

2017-06-10 Thread Eric Coates
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

Re: Inability to correct GBP value for Euro priced shares

2017-06-09 Thread Eric Coates
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 11:29, Fred Bone wrot

Re: Inability to correct GBP value for Euro priced shares

2017-06-08 Thread Eric Coates
date: 06/08/2017 <=== recommended currency: EUR <=== required last: 73.50<=\ nav: <=== one of these price: 73.50<=/ timezone: <=== optional HTH, Ma

Inability to correct GBP value for Euro priced shares

2017-06-08 Thread Eric Coates
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