MONEY: Figuring the market

Tuesday, March 6, 2007

There no “flux”. It’s a cyclic bull inside secular bear market. Yeah, I know “wt…”!

The secular trend (aka the channel) is the very long term trend. It’s bearish. It’s generally accepted that that long term trend is to lower valuations. PEs are at record highs. Oil is creeping back up. The Chinese are out of balance in trade. AND, the gooferment has several structural financial problems — out of balance budget, mounting debt, war costs, inflation, medicare costs escalating, medicare’s drug benefit, social security is unfunded, government pensions, government benefits — that make for bad news! The secular trend is evidenced by lower highs and lower lows. The cyclic trend is bullish(aka were going up inside the channel). There is no evidence of “bad news”. Business still are showing profits. Albeit slowing, but still profits. The structure of the economy seems to be good enough to support the normal course of business.

So, we are looking at is oscillation inside a channel that is sloped down. Watch the charts as the daily results bounce between the boundaries.

What should someone do?

Depends upon your age, and what kind of money it is.

If we are talking tax-deffered retirement money for a young person, then you want to be fully diversified, fully advantaged, and tactically shifting the mix as it seems fitting. If we are talking non-tax-deffered, then one has to be less careful (i.e., losses are deductible). A non-market-timer, buy and hold, average joe should be really careful in this environment. We’re going down. The only question is how far, how fast, and when.

My personal strategy, and I’m an old fart, that doesn’t have the ten years for the market to come back, is to in April 15th, take a conservative position with ½ maybe even more of ALL retirement and non-retirement money. I am expecting that all the IRA contributions to support the market thru April. Like deal or nodeal, I like to look at the upside versus the downside. With the S&P, and most metrics at near records, with PEs in the stratosphere, I postulate ex-cathedra from my belly button, is upside 1500 from 1350 and downside 900 from 1350. Numbers are approximate. That’s 11% up and 33% down.

So, I’d be very careful about taking a big loss in a retirement account.

In tax-protected accounts, I’m moving half or more to cash in April.

In taxable account, I’m confused. If I sell to move to cash, I’ll have to pay taxes ~25%. If the downside is 33%, then the loss would be 8%. I’m much more tempted to roll the dice. I’m reviewing each holding and trying read the entrails of the chickens to determine how the individual will fare in the downdraft.

Hopefull, if you’ve read my book,

https://reinkefj.wordpress.com/2006/06/30/muny-mental-lock-in-or-training-elephants/

then there is no single investment that will put a hole below the waterline.

I try to think about pyramid. Emergency fund and savings should be untouched by any down draft in the market.

If you’re efund and savings are defective, then that’s a different problem.


WRITING: Trying to “claim” my blog

Tuesday, March 6, 2007

To whom it may concern:

I’ve been trying to claim my wordpressblog reinkefaceslife. I’ve been able to do it on Technoratti. I’m pretty tech, but I can’t just seem to make it click on bloglines. What am I missing?

As an IT exec, I’d say that the process is flawed. If you have diagnostics, they aren’t apparent to me. So for example, if there is a two step check, then there should be two distinct red / green lights would be a good start. The site really should have a diagnostic mode that reports or journalize the steps that it is “seeing”.

Then, maybe I’d have a clue what is wrong.


RANT: Red light cameras for nu jerzee

Tuesday, March 6, 2007

Today on 1015, they reported that red light cameras are the latest revenue raising idea in trenton.

Argh!

Despite the fact that I was just in an accident caused by an illeagal left turn, I am still opposed to the automatic ticketing.

I’m less concerned about the camera. I am concerned about the gang in trenton finding a new way to rob us. I’m sure that they wouldn’t shorten the yellow to raise money.

We can have cameras on the roads, just as soon as they put them in the politician’s offices, homes, and hangouts.

Argh!


INTERESTING: Sorting in Excel

Tuesday, March 6, 2007

>>> Oh well, the favor involves an Excel spreadsheet that I am using to
>>> keep track of the team’s standings. I have a formula in there to
>>> calculate Win-Loss percent as you will see, but what I would also like
>>>each table (AL East, AL West, NL East, NL West) is sort the teams
>>>according to W-L percentage.
>>>
>>> I think what my problem is..is that I am trying to sort ‘within’ the
>>> spreadsheet, ie, just certain cols and rows. If I made each table
>>> (e.g. AL East) a separate spreadhseet then I suppose I could do it.
>>> Well don’t spend too much time on it…(you are too expensive for
>>> me)…I just thought I would give it a try.

>> I copied your sheet 1 to sheet2.
>> I removed your extra columns, merged cells, and two hidden merged cell
>> columns.
>> I “equalized” in column width all cells.
>> I then selected each range to be sorted. Did “data”
>> “sort” “PCT” for the range.
>> I repeated that for each one of the four ranges.
>> I think that is what you were trying to do.
>> It should be possible to code a macro to sort all four ranges
>> automagically.
>> (But you said don’t spend a lot of time.)

>That was great, thanks so much! So it looks like after I make an update,
>that all I have to do is then highlight the range to be sorted, and Select
> Data, Sort. I gave it a test and it worked great.
>
>My next challenge will be to try and write a macro to calculate the GB
> (Games Back)! Thanks again John, I knew you would know how to do that.

http://www.math.utoronto.ca/mathnet/questionCorner/baseball.html

*** begin quote ***

UNIVERSITY OF TORONTO MATHEMATICS NETWORK
Question Corner and Discussion Area
How To Compute Standings In Baseball
Asked by David Tobey on October 6, 1997:

In sports statistics, namely baseball, how do you calculate the number of games that a second place team is behind the first place team? This is easy if both teams have played the same number of games, but if they have not played the same amount, it isn’t so clear. This sounds like a fascinating mathematical question for a math fan and sports buff. I have come up with a few scenarios, but never have seen a definitive formula.

*** end quote ***

Their Answer:

image574

===

My summary: The original question taught me that sorting in Excel can not handle “hidden columns” (i.e., width set to zero — a consultant’s trick), columns of unequal width, and merged cells. Interesting facts I was unaware of. The effort was time stopped before I learned how to sort four ranges on the same page. I assume a macro, but I’ll bet named ranges might work as well since all sort on the same “pct”. Finally, the heavy lifting of calculating games behind was solved nicely by the University of Toronto. Thanks to the folks there. Finally that was interesting because they don’t play baseball. :-) For all those kids who went to gooferment skool, that formula is (I guess) the Canadian way of writing the generalized solution to a quadratic equation. Also interesting.

An interesting interesting exercise.