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

Notification

Icon
Error

Options
Go to last post Go to first unread
kkrishna79  
#1 Posted : Thursday, June 27, 2019 11:47:21 AM(UTC)
kkrishna79

Rank: Newbie

Groups: Registered, Registered Users, Unverified Users
Joined: 1/31/2009(UTC)
Posts: 7
Location: Mumbai

Thanks: 1 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)

MS Support  
#2 Posted : Thursday, June 27, 2019 3:05:20 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,589

Thanks: 50 times
Was thanked: 125 time(s) in 121 post(s)
Originally Posted by: kkrishna79 Go to Quoted Post

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:

Code:
Power(Cum(1),2)

KRISHNA  
#3 Posted : Thursday, June 27, 2019 6:18:47 PM(UTC)
KRISHNA

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
KRISHNA  
#4 Posted : Thursday, June 27, 2019 6:30:50 PM(UTC)
KRISHNA

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

MS Support  
#5 Posted : Thursday, June 27, 2019 9:32:16 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,589

Thanks: 50 times
Was thanked: 125 time(s) in 121 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))));

thanks 1 user thanked MS Support for this useful post.
kkrishna79 on 7/1/2019(UTC)
kkrishna79  
#6 Posted : Monday, July 1, 2019 3:13:01 AM(UTC)
kkrishna79

Rank: Newbie

Groups: Registered, Registered Users, Unverified Users
Joined: 1/31/2009(UTC)
Posts: 7
Location: Mumbai

Thanks: 1 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
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.