Anyone have a how-to or tutorial on how to import stock transactions from a CSV file? I'm not finding anything in the documentation on how to handle the different commodities.
On Sun, 2022-06-19 at 15:10 -0500, Jon Schewe wrote: > I'm trying to do a similar import and I'm finding that I can't > convince > GnuCash to enter the other account. I'm using import transactions > from > CSV.I have matched columns to Date, Description, Account, Price, > Deposit, Transfer Account.The "Account" column is the mutual fund > account.The "Transfer Account" column is the currency account. > When I start the import process all of my transactions need an > account > to transfer from, despite specifying the Transfer Account. When I try > and select my currency account I'm told that it has the wrong > commodity. > I have another column for the currency amount, but I don't know what > to > map that to in the importer. > I tried checkout out > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv > > but it doesn't seem to address this.Suggestions on where I'm going > wrong. > On Mon, 2022-04-11 at 22:36 -0400, David T. via gnucash-user wrote: > > Further to this: you care about how much money something cost (the > > amount you have spent), and how much you got for it (the amount of > > shares you purchased). The first affects how much money you have in > > your bank account, the second affects how many shares show in your > > mutual fund. > > On April 11, 2022 8:16:06 PM EDT, Stu Perlman < > > sgperl...@gmail.com > > > > > wrote: > > > Thank for the heads up. > > > On Mon, Apr 11, 2022 at 3:03 PM D < > > > sunfis...@yahoo.com > > > > wrote: > > > > Not going to go into great detail here, but you definitely > > > > DON'T > > > > want tohave gnucash calculate shares. Have it calculate > > > > price.On > > > > Apr 11, 2022, at 11:21, Stu Perlman < > > > > sgperl...@gmail.com > > > > > wrote: > > > > > Hello Everyone, > > > > > I am looking for some guidance on how to import a few hundred > > > > > transactionsfrom my 401(k) account.Unfortunately, the plan > > > > > administrator does not offer a good option forexporting the > > > > > transaction data but I am able to get what I need with > > > > > somebasic web scraping. > > > > > I have been experimenting with creating a multi-split CSV > > > > > import from thedata that I have captured.What I wanted to do > > > > > was a file layout such as: > > > > > *Date,Description,Account,Deposit,SharesAsMemo,Price*01/04/20 > > > > > 21 > > > > > ,Contribution,Cash,-299.26,,Vanguard Institutional Index > > > > > Institutional > > > > > Fund,299.26,0.916289038,326.601/19/2021,Contribution,Cash,- > > > > > 299.26,,Vanguard Institutional Index Institutional > > > > > Fund,299.26,0.892008703,335.49 > > > > > > > > > > My wishful thinking was that I could put the number of shares > > > > > into the memocolumn for reference (but that the system would > > > > > auto-calculate that numberusing the provided Price and > > > > > transaction amount ("Deposit")).I hit a blocker on the second > > > > > to last step of the import wizard with themessage: "*The > > > > > account 'Vanguard Institutional Index Fund' has a > > > > > differentcommodity to the one required, 'US Dollar'. Please > > > > > choose a differentaccount.*" > > > > > So I'm wondering if there are other ways I can go about what > > > > > I'm trying toaccomplish? I started with the CSV importer > > > > > because I figured it would bethe easiest record layout to > > > > > create but I'm not against using a differentformat if what I > > > > > want to accomplish can be done. > > > > > I have a backup plan which is that I will NOT do the multi- > > > > > split import andwill just select the Cash account for all > > > > > rows > > > > > in the Import Previewscreen. I could pack the memo field with > > > > > the ticker symbol, price,quantity, and total debit and let it > > > > > all dump into the Imbalance-USDaccount. I would then have to > > > > > either manually fix them one by one orpossibly script it > > > > > out. I have done this with success in the past butwould > > > > > rather > > > > > just get it right at the data import step if that's in anyway > > > > > possible. > > > > > My thanks in advance for any advice offered. > > > > > - Stu------------------------------ > > > > > gnucash-user mailing > > > > > listgnucash-u...@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 > > listgnucash-u...@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.
