Understood. My point was more around whether there is a specific field in the GnuCash securities setup which if matched with a specific field in the OFX xml would result in the manual click-based becoming unnecessary?
I have dozens of bonds in the portfolio which are painful to manually match. But they all have unique identifiers (CUSIPs and IBKR contract ids) which I wish GnuCash could leverage in the matching stage. As of now it does not seem to attempt any type of best guess when a new security is being imported from the OFX. Thanks, Ken > On 7 Feb 2024, at 02:57, Kalpesh Patel <kalpesh.pa...@usa.net> wrote: > > Yap, one time deal. It remembers for next time and it won't ask unless it > encounters something new. > > It is similar to us learning to walk in our childhood ... > > -----Original Message----- > From: Steve Butler <stephen.m.butle...@gmail.com> > Sent: Tuesday, February 06, 2024 1:21 AM > To: km22 <k...@gmx.com> > Cc: Kalpesh Patel <kalpesh.pa...@usa.net>; Gyle McCollam > <gmccol...@live.com>; GnuCash Users <gnucash-user@gnucash.org> > Subject: Re: [GNC] GnuCash with Interactive Brokers > > That is true for the first time. After that it will learn the matches you > make and only ask for new ones. > >> On Tue, Feb 6, 2024, 16:35 km22 via gnucash-user <gnucash-user@gnucash.org> >> wrote: >> >> Thanks. >> >> >> Upon importing the OFX I am prompted to match the different bonds in >> the statement with the relevant asset in GnuCash: >> >> This is quite a manual process having to match these manually >> one-by-one. Do you know whether there is a way for me to define the >> assets in GnuCash so this mapping is more automated? (Or at least >> where GnuCash is able to select the best match for me to review?) >> >> >> Since it reads "Please note that the exchange code of the commodity >> you select will be overwritten" does this mean that if I set the >> ISIN/CUSIP correctly in GnuCash the mapping would be more seamless? >> >> >> >> >> >> >>> On 2024-02-05 22:17, Kalpesh Patel wrote: >>> >>> Ken, as Gyle mentioned, they are sibling to each other. In terms of >>> technical specs, QFX is modified OFX format which contains >>> additional Intuit’s non-XML header but GNC treats them both equal as >>> it simply ignores that header. From the transaction wise they both >>> will contain identical data. >>> >>> *From:*Gyle McCollam <gmccol...@live.com> >>> *Sent:* Monday, February 05, 2024 8:59 AM >>> *To:* Kalpesh Patel <kalpesh.pa...@usa.net>; km22 <k...@gmx.com> >>> *Cc:* gnucash-user@gnucash.org >>> *Subject:* Re: [GNC] GnuCash with Interactive Brokers >>> >>> It doesn't "prefer" either, in fact the import is OFX/QFX. >>> >>> Thank You, >>> >>> *Gyle McCollam* >>> >>> Gyle McCollam >>> >>> gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email >>> >>> -------------------------------------------------------------------- >>> ---- >>> >>> *From:*gnucash-user >>> <gnucash-user-bounces+gylemc=gmail....@gnucash.org> on behalf of >>> km22 via gnucash-user <gnucash-user@gnucash.org> >>> *Sent:* Monday, February 5, 2024 4:54 AM >>> *To:* Kalpesh Patel <kalpesh.pa...@usa.net> >>> *Cc:* gnucash-user@gnucash.org <gnucash-user@gnucash.org> >>> *Subject:* Re: [GNC] GnuCash with Interactive Brokers >>> >>> Hi Kalpesh, >>> >>> Thanks for your reply. IBKR offers these "Third-party Downloads": >>> >>> 1. Quicken Web Connect -> which generate a QFX file >>> >>> 2. GainsKeeper >>> >>> 3. TradeLog >>> >>> 4. MS Money -> which generates a OFX file >>> >>> >>> Do you know whether GnuCash prefers OFX or QFX? >>> >>> I have downloaded both and will experiment with them. >>> >>> Thanks, >>> >>> Ken >>> >>> >>> >>> On 2024-02-05 10:27, Kalpesh Patel wrote: >>>> While I am NOT with Interactive Broker, your best bet is to see if >>> you can download transactions in OFX (Open Financial Exchange) or >>> QFX (Quicken Financial Exchange) format. That would be the best >>> format and I believe most broker-dealers support that format as a >>> download method from their web portal. >>>> >>>> -----Original Message----- >>>> From: km22<k...@gmx.com> >>>> Sent: Sunday, February 04, 2024 4:57 AM >>>> To:gnucash-user@gnucash.org >>>> Subject: [GNC] GnuCash with Interactive Brokers >>>> >>>> Hi Gnucash Users, >>>> >>>> Does anyone on this mailing list have a method for importing >>> transactions from Interactive Brokers (IBKR) to GnuCash? (Especially >>> multi-currency users.) >>>> >>>> I currently enter all transactions manually but would like to >>> explore ways of importing transactions. >>>> >>>> Please share your approach if so. >>>> >>>> Thanks, >>>> >>>> Ken >>>> >>>> >>>> >>>> >>> _______________________________________________ >>> 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. >>> >> _______________________________________________ >> 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. >> > > _______________________________________________ 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.
