[GNC] Online quotes for funds
Sorry to be a bore, but having cracked the stock quotes problem, I'm now having trouble with funds. I suspect the problem lies in the display box. Stocks are easy xyz.L or whatever, but how do I find out what funds should be? I tried putting the ISIN number in but that doesn't work. Can someone point me to a source to find out the equivalent of a ticker for a fund? -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Online quotes problem -sorted
Many thanks for the replies all Going through the API route and altering the environment file has done the trick. G On 09/06/2018 11:48, Maf. King wrote: On Saturday, 9 June 2018 10:22:19 BST Graham Balin wrote: Many thanks for the reply, but sadly none of this works. I tried adding an ".AX" stock as described below but that didn't work either. I'm afraid I don't understand the references to API for AlphaVantage - is that something I need to find out about? G Hi Graham OK, back in November Yahoo stopped providing price information. There was a lot of traffic on the list around then and some rapid patches provided by various developers to keep the wheels turning. There are a couple of alternatives you can use - there is a service called Alphavantage which is nearly the same as the old Yahoo service. But you need to register with Alphavantage and get an " API key" (a sequence of Alphanumeric characters to authorise you on their service) which the Finance Quote PERL scripts need to be told, but then can handle getting price info from Alphavantage. The Gnucash FAQ contains details and instructions about that. Another option - it has been reported on the list that Yahoo still have a way to get info - but you need to tell F::Q use "yahoo_json" in place of Yahoo. I haven't tried it. The list archives will have more info if you can search and find it! HTH, Maf. -- -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Online quotes problem
Hey guys n gals,
I'm afraid I'm getting a bit out of my depth here. Keep having problems
getting online updates of stocks. Been through the archives but none of
it seems relevant to me on this topic.
Tried re-installing the perl installer [on Win 10]and it seemed to be
fine. Only problem is I still get 'unknown error' message when I try to
'get quotes'.
As per the guide, I tried c:\Program Files (x86)\gnucash\bin>gnc-fq-dump
-v yahoo USDEUR=X. .got:
'gnc-fq-dump' is not recognized as an internal or external command,
operable program or batch file.
Then I tried
c:\Program Files (x86)\gnucash\bin>echo (yahoo "CSCO") | perl gnc-fq-helper
and I got:
Use of uninitialized value $year in numeric lt (<) at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 750, <> line 1.
Use of uninitialized value $month in pattern match (m//) at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 768, <> line 1.
Use of uninitialized value $month in sprintf at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $day in sprintf at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $month in sprintf at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $day in sprintf at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $info{"in substitution (s///) at
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 233, <> line 1.
Use of uninitialized value within %info in pattern match (m//) at
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 238, <> line 1.
(#f)
I have no idea what is going on, and would value any tips of where to
go/what to do.
TIA
--
Cheerio,
Graham
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Search facility
On 16/06/2018 13:00, Geert Janssens wrote: D'oh.:-[ Of course. Memo to self: Try harder next time Edit->Find This behaves slightly differently when started from the account hierarchy or from an account register. When started from the account hierarchy it will search all transactions and splits in all accounts. When started from an account register it will only search for splits (and their associated transaction info) in that account. Regards, Geert -- -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Search facility
Apologies if this is brain-numbingly obvious, but I have tried looking for the answer, honest! How do I search for a particular item eg search all accounts for $4.35, or transactions with 'Harrison' in it? Quicken had a very simple search bar which worked very well. Is there a similar function in GNC? -- -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Online quotes for funds
On 10/06/2018 22:07, Richard Ullger wrote: Assuming you're in the UK going by the .L you're using, Morningstar, GB works for me using just the ISIN code. Regards, Richard. Thanks Richard. Do you enter the account as a fund or a stock? I have tried both; I've tried online quotes -'single' morningstar gb and 'multiple - Funds UK etc' but neither seem to do the trick. Keeps coming up as 'unable to retrieve quote' -- -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] exchange rate calculations
Another problem has cropped up now.. in the investment portfolio report, i see this: IG GROUP IGG.L LSE 400.00 £8.67 £3,468.00 LOVISA LOV.AX ASX 3,500.00 $12.17 £7,268.89 Note the IG quote is worked out properly, but LOV.AX has updated the correct price in AUD, but the value of £7268.89 is the original purchase price, not the current value which should be [3500*12.17]*0.57 ish I tried entering the AUD /GBP price manually, but the report stayed the same as above. As usual, any tips would be gratefully received, -- -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mailing list filter no longer working
Mine is fine. Reinstall TB? (Save profile first) Cheerio Graham On Fri, 8 Jun 2018, 6:30 pm elvis, wrote: > Just wondering if something changed in the list-ID, Thunderbird no > longer recognises gnucash emails > > -- > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Online quotes problem
Many thanks for the reply, but sadly none of this works.
I tried adding an ".AX" stock as described below but that didn't work
either.
I'm afraid I don't understand the references to API for AlphaVantage -
is that something I need to find out about?
G
On 09/06/2018 07:38, WasserLand wrote:
Graham,
What follows here is a cut & paste of the recent chain of emails that
resulted in the resolution of the same problem. Read from bottom up,
in blue. Tell me if I can further elaborate:
Thank you Maf,
The very first thread led me to the answer. Simply a matter of
adding an ".AX" suffix to the share code!
How I struggled to resolve the matter prior! As always the
solution is simple.
Thank again for responding to my outcry.
Dave W
On 06/06/18 23:48, Maf. King wrote:
Hi,
have you tried the list archives? Try this thread (yes it is Win,
but that
isn't relevant)
https://lists.gnucash.org/pipermail/gnucash-user/2018-May/076983.html
or maybe this
https://lists.gnucash.org/pipermail/gnucash-user/2018-April/075839.html
HTH,
Maf.
On Wednesday, 6 June 2018 13:50:39 BST WasserLand wrote:
I have a problem with getting quotes for my ASX portfolio in GnuCash.
Finance::Quote no longer works.
I am running Ubuntu 16.04.
Any help, please.
Dave W
On 09/06/18 02:40, Graham Balin wrote:
Hey guys n gals,
I'm afraid I'm getting a bit out of my depth here. Keep having
problems getting online updates of stocks. Been through the archives
but none of it seems relevant to me on this topic.
Tried re-installing the perl installer [on Win 10]and it seemed to be
fine. Only problem is I still get 'unknown error' message when I try
to 'get quotes'.
As per the guide, I tried c:\Program Files
(x86)\gnucash\bin>gnc-fq-dump -v yahoo USDEUR=X. .got:
'gnc-fq-dump' is not recognized as an internal or external command,
operable program or batch file.
Then I tried
c:\Program Files (x86)\gnucash\bin>echo (yahoo "CSCO") | perl
gnc-fq-helper
and I got:
Use of uninitialized value $year in numeric lt (<) at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 750, <> line 1.
Use of uninitialized value $month in pattern match (m//) at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 768, <> line 1.
Use of uninitialized value $month in sprintf at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $day in sprintf at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $month in sprintf at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $day in sprintf at
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $info{"\"-//W3C//"...} in substitution (s///) at
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 233, <>
line 1.
Use of uninitialized value within %info in pattern match (m//) at
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 238, <>
line 1.
(#f)
I have no idea what is going on, and would value any tips of where to
go/what to do.
TIA
--
Cheerio,
Graham
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
--
--
Cheerio,
Graham
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] Entering preexisting shares
Hi. My first post as a gnu-bie, so please bear with me. Trying to enter preexisting shares as split transaction, with commission and tax. [Have searched google /archives without success] I enter the splits, [as per 9.5.1 of gnucash guide] add a balancing amount from 'equity:opening balances' and yet I get 'imbalance' and 'orphan-gbp' generated. Hope the image comes out ok. Any ideas or places to look, gratefully received -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Entering preexisting shares
On 06/06/2018 20:28, John C wrote: Assuming you're transferring shares from one brokerage account to another, I found it best to enter the shares and their original purchase dates in the destination stock account and the cash used for the purchase comes from Equity: Opening Balances. This way maintains the lot purchase dates and doesn't seem to conflict with the brokerage account opening date. You could also enter a negative number of shares and the base price in one stock account and the same (but positive) number of shares and base price in the destination account. You won't have much luck trying to credit the stock account directly from Equity:Opening Balances, because the currencies are different, "shares" vs. "dollars". Wow! Didn't expect a reply that fast! No, I wasn't transferring, just trying to enter a date in the past when i bought the shares. I take your point about the conflict with opening dates -will play around with that. [Crediting the stock account seems to be what is described in 9.5.1 of the guide; it is the value of the shares that is credited ] Thanks for the reply -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Strange Problem
On 22/06/2018 17:34, Les wrote: John: I never received your reply because for some reason, it ended up in my spam folder. I am not sure what you mean, but I cannot find the stock in question in Price Editor so I cannot check its prices. I have selected to get quotes via AlphaVantage in Security Editor. At any rate, I cannot get prices or input a price manually. Thanks, Les Have you tried using the ISIN number as an identifier? -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Fwd: liability or expense
Forwarded as I forgot to 'reply all'. Sorry. Newbie brain! Cheerio Graham -- Forwarded message - From: Graham Balin Date: Mon, 6 Aug 2018, 10:12 pm Subject: Re: [GNC] liability or expense To: Baldero Mendoza I have found Gnucash to be a very powerful hammer to crack a very small nut using it for domestic accounts only. Does the job well but there are features of double entry bookkeeping that are superfluous. For example you will have an expenses;groceries account that will be a mass of entries and will never be reconciled because it is irrelevant.just ignore it. It is there to help you categorise your spending. Well, you can reconcile it if you want to spend half your life on your accounts! I'm into my 3rd month and haven't done any reports yet. Just pleased that all bank accounts and liabilities (credit cards)are balanced and reconciled. Investments are taking a bit longer to get my head around. Good luck! Cheerio Graham On Mon, 6 Aug 2018, 10:02 pm Baldero Mendoza, wrote: > Please be patient with me - brand new to this. > > Household financial stuff. I want to post a "google play" purchase. > Should I post as an expense or a liability? > > I have accounts open for things like "electricity" and that seems to > work just fine, but "google play" looks like it works sort of like a > credit card, so I listed it under "liabilities", and that seems to > work too. I made the connected account "checking" and it all seems to > balance and work. > > However, what bothers me is that the "google play" entry under > "liabilities" is listed as a red negative number. So I have two red > negative numbers listed now, one under "liabilities" and one under > "google play". Everything balances, so is it okay or should I place > "google play" purchases as "expenses"? (I just started gnucash so > there aren't any credit card or debit card purchases yet.) The > "expenses" stuff gets listed as black positive numbers even though > they're an outflow of money just like the "google play" stuff under > "liabilities". Maybe it's optional and can be done either way? > Confusing. > > Thank you everybody! > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Column widths again
Hi all, Recent convert from Quicken and pleased overall...BUT... version 2.6.12 on a windows machine and 24" monitor-fine; on a HP laptop...almost unusable due to description column auto-widening to screen width. I have tried trawling through the many posts, dating back 8 years!, and cannot believe that it still happens! Why on earth is there such a feature that is the antithesis of user-friendliness? Is there some programming reason it needs to be there? I have tried all workarounds except going into programming in which I am sadly ignorant. Once I have made the error of re-sizing one of the columns -bang, I have to keep horizontal scrolling to see what is going on. Does 3.2 offer any improvement on this? Has anyone got any suggestions? -- Cheerio, Graham ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column widths again
No, that doesn't work. Sadly my previous 'fix' doesn't work either because as soon as I open a new account window, the widths of all open windows are spoilt. It seems to think my screen is an inch or so wider than it really is, as the balance column is always off-screen. Dragging the right divider doesn't work - as soon as I let go, it springs back to the previous width. What I can't understand is why this problem still happens. Someone once must have coded the auto-size feature for the description column - given that people have been complaining about it for at least 8 years, can it not just be deleted so all columns behave the same way? -- Cheerio, Graham On Wed, 15 Aug 2018 at 21:46, GT-I9070 H wrote: > I have large and small monitors and the sizing of the columns started to > work very well for me after I got enough knowledge to deal with them. > > After you scale all columns to your liking, drag in the header the end > divider of the Description column farthest to the left and then drop it and > it will auto size as much as possible in the window without a horizontal > scrollbar. > > Double-clicking on the column header resizes it to the minimum required > and sets this width, dragging its right divider in the header defines a > fixed width. > > > Regards > GTI > > Em seg, 13 de ago de 2018 às 14:34, Graham Balin > escreveu: > >> Hi all, >> Recent convert from Quicken and pleased overall...BUT... >> version 2.6.12 on a windows machine and 24" monitor-fine; on a HP >> laptop...almost unusable due to description column auto-widening to screen >> width. >> I have tried trawling through the many posts, dating back 8 years!, and >> cannot believe that it still happens! Why on earth is there such a feature >> that is the antithesis of user-friendliness? >> Is there some programming reason it needs to be there? >> I have tried all workarounds except going into programming in which I am >> sadly ignorant. >> Once I have made the error of re-sizing one of the columns -bang, I have >> to >> keep horizontal scrolling to see what is going on. Does 3.2 offer any >> improvement on this? >> >> Has anyone got any suggestions? >> -- >> >> Cheerio, >> >> Graham >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column widths again
Yes. 2.6.12 on Ubuntu with HP Laptop. No matter what I do, only the letters 'Ba' show in the Balance column on the far right of the screen. Clicking tile window allows me to resize the height of the window but not the width. Very frustrating. No problem when I am on my big monitor running 3.1 but then i don't need to resize as the screen is wide enough. However i have tried to resize and the same 'snapping back' occurs. Thanks for the suggestions anyway Cheerio Graham On Thu, 16 Aug 2018, 1:30 pm Colin Law, wrote: > > > On Thu, 16 Aug 2018 at 09:44, Graham Balin wrote: > >> No, that doesn't work. Sadly my previous 'fix' doesn't work either because >> as soon as I open a new account window, the widths of all open windows are >> spoilt. It seems to think my screen is an inch or so wider than it really >> is, as the balance column is always off-screen. >> > > For most people, once they understand how to sort it there is no problem. > Something about your situation must be unusual. > Do you see the same issue if the window is not maximised? > Have you told us which version of GC you are using and on what OS? > > Colin > > >> Dragging the right divider doesn't work - as soon as I let go, it springs >> back to the previous width. >> >> What I can't understand is why this problem still happens. Someone once >> must have coded the auto-size feature for the description column - given >> that people have been complaining about it for at least 8 years, can it >> not >> just be deleted so all columns behave the same way? >> -- >> >> Cheerio, >> >> Graham >> >> >> On Wed, 15 Aug 2018 at 21:46, GT-I9070 H wrote: >> >> > I have large and small monitors and the sizing of the columns started to >> > work very well for me after I got enough knowledge to deal with them. >> > >> > After you scale all columns to your liking, drag in the header the end >> > divider of the Description column farthest to the left and then drop it >> and >> > it will auto size as much as possible in the window without a horizontal >> > scrollbar. >> > >> > Double-clicking on the column header resizes it to the minimum required >> > and sets this width, dragging its right divider in the header defines a >> > fixed width. >> > >> > >> > Regards >> > GTI >> > >> > Em seg, 13 de ago de 2018 às 14:34, Graham Balin < >> graham.ba...@gmail.com> >> > escreveu: >> > >> >> Hi all, >> >> Recent convert from Quicken and pleased overall...BUT... >> >> version 2.6.12 on a windows machine and 24" monitor-fine; on a HP >> >> laptop...almost unusable due to description column auto-widening to >> screen >> >> width. >> >> I have tried trawling through the many posts, dating back 8 years!, and >> >> cannot believe that it still happens! Why on earth is there such a >> feature >> >> that is the antithesis of user-friendliness? >> >> Is there some programming reason it needs to be there? >> >> I have tried all workarounds except going into programming in which I >> am >> >> sadly ignorant. >> >> Once I have made the error of re-sizing one of the columns -bang, I >> have >> >> to >> >> keep horizontal scrolling to see what is going on. Does 3.2 offer any >> >> improvement on this? >> >> >> >> Has anyone got any suggestions? >> >> -- >> >> >> >> Cheerio, >> >> >> >> Graham >> >> ___ >> >> gnucash-user mailing list >> >> gnucash-user@gnucash.org >> >> To update your subscription preferences or to unsubscribe: >> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> >> If you are using Nabble or Gmane, please see >> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> >> - >> >> Please remember to CC this list on all your replies. >> >> You can do this by using Reply-To-List or Reply-All. >> >> >> > >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column widths again
Thanks. doesn't work for me. However, I have discovered that closing Gnucash and re-opening re-sets things, so as long as I leave the column widths alone, all is well. The moment I try to re-size, bang. Masterly inactivity is called for, I think! -- Cheerio, Graham On Mon, 13 Aug 2018 at 21:45, Colin Law wrote: > On Mon, 13 Aug 2018 at 19:37, Graham Balin wrote: > >> ... >> Once I have made the error of re-sizing one of the columns -bang, I have >> to >> keep horizontal scrolling to see what is going on. >> > > All you have to do is to set the column sizes (apart from description) as > you want then double click the description column and it should resize to > fit the window. At least that works for me. > > Colin > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column widths again
What happens is that it springs back to its original width, obscuring the balance column. I'll try the ubuntu forums as Adrien advised. Thanks for all the suggestions. I'll keep you updated. -- Cheerio, Graham On Sat, 18 Aug 2018 at 19:00, David T. wrote: > Graham, > > Once your balance column has disappeared, what happens if you then grab > the *right* hand edge of the Description column, and drag it all the way to > the *left*, and let go? When I take these steps, I am left with a register > that shows the complete balance column, and the Description changes to fill > the remaining space, as it is programmed to do. > > David > > On Aug 17, 2018, at 11:08 AM, Graham Balin wrote: > > Sorry guys if there is any misunderstanding here. There is no account > field or rate field . in the basic ledger view i have > date-num-description-transfer-R-receive-spend-balance. > Double clicking the Balance header moves it right out of view! Description > takes up almost the whole screen. > This is in basic ledger view for asset accounts but the same thing happens > with expense and stock accounts as well. Balance is always off screen. > > Cheerio > > Graham > > On Thu, 16 Aug 2018, 10:53 pm GT-I9070 H, wrote: > >> Em qui, 16 de ago de 2018 às 13:34, David T. via gnucash-user < >> gnucash-user@gnucash.org> escreveu: >> >> > Graham, >> > >> > If your problem is specifically that the Balance column is too narrow, >> > then you’ve encountered a Known Idiosyncrasy: the Balance column is a >> > challenge to resize. In fact, the only way I know to get it to resize >> is to >> > double-click the column heading. This is documented in a note in the >> Guide >> > at 2.3.3. >> > >> > David T. >> > >> >> I resize the Balance column with ease by dragging in the header its right >> divider to the right/left, I can even add/remove the "RATE" field in the >> records sheets so. >> >> Regads >> GTI >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column widths again
Sorry guys if there is any misunderstanding here. There is no account field or rate field . in the basic ledger view i have date-num-description-transfer-R-receive-spend-balance. Double clicking the Balance header moves it right out of view! Description takes up almost the whole screen. This is in basic ledger view for asset accounts but the same thing happens with expense and stock accounts as well. Balance is always off screen. Cheerio Graham On Thu, 16 Aug 2018, 10:53 pm GT-I9070 H, wrote: > Em qui, 16 de ago de 2018 às 13:34, David T. via gnucash-user < > gnucash-user@gnucash.org> escreveu: > > > Graham, > > > > If your problem is specifically that the Balance column is too narrow, > > then you’ve encountered a Known Idiosyncrasy: the Balance column is a > > challenge to resize. In fact, the only way I know to get it to resize is > to > > double-click the column heading. This is documented in a note in the > Guide > > at 2.3.3. > > > > David T. > > > > I resize the Balance column with ease by dragging in the header its right > divider to the right/left, I can even add/remove the "RATE" field in the > records sheets so. > > Regads > GTI > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column widths again- SOLVED!!!!
On 19/08/2018 11:04, Colin Law wrote: What resolution is your screen? You said it works ok on a larger monitor, what display resolutions are you getting on each? Go to Settings > Devices > Screen Displays and it will show you. Aha! By George he's got it! Went into screen displays; changed 'scale for menu and title bars' to .75% and the font got smaller but still easily readable, and there is acres more space on the screen. Balance shows up nicely, no scrolling needed. Slider bars work fine. Many thanks one and all, for the advice and help -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column widths again
On 19/08/2018 11:04, Colin Law wrote: What resolution is your screen? You said it works ok on a larger monitor, what display resolutions are you getting on each? Go to Settings > Devices > Screen Displays and it will show you. Colin 1366*768 on the laptop; 1920x1080 on the [windows] PC -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column widths again
-- Cheerio, Graham On Fri, 17 Aug 2018 at 22:00, Colin Law wrote: > On Fri, 17 Aug 2018 at 19:11, Graham Balin wrote: > >> Sorry guys if there is any misunderstanding here. There is no account >> field >> or rate field . in the basic ledger view i have >> date-num-description-transfer-R-receive-spend-balance. >> Double clicking the Balance header moves it right out of view! Description >> takes up almost the whole screen. >> This is in basic ledger view for asset accounts but the same thing happens >> with expense and stock accounts as well. Balance is always off screen. >> > > I wonder if there is an issue with how big gnucash thinks the window is. > I don't think you replied to my question asking which version of Ubuntu you > are using and also why you can't unmaximise the window. You should be able > to make the window any size you like but you said you could not do that. > > Colin > > >> >> Thanks Colin. Sorry I forgot - Ubuntu 2.16.4 LTS is the version. I can >> pull the vertical sizing bar down to decrease the height of the tile, but >> the horizontal bar won't move at all. >> > Graham ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column widths again
So , forgive me if this is a basic stupid newbie question, but where do I find the screen driver? Do I look in HP or Ubuntu libraries? -- Cheerio, Graham On Sat, 18 Aug 2018 at 00:36, David Carlson wrote: > I think that some installations of Debian and Ubuntu (and probably most > other flavors of Linux) default to 600x800 pixels if there is not a good > screen driver installed. The Dell Inspiron may need a non-free driver. > That could cause what Graham is seeing. I thought that GnuCash could deal > with that, but it would not look nice. I am not sure in that case if it > would help to temporarily switch to two line view and drag the right edge > of the Description title leftward to see the Balance. > > David C > > On Fri, Aug 17, 2018 at 4:00 PM, Colin Law wrote: > >> On Fri, 17 Aug 2018 at 19:11, Graham Balin >> wrote: >> >> > Sorry guys if there is any misunderstanding here. There is no account >> field >> > or rate field . in the basic ledger view i have >> > date-num-description-transfer-R-receive-spend-balance. >> > Double clicking the Balance header moves it right out of view! >> Description >> > takes up almost the whole screen. >> > This is in basic ledger view for asset accounts but the same thing >> happens >> > with expense and stock accounts as well. Balance is always off screen. >> > >> >> I wonder if there is an issue with how big gnucash thinks the window is. >> I >> don't think you replied to my question asking which version of Ubuntu you >> are using and also why you can't unmaximise the window. You should be >> able >> to make the window any size you like but you said you could not do that. >> >> Colin >> >> >> > >> > Cheerio >> > >> > Graham >> > >> > On Thu, 16 Aug 2018, 10:53 pm GT-I9070 H, wrote: >> > >> > > Em qui, 16 de ago de 2018 às 13:34, David T. via gnucash-user < >> > > gnucash-user@gnucash.org> escreveu: >> > > >> > > > Graham, >> > > > >> > > > If your problem is specifically that the Balance column is too >> narrow, >> > > > then you’ve encountered a Known Idiosyncrasy: the Balance column is >> a >> > > > challenge to resize. In fact, the only way I know to get it to >> resize >> > is >> > > to >> > > > double-click the column heading. This is documented in a note in the >> > > Guide >> > > > at 2.3.3. >> > > > >> > > > David T. >> > > > >> > > >> > > I resize the Balance column with ease by dragging in the header its >> right >> > > divider to the right/left, I can even add/remove the "RATE" field in >> the >> > > records sheets so. >> > > >> > > Regads >> > > GTI >> > > ___ >> > > gnucash-user mailing list >> > > gnucash-user@gnucash.org >> > > To update your subscription preferences or to unsubscribe: >> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > > If you are using Nabble or Gmane, please see >> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> > > - >> > > Please remember to CC this list on all your replies. >> > > You can do this by using Reply-To-List or Reply-All. >> > ___ >> > gnucash-user mailing list >> > gnucash-user@gnucash.org >> > To update your subscription preferences or to unsubscribe: >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > If you are using Nabble or Gmane, please see >> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> > - >> > Please remember to CC this list on all your replies. >> > You can do this by using Reply-To-List or Reply-All. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] UK Shares and Yahoo as JSON
Have you tried single-Morningstar GB as your source? Cheerio Graham On Tue, 4 Sep 2018, 8:15 pm Eric Coates, 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 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 JSON as an alternative source. > > Having set the source as Single/Yahoo as JSON for all my shares and > clicking Get Quotes I got very rich! Unfortunately, a quick > investigation revealed that, although my European shares had received > (what looked like) good quotes, the prices received for my UK shares > come back 100 times too big. > > As I have relatively few shares and usually only update the prices at > the end of the month it is not totally ridiculous to input UK share > prices by hand. But it would be so much nicer to be able to do it > automatically. > > Assuming that others are having the same problem with UK shares and > Yahoo as JSON (are they?), is there a known (and hopefully simple) way > to correct the Yahoo prices? > > I wonder if there is a possible alternative: It has been hinted here > that GnuCash 3 has a much improved CSV importer and (if I understand > properly) it is possible to input share prices using it. It would be > possible to get the list of shares and their prices from my broker > account. Is the GnuCash 3 importer documented (I can't find anything) so > as to make the import easy? (But that means upgrading and, again, my > ignorance means I need simple instructions.) > > As always, my thanks to the developers and the documentation team and > other users of this list for their time and efforts > > Best wishes > > Eric > > PS: Please forgive this aside: > > On the Securities Editor page, for me, it is not possible to un-tick the > box in the Get Quote column. Should it be? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Nothing Wrong
Exactly what he said! On Wed, 24 Apr 2024, 18:20 R Losey, wrote: > On Tue, Apr 23, 2024 at 4:00 PM Jim Muchow wrote: > > > I want you maintainers and developers to know that I run GnuCash just > > fine and don't have problems. I very much appreciate such a great free > > product. Thanks. > > > > I kinda wanted to make this an annual thing but I have not been > > consistent about this and for that I apologize. Also this is not > > response to any one or more of the problem reports. Just a note of > > thanks. > > > > I'll add my voice to the growing chorus. I switched from Quicken in 2016 > and am very, very happy with GnuCash itself, and for the additional things > I've learned following this newsgroup. > -- > _ > Richard Losey > rlo...@gmail.com > Micah 6:8 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
