|
PureBytes Links
Trading Reference Links
|
If you use the stock symbol, you won't have to enter current closes by
hand. You can create a Yahoo portfolio and download data as a
spreadsheet, then use Excel's Vlookup function to bring in each night's
closing prices. Excel also enables you to track events which may lead
to sell signals or "move stop" signals.
Vassilis wrote:
>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 Links
>
>
>
>
>
>
>
>
------------------------ 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/
|