I’d like a custom column showing how often a stock has gained/declined $1 in a trading day over an X time frame. Ex: ABC open at $9, close at $10.30. DEF open at $12.50, close at $11.25.
Marked as spam
Thanks for posting this again in the Watchlist topic. The previous post has been deleted so we need all of the details included in this post. For the examples you provided, you would want the column to display a value of 1 for ABC and a value of -1 for DEF? Please explain what is "over an x time frame".
Is it possible for the time frame to have a customized input? Sometimes I'd like it to be over 5 days while other times over a month. Yes on the display value. For example, let's say ABC stock has had 12 +1$ and 5 -$1 moves, I'd like two columns so that I can see the comparison. Thanks again Pete!
I'm not sure you realize the level of detail required for this specification. Might seem very simple to you but as I look at this I find many different paths one could follow to arrive at a solution. Each of them resulting in vastly different outcomes. Every computation has at least two components. In this case I have no idea where the starting and ending points are for your first computation. Do we measure from the previous day close to the current day's high/low? The previous day's close to the current day's close? The current day's open to the current day's close? The current day's open to the current day's high/low? What if a stock gains $1 and then declines $1, does that day get a value of $0 or is it counted as plus 1 in one column and minus 1 in the other. I could go on but I will run about of space to type.
My bad Pete. I'm looking for the previous day's close to the current day's close. Example over the past month: APPL Pos $1: 8. Neg $1: 3
Please log in to post questions.