Your Account  •  Become a Member  •  Help  •  Search
 Forums ›› Technically Speaking ›› Strategy (System) Design ›› too dumb

 Page 1 of 2:   1  2
 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
 man   Registered: Nov 2002 Posts: 2179 04-04-03 10:14 AM Tao using percentage instead of log doesn't change the picture. peace Edit/Delete • Quote • Complain
 Page 1 of 2:   1  2