|
PureBytes Links
Trading Reference Links
|
greg,
For H,L,C of last week:
HOLW:=ValueWhen(1,DayOfWeek()=1,HighestSince(2,DayOfWeek()=1,H));
LOLW:=ValueWhen(1,DayOfWeek()=1,LowestSince(2,DayOfWeek()=1,L));
CLW:=ValueWhen(1,DayOfWeek()=1,ValueWhen(1,DayOfWeek()=5,C));
HOLW;LOLW;CLW;
I think that'll do it.
G.
Message: 1
Date: Fri, 06 Feb 2004 14:43:42 -0000
From: "mc_gregor25" <gregory_p25@xxxxxxxxxxx>
Subject: Re: [spam] Help needed with formula
The Ft is not decalred this is the problem....
i can not find it....
greg
________________________________________________________________________
________________________________________________________________________
Message: 2
Date: Fri, 06 Feb 2004 15:11:00 -0000
From: "mc_gregor25" <gregory_p25@xxxxxxxxxxx>
Subject: Re: [spam] Help needed with formula
Thanx
Now it works but it is not what i am seraching...
greg
________________________________________________________________________
________________________________________________________________________
Message: 3
Date: Fri, 06 Feb 2004 15:15:04 -0000
From: "mc_gregor25" <gregory_p25@xxxxxxxxxxx>
Subject: Another question?????
I look for the formula which gives me the:
1 , The High of the last week.
2 , The low of the last week.
3 , The close of the last week.
Thanks
greg
________________________________________________________________________
________________________________________________________________________
Message: 4
Date: Fri, 6 Feb 2004 16:41:10 +0000 GMT
From: "on mobile" <adet@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Re: [spam] Help needed with formula
Good stuff then. What was the problem?
-----Original Message-----
From: "mc_gregor25" <gregory_p25@xxxxxxxxxxx>
Date: Fri, 06 Feb 2004 15:11:00
To:Metastockusers@xxxxxxxxxxxxxxx
Subject: [Metastockusers] Re: [spam] Help needed with formula
Thanx
Now it works but it is not what i am seraching...
greg
Yahoo! Groups Links
------------------
________________________________________________________________________
________________________________________________________________________
Message: 5
Date: Fri, 6 Feb 2004 16:40:08 +0000 GMT
From: "on mobile" <adet@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Re: [spam] Help needed with formula
It was no FT but FT-FBP. I saw it!
It was a sectional declaration. I never saw FT in your code.
Send me everything you've got and I will take a look this weekend.
-----Original Message-----
From: "mc_gregor25" <gregory_p25@xxxxxxxxxxx>
Date: Fri, 06 Feb 2004 14:43:42
To:Metastockusers@xxxxxxxxxxxxxxx
Subject: [Metastockusers] Re: [spam] Help needed with formula
The Ft is not decalred this is the problem....
i can not find it....
greg
Yahoo! Groups Links
------------------
________________________________________________________________________
________________________________________________________________________
Message: 6
Date: Fri, 06 Feb 2004 16:58:25 -0000
From: "mc_gregor25" <gregory_p25@xxxxxxxxxxx>
Subject: Re: [spam] Help needed with formula
all i have is this....
but if you separate it it works... i dont know exacttly why....
Mc1:=BarsSince(DayOfWeek()=1);
Fc1:=BarsSince(DayOfWeek()=5);
Fc2:=Ref(BarsSince(DayOfWeek()=5),-1)-1;
{Fixed Balance Point Calculation}
FBC:=If(Mc1=0 AND Fc1>2,
{then}(Ref(HHV(H,LastValue(mc1)),-1)+
Ref(LLV(L,LastValue(Mc1)),-1)+
Ref(C,-1))/3,
{else}If(Fc1=0 AND Mc1>5,
{then}(HHV(H,LastValue(Fc2))+
LLV(L,LastValue(Fc2))+C)/3,
{else}If(Fc1=0,
{then}(HHV(H,LastValue(Mc1))+
LLV(L,LastValue(Mc1))+C)/3,
{else}0)));
{Fixed Balance Point Plot}
FBP:=ValueWhen(1,FBC>0,FBC);
FBP;
{NOTE: under Color/Style options, change
plot to last "style" option}
{Weekly Price Range Calculation}
Mc1:=BarsSince(DayOfWeek()=1);
Fc1:=BarsSince(DayOfWeek()=5);
Fc2:=Ref(BarsSince(DayOfWeek()=5),-1)-1;
WRC:=If(Mc1=0 AND Fc1>2,
{then}Ref(HHV(H,LastValue(mc1)),-1)-
Ref(LLV(L,LastValue(Mc1)),-1),
{else}If(Fc1=0 AND Mc1>5,
{then}HHV(H,LastValue(Fc2))-
LLV(L,LastValue(Fc2)),
{else}If(Fc1=0,
{then}HHV(H,LastValue(Mc1))-
LLV(L,LastValue(Mc1)),
{else}0)));
WRP:=ValueWhen(1,WRC>0,WRC);
{Resistance Range}
RR1:= FmlVar("FT-FBP","FBP")+(WRP*.5);
RR2:= FmlVar("FT-FBP","FBP")+(WRP*.618);
{Support Range}
SR1:= FmlVar("FT-FBP","FBP")-(WRP*.5);
SR2:= FmlVar("FT-FBP","FBP")-(WRP*.618);
{Plot Ranges}
RR1;
RR2;
SR1;
SR2;
.........
So what i made is to intruduce this like FT-FBP
Mc1:=BarsSince(DayOfWeek()=1);
Fc1:=BarsSince(DayOfWeek()=5);
Fc2:=Ref(BarsSince(DayOfWeek()=5),-1)-1;
{Fixed Balance Point Calculation}
FBC:=If(Mc1=0 AND Fc1>2,
{then}(Ref(HHV(H,LastValue(mc1)),-1)+
Ref(LLV(L,LastValue(Mc1)),-1)+
Ref(C,-1))/3,
{else}If(Fc1=0 AND Mc1>5,
{then}(HHV(H,LastValue(Fc2))+
LLV(L,LastValue(Fc2))+C)/3,
{else}If(Fc1=0,
{then}(HHV(H,LastValue(Mc1))+
LLV(L,LastValue(Mc1))+C)/3,
{else}0)));
{Fixed Balance Point Plot}
FBP:=ValueWhen(1,FBC>0,FBC);
FBP;
and this like another indicator
{FT Weekly Price Range}
Mc1:=BarsSince(DayOfWeek()=1);
Fc1:=BarsSince(DayOfWeek()=5);
Fc2:=Ref(BarsSince(DayOfWeek()=5),-1)-1;
WRC:=If(Mc1=0 AND Fc1>2,
{then}Ref(HHV(H,LastValue(mc1)),-1)-
Ref(LLV(L,LastValue(Mc1)),-1),
{else}If(Fc1=0 AND Mc1>5,
{then}HHV(H,LastValue(Fc2))-
LLV(L,LastValue(Fc2)),
{else}If(Fc1=0,
{then}HHV(H,LastValue(Mc1))-
LLV(L,LastValue(Mc1)),
{else}0)));
WRP:=ValueWhen(1,WRC>0,WRC);
{Resistance Range}
RR0:= FmlVar("FT-FBP","FBP")+(WRP*.236);
RR1:= FmlVar("FT-FBP","FBP")+(WRP*.382);
RR2:= FmlVar("FT-FBP","FBP")+(WRP*.5);
RR3:= FmlVar("FT-FBP","FBP")+(WRP*.618);
{Support Range}
SR0:= FmlVar("FT-FBP","FBP")-(WRP*.236);
SR1:= FmlVar("FT-FBP","FBP")-(WRP*.382);
SR2:= FmlVar("FT-FBP","FBP")-(WRP*.5);
SR3:= FmlVar("FT-FBP","FBP")-(WRP*.618);
{Plot Ranges}
RR0;
RR1;
RR2;
RR3;
SR0;
SR1;
SR2;
SR3;
and it works
this is all...
thanks
greg
________________________________________________________________________
________________________________________________________________________
Message: 7
Date: Fri, 06 Feb 2004 17:10:20 -0000
From: "jim" <jimk_30045@xxxxxxxxx>
Subject: tc2k v5.3 data load problem
I am attempting to load the new cd from worden and get the following
error messages...
"you have inserted an outdated cd.Insert the most recent one"
the most recent one is the one i am trying to load...version 5.3...
after i click again i get into the program and then only get data for
a month. So i figure i have to update..so i click on update and it
appears to update the files and then I get "error building history".
so i click okay and it hangs up for a long time. i finally have to do
alt-c-del to end task and close tc2k altogether..
2 question's...going into windows explorer and going to program files
and then double clicking on tc2k...scroll down to tc2000reginfo.exe
and double click...what are your values for files\cdhistory and
files\fastcdhistory...
any help would be appreciated...thanks..jim...
________________________________________________________________________
________________________________________________________________________
Message: 8
Date: Sat, 7 Feb 2004 07:14:27 +1300
From: "Roy Larsen" <rlarsen@xxxxxxxxxxxxxx>
Subject: Re: Another question?????
Greg
> I look for the formula which gives me the:
>
> 1 , The High of the last week.
> 2 , The low of the last week.
> 3 , The close of the last week.
>
> Thanks
>
> greg
{Weekly OHLC}
{Copyright© 2003 Roy Larsen}
{rlarsen@xxxxxxxxxxxxxx}
{use on daily charts}
Q:=Input("Dynamic Current Week, Yes=1",0,1,0);
{0=Update when end of current week is known}
{1=MS compatible dynamic current week}
M:=DayOfWeek()<=ValueWhen(2,1,DayOfWeek());
F:=DayOfWeek()=5;
A:=LastValue(Cum(1)-1)=Cum(1);
B:=LastValue(Cum(1))=Cum(1);
J:=If(F,1,If(Alert(F,2)=0 AND M,2,0));
J:=If(A+LastValue(J)>2 OR B+Q>1,1,(B=0)*J);
Hw:=HighestSince(1,M,H);
Hw:=ValueWhen(1,J,If(J=1,Hw,ValueWhen(2,1,Hw)));
Lw:=LowestSince(1,M,L);
Lw:=ValueWhen(1,J,If(J=1,Lw,ValueWhen(2,1,Lw)));
Cw:=ValueWhen(1,J,If(J=1,C,ValueWhen(2,1,C)));
Ow:=ValueWhen(1,J,If(J=1,ValueWhen(1,M,O),
ValueWhen(2,M OR Cum(1)=3,O)));
Ow:=ValueWhen(1,Lw>0,Ow); {O}
Hw:=ValueWhen(1,Lw>0,Hw); {H}
Lw:=ValueWhen(1,Lw>0,Lw); {L}
Cw:=ValueWhen(1,Lw>0,Cw); {C}
{Ow;} Hw; Lw; Cw;
Roy
________________________________________________________________________
________________________________________________________________________
Message: 9
Date: Fri, 06 Feb 2004 21:35:26 -0000
From: "lseldin" <larry@xxxxxxxxxx>
Subject: Re: How to keep Optimization Variable from being optimized
Pierre,
Thanks much,
- Larry
---------------------------------------------
--- In Metastockusers@xxxxxxxxxxxxxxx, Pierre Tremblay <pt2000@xxxx>
wrote:
> Iseldin,
>
> minimum .10
> maximum .10
> step 1
>
> Pierre Tremblay
>
>
>
> lseldin a écrit:
>
> >In MetaStock 8, I created an Enhanced System Tester, I created a
> >System Test with 3 Opt variables. At this point, I want to test
each
> >variable without changing the other ones.
> >
> >I know I can delete my code that references Opt1, however, I
rather
> >just adjust the System Editor, Optimizations screen.
> >
> >
> >What I am looking for is something for Opt1 such as:
> >
> >minimum .10
> >maximum .10
> >step 0
> >
> >This does not work.
> >
> >Thanks much,
> >
> >larryTAKEOUT@xxxx
> >
> >
> >
> >
> >
> >Yahoo! Groups Links
> >
> >To visit your group on the web, go to:
> > http://groups.yahoo.com/group/Metastockusers/
> >
> >To unsubscribe from this group, send an email to:
> > Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
> >
> >Your use of Yahoo! Groups is subject to:
> > http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
> >
________________________________________________________________________
________________________________________________________________________
Message: 10
Date: Fri, 06 Feb 2004 21:25:38 -0500
From: Philip Schmitz <pschmi02@xxxxxxxxxxx>
Subject: Linking to Excel
Greetings,
I would like to link my exploration results to an excel spreadsheet. Can
you tell me how to identify the result files and where they're kept?
TIA,
Philip Schmitz
________________________________________________________________________
________________________________________________________________________
Message: 11
Date: Fri, 6 Feb 2004 21:39:40 EST
From: JayTownsend@xxxxxxx
Subject: Re: Linking to Excel
<<Greetings,
I would like to link my exploration results to an excel spreadsheet. Can
you tell me how to identify the result files and where they're kept?
TIA,
Philip Schmitz>>
I think you'll find that the MS file format is not compatible with anything
else. What I do is select one line of the Exploration report, do a Ctrl C
(copy), and paste it into Excel. By copying one line it in fact copies all lines
of your report.
Jay
[This message contained attachments]
________________________________________________________________________
________________________________________________________________________
------------------------------------------------------------------------
Yahoo! Groups Links
-----------------------------------------------------------------------
________________________________________________________________
The best thing to hit the Internet in years - Juno SpeedBand!
Surf the Web up to FIVE TIMES FASTER!
Only $14.95/ month - visit www.juno.com to sign up today!
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Metastockusers/
<*> To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|