[GNC] unable to import simple investment transaction from qif
Hi, I am trying to import avery simple transaction from qif: just 2 buy transaction for the same account, containing mutual fund The 'Assets:Investments:X' is gnu cash account tracking shares of , 'Asserts:Investments:' is a gnucash cash account. If I do not provide security symbol as below, the import fails when it requires to enter the security. !Account NAssets:Investments:X TInvst ^ !Type:Invst D07/16'2022 NBuy LAssets:Investments:Y Q34.107 T-77.58 ^ D07/15'2022 NBuy LAssets:Investments:Y Q7.638 T-37.7 ^ I provide security as Y, the import creates account Assets:Investments:X: that conflicts with 'Assets:Investments:X' 1. Does this feature works? If Yes are there usage examples. 2. I do not insist on using qif format, is it possible to use .csv for import, are there examples? 3. It seems that csv import requires a lot of manual selections to be made for every imported file, am I getting it right? Thank you, Aleksey ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] importing simple investment account
Hi, I am downloading my data in the form of .csv file and I have a simple program to generate an.qif file with proper categories and then import .qif into gnucash. I am adding a program to deal with investment accounts. The problem is that GnuCash investment account consists of a multitude of sub-accounts: cash sub-account + one sub-account for every security/mutual fund. Should I generate a separate .qif file for every sub-account or I can pack it all into a single .qif file with proper account headers inserted? Also, I would generate .csv files but it is not clear what is the native import format for bank and investment transactions. Also, I am using 3.x GnuCash, does it make sense to switch to 4.x to simplify my importing chores? Thank you, Aleksey ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] rational numbers as stock price
I am using 3.1 and see stock price numbers randomly displayed as both rational numbers (e.g. 2/3) and decimals (0.). I really would like to see decimals, is there way to force it. Thank you Aleksey ___ 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: Newbie account matching
Thank you, Aleksey On Tue, May 30, 2017 at 11:40 AM, Derek Atkins <warl...@mit.edu> wrote: > Hi, > > ar <ar123...@gmail.com> writes: > > > Hi, > > > > I had just switched to gnucash from many years of quicken. So, far it > works > > fine. > > > > The only problem is account matching. I am not looking into something > fancy > > - the vast majority of our expenses is in less than 10 stores and less > than > > 10 gas stations, everything else I can classify manually. > > > > In addition to that there are quirks/bugs per reporting company. > > > > I suppose I can easily write a script that will perform proper matching. > > However, I am using it on win10 and there are no python bindings. Hence I > > have to write a standalone pre-processor that will read downloaded file, > > fix the quirks and add explicit account-id string. > > > > My current plan is to generate .csv file and then import it. Should I > > target .qif instead? What strings should I use as account-ids in .csv > file? > > Say if want something to be matched to 'Expenses:Auto:Gas' what string > > should I use? Should I add any configuration for this to happen? > > I would recommend yes, convert it to qif. Then you can add a QIF > Category: > > LExpenses:Auto:Gas > > which the importer will default to the GnuCash Account of the same name. > If you need to insert an Asset/Liability then you can insert a QIF > Account: > > L[Assets:Checking] > > and the same thing will happen. > > > Thank you, > > > > Aleksey > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory >Member, MIT Student Information Processing Board (SIPB) >URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH >warl...@mit.eduPGP key available > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.