[GNC] GnuCash with Interactive Brokers

[km22]

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.patel at 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.butler51 at gmail.com>
> Sent: Tuesday, February 06, 2024 1:21 AM
> To: km22 <km22 at gmx.com>
> Cc: Kalpesh Patel <kalpesh.patel at usa.net>; Gyle McCollam <gmccollam at live.com>; GnuCash Users <gnucash-user at 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 at 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 <gmccollam at live.com>
>>> *Sent:* Monday, February 05, 2024 8:59 AM
>>> *To:* Kalpesh Patel <kalpesh.patel at usa.net>; km22 <km22 at gmx.com>
>>> *Cc:* gnucash-user at 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
>>> 
>>> gmccollam at live.com <mailto:gmccollam at gyleshomes.com>email
>>> 
>>> --------------------------------------------------------------------
>>> ----
>>> 
>>> *From:*gnucash-user
>>> <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on behalf of
>>> km22 via gnucash-user <gnucash-user at gnucash.org>
>>> *Sent:* Monday, February 5, 2024 4:54 AM
>>> *To:* Kalpesh Patel <kalpesh.patel at usa.net>
>>> *Cc:* gnucash-user at gnucash.org <gnucash-user at 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<km22 at gmx.com>
>>>> Sent: Sunday, February 04, 2024 4:57 AM
>>>> To:gnucash-user at 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 at 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 at 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.
>> 
> 
>