Originally Posted by: mohamed_farahat

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?

Originally Posted by: mohamed_farahat

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:

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