QFX file Import

Steve Mellow's Avatar

Steve Mellow

24 May, 2016 10:27 PM


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.
QQQ 141018C00090000 QQQ 18OCT14 90.0 C
QQQ 141018C00090500 QQQ 18OCT14 90.5 C

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.

  1. System closed this discussion on 02 Oct, 2016 02:36 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac