[GNC] GnuCash with Interactive Brokers
km22
km22 at gmx.com
Tue Feb 6 03:06:50 EST 2024
Thanks. This can be a very tedious process, especially where there
might be dozens of securities to match one by one through a gui that
requires many clicks through different drop down lists.
It would be nice if there was a way to ensure much better matching
suggestions and then the user simply needs to click to accept (in most
instances).
I’ll continue to experiment with importing IBKR ofx transactions into a
dummy test file. Thanks for the guidance so far.
On 6 Feb 2024, at 13:21, Steve Butler <stephen.m.butler51 at gmail.com>
wrote:
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
<[1]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 <[2]gmccollam at live.com>
> *Sent:* Monday, February 05, 2024 8:59 AM
> *To:* Kalpesh Patel <[3]kalpesh.patel at usa.net>; km22
<[4]km22 at gmx.com>
> *Cc:* [5]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
>
> [6]gmccollam at live.com <mailto:[7]gmccollam at gyleshomes.com>email
>
>
--------------------------------------------------------------------
----
>
> *From:*gnucash-user
> <gnucash-user-bounces+gylemc=[8]gmail.com at gnucash.org> on behalf
of km22
> via gnucash-user <[9]gnucash-user at gnucash.org>
> *Sent:* Monday, February 5, 2024 4:54 AM
> *To:* Kalpesh Patel <[10]kalpesh.patel at usa.net>
> *Cc:* [11]gnucash-user at gnucash.org <[12]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<[13]km22 at gmx.com>
> > Sent: Sunday, February 04, 2024 4:57 AM
> > [14]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
> [15]gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> [16]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
[17]gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
[18]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.
References
1. mailto:gnucash-user at gnucash.org
2. mailto:gmccollam at live.com
3. mailto:kalpesh.patel at usa.net
4. mailto:km22 at gmx.com
5. mailto:gnucash-user at gnucash.org
6. mailto:gmccollam at live.com
7. mailto:gmccollam at gyleshomes.com
8. mailto:gmail.com at gnucash.org
9. mailto:gnucash-user at gnucash.org
10. mailto:kalpesh.patel at usa.net
11. mailto:gnucash-user at gnucash.org
12. mailto:gnucash-user at gnucash.org
13. mailto:km22 at gmx.com
14. mailto:To:gnucash-user at gnucash.org
15. mailto:gnucash-user at gnucash.org
16. https://lists.gnucash.org/mailman/listinfo/gnucash-user
17. mailto:gnucash-user at gnucash.org
18. https://lists.gnucash.org/mailman/listinfo/gnucash-user
More information about the gnucash-user
mailing list