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.

Technology Stocks : Ascend Communications (ASND) -- Ignore unavailable to you. Want to Upgrade?

To: alvin ung who wrote (28924)	12/30/1997 4:49:00 PM
From: Glenn D. Rudolph	Read Replies (1) \| Respond to of 61433

To anyone using margin accounts: Whats the easiest way to factor in margin interest when you are trying to find out your cost basis for individual stocks. Thxs, Alvin, Add the margin interest onto your total purchase price. Then devide by the number of shares. Glenn

To: alvin ung who wrote (28924)	12/31/1997 9:28:00 AM
From: pae	Respond to of 61433

Alvin, I calc margin costs per position via an excel spreadsheet. First I calc what 1 day costs: #sharespriceintrate/360. Then I calc out how many days I have held it and add in commission costs. I use 1 line per position. Here a paste of the excel formula giving me my expenses per position (it updates for today's date): =IF(D3 = "","", IF(G3 = "", DAYS360(E3,TODAY())J3+9.952+D3C3/30000, DAYS360(E3,G3)J3+9.952+F3C3/30000)) column D=entry price E=entry date C=#shares G=exit date (or blank if open position) J=daily margin charge F=exit price D3*C3/30000 figures the SEC fee at exit DAYS360(E3,TODAY()) figures days since entry DAYS30(E3,G3) figures days held for a closed position 9.95 is my commission charge The references to "" check for blank cells and keep the display clean. Scary formula, but I have come to rely on it. Cheers!