Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/31/2009(UTC)
Posts: 18
Location: Mumbai
Thanks: 2 times
|
Hello, How can i plot
1*1 = 2 2*2=4 3*3=9 4*4=16 ......... from 1 to 10000 (number multiply on its own)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,999
Thanks: 96 times
Was thanked: 159 time(s) in 154 post(s)
|
Originally Posted by: kkrishna79  Hello, How can i plot
1*1 = 2 2*2=4 3*3=9 4*4=16 ......... from 1 to 10000 (number multiply on its own)
Are you wanting something that increases with each price plot? If so you could try:
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/5/2008(UTC)
Posts: 2
|
Hello sir,
i am looking to plot square root value of all number as parallel line on chart.
for eg
1*1 = 2
2*2=4
3*3=9
4*4=16
Want to plot value 2,4,9,16,25,.... and so on chart
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/5/2008(UTC)
Posts: 2
|
THIS IS WHAT I DESIGN
======================================
Y:=Input("Square Root", 1, 10000, 20);
A:= (Y+5) * (Y+5);
B:= (Y+4) * (Y+4);
D:= (Y+3) * (Y+3);
F:= (Y+2) * (Y+2);
G:= (Y+1) * (Y+1);
I:= Y * Y;
J:= (Y-1) * (Y-1);
K:= (Y-2) * (Y-2);
M:= (Y-3) * (Y-3);
N:= (Y-4) * (Y-4);
Q:= (Y-5) * (Y-5);
A;
B;
D;
F;
G;
I;
J;
K;
M;
N;
Q;
================================
NOW I CAN HAVE SQUARE ROOT MULTIPLE OF A NUMBER INPUT AT " Y "
THAN 5 UPPER VALUE AND 5 LOWER VALUE.
Practically i am looking to plot all square root multiple from 1 to 200 numbers on chart.
THIS IS GANN SQUARE OF 9 PLOT ON CHART .
HOPE I AM ABLE TO EXPLAIN WHAT I WANT.'
THANKYOU SIR
Edited by user Thursday, June 27, 2019 6:34:08 PM(UTC)
| Reason: LITTLE SPACE
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,999
Thanks: 96 times
Was thanked: 159 time(s) in 154 post(s)
|
I had one of our formula writers take a look and it was suggested that the following formula may be closer to what you are looking for. You could expand the formula up to 9 lines in each direction. Code:X:=Input("Square Root",1,9,5);
(X+4)*(X+4) + LastValue(Ref(0, +LastValue( Max(4-X,0))));
(X+3)*(X+3) + LastValue(Ref(0, +LastValue( Max(3-X,0))));
(X+2)*(X+2) + LastValue(Ref(0, +LastValue( Max(2-X,0))));
(X+1)*(X+1) + LastValue(Ref(0, +LastValue( Max(1-X,0))));
(X)*(X);
(X-1)*(X-1) + LastValue(Ref(0, +LastValue( Max(1-X,0))));
(X-2)*(X-2) + LastValue(Ref(0, +LastValue( Max(2-X,0))));
(X-3)*(X-3) + LastValue(Ref(0, +LastValue( Max(3-X,0))));
(X-4)*(X-4) + LastValue(Ref(0, +LastValue( Max(4-X,0))));
|
 1 user thanked MS Support for this useful post.
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/31/2009(UTC)
Posts: 18
Location: Mumbai
Thanks: 2 times
|
Thank you for coding...
I am also looking for each and every Yearly HIGH & LOW horizontal line on Daily chart across the years of data.
If possible please help me.
Regards,
Krishna
|
|
|
|
|
|
| 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.
