Re: [GNC] First request to kindly help

[david amaral via gnucash-user]

 To set up a "NEW" gnucash file, make sure that your windows documents 
directory has no gnucash directory in iteither delete all the files in it or 
rename the gnucash directory "OLD_gnucash" to save any older files you may have.
On Thursday, July 4, 2024 at 12:32:26 AM MST, Norbert Klein via 
gnucash-user  wrote:  
 
 My name is Norbert Klein, German, since 1990 in Cambodia, 90 years old,
but still alive and interested.

After this self-introduction, I would like to ask for your help. I read
since some days the GnuCash user mailing list, and I see the many
detailed qestion raised and responded. Several years ago, I had been
using GnuCash, but because of changed working responsibilities this had
been given up – and I do not have any copies. But the new task is
similar: to set up a general income-and-expenses system, with the two
currencies US$ and Cambodian/Khmer Riel – with the widely used fixed
rate of US$1.00 to Riel 4,000.

Then I tried to clean my Windows 10 notebook from any remaining old
“*gnu*” file which might have reamined from before.

I downloaded gnucash-5.7.setup.exe and started the installation, and the
installation happened in

C:\System\ProgramFiles(x86)\gnucash

I was happy to see that also a GnuCash icon had been created on the
desktop, and I hoped I could now start to set up the GnuCash program –
but here my frustration started.

I tried for several hours to solve it – in vain. I describe here what I
got, and I ask for your advice.

After clicking on the GnuCash icon, I get – only very short – a kind of
general GnuCash display picture, and then a GnuCash Tip-of-the-Day.
These disappear quickly, and a full screen field shows up:

Unsaved Book - GnuCash

File     Edit     View     Actions Business   Reports     Tools
Windows   Help (9 items)

Save Close
(with a grayed out Down Arrow)   (with a crossed out x-sign)

When click I see:  When click I see:
Save the current file.            Close the current active page.

But I cannot use these activations – but I can close the whole screen.

I had also tried the 9 items above – but I did not find out where these
contacts would lead me.

So I am totally frustrated, and I started to write to the help list.

Please help.

Norbert




--
This email has been checked for viruses by Avast antivirus software.
www.avast.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Problem with Online Quotes/Price Database

[david amaral via gnucash-user]

 dont know why this happened but.shoud be
cd Program Files (x86)\gnucash\bin
perl gnc-fq-check (should get some info)
if not install/reinstall finance quote
cpanm Finance::Quote
perl gnc-fq-update
close all apps and reboot
should fix your problem



On Friday, June 14, 2024 at 11:05:26 AM MST, david amaral via gnucash-user 
 wrote:  
 
  Had same problem and this resolved it
open CMD windowcd Program Files (x86)\gnucash\binperl gnc-fq-check (should get 
some info)if not install/reinstall finance quotecpanm Finance::Quote
perl gnc-fq-update
close all apps and reboot
should fix your problem

    On Friday, June 14, 2024 at 10:33:05 AM MST, Kalpesh Patel 
 wrote:  
 
 It is very likely that when you uninstalled Strawberry Perl, it also
uninstalled Finance::Quote library which is needed to download quotes.

At a Windows' CMD (Command line) console, you should be able to installed it.
Instructions are as follows:

1) At the command prompt execute following to bring up CPAN shell:
perl -MCPAN -e shell

2) In CPAN shell type in following command (this might trigger initialization
question for CPAN module since it will be seen as being run for first time.
accepting all defaults setting is fine so answer 'Y' when prompted):
install Finance::Quote

Get your favorite drink and enjoy it while all dependencies are downloaded and
installed. If all goes well then you should see following (or similar) message
at completion of step 2:
Finance::Quote is up to date (1.62).

Once finished, I recommend you reboot and then launch GNUCash. If everything
works as it suppose to, the button will be no longer greyed out.

Hope that helps.


> On Jun 13, 2024, at 1:25 AM, Steve Barru  wrote:
>
> I am using GnuCash v4.12 on a 64-bit Windows 11 laptop to keep track of
> personal finances. I am retired and my income consists of Social Security
> and distributions from investments in funds and occasionally, stocks. I
> live outside of the US and am tracking dual-currencies with GnuCash. When I
> started running GnuCash in Jan 2023, I set up the Online Price Retrieval
> module for equities and forex quotations. I have been using the Price
> Database tool to fetch quotes on a more or less monthly basis and this has
> worked seamlessly until May 2024 when I got an error message telling me
> there was a problem with the database or something to that effect. Beyond
> periodic Windows updates, no changes to my system that I know of.
>
> Since then I have uninstalled and then reinstalled the Strawberry Perl app
> that runs the online quote service; the version installed is 5.32.1001.
> After the installation, I ran the Price Database tool and the Get Quotes
> button on the right of the screen was grayed out. I got a new Alpha Vantage
> API key hoping that might solve the problem. It did not; the Get Quotes
> button is still grayed out.
>
> Looking for suggestions how to troubleshoot this, hopefully that are not
> exceptionally technical. Thanks for any help with this.
>
> Best,
> Steve
>
> --
> steve barru photographs <http://stevebarru.com!@#?>?#@!
> Mobile: +84 393 022 059
> Hoi An, Vietnam
>

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Problem with Online Quotes/Price Database

[david amaral via gnucash-user]

 Had same problem and this resolved it
open CMD windowcd Program Files (x86)\gnucash\binperl gnc-fq-check (should get 
some info)if not install/reinstall finance quotecpanm Finance::Quote
perl gnc-fq-update
close all apps and reboot
should fix your problem

On Friday, June 14, 2024 at 10:33:05 AM MST, Kalpesh Patel 
 wrote:  
 
 It is very likely that when you uninstalled Strawberry Perl, it also
uninstalled Finance::Quote library which is needed to download quotes.

At a Windows' CMD (Command line) console, you should be able to installed it.
Instructions are as follows:

1) At the command prompt execute following to bring up CPAN shell:
perl -MCPAN -e shell

2) In CPAN shell type in following command (this might trigger initialization
question for CPAN module since it will be seen as being run for first time.
accepting all defaults setting is fine so answer 'Y' when prompted):
install Finance::Quote

Get your favorite drink and enjoy it while all dependencies are downloaded and
installed. If all goes well then you should see following (or similar) message
at completion of step 2:
Finance::Quote is up to date (1.62).

Once finished, I recommend you reboot and then launch GNUCash. If everything
works as it suppose to, the button will be no longer greyed out.

Hope that helps.


> On Jun 13, 2024, at 1:25 AM, Steve Barru  wrote:
>
> I am using GnuCash v4.12 on a 64-bit Windows 11 laptop to keep track of
> personal finances. I am retired and my income consists of Social Security
> and distributions from investments in funds and occasionally, stocks. I
> live outside of the US and am tracking dual-currencies with GnuCash. When I
> started running GnuCash in Jan 2023, I set up the Online Price Retrieval
> module for equities and forex quotations. I have been using the Price
> Database tool to fetch quotes on a more or less monthly basis and this has
> worked seamlessly until May 2024 when I got an error message telling me
> there was a problem with the database or something to that effect. Beyond
> periodic Windows updates, no changes to my system that I know of.
>
> Since then I have uninstalled and then reinstalled the Strawberry Perl app
> that runs the online quote service; the version installed is 5.32.1001.
> After the installation, I ran the Price Database tool and the Get Quotes
> button on the right of the screen was grayed out. I got a new Alpha Vantage
> API key hoping that might solve the problem. It did not; the Get Quotes
> button is still grayed out.
>
> Looking for suggestions how to troubleshoot this, hopefully that are not
> exceptionally technical. Thanks for any help with this.
>
> Best,
> Steve
>
> --
> steve barru photographs ?#@!
> Mobile: +84 393 022 059
> Hoi An, Vietnam
>

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] No stock and currency quotes anymore

[david amaral via gnucash-user]

 Here is the fix for windos 11. worked for me

On 4/13/24 20:08:20 -0700, Bruce S wrote:

> There is some miscellaneous housekeeping and cleanup that needs to be
> done before pushing a final release to CPAN. Plus I had some other
> changes that I was planning for v1.60 but haven't done yet. Instead of
> v1.60, I may upload v1.59_01 tomorrow so people can at least fetch the
> fix for YahooJSON before v1.60 is uploaded and indexed by CPAN.

Pre-release F::Q v1.59_01 has been uploaded to CPAN.

To install using cpan or cpanm you must specify the path.

cpan> install BPSCHUCK/Finance-Quote-1.59_01.tar.gz

Bruce S.


On Thursday, April 18, 2024 at 02:55:16 AM GMT-7, assmsnap--- via 
gnucash-user  wrote:  
 
 Can't receive anymore stock and currency quotes since a few days.

I am using Gnucash 5.6 on windows 11,

Reinstalled Gnucash a few times.
Also did a few times "Online price retrieval for gnucash" 
Finance quote is 1.60 and 
JSON:: parse is up to date 0.62

Look at the attachments and please tell me what to do?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  

Online price retrieval.png
Description: Binary data


Result retrieving quotes.png
Description: Binary data
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help with setting up stock price updates

[david amaral via gnucash-user]

 cpanm Finance::Quotego to gnucash\binperl gnc-fq-update
might have to uninstall finance quote if problemscpanm --uninstall 
Finance::Quote


On Wednesday, April 17, 2024 at 03:10:48 PM GMT-7, Anna Scott 
 wrote:  
 
 Hello all … I’m advancing beyond basics for the first time and am stuck trying 
to create a new security in pricing editor - under “Quote Source Information” 
it gives error message that “Warning: Finance: Quote not installed properly”.  

I’ve seen other references to this as a bug … but don’t know if it’s been 
resolved?  I’m using GNUCASH 5.3 on a MAC with Sonoma 14.0 .

Id appreciate any and all help!  Thanks in advance,

A


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quotes Yahoo off the rails again?

[david amaral via gnucash-user]

 Thank you.Installed on windows 11 Gnucash 5.6 flawlesly in an admin comand 
window issued the command and all went without any errors.

On Sunday, April 14, 2024 at 08:45:09 AM GMT-7, Bruce Schuck 
 wrote:  
 
 On 4/13/24 20:08:20 -0700, Bruce S wrote:

> There is some miscellaneous housekeeping and cleanup that needs to be
> done before pushing a final release to CPAN. Plus I had some other
> changes that I was planning for v1.60 but haven't done yet. Instead of
> v1.60, I may upload v1.59_01 tomorrow so people can at least fetch the
> fix for YahooJSON before v1.60 is uploaded and indexed by CPAN.

Pre-release F::Q v1.59_01 has been uploaded to CPAN.

To install using cpan or cpanm you must specify the path.

cpan> install BPSCHUCK/Finance-Quote-1.59_01.tar.gz

Bruce S.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] I'm looking at installing GnuCash but has a couple of questions first

[david amaral via gnucash-user]

 For anyone wanting to access gnucash or any app on a windows systemlook at 
teamviewer. lets you set up computer and laptops to access all your aps remotely
On Monday, April 8, 2024 at 10:05:34 PM GMT-7, Robert Dew  
wrote:  
 
 I have a a number of small, separate, but interconnected companies that I'd 
like to 
have separate accounting systems for.

Does GnuCash allow for multiple businesses, or would I need to install a 
separate 
version for each business

It's a little unclear if GnuCash operates, or can be made to operate, via a 
remote 
web browser. I see references to using X-windows which would be an acceptable 
option, web/browser based would be my preference.

Is there any restrictions on the self hosted version. 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quotes Yahoo off the rails again?

[david amaral via gnucash-user]

 I have been on gnucash for years now and have close to 300 securities that i 
get updates from yahoo.no problems as to yahoo limits
On Thursday, April 4, 2024 at 10:03:26 AM GMT-7, David G. Pickett via 
gnucash-user  wrote:  
 
  My personal portfolio has 26-28 stocks (I recently closed 2 positions) 
(Diversity has it's virtues, and while IRSs are free choice, different 401Ks 
have different restricted choices.)  When it is in a mood to block, it seems to 
block them all, not just the last few.
    On Wednesday, April 3, 2024 at 10:53:03 PM EDT, Bruce Schuck 
 wrote:  
 
 Wed Apr 3 13:40:48 EDT 2024 David G. Pickett wrote:

> Looks good, (only error because I need to switch DIA back to yahoo) 
> and slow but much better.  A later run under cron got lots of
> errors. Do they ration by IP address? If it is by frequency, maybe we
> should purposely send requests only every 10 seconds to simulate a
> human user?  It cannot make it much slower.
I've been meaning to ask how many securities are you attempting to get 
prices for?

Early on in this thread I called out the "500" responses. A "500" 
typically gets returned from a web page if the site has an issue. When 
Yahoo turned off the previous APIs F::Q was using, the HTTP response was 
one of the "40?" that would be expected.

With no one else reporting the same issue my sense is that your errors 
are the result of something on your end. I also use YahooJSON, and a 
cron job fired every weekday at 13:30 Pacific time (16:30 Eastern) 
updates about 20 securities in less than 15 seconds. My log from today's 
(04/03/2024) run:

=
gnc-get-quote.sh start: Wed Apr  3 01:30:01 PM PDT 2024
DATAFILE: /home/bschuck/Documents/bschuck.gnucash
BKUPFILE: /home/bschuck/Documents/bschuck.gnucash.20240403133001.gnucash
Found Finance::Quote version 1.59.
gz_thread_func EOF
gnc-get-quote.sh completed: Wed Apr  3 01:30:13 PM PDT 2024
=

I would not be surprised if you have a sufficiently large number of 
securities that Yahoo has mechanisms in place to detect and block/limit 
further lookups.

Bruce S.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Problem install Finance::Quote

[david amaral via gnucash-user]

If you are onWindows platform, I sugguest you download  perl for windows.
https://strawberryperl.com/
It may resolve all your problems as it is compatible dow windows.
It is what I have and there are no issues with gnucash






On Monday, February 19, 2024 at 11:12:06 AM GMT-7, Kalpesh Patel 
 wrote: 





I am on Windows platform but most likely one of two issues likely on the
Perl front as it seems to be universal across platform:

Since you forced installed LWP::Protocol::https module, it skipped install
of one or more under lying dependent modules so it is broken at its heart
even though physically it is present. IMHO, if Perl is configured correctly
then there is hardly need to force install modules other than in extremely
few rare cases. This also means your CPAN module for Perl is not likely to
be configured correctly to retrieve dependent modules and install them as
necessary. 

-- OR --

Your GNC install is looking at Perl that is entirely located in a different
location and it isn't finding all the required modules there.

Former is likely to issue. Also may I ask how you came to conclusion that
installing OpenSSL via brew package manager will be sufficient on Mac to get
F::Q up and running? You may want to review documentation at
https://finance-quote.sourceforge.net/index.html to become familiar. 

While commands you listed might work, I like to use following (not sure how
they will behave on your system at this point though) after Perl CPAN module
is properly configured:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Test2'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Finance::Quote'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install JSON::Parse'

If things are broken in the process of install then fix them; don't skip
them!

As for Perl's CPAN module, normally if the CPAN's 'prerequisites_policy'
setting (configured with 'follow' option), 'build_requires_install_policy'
setting (with 'yes') and 'make' settings (with fully qualified path to a
make that is found by search or compatible one) are properly set then that
should have installed all pre-requisite dependencies automatically. These
are the sane defaults that gets configures with when CPAN module is
initialized. In case there is interest for the CPAN module configuration
settings, refer to https://metacpan.org/pod/CPAN#Config-Variables link.

Perl sadly does not have a way to uninstall a module on its own. The
unofficial way to do is to delete (safer to rename!?!?) the module's Perl
files and then attempt to install it again.

- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.
- Rename 'Finance' directory under .../lib/perl5/... subtree (with perhaps
.bak extension).
- Rerun the installer as mentioned above using modified commands.

With the current state of it, YMMV though.

-Original Message-
From: Gustavo Taouil  
Sent: Friday, February 16, 2024 5:34 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Problem install Finance::Quote

Hi Guys, I tried to install Finance::Quote in my new mac (M3) with Sonoma
macOs. I Use these lines of command to install:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Test2
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
Finance::Quote
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
JSON::Parse

Now, I was receiving theses kind of messages when I tried to update quotes:


* B3:IVVB11.SA Finance::Quote reported failure with error: 501 Protocol
scheme 'https' is not supported (LWP::Protocol::https not installed)


I already force the install of LWP::Protocol::https and I installed the
opensll with the command: brew install openssl, but it's not working.

My perl is installed in /usr/bin/perl and my version is 5.30.3

anyone can help me?






___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Maddening!!!!!!!!

[david amaral via gnucash-user]

 Verify your windows OSopen cmd window as adminTypedism /Online /Cleanup-Image 
/RestoreHealthFollowed bysfc /scannow
check for bugs with free Norton NPEDownload and run Norton Power Eraser - Free 
virus and malware removal tool for Windows

On Thursday, January 11, 2024 at 02:43:08 PM GMT-7, Mark at Lorimark 
 wrote:  
 
 Going out on a limb...

These folks have a free virus scanner;

> https://www.eset.com/us/home/online-scanner/

Based on how you described the symptom, I'd start to be a little curious 
about that copy of Windows.

~w:http://www.lorimarksolutions.com

On 1/11/24 15:29, Joseph Keithley wrote:
> I have had similar issues.  My only "solution" was to hit the "Save" 
> button after any action or entry.  Gnucash can then crash as it always 
> does and I will only have lost at most one transaction.  I have the 
> autosave feature enabled for every 5 minutes.  The constant crashing 
> seems to be related to my Windows 10 installation.  Windows will 
> initiate some background process which I notice becuase the mouse pauses 
> for a microsecond and the screen will briefly flash as if a messsage box 
> were trying to pop up but it goes away so quickly I can't really figure 
> out what is going on.  Once this happens, if Gnucash is open I can bet 
> on a crash in short order.  There will be no notification, Gnucash just 
> quits and any unsaved work is lost.  If I reboot Wndows then Gnucash 
> doesn't crash until the next time Windows has its little hiccup.  The 
> hiccup happens at most once a month but it is still irritating to lose 
> my work.  The hiccup doesn't seem to bother any other running programs 
> to include Quicken 2016, Excel, and Comodo A/V and Firewall.
> 
> 
> 
> On Thu, Jan 11, 2024 at 3:33 PM Mark at Lorimark 
> mailto:m...@lorimarksolutions.com>> wrote:
> 
>    You can post an image as an attachment to your email, it will be
>    available to the group here.
> 
>    ~w:http://www.lorimarksolutions.com 
> 
>    On 1/11/24 13:00, Jack Slater wrote:
>      > Is there a way I post the image?
>      >
>      >
>    ___
>    gnucash-user mailing list
>    gnucash-user@gnucash.org 
>    To update your subscription preferences or to unsubscribe:
>    https://lists.gnucash.org/mailman/listinfo/gnucash-user
>    
>    -
>    Please remember to CC this list on all your replies.
>    You can do this by using Reply-To-List or Reply-All.
> 
> 
> 
> -- 
> iii
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Online Banking

[david amaral via gnucash-user]

I am attemting to set up online banking to Fidelity and not having much luck. I 
keep getting error of "bad request"  Have no idea as to why,
AqBanking v6.5.4.0stableSending jobs to the bank(s)Sorting commands by 
accountSorting account queues by providerSend commands to providersSend 
commands to provider "aqofxconnect"Locking customer "7"Sending 
request...Connecting to server...Resolving hostname "ofx.fidelity.com" ...IP 
address is "23.209.84.151"Connecting to "ofx.fidelity.com"Connected to 
"ofx.fidelity.com"Connected.Sending message...Message sent.Waiting for 
response...Receiving response...HTTP-Status: 400 (Bad Request)Unlocking 
customer "7"
Any help would be greatly appreciated

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Investment Accounts

[david amaral via gnucash-user]

I am in need of help with a new investment account I created. Everything seems 
right except the totals.I created an account under investments named 
brokerage.Under brokerage I created a sub account named spaxxI entered 
transactions and the account spaxx has the correct total displayed.the 
brokerage account is 0the asset account has a value that is almost correct but 
missing the value of the spaxx account.
My retirement account is correct in all values and I set up the brokerage 
account using the retirement account values for the account setup. ( I used 
edit account to verify set up)
Any Ideas as to why the total values are incorrect? 
Thanks in advance.
___
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

[david amaral via gnucash-user]

Verify security editor for your investments have get quotes checked and 
AlphaVantage  listed as source for each entry.

  From: David T. via gnucash-user 
 To: Gnucash Users  
 Sent: Tuesday, January 23, 2018 10:07 AM
 Subject: Price Retrieval Failure
   
Hello,

I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior 
setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the 
Alphavantage key, added the same key to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed 
all my stocks to use other:alphavantage, and I was able to retrieve quotes.

Upon upgrade, I find I am no longer able to retrieve AlphaVantage quotes. F::Q 
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 alphavantage AAPL
Finance::Quote fields Gnucash uses:
    symbol: AAPL                <=== required
      date: 01/23/2018          <=== recommended
  currency: USD                  <=== required
      last: 178.6400            <=\      
      nav:                      <=== one of these
    price:                      <=/        
  timezone:                      <=== optional

I have restored the following two lines into the aforementioned lines to 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment:

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

Unfortunately, I am getting the dreaded "There was an unknown error while 
retrieving the price quotes.”

I welcome any reminders on what I have missed, or how to debug this further.

TIA,
David T.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

   
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Gnucash freezes while loading data

[david amaral via gnucash-user]

site is csvconverter.biz
it is an online converter.

  From: david amaral via gnucash-user <gnucash-user@gnucash.org>
 To: jeffrey black <beastmaster...@hotmail.com>; David T. 
<sunfis...@yahoo.com>; Paul Konnersman <konners...@gmail.com> 
Cc: Gnucash Users <gnucash-user@gnucash.org>
 Sent: Sunday, January 21, 2018 10:23 AM
 Subject: Re: Gnucash freezes while loading data
   
Here is a free converter you might want to try for your csv file.
 CSV Converter


  
|  
|  
|  
|  |    |

  |

  |
|  
|  |  
CSV Converter
 Free online CSV converter. Save your bank/institution statement as QIF or OFX 
to then import into your accountin...  |  |

  |

  |

 
      From: jeffrey black <beastmaster...@hotmail.com>
 To: David T. <sunfis...@yahoo.com>; Paul Konnersman <konners...@gmail.com> 
Cc: Gnucash Users <gnucash-user@gnucash.org>
 Sent: Sunday, January 21, 2018 9:41 AM
 Subject: Re: Gnucash freezes while loading data
  
On 1/21/2018 8:50 AM, David T. via gnucash-user wrote:
> Those don’t sound like large files, so it sounds like there might be 
> something wrong. Do they ALL hang, or only some of them?
>
> I will admit that I am not one to advise on importing, as I don’t do it much. 
> That being said, I would take a close look at the source files—especially the 
> date fields, as GnuCash can be somewhat finicky around variably-formed dates.
>
> David T.
>
>> On Jan 21, 2018, at 6:59 PM, Paul Konnersman <konners...@gmail.com> wrote:
>>
>> Thank you for the suggestions David T.
>>
>> Each of the files that I have been trying to import contains three weeks of 
>> transactions from one bank account. They are all between 1kb and 3kb.
>>
>> Paul
>>
>> On Sun, Jan 21, 2018 at 1:15 AM, David T. <sunfis...@yahoo.com 
>> <mailto:sunfis...@yahoo.com>> wrote:
>> Moreover, any import process can take a long time to complete (with no 
>> indication of progress). If you are importing a large csv file (as you might 
>> be doing if you are migrating in to GnuCash), it can be especially time 
>> consuming. Five or ten minutes is not unheard of.
>>
>> Try again and wait it out, as David C. suggests.
>>
>> If it really gets hung up, you would be well-advised to break the import up 
>> into smaller portions, thus reducing the time to process any given subset, 
>> and also increasing the likelihood of finding any erroneous data that might 
>> be causing a glitch. Heck, you may want to do this anyway.
>>
>> David T.
>>
>>> On Jan 21, 2018, at 4:45 AM, David Carlson <david.carlson@gmail.com 
>>> <mailto:david.carlson@gmail.com>> wrote:
>>>
>>> Not sure how you know it is 'frozen' after such a short time.  GnuCash does
>>> not have any 'activity' indicator. Try giving it several minutes.
>>>
>>> David C
>>>
>>> On Sat, Jan 20, 2018 at 4:19 PM, Paul Konnersman <konners...@gmail.com 
>>> <mailto:konners...@gmail.com>>
>>> wrote:
>>>
>>>> I have just made the decision to use Gnucash. So far I have successfully
>>>> imported my chart of accounts from a csv-file and attempted to import a
>>>> csv-file of transaction data. After 20-30 seconds of the transaction import
>>>> Gnucash freezes and I have to force quit. Any suggestions will be
>>>> appreciated.
>>>>
>>>> Paul
>>>> Running Gnucash 2.6.19 with OSX High Sierra on a Macbook Pro
>>>> --
>>>> *Paul M. Konnersman*
>>>> *konners...@gmail.com <mailto:konners...@gmail.com> <konners...@gmail.com 
>>>> <mailto:konners...@gmail.com>>*
>>>> *781-639-0616 *
>>>> ___
>>>> gnucash-user mailing list
>>>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>>> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>>> -
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Re

Re: Gnucash freezes while loading data

[david amaral via gnucash-user]

Here is a free converter you might want to try for your csv file.
 CSV Converter


  
|  
|   
|   
|   ||

   |

  |
|  
|   |  
CSV Converter
 Free online CSV converter. Save your bank/institution statement as QIF or OFX 
to then import into your accountin...  |   |

  |

  |

 
  From: jeffrey black 
 To: David T. ; Paul Konnersman  
Cc: Gnucash Users 
 Sent: Sunday, January 21, 2018 9:41 AM
 Subject: Re: Gnucash freezes while loading data
   
On 1/21/2018 8:50 AM, David T. via gnucash-user wrote:
> Those don’t sound like large files, so it sounds like there might be 
> something wrong. Do they ALL hang, or only some of them?
>
> I will admit that I am not one to advise on importing, as I don’t do it much. 
> That being said, I would take a close look at the source files—especially the 
> date fields, as GnuCash can be somewhat finicky around variably-formed dates.
>
> David T.
>
>> On Jan 21, 2018, at 6:59 PM, Paul Konnersman  wrote:
>>
>> Thank you for the suggestions David T.
>>
>> Each of the files that I have been trying to import contains three weeks of 
>> transactions from one bank account. They are all between 1kb and 3kb.
>>
>> Paul
>>
>> On Sun, Jan 21, 2018 at 1:15 AM, David T. > > wrote:
>> Moreover, any import process can take a long time to complete (with no 
>> indication of progress). If you are importing a large csv file (as you might 
>> be doing if you are migrating in to GnuCash), it can be especially time 
>> consuming. Five or ten minutes is not unheard of.
>>
>> Try again and wait it out, as David C. suggests.
>>
>> If it really gets hung up, you would be well-advised to break the import up 
>> into smaller portions, thus reducing the time to process any given subset, 
>> and also increasing the likelihood of finding any erroneous data that might 
>> be causing a glitch. Heck, you may want to do this anyway.
>>
>> David T.
>>
>>> On Jan 21, 2018, at 4:45 AM, David Carlson >> > wrote:
>>>
>>> Not sure how you know it is 'frozen' after such a short time.  GnuCash does
>>> not have any 'activity' indicator. Try giving it several minutes.
>>>
>>> David C
>>>
>>> On Sat, Jan 20, 2018 at 4:19 PM, Paul Konnersman >> >
>>> wrote:
>>>
 I have just made the decision to use Gnucash. So far I have successfully
 imported my chart of accounts from a csv-file and attempted to import a
 csv-file of transaction data. After 20-30 seconds of the transaction import
 Gnucash freezes and I have to force quit. Any suggestions will be
 appreciated.

 Paul
 Running Gnucash 2.6.19 with OSX High Sierra on a Macbook Pro
 --
 *Paul M. Konnersman*
 *konners...@gmail.com  >*
 *781-639-0616 *
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org 
 https://lists.gnucash.org/mailman/listinfo/gnucash-user 
 
 -
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.

>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org 
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> 
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>>
>> -- 
>> Paul M. Konnersman
>> konners...@gmail.com 
>> 781-639-0616
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

Paul:

I can not speak for the OS you are running, GnuCash may look a little 
different.  As will your Quicken program.  I am still running Windoze.

My version (2014), of quicken, will not export to .csv, only .qif and 
.qfx.  I would recommend exporting to .qif instead.  The qif exported 
file will allow for multiple split transactions, I do not know about the 
csv export.  If I remember correctly I exported all of my quicken data 
in one shot and imported it.

Sometimes GnuCash has to "chew" on an import for a while.  I frequently 
get a message in the top title bar that Gnucash is "not responding".  
Wait a few minutes and see if it finishes.  I gave up on .csv imports 
because I could never assign the right fields. All I use is 

Re: Help finding Account Register

[david amaral via gnucash-user]

In your home directory should be a gnucash directory with backups. you can open 
on older file. also select "file" as you would close gnucash and see if there 
is a backup there.

  From: Dave Orsinger 
 To: gnucash-user@gnucash.org 
 Sent: Thursday, December 21, 2017 6:30 PM
 Subject: Help finding Account Register
   
I inadvertently "x 'd" out of my Account (checking) Register and can't 
figure out a way to get it back. I've gone through a lot of the 
documentation but haven't found anything that addresses my issue. Can 
somebody out there give me some love and "support"?
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


   
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

gnucash not updating mutual funds

[david amaral via gnucash-user]

gnucash was working fine and now has stopped updating my investments in mutual 
funds.i am getting the error message:there was an unknown errorwhile receiving 
the price quote
These are the version numbers i am working with.Ubuntu 16.04 LTSGnucash 
2.6.12Perl5 v5.22.1

I have looked thru some posts and tried different things.
gnc-fq-dump nyse FCNTXno results found for FCNTX
gnc-fq-dump alphavantage FCNTXFinance::Quote fields Gnucash uses:         
symbol: FCNTX (deduced)  <===required             date:  ** missing **       
currency: ** missing **        etcAs I stated earlier it was working fine and 
now has stopped. any help with this would be greatly appreciated. 
I run quicken on my windows machine and gnucash on ubuntu. i am thinking of 
going to moneydance for both machines if i cant get this fixed.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.