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 : MB TRADING -- Ignore unavailable to you. Want to Upgrade?

To: peter michaelson who wrote (4689)	5/23/1999 2:08:00 PM
From: Colin Cody	Read Replies (1) \| Respond to of 7382

I do from zero to 8 trades a day, so my spreadsheet is not a big burden for me. It is not big deal. The formula for a MBTrader sell for example is: =ROUND(A233E233-26.5-(($A233E233)*0.0000333334),2) cell A233= quantity of shares e.g. 1,000 cell E233= price received (or current MTM price) e.g, 28 11/16 When the confirm comes in I adjust it for Instanet commissions and maybe 1c or 2c for rounding of the SEC fee. I have several ways I sort the file: chronologically by purchase date, alphabetically by ticker, by broker, by open vrs closed positions. I also use colors to highlight open positions and to highlight trades awaiting written confirms. Once an item is closed and confirmed in writing I make the color black. The only thing I don't have with the Excel spreadsheet is a link to real-time prices so it is marked-to-market (MTM) continuously. My eSignal has a dynamic "spreadsheet" that marks to market continuously, but I haven't been using it much lately. At the end of the year I will have my tax schedules all ready. I can sort by broker to check each of the 1099Bs that I get, I can sort by open positions for my mark-to-market computations. and I can print out a "schedule D like" report using the same columns that Sch D uses. Colin