Crash when accepting downloaded txns into Quicken. Lost transactions. How to recover?

Question

Quicken premier 27.1.29.22.

When accepting downloaded transactions from Ameritrade into Quicken, it crashed. Bugsplat crash report sent in under my email id. Second time in two days. Same place. Different accounts.

Certainly not uncommon for Quicken to crash (happens regularly to me these days), but first time in 20 years that I can remember losing all the downloaded transactions.
 Yesterday it was a dozen or so, so I just typed them back in. After dealing with all the cusip mismatches, it took me and hour or two.

Today it was 2 or 3 weeks worth involving about 160 mostly complex options transactions.  No way am I typing all those in.

This is the way I did it.
 1. Downloaded txns from Ameritrade into Excel. 
 2. Downloaded some software I found on the web to convert Excel to QIF. (Only allowed 10 at a time unless I paid for it)
 3 Imported QIF file into Quicken.
 4. Edited pretty much every transaction for Investment action errors, Cusip mismatches, Options Qty errors, Ticker symbol mismatches.

I've just finished after 4 or 5 hours of painful work. Reconciling options open/close pairs is not fun in Quicken.

My topics for discussion are:

1. It would be nice to be able to re-download txns using a date range like you can for most credit card or bank websites? Even if there are dups, it's easier to delete that re-enter.
 2. It would be nice to be able to go on to Ameritrade's website and "push" a QFX or QIF file out. I can do that on my bank and credit card websites.
 3.  It would be nice if Quicken supplied a utility to do this conversion from Excel. I lost some bank transactions last year for a different reason and had to go through a similar conversion.

Brian94582 · Answer

Hi @JohnA,
 Interesting. I will try that next time.
 Thanks for your feedback.

Brian94582 · Answer

Hi @QuickenHugh, 
 Thanks for your feedback.
 This issue happened again last week. While Quicken didn't crash this time, I did lose 5 days worth of securities transactions. I re-entered them manually this time, and the securities symbols and options codes already existed, so I know the txns came down, but then never appeared in the "accept" list (other than 3 that needed "specify lots" applied to them).
 Same account as last time, and while going through the process of manually reconciling with my brokerage statement, discovered I was missing a handful from May, also. That probably explains why I haven't been able reconcile accurately for 6 months. I do a lot of trading, so reconciling exactly is not always worth the time I need to spend to do it. 
 Anyway, I will be opening a support case.

JohnA · Answer

There is a procedure to to reset the last downloaded transaction:  I'm not sure how it works for investment accounts though you might want to give it a try.* Go to the Online Center by selecting the Tools menu > Online Center.
* In the Online Center hold down the Ctrl key and click Contact Info.
* In the Refresh Online Transaction Information window, choose the account you are having problems with downloading a full range of transactions.
* Click on the Reset DTSTART button.
Warning: Using this function resets Quickens list of last downloaded transactions. This means that after this button is reset, it is possible you will download several duplicate transactions.
* Choose the earliest date of a transaction you are missing and click OK.
* Click on the Refresh button.
* Attempt to download again.