Re: How to assign transaction to accounts automatically.

[jeffrey black]

On 2/20/2018 10:03 AM, Edward Bridges wrote:
> If you downloaded the transactions in QIF format, you may find this tool 
> interesting:
>
> https://github.com/Kraymer/qifqif
>
> I have used for about a year now and it's really effective at categorizing 
> transactions to the correct account before importing.
>
>
> On Tue, Feb 20, 2018, at 10:09 AM, John Ralls wrote:
>>
>>> On Feb 20, 2018, at 4:39 AM, Hans Deragon  wrote:
>>>
>>> Greetings,
>>>
>>> New user here.  I downloaded 500 transactions from my credit card bank
>>> site, all assigned to 'Imbalanced-CAD'.  Now, how can I set rules to
>>> automatically assign transactions to a specific account?  For instance,
>>> any transaction with "^ESSO.*" or "^SHELL.*" must be reassigned to
>>> Car:Gasoline.  I fail to find that information on the web, except that
>>> when importing, GnuCash trains itself and does that automatically at the
>>> next import.
>>>
>>> But what about my 500 transactions that are already imported?  What
>>> about if one wants to reassign transactions to another account, after a
>>> month of careful thinking?  Does a user have to go through all
>>> transactions manually?
>>>
>>> As a workaround, is it possible to convert the GnuCash file into Unicode
>>> and use scripting languages to manipulate the transactions, then convert
>>> it back to its binary format?
>>>
>>> Using GnuCash 2.6.12 on Ubuntu 16.04 LTS.
>> No, GnuCash does not train itself: You have to train it. You do that by
>> assigning the transactions to accounts during import. That’s what that
>> dialog with all of the yellow was about. Your best course of action is
>> to go to the backup from before the import and start over.
>>
>> Otherwise, yes, the only way to change transactions is one-at-a-time.
>> You can speed it up a bit using the Edit>Find to select a group of
>> transactions that you want to change to a particular. You’ll get a
>> editable register and you can just go down the list changing each
>> transfer account.
>>
>> 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.
> ___
> 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.

Hans:

I assume you are using the OFX/QFX importer.  As Derek recommends you have a 
choice of either reverting your data back to before the import and then 
correctly assign the transactions (preferably with a small number of 
transactions at a time) or manually reassign all 500 and then proceed to 
retrain the importer for all future transactions. If you revert back to a 
previous backup, you will also have to re-enter all transactions entered after 
that import.

Derek could probably write a Python script in his sleep to do the corrections, 
if he ever sleeps.  Personally I don't think that he ever does sleep (:-))!! 
His up-time is longer than the servers.  So that is not an option.

Also personally, I have grown tired of the downloads I get from my financial 
institutions, all "YELLING" at me with payee names that are not human friendly 
when I forget to enter a transaction first.  I have been bludgeoning a Perl 
script to make the downloaded OFX/QFX files more friendly.  IE. "^SHELL.*" will 
be replaced with "Shell Gas".  If you have just a few names to change, you can 
easily use a search & replace with a good text editor or awk/sed on all future 
downloaded OFX/QFX files, and QIF for that matter.  It will bypass what the 
Bayesian logic has already learned. Doesn't solve your current 500 transactions 
problem I know but; will make your books more readable if you neglect to enter 
a transaction in the future.

Just my 2 U.S. cents worth.

--JEffrey Black M.B.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
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: Language change mystery

[David Carlson]

Roger,

Do you have your data file in a user documents folder or sub-folder with
full read and write privileges?  Windows Defender should not be interfering
with access to your data file.  If that new Controlled Folder Access
feature is that fussy...

David C

On Tue, Feb 20, 2018 at 9:07 PM, John Ralls  wrote:

>
>
> > On Feb 20, 2018, at 12:14 PM, rmom...@gmail.com wrote:
> >
> > Thanks Derek,
> >
> > I changed the OS language back to English and restarted the computer,
> > several times. This did not change the language back to English.
> >
> > Windows Defender Controlled Folder Access blocked GnuCash from making
> > changes to the data file. At first, it even blocked adding a new
> > transaction. I turned off the controlled folder access feature.
> >
> > I read the instructions at the link. The version of GnuCash I have
> installed
> > is 2.6.18. I tried to follow the instructions to edit the environment
> file
> > at c:\\Program Files\gnucash\etc\gnucash. But I don't have an editor for
> > that type of file or an option to open it as administrator. So, I'm not
> sure
> > what to do with that.
> >
> > Might it work to uninstall and reinstall the program? Does the uninstall
> > remove the data files? I have a backup, just a matter of making sure it
> is
> > up to date.
> >
>
> You do have an editor: Notepad. It comes with Windows. Just click the
> Start menu and then type the name to find it. Once it’s visible in the menu
> bar, right-click on it and select “run as administrator” to get the
> privilege escalation to edit environment.
>
> 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.
>
___
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: Stock Spin-Out

[nvsoar]

On 02/20/18 11:35, Les wrote:
There is a stock-split function in GC.  However it doesn't appear to 
do spin-outs.  In my case, the company doing the spin-out is doing a 5 
to 1 and there are no fractional shares. I just assigned the cost at 
0.00 per share.


Les


On 02/20/2018 01:27 PM, David Carlson wrote:

Les,

Usually a stock spin-off splits the before spin-off cost basis 
between the after spin-off stocks according to documents provided by 
the parent corporation to the SEC and shareholders which also explain 
how details such as fractional shares and various expenses are to be 
treated.


The worksheet that nvsoar provided the link to helps with calculating 
details.


I thought that there was also a stock split assistant built into 
GnuCash to construct the transactions. Check the help or tutorial 
manual s for that.


David C




On Feb 20, 2018 9:57 AM, "Les" > wrote:


    Thanks for both replies.  I used a zero price and the number of
    shares with a description.  (John's procedure)  But I was not sure
    if the procedure I used was correct (best).

    Regards,

    Les
Comment:  It seems to me that a zero cost for the spun off shares is 
incorrect if a non-zero basis exists for the pre-spin off shares.  A 
zero cost for the new shares will result in a higher than necessary 
capital gain when those shares are sold.  The easiest way to determine 
the new basis for each of the remaining entities that I have found is to 
use the cost basis calculator at the link previously provided.

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

Closing Book causes Imbalance????

[replicon]

Hello,

I was closing the book for 2017, and noticed it created an Imbalance account
instead of putting things in the equity account I've selected.

Is this a new bug in GNUCash?

* Tools -> Close Book
* Closing Date: 2017-12-31
* Income Total: Equity:Book Closing Transactions
* Expense Total: Equity:Book Closing Transactions
* Description: Closing book for 2017


Result:

* The 'income' transaction works fine
* The 'expense' transaction puts NOTHING into the equity account, and
instead, dumps it all into 'Imbalance-USD'. The equity account does show up
when I look at the splits, but there's nothing entered.

This is a pretty simple UI, so it's not really possible to do it wrong.
What's going on? Are there cases where this is expected behavior? (note: I
didn't have any imbalance before this)

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: Language change mystery

[John Ralls]

> On Feb 20, 2018, at 12:14 PM, rmom...@gmail.com wrote:
> 
> Thanks Derek,
> 
> I changed the OS language back to English and restarted the computer,
> several times. This did not change the language back to English. 
> 
> Windows Defender Controlled Folder Access blocked GnuCash from making
> changes to the data file. At first, it even blocked adding a new
> transaction. I turned off the controlled folder access feature.
> 
> I read the instructions at the link. The version of GnuCash I have installed
> is 2.6.18. I tried to follow the instructions to edit the environment file
> at c:\\Program Files\gnucash\etc\gnucash. But I don't have an editor for
> that type of file or an option to open it as administrator. So, I'm not sure
> what to do with that.
> 
> Might it work to uninstall and reinstall the program? Does the uninstall
> remove the data files? I have a backup, just a matter of making sure it is
> up to date.
> 

You do have an editor: Notepad. It comes with Windows. Just click the Start 
menu and then type the name to find it. Once it’s visible in the menu bar, 
right-click on it and select “run as administrator” to get the privilege 
escalation to edit environment.

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: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Adrien Monteleone]

In order to use SQL on the Gnucash data, it needs to be saved in that format. 
This requires the particular backend drivers (sqlite3, MySQL) be installed 
already for the format to be available as a choice in the Save As dialog. See 
the installation notes on the wiki for more info.

There is no built-in facility for writing queries. You’d have to access the 
datafile from something else.

You may be interested in PieCash which allows for accessing either the XML or 
SQL formatted data file for report writing. https://github.com/sdementen/piecash

This was also posted to the mailing list recently and is an example of using 
PieCash: https://github.com/ebridges/accounting-reports

Before you get started, you’ll want to look over this: 
https://wiki.gnucash.org/wiki/FAQ#SQL_Database, and 
https://wiki.gnucash.org/wiki/SQL and mind the warnings never to WRITE to the 
data file from outside of Gnucash. (at least for the foreseeable future)

Here’s the SQL table map - yes, it’s ugly: 
https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png

Unless you are comfortable with Scheme, or learning a new language, your best 
bet is definitely to stick with the SQL/PieCash route.


Regards,
Adrien

> On Feb 20, 2018, at 4:59 PM, Fran_3  wrote:
> 
> Thanks Adrien,
> 
> Regarding custom reports... I do SQL but am having gnuCash save account files 
> in it's default XML format.
> 
> Where would I get a list of the tables in gnuCash and their associated 
> fields/columns?
> 
> Is there a window I can open to just put in an SQL query or what?
> 
> Can I create an SQL query that will query the default XML format file format?
> 
> (I've actually never considered using XML for a full fledged database until I 
> just started using gnuCash and discovered that it uses XML)
> 
> Or do I have all of this wrong?
> 
> thanks again.
> 
> 
> 
> On Tuesday, February 20, 2018, 5:14:38 PM EST, Adrien Monteleone 
>  wrote:
> 
> 
> You could leverage a multi-column report perhaps with a customer report in 
> each column, that will get you invoice & payment detail, but no aggregate 
> totals across all customers. (but each customer would have it’s own total)
> 
> Then there is the P/Income Statement, but it will show you revenue by type 
> (account) not by customer. It will have a total however.
> 
> Finally, there is the Customer Report. The Sales column will show what you 
> want. Though you may not need the other columns, the only one you can turn 
> off is the expense column. I’ve yet to figure out where to put costs or 
> markup figures for that report to make much sense. It will report a sales 
> total per customer with a grand total.
> 
> If you want to see revenue by type AND customer with totals, you’ll have to 
> make your own report either with SQL or Scheme.
> 
> All of these reports (as are any others in GnuCash) allow you to set either 
> the date of the report, (such as for a Balance Sheet) or the date range the 
> report covers. There are shortcut date selectors for month, quarter, year and 
> ‘accounting period’ (if your fiscal year differs from the calendar) as well 
> as boxes to let you put in any specific dates you want. You’ll find that 
> under the General tab of any report options.
> 
> 
> Regards,
> Adrien
> 
> > On Feb 20, 2018, at 3:41 PM, Fran_3 via gnucash-user 
> >  wrote:
> > 
> > I'm sure there is a way but I haven't found it yet...
> > How do we run a report to see how much business we booked/invoiced for a 
> > particular month?Total and/or including a list of customers and amounts?
> > Ditto for  a specified period of time... current quarter, last quarter, so 
> > far this year... so far this date last year... etc?
> > Thanks for any help.
> > Fran 3
> 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please 

Re: Date changes

[Stan Brown]

On 2018-02-19 09:22, parakr...@theacetechnologies.com wrote:

> I downloaded Gnucash on 17th and tried to record transactions from
> last year. However I found that the system does not show any date
> before YESTERDAY, 17TH February 2018.
> 
> My requirement is to record transaction from July 2017 and update
> upto now
> 
> Can someone tell me how to record backdated transactions and use it?
Hi. New user here, but I'll jump in.

I'm not sure what you mean by "does not show any date before". When you
enter transactions, you ENTER a date. Sure, it shows you a date by
default, but don't have to use that. Just highlight the date shown, and
enter 2017-07-15 or whatever (in your date format).

There's a nice shortcut. In Edit » Preferences, on the Date/Tie tab,
select the last radio button, "in a sliding 12-month window" and select
8 for "this many months before the current month." Then you can enter a
date as 7-15 (for example, but use your format) and it will supply 2017
because the "window" runs from 8 months before now to 4 months after now.

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.com>
>  
> 
>  
> 
> Parakrama Weerasinghe
> 
> ___
> 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: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Fran_3 via gnucash-user]

 Thanks Adrien,

Regarding custom reports... I do SQL but am having gnuCash save account files 
in it's default XML format.
Where would I get a list of the tables in gnuCash and their associated 
fields/columns?
Is there a window I can open to just put in an SQL query or what?
Can I create an SQL query that will query the default XML format file format?
(I've actually never considered using XML for a full fledged database until I 
just started using gnuCash and discovered that it uses XML)
Or do I have all of this wrong?
thanks again.


On Tuesday, February 20, 2018, 5:14:38 PM EST, Adrien Monteleone 
 wrote:  
 
 You could leverage a multi-column report perhaps with a customer report in 
each column, that will get you invoice & payment detail, but no aggregate 
totals across all customers. (but each customer would have it’s own total)

Then there is the P/Income Statement, but it will show you revenue by type 
(account) not by customer. It will have a total however.

Finally, there is the Customer Report. The Sales column will show what you 
want. Though you may not need the other columns, the only one you can turn off 
is the expense column. I’ve yet to figure out where to put costs or markup 
figures for that report to make much sense. It will report a sales total per 
customer with a grand total.

If you want to see revenue by type AND customer with totals, you’ll have to 
make your own report either with SQL or Scheme.

All of these reports (as are any others in GnuCash) allow you to set either the 
date of the report, (such as for a Balance Sheet) or the date range the report 
covers. There are shortcut date selectors for month, quarter, year and 
‘accounting period’ (if your fiscal year differs from the calendar) as well as 
boxes to let you put in any specific dates you want. You’ll find that under the 
General tab of any report options.


Regards,
Adrien

> On Feb 20, 2018, at 3:41 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> I'm sure there is a way but I haven't found it yet...
> How do we run a report to see how much business we booked/invoiced for a 
> particular month?Total and/or including a list of customers and amounts?
> Ditto for  a specified period of time... current quarter, last quarter, so 
> far this year... so far this date last year... etc?
> Thanks for any help.
> Fran 3
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Autocompletion problem

[Sebastian Di Mateo]

Hello, everyone.
I'm on 2.6.18 running on Fedora 27. I'm experiencing the same problem as
described here:
https://lists.gnucash.org/pipermail/gnucash-user/2011-July/040365.html
Autocompletion of account names tends to assume I want to pick the first
option that is highlighted, usually when typing fast. The message I link to
said the problem was reported and intended to be solved sometimes on 2.4
versions but I'm still experiencing it.
Any clues?
-- 

_
Seba/Rosario/Mobile
___
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: Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Adrien Monteleone]

You could leverage a multi-column report perhaps with a customer report in each 
column, that will get you invoice & payment detail, but no aggregate totals 
across all customers. (but each customer would have it’s own total)

Then there is the P/Income Statement, but it will show you revenue by type 
(account) not by customer. It will have a total however.

Finally, there is the Customer Report. The Sales column will show what you 
want. Though you may not need the other columns, the only one you can turn off 
is the expense column. I’ve yet to figure out where to put costs or markup 
figures for that report to make much sense. It will report a sales total per 
customer with a grand total.

If you want to see revenue by type AND customer with totals, you’ll have to 
make your own report either with SQL or Scheme.

All of these reports (as are any others in GnuCash) allow you to set either the 
date of the report, (such as for a Balance Sheet) or the date range the report 
covers. There are shortcut date selectors for month, quarter, year and 
‘accounting period’ (if your fiscal year differs from the calendar) as well as 
boxes to let you put in any specific dates you want. You’ll find that under the 
General tab of any report options.


Regards,
Adrien

> On Feb 20, 2018, at 3:41 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> I'm sure there is a way but I haven't found it yet...
> How do we run a report to see how much business we booked/invoiced for a 
> particular month?Total and/or including a list of customers and amounts?
> Ditto for  a specified period of time... current quarter, last quarter, so 
> far this year... so far this date last year... etc?
> Thanks for any help.
> Fran 3
> ___
> 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.

Monthly Billings Report ? (How much business did we book/Invoice during month X)

[Fran_3 via gnucash-user]

I'm sure there is a way but I haven't found it yet...
How do we run a report to see how much business we booked/invoiced for a 
particular month?Total and/or including a list of customers and amounts?
Ditto for  a specified period of time... current quarter, last quarter, so far 
this year... so far this date last year... etc?
Thanks for any help.
Fran 3
___
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: importing splits

[Matt Graham]

The easiest way would be saving  the spreadsheet to .csv format and importing 
that to Gnucash.

Id recommend:
- first removing any other text and stuff you have so that the spreadsheet is 
just the headings you want and the data you want in columns
- doing the import on a new test gnucash file first if you have a lot of data 
already in your gnucash book. Just in case.

Good luck!

Thanks and regards,
Matt


 Original message 
From: Jeff Abrahamson 
Date: 21/2/18 05:00 (GMT+10:00)
To: gnucash-user@gnucash.org
Subject: importing splits

I'm processing check deposits.  I have a spreadsheet with lovely columns
like name, check number, amount, and the account to debit.  It seems a
shame to retype it all.

I see some old discussion on the list that, essentially, says this is
not well supported if supported at all.


https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D=0

Is there anything since that might help?  I'm not sure converting
spreadsheets to QIF to then import into gnucash is better than retyping.

--

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fp27.eu%2Fjeff%2F=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D=0

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D=0
If you are using Nabble or Gmane, please see 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D=0
 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: Language change mystery

[rmomxtx]

Thanks Derek,

I changed the OS language back to English and restarted the computer,
several times. This did not change the language back to English. 

Windows Defender Controlled Folder Access blocked GnuCash from making
changes to the data file. At first, it even blocked adding a new
transaction. I turned off the controlled folder access feature.

I read the instructions at the link. The version of GnuCash I have installed
is 2.6.18. I tried to follow the instructions to edit the environment file
at c:\\Program Files\gnucash\etc\gnucash. But I don't have an editor for
that type of file or an option to open it as administrator. So, I'm not sure
what to do with that.

Might it work to uninstall and reinstall the program? Does the uninstall
remove the data files? I have a backup, just a matter of making sure it is
up to date.

Thanks much,
Roger

-Original Message-
From: Derek Atkins [mailto:warl...@mit.edu] 
Sent: martes, 20 de febrero de 2018 10:00 a. m.
To: Roger Oliver 
Cc: Gnucash 
Subject: Re: Language change mystery

Hi,

Roger Oliver  writes:

> I live in Mexico so when my tech works on my computer he changes the 
> operating language of Windows to Spanish. Somehow that changed the 
> language of GnuCash and I can't seem to get it to change back. The 
> names of the accounts are the names I gave them in English but all the 
> menus and tabs are in Spanish. It even changed the primary currency to the
Mexican peso.

GnuCash uses the system locale to choose its display/menu language.
You will need to change the OS language back to English -- or you will need
to specifically reconfigured GnuCash to run in English.  See
https://wiki.gnucash.org/wiki/Locale

> It may have something to do with Windows Defender. For some reason it 
> blocked GnuCash from making changes to the file. It was treating 
> GnuCash as a virus. I think we fixed that.

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

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available

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

Re: Date changes

[Greg Feneis]

Paul,

I replied with a solution, I'm not searching for anything.

You may want to address Parakrama,






Kind regards,

Greg Feneis



On Tue, Feb 20, 2018 at 11:30 AM, Paul Konnersman 
wrote:

> Greg,
>
> I think that you will find what you're looking for here:
>
> MenuBar> File> Accounts> "Day Threshold to Read-Only Transactions (red
> line)
>
> If you enter zero in that box all transactions will be available in
> Read/Write,
> If you enter the numeral "n" in that box all transactions will be
> available in Read/Write for the last "n" days, but read only if the
> transaction date is more than "n" in the past.
>
> Paul
>
> On Tue, Feb 20, 2018 at 2:34 AM, Greg Feneis  wrote:
>
>> There is a setting that might prevent you from seeing older transactions
>> once you've entered them.
>>
>> When you have a register open, use the View menu
>>
>> View > Filter by > Show all
>>
>> If it was set to a date range that excludes an old transaction date, it
>> would be possible for a newly entered old transaction to seem to
>> disappear.
>>
>>
>>
>>
>>
>> Kind regards,
>>
>> Greg Feneis
>>
>>
>>
>> On Mon, Feb 19, 2018 at 7:12 PM, David Carlson <
>> david.carlson@gmail.com>
>> wrote:
>>
>> > Start by reading the Tutorial and the Help Manual.  Once you have
>> created a
>> > chart of accounts you just open the register for whichever account you
>> want
>> > to enter a transaction into, type any date into the date box and go from
>> > there.
>> >
>> > David C
>> >
>> > On Mon, Feb 19, 2018 at 8:22 AM, 
>> wrote:
>> >
>> > > Hello Team,
>> > >
>> > >
>> > >
>> > > I downloaded Gnucash on 17th and tried to record transactions from
>> last
>> > > year. However I found that the system does not show any date before
>> > > YESTERDAY, 17TH February 2018.
>> > >
>> > >
>> > >
>> > > My requirement is to record transaction from July 2017 and update upto
>> > now
>> > > and use it then
>> > >
>> > >
>> > >
>> > > Can someone tell me how to record backdated transactions and use it?
>> > >
>> > >
>> > >
>> > >
>> > >
>> > > Parakrama Weerasinghe
>> > >
>> > > ___
>> > > gnucash-user mailing list
>> > > gnucash-user@gnucash.org
>> > > To update your subscription preferences or to unsubscribe:
>> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > > If you are using Nabble or Gmane, please see
>> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> > > -
>> > > Please remember to CC this list on all your replies.
>> > > You can do this by using Reply-To-List or Reply-All.
>> > >
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > If you are using Nabble or Gmane, please see
>> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
>
> --
> *Paul M. Konnersman*
> *konners...@gmail.com *
> *781-639-0616 <(781)%20639-0616>*
>
___
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: Stock Spin-Out

[Les]

There is a stock-split function in GC.  However it doesn't appear to do 
spin-outs.  In my case, the company doing the spin-out is doing a 5 to 1 
and there are no fractional shares. I just assigned the cost at 0.00 per 
share.


Les


On 02/20/2018 01:27 PM, David Carlson wrote:

Les,

Usually a stock spin-off splits the before spin-off cost basis between 
the after spin-off stocks according to documents provided by the 
parent corporation to the SEC and shareholders which also explain how 
details such as fractional shares and various expenses are to be treated.


The worksheet that nvsoar provided the link to helps with calculating 
details.


I thought that there was also a stock split assistant built into 
GnuCash to construct the transactions. Check the help or tutorial 
manual s for that.


David C




On Feb 20, 2018 9:57 AM, "Les" > wrote:


Thanks for both replies.  I used a zero price and the number of
shares with a description.  (John's procedure)  But I was not sure
if the procedure I used was correct (best).

Regards,

Les



On 02/19/2018 05:47 PM, nvsoar wrote:

On 02/19/18 15:25, John Coppock wrote:

This is what I have been doing.  I am new to Gnu Cash.

I'm using Gnu Cash v.2.6.17 on Windows 10 in US dollars.

In 'Tools/Security Editor', create the new spin-off security.

In your brokerage account, create a new sub-account for
the new spin-off security. Its Account Type will be stock
(do this first), currency will be shares of the security
you just created. If you don't see it show up after you
created it, go to 'View/Filter by/Other' to show accounts
with zero totals,

In the new sub-account (tab between fields), enter the
date of the spin-off, a description, on the next line
choose 'Buy' for 'Action', enter the shares received in
'Shares', delete the value in 'Price', enter the basis of
the shares received in 'Buy', on the next line enter the
name of the parent Stock account, enter 0 for 'Shares',
delete the value in 'Price', verify the value in 'Buy' is
the same as the basis entered before, hit enter and you're
done.

I've found this seems to handle the basis change for both
stocks.



On 2/19/2018 1:37 PM, Les wrote:

I recently had a stock that owned a significant part
of a rather new company and decided to spin it out at
a 5 to 1 rate.  Can someone please explain how to do
this in GC?

Thanks,


Les

FWIW - Here is a resource for dealing with spin-off basis
transactions -
http://www.costbasistools.com/spinoff/calculator.php

nvsoar
___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
 for more
information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




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

Re: aqbanking / ofx downloads to wrong account and can't straighten out

[Derek Atkins]

The mapping is done inside the account structure.
The best way to handle this is to create a fake OFX import with a bogus
account # -- then map that bogus account number to the account you want to
reset (the one that is currently bound to your real OFX account #).
Then, the next time you import the correct OFX account # it should ask you
to map it again.

-derek

On Tue, February 20, 2018 11:10 am, Bill Starrs wrote:
> Hello all,
>
> Still no dice.  I do have 4/5 accounts working properly, and used to
> have 5/5 until the fateful day I mis-assigned the one that received a
> new credit card number.
>
> The setup screen clearly shows that my aqbanking account is associated
> to the correct Gnucash account.  And that relationship holds up front
> when I perform a transaction download from that account in the GUI.  But
> once it pulls the transactions down, it still dumps them in the other
> account.
>
> I would think this has to be some kind of bug where there is a hidden
> setting that is set once and forgotten by the wizard for existing
> accounts?  Can anybody tell me where in the config files I can find
> these relationships?
>
> Thanks,
>
> Bill
>
>
> On Sun, Feb 18, 2018 at 02:20:26AM -0600, David Carlson wrote:
>>I think I found the WIKI page covering this.  It looks like just about
>> what
>>John remembers, but perhaps there is a subtle difference:
>>https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings.
>>
>>David C
>>
>>On Sat, Feb 17, 2018 at 10:17 PM, Bill Starrs 
>> wrote:
>>
>>> Hi John,
>>>
>>> Thanks for your response. I followed this and have the same situation.
>>> The transactions and balance are correct for the account that I update
>>> from, but the transactions still go to the other account, as well as
>>> the
>>> reconciliation window opens for the other account.
>>>
>>> Still scratching my head.  There has to be a way to manually fix it.
>>>
>>> Thanks,
>>>
>>> Bill
>>>
>>>
>>>
>>> On Fri, Feb 16, 2018 at 02:05:02PM -0800, John Ralls wrote:
>>>


 On Feb 16, 2018, at 12:08 PM, Bill Starrs 
 wrote:
>
> Hello,
>
> A few months ago I had to change a credit card # due to fraud and
> reconfigure it through aqbanking.  When I did this, I accidentally
> associated it with the wrong credit card account in gnucash.
>
> After re-configuring it again, and again, and again, in the wizard, I
> now have a situation where when I am sitting in the proper account
> and
> download transactions, I get the preview of the charges for that
> card,
> however in the "Account" column of the download reconciliation
> dialog,
> it shows the other, mistaken account.  When I accept the
> transactions,
> they are placed into that other account.  I then have to manually
> change
> them to put them in the right account.  Account balancing also does
> not
> work as it opens the balance dialog of the incorrect account.
>
> I gave up on fixing with the ui and started looking through the
> .gnucash
> and .aqbanking directories as well as the mariadb gnucash database to
> manually fix this setting but have given up here too.
>
>
 I haven't had to do this in a while, but IIRC you run the Online
 Banking
 Setup assistant, start and close the AQBanking wizard, and click
 "forward"
 on the GnuCash assistant. The next screen is a list of your AQBanking
 accounts. Double-click the one that you want to change and you'll get
 a
 Select Account dialog from which you can pick the new account. Once
 you
 have done that, the account name will appear in the middle column and
 the
 "New?" box will be checked. Click "Forward" and the "Apply".

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


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___

Re: aqbanking / ofx downloads to wrong account and can't straighten out

[Bill Starrs]

Hello all,

Still no dice.  I do have 4/5 accounts working properly, and used to
have 5/5 until the fateful day I mis-assigned the one that received a
new credit card number.

The setup screen clearly shows that my aqbanking account is associated
to the correct Gnucash account.  And that relationship holds up front
when I perform a transaction download from that account in the GUI.  But
once it pulls the transactions down, it still dumps them in the other
account.

I would think this has to be some kind of bug where there is a hidden
setting that is set once and forgotten by the wizard for existing
accounts?  Can anybody tell me where in the config files I can find
these relationships?

Thanks,

Bill


On Sun, Feb 18, 2018 at 02:20:26AM -0600, David Carlson wrote:

I think I found the WIKI page covering this.  It looks like just about what
John remembers, but perhaps there is a subtle difference:
https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings.

David C

On Sat, Feb 17, 2018 at 10:17 PM, Bill Starrs  wrote:


Hi John,

Thanks for your response. I followed this and have the same situation.
The transactions and balance are correct for the account that I update
from, but the transactions still go to the other account, as well as the
reconciliation window opens for the other account.

Still scratching my head.  There has to be a way to manually fix it.

Thanks,

Bill



On Fri, Feb 16, 2018 at 02:05:02PM -0800, John Ralls wrote:




On Feb 16, 2018, at 12:08 PM, Bill Starrs  wrote:


Hello,

A few months ago I had to change a credit card # due to fraud and
reconfigure it through aqbanking.  When I did this, I accidentally
associated it with the wrong credit card account in gnucash.

After re-configuring it again, and again, and again, in the wizard, I
now have a situation where when I am sitting in the proper account and
download transactions, I get the preview of the charges for that card,
however in the "Account" column of the download reconciliation dialog,
it shows the other, mistaken account.  When I accept the transactions,
they are placed into that other account.  I then have to manually change
them to put them in the right account.  Account balancing also does not
work as it opens the balance dialog of the incorrect account.

I gave up on fixing with the ui and started looking through the .gnucash
and .aqbanking directories as well as the mariadb gnucash database to
manually fix this setting but have given up here too.



I haven't had to do this in a while, but IIRC you run the Online Banking
Setup assistant, start and close the AQBanking wizard, and click "forward"
on the GnuCash assistant. The next screen is a list of your AQBanking
accounts. Double-click the one that you want to change and you'll get a
Select Account dialog from which you can pick the new account. Once you
have done that, the account name will appear in the middle column and the
"New?" box will be checked. Click "Forward" and the "Apply".

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.


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

Re: How to assign transaction to accounts automatically.

[Edward Bridges]

If you downloaded the transactions in QIF format, you may find this tool 
interesting:

https://github.com/Kraymer/qifqif

I have used for about a year now and it's really effective at categorizing 
transactions to the correct account before importing.


On Tue, Feb 20, 2018, at 10:09 AM, John Ralls wrote:
> 
> 
> > On Feb 20, 2018, at 4:39 AM, Hans Deragon  wrote:
> > 
> > Greetings,
> > 
> > New user here.  I downloaded 500 transactions from my credit card bank
> > site, all assigned to 'Imbalanced-CAD'.  Now, how can I set rules to
> > automatically assign transactions to a specific account?  For instance,
> > any transaction with "^ESSO.*" or "^SHELL.*" must be reassigned to
> > Car:Gasoline.  I fail to find that information on the web, except that
> > when importing, GnuCash trains itself and does that automatically at the
> > next import.
> > 
> > But what about my 500 transactions that are already imported?  What
> > about if one wants to reassign transactions to another account, after a
> > month of careful thinking?  Does a user have to go through all
> > transactions manually?
> > 
> > As a workaround, is it possible to convert the GnuCash file into Unicode
> > and use scripting languages to manipulate the transactions, then convert
> > it back to its binary format?
> > 
> > Using GnuCash 2.6.12 on Ubuntu 16.04 LTS.
> 
> No, GnuCash does not train itself: You have to train it. You do that by 
> assigning the transactions to accounts during import. That’s what that 
> dialog with all of the yellow was about. Your best course of action is 
> to go to the backup from before the import and start over.
> 
> Otherwise, yes, the only way to change transactions is one-at-a-time. 
> You can speed it up a bit using the Edit>Find to select a group of 
> transactions that you want to change to a particular. You’ll get a 
> editable register and you can just go down the list changing each 
> transfer account.
> 
> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to assign transaction to accounts automatically.

[Derek Atkins]

Hi,

Hans Deragon  writes:

> Greetings,
>
> New user here.  I downloaded 500 transactions from my credit card bank
> site, all assigned to 'Imbalanced-CAD'.  Now, how can I set rules to
> automatically assign transactions to a specific account?  For instance,
> any transaction with "^ESSO.*" or "^SHELL.*" must be reassigned to
> Car:Gasoline.  I fail to find that information on the web, except that
> when importing, GnuCash trains itself and does that automatically at the
> next import.

There are no rule-based modifications.  It's all about training.

> But what about my 500 transactions that are already imported?  What
> about if one wants to reassign transactions to another account, after a
> month of careful thinking?  Does a user have to go through all
> transactions manually?

Yes, you will.   Or you can "restart" -- revert back to before the
import, and then assign the imports correctly the "first" time.

> As a workaround, is it possible to convert the GnuCash file into Unicode
> and use scripting languages to manipulate the transactions, then convert
> it back to its binary format?

No.  But you could use the Python bindings to write a script against the
GnuCash API and manipulate them that way.

> Using GnuCash 2.6.12 on Ubuntu 16.04 LTS.
>
> Best regards,
> Hans Deragon

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

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Language change mystery

[Derek Atkins]

Hi,

Roger Oliver  writes:

> I live in Mexico so when my tech works on my computer he changes the
> operating language of Windows to Spanish. Somehow that changed the language
> of GnuCash and I can't seem to get it to change back. The names of the
> accounts are the names I gave them in English but all the menus and tabs
> are in Spanish. It even changed the primary currency to the Mexican peso.

GnuCash uses the system locale to choose its display/menu language.
You will need to change the OS language back to English -- or you will
need to specifically reconfigured GnuCash to run in English.  See
https://wiki.gnucash.org/wiki/Locale

> It may have something to do with Windows Defender. For some reason it
> blocked GnuCash from making changes to the file. It was treating GnuCash as
> a virus. I think we fixed that.

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

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Stock Spin-Out

[Les]

Thanks for both replies.  I used a zero price and the number of shares 
with a description.  (John's procedure)  But I was not sure if the 
procedure I used was correct (best).


Regards,

Les


On 02/19/2018 05:47 PM, nvsoar wrote:

On 02/19/18 15:25, John Coppock wrote:

This is what I have been doing.  I am new to Gnu Cash.

I'm using Gnu Cash v.2.6.17 on Windows 10 in US dollars.

In 'Tools/Security Editor', create the new spin-off security.

In your brokerage account, create a new sub-account for the new 
spin-off security. Its Account Type will be stock (do this first), 
currency will be shares of the security you just created. If you 
don't see it show up after you created it, go to 'View/Filter 
by/Other' to show accounts with zero totals,


In the new sub-account (tab between fields), enter the date of the 
spin-off, a description, on the next line choose 'Buy' for 'Action', 
enter the shares received in 'Shares', delete the value in 'Price', 
enter the basis of the shares received in 'Buy', on the next line 
enter the name of the parent Stock account, enter 0 for 'Shares', 
delete the value in 'Price', verify the value in 'Buy' is the same as 
the basis entered before, hit enter and you're done.


I've found this seems to handle the basis change for both stocks.



On 2/19/2018 1:37 PM, Les wrote:
I recently had a stock that owned a significant part of a rather new 
company and decided to spin it out at a 5 to 1 rate.  Can someone 
please explain how to do this in GC?


Thanks,


Les
FWIW - Here is a resource for dealing with spin-off basis transactions 
- http://www.costbasistools.com/spinoff/calculator.php

nvsoar
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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


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

Re: How to assign transaction to accounts automatically.

[John Ralls]

> On Feb 20, 2018, at 4:39 AM, Hans Deragon  wrote:
> 
> Greetings,
> 
> New user here.  I downloaded 500 transactions from my credit card bank
> site, all assigned to 'Imbalanced-CAD'.  Now, how can I set rules to
> automatically assign transactions to a specific account?  For instance,
> any transaction with "^ESSO.*" or "^SHELL.*" must be reassigned to
> Car:Gasoline.  I fail to find that information on the web, except that
> when importing, GnuCash trains itself and does that automatically at the
> next import.
> 
> But what about my 500 transactions that are already imported?  What
> about if one wants to reassign transactions to another account, after a
> month of careful thinking?  Does a user have to go through all
> transactions manually?
> 
> As a workaround, is it possible to convert the GnuCash file into Unicode
> and use scripting languages to manipulate the transactions, then convert
> it back to its binary format?
> 
> Using GnuCash 2.6.12 on Ubuntu 16.04 LTS.

No, GnuCash does not train itself: You have to train it. You do that by 
assigning the transactions to accounts during import. That’s what that dialog 
with all of the yellow was about. Your best course of action is to go to the 
backup from before the import and start over.

Otherwise, yes, the only way to change transactions is one-at-a-time. You can 
speed it up a bit using the Edit>Find to select a group of transactions that 
you want to change to a particular. You’ll get a editable register and you can 
just go down the list changing each transfer account.

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: How to assign transaction to accounts automatically.

[Roger Miskowicz]

Excellent question!

On Tue, Feb 20, 2018 at 7:39 AM, Hans Deragon  wrote:

> Greetings,
>
> New user here.  I downloaded 500 transactions from my credit card bank
> site, all assigned to 'Imbalanced-CAD'.  Now, how can I set rules to
> automatically assign transactions to a specific account?  For instance,
> any transaction with "^ESSO.*" or "^SHELL.*" must be reassigned to
> Car:Gasoline.  I fail to find that information on the web, except that
> when importing, GnuCash trains itself and does that automatically at the
> next import.
>
> But what about my 500 transactions that are already imported?  What
> about if one wants to reassign transactions to another account, after a
> month of careful thinking?  Does a user have to go through all
> transactions manually?
>
> As a workaround, is it possible to convert the GnuCash file into Unicode
> and use scripting languages to manipulate the transactions, then convert
> it back to its binary format?
>
> Using GnuCash 2.6.12 on Ubuntu 16.04 LTS.
>
> Best regards,
> Hans Deragon
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

How to assign transaction to accounts automatically.

[Hans Deragon]

Greetings,

New user here.  I downloaded 500 transactions from my credit card bank
site, all assigned to 'Imbalanced-CAD'.  Now, how can I set rules to
automatically assign transactions to a specific account?  For instance,
any transaction with "^ESSO.*" or "^SHELL.*" must be reassigned to
Car:Gasoline.  I fail to find that information on the web, except that
when importing, GnuCash trains itself and does that automatically at the
next import.

But what about my 500 transactions that are already imported?  What
about if one wants to reassign transactions to another account, after a
month of careful thinking?  Does a user have to go through all
transactions manually?

As a workaround, is it possible to convert the GnuCash file into Unicode
and use scripting languages to manipulate the transactions, then convert
it back to its binary format?

Using GnuCash 2.6.12 on Ubuntu 16.04 LTS.

Best regards,
Hans Deragon



signature.asc
Description: OpenPGP digital signature
___
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: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Adriano Baldi]

Hello

Maybe I found something 

https://www.alpha-vantage.community/post/unable-to-get-the-response-when-using-currencyexchangerate-api-9654331

we are not alone...

Best regards

Adriano

2018-02-20 12:47 GMT+01:00 Adriano Baldi :

> Hello Richard
>
> After doing countless tests I think that the problem is related to the
> management of the demands of Alphavantage.
> But I can not figure out where we are wrong.
> These are the declared performances:
>
> *>> What is the expected server-side performance (e.g., throughput time)
> for the API service?*
>
> *>> Based on the latest instrumentation, the throughput time for our API
> endpoint is under 500 milliseconds per request at 25% to 75% percentile. *
>
> *>> While we are proud to provide free API service with no
> daily/weekly/monthly call limits, we recommend that API call frequency does
> not extend far beyond ~1 call per second *
>
> *>> so that we can continue to deliver the optimal server-side
> performance.*
>
> So I tried to put a delay between one request and another of 1 or more
> seconds, with no result.
> In addition I tried to ensure that for each request was used a different
> key, randomly chosen among 10 keys, even here without result.
>
> I need new idea to test.
>
> Best regards
>
> Adriano
>
>
> 2018-02-20 9:28 GMT+01:00 Richard Morris :
>
>> I have this problem too (starting yesterday). I was going to do a post -
>> then, late in the day, the problem went away! But now it's back again.
>>
>> I wonder if this is a connectivity issue with whatever GNUCash uses for
>> currency sources? (This is hard-wired I think, and I'm not sure what that
>> is).
>>
>> I'm on Ubuntu too: GnuCash 2.6.17 + Ubuntu 17.10 + Finance::Quote 1.47
>>
>>
>> On Tue, Feb 20, 2018 at 6:09 AM, Adriano Baldi 
>> wrote:
>>
>>> Hello
>>>
>>> I apologize for my poor English.
>>>
>>> I use GnuCash since 2011 and usually I am able to solve this kind of
>>> problem by myself if necessary modifing the perl files of Finance::Quote.
>>> But now I'm going crazy with this problem.
>>>
>>> I've got this error since february 14 on two different PC with Ubuntu
>>> 14.04
>>> and 16.04 with GnuCash 2.6.12 and Finance::Quote 1.47.
>>>
>>> Unable to retrieve quotes for these items:
>>>   CURRENCY:XAU
>>>   CURRENCY:XPT
>>>   CURRENCY:XAG
>>>   CURRENCY:NZD
>>>   CURRENCY:CAD
>>>   CURRENCY:AUD
>>>   CURRENCY:CHF
>>>   CURRENCY:CNY
>>>   CURRENCY:RUB
>>>   CURRENCY:DKK
>>>   CURRENCY:NOK
>>>   CURRENCY:GBP
>>>   CURRENCY:USD
>>>   CURRENCY:JPY
>>> Continue using only the good quotes?
>>>
>>> If I try from the consolle Finance::Quote work fine
>>>
>>> $ gnc-fq-dump currency USD EUR
>>> 1 USD = 0.805969 EUR
>>>
>>> $ gnc-fq-dump currency XAU EUR
>>> 1 XAU = 1085.3924262 EUR
>>>
>>> $ 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")
>>>
>>> I don't know if this problem afflict only me (I hope so) or if others
>>> have
>>> the same problem.
>>> The problem afflicts only the currency with continuity, on some stocks I
>>> can have the problem occasionally, but generally a second download work
>>> fine.
>>> I retreive more of 40 stocks from 6 excange with no problem using
>>> Alphavantage.
>>> Does anyone have an idea from what can be determined?
>>> Does anyone have a suggestion to give me to solve this problem?
>>> Thanks in advance to anyone who can help me.
>>>
>>> Best regards
>>>
>>> Adriano
>>> ___
>>> 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: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Adriano Baldi]

Hello Richard

After doing countless tests I think that the problem is related to the
management of the demands of Alphavantage.
But I can not figure out where we are wrong.
These are the declared performances:

*>> What is the expected server-side performance (e.g., throughput time)
for the API service?*

*>> Based on the latest instrumentation, the throughput time for our API
endpoint is under 500 milliseconds per request at 25% to 75% percentile. *

*>> While we are proud to provide free API service with no
daily/weekly/monthly call limits, we recommend that API call frequency does
not extend far beyond ~1 call per second *

*>> so that we can continue to deliver the optimal server-side performance.*

So I tried to put a delay between one request and another of 1 or more
seconds, with no result.
In addition I tried to ensure that for each request was used a different
key, randomly chosen among 10 keys, even here without result.

I need new idea to test.

Best regards

Adriano


2018-02-20 9:28 GMT+01:00 Richard Morris :

> I have this problem too (starting yesterday). I was going to do a post -
> then, late in the day, the problem went away! But now it's back again.
>
> I wonder if this is a connectivity issue with whatever GNUCash uses for
> currency sources? (This is hard-wired I think, and I'm not sure what that
> is).
>
> I'm on Ubuntu too: GnuCash 2.6.17 + Ubuntu 17.10 + Finance::Quote 1.47
>
>
> On Tue, Feb 20, 2018 at 6:09 AM, Adriano Baldi 
> wrote:
>
>> Hello
>>
>> I apologize for my poor English.
>>
>> I use GnuCash since 2011 and usually I am able to solve this kind of
>> problem by myself if necessary modifing the perl files of Finance::Quote.
>> But now I'm going crazy with this problem.
>>
>> I've got this error since february 14 on two different PC with Ubuntu
>> 14.04
>> and 16.04 with GnuCash 2.6.12 and Finance::Quote 1.47.
>>
>> Unable to retrieve quotes for these items:
>>   CURRENCY:XAU
>>   CURRENCY:XPT
>>   CURRENCY:XAG
>>   CURRENCY:NZD
>>   CURRENCY:CAD
>>   CURRENCY:AUD
>>   CURRENCY:CHF
>>   CURRENCY:CNY
>>   CURRENCY:RUB
>>   CURRENCY:DKK
>>   CURRENCY:NOK
>>   CURRENCY:GBP
>>   CURRENCY:USD
>>   CURRENCY:JPY
>> Continue using only the good quotes?
>>
>> If I try from the consolle Finance::Quote work fine
>>
>> $ gnc-fq-dump currency USD EUR
>> 1 USD = 0.805969 EUR
>>
>> $ gnc-fq-dump currency XAU EUR
>> 1 XAU = 1085.3924262 EUR
>>
>> $ 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")
>>
>> I don't know if this problem afflict only me (I hope so) or if others have
>> the same problem.
>> The problem afflicts only the currency with continuity, on some stocks I
>> can have the problem occasionally, but generally a second download work
>> fine.
>> I retreive more of 40 stocks from 6 excange with no problem using
>> Alphavantage.
>> Does anyone have an idea from what can be determined?
>> Does anyone have a suggestion to give me to solve this problem?
>> Thanks in advance to anyone who can help me.
>>
>> Best regards
>>
>> Adriano
>> ___
>> 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 

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Richard Morris via gnucash-user]

I have this problem too (starting yesterday). I was going to do a post -
then, late in the day, the problem went away! But now it's back again.

I wonder if this is a connectivity issue with whatever GNUCash uses for
currency sources? (This is hard-wired I think, and I'm not sure what that
is).

I'm on Ubuntu too: GnuCash 2.6.17 + Ubuntu 17.10 + Finance::Quote 1.47


On Tue, Feb 20, 2018 at 6:09 AM, Adriano Baldi 
wrote:

> Hello
>
> I apologize for my poor English.
>
> I use GnuCash since 2011 and usually I am able to solve this kind of
> problem by myself if necessary modifing the perl files of Finance::Quote.
> But now I'm going crazy with this problem.
>
> I've got this error since february 14 on two different PC with Ubuntu 14.04
> and 16.04 with GnuCash 2.6.12 and Finance::Quote 1.47.
>
> Unable to retrieve quotes for these items:
>   CURRENCY:XAU
>   CURRENCY:XPT
>   CURRENCY:XAG
>   CURRENCY:NZD
>   CURRENCY:CAD
>   CURRENCY:AUD
>   CURRENCY:CHF
>   CURRENCY:CNY
>   CURRENCY:RUB
>   CURRENCY:DKK
>   CURRENCY:NOK
>   CURRENCY:GBP
>   CURRENCY:USD
>   CURRENCY:JPY
> Continue using only the good quotes?
>
> If I try from the consolle Finance::Quote work fine
>
> $ gnc-fq-dump currency USD EUR
> 1 USD = 0.805969 EUR
>
> $ gnc-fq-dump currency XAU EUR
> 1 XAU = 1085.3924262 EUR
>
> $ 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")
>
> I don't know if this problem afflict only me (I hope so) or if others have
> the same problem.
> The problem afflicts only the currency with continuity, on some stocks I
> can have the problem occasionally, but generally a second download work
> fine.
> I retreive more of 40 stocks from 6 excange with no problem using
> Alphavantage.
> Does anyone have an idea from what can be determined?
> Does anyone have a suggestion to give me to solve this problem?
> Thanks in advance to anyone who can help me.
>
> Best regards
>
> Adriano
> ___
> 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.