Re: [GNC] Alphavantage quote displaying wrong currency and value

2018-07-08 Thread Mark Blakeney

On 07/09/2018 03:26 AM, Fred Bone wrote:
> Your timezone determines when midnight (and hence a new day) occurs
> relative to UTC. This may be different from the corresponding offset of a
> given quote-source. And you are not "required" to tell Gnucash what
> timezone your quote-source uses: there is a default.

Sorry Fred but that is irrelevant. Of course in general, Finance::Quote 
can fetch time+price pairs but that should irrelevant to GnuCash users. 
GnuCash only needs and wants the very latest price at the time the query 
is done so there is zero justification asking the user to configure 
anything about time. Between them, GnuCash and Finance::Quote, should be 
able to fetch the "latest available" price.


___
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] Saving in GnuCash painfully slow: what can I do?

2018-07-08 Thread Derek Atkins
Hi,

Hmm  writes:

> What can I do to speed things up? I am using GnuCash on a Windows 7 system.

What version of GnuCash are you using?
What do you define as "painfully slow"?
What backend are you using?

> Thank you

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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] GNC List and DKIM (was Re: how to share style sheets between computers in GnuCash 3.1?)

2018-07-08 Thread Derek Atkins
Robert Heller  writes:

> *Some* of the E-Mail providers out there are getting picky WRT DMARC/DKIM.  
> It 
> seems like getting DMARC/DKIM *fully* set up on the outbound SMTP server used 
> by Gnucash's Mailman list might be getting more urgent on the To Do list...

Yeah, it's on my todo list.

>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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] Where to find invoice actions in 3.2?

2018-07-08 Thread Rich Shepard

On Sun, 8 Jul 2018, Geert Janssens wrote:


All these functions can also be found in the menus.
Post/Unpost invoice is in the Edit menu
Process Payment is under Business->Customer or Business->Vendor.


Geert,

  Thanks for the pointer.


It's odd you don't have the little down-arrow on the toolbar. It's still
there on my Fedora 27 system. Perhaps Slackware is using a different
default gtk3 theme?


  I've no idea. Is the theme set within gnucash or gtk3? I thought there
used to be a gtk-config somewhere, but now all the gtk3 supplements I find
are gtk3-demo, gtk3-demo-application, gtk3-icon-browser, and
gtk3-widget-factory.

Regards,

Rich



___
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] Where to find invoice actions in 3.2?

2018-07-08 Thread Geert Janssens
Op zondag 8 juli 2018 19:41:53 CEST schreef Rich Shepard:
>This morning I upgraded from 2.6.21 to 3.2 (on Slackware-14.2) and a
> couple of previously-balanced accounts lost their balance.
> 
>The one I'm trying to fix is a vendor invoice entered, posted, and paid
> on 23 June. The payment check is a transaction in the checking account, but
> it's not appearing in the A/P register so that shows an outstanding balance
> for that invoice.
> 
>In the 2.x versions there was a little down arrow on the bar above the
> accounts tabs where I could post, unpost, and pay outstanding invoices. This
> seems to have disappeared and I've not found to where those functions have
> been moved. I want to unpost that invoice, the repost it and, if necessary,
> re-pay it with the same transaction date, check number, and amount as is
> entered in the checking account register.
> 
>Where are these A/P and A/R invoice functions to be found in 3.2?
> 
> Rich

All these functions can also be found in the menus.
Post/Unpost invoice is in the Edit menu
Process Payment is under Business->Customer or Business->Vendor.

It's odd you don't have the little down-arrow on the toolbar. It's still there 
on my Fedora 27 system. Perhaps Slackware is using a different default gtk3 
theme ?

Geert


___
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] UI question

2018-07-08 Thread John Ralls



> On Jul 8, 2018, at 8:22 AM, Rich Shepard  wrote:
> 
>  I just upgraded from 2.6.21 to 3.2 (on Slackware-14.2) and the text and
> images on the new display appear larger than the 2.x versions. Is there a
> way to select font size for the registers and controls?
> 
>  I found preferences for html reports which allows selection of typeface
> and size but not for the main register display.

See https://wiki.gnucash.org/wiki/GTK3 for all sorts of information about 
customizing GnuCash version 3's appearance.

Regards,
John Ralls

___
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] Alphavantage quote displaying wrong currency and value

2018-07-08 Thread Fred Bone
On 08 July 2018 at 9:51, Mark Blakeney said:

[...]
> Then I eventually discovered the Type/Namespace
> field serves no purpose whatever and can be configured to whatever you
> want to make up! That field should be removed. 
The obvious purpose is to let the user group securities by type. If you 
have no use for such a distinction, you can choose to ignore it.

> Also, why is it required to
> configure a timezone? The software is only after the latest quote price
> and should be able to hide that complexity from the user.

Your timezone determines when midnight (and hence a new day) occurs 
relative to UTC. This may be different from the corresponding offset of a 
given quote-source. And you are not "required" to tell Gnucash what 
timezone your quote-source uses: there is a default.

___
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] 529 Help New

2018-07-08 Thread Thomas E Moughan
Hi Khristine...

With our 529 plans, the price we pay for new shares is more than the
"current" price for the share, e.g. we pay $1.10 for a share with a current
value of $1.00!

Have you accounted for this difference in your GnuCash transaction, e.g.
$.10 per share, expensed to a broker fee or some such? This would reduce
your GnuCash total to what would be on the website..

Tom


>
> Date: Sat, 7 Jul 2018 21:43:28 +
> From: Khristine Ann Ramella 
> To: "gnucash-user@gnucash.org" 
> Subject: [GNC] 529 Help New
> Message-ID:
> <
> bn6pr11mb1779f0755312e6e495be1c93d6...@bn6pr11mb1779.namprd11.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="Windows-1252"
>
> Super clueless new Gnu User seeks someone to help explain 529. I asked for
> help before and was directed to various places which gave a little insight,
> but not as much as I need.
>
> Here is what I have done:Created a Mutual Fund for 529 A and
> one for 529 B?I believe I have done this right but it is open to debate
> since I don?t understand a lot of the specifics required to open the
> accounts (security/commodity?) Yikes!
>   Created a cash
> account to transfer the money out of my checking. Then I went in to the
> mutual fund and made the purchase out of the cash. That seemed to go well.
> The info on my 529 web site/statement and the ledger of my 529 seem to add
> up/match in terms of shares, price paid-HOWEVER the totals don?t add up. My
> gnu total  shows for example 4503 , while my account online total shows 4392
> Also, on my main gnu page instead of showing the total in each account, it
> shows the shares and the account number and then the total is shown
> (incorrectly as mentioned before) under mutual fund in general.
>
>
> I have scoured the internet for videos, articles related to this and no
> luck. I really don?t understand, but would like to if someone can explain
> in simple terms. Open to email lessons or anything
>
> Many thanks
>
>
>
___
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] Where to find invoice actions in 3.2?

2018-07-08 Thread Rich Shepard

  This morning I upgraded from 2.6.21 to 3.2 (on Slackware-14.2) and a
couple of previously-balanced accounts lost their balance.

  The one I'm trying to fix is a vendor invoice entered, posted, and paid on
23 June. The payment check is a transaction in the checking account, but
it's not appearing in the A/P register so that shows an outstanding balance
for that invoice.

  In the 2.x versions there was a little down arrow on the bar above the
accounts tabs where I could post, unpost, and pay outstanding invoices. This
seems to have disappeared and I've not found to where those functions have
been moved. I want to unpost that invoice, the repost it and, if necessary,
re-pay it with the same transaction date, check number, and amount as is
entered in the checking account register.

  Where are these A/P and A/R invoice functions to be found in 3.2?

Rich
___
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] UI question

2018-07-08 Thread Rich Shepard

  I just upgraded from 2.6.21 to 3.2 (on Slackware-14.2) and the text and
images on the new display appear larger than the 2.x versions. Is there a
way to select font size for the registers and controls?

  I found preferences for html reports which allows selection of typeface
and size but not for the main register display.

Rich
___
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] Imbalance-

2018-07-08 Thread Thomas Forrester
The "Imbalance" account is used when GnuCash knows where one side of the
transaction is going, but not the other.  That's actually a pretty helpful
catch-all account for when GnuCash has undistributed amounts.  During the
import, you can specify the other side of the transaction on the screen
that lists all the transactions found in your bank download.  GnuCash will
try to automatch based upon previous transactions that appear to be the
same as one just downloaded, but may have found something completely new,
or not yet figured out what to do with a transaction.  In particular, look
for the ones marked "New, Unbalanced...".  You can double click the entry
and tell GnuCash where the other side of the transaction should go.

You can delete the account, I suppose, but I think GnuCash would just
recreate it next time it finds it needs it.  It's a necessary account since
GnuCash has to have somewhere to put unbalanced amounts.  The goal
shouldn't be to eliminate it, but keep it at a zero balance since a
non-zero balance indicates a problem with a transaction somewhere.  It's a
red flag account.  Preventing it from populating requires making sure all
transactions have corresponding debit and credit accounts (totalling to the
same amount if split).

On Sat, Jul 7, 2018 at 6:44 PM Hmm  wrote:

> I have just installed GnuCash and I am importing Quicken (QFX) files from
> my
> bank (chequing, savings, credit cards etc.) and I have a separate account
> name for Imbalance.
>
> How can I delete this or prevent it from populating in the future whenever
> I
> download transactions?
>
> Thanks
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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] Alphavantage quote displaying wrong currency and value

2018-07-08 Thread Chris Good
From: Mark Blakeney  
Sent: Sunday, 8 July 2018 9:52 AM
To: goodchri...@gmail.com
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Alphavantage quote displaying wrong currency and value

 

Chris,

 

Yes thanks. I actually discovered that myself later on. Obviously it was 
picking up some other US stock called WES.

 

I find this online quote stuff needlessly confusing though. I fretted trying to 
work out what to configure as the "Type" for my stocks given none of the 
default ones (NASDAQ, EUREX, etc) seemed appropriate to my ASX stocks. Also, 
that field is confusingly called "Namespace" when you look in the securities 
editor. Then I eventually discovered the Type/Namespace field serves no purpose 
whatever and can be configured to whatever you want to make up! That field 
should be removed. Also, why is it required to configure a timezone? The 
software is only after the latest quote price and should be able to hide that 
complexity from the user.

 
--
Mark Blakeney.

 

On Sun, Jul 8, 2018 at 9:29 AM Chris Good mailto:goodchri...@gmail.com> > wrote:

> Message: 5
> Date: Sat, 7 Jul 2018 10:59:33 +1000
> From: Mark Blakeney   >
> To: gnucash-user@gnucash.org  
> Subject: [GNC] Alphavantage quote displaying wrong currency and value
> Message-ID:
>ail.gmail.com  >
> Content-Type: text/plain; charset="UTF-8"
> 
> Hi,
> 
> I'm new to gnucash and trying to set up online quotes via Alphavantage. I
am
> using Arch Linux with stock versions gnucash 3.2-1 and perl-finance-quote
1.47-
> 1. I have my API key configured etc and gnc-fq-dump works correctly as
seen at
> https://imgur.com/a/swf5xto.
> 
> I have the stock configured in gnucash as https://imgur.com/a/mblUFvj. My
> default currency is Australian dollars (AUD) everywhere.
> 
> However the online quote is displayed with the wrong currency (US) and
value as
> seen at https://imgur.com/a/gnS8Aau.
> 
> Does anybody know why?

Hi Mark,

You need to add suffix ".AX" to the "Symbol" in the Security Editor.
E.g. CBA.AX  
This tells Finance::Quote to use the price from the ASX using currency AUD.

Regards, Chris Good

 

Hi Mark,

I believe the security Type/Namespace is used to group securities in the 
security editor and Price Editor.

For those with many securities that is probably very useful. You should 
probably create a type called ASX for your aussie stocks. That’s what I did 
IIRC.

I don’t know why the timezone is needed but presumably it is.

The documentation could use some updating. The Help manual section about the 
Security Editor needs updating re Yahoo stopping providing most stock prices. 
Any help gratefully accepted :-)

Regards, Chris

 

___
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.