Correct, it is initially set to blank and it sadly does not take any hints from 
any of those fields at this time. Training the matcher is the only way to 
populate its heuristics. 

-----Original Message-----
From: km22 <k...@gmx.com> 
Sent: Tuesday, February 06, 2024 6:28 PM
To: Kalpesh Patel <kalpesh.pa...@usa.net>
Cc: Steve Butler <stephen.m.butle...@gmail.com>; Gyle McCollam 
<gmccol...@live.com>; GnuCash Users <gnucash-user@gnucash.org>
Subject: Re: [GNC] GnuCash with Interactive Brokers

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.

Reply via email to