Fwd: Unable to download stock quotes

[Steven Anter]

-- Forwarded message --
From: Steven Anter 
Date: Fri, Mar 23, 2018 at 10:44 PM
Subject: Re: Unable to download stock quotes
To: Chris Good 


C:\Program Files (x86)\gnucash\bin>echo %PATH%
C:\ProgramData\Oracle\Java\javapath;C:\Perl\site\bin;C:\Perl\bin;C:\Program
Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files
(x86)\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\
WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\
WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL
SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL
SDK\2.0\bin\x64;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files
(x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Skype\Phone\;C:\
Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\
Strawberry\perl\bin;C:\Users\Steven\AppData\Local\Microsoft\WindowsApps;

C:\Program Files (x86)\gnucash\bin>
C:\Program Files (x86)\gnucash\bin>perl -v

This is perl 5, version 26, subversion 1 (v5.26.1) built for
MSWin32-x86-multi-thread-64int

Copyright 1987-2017, Larry Wall

Perl may be copied only under the terms of either the Artistic License or
the
GNU General Public License, which may be found in the Perl 5 source kit.

On Fri, Mar 23, 2018 at 10:29 PM, Steven Anter  wrote:

> I'm using strawberry perl
>
> On Fri, Mar 23, 2018 at 10:28 PM, Steven Anter  wrote:
>
>> I'm an Administrator
>> This is my computer
>> I used netplwiz to verify and ran   *echo (yahoo_json "CBA.AX
>> ") | perl gnc-fq-helper*
>>
>> On Fri, Mar 23, 2018 at 10:24 PM, Steven Anter  wrote:
>>
>>>
>>>
>>> *when I run: echo (yahoo_json "CBA.AX ") | perl
>>> gnc-fq-helper*
>>>
>>> I now get this
>>>
>>>
>>> (("CBA.AX" (symbol . "CBA.AX") (gnc:time-no-zone . "2018-03-22
>>> 12:00:00") (last . 72.81) (currency . "AUD")))
>>>
>>> On Fri, Mar 23, 2018 at 10:15 PM, Steven Anter 
>>> wrote:
>>>
 I used the cpan command


 On Fri, Mar 23, 2018, 9:41 PM Chris Good  wrote:

> Hi Steven,
>
>
>
> Do you mean you used the cpan command to find the version of
> Finance::Quote
>
> or you logged in as a user that does have administrative privileges?
>
>
>
> Please answer all the questions I ask, and tell me exactly what you
> have done, to speed up a resolution.
>
>
>
> Reinstalling may help but if you don’t have administrative privileges,
> it may cause more issues.
>
>
>
> We should try a few other things before reinstalling GnuCash.
>
>
>
> Re the “access denied” error from *perl gnc-fq-check:*
>
> What happens when you try running
>
> *cd \Program Files (x86)\gnucash\bin*
>
> *echo (yahoo_json "CBA.AX ") | perl gnc-fq-helper*
>
> from an administrative command prompt?
>
>
>
> What is your login name?
>
> Are you an administrator?
>
>
>
> In File Explorer, right click on C:\Program Files
> (x86)\gnucash\bin\gnc-fq-check,
>
> Properties, Security Tab.
>
> Click on each of the entries in ‘Group or user names’.
>
> Under Permissions for Users, for each, it should show at least “Read &
> Execute” & “Read” is allowed, as follows:
>
>
>
> Note my pc name is goodi7.
>
>
>
>
>
> Are you using strawberry perl or ActiveState perl?
>
> If you are using strawberry perl, which you should be, you should see
> only that in
>
> Start, Settings, Apps, not ActiveState.
>
>
>
> Please paste in the response from running the following in a command
> prompt (NOT administrative):
>
> *echo %PATH%*
>
> *perl -v*
>
>
>
> If you are a programmer , you can debug the problem using:
>
> *cd \Program Files (x86)\gnucash\bin*
>
> *echo (yahoo_json "CBA.AX ") | perl -d gnc-fq-helper*
>
> If you open in WordPad:
>
> *C:\strawberry\perl\site\lib\Finance\Quote\YahooJSON.pm*
>
> And change the Page Setup to landscape, do you see the following lines
> which are only in my fixed YahooJSON.pm:
>
>
>
> # MS Windows strftime() does not support %T so use %H:%M:%S
>
> #  instead.
>
> $my_date =
>
> localtime($json_timestamp)->strftime('%d.%m.%Y
> %H:%M:%S');
>
>
>
>
>
> Regards, Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Saturday, 24 March 2018 1:45 PM
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
>
>
> I followed your instructions.  I have 1.47.   Perhaps I should
> uninstall 

Fwd: Unable to download stock quotes

[Steven Anter]

-- Forwarded message --
From: Steven Anter 
Date: Fri, Mar 23, 2018 at 10:24 PM
Subject: Re: Unable to download stock quotes
To: Chris Good 




*when I run: echo (yahoo_json "CBA.AX ") | perl
gnc-fq-helper*

I now get this


(("CBA.AX" (symbol . "CBA.AX") (gnc:time-no-zone . "2018-03-22 12:00:00")
(last . 72.81) (currency . "AUD")))

On Fri, Mar 23, 2018 at 10:15 PM, Steven Anter  wrote:

> I used the cpan command
>
>
> On Fri, Mar 23, 2018, 9:41 PM Chris Good  wrote:
>
>> Hi Steven,
>>
>>
>>
>> Do you mean you used the cpan command to find the version of
>> Finance::Quote
>>
>> or you logged in as a user that does have administrative privileges?
>>
>>
>>
>> Please answer all the questions I ask, and tell me exactly what you have
>> done, to speed up a resolution.
>>
>>
>>
>> Reinstalling may help but if you don’t have administrative privileges, it
>> may cause more issues.
>>
>>
>>
>> We should try a few other things before reinstalling GnuCash.
>>
>>
>>
>> Re the “access denied” error from *perl gnc-fq-check:*
>>
>> What happens when you try running
>>
>> *cd \Program Files (x86)\gnucash\bin*
>>
>> *echo (yahoo_json "CBA.AX ") | perl gnc-fq-helper*
>>
>> from an administrative command prompt?
>>
>>
>>
>> What is your login name?
>>
>> Are you an administrator?
>>
>>
>>
>> In File Explorer, right click on C:\Program Files
>> (x86)\gnucash\bin\gnc-fq-check,
>>
>> Properties, Security Tab.
>>
>> Click on each of the entries in ‘Group or user names’.
>>
>> Under Permissions for Users, for each, it should show at least “Read &
>> Execute” & “Read” is allowed, as follows:
>>
>>
>>
>> Note my pc name is goodi7.
>>
>>
>>
>>
>>
>> Are you using strawberry perl or ActiveState perl?
>>
>> If you are using strawberry perl, which you should be, you should see
>> only that in
>>
>> Start, Settings, Apps, not ActiveState.
>>
>>
>>
>> Please paste in the response from running the following in a command
>> prompt (NOT administrative):
>>
>> *echo %PATH%*
>>
>> *perl -v*
>>
>>
>>
>> If you are a programmer , you can debug the problem using:
>>
>> *cd \Program Files (x86)\gnucash\bin*
>>
>> *echo (yahoo_json "CBA.AX ") | perl -d gnc-fq-helper*
>>
>> If you open in WordPad:
>>
>> *C:\strawberry\perl\site\lib\Finance\Quote\YahooJSON.pm*
>>
>> And change the Page Setup to landscape, do you see the following lines
>> which are only in my fixed YahooJSON.pm:
>>
>>
>>
>> # MS Windows strftime() does not support %T so use %H:%M:%S
>>
>> #  instead.
>>
>> $my_date =
>>
>> localtime($json_timestamp)->strftime('%d.%m.%Y
>> %H:%M:%S');
>>
>>
>>
>>
>>
>> Regards, Chris Good
>>
>>
>>
>> *From:* Steven Anter 
>> *Sent:* Saturday, 24 March 2018 1:45 PM
>> *To:* Chris Good 
>> *Subject:* Re: Unable to download stock quotes
>>
>>
>>
>> Chris,
>>
>>
>>
>> I followed your instructions.  I have 1.47.   Perhaps I should uninstall
>> and then reinstall gnucash?
>>
>>
>>
>>
>> 
>>
>> Virus-free. www.avast.com
>> 
>>
>>
>>
>> On Wed, Mar 21, 2018 at 10:18 PM, Chris Good 
>> wrote:
>>
>> Hi Steven,
>>
>>
>>
>> Well that’s strange.
>>
>> Was Gnucash perhaps installed when signed on as another user?
>>
>> Try running the echo command from an administrative command prompt.
>>
>>
>>
>> If you don’t have administrative privileges, login to Windows as a user
>> that does.
>>
>>
>>
>> Another way to check the version of Finance::Quote:
>>
>>   From a command prompt (NOT run as administrator):
>>
>>cpan
>>
>>m Finance::Quote
>>
>>quit
>>
>>
>>
>> If your Finance::Quote is not 1.47:
>>
>> cpan
>>
>>upgrade Finance::Quote
>>
>>quit
>>
>> After you upgrade Finance::Quote you will need to reinstall my fixed
>> YahooJSON.pm.
>>
>>
>>
>> Good luck, Chris Good
>>
>>
>>
>> *From:* Steven Anter 
>> *Sent:* Wednesday, 21 March 2018 4:49 PM
>>
>>
>> *To:* Chris Good 
>> *Subject:* Re: Unable to download stock quotes
>>
>>
>>
>> Chris,
>>
>>
>>
>>
>>
>> When I try to execute this:
>>
>> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check*
>>
>>
>>
>> I get
>>
>> Access Denied
>>
>>
>>
>>
>> 
>>
>> Virus-free. www.avast.com
>> 
>>
>>
>>
>> On Tue, Mar 20, 2018 at 10:43 PM, Chris Good 
>> wrote:
>>
>> Hi Steve,
>>
>>
>>
>> Hmm.. works for me.

Fwd: Unable to download stock quotes

[Steven Anter]

-- Forwarded message --
From: Steven Anter 
Date: Fri, Mar 23, 2018 at 10:15 PM
Subject: Re: Unable to download stock quotes
To: Chris Good 


I used the cpan command


On Fri, Mar 23, 2018, 9:41 PM Chris Good  wrote:

> Hi Steven,
>
>
>
> Do you mean you used the cpan command to find the version of
> Finance::Quote
>
> or you logged in as a user that does have administrative privileges?
>
>
>
> Please answer all the questions I ask, and tell me exactly what you have
> done, to speed up a resolution.
>
>
>
> Reinstalling may help but if you don’t have administrative privileges, it
> may cause more issues.
>
>
>
> We should try a few other things before reinstalling GnuCash.
>
>
>
> Re the “access denied” error from *perl gnc-fq-check:*
>
> What happens when you try running
>
> *cd \Program Files (x86)\gnucash\bin*
>
> *echo (yahoo_json "CBA.AX ") | perl gnc-fq-helper*
>
> from an administrative command prompt?
>
>
>
> What is your login name?
>
> Are you an administrator?
>
>
>
> In File Explorer, right click on C:\Program Files 
> (x86)\gnucash\bin\gnc-fq-check,
>
>
> Properties, Security Tab.
>
> Click on each of the entries in ‘Group or user names’.
>
> Under Permissions for Users, for each, it should show at least “Read &
> Execute” & “Read” is allowed, as follows:
>
>
>
> Note my pc name is goodi7.
>
>
>
>
>
> Are you using strawberry perl or ActiveState perl?
>
> If you are using strawberry perl, which you should be, you should see only
> that in
>
> Start, Settings, Apps, not ActiveState.
>
>
>
> Please paste in the response from running the following in a command
> prompt (NOT administrative):
>
> *echo %PATH%*
>
> *perl -v*
>
>
>
> If you are a programmer , you can debug the problem using:
>
> *cd \Program Files (x86)\gnucash\bin*
>
> *echo (yahoo_json "CBA.AX ") | perl -d gnc-fq-helper*
>
> If you open in WordPad:
>
> *C:\strawberry\perl\site\lib\Finance\Quote\YahooJSON.pm*
>
> And change the Page Setup to landscape, do you see the following lines
> which are only in my fixed YahooJSON.pm:
>
>
>
> # MS Windows strftime() does not support %T so use %H:%M:%S
>
> #  instead.
>
> $my_date =
>
> localtime($json_timestamp)->strftime('%d.%m.%Y
> %H:%M:%S');
>
>
>
>
>
> Regards, Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Saturday, 24 March 2018 1:45 PM
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
>
>
> I followed your instructions.  I have 1.47.   Perhaps I should uninstall
> and then reinstall gnucash?
>
>
>
>
> 
>
> Virus-free. www.avast.com
> 
>
>
>
> On Wed, Mar 21, 2018 at 10:18 PM, Chris Good 
> wrote:
>
> Hi Steven,
>
>
>
> Well that’s strange.
>
> Was Gnucash perhaps installed when signed on as another user?
>
> Try running the echo command from an administrative command prompt.
>
>
>
> If you don’t have administrative privileges, login to Windows as a user
> that does.
>
>
>
> Another way to check the version of Finance::Quote:
>
>   From a command prompt (NOT run as administrator):
>
>cpan
>
>m Finance::Quote
>
>quit
>
>
>
> If your Finance::Quote is not 1.47:
>
> cpan
>
>upgrade Finance::Quote
>
>quit
>
> After you upgrade Finance::Quote you will need to reinstall my fixed
> YahooJSON.pm.
>
>
>
> Good luck, Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 4:49 PM
>
>
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
>
>
>
>
> When I try to execute this:
>
> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check*
>
>
>
> I get
>
> Access Denied
>
>
>
>
> 
>
> Virus-free. www.avast.com
> 
>
>
>
> On Tue, Mar 20, 2018 at 10:43 PM, Chris Good 
> wrote:
>
> Hi Steve,
>
>
>
> Hmm.. works for me.
>
> What version of Finance::Quote do you have:
>
>
>
> Do
>
>
>
> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check*
>
>
>
> Response should be:
>
> ("*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" 

Fwd: Unable to download stock quotes

[Steven Anter]

-- Forwarded message --
From: Steven Anter 
Date: Fri, Mar 23, 2018 at 10:46 PM
Subject: Fwd: Unable to download stock quotes
To: gnucash-user@gnucash.org



-- Forwarded message --
From: Steven Anter 
Date: Fri, Mar 23, 2018 at 7:45 PM
Subject: Re: Unable to download stock quotes
To: Chris Good 


Chris,

I followed your instructions.  I have 1.47.   Perhaps I should uninstall
and then reinstall gnucash?


Virus-free.
www.avast.com

<#m_1583295558011341580_m_-1344617281304295049_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Wed, Mar 21, 2018 at 10:18 PM, Chris Good  wrote:

> Hi Steven,
>
>
>
> Well that’s strange.
>
> Was Gnucash perhaps installed when signed on as another user?
>
> Try running the echo command from an administrative command prompt.
>
>
>
> If you don’t have administrative privileges, login to Windows as a user
> that does.
>
>
>
> Another way to check the version of Finance::Quote:
>
>   From a command prompt (NOT run as administrator):
>
>cpan
>
>m Finance::Quote
>
>quit
>
>
>
> If your Finance::Quote is not 1.47:
>
> cpan
>
>upgrade Finance::Quote
>
>quit
>
> After you upgrade Finance::Quote you will need to reinstall my fixed
> YahooJSON.pm.
>
>
>
> Good luck, Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 4:49 PM
>
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
>
>
>
>
> When I try to execute this:
>
> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check*
>
>
>
> I get
>
> Access Denied
>
>
>
>
> 
>
> Virus-free. www.avast.com
> 
>
>
>
> On Tue, Mar 20, 2018 at 10:43 PM, Chris Good 
> wrote:
>
> Hi Steve,
>
>
>
> Hmm.. works for me.
>
> What version of Finance::Quote do you have:
>
>
>
> Do
>
>
>
> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check*
>
>
>
> Response should be:
>
> ("*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")
>
>
>
> You should have version 1.47 at the start of the response. This is the
> latest.
>
>
>
> Regards,
>
>
>
> Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 4:29 PM
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
> I ran this in the command prompt
>
>
>
> *C:\Program Files (x86)\gnucash\bin>echo (yahoo_json "CBA.AX
> ") | perl gnc-fq-helper*
>
>
>
>
>
> This is all that returned:
>
> *(#f)*
>
>
>
>
> 
>
> Virus-free. www.avast.com
> 
>
>
>
> On Tue, Mar 20, 2018 at 10:08 PM, Chris Good 
> wrote:
>
> Hi Steven,
>
>
>
> Instructions are in the nabble link. GnuCash does not have to be running.
>
>
>
> Regards,
>
>
>
> Chris Good
>
> Mobile 0484 001 392
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 4:06 PM
> *To:* Chris Good 
> *Subject:* RE: Unable to download stock quotes
>
>
>
> Chris,
>
> I know how to run a command from the prompt.
>
> But what's the command?
>
> Can I run it from any directory?
>
> Does gnucash have to be running?
>
>
>
> On Mar 20, 2018 10:02 PM, "Chris Good"  wrote:
>
> Hi Steven,
>
>
>
> Type 

Fwd: Unable to download stock quotes

[Steven Anter]

-- Forwarded message --
From: Steven Anter 
Date: Fri, Mar 23, 2018 at 7:45 PM
Subject: Re: Unable to download stock quotes
To: Chris Good 


Chris,

I followed your instructions.  I have 1.47.   Perhaps I should uninstall
and then reinstall gnucash?


Virus-free.
www.avast.com

<#m_-1344617281304295049_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Wed, Mar 21, 2018 at 10:18 PM, Chris Good  wrote:

> Hi Steven,
>
>
>
> Well that’s strange.
>
> Was Gnucash perhaps installed when signed on as another user?
>
> Try running the echo command from an administrative command prompt.
>
>
>
> If you don’t have administrative privileges, login to Windows as a user
> that does.
>
>
>
> Another way to check the version of Finance::Quote:
>
>   From a command prompt (NOT run as administrator):
>
>cpan
>
>m Finance::Quote
>
>quit
>
>
>
> If your Finance::Quote is not 1.47:
>
> cpan
>
>upgrade Finance::Quote
>
>quit
>
> After you upgrade Finance::Quote you will need to reinstall my fixed
> YahooJSON.pm.
>
>
>
> Good luck, Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 4:49 PM
>
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
>
>
>
>
> When I try to execute this:
>
> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check*
>
>
>
> I get
>
> Access Denied
>
>
>
>
> 
>
> Virus-free. www.avast.com
> 
>
>
>
> On Tue, Mar 20, 2018 at 10:43 PM, Chris Good 
> wrote:
>
> Hi Steve,
>
>
>
> Hmm.. works for me.
>
> What version of Finance::Quote do you have:
>
>
>
> Do
>
>
>
> C:\Program Files (x86)\gnucash\bin> *perl gnc-fq-check*
>
>
>
> Response should be:
>
> ("*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")
>
>
>
> You should have version 1.47 at the start of the response. This is the
> latest.
>
>
>
> Regards,
>
>
>
> Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 4:29 PM
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
> I ran this in the command prompt
>
>
>
> *C:\Program Files (x86)\gnucash\bin>echo (yahoo_json "CBA.AX
> ") | perl gnc-fq-helper*
>
>
>
>
>
> This is all that returned:
>
> *(#f)*
>
>
>
>
> 
>
> Virus-free. www.avast.com
> 
>
>
>
> On Tue, Mar 20, 2018 at 10:08 PM, Chris Good 
> wrote:
>
> Hi Steven,
>
>
>
> Instructions are in the nabble link. GnuCash does not have to be running.
>
>
>
> Regards,
>
>
>
> Chris Good
>
> Mobile 0484 001 392
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 4:06 PM
> *To:* Chris Good 
> *Subject:* RE: Unable to download stock quotes
>
>
>
> Chris,
>
> I know how to run a command from the prompt.
>
> But what's the command?
>
> Can I run it from any directory?
>
> Does gnucash have to be running?
>
>
>
> On Mar 20, 2018 10:02 PM, "Chris Good"  wrote:
>
> Hi Steven,
>
>
>
> Type into Google: how to run a command prompt
>
>
>
> Sorry to seem unhelpful but the GnuCash Users email list is not the place
> to teach basic computer usage.
>
> Google is your friend.. or perhaps you have a friend who 

where to share GnuCash python scripts?

[darrylctx]

I am doing a project bringing years of old data that I only have in pdf files
into GC.I've been writing some python scripts to make sucking data out
of the PDF files, converting them to CSV files that can easily be checked in
a spreadsheet, and then converting the CSV files into QIF that can be
imported as QIF files.  The process has the added benefit of generating
files that can be used as a reconciliation aid once the files are imported.  

Where would be the best place to upload the .py files if I wanted to share
them?  Right now, they are pretty raw, but I could clean them up and make
them a little easier to use.  At the least, they are an example of how easy
it is to get data into GC with a few simple python scripts.

GnuCash is a great forensic accounting tool.





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

Thanks and solution to "incorrect starting balance in reconcile."

[darrylctx]

First, regarding my recent post re. "incorrect starting balance in
reconcile," thanks to everyone who helped.  The many replies helped me
understand a couple of things:

1.  the find is limited to the dates in the current filter if you execute it
while on the account tab that is being filtered.  I had not used the view
filter much before, so this had not come up. 
2.  the reconcile includes ALL reconciled transactions, even those after the
date being reconciled.

Once I understood this, I selected Show All in the filter, and the Find for
reconciled found a reconciled transaction that I had accidentally changed
the date on to one well after the period I was reconciling.

The comments of many people that a problem had never been found with
reconcile, along with comments that led me to the above solved the problem. 

I've been using GnuCash for years and I've never had a problem that I could
not figure out by reading the forums until recently, but I was in a bit of a
rush on this one, so I thought I would post it.  It is nice to know that the
forum people are so responsive.

I did post a reply that I had solved the problem because there were so many
people that helped that I only posted it once, rather than replying to
everyone.  Is there a place in the thread on the forum that I can post the 
"solution" with a thank you note?  I looked but did not see anything like
that, so I decided to post this as a new thread.

Thanks to everyone for the help.







--
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: Date limit on transactions / freezing transactions

[David T. via gnucash-user]

Stan, 
There is a setting that might help you: File->Properties->Day threshold for 
read-only transactions 
I'm not sure whether it will help in your use case, but it's worth mentioning. 
On a side note, I recall you saying you are planning to merge these two files 
at a later date. Do you have any idea how you plan to do this? I ask, because 
as far as I know, there is no merge option in gnucash itself. 
David T 

 
 
  On Sat, Mar 24, 2018 at 2:02, Stan Brown wrote:   
Thanks, but I meant that while I am entering later months, I don't want to be 
able to alter earlier months.  Such an alteration happened once, in September 
2012 while I was (I thought) entering November 2012, and it's only when the 30 
November 2012 balance sheet didn't match my source database that I discovered 
it.

-- 
Stan Brown
the_stan_br...@fastmail.fm
http://BrownMath.com
http://OakRoadSystems.com/

On Fri, Mar 23, 2018, at 2:47 PM, Mike or Penny Novack wrote:
> Am I correct, you want to be able to look at your historical data but 
> not alter it? That's easy. After you have gotten the historical file to 
> your satisfaction, make a copy of the file to ROM (burn it to a DVD, 
> etc.) and delete the one in read/write memory. Now in the future, when 
> you want to look at your historical books, insert that DVD, open 
> gnucash, and tell gnucash to open the file (on the DVD)
___
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: Date limit on transactions / freezing transactions

[Stan Brown]

Thanks, but I meant that while I am entering later months, I don't want to be 
able to alter earlier months.  Such an alteration happened once, in September 
2012 while I was (I thought) entering November 2012, and it's only when the 30 
November 2012 balance sheet didn't match my source database that I discovered 
it.

-- 
Stan Brown
the_stan_br...@fastmail.fm
http://BrownMath.com
http://OakRoadSystems.com/

On Fri, Mar 23, 2018, at 2:47 PM, Mike or Penny Novack wrote:
> Am I correct, you want to be able to look at your historical data but 
> not alter it? That's easy. After you have gotten the historical file to 
> your satisfaction, make a copy of the file to ROM (burn it to a DVD, 
> etc.) and delete the one in read/write memory. Now in the future, when 
> you want to look at your historical books, insert that DVD, open 
> gnucash, and tell gnucash to open the file (on the DVD)
___
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: Date limit on transactions / freezing transactions

[Mike or Penny Novack]

On 3/23/2018 2:28 PM, Stan Brown wrote:

I am entering historical data 2011-2017 in a Gnucash file separate from my 
current file (starting 2018).

(1) In the historical file, I want to limit transactions so that I can't enter 
a date of 2018 or otherwise out a certain range. Is there any way?

(2) Also in the historical file, once I've checked a month's data against the 
dBase original, I want to mark those transactions so that they can't be 
altered. Is there a way to do that? I thought reconciliation might do it, but 
(a) I can't reconcile even the initial balances, though they do balance, and 
(b) in the help I saw reference to deleting reconciled transactions, which 
sounds like they are not protected.

Thanks in advance!

MARK the transactions so that they cannot be altered? Or MAKE the entire 
historical set of books unalterable?


Am I correct, you want to be able to look at your historical data but 
not alter it? That's easy. After you have gotten the historical file to 
your satisfaction, make a copy of the file to ROM (burn it to a DVD, 
etc.) and delete the one in read/write memory. Now in the future, when 
you want to look at your historical books, insert that DVD, open 
gnucash, and tell gnucash to open the file (on the DVD)


Michael D Novack

--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

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

Date limit on transactions / freezing transactions

[Stan Brown]

I am entering historical data 2011-2017 in a Gnucash file separate from my 
current file (starting 2018).

(1) In the historical file, I want to limit transactions so that I can't enter 
a date of 2018 or otherwise out a certain range. Is there any way?

(2) Also in the historical file, once I've checked a month's data against the 
dBase original, I want to mark those transactions so that they can't be 
altered. Is there a way to do that? I thought reconciliation might do it, but 
(a) I can't reconcile even the initial balances, though they do balance, and 
(b) in the help I saw reference to deleting reconciled transactions, which 
sounds like they are not protected.

Thanks in advance!

-- 
Stan Brown
the_stan_br...@fastmail.fm
http://BrownMath.com
http://OakRoadSystems.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: Recent posts and replies missing issues in several GnuCash user threads

[Adrien Monteleone]

This morning I received a second copy of this message from Mailman: 
https://lists.gnucash.org/pipermail/gnucash-user/2018-March/075638.html

I also have a copy from yesterday. The copy from yesterday is in a thread with 
a reply. (as noted on the Archive pages)

But the copy today does not show any reply, is now in it’s own thread, and is 
not on the Archive pages.

It seems Mailman sent me another copy but did not show another post in the 
Archive.

Did anyone else get that above linked post twice?

If so, the problem is with Mailman, if not, then perhaps my Gmail account is 
having fits.

Regards,
Adrien

> On Mar 22, 2018, at 12:01 PM, Adrien Monteleone  
> wrote:
> 
> I too noticed a change about a month or two ago. Perhaps it was happening 
> before, but it seems more frequent lately.
> 
> My subscribed address is Gmail, but I use macOS mail client on my desktop so 
> it’s not a web vs. client issue.
> 
> So far that I can tell, it appears though that the issue may not be Gmail, 
> but rather people hitting the reply button instead of new/compose. It seems 
> they are taking the advice to change the subject line appropriately, but that 
> still breaks the thread. (threading is by message id, not subject text) I 
> investigated a few such threads by viewing By Thread on the archive page. 
> Sure enough, subject lines changed in several threads, and it was the same 
> few users in each case causing the issue.
> 
> What I have noticed as odd is that posts appear to be re-sending. (at least 
> OPs from newbies) One of these I determined was a real re-post, I didn’t 
> investigate the others to see if they were in fact re-posted or if the 
> mailman server was re-sending them. Sometimes this happens for replies too. 
> So I’ll see a thread, maybe even participate in it, and then 3 days later, 
> the OP appears again fresh and new. At least in the one case that was an 
> actual repost, I suspect the OP did not check to see if they received a reply 
> from the list, or else, it’s possible to post to the list without 
> subscribing. (I didn’t think this was possible) If the latter is the case, 
> then if they don’t subscribe, they won’t get any replies sent back *only* to 
> the list. The usual tell-tale for this is a newbie posts a question, several 
> people chime in with answers, and the OP never responds again. Then they 
> repost the original question.
> 
> Personally, I reply-to-list. I do not ‘reply-all’. Reply-all will send to the 
> list AND each sender (depending on the message you are replying to) which 
> then means those people get multiple copies. I personally don’t care to deal 
> with duplicates of the same message, so I try to avoid it for others. But if 
> people can post without subscribing, that means they’ll never see my reply. 
> (or the reply of anyone else only replying to the list) Does Nabble allow 
> people to post and not subscribe? Perhaps they are using Nabble and then 
> loosing track of the thread to see replies? Maybe they don’t know how to find 
> their own threads? (I’m not a Nabble user)
> 
> Regards,
> Adrien
> 
>> On Mar 22, 2018, at 8:01 AM, David Carlson  
>> wrote:
>> 
>> I have noticed an issue on my computer recently that Gmail is not always
>> correctly displaying threads from the GnuCash user maillists.  I have
>> usually been able to find the missing items by scrolling through the
>> threads, but then I see all the duplicated text in the replies and I get
>> even more confused.
>> 
>> This could be affecting other users as well.
>> 
>> David C
>> ___
>> 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: incorrect starting balance in reconcile

[Adrien Monteleone]

Double check the date on the first reconcile window. That has often been a 
source of consternation for me.

Regards,
Adrien

> On Mar 22, 2018, at 8:08 PM, darrylctx  wrote:
> 
> I have unreconciled all txns in the account.
> 
> I am trying to reconcile the first txn.  It is $0.
> 
> It is obviously not calculating the reconcile balance by adding up previous
> unreconciled because it is coming up -$918.00.  There are not transactions
> in the register before the one I am trying to reconcile.
> 
> Thanks,
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Recent posts and replies missing issues in several GnuCash user threads

[Adrien Monteleone]

Yes I did, though curiously, 5 minutes apart.

I’m leaving this reply as both TO you and CC the list. (your’s was opposite - 
TO the list, and CC me) Did you get this reply twice?

Regards,
Adrien

> On Mar 22, 2018, at 11:25 PM, Geert Janssens  
> wrote:
> 
> Op vrijdag 23 maart 2018 00:01:05 WIB schreef Adrien Monteleone:
>> Personally, I reply-to-list. I do not ‘reply-all’. Reply-all will send to
>> the list AND each sender (depending on the message you are replying to)
>> which then means those people get multiple copies.
> 
> I doubt this. I believe mailman is smart enough to send the message only once 
> if the direct mails are also list subscribers. I've been using reply-all for 
> a 
> long time (and I deliberately did so for this message).
> 
> Do you get it twice ?
> 
> 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: Compiling -DWITH_GNUCASH=NO

[John Ralls]

> On Mar 23, 2018, at 8:34 AM, Matthew Pounsett  wrote:
> 
> On 23 March 2018 at 00:35, Geert Janssens 
> wrote:
> 
>> 
>> Ideally this would become part of libgnucash in order to make the report
>> generation platform independent as well (and hence opening the way to make
>> it
>> accessible one day on android or osx platforms). This will only be
>> possible at
>> the cost of moving away from scheme as reporting engine unfortunately as
>> that
>> would not be portable...
>> 
> 
> lua maybe?  It seems popular and portable.. and it's already on my personal
> education roadmap. :)

Apple’s rules for iOS include *no interpreters*. That means no Guile, no 
Python, no Lua, no Ruby, no Javascript.

BTW, no, lua isn’t particularly popular: 
https://insights.stackoverflow.com/survey/2017#technology 

https://isocpp.org/files/papers/CppDevSurvey-2018-02-summary.pdf 


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: Compiling -DWITH_GNUCASH=NO

[Matthew Pounsett]

On 23 March 2018 at 00:35, Geert Janssens 
wrote:

>
> Ideally this would become part of libgnucash in order to make the report
> generation platform independent as well (and hence opening the way to make
> it
> accessible one day on android or osx platforms). This will only be
> possible at
> the cost of moving away from scheme as reporting engine unfortunately as
> that
> would not be portable...
>

lua maybe?  It seems popular and portable.. and it's already on my personal
education roadmap. :)
___
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: Recent posts and replies missing issues in several GnuCash user threads

[Adonay Felipe Nogueira]

> I doubt this. I believe mailman is smart enough to send the message only 
> once> if the direct mails are also list subscribers. I've been using 
> reply-all for a 

Not exactly, for one, the path taken when someone is in both a direct
recipient or an indirect recipient through a mailing list is somewhat
different. Most of the times the direct one arrives first.

What you probably refer to which seems to be helping you not get
duplicate messages is the client software.
___
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: incorrect starting balance in reconcile

[Colin Law]

Did you try John's suggestion to use the Edit->Find menu item to search for
entries by their reconcile status?

Colin

On 23 March 2018 at 01:04, darrylctx  wrote:

> I am trying to reconcile the first transaction in the account, and yes view
> is set to show all.
>
> thanks
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: incorrect starting balance in reconcile

[darrylctx]

Thanks to all who posted.  I had done a search several times on the whole
account for reconciled trxns, and it came up no results, but I did it again,
and it came up with the problem.  Perhaps I had the date filter set or
something.

Thanks to everyone for the help.  Knowing that the balance is calculated on
the fly including all txns in the entire account helped alot.







--
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: incorrect starting balance in reconcile

[darrylctx]

I have unreconciled all txns in the account.

I am trying to reconcile the first txn.  It is $0.

It is obviously not calculating the reconcile balance by adding up previous
unreconciled because it is coming up -$918.00.  There are not transactions
in the register before the one I am trying to reconcile.

Thanks,



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

GNUCash Check Printing

[Robert Lewis]

Hi.  I'm looking for a good example of how to specify the font and size of
a line to be printed in a custom .chk file.  I know it is specified with
"font_n" ("n" being the line number)  but the format of what follows is
what I cannot find any reference to or an example of.  Thanks

-- 
*<< Robert Lewis >>*
___
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: incorrect starting balance in reconcile

[darrylctx]

I am trying to reconcile the first transaction in the account, and yes view
is set to show all.

thanks



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: "Unrealized Losses" in Trial Balance Report

[Christoph R]

Hi Richard,

> Adrien asked if I have Trading Accounts enabled. I didn't know about this 
> feature, and I see that I have it turned off. I turned it on and re-generated 
> my Trial Balance, but I didn't see any difference.

You need to run “Actions -> Check & Repair -> Check & Repair All” to add the 
needed splits to existing transactions.

Gruß,
Christoph

> Am 23.03.2018 um 05:47 schrieb Richard :
> 
> HI all,
> 
> Thanks everyone for your thoughts. Once I see what my accountant does with 
> these foreign currency transactions, I will try entering them back into 
> GnuCash and see what happens. 
> 
> A message from Christopher mentioned stocks and capital gains. I don't have 
> any stocks in my books, but as I mentioned I do have a small gain or loss due 
> to currency conversion. I'm working with my accountant on this. What's so 
> strange about this "Unrealized losses" line that appeared in the trial 
> balance is that it's so much larger than any gain or loss that I have from 
> currency conversion. However, the "Unrealized losses" line could disappear 
> when I account for these currency exchange gains or losses correctly. 
> 
> Adrien asked if I have Trading Accounts enabled. I didn't know about this 
> feature, and I see that I have it turned off. I turned it on and re-generated 
> my Trial Balance, but I didn't see any difference.
> 
> Cheers,
> Richard
> 
> 
> 
> On 23/3/18, 2:25 AM, "gnucash-user on behalf of Adrien Monteleone" 
>  adrien.montele...@gmail.com> wrote:
> 
>The rounding error I found can be very large depending on the variance 
> between the exchange rate for each transaction and the date of the report. 
> But, I don’t think it affects anything else, because it’s a function of the 
> report, not any math Gnucash otherwise performs. And I’ve never seen this 
> discrepancy anywhere else. Others are using multiple currencies without major 
> issue, so I don’t think overall that there’s any danger. Perhaps someone who 
> routinely uses multiple currencies AND performs Trial Balance reports could 
> weigh in.
> 
>As for the Unrealized line, do you have Trading Accounts enabled by 
> chance? I’d have to play with it, but perhaps that is why you are seeing that 
> line at all. (I have it on in my book) I don’t know the implications of 
> turning that off once it’s on. One of the more seasoned users or developers 
> would have to chime in.
> 
>However, you can ‘adjust it out’ if need be. (that’s the purpose of a 
> trial-balance, to determine what if any adjusting entries need to be made) In 
> this case, you won’t be making any actual transaction entries in Gnucash - 
> just on the Trial Balance.
> 
>Check this out:
> 
>Trial Balance Total Debits - Trial Balance Total Credits + 
> Unrealized(+Gain, -Loss) = rounding error (or zero if no error)
> 
>If this equation holds true for your Trial Balance Report, then you are 
> otherwise in balance. If not, then you really do have an error somewhere that 
> you need to correct/adjust for.
> 
>To determine the actual rounding error, open the foreign currency asset 
> account. Add up all of the entries in the native currency. (If you have 
> Trading Accounts on, you’ll see two debits and credits for each transaction, 
> one in the native currency of the book, and one in the foreign currency of 
> the account) Then subtract balance of this account found on the trial 
> balance. The result is the rounding error. So for example if the sum of your 
> SGD entries is debit S$1100 and the Trial Balance report says the account is 
> really debit S$1000, then the rounding error is S$100.
> 
>So if the result of Total Debits - Total Credits - Unrealized Loss = 
> S$100, then you are otherwise in balance.
> 
>I’ve tried several reports to do this math for me to no avail. Probably 
> the closest is the Account report, but that doesn’t give totals in the native 
> currency, only the foreign currency set for that account. I suppose though it 
> would be trivial enough to copy/export to a spreadsheet to generate that 
> figure. My XAG account only has about 10 entries, so I don’t mind doing the 
> calculator math. 
> 
> 
>Regards,
>Adrien
> 
>> On Mar 22, 2018, at 4:42 AM, Richard  wrote:
>> 
>> Thanks for your thoughts, Adrien.
>> 
>> Yes, I do have losses from changes in exchange rates between when I booked a 
>> currency and the date of the report. However, these changes were tiny 
>> compared to the "Unrealized Losses" figure that appeared in the Trial 
>> Balance report. So, while I agree that this report shouldn't show virtual 
>> accounts, the bigger question in my mind is, "Where did this number come 
>> from?" That's still a mystery to me, but the use of multiple currencies is 
>> definitely a trigger. As soon as I remove all transactions in a foreign 
>> currency,