Split Transaction To Personal And Business

2018-01-01 Thread James Meade
I have one electrical meter on the house and the farm shop. I need to allocate a percentage of the monthly (variable) check to each account because they have a different tax structure. Any hints or references appreciated on how to set up the accounts is appreciated. I'm new to gnucash an

Re: Alphavantage

2018-01-01 Thread Dave H
Check out https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F for instructions Any further questions it would be helpful to quote your OS and gnucash version. Cheers Dave H On 2 January 2018 at 14:42, Gerald Ellis wrote: > I receive an error message "Alphavantage API

Alphavantage

2018-01-01 Thread Gerald Ellis
I receive an error message "Alphavantage API Key not set". I have retrieved the Free API Key but am not sure how to Set It. Any help? Jerry ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user -

Re: Security Editor

2018-01-01 Thread John Ralls
Try disabling price retrieval on all but one stock, one that you know is still trading. If price retrieval still fails with just the one then check that you set up your Alphavantage key correctly and that there’s only one instance of F::Q on your system and it’s 1.47. Once you have price retri

Re: Register view

2018-01-01 Thread David Carlson
Select View> Double Line David C On Mon, Jan 1, 2018 at 7:37 AM, John Morgan via gnucash-user < gnucash-user@gnucash.org> wrote: > Is it possible to have both the description field and memo field in the > register view. At the moment I have only the description field and I cannot > see how to ad

Re: Register view

2018-01-01 Thread Liz
On Mon, 1 Jan 2018 19:14:57 -0800 Greg Feneis wrote: > Yes you can. Check the view menu for an item with a similar name. I > can't recall exactly what it's called > > Kind regards, Greg Feneis You would like to see "Double Line" from the View menu. Liz ___

Re: Register view

2018-01-01 Thread Dave H
View >> Transaction Journal may be what you're after ? Cheers Dave H. On 1 January 2018 at 23:37, John Morgan via gnucash-user < gnucash-user@gnucash.org> wrote: > Is it possible to have both the description field and memo field in the > register view. At the moment I have only the description

Re: hidden

2018-01-01 Thread Kenneth Schneider
I just went through this myself. Under one of the pull downs is an option for Filters. Click on it and on the window that opens select the option for hidden accounts. Ken Schneider > On Jan 1, 2018, at 10:33 AM, "tom9...@earthlink.net" > wrote: > > Last year I edited an account to mark it

Re: Register view

2018-01-01 Thread Greg Feneis
Yes you can. Check the view menu for an item with a similar name. I can't recall exactly what it's called Kind regards, Greg Feneis (Samsung Galaxy S5) On Jan 1, 2018 7:10 PM, "John Morgan via gnucash-user" < gnucash-user@gnucash.org> wrote: Is it possible to have both the description field a

hidden

2018-01-01 Thread tom9...@earthlink.net
Last year I edited an account to mark it as hidden. Now I want to see it again. How do I un-hide it? Thomas Marks Thomas Marks ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Plea

Register view

2018-01-01 Thread John Morgan via gnucash-user
Is it possible to have both the description field and memo field in the register view. At the moment I have only the description field and I cannot see how to add the memo field John ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Yes gnucash was closed, I had admin rights, and I checked the spelling. I believe thats fine because it works in gnucash now. On Mon, Jan 1, 2018 at 6:43 PM David Carlson wrote: > Elias, > > Have you rechecked your gnucash environment file for spelling, leading > comment characters, etc? > > You

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread David Carlson
Elias, Have you rechecked your gnucash environment file for spelling, leading comment characters, etc? You did have admin rights when you edited it? Did you quit gnucash before editing it? David C On Jan 1, 2018 4:56 PM, "Elias K Gardner" wrote: Ok took me awhile to realize I needed to be in

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Ok I think I solved it reading about CPAN on the wiki https://wiki.gnucash.org/wiki/CPAN If I understand it right running 'cpan -D Finance::Quote' reported my CPAN being out of date. So I ran 'sudo cpan' and then 'upgrade' to upgrade it (does that upgrade perl too?). Anyway alphavantage now shows

Re: Thank You!

2018-01-01 Thread Adrien Monteleone
Don’t forget, asking questions is super helpful. I can’t count how many times I’ve seen a question asked about a topic I haven’t yet come across, but remember down the road when I do. And I know I can come back here to the list archives and find the discussion. So thanks to ALL who participate

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Ok took me awhile to realize I needed to be in /usr/bin and run 'export ALPHAVANTAGE_API_KEY=##' first. Then it appears 'perl gnc-fq-dump -v alphavantage AMZN' works returning this: "Finance::Quote fields Gnucash uses: symbol: AMZN <=== required date: 12/29/201

Best source for stock prices

2018-01-01 Thread Jon Schewe
I've seen some discussion recently on the list about Yahoo changing access to their stock quotes and this new alphavantage source. What is the best free source to be using for US finance quotes these days? I had been using US Multiple, but that doesn't appear to be updating lately. I'm currently

Re: Company sponsored stock plan

2018-01-01 Thread Mike or Penny Novack
On 1/1/2018 4:01 PM, Klaus Dahlke wrote: Stop --- this advice depends on jurisdiction (in the US, the contributions if "pretax" are taxed only at distribution time many years down the road). But there may be other complications. The employer contribution is usually "conditional" becoming veste

Re: Price Editor - currency exchange rates

2018-01-01 Thread David Carlson
Ismael, It seems that I failed to see your question until now, and perhaps most others did not see it either or someone would have responded. Alas, I do not know what happened in your case, but hopefully someone else will know. I do suspect, however, that it may be a bug in the Finance-Quote mod

Re: Security Editor

2018-01-01 Thread Carlos A. Garcia
Dear John, first of all, have a good 2018. I installed the same version 2.6.19 in Windows, and as you said, is automatic. And works perfect. My problem still in my version 2.6.19 in Linux Mint 18.3 + Cinnamon (and 2.6.12, pre compiled and others versions aI checked) There are some problem in t

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Fross, Michael
​Hi Elias, Take GNUCash out of the equation. If you run : perl gnc-fq-dump -v alphavantage AMZN That should tell you if F:Q can get to alphavantage. I'm not sure if that will be in your path so you might have to find gnc-fq-dump. If that works or not it will help to narrow it down. Michael

Re: Company sponsored stock plan

2018-01-01 Thread Klaus Dahlke
On Sun, 31 Dec 2017 10:00:55 -0500 Mike or Penny Novack wrote: > On 12/30/2017 4:39 PM, Klaus Dahlke wrote: > > Hi Wolfgang, > > I have modeled a comparable plan as follows: first of all, I record my > > salary only net. Salary is what is posted to my bank account after all > > deductions. >

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Ah so it is. When I set it to "Yahoo as json" and get quotes it says unable to retrieve quotes. Definitely no Alphavantage source. Version 1.47 is the newest version of Finance:Quote. I've tried to update it separately per the wiki and it says I have the newest version. On Mon, Jan 1, 2018 at 2:13

Re: Thank You!

2018-01-01 Thread Rachel Gibb
happy new year! appreciate you all On Mon, 01 Jan 2018 12:35:33 -0600, ph hermes wrote: i agree. appreciate the developers and contributors. very much. happy new year ! ~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~: writer ~:~ photographer ~:~ book designer resident manager paulahendricks.com On Mon

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread David Carlson
I think Yahoo_json is under the Single source tab in the get quotes section of the security editor. In GnuCash 2.6.18 Windows Alpha Vantage is the second choice under Other. I have not investigated updating Finance:Quote in Linux yet, but as is mentioned in the wiki, it probably needs to be updat

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
gnc-fq-check returns 1.47 as the first value in quotes I believe this means I have version 1.47. On Mon, Jan 1, 2018 at 1:47 PM Derek Atkins wrote: > What version of F::Q do you have installed? > > -derek > Sent using my mobile device. Please excuse any typos. > > > > On January 1, 2018 1:45:51

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Derek Atkins
What version of F::Q do you have installed? -derek Sent using my mobile device. Please excuse any typos. On January 1, 2018 1:45:51 PM Elias K Gardner wrote: Thanks Michael, yahoo_json does not show up in my unknown sources either. I wonder if that is related to my problem. On Mon, Jan 1,

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Thanks Michael, yahoo_json does not show up in my unknown sources either. I wonder if that is related to my problem. On Mon, Jan 1, 2018 at 1:17 PM Fross, Michael wrote: > While this doesn't answer your question, I switched to Alphavantage > without issue, but then switched to yahoo_json as it's

Re: Thank You!

2018-01-01 Thread ph hermes
i agree. appreciate the developers and contributors. very much. happy new year ! ~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~: writer ~:~ photographer ~:~ book designer resident manager paulahendricks.com On Mon, Jan 1, 2018 at 9:24 AM, Les wrote: > I would like to give a great big Thanks to all the peop

How to deal with RRSP's (Canada)

2018-01-01 Thread lejohnston
Hi, I am starting my second year in GNUCash. I think I may have set up my RRSP's (I think in the US they are 401K's) incorrrectly. I have them as Asset accounts under Current Assets. At first it seemed ok but now as I am getting closer to starting to withdraw funds rather than deposit them I am

Re: Alphavantage not an option in unknown online source list

2018-01-01 Thread Fross, Michael
While this doesn't answer your question, I switched to Alphavantage without issue, but then switched to yahoo_json as it's much faster. I assume it will go away at some point and I'll have to switch back to Alphavantage. I'm currently running on Windows and it's available in unknown sources so I'

Alphavantage not an option in unknown online source list

2018-01-01 Thread Elias K Gardner
Hey there. I've followed the directions on the wiki for switching my online quotes from Yahoo! to Alphavantage but in the security editor alphavantage does not show up under unknown sources. What have I done wrong? I got an Alphavantage API key and I added ALPHAVANTAGE_API_KEY=## (with

Thank You!

2018-01-01 Thread Les
I would like to give a great big Thanks to all the people that help us all with issues and the users that also contribute.  I do not know how you can be so patient when you ask the same questions day in and day out, but I marvel at your persistence.  At any rate, I have been meaning to do this

Re: Dealing with a large QIF file

2018-01-01 Thread Cliff McDiarmid
Sent: Thursday, December 28, 2017 at 8:11 AM From: "jeffrey black" To: "l...@lincolnbaxter.com" , "cliffhan...@gardener.com" , "Colin Law" Cc: "gnucash-user@gnucash.org" Subject: Re: Dealing with a large QIF file On 12/24/2017 8:08 PM, Lincoln A Baxter wrote: > On Mon, 2017-12-25 at 00:46 +000

How to get rid of "Could not determine the account currency. Using the default currency provided by your system."

2018-01-01 Thread Paul Neuwirth
Hello, I always get "Could not determine the account currency. Using the default currency provided by your system." when opening an account since upgrade to 2.6.19. according to SQL SELECT * FROM gnucash.accounts a left join gnucash.commodities c on c.guid = a.commodity_guid; all accounts have a c