Re: 2.7.4 install

[Geert Janssens]

Op donderdag 8 februari 2018 02:03:44 CET schreef Michael via gnucash-user:
> Hello all, I haven't seen much about 2.7.4, so maybe this is not the
> place.  Anyway I was able to install on linux using cmake (first time
> for me).  Went reasonably well given all.  It worked! Used yahoo as json
> for quotes as the financial data file is set up that way.  Overall,
> seems to be a lag when bringing up a new view or resizing windows, etc
> and to be somewhat slower loading the XML datafile.  On trying SQLite
> says no back end, even though earlier versions worked on this machine. 
> Seem to have lost my tax item selections.  Otherwise, on a quick look,
> seems quite good for a beta version.  Thanks for your efforts.  Mike

Thanks for the quick review.

There certainly are still a few quirks to iron out as you have found as well.

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: Price Retrieval Failure, Part 2

[John Ralls]

> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user 
>  wrote:
> 
> In thread 
> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
> , 
> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
> was an unknown error while retrieving the price quotes.”
> 
> *** As I noted there: Finance::Quote works at the command line:
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
> alphavantage AAPL
> Finance::Quote fields Gnucash uses:
>symbol: AAPL <=== required
>  date: 02/08/2018   <=== recommended
>  currency: USD  <=== required
>  last: 160.1350 <=\   
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> *** As I noted earlier: I restored the following two lines to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
> 
> # Set AlphaVantage API Key to allow Finance::Quote to work
> ALPHAVANTAGE_API_KEY=8SET
> 
> It seems to me that somehow Gnucash.app is not reading or using the 
> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
> somehow my environment file is not properly configured. However, I do not see 
> any way to test these hypotheses. 
> 
> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
> the Alphavantage API key is being read, and what its value currently is? Is 
> there any other way to troubleshoot this problem?

David,

There’s no UI for examining the environment. I can only say that it works for 
me on MacOS 10.13 and GnuCash 2.6.19.

If you’re willing to hack a bit you could add a snippet to 
GnuCash.app/Contents/Resources/bin/gnc-fq-helper to print out the value of the 
key:

  print (“Alphavantage Key: $ENV{‘ALPHAVANTAGE_API_KEY’}\n”}

Put it down at the bottom somewhere after the #Runtime comment. You’ll have to 
run GnuCash from the command line to see that output.

Geert pushed a commit last week that keeps the Alphavantage key in preferences 
instead of the environment file so that in 3.0 one won’t have to keep resetting 
the environment file.

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: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

John,

Thanks for the suggestion. I inserted the line as you indicated (at line 324 in 
my copy of gnc-fq-helper), but didn’t get any output on the command line after 
“Found Finance::Quote version 1.47”

I’m not much for perl, but I noticed your snippet had one ‘(‘, one  ‘{‘, and 
two ‘}’. I tried it that way, and then I tried changing the last ‘}’ to ‘)’, 
but that didn’t change anything. I also tried adding a semi-colon at the end of 
the line, without effect. Heck, I even tried putting a Hello world print 
statement, but that didn’t generate either. Either I am a bone fide idiot, or 
there is something else going on here. I’ve got my money on the first, but I 
hold out hope that it’s the second. Is it possible that I’ve latched on to the 
wrong file somehow? Or that the command isn’t going to the standard output?

David

P.S.: Should I be seeing:

/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
 Error: unsupported compressor 8
/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
 Error: Unknown compression scheme encountered for file 
'/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/Exceptions.plist'
/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
 Error: unsupported compressor 8
/BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
 Error: Unknown compression scheme encountered for file 
'/System/Library/CoreServices/CoreTypes.bundle/Contents/Library/AppExceptions.bundle/Exceptions.plist’

at the command line? This appears at startup before the F::Q note...

> On Feb 8, 2018, at 9:33 PM, John Ralls  wrote:
> 
> 
> 
>> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> In thread 
>> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>> , 
>> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
>> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
>> was an unknown error while retrieving the price quotes.”
>> 
>> *** As I noted there: Finance::Quote works at the command line:
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
>> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
>> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
>> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
>> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>> alphavantage AAPL
>> Finance::Quote fields Gnucash uses:
>>   symbol: AAPL <=== required
>> date: 02/08/2018   <=== recommended
>> currency: USD  <=== required
>> last: 160.1350 <=\   
>>  nav:  <=== one of these
>>price:  <=/
>> timezone:  <=== optional
>> 
>> *** As I noted earlier: I restored the following two lines to 
>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
>> 
>> # Set AlphaVantage API Key to allow Finance::Quote to work
>> ALPHAVANTAGE_API_KEY=8SET
>> 
>> It seems to me that somehow Gnucash.app is not reading or using the 
>> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
>> somehow my environment file is not properly configured. However, I do not 
>> see any way to test these hypotheses. 
>> 
>> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
>> the Alphavantage API key is being read, and what its value currently is? Is 
>> there any other way to troubleshoot this problem?
> 
> David,
> 
> There’s no UI for examining the environment. I can only say that it works for 
> me on MacOS 10.13 and GnuCash 2.6.19.
> 
> If you’re willing to hack a bit you could add a 

Applying Customer overpayments

[Alan Johnson]

Hello, I'm having an issue with GnuCash. A customer has a 
overpayment/credit balance. How do I apply it to an invoice so that it 
comes out of the AR report at the bottom of the customer report? The 
total due / sums are correct, but the customer report has a 91+ day 
balance of (0.03). I would like to apply the payment to an invoice / fix 
the AR box on the customer report. This is on version 2.6.19.


Thanks,

Alan

___
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: can't change preferences [SOLVED]

[Geert Janssens]

Op woensdag 7 februari 2018 09:16:45 CET schreef Graham Menhennitt:
> Thanks again for your help,
>  Graham

I glad to hear you managed to sort this out!

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: Accounting rules

[Adrien Monteleone]

Sorry, I'm not using my usual mail software and forgot to reply to the
list. I'm copying this for posterity, my apologies Bert for the duplicate
message.

--
I suppose the term 'exploit' then was the most concise and precise choice.
It just wasn't what I guess I was thinking of in this context at first.

Certainly, speak to a local accountant for specific recommendations for
your situation, especially with respect to the cash portion of the business.

With respect to Gnucash, you'd probably want to set up 2 liability
accounts, one for each VAT.

Liabilities:VAT Payable:Low
Liabilities:VAT Payable:High

(optionally include the rate in the name, but that depends on how often it
is likely to change)

This way you can track which one you owe and can post invoices/transactions
to each one separately.

For the income/revenue accounts you could get specific and have one for
each type of equipment or keep it generalized. Since you earn money from
both using equipment directly and renting, you could put the equipment
first in the hierarchy.

Income:Carousel:Operations
Income:Carousel:Rentals
Income:Train:Operations
Income:Train:Rentals
Income:Food Carts:Operations
Income:Food Carts:Rentals

Optionally, you could make the Operations and Rentals as the higher level
accounts and place each type of equipment under them.

Income:Operations:Carousel
Income:Operations:Train
Income:Operations:Food Carts
Income:Rentals:Carousel
Income:Rentals:Train
Income:Rentals:Food Carts

Either method will allow you to produce reports specific to each type of
income and each type of equipment. The second method is probably easier to
use because of the way accounts are selected in the report options and is
probably more commonly used since you are more likely to want to see for
the business overall where your revenue is coming from and then only later
get specific with details of which attractions and locations are profitable.

I'd use the transaction memos for including the location to use as a report
filter. There is also an action field on the left of the transaction just
to the right of the date (under the NUM field) You could repurpose this to
hold a simple weather term like 'sunny' 'cloudy' or 'rainy' etc. That field
should be available as a filter as well.

On Wed, Feb 7, 2018 at 6:37 PM, Bert Heijne  wrote:

> Adrien,
>
> Q1 has been answered. was easy so have don that.
>
> Q2 - I'm Dutch [Hollander] and you have it quite right.
>
> Q1-  My story is that we own some attractions carousel's, a train and
> other smaller stands with food.
> We Have 2 VAT categorized for us , the low one 6% and high 21%
>
> Most of the time we operate the carousel (attractions) by ourself,  so we
> earn cash money so thats low VAT 6% going from city to city or village.
> Most of the city's we have to pay rent for the spot we are standing on.
> For city's we regularly visit I would like to make a report of revenue for
> that city. but for now thats not a priority.
>
> When we rent our carousel and ourselves for a day with free rides for the
> kits it is high VAT 21% and get payed in cash on delivery or afterwards but
> also by invoice (hopefully in advance by reservation)
>
> Al the things we own and rent out is high VAT by a rent contract and so we
> can make invoices.
>
> If we selling food only is 6% VAT but when we rent out a food stand with
> food it is High VAT. (with gnucash we can make a high and low specific VAT
> invoice but for now we only rent out with high VAT)
>
> The expenses for maintenance of the attractions can go into another total
> expense account and make reports from the memo fields
>
> I hope this explains to you how my business works.
>
> Q 3 because we have much cash flow do we need a payment condition for cash
> payment invoices and also VAT rates for Cash?
>
> Ps I can send you my Accounts overview, its in dutch but can translate it
> for u.
>
> Bert.
>
>
> 
> Van: Bert Heijne
> Verzonden: woensdag 7 februari 2018 12:12
> Aan: gnucash-user@gnucash.org
> Onderwerp: Accounting rules
>
> Hello everyone,
>
> As a new be to bookkeeping and Gnucash. I have some questions about
> accounting. I already did some work with GC and read the manual.
> My company is a rental of party material and we have some attractions that
> we rent and we exploit the attractions.
>
> So we have invoice and bills, cash income from the rental (pay at
> delivery) and Cash income from the attractions.
>
> 1- Is it wise to give the attractions we exploit and have cash income
> from, make them customer so we can track their income and get it to the
> wright Vat box. Also track information about where and Weather conditions?
> Say reservation of the first 20 customer numbers for the attractions.
>
> 2- Can I remove a customer from the customer list that i accidental made?
> (it was suppose to be a vendor) or just change the input. customer isn't
> used yet in any transaction.
>

Re: Applying Customer overpayments

[Geert Janssens]

Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson:
> Hello, I'm having an issue with GnuCash. A customer has a
> overpayment/credit balance. How do I apply it to an invoice so that it
> comes out of the AR report at the bottom of the customer report? The
> total due / sums are correct, but the customer report has a 91+ day
> balance of (0.03). I would like to apply the payment to an invoice / fix
> the AR box on the customer report. This is on version 2.6.19.
> 

- Go to Business->Customer->Process Payment
- Select the customer you refer to above
- You should get a list of open invoices and overpayments
- Select both the 0.03 overpayment and the invoice you want to apply it to 
(using shift- or ctrl-click)
- If you only want to apply this 0.03, adjust the amount to exactly that 0.03
- Click Ok

Regards,

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: Price Retrieval Failure, Part 2

[Geert Janssens]

David,

You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
Library/Application Support/Gnucash)

If you then start gnucash from the command line, it should print out the value 
of your API key there, together with the version of Finance::Quote that got 
installed. Unless the OS X edition doesn't print this early boot 
information...

Regards,

Geert(let ((api-key (getenv "ALPHAVANTAGE_API_KEY")))
  (if (not api-key)
  (display "ALPHAVANTAGE_API_KEY is not set\n" (current-error-port))
  (display (string-append
  "ALPHAVANTAGE_API_KEY is set to '"
   (getenv "ALPHAVANTAGE_API_KEY")
   "'\n")
   (current-error-port)
  )
  )
)
___
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: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

[Roger Miskowicz]

Thanks Tim, that is the same as my situation and I like your solution.  I
am not worried about tax time as I just need to have a general idea I can
use for a sort of sanity check.  I will try your solution in parallel.


On Thu, Feb 8, 2018 at 11:30 AM, Timothy B. Taylor 
wrote:

> Roger, there may be a simpler solution. I had an investment account that
> internally was kind of a mess, with various holdings that I really didn't
> want to try to track individually. The reports from the investment company
> were sufficient to track dividends and gains and to report taxes. I wanted
> to track the overall value in that account, but I didn't want to or need to
> deal with the internal ups and downs.
>
> So I created an asset account (type=asset) with the opening balance the
> total value of the account and date shown on the most recent statement.
>
> Then I created an equity account called Changes in Investment Value or
> something similar with an opening balance of zero.
>
> Periodically I add a transaction in the asset account to reflect the
> accumulated changes in value since the last transaction, to make the
> Gnucash account balance match the total value of the account. This
> transaction is balanced against the corresponding equity account. This
> makes sense to me. When my overall asset value goes up, so does my equity.
> And vice versa.
>
> In effect I am treating this investment account as a cash account, with a
> particular value on any given day, with ups and downs corresponding to the
> overall value of the account.
>
> The result is my Gnucash net worth, balance sheet and similar reports make
> sense. But of course dividends, capital gains, purchases, sales, investment
> fees and similar accounts do not. At tax time I have to add the Gnucash
> results to the data received from the investment company.
>
> I'm sure this won't pass anyone's proper-accounting test, but it seems to
> work for me. Tim
>
> On Thu, Feb 8, 2018 at 10:47 AM, Roger Miskowicz 
> wrote:
>
>> I went through the section 9.5.3 Entering Pre-Existing Stocks for about
>> the
>> fifth time.  Don't know what I did differently but it now works as
>> expected.  Before it used to crash when I tried a price update.
>>
>> Actually it still crashes when I click on Apply instead of Ok when editing
>> a Price Entry.  (I think, I need to check it out more to determine exactly
>> what I am doing to cause the crash).
>>
>> Is there a related bug in 2.6.12?
>>
>> On Thu, Feb 8, 2018 at 9:28 AM, David Carlson <
>> david.carlson@gmail.com>
>> wrote:
>>
>> > If you want to create a fictional stock and manually enter prices from
>> > time to time that is easy.
>> >
>> > Just use the security editor and invent a name and symbol, possibly
>> under
>> > the group called Fund.  Do not set an online quote source.  Then
>> manually
>> > use the price editor to enter prices for whatever dates you like.
>> >
>> > David C
>> >
>> > On Thu, Feb 8, 2018 at 8:00 AM, Roger Miskowicz 
>> > wrote:
>> >
>> >> Sorry, I just want to take a number from one online brokerage report
>> and
>> >> manually put it into gnucash.
>> >>
>> >> On Thu, Feb 8, 2018 at 6:28 AM, David T.  wrote:
>> >>
>> >> > Roger,
>> >> >
>> >> > You stay by stating that you are able to generate a report that tells
>> >> you
>> >> > "the current value of everything."  Then, you ask how you can add
>> >> another
>> >> > layer of complexity to accomplish the same thing?
>> >> >
>> >> > I don't understand: what's wrong with the report?
>> >> >
>> >> > David
>> >> >
>> >> >
>> >> > On Thu, Feb 8, 2018 at 16:14, Roger Miskowicz
>> >> >  wrote:
>> >> > I have an Investment Account which is a collection of stocks,
>> >> certificates,
>> >> > cash etc in two currencies.  I can get a report that tells me in my
>> >> local
>> >> > currency the current value of everything.
>> >> >
>> >> > I would like to create a stock, fund, or whatever appropriate with 1
>> >> share
>> >> > for which  I can manually update a single price representing the
>> current
>> >> > value of the entire collection.
>> >> >
>> >> > Using the online guide I have tried creating a fund or stock but I
>> don't
>> >> > understand the process and can't seem to get it to work and even
>> >> > ocassionally crashing gnucash.
>> >> >
>> >> > I think I would like something such as:
>> >> >
>> >> > Investment
>> >> >   Stocks
>> >> > myStock  (I would like to manually update the price of a single
>> >> share.)
>> >> >
>> >> >
>> >> > I am using gucash 2.6.12 on Ubuntu 16.04 LTS.
>> >> >
>> >> > I would appreciate it if someone can suggest a way to do this.
>> >> > ___
>> >> > 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 

Re: How to relate Transfer Sales to Cash to Customer?

[Derek Atkins]

No.
Customers only exist in AR.
Sorry.

-derek
Sent using my mobile device. Please excuse any typos.



On February 8, 2018 2:17:56 PM Fran_3 via gnucash-user 
 wrote:


 When a customer pays cash or by credit card there is no reason to create an 
 invoice... so we click Accounts Tab -> Action -> Transfer

and transfer directly Sales to Cash
But there seems to be no way to relate this to a customer so when we run a 
Customer Report the transactions don't show up.
Is there a way to fix this short of creating an invoice first... putting it 
in Sales and A/R

And then "Process Payment" to take it out of A/R and into the Cash account?
Thanks for any help.
Fran3


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

How to relate Transfer Sales to Cash to Customer?

[Fran_3 via gnucash-user]

 When a customer pays cash or by credit card there is no reason to create an 
invoice... so we click Accounts Tab -> Action -> Transfer
and transfer directly Sales to Cash
But there seems to be no way to relate this to a customer so when we run a 
Customer Report the transactions don't show up.
Is there a way to fix this short of creating an invoice first... putting it in 
Sales and A/R
And then "Process Payment" to take it out of A/R and into the Cash account?
Thanks for any help.
Fran3

  
___
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: How to relate Transfer Sales to Cash to Customer?

[Greg Feneis]

I suspect Gnu Cash needs a point of sale (POS) module to handle this
functionality.

I bet patches are welcome.

Patches, he's a popular guy.

Kind regards, Greg Feneis
(Galaxy S5)

On Feb 8, 2018 11:23 AM, "Derek Atkins"  wrote:

No.
Customers only exist in AR.
Sorry.

-derek
Sent using my mobile device. Please excuse any typos.




On February 8, 2018 2:17:56 PM Fran_3 via gnucash-user <
gnucash-user@gnucash.org> wrote:

 When a customer pays cash or by credit card there is no reason to create
> an  invoice... so we click Accounts Tab -> Action -> Transfer
> and transfer directly Sales to Cash
> But there seems to be no way to relate this to a customer so when we run a
> Customer Report the transactions don't show up.
> Is there a way to fix this short of creating an invoice first... putting
> it in Sales and A/R
> And then "Process Payment" to take it out of A/R and into the Cash account?
> Thanks for any help.
> Fran3
>
>
> ___
> 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.

Duplicating Accounts?

[Steve Isenberg via gnucash-user]

I figured out how to do this once before and now for thelife of I cannot 
remember. I am trying to duplicate an expense account and allof its 
sub-accounts, with a new name of course, and zero balances. 

This is not a transfer of funds and I'm not duplicatingtransactions. It is 
basically a copy of one account hierarchy to a new expenseaccount hierarchy.

Anyone remember how to do this without creating a newaccount and eight new 
sub-accounts?

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.

Re: How to relate Transfer Sales to Cash to Customer?

[Mike or Penny Novack]

On 2/8/2018 4:00 PM, Greg Feneis wrote:

I suspect Gnu Cash needs a point of sale (POS) module to handle this
functionality.


I think not exactly a module withing gnucash.

What gnucash would need is the ability to accept a feed from a (typical) 
POS system. Whether a POS system is practical as an open source project 
is another matter. Many (most?) that exist are tied to some company's 
cash registers, may be scanning in customer ID << I am going by what I 
see out there as a customer >>


Keep in mind, in the usual situation, you would NOT be wanting the sales 
clerks (who are ringing through customers) to have any access to the 
accounting system.


Open source POS (and inventory, see below) more practical based on the 
assumption that instead of a cash register would be a general purpose 
small computer the sales clerk used. Would be an app where a customer 
number was entered, purchases one at a time (know what is taxable), 
total the bill and note how paid (cash, check, credit card). Then feed 
the accounting and inventory systems.


Michael D Novack

PS: Interfaces with an inventory system similar. There, ideally you 
would want POS to feed inventory as well as "general ledger" and 
inventory to feed general ledger. In our case, the general ledger system 
would be gnucash.

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

Finance::Quote - ASX problems (alphavantage and ASX sources)

[ln . mailinglists]

Hi All,

Just a quick heads up that neither source for ASX share prices is
working properly/consistently at the moment (or at least I haven't
worked out the consistency issues with alpha vantage). 

1) The old (and most reliable) "Single" source data feed direct from
the ASX stopped working on/around 21st January. See the following
whirlpool link for more details:

http://forums.whirlpool.net.au/archive/2678938

This forum page suggests that there are couple of alternative feeds
now available from the ASX. However, the ASX hasn't provided any
information on which of these (if any) will be supported in the long
term. I'm keeping an eye on this page and when things stabilise, I'll
see if I can figure what needs to be changed in ASX.pm. Even then, it
may take a while, as it has been more than a decade since I last
@$!%// with perl.

2) Alphavantage is kind-of working. You can definitely pull data using
.AX. However, the feed is somewhat inconsistent. To show the problem,
at the of end of this message, I've included a dump at from for
Telstra generated by the following alpha vantage web page:

https://www.alphavantage.co/query?function=TIME_SERIES_DAILY=TLS.AX=***.

The problem with the alpha vantage data is all about dates. I
generated the dump below on the morning of the 9th of February. The
first problem is that the most recent data in the Telstra data set is
for the 7th, when it should be showing the 8th. Unfortunately, there
is also a consistency problem - if I do a similar dump for VAS or STW,
then both of them provide data for the 8th.

I think this may be a time zone problem - but if so, it's a slightly
odd one, where normal run of the mill ASX stocks (TLS, WEL, FMG) 
will need to be collected based on one time zone, whereas ETFs (VAS,
STW, etc.) need to be collected on another. I picked this up because
I've used the local time zone for pulling data, and this results in
some, but not all ASX valuations being off by one day.

I'll update this when I've done a bit more digging, but I thought
other users of the ASX data sets would be interested to know about
this anomaly.

Cheers,

Larry

{ "Meta Data": { "1. Information": "Daily Prices (open, high, low,
close) and Volumes", "2. Symbol": "TLS.AX", "3. Last Refreshed":
"2018-02-07", "4. Output Size": "Compact", "5. Time Zone":
"US/Eastern" }, "Time Series (Daily)": { "2018-02-07": { "1. open":
"3.4900", "2. high": "3.5700", "3. low": "3.4900", "4. close":
"3.5600", "5. volume": "22698598" }, "2018-02-06": { "1. open":
"3.5400", "2. high": "3.5700", "3. low": "3.5000", "4. close":
"3.5000", "5. volume": "27375575" }, "2018-02-05": { "1. open":
"3.5600", "2. high": "3.5600", "3. low": "3.4800", "4. close":
"3.5100", "5. volume": "53276602" }, "2018-02-04": { "1. open":
"3.6400", "2. high": "3.6400", "3. low": "3.6050", "4. close":
"3.6200", "5. volume": "21058372" }, "2018-02-01": { "1. open":
"3.6300", "2. high": "3.6750", "3. low": "3.5900", "4. close":
"3.6700", "5. volume": "30491033" }, "2018-01-31": { "1. open":
"3.6800", "2. high": "3.6800", "3. low": "3.6200", "4. close":
"3.6400", "5. volume": "38593165" }, "2018-01-30": { "1. open":
"3.6000", "2. high": "3.6900", "3. low": "3.5750", "4. close":
"3.6700", "5. volume": "38783867" }, "2018-01-29": { "1. open":
"3.6100", "2. high": "3.6350", "3. low": "3.6000", "4. close":
"3.6000", "5. volume": "14138824" },
 


___
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: Online quotes fetching the wrong price

[farleykj]

You could also, without any alphavantage stuff, obtain quotes from the
"yahoo_json" source, again using NAB.AX as the symbol. Hopefully yahoo won't
kill off this source, too.



-
Ken Farley
--
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.

Re: GNUCASH Free Accounting Software

[James fuller]

Adrian,
I saw your reply below.  I cannot seem to print by date range.  What I’m trying 
to do is print the bank account transactions by date. Specifically the year 
2017.  I also need to print out a couple of expense account transactions for 
the same period.  I did not close
2016 and every report I have printed shows all of 2016 along with 2017.
What am I missing?

Thanks
James Fuller 

Sent from my iPad

> On Feb 3, 2018, at 3:43 PM, Adrien Monteleone  
> wrote:
> 
> the

___
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: GNUCASH Free Accounting Software

[David Carlson]

If you want to do a register report for a certain time range open the
register window and choose View > Filter by.. > Date to select your time
window then select Reports > Account Report.

David C

On Thu, Feb 8, 2018 at 5:44 PM, James fuller  wrote:

> Adrian,
> I saw your reply below.  I cannot seem to print by date range.  What I’m
> trying to do is print the bank account transactions by date. Specifically
> the year 2017.  I also need to print out a couple of expense account
> transactions for the same period.  I did not close
> 2016 and every report I have printed shows all of 2016 along with 2017.
> What am I missing?
>
> Thanks
> James Fuller
>
> Sent from my iPad
>
> > On Feb 3, 2018, at 3:43 PM, Adrien Monteleone <
> adrien.montele...@gmail.com> wrote:
> >
> > the
>
> ___
> 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: Instructions for GST India

[Deva -]

Thanks Amish. I am glad you were able to compensate for my failings…

I am sure many users can benefit from your template, especially if it gets 
shipped as part of the next release like Frank said.

Cheers,
Deva

> 
> Message: 1
> Date: Wed, 7 Feb 2018 22:26:35 +0530
> From: Amish 
> To: gnucash-user@gnucash.org
> Subject: Re: Instructions for GST India
> Message-ID: <9ab0f1b1-c69b-707b-6bb9-262578619...@gmail.com>
> Content-Type: text/plain; charset=utf-8; format=flowed
> 
> 
> On Tuesday 06 February 2018 08:02 PM, Frank H. Ellenberger wrote:
>> Hi,
>> 
>> Am 06.02.2018 um 13:07 schrieb Deva -:
>>> And yes, it can certainly go on the wiki for those looking for help.
>>> I wish I had something like that to guide me when I was doing the
>>> same, but with trial and error, I got to what I wanted.
>> Or, if one of you were volunteering to create a template, we could ship
>> it with future releases.
>> 
>> The basics to create one are described in
>> https://wiki.gnucash.org/wiki/Account_Hierarchy_Template .
> 
> Created pull request:
> https://github.com/Gnucash/gnucash/pull/275
> 
> Description:
> This is the base module for setting up accounts for an Indian Business 
> with Goods and Service Tax (GST).
> 
> Mostly uses Indian terminology to ease the filing of many Indian 
> Government returs - e.g. Income tax returns, MCA returns and GST returns.
> 
> Amish
> 
> 

___
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: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

Oh, and I mentioned this in the earlier thread, but it bears repeating: the 
Security Editor window has the option to display price source. 

As with the Chart of Accounts window, there is a selector arrow on the upper 
right corner which drops down a list of user-selectable co,lumns for display. 
Source is one of these.

Cheers,
David


> On Feb 8, 2018, at 10:33 PM, D via gnucash-user  
> wrote:
> 
> David,
> 
> Thanks, but that's not it. I have my security editor window set up so that it 
> shows the quote source, so I can see at a glance that every one of the 
> 100-plus securities is set to Alphavantage.
> 
> I think that tomorrow, when I have a little time, I'll create a small test 
> file with one security in it, and see what happens.
> 
> Thanks,
> David
> 
> On February 8, 2018, at 10:07 PM, David Reiser  wrote:
> 
> 
>> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> In thread 
>> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>> , 
>> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
>> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
>> was an unknown error while retrieving the price quotes.”
>> 
>> *** As I noted there: Finance::Quote works at the command line:
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
>> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
>> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
>> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
>> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
>> 
>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>> alphavantage AAPL
>> Finance::Quote fields Gnucash uses:
>>   symbol: AAPL <=== required
>> date: 02/08/2018   <=== recommended
>> currency: USD  <=== required
>> last: 160.1350 <=\   
>>  nav:  <=== one of these
>>price:  <=/
>> timezone:  <=== optional
>> 
>> *** As I noted earlier: I restored the following two lines to 
>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
>> 
>> # Set AlphaVantage API Key to allow Finance::Quote to work
>> ALPHAVANTAGE_API_KEY=8SET
>> 
>> It seems to me that somehow Gnucash.app is not reading or using the 
>> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
>> somehow my environment file is not properly configured. However, I do not 
>> see any way to test these hypotheses. 
>> 
>> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
>> the Alphavantage API key is being read, and what its value currently is? Is 
>> there any other way to troubleshoot this problem?
>> 
>> David
> 
> Depending on your holdings, I’d suggest you open every single security in the 
> security editor dialog and make sure that _none_ of them are set to retrieve 
> online quotes from yahoo.
> 
> Back when my investing time horizon was a few months rather than years, I 
> bought and sold stocks in a total of something like 200 companies. When the 
> yahoo quote retrieval apocalypse hit, it took me three trips through the list 
> of 200 companies to find the last stock that was set to use yahoo as a 
> source. That’s annoying when one has to open each security definition 
> individually to see if it is set to retrieve quotes and from where. Hmm, time 
> for an enhancement request to include online-quote-source in the security 
> editor main dialog list…
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
> ___
> 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 

Re: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

Unfortunately, adding these lines to my config.user did not result in any 
further information.  I am stumped, and disappointed.


It seems that an upgrade of GnuCash not only tanks one’s customized environment 
file in the application bundle (understandable), but also any additional files 
that a user might have put into the DOT_GNUCASH_DIR folder—like, custom scheme 
reports, or a config.user file that a user might have created in vain attempts 
to get said custom reports to load into their personal installation of GnuCash. 
I find this circumstance to be rather troubling, as the files that a user has 
put into this folder should not be summarily sent to the executioner by the 
next version of the application. This is especially troubling given that the 
authorized methods for creating and using custom scheme reports (as convoluted 
and sensitive as they are) specifically directs such reports to be placed into 
this folder. If *I* were to have written a custom report for GnuCash (as 
opposed to simply copying someone else’s work to my own system) I would be 
pretty ticked off to find my work discarded this way. Thank goodness I had 
backups, but really, one shouldn’t have to restore from a backup on this.


I have now created a simple file to test out price retrieval. I put one stock 
account that uses AAPL, a cash account and Equity, and created a simple buy 
transaction (to create one price entry). For me, this file fails in the same 
way. I attach it here, so that someone else can test it. If it works for you, 
then there is something about my Mac that F::Q doesn’t like. And then I am 
really up the creek, because it’s a big operating system out there…

David



TestAlpha.gnucash
Description: Binary data


> On Feb 8, 2018, at 11:40 PM, Geert Janssens  
> wrote:
> 
> David,
> 
> You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
> Library/Application Support/Gnucash)
> 
> If you then start gnucash from the command line, it should print out the 
> value 
> of your API key there, together with the version of Finance::Quote that got 
> installed. Unless the OS X edition doesn't print this early boot 
> information...
> 
> Regards,
> 
> 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.

13 Column Reporting Starting July ending June plus Total

[Roger Hatton]

Is there a simple way to generate a 13 column Profit and Loss
and a 13 column Balance Sheet showing monthly movements?

My apology if this question has been asked often before but
being new I can't see the answer to what I hope is a simple
question, with one menu item to action these two reports?

Is there also a cumulative monthly balance sheet function
over 12 columns (no 13th Column needed)?

With thanks and congratulations on an interesting system.

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

The Wiki, and documentation

[Matt Graham]

Thanks Dave (And sorry – I knew I forget at least one of the regular mailing 
list people... Should have just said that you all rock ☹ )

Anyway – your comments make a good point regarding the never ending push to try 
to keep it all up to date. I know that the Tut and concepts guide and manual 
are done within xml DocBook. Does anyone know of any way to have one source of 
all information that the system can then produce the wiki pages, manual and 
tut/concepts guide? They are all different forms of information, but just 
wondering whether, for example, “GNUCash Windows Installation” could have one 
file that has tags or something for the different information in the different 
areas (so the “how to” section gets automatically pulled to the manual, the 
detailed tutorial and cool stuff to do gets pulsed into the concepts, and the 
detailed discussions and troubleshooting gets shunted to the wiki). Hopefully 
you could also define some “FAQ” questions for any of the topics that are 
automatically pulled to that page.

Maybe I’m just overthinking it... I have a habit of doing that.

Thanks and regards,

Matt

From: David T.
Sent: Friday, 9 February 2018 4:27 PM
To: Matt Graham
Cc: Adrien Monteleone; 
gnucash-user@gnucash.org
Subject: Re: Cash Flow View

Matt,

The wiki can always use help, so thank you! I think your approach makes sense. 
I will note that there already is a set of installation pages, and it may be 
most useful simply to move the relevant questions and answers to them. I 
suspect that there are similar overlaps in other areas of the FAQ. In each 
case, I would hope that you would keep a general question in the FAQ along with 
a reference to the appropriate dedicated wiki page. But by all means, move 
content to more specific pages wherever possible!

One major challenge in all the GnuCash documentation (the wiki, the website, 
and the Help and Guide) is making sure that the information is up to date, 
accurate, and still relevant. While it may be interesting to refer to technical 
accounting discussions from the lists in 2005, are the discussions still 
useful, and should readers need to know about them? I would hope that as you 
move things around, some of the more dated entries could be removed or placed 
in a different context to reflect their time-dated nature.

Generally, I think that information that addresses problems for versions that 
are no longer officially supported should either be deleted or archived in a 
special GnuCash salt mine, so that current users of the software aren’t 
worrying whether they need to manage their dbus daemons or not.

David

> On Feb 9, 2018, at 9:03 AM, Matt Graham  wrote:
>
> G’day All,
>
> I was thinking about what Adrien said in a past email: “Many questions lately 
> seem to be asked a bit too quickly.”. I agree – I sometimes wonder whether 
> people do a simple google before asking.
>
> Still, when I tried to go onto the GNUCash FAQ wiki to find the answer and 
> send it to someone, I found it really hard to find it (but it was there when 
> I searched the page). Due to the huge amount of ‘questions’ on there, It is 
> very difficult to quickly scan down to find stuff you are interested in.
>
> I have edited the page to take the actual questions out of the table of 
> contents – so hopefully people can more easily find their answer through 
> browsing their area (eg the “Using the Business Features” area if they are 
> wondering about how to do invoice stuff). Devs/experts, feel free to revert 
> it back if you don’t like it.
> I fiddled with “mw-collapsable” to get an expandable table of contents, but 
> couldn’t get it working well.
>
> To further improve it all, I’m considering trying to establish more wiki 
> pages to take a lot of the questions off the FAQ. Eg all the installation 
> questions would probably be better placed on wiki pages, with the FAQ just 
> having entries “Installing on Windows”, “Installing on Mac” and “Installing 
> on Linux” to link users to the right wiki page
>
> Anyone got any other ideas to make it easier for people to find the answers 
> without taking up Adrien/John/Geert/Mike’s time? (you all rock, by the way)
>
> Thanks and regards,
>
> Matt
>
> From: Adrien Monteleone
> Sent: Thursday, 8 February 2018 6:29 AM
> To: gnucash-user@gnucash.org
> Subject: Re: Cash Flow View
>
> I second Mike’s comments generally.
>
> What would probably address most concerns in this regard is a default 
> multi-column report that included the basics—Income Statement, Balance Sheet, 
> and perhaps Income/Expense graphs. This would be auto-opened and up to date. 
> If a seasoned/power user didn’t want it, they could just set a preference not 
> to open it at start. Alternatively, it could be a menu entry 

Re: Applying Customer overpayments

[Alan Johnson]

*replying to the list

Geert,

Thanks. That worked. However it wanted to apply the funds to the 
checking account (which were already deposited/received). I deleted that 
part of the transaction from the AR register, and the balance offset 
still works, just does not reflect as a payment on the customer report. 
Is there a better account to debit the funds? In the balance sheet / P 
I don't see any sort of customer funds held/liability that would be 
where the offset would go.


Also, this feature wasn't in the documentation (at least that I could 
find). The documentation merely states that GnuCash would keep track of 
any overpayment. It sounds like a feature like QuickBoox payment system 
check box "Apply customer balance to invoice" is needed.

Alan


On 2/8/2018 1:09 PM, Geert Janssens wrote:

Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson:

Hello, I'm having an issue with GnuCash. A customer has a
overpayment/credit balance. How do I apply it to an invoice so that it
comes out of the AR report at the bottom of the customer report? The
total due / sums are correct, but the customer report has a 91+ day
balance of (0.03). I would like to apply the payment to an invoice / fix
the AR box on the customer report. This is on version 2.6.19.


- Go to Business->Customer->Process Payment
- Select the customer you refer to above
- You should get a list of open invoices and overpayments
- Select both the 0.03 overpayment and the invoice you want to apply it to
(using shift- or ctrl-click)
- If you only want to apply this 0.03, adjust the amount to exactly that 0.03
- Click Ok

Regards,

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: Price Retrieval Failure, Part 2

[David T. via gnucash-user]

In reply to my own message, in the interest of trying to run a fresh 
installation of GnuCash, I logged in to a different (new) Mac user account and 
replicated the test there. In other words, I opened GnuCash and created a 
simple file with AAPL and tried to retrieve prices. I receive the same error. 

Because GnuCash on the Mac installs the application bundle at the system level, 
the environment file there is still invoked (a check in that account confirms 
that this file is accessible in the new account), so I wonder whether there is 
something going on there that causes my problem.

I don’t know whether this is a problem, but digging through the enviroment file 
yields two variables with John’s folder structures:

GNC_DBD_DIR=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/lib/dbd
XDG_DATA_DIRS=/Users/john/Development/Gnucash-Build/Gnucash-2.6-Leopard/inst/share;{XDG_DATA_DIRS};/usr/local/share;/usr/share

These should be removed, or scrubbed to be generically valid. 

At this point, I am at a loss for how to proceed.  

I would try for a “clean slate,” but I would have thought that downloading and 
installing the newer version would have done that. Since I have been using 
GnuCash so long, and have sporadically attempted to contribute to the project, 
my machine has numerous development tools (git, SourceTree, etc.) and GnuCash 
content (gnucash-docs, gnucash-htdocs) installed; I imagine I could delete all 
of that as well, and try from there. Given how much trouble it has been for me 
to get these development technologies to work, I am loathe to take this step, 
however.

Geert mentioned that the Alphavantage settings will be incorporated into 3.0; 
when is that slated for release? Is the feature active on 2.7.4—and should I 
try using that (*he shudders*)? 

David

> On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user 
>  wrote:
> 
> Unfortunately, adding these lines to my config.user did not result in any 
> further information.  I am stumped, and disappointed.
> 
> 
> It seems that an upgrade of GnuCash not only tanks one’s customized 
> environment file in the application bundle (understandable), but also any 
> additional files that a user might have put into the DOT_GNUCASH_DIR 
> folder—like, custom scheme reports, or a config.user file that a user might 
> have created in vain attempts to get said custom reports to load into their 
> personal installation of GnuCash. I find this circumstance to be rather 
> troubling, as the files that a user has put into this folder should not be 
> summarily sent to the executioner by the next version of the application. 
> This is especially troubling given that the authorized methods for creating 
> and using custom scheme reports (as convoluted and sensitive as they are) 
> specifically directs such reports to be placed into this folder. If *I* were 
> to have written a custom report for GnuCash (as opposed to simply copying 
> someone else’s work to my own system) I would be pretty ticked off to find my 
> work discarded this way. Thank goodness I had backups, but really, one 
> shouldn’t have to restore from a backup on this.
> 
> 
> I have now created a simple file to test out price retrieval. I put one stock 
> account that uses AAPL, a cash account and Equity, and created a simple buy 
> transaction (to create one price entry). For me, this file fails in the same 
> way. I attach it here, so that someone else can test it. If it works for you, 
> then there is something about my Mac that F::Q doesn’t like. And then I am 
> really up the creek, because it’s a big operating system out there…
> 
> David
> 
> 
> 
>> On Feb 8, 2018, at 11:40 PM, Geert Janssens  
>> wrote:
>> 
>> David,
>> 
>> You can put the attached config.user file in your DOT_GNUCASH_DIR ($HOME/
>> Library/Application Support/Gnucash)
>> 
>> If you then start gnucash from the command line, it should print out the 
>> value 
>> of your API key there, together with the version of Finance::Quote that got 
>> installed. Unless the OS X edition doesn't print this early boot 
>> information...
>> 
>> Regards,
>> 
>> 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.

___
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 

Re: Price Retrieval Failure, Part 2

[David Reiser]

> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user 
>  wrote:
> 
> In thread 
> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
> , 
> I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac 
> (OS X 10.13.3), Price retrieval was failing with the generic error: "There 
> was an unknown error while retrieving the price quotes.”
> 
> *** As I noted there: Finance::Quote works at the command line:
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
> 
> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
> alphavantage AAPL
> Finance::Quote fields Gnucash uses:
>symbol: AAPL <=== required
>  date: 02/08/2018   <=== recommended
>  currency: USD  <=== required
>  last: 160.1350 <=\   
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> *** As I noted earlier: I restored the following two lines to 
> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
> 
> # Set AlphaVantage API Key to allow Finance::Quote to work
> ALPHAVANTAGE_API_KEY=8SET
> 
> It seems to me that somehow Gnucash.app is not reading or using the 
> ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
> somehow my environment file is not properly configured. However, I do not see 
> any way to test these hypotheses. 
> 
> Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
> the Alphavantage API key is being read, and what its value currently is? Is 
> there any other way to troubleshoot this problem?
> 
> David

Depending on your holdings, I’d suggest you open every single security in the 
security editor dialog and make sure that _none_ of them are set to retrieve 
online quotes from yahoo.

Back when my investing time horizon was a few months rather than years, I 
bought and sold stocks in a total of something like 200 companies. When the 
yahoo quote retrieval apocalypse hit, it took me three trips through the list 
of 200 companies to find the last stock that was set to use yahoo as a source. 
That’s annoying when one has to open each security definition individually to 
see if it is set to retrieve quotes and from where. Hmm, time for an 
enhancement request to include online-quote-source in the security editor main 
dialog list…

Dave
--
Dave Reiser
dbrei...@icloud.com





___
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: Price Retrieval Failure, Part 2

[John Ralls]

David,

Sorry for the typos, I should have tested first. Then I would have realized 
that of course price-quotes.scm eats gnc-fq-helper’s stdout--that’s after all 
how it gets the quotes. Unfortunately it seems also to send stderr to /dev/null 
so that approach won’t work without changing price-quotes.scm.

Regards,
John Ralls

> On Feb 8, 2018, at 9:05 AM, David T.  wrote:
> 
> John,
> 
> Thanks for the suggestion. I inserted the line as you indicated (at line 324 
> in my copy of gnc-fq-helper), but didn’t get any output on the command line 
> after “Found Finance::Quote version 1.47”
> 
> I’m not much for perl, but I noticed your snippet had one ‘(‘, one  ‘{‘, and 
> two ‘}’. I tried it that way, and then I tried changing the last ‘}’ to ‘)’, 
> but that didn’t change anything. I also tried adding a semi-colon at the end 
> of the line, without effect. Heck, I even tried putting a Hello world print 
> statement, but that didn’t generate either. Either I am a bone fide idiot, or 
> there is something else going on here. I’ve got my money on the first, but I 
> hold out hope that it’s the second. Is it possible that I’ve latched on to 
> the wrong file somehow? Or that the command isn’t going to the standard 
> output?
> 
> David
> 
> P.S.: Should I be seeing:
> 
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
>  Error: unsupported compressor 8
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
>  Error: Unknown compression scheme encountered for file 
> '/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/Exceptions.plist'
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Common/ChunkCompression.cpp:50:
>  Error: unsupported compressor 8
> /BuildRoot/Library/Caches/com.apple.xbs/Sources/AppleFSCompression/AppleFSCompression-96.30.2/Libraries/CompressData/CompressData.c:353:
>  Error: Unknown compression scheme encountered for file 
> '/System/Library/CoreServices/CoreTypes.bundle/Contents/Library/AppExceptions.bundle/Exceptions.plist’
> 
> at the command line? This appears at startup before the F::Q note...
> 
>> On Feb 8, 2018, at 9:33 PM, John Ralls > > wrote:
>> 
>> 
>> 
>>> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user 
>>> > wrote:
>>> 
>>> In thread 
>>> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
>>>  
>>> >> >,
>>>  I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my 
>>> Mac (OS X 10.13.3), Price retrieval was failing with the generic error: 
>>> "There was an unknown error while retrieving the price quotes.”
>>> 
>>> *** As I noted there: Finance::Quote works at the command line:
>>> 
>>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
>>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" 
>>> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" 
>>> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
>>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" 
>>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" 
>>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" 
>>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" 
>>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
>>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
>>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
>>> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" 
>>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" 
>>> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" 
>>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts”)
>>> 
>>> $ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v 
>>> alphavantage AAPL
>>> Finance::Quote fields Gnucash uses:
>>>   symbol: AAPL <=== required
>>> date: 02/08/2018   <=== recommended
>>> currency: USD  <=== required
>>> last: 160.1350 <=\   
>>>  nav:  <=== one of these
>>>price:  <=/
>>> timezone:  <=== optional
>>> 
>>> *** As I noted earlier: I restored the following two lines to 
>>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:
>>> 
>>> # Set AlphaVantage API Key to allow 

Re: Cash Flow View

[David T. via gnucash-user]

Matt,

The wiki can always use help, so thank you! I think your approach makes sense. 
I will note that there already is a set of installation pages, and it may be 
most useful simply to move the relevant questions and answers to them. I 
suspect that there are similar overlaps in other areas of the FAQ. In each 
case, I would hope that you would keep a general question in the FAQ along with 
a reference to the appropriate dedicated wiki page. But by all means, move 
content to more specific pages wherever possible!

One major challenge in all the GnuCash documentation (the wiki, the website, 
and the Help and Guide) is making sure that the information is up to date, 
accurate, and still relevant. While it may be interesting to refer to technical 
accounting discussions from the lists in 2005, are the discussions still 
useful, and should readers need to know about them? I would hope that as you 
move things around, some of the more dated entries could be removed or placed 
in a different context to reflect their time-dated nature.

Generally, I think that information that addresses problems for versions that 
are no longer officially supported should either be deleted or archived in a 
special GnuCash salt mine, so that current users of the software aren’t 
worrying whether they need to manage their dbus daemons or not.

David

> On Feb 9, 2018, at 9:03 AM, Matt Graham  wrote:
> 
> G’day All,
> 
> I was thinking about what Adrien said in a past email: “Many questions lately 
> seem to be asked a bit too quickly.”. I agree – I sometimes wonder whether 
> people do a simple google before asking.
> 
> Still, when I tried to go onto the GNUCash FAQ wiki to find the answer and 
> send it to someone, I found it really hard to find it (but it was there when 
> I searched the page). Due to the huge amount of ‘questions’ on there, It is 
> very difficult to quickly scan down to find stuff you are interested in.
> 
> I have edited the page to take the actual questions out of the table of 
> contents – so hopefully people can more easily find their answer through 
> browsing their area (eg the “Using the Business Features” area if they are 
> wondering about how to do invoice stuff). Devs/experts, feel free to revert 
> it back if you don’t like it.
> I fiddled with “mw-collapsable” to get an expandable table of contents, but 
> couldn’t get it working well.
> 
> To further improve it all, I’m considering trying to establish more wiki 
> pages to take a lot of the questions off the FAQ. Eg all the installation 
> questions would probably be better placed on wiki pages, with the FAQ just 
> having entries “Installing on Windows”, “Installing on Mac” and “Installing 
> on Linux” to link users to the right wiki page
> 
> Anyone got any other ideas to make it easier for people to find the answers 
> without taking up Adrien/John/Geert/Mike’s time? (you all rock, by the way)
> 
> Thanks and regards,
> 
> Matt
> 
> From: Adrien Monteleone
> Sent: Thursday, 8 February 2018 6:29 AM
> To: gnucash-user@gnucash.org
> Subject: Re: Cash Flow View
> 
> I second Mike’s comments generally.
> 
> What would probably address most concerns in this regard is a default 
> multi-column report that included the basics—Income Statement, Balance Sheet, 
> and perhaps Income/Expense graphs. This would be auto-opened and up to date. 
> If a seasoned/power user didn’t want it, they could just set a preference not 
> to open it at start. Alternatively, it could be a menu entry or toolbar 
> button for easy discovery.
> 
> Many questions lately seem to be asked a bit too quickly. But that’s not 
> always the case. In my several years of experience as a Gnucash user, I find 
> much of what I want to accomplish to be quite obtuse discovery-wise. Perhaps 
> this is a consequence of the software being generalized for as many use cases 
> as possible, but I’d suspect more because the reporting system has a very 
> high hurdle for customization. (and the data is not yet easy to extract as 
> with proper SQL, which is of course, in the works)
> 
> The recurring questions I see on this list aren’t issues with Gnucash not 
> being able to provide what people are looking for, but that the ability takes 
> some gymnastics, or at the least is not easily discoverable. Certainly, that 
> is something I think can be improved even before the full SQL implementation 
> is achieved.
> 
> With regards to the specific question, the answer is, “No, it doesn’t out of 
> the box.”
> 
> There IS a ‘cash flow’ report, but this isn’t the same sort of report that I 
> was expecting to see or what is described on most business accounting sites 
> I’ve come across, or the one you are looking for Sean.
> 
> The built-in cash flow report shows you which accounts had money going in and 
> out. It is for a time period, but it does not show you a change in position 
> for a 

Re: GNUCASH Free Accounting Software

[David T. via gnucash-user]

Or run a transaction report and set the dates accordingly.

> On Feb 9, 2018, at 5:20 AM, David Carlson  wrote:
> 
> If you want to do a register report for a certain time range open the
> register window and choose View > Filter by.. > Date to select your time
> window then select Reports > Account Report.
> 
> David C
> 
> On Thu, Feb 8, 2018 at 5:44 PM, James fuller  wrote:
> 
>> Adrian,
>> I saw your reply below.  I cannot seem to print by date range.  What I’m
>> trying to do is print the bank account transactions by date. Specifically
>> the year 2017.  I also need to print out a couple of expense account
>> transactions for the same period.  I did not close
>> 2016 and every report I have printed shows all of 2016 along with 2017.
>> What am I missing?
>> 
>> Thanks
>> James Fuller
>> 
>> Sent from my iPad
>> 
>>> On Feb 3, 2018, at 3:43 PM, Adrien Monteleone <
>> adrien.montele...@gmail.com> wrote:
>>> 
>>> the
>> 
>> ___
>> 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: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

[Roger Miskowicz]

Sorry, I just want to take a number from one online brokerage report and
manually put it into gnucash.

On Thu, Feb 8, 2018 at 6:28 AM, David T.  wrote:

> Roger,
>
> You stay by stating that you are able to generate a report that tells you
> "the current value of everything."  Then, you ask how you can add another
> layer of complexity to accomplish the same thing?
>
> I don't understand: what's wrong with the report?
>
> David
>
>
> On Thu, Feb 8, 2018 at 16:14, Roger Miskowicz
>  wrote:
> I have an Investment Account which is a collection of stocks, certificates,
> cash etc in two currencies.  I can get a report that tells me in my local
> currency the current value of everything.
>
> I would like to create a stock, fund, or whatever appropriate with 1 share
> for which  I can manually update a single price representing the current
> value of the entire collection.
>
> Using the online guide I have tried creating a fund or stock but I don't
> understand the process and can't seem to get it to work and even
> ocassionally crashing gnucash.
>
> I think I would like something such as:
>
> Investment
>   Stocks
> myStock  (I would like to manually update the price of a single share.)
>
>
> I am using gucash 2.6.12 on Ubuntu 16.04 LTS.
>
> I would appreciate it if someone can suggest a way to do this.
> ___
> 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: Online quotes fetching the wrong price

[Derek Atkins]

No, the namespace has no meaning to gnucash. It's purely for human 
organization.  Change the stock code.


-derek
Sent using my mobile device. Please excuse any typos.



On February 8, 2018 9:10:53 AM Justin Smith  wrote:


Thanks - that works for me too...

So how do configure gnucash to use NAB.AX instead of NAB?

I would have thought that setting the security type to "ASX" would have
done that...

Cheers,
Justin.


On 8 February 2018 at 21:20, Anthony Hepple 
wrote:


The ticker NAB.AX seems to work for me:

ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB.AX
Finance::Quote fields Gnucash uses:
symbol: NAB.AX   <=== required
  date: 02/07/2018   <=== required
  currency: AUD  <=== required
  last: 28.9000  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

On 8 February 2018 at 13:09, Justin Smith 
wrote:
> Hi David,
>
> Thanks for your email - it's interesting that it's not just me. I was
> hoping the issue was my configuration...
>
> You ask about NAB and Mar 13 but I have this same problem ("random" USD
> quotes) with *all* my ASX stocks (20+).
>
> Cheers,
> Justin.
>
>
> On 8 February 2018 at 21:01, David T.  wrote:
>
>> Justin,
>>
>> I see the same command line result. I will note that the date listed
there
>> is for 2017 (mine is the same), which suggests something is out of
whack.
>> Looking online, I see that NAB was at 33.14 on 03/13/2017, so that
doesn’t
>> work. I’ve tried various versions of the exchange (ASX, ASE, AX, all of
>> which appear out on the web) and the symbol (both the ticker, and the
ISIN, AU00NAB4)
>> without success.
>>
>> Usually, when I see an old date, it means that the symbol ceased trading
>> for one reason or another (e.g., a merger or a company purchase), which
>> leaves the ticker “stuck” on the last day of existence. That isn’t the
case
>> here; was there anything funny that happened last March 13 for NAB?
>>
>> Sorry I can’t be of help. Maybe someone else has better chops.
>>
>> David
>>
>> On Feb 7, 2018, at 7:50 PM, Justin Smith 
wrote:
>>
>> Hi,
>>
>> I use gnc to track my stock portfolio of mostly Australian ASX stocks.
>> After yahoo closed their quoting service I set up alphavantage as per
the
>> instructions in the gnc FAQ (with key etc).
>>
>> I've just noticed that the online quotes for *all* my ASX stocks are
now in
>> USD, and that they are meaningless values too (i.e. not the ASX stock in
>> USD).
>>
>> This is confirmed when testing using gnc-fq-dump. E.g.
>>
>> ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB
>> Finance::Quote fields Gnucash uses:
>>symbol: NAB  <=== required
>>  date: 03/13/2017   <=== recommended
>>  currency: USD  <=== required
>>  last: 1.0800   <=\
>>   nav:  <=== one of these
>> price:  <=/
>>  timezone:  <=== optional
>>
>> The price of $1.08 USD is what gnc fetches today.
>>
>> The correct quote for ASX.NAB is around $28.24 AUD (or around $22.18
USD).
>>
>> A quick search didn't even find a NYSE or NASDAQ NAB so I have no idea
>> where F::Q is getting this quote from.
>>
>> Also I don't know why the date returned by gnc-fq-dump is 3/13/2017.
Very
>> odd.
>>
>> How does gnc-fq-dump determine the stock type? (e.g. ASX or NYSE)
>>
>> For all my ASX stocks, in the Security Editor, I have the following
>> settings:
>> * Type = ASX
>> * ISIN/CUSIP =  (is that a problem?)
>> * Get Online Quotes is ticked
>> * Type of Quote = Unknown/alphavantage
>>
>> I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (yes, end of life).
>> And Finance::Quote 1.48 (installed from git).
>>
>> Any clues?
>>
>>
>> Cheers,
>> Justin.
>> ___
>> 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.



--
Anthony Hepple
01704 227828 / 07931 504049
http://www.dhdevelopment.co.uk

Re: Online quotes fetching the wrong price

[Justin Smith]

Responding to my own email...

Adding ".AX" to each security "Symbol/abbreviation" for ASX stocks fixed my
issue.

Yahoo didn't need this suffix, but alphavantage does.

Now all good!

Cheers,
Justin.


On 8 February 2018 at 22:10, Justin Smith  wrote:

> Thanks - that works for me too...
>
> So how do configure gnucash to use NAB.AX instead of NAB?
>
> I would have thought that setting the security type to "ASX" would have
> done that...
>
> Cheers,
> Justin.
>
>
> On 8 February 2018 at 21:20, Anthony Hepple 
> wrote:
>
>> The ticker NAB.AX seems to work for me:
>>
>> ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB.AX
>> Finance::Quote fields Gnucash uses:
>> symbol: NAB.AX   <=== required
>>   date: 02/07/2018   <=== required
>>   currency: AUD  <=== required
>>   last: 28.9000  <=\
>>nav:  <=== one of these
>>  price:  <=/
>>   timezone:  <=== optional
>>
>> On 8 February 2018 at 13:09, Justin Smith 
>> wrote:
>> > Hi David,
>> >
>> > Thanks for your email - it's interesting that it's not just me. I was
>> > hoping the issue was my configuration...
>> >
>> > You ask about NAB and Mar 13 but I have this same problem ("random" USD
>> > quotes) with *all* my ASX stocks (20+).
>> >
>> > Cheers,
>> > Justin.
>> >
>> >
>> > On 8 February 2018 at 21:01, David T.  wrote:
>> >
>> >> Justin,
>> >>
>> >> I see the same command line result. I will note that the date listed
>> there
>> >> is for 2017 (mine is the same), which suggests something is out of
>> whack.
>> >> Looking online, I see that NAB was at 33.14 on 03/13/2017, so that
>> doesn’t
>> >> work. I’ve tried various versions of the exchange (ASX, ASE, AX, all of
>> >> which appear out on the web) and the symbol (both the ticker, and the
>> ISIN, AU00NAB4)
>> >> without success.
>> >>
>> >> Usually, when I see an old date, it means that the symbol ceased
>> trading
>> >> for one reason or another (e.g., a merger or a company purchase), which
>> >> leaves the ticker “stuck” on the last day of existence. That isn’t the
>> case
>> >> here; was there anything funny that happened last March 13 for NAB?
>> >>
>> >> Sorry I can’t be of help. Maybe someone else has better chops.
>> >>
>> >> David
>> >>
>> >> On Feb 7, 2018, at 7:50 PM, Justin Smith 
>> wrote:
>> >>
>> >> Hi,
>> >>
>> >> I use gnc to track my stock portfolio of mostly Australian ASX stocks.
>> >> After yahoo closed their quoting service I set up alphavantage as per
>> the
>> >> instructions in the gnc FAQ (with key etc).
>> >>
>> >> I've just noticed that the online quotes for *all* my ASX stocks are
>> now in
>> >> USD, and that they are meaningless values too (i.e. not the ASX stock
>> in
>> >> USD).
>> >>
>> >> This is confirmed when testing using gnc-fq-dump. E.g.
>> >>
>> >> ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB
>> >> Finance::Quote fields Gnucash uses:
>> >>symbol: NAB  <=== required
>> >>  date: 03/13/2017   <=== recommended
>> >>  currency: USD  <=== required
>> >>  last: 1.0800   <=\
>> >>   nav:  <=== one of these
>> >> price:  <=/
>> >>  timezone:  <=== optional
>> >>
>> >> The price of $1.08 USD is what gnc fetches today.
>> >>
>> >> The correct quote for ASX.NAB is around $28.24 AUD (or around $22.18
>> USD).
>> >>
>> >> A quick search didn't even find a NYSE or NASDAQ NAB so I have no idea
>> >> where F::Q is getting this quote from.
>> >>
>> >> Also I don't know why the date returned by gnc-fq-dump is 3/13/2017.
>> Very
>> >> odd.
>> >>
>> >> How does gnc-fq-dump determine the stock type? (e.g. ASX or NYSE)
>> >>
>> >> For all my ASX stocks, in the Security Editor, I have the following
>> >> settings:
>> >> * Type = ASX
>> >> * ISIN/CUSIP =  (is that a problem?)
>> >> * Get Online Quotes is ticked
>> >> * Type of Quote = Unknown/alphavantage
>> >>
>> >> I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (yes, end of life).
>> >> And Finance::Quote 1.48 (installed from git).
>> >>
>> >> Any clues?
>> >>
>> >>
>> >> Cheers,
>> >> Justin.
>> >> ___
>> >> 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 

Re: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

[David T. via gnucash-user]

Roger, 
You stay by stating that you are able to generate a report that tells you "the 
current value of everything."  Then, you ask how you can add another layer of 
complexity to accomplish the same thing?
I don't understand: what's wrong with the report? 
David

 
 
  On Thu, Feb 8, 2018 at 16:14, Roger Miskowicz wrote:   I 
have an Investment Account which is a collection of stocks, certificates,
cash etc in two currencies.  I can get a report that tells me in my local
currency the current value of everything.

I would like to create a stock, fund, or whatever appropriate with 1 share
for which  I can manually update a single price representing the current
value of the entire collection.

Using the online guide I have tried creating a fund or stock but I don't
understand the process and can't seem to get it to work and even
ocassionally crashing gnucash.

I think I would like something such as:

Investment
  Stocks
    myStock  (I would like to manually update the price of a single share.)


I am using gucash 2.6.12 on Ubuntu 16.04 LTS.

I would appreciate it if someone can suggest a way to do this.
___
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: Online quotes fetching the wrong price

[David T. via gnucash-user]

Justin, 

I see the same command line result. I will note that the date listed there is 
for 2017 (mine is the same), which suggests something is out of whack. Looking 
online, I see that NAB was at 33.14 on 03/13/2017, so that doesn’t work. I’ve 
tried various versions of the exchange (ASX, ASE, AX, all of which appear out 
on the web) and the symbol (both the ticker, and the ISIN, AU00NAB4) 
without success. 

Usually, when I see an old date, it means that the symbol ceased trading for 
one reason or another (e.g., a merger or a company purchase), which leaves the 
ticker “stuck” on the last day of existence. That isn’t the case here; was 
there anything funny that happened last March 13 for NAB?

Sorry I can’t be of help. Maybe someone else has better chops.

David

> On Feb 7, 2018, at 7:50 PM, Justin Smith  wrote:
> 
> Hi,
> 
> I use gnc to track my stock portfolio of mostly Australian ASX stocks.
> After yahoo closed their quoting service I set up alphavantage as per the
> instructions in the gnc FAQ (with key etc).
> 
> I've just noticed that the online quotes for *all* my ASX stocks are now in
> USD, and that they are meaningless values too (i.e. not the ASX stock in
> USD).
> 
> This is confirmed when testing using gnc-fq-dump. E.g.
> 
> ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB
> Finance::Quote fields Gnucash uses:
>symbol: NAB  <=== required
>  date: 03/13/2017   <=== recommended
>  currency: USD  <=== required
>  last: 1.0800   <=\
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> The price of $1.08 USD is what gnc fetches today.
> 
> The correct quote for ASX.NAB is around $28.24 AUD (or around $22.18 USD).
> 
> A quick search didn't even find a NYSE or NASDAQ NAB so I have no idea
> where F::Q is getting this quote from.
> 
> Also I don't know why the date returned by gnc-fq-dump is 3/13/2017. Very
> odd.
> 
> How does gnc-fq-dump determine the stock type? (e.g. ASX or NYSE)
> 
> For all my ASX stocks, in the Security Editor, I have the following
> settings:
> * Type = ASX
> * ISIN/CUSIP =  (is that a problem?)
> * Get Online Quotes is ticked
> * Type of Quote = Unknown/alphavantage
> 
> I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (yes, end of life).
> And Finance::Quote 1.48 (installed from git).
> 
> Any clues?
> 
> 
> Cheers,
> Justin.
> ___
> 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.

How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

[Roger Miskowicz]

I have an Investment Account which is a collection of stocks, certificates,
cash etc in two currencies.  I can get a report that tells me in my local
currency the current value of everything.

I would like to create a stock, fund, or whatever appropriate with 1 share
for which  I can manually update a single price representing the current
value of the entire collection.

Using the online guide I have tried creating a fund or stock but I don't
understand the process and can't seem to get it to work and even
ocassionally crashing gnucash.

I think I would like something such as:

Investment
  Stocks
myStock  (I would like to manually update the price of a single share.)


I am using gucash 2.6.12 on Ubuntu 16.04 LTS.

I would appreciate it if someone can suggest a way to do this.
___
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: Online quotes fetching the wrong price

[Justin Smith]

Hi David,

Thanks for your email - it's interesting that it's not just me. I was
hoping the issue was my configuration...

You ask about NAB and Mar 13 but I have this same problem ("random" USD
quotes) with *all* my ASX stocks (20+).

Cheers,
Justin.


On 8 February 2018 at 21:01, David T.  wrote:

> Justin,
>
> I see the same command line result. I will note that the date listed there
> is for 2017 (mine is the same), which suggests something is out of whack.
> Looking online, I see that NAB was at 33.14 on 03/13/2017, so that doesn’t
> work. I’ve tried various versions of the exchange (ASX, ASE, AX, all of
> which appear out on the web) and the symbol (both the ticker, and the ISIN, 
> AU00NAB4)
> without success.
>
> Usually, when I see an old date, it means that the symbol ceased trading
> for one reason or another (e.g., a merger or a company purchase), which
> leaves the ticker “stuck” on the last day of existence. That isn’t the case
> here; was there anything funny that happened last March 13 for NAB?
>
> Sorry I can’t be of help. Maybe someone else has better chops.
>
> David
>
> On Feb 7, 2018, at 7:50 PM, Justin Smith  wrote:
>
> Hi,
>
> I use gnc to track my stock portfolio of mostly Australian ASX stocks.
> After yahoo closed their quoting service I set up alphavantage as per the
> instructions in the gnc FAQ (with key etc).
>
> I've just noticed that the online quotes for *all* my ASX stocks are now in
> USD, and that they are meaningless values too (i.e. not the ASX stock in
> USD).
>
> This is confirmed when testing using gnc-fq-dump. E.g.
>
> ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB
> Finance::Quote fields Gnucash uses:
>symbol: NAB  <=== required
>  date: 03/13/2017   <=== recommended
>  currency: USD  <=== required
>  last: 1.0800   <=\
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
>
> The price of $1.08 USD is what gnc fetches today.
>
> The correct quote for ASX.NAB is around $28.24 AUD (or around $22.18 USD).
>
> A quick search didn't even find a NYSE or NASDAQ NAB so I have no idea
> where F::Q is getting this quote from.
>
> Also I don't know why the date returned by gnc-fq-dump is 3/13/2017. Very
> odd.
>
> How does gnc-fq-dump determine the stock type? (e.g. ASX or NYSE)
>
> For all my ASX stocks, in the Security Editor, I have the following
> settings:
> * Type = ASX
> * ISIN/CUSIP =  (is that a problem?)
> * Get Online Quotes is ticked
> * Type of Quote = Unknown/alphavantage
>
> I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (yes, end of life).
> And Finance::Quote 1.48 (installed from git).
>
> Any clues?
>
>
> Cheers,
> Justin.
> ___
> 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: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

[David Carlson]

If you want to create a fictional stock and manually enter prices from time
to time that is easy.

Just use the security editor and invent a name and symbol, possibly under
the group called Fund.  Do not set an online quote source.  Then manually
use the price editor to enter prices for whatever dates you like.

David C

On Thu, Feb 8, 2018 at 8:00 AM, Roger Miskowicz  wrote:

> Sorry, I just want to take a number from one online brokerage report and
> manually put it into gnucash.
>
> On Thu, Feb 8, 2018 at 6:28 AM, David T.  wrote:
>
> > Roger,
> >
> > You stay by stating that you are able to generate a report that tells you
> > "the current value of everything."  Then, you ask how you can add another
> > layer of complexity to accomplish the same thing?
> >
> > I don't understand: what's wrong with the report?
> >
> > David
> >
> >
> > On Thu, Feb 8, 2018 at 16:14, Roger Miskowicz
> >  wrote:
> > I have an Investment Account which is a collection of stocks,
> certificates,
> > cash etc in two currencies.  I can get a report that tells me in my local
> > currency the current value of everything.
> >
> > I would like to create a stock, fund, or whatever appropriate with 1
> share
> > for which  I can manually update a single price representing the current
> > value of the entire collection.
> >
> > Using the online guide I have tried creating a fund or stock but I don't
> > understand the process and can't seem to get it to work and even
> > ocassionally crashing gnucash.
> >
> > I think I would like something such as:
> >
> > Investment
> >   Stocks
> > myStock  (I would like to manually update the price of a single
> share.)
> >
> >
> > I am using gucash 2.6.12 on Ubuntu 16.04 LTS.
> >
> > I would appreciate it if someone can suggest a way to do this.
> > ___
> > 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.

Price Retrieval Failure, Part 2

[David T. via gnucash-user]

In thread 
https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html 
, I 
noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac (OS 
X 10.13.3), Price retrieval was failing with the generic error: "There was an 
unknown error while retrieving the price quotes.”

*** As I noted there: Finance::Quote works at the command line:

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" 
"australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" 
"canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" 
"europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" 
"financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" 
"ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" 
"hu" "hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" 
"maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" 
"platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" 
"tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" 
"trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" 
"usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" 
"yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" 
"za_unittrusts”)

$ /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v alphavantage 
AAPL
Finance::Quote fields Gnucash uses:
symbol: AAPL <=== required
  date: 02/08/2018   <=== recommended
  currency: USD  <=== required
  last: 160.1350 <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

*** As I noted earlier: I restored the following two lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:

# Set AlphaVantage API Key to allow Finance::Quote to work
ALPHAVANTAGE_API_KEY=8SET

It seems to me that somehow Gnucash.app is not reading or using the 
ALPHAVANTAGE_API_KEY that is stored in its environment file. Either that, or 
somehow my environment file is not properly configured. However, I do not see 
any way to test these hypotheses. 

Can anyone tell me how I might determine **FROM WITHIN GNUCASH.APP** whether 
the Alphavantage API key is being read, and what its value currently is? Is 
there any other way to troubleshoot this problem?

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

Currency Issue

[Les]

I know this has been discussed in the past:

I have a foreign bank account, denominated in the local currency.  
Within this account, I also hold other currencies. However, the other 
currencies, instead of relating to the local currency, is relating to my 
native currency: USD.  This greatly distorts the total value of my 
foreign bank balance.  This is a problem because I have to report the 
year end value of all foreign accounts over $1.00 and one over 
$5.00 (individual).


Is there ever going to be a resolution to this problem? Suggestions?

Thanks,

Les

___
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: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

[Roger Miskowicz]

I went through the section 9.5.3 Entering Pre-Existing Stocks for about the
fifth time.  Don't know what I did differently but it now works as
expected.  Before it used to crash when I tried a price update.

Actually it still crashes when I click on Apply instead of Ok when editing
a Price Entry.  (I think, I need to check it out more to determine exactly
what I am doing to cause the crash).

Is there a related bug in 2.6.12?

On Thu, Feb 8, 2018 at 9:28 AM, David Carlson 
wrote:

> If you want to create a fictional stock and manually enter prices from
> time to time that is easy.
>
> Just use the security editor and invent a name and symbol, possibly under
> the group called Fund.  Do not set an online quote source.  Then manually
> use the price editor to enter prices for whatever dates you like.
>
> David C
>
> On Thu, Feb 8, 2018 at 8:00 AM, Roger Miskowicz 
> wrote:
>
>> Sorry, I just want to take a number from one online brokerage report and
>> manually put it into gnucash.
>>
>> On Thu, Feb 8, 2018 at 6:28 AM, David T.  wrote:
>>
>> > Roger,
>> >
>> > You stay by stating that you are able to generate a report that tells
>> you
>> > "the current value of everything."  Then, you ask how you can add
>> another
>> > layer of complexity to accomplish the same thing?
>> >
>> > I don't understand: what's wrong with the report?
>> >
>> > David
>> >
>> >
>> > On Thu, Feb 8, 2018 at 16:14, Roger Miskowicz
>> >  wrote:
>> > I have an Investment Account which is a collection of stocks,
>> certificates,
>> > cash etc in two currencies.  I can get a report that tells me in my
>> local
>> > currency the current value of everything.
>> >
>> > I would like to create a stock, fund, or whatever appropriate with 1
>> share
>> > for which  I can manually update a single price representing the current
>> > value of the entire collection.
>> >
>> > Using the online guide I have tried creating a fund or stock but I don't
>> > understand the process and can't seem to get it to work and even
>> > ocassionally crashing gnucash.
>> >
>> > I think I would like something such as:
>> >
>> > Investment
>> >   Stocks
>> > myStock  (I would like to manually update the price of a single
>> share.)
>> >
>> >
>> > I am using gucash 2.6.12 on Ubuntu 16.04 LTS.
>> >
>> > I would appreciate it if someone can suggest a way to do this.
>> > ___
>> > 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.