Dark Theme
Light Theme
Trading Articles
Article Categories
Article Tools
Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to
register in order to view the content of the threads and start contributing to our community.
It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
median line
Updated September 11, 2012
trending_up
6,195 views
thumb_up
2 thanks given
group
3 followers
forum
13 posts
attach_file
3 attachments
median line
September 10th, 2012, 03:05 PM
Kolkata+India
Posts: 27 since Aug 2012
Thanks Given: 10
Thanks Received: 1
TheTrend
Apply this code to an exploration for a ticker.
In the 2nd Col you'll see the date of the yearly high or low IF the 3rd or 4th column is different from 0.
Code
NewHigh = H > Ref(HHV(H,250),-1);
NewLow = L < Ref(LLV(L,250),-1);
Filter =1;
AddColumn(IIf(NewHigh,H,0) ,"Yearly High ?");
AddColumn(IIf(NewLow,L,0),"Yearly Low ?");
Hope that helps.
thanx for the code. it explores all the quotes for the desired time period and post all result.
can i filter the zero result and get only the hi or lo dates.
wud i use any filter or put any condition?
regards
sr
Can you help answer these questions from other members on NexusFi?
Best Threads (Most Thanked) in the last 7 days on NexusFi
September 10th, 2012, 03:10 PM
Paris, France
Experience: Advanced
Platform: Amibroker
Trading: Futures, Stocks
Posts: 95 since Jun 2011
Thanks Given: 118
Thanks Received: 105
sr114
thanx for the code. it explores all the quotes for the desired time period and post all result.
can i filter the zero result and get only the hi or lo dates.
wud i use any filter or put any condition?
regards
sr
You can filter that in Excel very easily or re-formulate the code to give you buy or sell signals and then run a scan i/o an exploration.
September 10th, 2012, 03:31 PM
Paris, France
Experience: Advanced
Platform: Amibroker
Trading: Futures, Stocks
Posts: 95 since Jun 2011
Thanks Given: 118
Thanks Received: 105
Actually no need to run a scan, just use this updated code for exploration:
Code
NewHigh = IIf( H > Ref(HHV(H,250),-1),1,0);
NewLow = IIf(L < Ref(LLV(L,250),-1),1,0);
Clr = IIf(NewHigh,colorGreen,colorRed);
Filter =NewHigh ==1 OR NewLow ==1;
AddColumn(IIf(NewHigh,H,L) ,"Yearly High / Low",1.2,colorDefault,Clr);
It gives you 1 column with green cells for highs and red cells for lows, how nice is it ?
September 11th, 2012, 12:23 AM
Kolkata+India
Posts: 27 since Aug 2012
Thanks Given: 10
Thanks Received: 1
TheTrend
Actually no need to run a scan, just use this updated code for exploration:
Code
NewHigh = IIf( H > Ref(HHV(H,250),-1),1,0);
NewLow = IIf(L < Ref(LLV(L,250),-1),1,0);
Clr = IIf(NewHigh,colorGreen,colorRed);
Filter =NewHigh ==1 OR NewLow ==1;
AddColumn(IIf(NewHigh,H,L) ,"Yearly High / Low",1.2,colorDefault,Clr);
It gives you 1 column with green cells for highs and red cells for lows, how nice is it ?
The Trend
thats was a big help for me. a heartfelt gratitude for u
regards
sr
Last Updated on September 11, 2012