comparing investment transactions

a very odd problem - my stock portfolio in quicken matches my on line account at Etrade. But when comparing holdings between the online and quicken portfolios my last several transactions - all on Jan 24 do not match - it says the online (actual) Etrade account has less shares - meaning the latest purchases are not being recognized. But the stocks are there! I validated the file and also deactivated Etrade online access, and then re-activated it - no change. i have call into Etrade on this

Any ideas?

al

Reply to
Alan
Loading thread data ...

Just a long shot wild guess, and possible only if it is happening to all Etrade users.

Investment transactions and holdings are separate parts of a download. Perhaps your transactions are being given "trade" dates and your holdings were computed using "settle" dates and your trades haven't settled yet.

Reply to
John Pollard

John This is what I was told by Etrade as a possibility - it might take one more work day for me to see.

alan

Reply to
Alan

This sounds similar to my problem. I sold 1 lot in four different stocks, I'll call them stocks A, B, C, & D, over the last 3 weeks. In each case Quicken added a "place holder" that incorrectly offsets my total stock owned. Lets say I started w/ 500 shares of stock A and sold 100 shares. Quicken adds a placeholder for 100 shares in Stock A's register, thereby making my new total 500 shares instead of the correct 400 shares.

I'm not sure if this is a E*trade problem or a Quicken problem. I've sent an email to E*trade on Sat. Will let you know how they respond.

Any suggestions for troubleshooting?

Reply to
Steve

When you say "Quicken adds a placeholder", I think your wording may be leading you astray. As far as I know, Quicken never "adds a placeholder" without your approval.

What it sounds like is happening is that you already had a placeholder that was hidden because your historical transactions for the security totalled to the correct number of shares. When you sold some shares, the placeholder became visible, because the total shares owned no longer equaled that specified in the placeholder.

Placeholders *never* go away (unless you delete them); once entered, they remain in the account - they can be visible or they can be hidden, but they are there.

Where the original placeholder came from is another question.

You don't say what version of Quicken you have. In Q2005, you should really not accept any placeholders suggested by Quicken and you should delete any you already have. You probably need to also delete any historical transactions entered while the placeholder was in your account, then re-enter them. I am not certain whether this problem (the permanent effect of placeholders on transactions for that security - even transactions that should not be affected) was fixed in Q2006 or not. It's my policy to never have a placeholder in my data.

Reply to
John Pollard

Steve Your problem is identical to my problem. If I accept the placeholder, then the account becomes incorrect - with less shares than it should have. I am going to call Etrade again. I had thought perhaps I needed one extra day for trades to settle - and I will know for certain tuesday

alan

Reply to
Alan

still a big issue - Etrade tells me the problem is not theirs. Quicken says to validate and super validate and I might have corruption. But i created a test file and the Etrade download brings back all my securities but with the same issues. so it is not my file corrupted. perhaps i need to reinstall quicken.

Reply to
Alan

Help - Further on this issue - I have had several emails from Quicken and am now convinced this issue relates to Etrade. I had set up a new quicke file and dowloaded transactions from Etrade - and find that their downloaded list of transactions is incorrect. I have written to them and have not heard back as yet.

Question - the screen in the online center that shows portfolio holds at brokerage as of certain date and time - does that come from the brokerage? or is it derived from my file? I think it must be from the brokerage.

alan

Reply to
Alan

Yes, I am fairly sure the Holdings tab in the Online Center contains values downloaded from your fi.

When there are differences between what is shown on the Holdings tab and what Quicken computes as your holdings, the "Compare to Portfolio" button is available and you can click that button to see what the differences are.

Reply to
John Pollard

John Thanks for your insights here. Do you have any idea at all as to why the "portfolio holdings" file, as downloaded from Etrade should be wrong? My account on their website is correct - which makes me think that for some reason certain transactions did not somehow get properly recorded.

thanks

alan

Reply to
Alan

I don't have any different insights than earlier when I suggested that Etrade may be creating the "Holding" portion of the download with "settle" dates while the transactions they download probably use "trade" dates. You could probably verify this by looking at the differences in Quicken between Quicken's and Etrade's holdings. If 100% of the difference can be accounted for by the date difference, I think you've found your reason.

I don't mean to suggest that there could not be any other reason; I download from Fidelity, they download my non-money market holdings correctly ... they do not download anything for my mm holdings, so there is always a discrepancy there, and it can't be explained by trade date/settle date. They just don't download the mm holdings (they do download the mm transactions).

Reply to
John Pollard

John I checked the dates - no discrepancy. I will be calling Etrade tomorrow and try to ground out this issue alan

Reply to
Alan

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.