import investment transactions from Options House into Quicken

4,054 views
I am trying to import investment transactions from Options House into Quicken. Where can I find documentation of all of the investment action codes and the format of all fields needed by each of the codes so that I know my source csv file has the right data in it? Is it possible to use QIF to transfer stocks and options into an account without affecting cash? The account I am loading was transferred from Fidelity to Options House and contained some stock and a short call in it at the time it was transferred. Thanks, Rob
asked Dec 18, 2013 by anonymous

5 Answers

The Security Name column should have the security NAME as you have it in Quicken. Quicken will use the name supplied on the QIF file to locate or create the security record. It is not ticket symbol or the CUSIP number (for the one you specified the security name is "McDonald's Corp.", but it could be different if you changed it in Quicken).

Sergiy - ProperSoft Products Support
answered Dec 18, 2013 by sergiy
Also, how do I specify the full security name for options? So far I have been using the symbol the way Yahoo Finance does, e.g., MCD140118C00090000. What should I place in the full security name column for this option?

Thanks,
Rob
answered Dec 18, 2013 by anonymous
1. Yes, all action codes are passed as you supply them.
2. Let em take a look and reply.
3. You need to supply full security name as you have in Quicken.

Sergiy - ProperSoft Products Support
answered Dec 18, 2013 by sergiy
Sergiy,

Thank you for your reply. I have the Buy, Sell, and Div investment actions
working fine. I found a listing of the different codes online.

1. Does CSV2QIF support all Investment Action codes? If not, which ones are
supported?
2. I have not been able to get XIn to work. What does it require?
3. For the security name column, I used the ticker symbol. That seems to be
working fine including for options. Should I use something other than the
ticker symbol?

Thanks,
Rob
answered Dec 18, 2013 by anonymous
Hello Rob,

Your CSV file should have the following columns:

- date
- amount
- price
- quantity
- full security name
- investment action (BUY, SELL, etc.)
- commission (optional)

the first line should be column names as specified above - CSV2QIF will detect them an assign to appropriate columns.


Sergiy - ProperSoft Products Support
answered Dec 18, 2013 by sergiy
Welcome to Propersoft Q&A, where you can ask questions and receive answers from other members of the community.

Ask conversion expert:

I have:

I need to convert to or import into: