tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/988-qfx-file-importInfinite Kind: Discussion 2018-10-18T14:06:02Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/399600872016-05-24T22:27:49Z2016-05-24T22:27:53ZQFX file Import<div><p>Hi,</p>
<p>I'm trying to import a QFX transaction file; this files has
investment transactions (stocks and options, and includes some
short sells). I'm confused on why I need to verify each entry. On
my first import, empty database, it asks me to verify duplicates
(that shouldn't happen). Also, your program is limited on how it
figures out entries. If for example, I bought 100 shares of SPY in
one month and hold on to it for several months, it should be smart
enough to know that entry already exists based on dates. Biggest
flaw is you most likely truncate compare strings, for example, the
following two stock options entries are unique.<br>
QQQ 141018C00090000 QQQ 18OCT14 90.0 C<br>
QQQ 141018C00090500 QQQ 18OCT14 90.5 C</p>
<p>And they also will be unique based on date and timestamp of
Buy/Sell transaction. I do hope you're looking at full timestamp
too. I sometimes will buy and sell the same security 3-4 times in
the same day. For example, buy 100 spy, sell 100 SPY, then buy 100
SPY, buy 100 more SPY, then sell 100 SPY, then buy 100 more, then
sell 200 to close; all in one day.</p></div>Steve Mellow