Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 3/4/2023(UTC) Posts: 3
|
what is the formua to select first closing price
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960
Thanks: 91 times Was thanked: 155 time(s) in 150 post(s)
|
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?
|
|
|
|
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
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960
Thanks: 91 times Was thanked: 155 time(s) in 150 post(s)
|
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:
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.