Monthly Archives: August 2006

You are browsing the site archives by month.

DownloaderXL from AnalyzerXL

I was on a trial of DownloaderXL and I ordered a licensed copy yesterday. It is really a nifty tool for anyone who plays a lot in Excel and for $50, you can’t really go wrong. The package I got includes:

  • RTQuotesXL, builds a quote sheet with whatever symbols you need. Can also include charts. It gets the data from Yahoo! so have to pay Yahoo! for their real-time quotes if you want real-time in Excel. Otherwise you will get the delayed data.
  • PortfolioXL allow you to create portfolios in Excel and track buys and sells.
  • DownloaderXL is used to download historical quotes.
  • OptionsXL downloads option chains and LEAPS in Excel.

So far I am very satisfied. It works as advertised and allowed to improve my system. Ultimatly, I will probably use the API from IB‘s TWS but for now, this gets me going with little effort.

In my current setup, I rely on two worksheets in one book: Ideas and Trades. In the Idea sheet, I throw in symbols I picked up from TC2007 and I pre-fill certain things (trigger in, stop, target, size). Since this now has the last price, I rely on “Conditional Formatting” to warm me a specific symbol is passing its trigger point. In similar fashion, my Trades sheet warns me if I’m getting near my stop or near my pre-established exit.

Watchlist for August 29th 2006

Here are swing candidates and their trigger points for today:

Date Type Sym Close Trigger
8/29/2006 XEL 20.72 20.35
8/29/2006 TNP 46.97 46.61
8/29/2006 ATO 28.48 28.20
8/29/2006 TLS 13.29 13.37
8/29/2006 ASH 63.20 63.72
8/29/2006 KNTA 1.53 1.55

I will be watching for each of these to cross their trigger and than I will try to find a nice entry.

Watchlist for August 28th 2006

Here are swing candidates and their trigger points for today:

Date Type Sym Close Trigger
8/28/2006 BORL 5.52 5.29
8/28/2006 CNMD 19.64 19.31
8/28/2006 DRYS 13.50 12.07
8/28/2006 GNSS 13.77 13.71
8/28/2006 OMNI 9.33 8.62
8/28/2006 KEY 36.79 37.11
8/28/2006 MRK 40.44 40.74
8/28/2006 ONNN 5.83 6.01

I will be watching for each of these to cross their trigger and than I will try to find a nice entry.

August Trades Review

Since august is coming to an end, I decided to take some time this weekend to go over some of my trades this month. I will focus of three of them, two winning and one losing.

The first one is probably my favorite, a winning trade of SCVL opened on 08/08 at 20.85 and closed on 08/21 at 23.96. This is not incredible profits but 3.11/share is nothing to shy away from (for my needs anyway and for a beginner). I also like it because it looks like a classic swing. One negative, my entry could have been a lot lower, looking at the chart now we can see how I got in near the high for the day. An entry under 20 would have been much better. My exit was better but not perfect either, in the upper half of the range for the day.

SCVL trade in Aug 06

Read More …

Worth reading

This is worth reading today:

 

Shortlist for August 25th 2006

I am testing something new this morning. I reversed some of my PCFs and I am looking for short candidates. Looking at PCF outputs and charts, I came up with the following list:

Date Sym Trigger
8/25/2006 PPP 44.01
8/25/2006 PHM 27.92
8/25/2006 ABMD 12.63
8/25/2006 NCC 35.22
8/25/2006 GSK 53.85
8/25/2006 IMA 30.95

Once triggered, same rules apply to shorts and longs. I get in, and set a stop above the previous day’s high. The stop than follows the drop to lock-in the profits.