Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Non-Tech : CyBerCorp.com -- Ignore unavailable to you. Want to Upgrade?

To: Tony C. who wrote (923)	2/15/2001 9:12:21 PM
From: MIKE REDDERT	Respond to of 1001

Tony, I've never seen a miscalculated capital gain, but your sales total will not match your brokers statement unless you export the report to a spreadsheet and multiply each cell under the sales column times -1. This can easily be done by using an "@ statement" in Lotus 123... and a very similar formula in Excel. Example Formula: @IF(SALES>0,SALES,-SALES) "SALES" refers to the corresponding cell under the "Sold" column. Copy that formula down thru the entire report and take the sum... it should equal that which is reported on your broker's statement. If it doesn't, you may get to visit your local IRS office :) That said, I've used Quicken since DOS release 3, and I'll never understand why they haven't fixed this short sale bug in all this time... about 12 -13 yrs. Mike