 |
man
Registered: Nov 2002
Posts: 2179 |
04-03-03 04:35 PM
to figure that out. I build three time series for daily data on the spx. I calculate ln(Ht0/Ot0), ln(Lt0/Ot0) and finally ln(Cto/Ot0). Thus I have three percentages each day for the High, Low and Close, all three referenced to the open.
Now when I build correlations among them I find high correlations between high/open:close/open as well as for
low/open:close/open. They are between 0.7 and 0.8 and I do not understand why they exist. Why is the relation between High and Open highly correlated to the relation between close and open, plus the same for Low to open???
It must be wrong and stupid and I do not see why? Anyone an idea, since I really seem to have a blackout on this.
peace
|
| |
|
Edit/Delete • Quote • Complain |
theTaoTrader
Registered: Feb 2003
Posts: 189 |
04-03-03 05:07 PM
The problem lies the use of logarithm (I assume your "Ln(Ht0/Ot0)" means you take log of the ratio of Ht0/Ot0). Since Ln(Ht0/Ot0)=Ln(Ht0) - Ln(Ot0), the reference point of opening price has been canceled out. So these correlations are saying if today's high (or log of high, to be more precise) is higher than yesterday's high then 70% to 80% the time today's low is also higher than yesterdays' low, which makes sense. Try re-run the correlations using Ht0/Ot0 and Lt0/Ot0 without log. Hope this helps.
|
| |
|
Edit/Delete • Quote • Complain |
BKuerbs
Registered: Oct 2001
Posts: 531 |
04-03-03 06:26 PM
Have a look at the range: That is the difference between High and Low, R = High - Low.
When the range is large, chances are LN(H/O) is large ditto for the other relations and when the range is low all these relations have a small value. That's all.
I have not looked at these relations too closely, the only thing I looked at was the relation H/C during up and down trends.
Regards
Bernd Kuerbs
|
| |
|
Edit/Delete • Quote • Complain |
man
Registered: Nov 2002
Posts: 2179 |
04-04-03 07:20 AM
Tao
I will try as you say (I am currently just not at the computer I use to do this). But hence that your final explanation can hardly be valid, since I do not have any reference to yesterday at all. I took the log, since I am used to and with this small numbers it usually does not make any difference.
It is still not completely clear to me, but thanks for posting. I come back once I know.
peace
|
| |
|
Edit/Delete • Quote • Complain |
man
Registered: Nov 2002
Posts: 2179 |
04-04-03 07:22 AM
Bernd
I am currently making quite different things in that field. range depending on trend, daily intradaychange, overnight change - it is rather interesting stuff.
I am not sure with your explanation - the correlations are much too high. I still think I did some really stupid mistake that I am too blind to see.
peace
|
| |
|
Edit/Delete • Quote • Complain |
| Receive
an email whenever a new post is added to this thread by subscribing
to it. |
|
|
|
|
