Thursday, September 17, 2009

Russell 3000 Daily Stats (09/17/09)

Key Figures Russell 3000 IWV
Total Active Components2973 1
Total New Listings this period0 0
Total Inactive this period0 0
# All-time Closing Highs 26 (0.87%) 0 (0.00%)
# All-time Closing Lows 0 (0.00%) 0 (0.00%)

# Higher Closes 1215 (40.87%) 0 (0.00%)
# Lower Closes 1701 (57.21%) 1 (100.00%)

Total Gains/Losses $-138.74 (-0.19%) $-0.12 (-0.19%)
Average True Range (4.04%) (1.46%)

* Results are cumulative for the period.

Price verification found 0 errors

Wednesday, September 16, 2009

Russell 3000 Daily Stats (09/16/09)

Key Figures Russell 3000 IWV
Total Active Components2973 1
Total New Listings this period0 0
Total Inactive this period0 0
# All-time Closing Highs 35 (1.18%) 0 (0.00%)
# All-time Closing Lows 2 (0.07%) 0 (0.00%)

# Higher Closes 2386 (80.26%) 1 (100.00%)
# Lower Closes 523 (17.59%) 0 (0.00%)

Total Gains/Losses $1271.15 (1.79%) $0.98 (1.58%)
Average True Range (4.14%) (1.58%)

* Results are cumulative for the period.

Price verification found 0 errors

Tuesday, September 15, 2009

Russell 3000 Daily Stats (09/15/09)

Key Figures Russell 3000 IWV
Total Active Components2973 1
Total New Listings this period0 0
Total Inactive this period0 0
# All-time Closing Highs 20 (0.67%) 0 (0.00%)
# All-time Closing Lows 1 (0.03%) 0 (0.00%)

# Higher Closes 1805 (60.71%) 1 (100.00%)
# Lower Closes 1096 (36.87%) 0 (0.00%)

Total Gains/Losses $520.78 (0.74%) $0.34 (0.55%)
Average True Range (3.80%) (1.30%)

* Results are cumulative for the period.

Price verification found 0 errors

Monday, September 14, 2009

Russell 3000 Daily Stats (09/14/09)

Key Figures Russell 3000 IWV
Total Active Components2973 1
Total New Listings this period0 0
Total Inactive this period2 0
# All-time Closing Highs 22 (0.74%) 0 (0.00%)
# All-time Closing Lows 0 (0.00%) 0 (0.00%)

# Higher Closes 2055 (69.12%) 1 (100.00%)
# Lower Closes 845 (28.42%) 0 (0.00%)

Total Gains/Losses $590.34 (0.85%) $0.34 (0.55%)
Average True Range (3.98%) (1.55%)

* Results are cumulative for the period.

Price verification found 0 errors

Sunday, September 13, 2009

Russell 3000 Weekly Stats (09/08/09-09/11/09)

Key Figures Russell 3000 IWV
Total Active Components2975 1
Total New Listings this period0 0
Total Inactive this period3 0
# All-time Closing Highs 58 (0.49%) 0 (0.00%)
# All-time Closing Lows 3 (0.03%) 0 (0.00%)

# Higher Closes 7676 (64.48%) 4 (100.00%)
# Lower Closes 3981 (33.44%) 0 (0.00%)

Total Gains/Losses $2224.89 (0.81%) $1.82 (0.75%)
Average True Range (3.95%) (1.26%)

* Results are cumulative for the period.

Price verification found 0 errors

Friday, September 11, 2009

Russell 3000 Daily Stats (09/11/09)

Total Active Components = 2975
Total New Listings this period = 0
Total Inactive this period = 1

Key Figures Russell 3000
# All-time Closing Highs 11 (0.37%)
# All-time Closing Lows 0 (0.00%)

# Stocks Closing Higher 1207 (40.57%)
# Stocks Closing Lower 1704 (57.28%)

Total Gains/Losses $-79.19 (-0.11%)
Average True Range (3.68%)


Price verification found 0 errors

Thursday, September 10, 2009

Russell 3000 Daily Stats (09/10/09)

Total Active Components = 2976
Total New Listings this period = 0
Total Inactive this period = 1

Key Figures Russell 3000
# All-time Closing Highs 17 (0.57%)
# All-time Closing Lows 0 (0.00%)

# Stocks Closing Higher 2197 (73.82%)
# Stocks Closing Lower 714 (23.99%)

Total Gains/Losses $759.08 (1.10%)
Average True Range (3.97%)


Price verification found 0 errors

Wednesday, September 09, 2009

Russell 3000 Daily Stats (09/09/09)

Total Active Components = 2977
Total New Listings this period = 0
Total Inactive this period = 0

Key Figures Russell 3000
# All-time Closing Highs 16 (0.54%)
# All-time Closing Lows 2 (0.07%)

# Stocks Closing Higher 2341 (78.64%)
# Stocks Closing Lower 579 (19.45%)

Total Gains/Losses $903.64 (1.32%)
Average True Range (4.17%)


Price verification found 0 errors

[Edit: Google Finance has a limitation of 14 symbols one can load at one time...so I had to switch to Yahoo Finance for the quote links. Actually works out better...I like the View All Charts feature that Yahoo allows.]

Tuesday, September 08, 2009

Russell 3000 Daily Stats (09/08/09)

Total Active Components = 2977
Total New Listings this period = 0
Total Inactive this period = 1

Key Figures Russell 3000
# All-time Closing Highs 14 (0.47%)
# All-time Closing Lows 1 (0.03%)

# Stocks Closing Higher 1931 (64.86%)
# Stocks Closing Lower 984 (33.05%)

Total Gains/Losses $641.70 (0.95%)
Average True Range (3.97%)


Price verification found 0 errors
[Edit: This post was corrected. Having troubles with the pricing database this week. I believe I've identified the issues...but time will tell. Most of the issues were a result of adding benchmark comparison functionality to the reporting engine. I haven't rolled out the front-end to this yet. But, once I'm sure all the issues are resolved, the stats will post with a comparison to the ETF benchmark IWV. Should always be roughly the same...but will be interesting if there are days that miss the mark.]

Sunday, September 06, 2009

Russell 3000 Weekly Stats (08/31/09-09/04/09)

Total Active Components = 2978
Total New Listings this period = 0
Total Inactive this period = 0

Key Figures Russell 3000
# All-time Closing Highs 14 (0.09%)
# All-time Closing Lows 4 (0.03%)

# Stocks Closing Higher 6731 (45.20%)
# Stocks Closing Lower 7881 (52.93%)

Total Gains/Losses $-1082.93 (-0.32%)
Average True Range (4.30%)


Price verification found 0 errors

[Edit: Post was corrected. Pricing database was incorrect and miscalculated the number of all-time highs and lows for the week.]

Portfolio Performance for August 2009

What a bad month for the portfolio. The S&P 500 is really trouncing me. And what's worse, I'm not quite sure the reason. I'm 98% invested in the market. And not trailing...actually delinking from the market. The coming months will shed more light on why the portfolio is zigging when the market is zagging.







On to other things...

You'll notice I'm posting Russell 3000 stats each day. And posting a weekly roundup each Sunday. These should become a regular thing since the whole process is now automated. Hopefully, I'll get a monthly roundup setup as well to start posting the end of this September.

At this point, not a whole lot is being tracked on the daily stats. My main goal is to use the stats as a way to ensure my pricing database is correct. At the end of the daily stats post, you'll find the following line:
Price verification found 0 errors

This line represents that out of all the Russell 3000 end of day quotes posted...none of the following errors were found for a given period:
pricerec['high'] is not less than pricerec['low']

pricerec['low'] is not greater than pricerec['high']

pricerec['close'] is not greater than pricerec['high']

pricerec['open'] is not greater than pricerec['high']

pricerec['close'] is not less than pricerec['low']

pricerec['open'] is not less than pricerec['low']

pricerec['low'] is not equal to or less than 0.00

pricerec['high'] is not equal to or less than 0.00

pricerec['close'] is not equal to or less than 0.00

pricerec['open'] is not equal to or less than 0.00


The daily stats posting also lists the number of stocks that did not receive a price quote for the day via this field:
Total Inactive this period = 0

And new listings...which are not as important for the Russell 3000 since these should only change once a year.

Of course, you can see the number of new all-time highs and lows along with a link to google finance for the corresponding stocks.

Overall, these daily stats are just an easy way to keep up with the price database each day. A stock market dashboard, if you will. With the overall goal of incorporating a portfolio dashboard into these daily stats in order to answer the question...why is my portfolio delinking from the market? Ha.

Later trades,

MT

Friday, September 04, 2009

Russell 3000 Daily Stats (09/04/09)

Total Active = 2979
Total New Listings this period = 0
Total Inactive this period = 0

Key Figures Current
# All-time Closing Highs 5 (0.17%)
# All-time Closing Lows 1 (0.03%)

# Stocks Closing Higher 2425 (81.43%)
# Stocks Closing Lower 504 (16.92%)

Total Gains/Losses $852.71 (1.27%)
Average True Range (3.87%)


Price verification found 0 errors

Thursday, September 03, 2009

Russell 3000 Daily Stats (09/03/09)

Total Active = 2979
Total New Listings this period = 0
Total Inactive this period = 0

Key Figures Current
# All-time Closing Highs 6 (0.20%)
# All-time Closing Lows 2 (0.07%)

# Stocks Closing Higher 2256 (75.76%)
# Stocks Closing Lower 647 (21.73%)

Total Gains/Losses $747.08 (1.13%)
Average True Range (3.82%)


Price verification found 0 errors

Wednesday, September 02, 2009

Russell 3000 Daily Stats (09/02/09)

Total Active = 2979
Total New Listings this period = 0
Total Inactive this period = 0

Key Figures Current
# All-time Closing Highs 1 (0.03%)
# All-time Closing Lows 3 (0.10%)

# Stocks Closing Higher 1182 (39.69%)
# Stocks Closing Lower 1717 (57.66%)

Total Gains/Losses $-223.12 (-0.34%)
Average True Range (3.85%)


Price verification found 0 errors

Russell 3000 Daily Stats - 20090901

PriceHouse Stats for the period 20090901 - 20090901

Total Active = 2979
Total New Listings this period = 0
Total Inactive this period = 0

Key Figures Current
# All-time Closing Highs 0 (0.00%)
# All-time Closing Lows 4 (0.13%)

# Stocks Closing Higher 337 (11.32%)
# Stocks Closing Lower 2607 (87.54%)

Total Gains/Losses $-1567.76 (-2.30%)
Average True Range (5.94%)

Price verification found 0 errors

Monday, August 31, 2009

Russell 3000 Daily Stats - 20090831


PriceHouse Stats for the period 20090831 - 20090831
Total Active = 2979

Total New Listings this period = 0
Total Inactive this period = 0

Closing at new all-time highs = 5 (0.17%)
Closing at new all-time lows = 2 (0.07%)

Up Closes = 531 (17.83%)
Down Closes = 2406 (80.79%)

Average True Range = 4.00%

Price verification found 0 errors

Sunday, August 30, 2009

Russell 3000 Weekly Stats - 20090828


PriceHouse Stats for the period 20090824 - 20090828
Total Active = 2979

Total New Listings this period = 0
Total Inactive this period = 0

Closing at new all-time highs = 73 (0.49%)
Closing at new all-time lows = 6 (0.04%)

Up Closes = 6815 (45.77%)
Down Closes = 7711 (51.79%)

Average True Range = 3.92%

Price verification found 0 errors

Russell 3000 Daily Stats - 20090828


PriceHouse Stats for the period 20090828 - 20090828
Total Active = 2979

Total New Listings this period = 0
Total Inactive this period = 0

Closing at new all-time highs = 9 (0.30%)
Closing at new all-time lows = 2 (0.07%)

Up Closes = 931 (31.26%)
Down Closes = 1995 (66.99%)

Average True Range = 4.09%

Price verification found 0 errors

Thursday, August 27, 2009

Russell 3000 Stats - 08/27/2009

PriceHouse Stats for the period 20090827 - 20090827
Total Active = 2979

Total New Listings this period = 0
Total Inactive Stocks this period = 0

Closing at new all-time highs = 12 (0.40%)
Closing at new all-time lows = 2 (0.07%)

Up Closes = 1433 (48.12%)
Down Closes = 1452 (48.76%)

Average True Range = 4.24%

Price verification found 0 errors

Wednesday, August 26, 2009

Russell 3000 Stats - 08/26/2009

I'll start posting stats on the Russell 3000 components each working day. This will be a work in progress. Adding new fields as I go. I still don't have it 100% tested nor 100% automated...so may miss some days or some values may be wrong. Over time...it'll get better.
PriceHouse Stats for the period 20090826 - 20090826
Total Active = 2979

Total New Listings this period = 0
Total Inactive Stocks this period = 0

Closing at new all-time highs = 15 (0.50%)
Closing at new all-time lows = 0 (0.00%)

Up Closes = 1517 (50.94%)
Down Closes = 1388 (46.61%)

Average True Range = 3.58%

Price verification found 0 errors
One last thing, tomorrow is my 15 year wedding anniversary. It has been a great 15 years...many all-time highs along with a few rough drawdowns. Exactly what life and investing are all about. What's funny is my wife and I were discussing our past anniversaries:
  • our 5 year we stayed in Galveston and they evacuated the island due to a hurricane.
  • our 10 year we stayed in a b&b in Kemah that at first looked remote and enchanting set off on its own peninsula. Which quickly turned into isolated and horror movie'esque..that is after big honkin' wharf rats scattered about outside all night long.
This anniversary we plan to keep it simple, just stay home. Of course, this upcoming front system could bring a tornado with our luck. Ha. Regardless, to my wife...thank you for the dance.
“The most wonderful of all things in life, I believe, is the discovery of another human being with whom one's relationship has a growing depth, beauty, and joy as the years increase. This inner progressiveness of love between two human beings is a most marvelous thing; it cannot be found by looking for it or by passionately wishing for it. It is a sort of divine accident, and the most wonderful of all things in life.” -- Hugh Walpole Sr.
MT