Bug Can Bite When Same Security Held in Two Investment Accounts

I first noticed this after migrating from 2004P to 2006P.

I hold treasury bills with the same CUSIPs in two different investment accounts. The first is a 6-month bill, the second is a 3-month bill of the same issue. I track these with the last three characters of the CUSIP for the securities symbol..

When I bought the latest bill, the account holding the earlier issue of the same bill estimated it's value using the new price. That results in an error in the securities value indicated by Quicken and also sees it as a gain because the cost basis is not equal to the estimated price.

I deleted the new account, purged the older account of all transactions using that CUSIP and deleted the CUSIP from the securities list. After that I ran re-entered the transactions in the older register and used ctl Z to recalculate. That did not fix the problem.

My eventual workaround was to append the words "event 1" to the symbol for the first bill . That works but it took a lot of time to arrive at that approach. Perhaps there is a better way?

I restored an earlier image of the entire drive to confirm that the problem also existed in Q2004.

The YTD performance bugs have also carried forward to Q2006.

In spite of these bugs, there are enough improvements in the program that I will keep it.

Reply to
JB
Loading thread data ...

No f-ing way are they the same EXACT same CUSIP's with different maturities.

You're trying to take a short-cut ... it didn't work ... and you're trying to blame it on Quicken.

Take some responsibility!

Reply to
danbrown

Perhaps your description left out some important information, but from what you posted, I do not understand why you think there is a bug. Do I understand you to say that you identified two different real-world securities as being the same security to Quicken ... then thought it was a bug that Quicken treated them as being the same security? Securities with the same ticker symbol get the same prices ... been that way since well before Q2004. I suppose that begs the question: why assign two different securities the same ticker symbol?

If you have securities that do not get assigned a ticker symbol in the real-world, you have a fairly wide range of choices for "dummy" ticker symbols you can use. Surely you can come up with a convention for assigning unique dummy ticker symbols to your securities when there is no real-world symbol available. I don't know how many securities of different prices can have the same cusip number or how many of those you are likely to own, but I would think you could find a much shorter suffix than the one you did for the purpose. A single letter of the alphabet might be sufficient.

Reply to
John Pollard

You need to give the new bill a different ticker. For bonds, I've typically used "~Abbr1" "~Abbr2" or something like that. Change the "ticker" for the new bond, then edit-delete the purchase price data for it and re-enter correct price data. Since these are the same issue, you'll need to enter periodic price updates in two securities instead of one.

Alternatively, you can give them the same ticker, but different names: TBill20050415" and "TBill20050815" would be a way to distinguish them by purchase date. They become two different securities in your records.

Either way, make sure that the default purchase price is corrected to the actual purchase price in the register. This will only affect the other purchase on that date (which can be fixed by editing price info).

Reply to
Thomas Healy
< snip >

Deleting a security in Quicken does not delete it's price history. And if you later add a "new" security with the same ticker, it will get the same prices as were left in the price history for the deleted security. But you can delete those prices manually.

< snip >
Reply to
John Pollard

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.