[GNC] Bonus share entry
Hi all, I have some bonus shares that were issued with no cost to me: I am having trouble entering them without a cost. When I put 0 as the cost, on the next line 1 appears, and I am unable to get rid of it. Perhaps I'm doing this the wrong way, and need to be entering them as a share split? In this case, I had 100 shares, and got issued 16 for no cost: so I have 116 in total. Any ideas? Thanks, Xboxboy ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
Chris, That's a bad idea. It messes up the lots as you note, it screws up the acquisition dates (important for tax purposes in the US), and ultimately it's not what happened. Since it is possible to add zero cost shares using tab (instead of enter), there is no reason to use this approach. You certainly don't *have* to use it. David On March 7, 2019, at 2:29 AM, Chris Good wrote: Message: 6 > Date: Wed, 6 Mar 2019 22:00:16 +1030 > From: Gnucash Xboxboy Mageia > To: Derek Atkins > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Fwd: Bonus share entry > Message-ID: > > Content-Type: text/plain; charset="utf-8" > >> On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: >> >> The cost may be zero, but the value is not. >> Maybe just enter them as 0.01? >> >> -derek >> Sent using my mobile device. Please excuse any typos. >> On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia >> wrote: >> >>> Hi all, >>> I have some bonus shares that were issued with no cost to me: >>> >>> I am having trouble entering them without a cost. When I put 0 as the >> cost, >>> on the next line 1 appears, and I am unable to get rid of it. >>> >>> Perhaps I'm doing this the wrong way, and need to be entering them as a >>> share split? >>> >>> In this case, I had 100 shares, and got issued 16 for no cost: so I have >>> 116 in total. >>> >>> Any ideas? >>> >>> Thanks, >>> Xboxboy >>> ___ >>> 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. > Hi Derek, > > I've attached a picture, I don't think I'm explaining very well. > > Please see attached. > > What can I do about that imbalance line? > Many thanks, > Xboxboy > -- next part -- > A non-text attachment was scrubbed... > Name: Screenshot_20190306_215426.png > Type: image/png > Size: 34424 bytes > Desc: not available > URL: > <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190306/8a2c7c73/attachment.png> > Hi XBoxBoy, If the tax authorities have agreed that you are getting these bonus shares for zero cost, then to keep the cost correct in GnuCash you will have to do a dummy sell of all your existing shares at cost, and then in another transaction, buy them, including the bonus qty, at the same cost. Assuming this is for your personal accounting, it probably doesn't matter which account you use for the other side in each transaction - you could probably use either a bank account (and if you reconcile that bank account, flag the transactions as reconciled even though they never appear on a bank statement) or an Equity:Opening Balances account - you should check with your accountant. Doing this will mean manually keeping track of lots bought and sold when determining costs of future sales. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Splitting a multi-year file
Il 03/03/19 20:29, Christian Kluge ha scritto: I’d suggest making balance sheets for each year to exported. Afterwards I would use File\Export\Transactions to CSV. There I would select the appropriate time range. I also would export the account structure to CSV. In the one-year-only file I would import the account structure and make entries for the opening balances. Lastly I would import the transactions from the CSV files. Christian, thanks for the detailed explanation. So far, these are the problems I had: 1) the account selection is a bit of a chore. I have a chart of accounts which is fairly extensive for a private person (111 accounts) and I cannot select the top-level accounts and have all subaccounts included, apparently: when I do that, the top-level accounts are selected plus the second level accounts of the last top level I clicked. If I start manually exploding all parts of the account tree and then hitting ctrl-a, then I get an increasing number of selected accounts, meaning that "select subaccounts" does not work on currently selected accounts, just on the last one. Is that to be expected? 2) importing the CSV for the accounts shows an empty preview and I cannot move past this screen. If I check the file, it looks like a regular CSV to me and I haven't changed the export defaults. Also, I have tried adjusting the number of header lines but no luck. Maybe I have to use "export accounts" instead of "export account tree to csv"? 3) during import, I need to select "gnucash export settings" first, then I have to match each account from the CSV to the corresponding account in the tree. There is no default mapping, which is weird considering the accounts obviously have the same names since they come from the same source. Is that normal? Thanks, Andrea. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL
On Wed, 6 Mar 2019 at 21:44, Keith Bellairs wrote: > > Yes I can connect using the mysql command line tool. No, the gnucash db has > not been created. > > But I cannot use the mysqlworkbench shell. It complains about a missing > connector (python?) > > Also, gnc get the "bad data" error even if I try to "save as" with a bad > password, no password, or no user id. So it doesn't look like it is really > hitting the db at all. The fact that there is nothing in the trace file suggests that too I think. I assume you looked at the trace file immediately after the error, it is cleared each time gnucash is run. You could try running gnucash itself from the command line and see if it says anything in the terminal, assuming you can do that on a Mac. Otherwise I am out of ideas. Colin ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL
Yes I can connect using the mysql command line tool. No, the gnucash db has not been created. But I cannot use the mysqlworkbench shell. It complains about a missing connector (python?) Also, gnc get the "bad data" error even if I try to "save as" with a bad password, no password, or no user id. So it doesn't look like it is really hitting the db at all. Keith On Wed, Mar 6, 2019 at 3:28 PM Colin Law wrote: > On Wed, 6 Mar 2019 at 19:09, Keith Bellairs wrote: > > > > gnucash.trace is empty. > > > > Of some interest, I did a Save As to sqlite and it worked. So the xml > data is acceptable to that DB. > > > > XML -> sqlite OK > > XML -> mysql NG > > sqlite -> mysql NG > > > > I tried to do a Save As from the sqlite db to MySQL. That Save As ground > away for a few minutes and then threw the same bad data error. So I am > guessing that I have a problem with my mysql server. But of course the > error log for mysql is clean. > > > > There may be some mysql magic I am missing. Since I don't live there I > may not push on it much longer. > > Can you connect to the database using the command line utility with > that user/pwd you specified? > Has it created the database when you look from the command line? > > Colin > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
Message: 6 > Date: Wed, 6 Mar 2019 22:00:16 +1030 > From: Gnucash Xboxboy Mageia > To: Derek Atkins > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Fwd: Bonus share entry > Message-ID: > > Content-Type: text/plain; charset="utf-8" > >> On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: >> >> The cost may be zero, but the value is not. >> Maybe just enter them as 0.01? >> >> -derek >> Sent using my mobile device. Please excuse any typos. >> On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia >> wrote: >> >>> Hi all, >>> I have some bonus shares that were issued with no cost to me: >>> >>> I am having trouble entering them without a cost. When I put 0 as the >> cost, >>> on the next line 1 appears, and I am unable to get rid of it. >>> >>> Perhaps I'm doing this the wrong way, and need to be entering them as a >>> share split? >>> >>> In this case, I had 100 shares, and got issued 16 for no cost: so I have >>> 116 in total. >>> >>> Any ideas? >>> >>> Thanks, >>> Xboxboy >>> ___ >>> 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. > Hi Derek, > > I've attached a picture, I don't think I'm explaining very well. > > Please see attached. > > What can I do about that imbalance line? > Many thanks, > Xboxboy > -- next part -- > A non-text attachment was scrubbed... > Name: Screenshot_20190306_215426.png > Type: image/png > Size: 34424 bytes > Desc: not available > URL: > <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190306/8a2c7c73/attachment.png> > Hi XBoxBoy, If the tax authorities have agreed that you are getting these bonus shares for zero cost, then to keep the cost correct in GnuCash you will have to do a dummy sell of all your existing shares at cost, and then in another transaction, buy them, including the bonus qty, at the same cost. Assuming this is for your personal accounting, it probably doesn't matter which account you use for the other side in each transaction - you could probably use either a bank account (and if you reconcile that bank account, flag the transactions as reconciled even though they never appear on a bank statement) or an Equity:Opening Balances account - you should check with your accountant. Doing this will mean manually keeping track of lots bought and sold when determining costs of future sales. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL
On Wed, 6 Mar 2019 at 19:09, Keith Bellairs wrote: > > gnucash.trace is empty. > > Of some interest, I did a Save As to sqlite and it worked. So the xml data is > acceptable to that DB. > > XML -> sqlite OK > XML -> mysql NG > sqlite -> mysql NG > > I tried to do a Save As from the sqlite db to MySQL. That Save As ground away > for a few minutes and then threw the same bad data error. So I am guessing > that I have a problem with my mysql server. But of course the error log for > mysql is clean. > > There may be some mysql magic I am missing. Since I don't live there I may > not push on it much longer. Can you connect to the database using the command line utility with that user/pwd you specified? Has it created the database when you look from the command line? Colin ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash 3.4 help needed
I am no expert but try putting an absolute path to the source directory in place of ../gnucash-3.4 Dale On 3/6/19 2:00 PM, devlin wrote: > Running Linux Mint 18.3 Cinnamon on this box, and need some help - > > Playing with Gnucash 3.4, and from the page at > > > [URL="http://https://wiki.gnucash.org/wiki/Building_On_Linux"]https://wiki.gnucash.org/wiki/Building_On_Linux[/URL] > > > I'm confused by these instructions and commands: > > Open a shell and change directory to the directory into which you > extracted the GnuCash sources (gnucash-3.4) or cloned the github > repository (gnucash), i.e. the parent directory of gnucash-3.4 or gnucash. > > Build using Cmake and Make > > mkdir build-gnucash-3.4 # create the build directory - Note: Named to > identify the source since it is not within the source directory. > cd build-gnucash-3.4 # change into the build directory > cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local > -DCMAKE_PREFIX_PATH=$HOME/.local ../gnucash-3.4 # As shown this will > install in the .local directory in /home/. > make # builds the program and associated libraries > make install # prefix with sudo if you do install to /usr/local or /opt > as admin privileges are required. > > Cuz that gets an error that confuses me even more: > > [CODE]@MainBox /mnt/sdb4/Applications/gnucash-3.4/build-gnucash-3.4 $ > cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local > -DCMAKE_PREFIX_PATH=$HOME/.local ../gnucash-3.4 > CMake Error: The source directory > "/mnt/sdb4/Applications/gnucash-3.4/gnucash-3.4" does not exist. > Specify --help for usage, or press the help button on the CMake GUI.[CODE] > > It says there's supposed to be another directory level called "gnucash-3.4" > If I create that"missing" directory, I just get a longer error: > > [CODE]@MainBox > /mnt/sdb4/Applications/gnucash-3.4/gnucash-3.4/build-gnucash-3.4 $ cmake > -DCMAKE_INSTALL_PREFIX=$HOME/.local -DCMAKE_PREFIX_PATH=$HOME/.local > ../gnucash-3.4 > CMake Error: The source directory > "/mnt/sdb4/Applications/gnucash-3.4/gnucash-3.4/gnucash-3.4" does not > exist. > Specify --help for usage, or press the help button on the CMake GUI.[/CODE] > > Now there's 2 levels missing. > > I don't know enough about scripting yet; what am I not getting right here? > > Thanks > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] gnucash 3.4 help needed
Running Linux Mint 18.3 Cinnamon on this box, and need some help - Playing with Gnucash 3.4, and from the page at [URL="http://https://wiki.gnucash.org/wiki/Building_On_Linux"]https://wiki.gnucash.org/wiki/Building_On_Linux[/URL] I'm confused by these instructions and commands: Open a shell and change directory to the directory into which you extracted the GnuCash sources (gnucash-3.4) or cloned the github repository (gnucash), i.e. the parent directory of gnucash-3.4 or gnucash. Build using Cmake and Make mkdir build-gnucash-3.4 # create the build directory - Note: Named to identify the source since it is not within the source directory. cd build-gnucash-3.4 # change into the build directory cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local -DCMAKE_PREFIX_PATH=$HOME/.local ../gnucash-3.4 # As shown this will install in the .local directory in /home/. make # builds the program and associated libraries make install # prefix with sudo if you do install to /usr/local or /opt as admin privileges are required. Cuz that gets an error that confuses me even more: [CODE]@MainBox /mnt/sdb4/Applications/gnucash-3.4/build-gnucash-3.4 $ cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local -DCMAKE_PREFIX_PATH=$HOME/.local ../gnucash-3.4 CMake Error: The source directory "/mnt/sdb4/Applications/gnucash-3.4/gnucash-3.4" does not exist. Specify --help for usage, or press the help button on the CMake GUI.[CODE] It says there's supposed to be another directory level called "gnucash-3.4" If I create that"missing" directory, I just get a longer error: [CODE]@MainBox /mnt/sdb4/Applications/gnucash-3.4/gnucash-3.4/build-gnucash-3.4 $ cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local -DCMAKE_PREFIX_PATH=$HOME/.local ../gnucash-3.4 CMake Error: The source directory "/mnt/sdb4/Applications/gnucash-3.4/gnucash-3.4/gnucash-3.4" does not exist. Specify --help for usage, or press the help button on the CMake GUI.[/CODE] Now there's 2 levels missing. I don't know enough about scripting yet; what am I not getting right here? Thanks ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] IRC access
So you are the ideal candidate to do the fine polishing of the page. ;-) Am 06.03.19 um 13:25 schrieb David Carlson: > I like the idea of making the page more useful to persons like me who have > no idea how IRC works yet without 'bloat' or information beyond links to a > few good outside sources for details beyond basics that is needed to start > using the #GnuCash channel. > > I know that another thing I would like to know is how to address in-channel > comments to others so that when more than one person is commenting I can > address one of them easily without manually typing their nick-name every > time. It looks like the seasoned users have a trick that I haven't > learned. I do not use IRC for any other purpose than asking questions > about GnuCash, so I do not practice in channels for other topics, and I > suspect most other GnuCash users that happen by are also not heavy IRC > users. It depends on your client: if text based, just copy In a GUI might be a user list, where you can right click a person to do something specific with her. > David Carlson ~Frank ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL
gnucash.trace is empty. Of some interest, I did a Save As to sqlite and it worked. So the xml data is acceptable to that DB. XML -> sqlite OK XML -> mysql NG sqlite -> mysql NG I tried to do a Save As from the sqlite db to MySQL. That Save As ground away for a few minutes and then threw the same bad data error. So I am guessing that I have a problem with my mysql server. But of course the error log for mysql is clean. There may be some mysql magic I am missing. Since I don't live there I may not push on it much longer. Keith On Wed, Mar 6, 2019 at 11:44 AM Colin Law wrote: > On Wed, 6 Mar 2019 at 15:36, Keith Bellairs wrote: > > > > Yes, the Save As selection is not grayed out. So I assumed the drivers > were > > in the Mac package. > > > > My MySQL instance is up and running. > > > > But I get a gnc error when I try to do the Save As. > > > > Have a look in the gnucash trace file to see if it says anything more > helpful > > Colin > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Business Set up
You can export and re-import your account structure. I think you’ll have to recreate your business information data, and there is currently no facility to export customers and vendors, but you can import them. So if you manage to create a CSV for your customers and vendors, you can use that for subsequent import. Tax tables are another animal, and those will also have to be recreated manually. It might be much simpler to just enter correcting transactions and then refactor any part of your account tree you need to update. > On Mar 6, 2019, at 11:21 AM, Alan Harris via gnucash-user > wrote: > > I have been using gnucash for several years for our small business. I would > like start fresh due to some errors made several years ago. Can I copy the > current business and zero out the beginning balances or do I need to start > from scratch and create a new business? Can I copy over my current customer > list and vendor list? > Thank you ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Business Set up
I have been using gnucash for several years for our small business. I would like start fresh due to some errors made several years ago. Can I copy the current business and zero out the beginning balances or do I need to start from scratch and create a new business? Can I copy over my current customer list and vendor list? Thank you ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL
On Wed, 6 Mar 2019 at 15:36, Keith Bellairs wrote: > > Yes, the Save As selection is not grayed out. So I assumed the drivers were > in the Mac package. > > My MySQL instance is up and running. > > But I get a gnc error when I try to do the Save As. > Have a look in the gnucash trace file to see if it says anything more helpful Colin ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Getting security prices - Funnies
After installation all of the files are copied to one of the directories in perl's @INC include list. What those directories are depends on the way perl is configured, but if you ran cpan as root then I'd expect them to be in /usr/lib/perl/ or /usr/lib/per5. For non-root installations ~/perl5 or ~/lib/perl5 are common. Regards, John Ralls > On Mar 6, 2019, at 2:23 AM, Eric Coates wrote: > > > John > Thanks for the explanations - and the bonus of explaining what the padlock > means, the directory belongs (in this case) to root. > But, in my ignorance, I don't follow your comment that none of the > directories of the form > Finance-Quote-1.44-0 > are needed after F::Q is installed. > Ameer Sengar and nvsoar have said that the file > AlphaVantage.pm > needs to be slightly modified to overcome the throttling. The only copies of > that file I can find on my system reside in the Finance-Quote directories > (albeit several subdirectories down). I would have thought that deleting the > Finance-Quote directories would negate the effect of changing the > AlphaVantage.pm file. > What am I missing? > On your comment about using yahoo-json instead of AlphaVantage it's worth > noting that the London Stock Exchange (where many of my securities are > listed) quotes prices in pennies but yahoo-json interprets the numbers as > pounds. Using yahoo-json makes one (appear to be) very rich! (However, it > does work correctly to get European stocks - at least on the Frankfurt and > Paris bourses - and I use it for those securities.) > Best wishes > Eric > === > > On 05/03/2019 19:54, John Ralls wrote: >>> On Mar 5, 2019, at 9:36 AM, Eric Coates >>> wrote: >>> >>> I am running GnuCash 2.9.16 (with Finance Quote 1.47) on Ubuntu 16.04. >>> >>> In the course of some fairly standard (for me) work I have come across a >>> couple of "funnies" and I'm wondering whether they are deliberate, >>> "features" (from Microsoft's vocabulary meaning a bug that won't be fixed), >>> bugs or me doing something wrong. >>> >>> On the last day of the month I need to revalue my share portfolio. Like >>> others, I have been a victim of Alphvantage's throttling of their service >>> but unlike others I have not (yet) screwed up my courage and updated the >>> the related file to incorporate the delays suggested. >>> >>> I open the Securities Editor, make sure that the Get Quote column is shown >>> (and, for simplicity at this stage, I'll assume no securities are ticked) >>> and then, by double clicking on a security I get to the Security >>> Information window and select Get Online Quotes, click Unknown and select >>> Alphavantage from the drop down. I do this for five securities (no point in >>> doing it for more because of the Alphavantage limitation). In the Price >>> Editor I click Get Quotes and, after a wait, I get the prices for the five >>> securities I selected. >>> >>> Having got those five prices I need to select a second batch of securities. >>> But (*first funny*) I cannot deselect the previously selected securities by >>> clicking on the tick - I have to go back to the Security Information to do >>> that. Is that intended? >>> >>> Having deselected the Get Quote for a security, I have noted that if, in >>> the same session of working with GnuCash, I return to the same security the >>> Get Online Quotes option is not selected but the associated options are >>> still intact. However (*second funny*), if I exit GnuCash (after saving of >>> course) and then restart it and re-enter the Security Editor only those >>> securities that were left ticked as Get Quotes retain the option >>> information, all others are reset to the defaults. >>> >>> These two funnies make getting security prices (using this method) somewhat >>> tedious and may mean that I have to really screw up my courage and make the >>> changes to the file. >>> >>> Anticipating that one day I will screw up enough courage I have been >>> investigating the file Alphavantage.pm. On my system I have five of them; >>> in the directory ~/.cpan/build I have five directories three of the form >>> >>> Finance-Quote-1.44-0 (they are 1.44-0, 1.45-0 and 1.47-0) >>> >>> and two of the form >>> >>> Finance-Quote-1.47-iGUjLI (both are for 1.47 but with different >>> tails, one of them has a closed padlock superimposed on the folder icon) >>> >>> Is this a *third funny*? Do I need all of them? If not, how do I determine >>> which one I do need? >>> >>> The *fourth **(or is it only the third?) **funny* I've noticed is that if I >>> rename a data file the Get Quote column is no longer visible in the >>> Security Editor window. It's easy to get back so this funny is trivial but, >>> out of interest, as the data file has not changed, why does it happen? >>> >> You might try using yahoo-json instead of Alphavantage. It's not throttled. >> >> First funny: Yes, it's intentional. The
Re: [GNC] Fwd: Bonus share entry
As David says, tab is your friend here. As far as the valuation goes, the additional shares, when added at zero cost to you, will serve to reduce the overall cost basis of the position, which will be reflected in the gain amount when you sell. At least, that's how I understand it. If they are in fact some kind of in-kind bonus (think stock bonus) that is given in lieu of a real value, then you would value the shares accordingly. Thus, a bonus of 100 shares in lieu of a $1000 bonus would be treated as bonus income, and each share in this transaction would be valued at $10. I'd be careful in this situation not to mistakenly let this artificially-low price skew the value of the position. Cheers, David On March 6, 2019, at 6:09 PM, David Carlson wrote: Mageia, There is a trick when manually typing to use the Tab key to traverse the split line to prevent the 1 price from appearing. However, if the bonus shares are a taxable income they should be valued as such so they appear as taxable income at tax time. David Carlson On Wed, Mar 6, 2019 at 6:08 AM Gnucash Xboxboy Mageia < xboxboy.mageia+gnuc...@gmail.com> wrote: > On Wed, Mar 6, 2019 at 10:22 PM Fred Bone > wrote: > > > On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: > > > > [...] > > > Hi Derek, > > > > > > I've attached a picture, I don't think I'm explaining very well. > > > > > > Please see attached. > > > > > > What can I do about that imbalance line? > > > > Delete it, and delete the price and value on the "buy" split. > > > > > Fred, > I think I've done as you say, but it continues to place 1 in the line > below? > > I've attached an updated pic > ___ > 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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] apply coefficient to an account
On Wed, Mar 06 2019, elvis wrote: > I have a program in python to add a split like that to a qif file. > [...] > if you are interested let me know. Thanks. But for my usage, it won't work: the split must be done later after importing the bank-files. -- Peter ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] apply coefficient to an account
On Tue, Mar 05 2019, Stephen M. Butler wrote: > Oh, are you using a Sqlite data store? If so, you might be able to > write a query to pull those accounts and apply the percentages. You > could load the account names and percentages into a new table and drive > the query from there. Thanks, good idea! -- Peter ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
Try using the Stock Split assistant to record bonus shares. When you use that assistant, it seems to have special privileges to accommodate a split with just the shares without associating a value to it. But when you try to replicate the same splits manually, you run into issues that you have described. To use the stock split assistant - - first, open the register in which bonus shares have been declared - then click on Actions -> Stock Split, then Next - it will automatically select the stock account you are in, so click next - on the next screen, enter the date when bonus was issued and the no. of bonus shares (in your case, 16). You can change the description to Bonus instead of Stock Split - on the next screen, it will ask you if there was a cash payout as well. If there was, enter the details here or skip. Then you are done. This will create a split in your stock register without the imbalance issue. You can run the Advanced Portfolio report and the balance sheet report after recording this split. It should show that your cost basis hasn’t changed. Cheers. On 06-Mar-2019, at 5:55 PM, mailto:gnucash-user-requ...@gnucash.org>> mailto:gnucash-user-requ...@gnucash.org>> wrote: Date: Wed, 6 Mar 2019 22:38:26 +1030 From: Gnucash Xboxboy Mageia mailto:xboxboy.mageia+gnuc...@gmail.com>> To: fred.b...@dial.pipex.com<mailto:fred.b...@dial.pipex.com> Cc: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Fwd: Bonus share entry Message-ID: mailto:cakfyohr_stteywc20f2p5jmugp6ulvnyzniz20zoj6dqons...@mail.gmail.com>> Content-Type: text/plain; charset="utf-8" On Wed, Mar 6, 2019 at 10:22 PM Fred Bone mailto:fred.b...@dial.pipex.com>> wrote: On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: [...] Hi Derek, I've attached a picture, I don't think I'm explaining very well. Please see attached. What can I do about that imbalance line? Delete it, and delete the price and value on the "buy" split. Fred, I think I've done as you say, but it continues to place 1 in the line below? I've attached an updated pic -- next part -- A non-text attachment was scrubbed... Name: Screenshot_20190306_223604.png Type: image/png Size: 28399 bytes Desc: not available URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190306/97314ef2/attachment-0001.png> -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
Mageia, There is a trick when manually typing to use the Tab key to traverse the split line to prevent the 1 price from appearing. However, if the bonus shares are a taxable income they should be valued as such so they appear as taxable income at tax time. David Carlson On Wed, Mar 6, 2019 at 6:08 AM Gnucash Xboxboy Mageia < xboxboy.mageia+gnuc...@gmail.com> wrote: > On Wed, Mar 6, 2019 at 10:22 PM Fred Bone > wrote: > > > On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: > > > > [...] > > > Hi Derek, > > > > > > I've attached a picture, I don't think I'm explaining very well. > > > > > > Please see attached. > > > > > > What can I do about that imbalance line? > > > > Delete it, and delete the price and value on the "buy" split. > > > > > Fred, > I think I've done as you say, but it continues to place 1 in the line > below? > > I've attached an updated pic > ___ > 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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
On Wednesday, March 6, 2019 at 22:38, Gnucash Xboxboy Mageia said: > On Wed, Mar 6, 2019 at 10:22 PM Fred Bone > wrote: > > > On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: > > > > [...] > > > Hi Derek, > > > > > > I've attached a picture, I don't think I'm explaining very well. > > > > > > Please see attached. > > > > > > What can I do about that imbalance line? > > > > Delete it, and delete the price and value on the "buy" split. > > > > > Fred, > I think I've done as you say, but it continues to place 1 in the line > below? > > I've attached an updated pic That is as it should be. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] IRC access
I like the idea of making the page more useful to persons like me who have no idea how IRC works yet without 'bloat' or information beyond links to a few good outside sources for details beyond basics that is needed to start using the #GnuCash channel. I know that another thing I would like to know is how to address in-channel comments to others so that when more than one person is commenting I can address one of them easily without manually typing their nick-name every time. It looks like the seasoned users have a trick that I haven't learned. I do not use IRC for any other purpose than asking questions about GnuCash, so I do not practice in channels for other topics, and I suspect most other GnuCash users that happen by are also not heavy IRC users. David Carlson On Wed, Mar 6, 2019 at 5:03 AM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > I am pretty sure the section can be slenderized. > > You have both not been there, when the attack was waging. I watched lags > of several minutes between sending a commnd and seeing its execution. > That is the reason why I copied the very first help screens. > > After setting the moderation flag on the channel, my worst case scenario > was a user, who fears he lost his data and can now additionally not ask > in the channel. > > Probably a more user friendly structure might be: > > Just try the link irc://... > If successful continue with "register a nick" > else install a client, see lists, and retry > > with the definitions, where required. > > ~Frank > > Am 06.03.19 um 08:00 schrieb David T.: > > I agree. It would be appropriate to have brief information related to > gnucash on IRC, with pointers to official resources. > > 90% of the content in the current page should go. The introductory > paragraph followed by the server, channel, and link to IRC download and > help pages should be it. > > David T. > > > > > > > > On Wed, Mar 6, 2019 at 10:18, John Ralls > wrote: > > > >> On Mar 5, 2019, at 8:01 PM, Frank H. Ellenberger < > frank.h.ellenber...@gmail.com> wrote: > >> > >> Am 05.03.19 um 20:56 schrieb John Ralls: > >>> LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/ > >>> > >>> Regards, > >>> John Ralls > >> > >> or read (and improve) the wiki ;.) > >> https://wiki.gnucash.org/wiki/IRC#Usage > > > > I don't think it's reasonable or practical to replicate all of mankind's > knowledge in our Wiki. It makes sense that we include information about > GnuCash itself. It does not make sense to document every random piece of > software that some user may use to communicate with us, particularly if > that documentation is readily available on the web. > > > > 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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
On Wed, Mar 6, 2019 at 10:22 PM Fred Bone wrote: > On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: > > [...] > > Hi Derek, > > > > I've attached a picture, I don't think I'm explaining very well. > > > > Please see attached. > > > > What can I do about that imbalance line? > > Delete it, and delete the price and value on the "buy" split. > > Fred, I think I've done as you say, but it continues to place 1 in the line below? I've attached an updated pic ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Default invoice/statement
Is there a way to move the Fancy invoice/statement layout up to replace the default? The default layout does not allow putting a logo on the masthead. I'm using the last update of version 2 of GnuCash. It's stable and working for us so haven't seen the need to update. Thanks much, Roger Oliver ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said: [...] > Hi Derek, > > I've attached a picture, I don't think I'm explaining very well. > > Please see attached. > > What can I do about that imbalance line? Delete it, and delete the price and value on the "buy" split. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
I wouldn't book this gift of shares as a zero-cost purchase. I'd book it as as a full-priced BUY transaction, but with corresponding account from Income:Gifts rather than Asset:Bank. Because I'm not accountant I don't know what is the tax treatment of this gift and would ensure the Income:Gifts is recorded and reported, and let them decide if tax is due. On Wed, 6 Mar 2019 at 19:28, Gnucash Xboxboy Mageia < xboxboy.mageia+gnuc...@gmail.com> wrote: > On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: > > > The cost may be zero, but the value is not. > > Maybe just enter them as 0.01? > > > > -derek > > Sent using my mobile device. Please excuse any typos. > > On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia > > wrote: > > > > > Hi all, > > > I have some bonus shares that were issued with no cost to me: > > > > > > I am having trouble entering them without a cost. When I put 0 as the > > cost, > > > on the next line 1 appears, and I am unable to get rid of it. > > > > > > Perhaps I'm doing this the wrong way, and need to be entering them as a > > > share split? > > > > > > In this case, I had 100 shares, and got issued 16 for no cost: so I > have > > > 116 in total. > > > > > > Any ideas? > > > > > > Thanks, > > > Xboxboy > > > ___ > > > 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. > > > > > > > Hi Derek, > > I've attached a picture, I don't think I'm explaining very well. > > Please see attached. > > What can I do about that imbalance line? > Many thanks, > Xboxboy > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
On Wed, Mar 6, 2019 at 9:38 PM Derek Atkins wrote: > The cost may be zero, but the value is not. > Maybe just enter them as 0.01? > > -derek > Sent using my mobile device. Please excuse any typos. > On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia > wrote: > > > Hi all, > > I have some bonus shares that were issued with no cost to me: > > > > I am having trouble entering them without a cost. When I put 0 as the > cost, > > on the next line 1 appears, and I am unable to get rid of it. > > > > Perhaps I'm doing this the wrong way, and need to be entering them as a > > share split? > > > > In this case, I had 100 shares, and got issued 16 for no cost: so I have > > 116 in total. > > > > Any ideas? > > > > Thanks, > > Xboxboy > > ___ > > 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. > > > Hi Derek, I've attached a picture, I don't think I'm explaining very well. Please see attached. What can I do about that imbalance line? Many thanks, Xboxboy ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Bonus share entry
The cost may be zero, but the value is not. Maybe just enter them as 0.01? -derek Sent using my mobile device. Please excuse any typos. On March 6, 2019 6:07:28 AM Gnucash Xboxboy Mageia wrote: Hi all, I have some bonus shares that were issued with no cost to me: I am having trouble entering them without a cost. When I put 0 as the cost, on the next line 1 appears, and I am unable to get rid of it. Perhaps I'm doing this the wrong way, and need to be entering them as a share split? In this case, I had 100 shares, and got issued 16 for no cost: so I have 116 in total. Any ideas? Thanks, Xboxboy ___ 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.
[GNC] Fwd: Bonus share entry
Hi all, I have some bonus shares that were issued with no cost to me: I am having trouble entering them without a cost. When I put 0 as the cost, on the next line 1 appears, and I am unable to get rid of it. Perhaps I'm doing this the wrong way, and need to be entering them as a share split? In this case, I had 100 shares, and got issued 16 for no cost: so I have 116 in total. Any ideas? Thanks, Xboxboy ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] IRC access
I am pretty sure the section can be slenderized. You have both not been there, when the attack was waging. I watched lags of several minutes between sending a commnd and seeing its execution. That is the reason why I copied the very first help screens. After setting the moderation flag on the channel, my worst case scenario was a user, who fears he lost his data and can now additionally not ask in the channel. Probably a more user friendly structure might be: Just try the link irc://... If successful continue with "register a nick" else install a client, see lists, and retry with the definitions, where required. ~Frank Am 06.03.19 um 08:00 schrieb David T.: > I agree. It would be appropriate to have brief information related to gnucash > on IRC, with pointers to official resources. > 90% of the content in the current page should go. The introductory paragraph > followed by the server, channel, and link to IRC download and help pages > should be it. > David T. > > > > On Wed, Mar 6, 2019 at 10:18, John Ralls > wrote: > >> On Mar 5, 2019, at 8:01 PM, Frank H. Ellenberger >> wrote: >> >> Am 05.03.19 um 20:56 schrieb John Ralls: >>> LMGTFY: http://deadlytechnology.com/linux/irc-on-ubuntu/ >>> >>> Regards, >>> John Ralls >> >> or read (and improve) the wiki ;.) >> https://wiki.gnucash.org/wiki/IRC#Usage > > I don't think it's reasonable or practical to replicate all of mankind's > knowledge in our Wiki. It makes sense that we include information about > GnuCash itself. It does not make sense to document every random piece of > software that some user may use to communicate with us, particularly if that > documentation is readily available on the web. > > 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: [GNC] Test email to Mailing List: I've been having Issues Sending to list
Hi I see it. Maf. On Wednesday, 6 March 2019 10:32:42 GMT Gnucash Xboxboy Mageia wrote: > Hi guys, > just a test email to see if I send to the mailing list: I seem to have been > getting bounced: so I've updated my 'from' address. > > Can one or two kind souls please reply if this comes through on your end? > > Many thanks, > Xboxboy > ___ > 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. -- Maf. King PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Test email to Mailing List: I've been having Issues Sending to list
Hi guys, just a test email to see if I send to the mailing list: I seem to have been getting bounced: so I've updated my 'from' address. Can one or two kind souls please reply if this comes through on your end? Many thanks, Xboxboy ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Getting security prices - Funnies
John Thanks for the explanations - and the bonus of explaining what the padlock means, the directory belongs (in this case) to root. But, in my ignorance, I don't follow your comment that none of the directories of the form Finance-Quote-1.44-0 are needed after F::Q is installed. Ameer Sengar and nvsoar have said that the file AlphaVantage.pm needs to be slightly modified to overcome the throttling. The only copies of that file I can find on my system reside in the Finance-Quote directories (albeit several subdirectories down). I would have thought that deleting the Finance-Quote directories would negate the effect of changing the AlphaVantage.pm file. What am I missing? On your comment about using yahoo-json instead of AlphaVantage it's worth noting that the London Stock Exchange (where many of my securities are listed) quotes prices in pennies but yahoo-json interprets the numbers as pounds. Using yahoo-json makes one (appear to be) very rich! (However, it does work correctly to get European stocks - at least on the Frankfurt and Paris bourses - and I use it for those securities.) Best wishes Eric === On 05/03/2019 19:54, John Ralls wrote: On Mar 5, 2019, at 9:36 AM, Eric Coates wrote: I am running GnuCash 2.9.16 (with Finance Quote 1.47) on Ubuntu 16.04. In the course of some fairly standard (for me) work I have come across a couple of "funnies" and I'm wondering whether they are deliberate, "features" (from Microsoft's vocabulary meaning a bug that won't be fixed), bugs or me doing something wrong. On the last day of the month I need to revalue my share portfolio. Like others, I have been a victim of Alphvantage's throttling of their service but unlike others I have not (yet) screwed up my courage and updated the the related file to incorporate the delays suggested. I open the Securities Editor, make sure that the Get Quote column is shown (and, for simplicity at this stage, I'll assume no securities are ticked) and then, by double clicking on a security I get to the Security Information window and select Get Online Quotes, click Unknown and select Alphavantage from the drop down. I do this for five securities (no point in doing it for more because of the Alphavantage limitation). In the Price Editor I click Get Quotes and, after a wait, I get the prices for the five securities I selected. Having got those five prices I need to select a second batch of securities. But (*first funny*) I cannot deselect the previously selected securities by clicking on the tick - I have to go back to the Security Information to do that. Is that intended? Having deselected the Get Quote for a security, I have noted that if, in the same session of working with GnuCash, I return to the same security the Get Online Quotes option is not selected but the associated options are still intact. However (*second funny*), if I exit GnuCash (after saving of course) and then restart it and re-enter the Security Editor only those securities that were left ticked as Get Quotes retain the option information, all others are reset to the defaults. These two funnies make getting security prices (using this method) somewhat tedious and may mean that I have to really screw up my courage and make the changes to the file. Anticipating that one day I will screw up enough courage I have been investigating the file Alphavantage.pm. On my system I have five of them; in the directory ~/.cpan/build I have five directories three of the form Finance-Quote-1.44-0 (they are 1.44-0, 1.45-0 and 1.47-0) and two of the form Finance-Quote-1.47-iGUjLI (both are for 1.47 but with different tails, one of them has a closed padlock superimposed on the folder icon) Is this a *third funny*? Do I need all of them? If not, how do I determine which one I do need? The *fourth **(or is it only the third?) **funny* I've noticed is that if I rename a data file the Get Quote column is no longer visible in the Security Editor window. It's easy to get back so this funny is trivial but, out of interest, as the data file has not changed, why does it happen? You might try using yahoo-json instead of Alphavantage. It's not throttled. First funny: Yes, it's intentional. The check box in the Securities dialog box is display-only. Second funny: That's an artifact of the difference between the in-memory state of the Security object and its representation on disk; if "get quotes" is off then the quotes element isn't written out. Third funny: I haven't seen that before. I've only seen the ones with the tail (which I think is randomly generated at build time). I imagine that the lock is because the directory belongs to another user. You can run ls -l on it in a terminal to see. Once F::Q is installed you don't need any of them. Fourth funny: That's because the window state of all windows lives in a file named after the data file. When you
Re: [GNC] apply coefficient to an account
On Wed, 6 Mar 2019 17:23:23 +1000 elvis wrote: > Hi Peter, > > I have a program in python to add a split like that to a qif file. > > I had it written to add Australian GST to my transactions after years > of splitting them manually. > > > So I download my bank file, run the program, then import with all the > splits added. > > > You might need to alter it to suit your split values, > > > if you are interested let me know. > > > Lawrence I was thinking that this is identical to the problem I face when I have to split the vehicle costs between business and personal in a fixed ratio. Then I have to split the GST as well. Liz ___ 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.
