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

Notification

Icon
Error

Options
Go to last post Go to first unread
bikhod  
#1 Posted : Thursday, August 14, 2008 10:26:12 AM(UTC)
bikhod

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 30

Hi

I have two questions:

1. How do you get MS to plot the last highest values only. For example, take the following number sequence:

5, 6, 5.5, 7, 7, 5, 6.5, 7, 6.5, 8, 7, 7.5
I would like to plot
5, 6, 6, 6, 7, 7, 7, 7, 7, 7, 7, 8, 8, 8, 8

2. How do you get MS not to plot anything. For example, in an if statement:

if (condition is true,
plot x, i.e. only plots something when condition evaluates to true
don't plot anything)

Thanks!

wabbit  
#2 Posted : Friday, August 15, 2008 3:28:08 AM(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)
1. User either the Highest() function or the HighestSince() function, depending on the specific context.

2. You can plot nothing until the first instance when a condition occurs, and you can plot a null after the last condition, but you cannot plot something then null then another thing etc. Once an indicator returns a value it must return a value until the final time when it no longer returns a value; it cannot be switched on and off multiple times.


wabbit [:D]

bikhod  
#3 Posted : Friday, August 29, 2008 4:59:16 AM(UTC)
bikhod

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 30

Thanks.

Doesn't sound simple; as a software engineer I would be able to do this very easily in C#. Oh well.

Users browsing this topic
Guest (Hidden)
Similar Topics
How I find the last highest value without time specified (Formula Assistance)
by chunwaihome 9/14/2016 1:11:51 PM(UTC)
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.