InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,572.85
(
0.10%
)
US TECH 100
19,963.60
(
0.59%
)
Dow Jones
39,344.79
(
-0.08%
)
Brent Oil
85.57
(
0.18%
)
Bitcoin
57,438.48
(
1.29%
)
Post# of 47148
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Conrad

Send PM Follow Ignore
Followers 13
Posts 2463
Boards Moderated 1
Alias Born 02/23/2002

Conrad

Member Level

Re: karw post# 30657

Monday, 08/31/2009 11:18:19 PM

Monday, August 31, 2009 11:18:19 PM

Post# of 47148
Karw,

The formula you can use for average share cost in the spread sheet is for example

SOM(I13:I55)/O55 . . . . (Net investment for 43 data lines)

I= Equity cost(+ or -) for each trade
O= Number of shares at the end of the run

You do not need to consider the cash first and then subtract it again. . .the sum of the equity trades is already available in the spreadsheet.

Of course you could ad the trading cost to that sum as I mentioned before and interest on cash could be subtracted form it as well.

Conrad Winkelman
What is Vortex AIMing? Look for my Vortex Discussion Forum:
http://investorshub.advfn.com/boards/board.asp?board_id=1341

Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up