Re: [GNC] Setting up existing investments in new GnuCash file
As far as moving accounts into a nested position later, I think you can use the "Edit Account" functionality to change the Parent Account setting. Found this out after carelessly creating an account in the wrong place. You don't need to delete anything. The program automatically updates all the transactions that reference the moved account. ... - Ken Farley Ken, The "Delete Account" function is a way of combining two accounts into a single one. You can certainly use "Edit Accounts" if you want to move an single account to another parent. However, if you're updating that account from an experimental one (or deciding you don't need multiple accounts), then you'll have to use the "Delete Account" function, and the wizard will ask what you want to do with the transactions currently in the to-be-deleted account. ___ 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] Setting up existing investments in new GnuCash file
Nov 9, 2019, 18:39 by no1clash...@mailbox.org: Thanks for the suggestions. It sounds from your description as though you entered a bunch of historical information for your investment accounts. Is this correct? To be clear, I have no intention of doing that. I am not bringing any history over from Quicken, for any account. I intend to use recent balances on each account as an opening balance in GnucCash, and then use QFX downloads to maintain them from that point. This applies to my investment account as well. It is an IRA, so I don´t need to identify lots, I have no splits, etc., I intend to start with positions as of X date, and import from that point on. If this is a bad approach, please let me know. But spending the time to bring over 3.5 years of history, since the establishment of the IRA, is a non-starter for me. ~dean~ On November 9, 2019 at 8:33 AM orn...@tutanota.com wrote: "Thanks for your reply. I get the impression that even if I get the import process sorted out, that this will be a tedious process and probably no easier in the long run that just entering all the data manually. You state the importer is ahead of the documentation, but my evaluation was based on actually trying the importer more than going following the documentation. None of them seemed suitable without a lot of work, and manual entry is a lot of work. I believe I'll do the latter. Regards, ~dean~"I went through much the same process in August and was unable to use the importer for investments effectively - I ended up doing much of it manually, also. I have some techniques suggestions that might be useful for manual entry. "Save as" your work product as something like "GnuCash_Experimental" in a directory different from your main one in case of non-recoverable errors. Do one account at a time Have your working account at the top level, e.g., ABCDE Mutual Fund, rather than "Assets:Investments:Taxable:Joint:Mutual Funds; this makes the splits easier to assign. Moving a whole account to its nested position later is easy using the (hair-raising) "Delete Account" technique, which I practiced a few times before invoking it with real data. Do only six months or a year's worth of your most recent data at a time. This gives you current information immediately, allowing you to fill in older data as you have time. Use common Description terms, such as "Dividend Reinvestment" when possible - this allows you to to create the same split as previously, saving much Debit/Credit assignment clicks. If you aren't bringing in significant history, then migration will be much simpler. GnuCash is my fifth financial manager program, and in each case before GnuCash I abandoned the all previous data and stated afresh, primarily due to my perception of the probable difficulty. I regretted those choices and this time I captured most of the old data for two earlier programs back through 2009. I made the effort because understanding just what I'd been doing was/is important for me to understand what I'm doing today using GnuCash's invaluable report system. Also importantly, migrating the old data helped me better understand double entry accounting better. Since this doesn't apply to you, your migration will be much simpler. I wish you good luck. ___ 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] Setting up existing investments in new GnuCash file
Back in the 2.6.x days the AFC importer did not do a very good job of importing investment account files. I typed "qfx", not sure where AFC came from. I hope it is better now. David Carlson On Sat, Nov 9, 2019, 12:41 PM Dean Bradley wrote: > Thanks for the suggestions. It sounds from your description as though you > entered a bunch of historical information for your investment accounts. Is > this correct? To be clear, I have no intention of doing that. I am not > bringing any history over from Quicken, for any account. I intend to use > recent balances on each account as an opening balance in GnucCash, and then > use QFX downloads to maintain them from that point. This applies to my > investment account as well. It is an IRA, so I don´t need to identify lots, > I have no splits, etc., I intend to start with positions as of X date, and > import from that point on. If this is a bad approach, please let me know. > But spending the time to bring over 3.5 years of history, since the > establishment of the IRA, is a non-starter for me. > > ~dean~ > > > On November 9, 2019 at 8:33 AM orn...@tutanota.com wrote: > > > > > > "Thanks for your reply. I get the impression that even if I get the > import process sorted out, that this will be a tedious process and probably > no easier in the long run that just entering all the data manually. You > state the importer is ahead of the documentation, but my evaluation was > based on actually trying the importer more than going following the > documentation. None of them seemed suitable without a lot of work, and > manual entry is a lot of work. I believe I'll do the latter. > > > > Regards, > > ~dean~"I went through much the same process in August and was unable to > use the importer for investments > > effectively - I ended up doing much of it manually, also. > > > > I have some techniques suggestions that might be useful for manual entry. > > "Save as" your work product as something like "GnuCash_Experimental" in > a directory different from your main one in case of non-recoverable errors. > > Do one account at a time > > Have your working account at the top level, e.g., ABCDE Mutual Fund, > rather than "Assets:Investments:Taxable:Joint:Mutual Funds; this makes the > splits easier to assign. Moving a whole account to its nested position > later is easy using the (hair-raising) "Delete Account" technique, which I > practiced a few times before invoking it with real data. > > Do only six months or a year's worth of your most recent data at a time. > This gives you current information immediately, allowing you to fill in > older data as you have time. > > Use common Description terms, such as "Dividend Reinvestment" when > possible - this allows you to to create the same split as previously, > saving much Debit/Credit assignment clicks. > > > > > > ___ > > 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: [GNC] Setting up existing investments in new GnuCash file
Thanks for the suggestions. It sounds from your description as though you entered a bunch of historical information for your investment accounts. Is this correct? To be clear, I have no intention of doing that. I am not bringing any history over from Quicken, for any account. I intend to use recent balances on each account as an opening balance in GnucCash, and then use QFX downloads to maintain them from that point. This applies to my investment account as well. It is an IRA, so I don´t need to identify lots, I have no splits, etc., I intend to start with positions as of X date, and import from that point on. If this is a bad approach, please let me know. But spending the time to bring over 3.5 years of history, since the establishment of the IRA, is a non-starter for me. ~dean~ > On November 9, 2019 at 8:33 AM orn...@tutanota.com wrote: > > > "Thanks for your reply. I get the impression that even if I get the import > process sorted out, that this will be a tedious process and probably no > easier in the long run that just entering all the data manually. You state > the importer is ahead of the documentation, but my evaluation was based on > actually trying the importer more than going following the documentation. > None of them seemed suitable without a lot of work, and manual entry is a lot > of work. I believe I'll do the latter. > > Regards, > ~dean~"I went through much the same process in August and was unable to use > the importer for investments > effectively - I ended up doing much of it manually, also. > > I have some techniques suggestions that might be useful for manual entry. > "Save as" your work product as something like "GnuCash_Experimental" in a > directory different from your main one in case of non-recoverable errors. > Do one account at a time > Have your working account at the top level, e.g., ABCDE Mutual Fund, rather > than "Assets:Investments:Taxable:Joint:Mutual Funds; this makes the splits > easier to assign. Moving a whole account to its nested position later is easy > using the (hair-raising) "Delete Account" technique, which I practiced a few > times before invoking it with real data. > Do only six months or a year's worth of your most recent data at a time. This > gives you current information immediately, allowing you to fill in older data > as you have time. > Use common Description terms, such as "Dividend Reinvestment" when possible - > this allows you to to create the same split as previously, saving much > Debit/Credit assignment clicks. > > > ___ > 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] Setting up existing investments in new GnuCash file
As far as moving accounts into a nested position later, I think you can use the "Edit Account" functionality to change the Parent Account setting. Found this out after carelessly creating an account in the wrong place. You don't need to delete anything. The program automatically updates all the transactions that reference the moved account. Also extremely convenient when I had to enter dozens of transactions is the autofill. I'd get the wording of the transaction, like "Reinvest Dividends : SBUX" or "Reinvest Cap Gains : SBUX" the way I like them. Any further transactions I only need to type enough text of the transaction description to uniquely identify it, and all the splits are automatically brought in; I just need to change the numerical values for shares, cost, etc. It's a very nice feature. My favorite invocation of this is when I'm entering a paycheck. It's got 13 splits, which would be brutally tedious to have to enter every time. Plus, the amounts for the splits are based upon the last transaction, *not* what a certain program with a Q used to do (based it upon useless percentages). - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Setting up existing investments in new GnuCash file
I don't think Quicken is in imminent danger of takeover by GnuCash. However, just like any software there is a learning curve that you have to come to terms with for GnuCash. For right now, I keep two sets of books, one in Quicken and one in GnuCash. I assume that at some point I won't be able to use Quicken anymore, either because my current computer died and/or I can't get it installed on a new computer. I'm just preparing for the day that Quicken will be either be too expensive to update (like it is now) or becomes useless to me because of hardware. In all Quicken does a better job and is easier to use than GnuCash, but I am able to do everything in GnuCash that I do in Quicken, albeit with more effort. iii On Monday, November 4, 2019, 3:38:55 AM UTC, Dean Bradley wrote: Hello Joseph, Thanks for the reply. Yeah, I was getting the sense this was going to be a chore, no matter how I sliced it. It seems to me that it is no more trouble to set up all the accounts, securities and opening balances manually, than it is to make multiple passes at incremental imports and all the subsequent amendments. So I think I'll take the manual route. I just hope that when all is said and done (mortgage, auto, IRA) that it will have been worth it, and that GnuCash is a suitable replacement for Quicken. I think Quicken gets a bum rap; I've been a (mostly) happy user of it for a long time. But I no longer want to maintain a Windows virtual machine for just one app. ~dean~ > On November 3, 2019 at 8:52 PM "Joseph G. Keithley, III" > wrote: > > > Speaking from painful experience I exported my brokerage register in > quicken to a qif and then imported it into GnuCash. Once you get past all > the questions from the import not-so-wizard, it took a very long time to > import the file. I tried to break the file up by exporting/importing one > year at a time, but it was still a very slow process. The biggest hassle > was, after GnuCash imported the file, it asks to assign the imported > transactions of stock, bonds, equities, etc to equivalent GnuCash categories > or accounts. The specific hassle was, that it asks you to assign > transactions to categories/accounts (stock purchase or cash dividend or > dividend reinvestment) but is cuts the item short so you cant read what the > full item is and you have to guess whether you are defining a new stock or a > dividend etc. It was very painful. It took at least three separate attempts > before I got something workable and it still required a lot of after import > editing. The only words of advice I can offer are, START VERY SMALL! A few > transactions at a time. You can save yourself some time by predefining your > stocks, bonds and other investments in the security editor and creating the > appropriate categories/accounts for other transactions like dividends and > interest. > > > iii > > > > > On Monday, November 4, 2019, 12:13:19 AM UTC, Dean Bradley > wrote: > > > > > > Hello!, > I am a long-time (25+ years)_ trying to finish my conversion to Linux. I am > setting up GnuCash 3.7 on Manjaro KDE 18.1.2. I am not importing my Quicken > history, and am starting with a new file. The task at hand is setting up my > brokerage account and its holdings. There are 30 securities in this account; > a mix of cash, cash alternatives, funds and stocks. Following are some > questions about this. > > Can I import my holdings from a CSV file into GnuCash? > I have exported my holdings to a CSV file, but it does not appear that any of > the CSV import options are designed for importing holdings. "Import Accounts > as CSV" seems the most appropriate option, but the constraints on that import > file (must match the format of an export) don't match my CSV input file at > all. I've also looked at the Price import, but it doesn't capture much of the > information (e.g. quantity, description). And Import as Transactions just > seem wrong. > > in the absence of an import, it appears I must go through the multi-step > (15-20) process defined in Section 9 of the documentation for each > account/security (define account, define security, define opening balance), > for each of my 30 accounts? Is this correct? Is there any valid shortcut to > this cumbersome approach? > > Assuming I have to manually define each account /security... > Is it correct that I define my current holding (shares and price) as the > opening balance for each account, using the register? > I can export transactions from my brokerage as a QFX file. Once this is all > setup, will I be able to maintain this hierarchy of accounts under the > brokerage parent by importing QFX files? > > I appreciate any help and guidance you can give me. I'd really like to > complete my migration to Linux, and getting this sorted out seems the hardest > part of the process. > > Thanks,and regards, > ~dean~ > ___ > gnucash-
Re: [GNC] Setting up existing investments in new GnuCash file
Thanks for your reply. I get the impression that even if I get the import process sorted out, that this will be a tedious process and probably no easier in the long run that just entering all the data manually. You state the importer is ahead of the documentation, but my evaluation was based on actually trying the importer more than going following the documentation. None of them seemed suitable without a lot of work, and manual entry is a lot of work. I believe I'll do the latter. Regards, ~dean~ > On November 3, 2019 at 8:12 PM David Cousens wrote: > > > Dean, > > It should be possible to use either the Import QIF, Import OFX/QFX, Import > Transactions from CSV options depending on the format you have exported them > in. I haven't used the QIF import for stock information so I can't really > comment on it. > > The CSV importer was largely rewritten going to V3 and the documentation has > not yet fully caught up. I have imported stock transactions exported from > GnuCash using the default GnuCash Export Format with the Simple Layout > export option switched off (It outputs only a single line per transaction in > Simple Layout mode ( not enough info)- the multiline exports a line for each > account entry (split) associated with the transaction). > > The easiest way to get a handle on the export format is to export a > transaction which is similar to the transactions you wish to import to get a > handle on the exported columns. > > The critical information will be the account information for each split the > amount (the importer uses a Deposit or Withdrawal label for this rather than > Debit and Credit ) and the price data. Columns like the transaction ID are > not critical as they will be recreated on import if not present. The closer > you can get the data you want to import to the default GnuCash Export format > the easier importing data with price information will be. In some testing > of the importer I found the export format often created the price in the > form of a rational number and on some occasions that was not interpreted > correctly on import. I am in the process of creating some examples of > importing for the tutorial guide but have been sidetracked by life a bit > lately and haven't really fully systematicall tested stock and currency > type imports. > > The documentation in progress is a little bit hard to access as not all of > it has been pushed to the main GnuCash/gnucash github repository yet. I > should be able to rebuild the branch I have been working on and post a link > to a copy in my Dropbox account later today. > > David Cousens > > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Setting up existing investments in new GnuCash file
Hello Joseph, Thanks for the reply. Yeah, I was getting the sense this was going to be a chore, no matter how I sliced it. It seems to me that it is no more trouble to set up all the accounts, securities and opening balances manually, than it is to make multiple passes at incremental imports and all the subsequent amendments. So I think I'll take the manual route. I just hope that when all is said and done (mortgage, auto, IRA) that it will have been worth it, and that GnuCash is a suitable replacement for Quicken. I think Quicken gets a bum rap; I've been a (mostly) happy user of it for a long time. But I no longer want to maintain a Windows virtual machine for just one app. ~dean~ > On November 3, 2019 at 8:52 PM "Joseph G. Keithley, III" > wrote: > > > Speaking from painful experience I exported my brokerage register in > quicken to a qif and then imported it into GnuCash. Once you get past all > the questions from the import not-so-wizard, it took a very long time to > import the file. I tried to break the file up by exporting/importing one > year at a time, but it was still a very slow process. The biggest hassle > was, after GnuCash imported the file, it asks to assign the imported > transactions of stock, bonds, equities, etc to equivalent GnuCash categories > or accounts. The specific hassle was, that it asks you to assign > transactions to categories/accounts (stock purchase or cash dividend or > dividend reinvestment) but is cuts the item short so you cant read what the > full item is and you have to guess whether you are defining a new stock or a > dividend etc. It was very painful. It took at least three separate attempts > before I got something workable and it still required a lot of after import > editing. The only words of advice I can offer are, START VERY SMALL! A few > transactions at a time. You can save yourself some time by predefining your > stocks, bonds and other investments in the security editor and creating the > appropriate categories/accounts for other transactions like dividends and > interest. > > > iii > > > > > On Monday, November 4, 2019, 12:13:19 AM UTC, Dean Bradley > wrote: > > > > > > Hello!, > I am a long-time (25+ years)_ trying to finish my conversion to Linux. I am > setting up GnuCash 3.7 on Manjaro KDE 18.1.2. I am not importing my Quicken > history, and am starting with a new file. The task at hand is setting up my > brokerage account and its holdings. There are 30 securities in this account; > a mix of cash, cash alternatives, funds and stocks. Following are some > questions about this. > > Can I import my holdings from a CSV file into GnuCash? > I have exported my holdings to a CSV file, but it does not appear that any of > the CSV import options are designed for importing holdings. "Import Accounts > as CSV" seems the most appropriate option, but the constraints on that import > file (must match the format of an export) don't match my CSV input file at > all. I've also looked at the Price import, but it doesn't capture much of the > information (e.g. quantity, description). And Import as Transactions just > seem wrong. > > in the absence of an import, it appears I must go through the multi-step > (15-20) process defined in Section 9 of the documentation for each > account/security (define account, define security, define opening balance), > for each of my 30 accounts? Is this correct? Is there any valid shortcut to > this cumbersome approach? > > Assuming I have to manually define each account /security... > Is it correct that I define my current holding (shares and price) as the > opening balance for each account, using the register? > I can export transactions from my brokerage as a QFX file. Once this is all > setup, will I be able to maintain this hierarchy of accounts under the > brokerage parent by importing QFX files? > > I appreciate any help and guidance you can give me. I'd really like to > complete my migration to Linux, and getting this sorted out seems the hardest > part of the process. > > Thanks,and regards, > ~dean~ > ___ > 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 t
Re: [GNC] Setting up existing investments in new GnuCash file
Speaking from painful experience I exported my brokerage register in quicken to a qif and then imported it into GnuCash. Once you get past all the questions from the import not-so-wizard, it took a very long time to import the file. I tried to break the file up by exporting/importing one year at a time, but it was still a very slow process. The biggest hassle was, after GnuCash imported the file, it asks to assign the imported transactions of stock, bonds, equities, etc to equivalent GnuCash categories or accounts. The specific hassle was, that it asks you to assign transactions to categories/accounts (stock purchase or cash dividend or dividend reinvestment) but is cuts the item short so you cant read what the full item is and you have to guess whether you are defining a new stock or a dividend etc. It was very painful. It took at least three separate attempts before I got something workable and it still required a lot of after import editing. The only words of advice I can offer are, START VERY SMALL! A few transactions at a time. You can save yourself some time by predefining your stocks, bonds and other investments in the security editor and creating the appropriate categories/accounts for other transactions like dividends and interest. iii On Monday, November 4, 2019, 12:13:19 AM UTC, Dean Bradley wrote: Hello!, I am a long-time (25+ years)_ trying to finish my conversion to Linux. I am setting up GnuCash 3.7 on Manjaro KDE 18.1.2. I am not importing my Quicken history, and am starting with a new file. The task at hand is setting up my brokerage account and its holdings. There are 30 securities in this account; a mix of cash, cash alternatives, funds and stocks. Following are some questions about this. Can I import my holdings from a CSV file into GnuCash? I have exported my holdings to a CSV file, but it does not appear that any of the CSV import options are designed for importing holdings. "Import Accounts as CSV" seems the most appropriate option, but the constraints on that import file (must match the format of an export) don't match my CSV input file at all. I've also looked at the Price import, but it doesn't capture much of the information (e.g. quantity, description). And Import as Transactions just seem wrong. in the absence of an import, it appears I must go through the multi-step (15-20) process defined in Section 9 of the documentation for each account/security (define account, define security, define opening balance), for each of my 30 accounts? Is this correct? Is there any valid shortcut to this cumbersome approach? Assuming I have to manually define each account /security... Is it correct that I define my current holding (shares and price) as the opening balance for each account, using the register? I can export transactions from my brokerage as a QFX file. Once this is all setup, will I be able to maintain this hierarchy of accounts under the brokerage parent by importing QFX files? I appreciate any help and guidance you can give me. I'd really like to complete my migration to Linux, and getting this sorted out seems the hardest part of the process. Thanks,and regards, ~dean~ ___ 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] Setting up existing investments in new GnuCash file
Dean, It should be possible to use either the Import QIF, Import OFX/QFX, Import Transactions from CSV options depending on the format you have exported them in. I haven't used the QIF import for stock information so I can't really comment on it. The CSV importer was largely rewritten going to V3 and the documentation has not yet fully caught up. I have imported stock transactions exported from GnuCash using the default GnuCash Export Format with the Simple Layout export option switched off (It outputs only a single line per transaction in Simple Layout mode ( not enough info)- the multiline exports a line for each account entry (split) associated with the transaction). The easiest way to get a handle on the export format is to export a transaction which is similar to the transactions you wish to import to get a handle on the exported columns. The critical information will be the account information for each split the amount (the importer uses a Deposit or Withdrawal label for this rather than Debit and Credit ) and the price data. Columns like the transaction ID are not critical as they will be recreated on import if not present. The closer you can get the data you want to import to the default GnuCash Export format the easier importing data with price information will be. In some testing of the importer I found the export format often created the price in the form of a rational number and on some occasions that was not interpreted correctly on import. I am in the process of creating some examples of importing for the tutorial guide but have been sidetracked by life a bit lately and haven't really fully systematicall tested stock and currency type imports. The documentation in progress is a little bit hard to access as not all of it has been pushed to the main GnuCash/gnucash github repository yet. I should be able to rebuild the branch I have been working on and post a link to a copy in my Dropbox account later today. David Cousens - David Cousens -- 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.