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

Error

 Previous Topic Next Topic
 kkrishna79 #1 Posted : Thursday, June 27, 2019 11:47:21 AM(UTC) Rank: NewbieGroups: Registered, Registered Users, Unverified UsersJoined: 1/31/2009(UTC)Posts: 7Location: MumbaiThanks: 1 times Hello,How can i plot 1*1 = 22*2=43*3=94*4=16.........from 1 to 10000 (number multiply on its own)
 Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.
 MS Support #2 Posted : Thursday, June 27, 2019 3:05:20 PM(UTC) Rank: Advanced MemberGroups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)Posts: 1,589Thanks: 50 timesWas thanked: 125 time(s) in 121 post(s) Originally Posted by: kkrishna79 Hello,How can i plot 1*1 = 22*2=43*3=94*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) Rank: NewbieGroups: Registered, Registered Users, SubscribersJoined: 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) Rank: NewbieGroups: Registered, Registered Users, SubscribersJoined: 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) Rank: Advanced MemberGroups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)Posts: 1,589Thanks: 50 timesWas 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))));`````` 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) Rank: NewbieGroups: Registered, Registered Users, Unverified UsersJoined: 1/31/2009(UTC)Posts: 7Location: MumbaiThanks: 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.