shorted options expiring out of the money still shown in account holdings

Unknown

As described in title.  Can not prevent a shorted option that expires out-of-the-money from still be listed in account holdings, even though the share balance is zero.  The transaction where the position is opened is entered as "ShtSell", and the balancing transaction entered after the option expiration date is entered as "Add - shares added".  The "date acquired" box in the closing transaction box has been filled in with the date that the option was shorted so that both transactions have the same lot number for the shares.  I'm using Quicken 2016 deluxe for Windows.

Sherlock

If you haven't already, you may want to review: https://www.quicken.com/support/recalculate-investment-register

Is there a reason you didn't use a CvrShrt action transaction?

Rocket J Squirrel

The closing transaction should be a Cover Short, not an Add Shares.

Unknown

That did the trick.  Thanks guys.

Unknown

I imported the transactions from TDAmeritrade, and they were coming in as add or remove shares, depending on whether it was a long or short that was expiring.  They are also inconsistent in their nomenclature, sometimes reporting options as the base ticker, strike price, call or put, and expiration, and other times as their Cuspid number, leading to a lot of manual editing to rationalize the data in Quicken.  

Sherlock

Terry Spearman said:

I imported the transactions from TDAmeritrade, and they were coming in as add or remove shares, depending on whether it was a long or short that was expiring.  They are also inconsistent in their nomenclature, sometimes reporting options as the base ticker, strike price, call or put, and expiration, and other times as their Cuspid number, leading to a lot of manual editing to rationalize the data in Quicken.  

A number of financial institutions don't post transactions appropriately to Quicken.  If you haven't already, you may also want to check for placeholder transactions: https://getsatisfaction.com/quickencommunity/topics/quicken-faq-managing-placeholder-entries-in-quic...

K.O. (Win-Premier)

Terry Spearman said:

I imported the transactions from TDAmeritrade, and they were coming in as add or remove shares, depending on whether it was a long or short that was expiring.  They are also inconsistent in their nomenclature, sometimes reporting options as the base ticker, strike price, call or put, and expiration, and other times as their Cuspid number, leading to a lot of manual editing to rationalize the data in Quicken.  

To Sherlock's point and to what you have noticed with TDA, TDA does not provide the accurate transaction to Quicken.  The OFX file format has a transaction type of EXPIRE but TDA doesn't send that transaction (even though that is what actually happened).  Instead then send an ADD transaction to Quicken.  It annoys the crap out of me but nothing Quicken can really do.  Too bad TDA doesn't care enough to fix it.

And yes, TDA also sends through differing symbols for their options and does that does not follow the standard OCC option format.  Bad on their part again.

Unknown

Terry Spearman said:

I imported the transactions from TDAmeritrade, and they were coming in as add or remove shares, depending on whether it was a long or short that was expiring.  They are also inconsistent in their nomenclature, sometimes reporting options as the base ticker, strike price, call or put, and expiration, and other times as their Cuspid number, leading to a lot of manual editing to rationalize the data in Quicken.  

I contacted TDAmeritrade about the issue of going back and forth between using Cuspid and base ticker, call or put, strike, expiration notation.  They said their technical department was aware of the issue, but could not provide an ETA for a fix.