[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EquisMetaStock Group] Re: Stock book keeper



PureBytes Links

Trading Reference Links

I think using excel is the best solution.
I found some good ideas in Mr Elder's book "come into my trading 
room". I will not change the flexibility of excel.
I have to "pages", one for the closed trades and one for the open 
ones.
For the open trades:
I have columns with date,stock name, number of shares and initial 
cost (including commissions). At the end of each day I write down 
the closing price and have excel calculate the difference (profit or 
loss) with the percentage. I also add up all the trades to know what 
is my total exposure to the market.

For the closed trades (well almost the same with the open trades)
Well you can imagine I write down the total income from the sale 
(minus the commissions) and the total profit/loss for each trade. In 
a column I calculate the total days that I was exposed and the 
anualized percentage of profit/loss. 

It is very simple but I will not change it with any ready made 
program.
Regards

--- In equismetastock@xxxxxxxxxxxxxxx, pmgoody2000 <no_reply@xxxx> 
wrote:
> what do you guys use to track your trades?  any freeware 
applications
> out there that you guys use? I've been using an excel sheet that I
> created, but looking for other(cheap) alternatives. 
> thanks in advance



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com.  Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/BefplB/TM
---------------------------------------------------------------------~->

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
     equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/