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

Notification

Icon
Error

Options
Go to last post Go to first unread
mohamed_farahat  
#1 Posted : Thursday, April 6, 2023 3:03:41 PM(UTC)
mohamed_farahat

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 3/4/2023(UTC)
Posts: 3

what is the formua to select first closing price 

MS Support  
#2 Posted : Thursday, April 6, 2023 7:49:49 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Originally Posted by: mohamed_farahat Go to Quoted Post

what is the formua to select first closing price 

Hi,

Can you describe what you mean in more detail? Are you referring to an Intraday chart and taking the first price bar of the day (at a particular interval)? The first price bar loaded into a chart?

mohamed_farahat  
#3 Posted : Friday, April 7, 2023 9:54:35 AM(UTC)
mohamed_farahat

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 3/4/2023(UTC)
Posts: 3

i want to make a filter that depending on the initial data on the chart, i means the first close price of the stock, so how to write this as a formula in the filter
MS Support  
#4 Posted : Friday, April 7, 2023 2:46:03 PM(UTC)
MS Support

Rank: Advanced Member

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

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)

Originally Posted by: mohamed_farahat Go to Quoted Post
i want to make a filter that depending on the initial data on the chart, i means the first close price of the stock, so how to write this as a formula in the filter

Identifying the first period of data will ultimately depend on how much data you load into a particular tool, whether that is the Explorer or a chart. There is no option to query an IPO date for example. So in the case of the Explorer, if you increase the records to Load, this will change the "first record" you can identify.

The following formula would identify the 1st record's close based on the amount loaded:

Code:
ValueWhen(1,Cum(1)=1,C)

1 is esentially a "True" statement. So if you cumulate a True statement over every data point, you get an upward sloping line that represents the records loaded. If you look for Cum(1) = 1, you are identifying the first data point where this always true condition begins, or essentially the first bar loaded.

Edited by user Friday, April 7, 2023 2:50:27 PM(UTC)  | Reason: Not specified

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.