Verify Trade Data to be Imported

This column contains a drop-down list of valid trade types for this Import page. To select a trade type, click in the Trade Type field in the appropriate row and select the appropriate trade type from the drop-down list that displays. The trade type that is selected displays in red and bold in the drop-down list. The trade types displayed in this list coincide with the security type displayed in the Security Type field. For example, if the Security Type field is set to Stock, the Trade Type drop-down list contains only those transactions that pertain to a stock. If you change the Security Type field to Option, the Trade Type drop-down list will contain those transactions that pertain to options.

The following table contains a list of all the transactions that can be selected from the Trade Type drop-down list.

Click here to view a list of transaction types that are only to be used for E*TRADE OFX and Scottrade CSV.

Transaction Name	Type	Valid Security Types	Transaction Description
assign	Short A short position represents a stock, that you have sold, without having covered it.	option	Use this transaction to assign The act of clearing houses and brokerages selecting short option and future contract holders to deliver underlying securities or commodities of maturing or exercised/tendered contracts. a call/put option by FIFO. It closes an option contract and buys (in the case of a call) or sells (in the case of a put) the underlying security.
assignexp	Short	option	Use this transaction to close a call/put option, without establishing a connection between the option and the underlying security. When using this transaction, you will need to adjust the cost basis on the associated stock transaction. Alternately, you can exclude Assignexp and the associated trades from import, and record the Assign transactions manually to have your cost basis automatically adjusted.
baseline	Long A long position represents a security, contract, or commodity that you actually own.	stock, mutual fund, option, bond, other	Use this transaction to record positions that you held open at the time your broker sent your trade data. In order to accurately calculate your gain/loss figures, input your cost basis and purchase dates for these baseline positions.
baselineshort	Short	stock, mutual fund, option, other	Use this transaction to record short positions that you held open at the time your broker sent your trade data.
buylong	Long	stock,mutual fund, bond, other	Use this transaction to purchase shares of a specific security.
buytoclose	Short	option	Use this transaction to cover a short option by FIFO.
buytoopen	Long	option	Use this transaction to buy an option.
cancel	Short/Long	stock, mutual fund, option, bond, other	Use this action to delete a transaction.
cashsettledassign	Short	option	Use this transaction to record a cash settled assign.
cashsettledexercise	Long	option	Use this transaction to record a cash settled exercise.
coverbyfifo	Short	stock, mutual fund, other	Use this transaction to cover short by FIFO.
divre	Long	stock, mutual fund, other	Use this transaction to record a dividend reinvestment.
exercise	Long	option	Use this transaction to exercise To implement the rights of an option by buying (in the case of call options) or selling (in the case of put options) the underlying asset. a call/put option by FIFO. It closes an option contract and buys (in the case of a call) or sells (in the case of a put) the underlying security.
exerciseexp	Long	option	Use this transaction to expire a call/put option by FIFO.
expirelong	Long	option	Use this transaction to expire a long call/put option by FIFO.
expireshort	Short	option	Use this transaction to expire a short call.
sellbyavg	Long	mutual fund	Use this transaction to record a sell using the Average Cost Method.
sellbyfifo	Long	stock, mutual fund, bond, other	Use this transaction to sell shares of a security using the first in, first out (FIFO) methodology.
sellshort	Short	stock, mutual fund, other	Use this transaction to record open short activity.
selltoclose	Long	option	Use this transaction to sell an option by FIFO.
selltoopen	Short	option	Use this transaction to open a short option.
withdrawbyfifo	Long	stock, mutual fund, option, bond, other	Use this transaction to withdraw shares without affecting gain/loss.

The following transaction types are only to be used for E*TRADE OFX and Scottrade CSV:

Transaction Name	Type	Valid Security Types	Transaction Description
assignbuy		stock	The assignbuy transaction type is used when a put option is assigned to the writer of an option. This transaction will purchase shares of the underlying security at the strike price of the option. An assignclose transaction must also be sent to close the short put option contracts which are being assigned.
assignclose	Short	option	The assignclose transaction type is used when a call or put option is assigned to the writer of an option. This transaction will close out the short option contracts. An assign buy or assignsell transaction must also be sent to buy or sell shares in the underlying security of the option which is being assigned.
assignsell		stock	The assignsell transaction type is used when a call option is assigned to the writer of an option. An assignclose transaction must also be sent to close the short call option contracts which are being assigned.
exercisebuy		stock	The exercisebuy transaction type is used when a call option is exercised by the holder of an option. This transaction will purchase shares of the underlying security at the strike price of the option. An exerciseclose transaction must also be sent to close the call option contracts which are being exercised.
exerciseclose	Long	option	The exerciseclose transaction type is used when a call or put option is exercised by the holder of an option. This transaction will close out the option contracts. An exercise buy or exercisesell transaction must also be sent to buy or sell shares in the underlying security of the option which is being exercised.
exercisesell		stock	The exercisesell transaction type is used when a put option is exercised by the holder of an option. This transaction will sell shares of the underlying security at the strike price of the option. An exerciseclose transaction must also be sent to close the put option contracts which are being exercised.