logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Knowland  
#1 Posted : Saturday, April 21, 2012 1:03:00 PM(UTC)
Knowland

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/15/2008(UTC)
Posts: 8

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

Any input to the following will be greatly appreciated:

a1:=Mov(C,50,E);

a2:=Mov(C,20,E);

a3:=Mov(C,10,E);

{Plot}

If(a2>a1,6,0);

If(a3>a2,4,0)

Instead of plotting vertical lines (i.e. histogram) from 0-6 and 0-4, how can I code it to plot a histogram that ranges 4-6 and 2-4 for the second one?

wabbit  
#2 Posted : Saturday, April 21, 2012 7:56:11 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
You have to play with the order in which the parts of the indicator are plotted using, the first plotted is the "bottom" of the pile, then each "layer" goes on top of the previous "layer" until the final "layer". Format the layer components as required:

Code:

a1:=Mov(C,50,E);
a2:=Mov(C,20,E);
a3:=Mov(C,10,E);

{Plot}
(a2>a1)*6;
4; {histogram, same as background colour}
(a3>a2)*4;
2; {histogram, same as background colour}




wabbit [:D]

Knowland  
#3 Posted : Sunday, April 22, 2012 3:01:34 PM(UTC)
Knowland

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/15/2008(UTC)
Posts: 8

Thanks wabbit. Pretty clever!..didn't cross my mind to do the horizontal line with the same background color. By the way, why would other indicators or a security that are the last to be overlaid onto this histogram window, upon closing and restarting MS, they are now overlaid by the histograms, then I need to cut and paste to have them displayed on top of the histograms?
wabbit  
#4 Posted : Sunday, April 22, 2012 5:57:58 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Knowland wrote:
By the way, why would other indicators or a security that are the last to be overlaid onto this histogram window, upon closing and restarting MS, they are now overlaid by the histograms, then I need to cut and paste to have them displayed on top of the histograms?


All versions of MS have always been 'buggy' in the way that templates are created and stored. You can spend a lot of time formatting things until they are perfect, save the work as a template, then apply that template to another chart and it's appearance and the order of the indicators and data is not retained.


wabbit [:D]

Knowland  
#5 Posted : Sunday, April 22, 2012 9:07:32 PM(UTC)
Knowland

Rank: Newbie

Groups: Registered, Registered Users
Joined: 3/15/2008(UTC)
Posts: 8

That pretty much explains it. Thanks again.
Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.