Support Board
Date/Time: Tue, 26 Nov 2024 02:31:29 +0000
Post From: Calculating Price Change Since Last Alert
| [2024-01-18 09:33:23] |
| pjk0225 - Posts: 34 |
|
I figured out how to achieve what I want using simple alerts. What do you mean it disappears when you recalculate the chart. Are you entering the formula in cell K3?
Yes, in cell K3. When I press ctrl+INS on the chart, the formula disappears. I have to press ctrl+INS each time I make an adjustment to my studies because a lot of the study cells (starting from AA) show as blanks if I don't. Pressing ctrl+INS populates them correctly. Also, you would need to use the absolute reference for the rows, such as K$3:K$200000.
I'm not comfortable referencing columns like this, because adding a new study can potentially shift the columns and affect the formulas. Isn't it possible to reference the studies directly with their study IDs (id_.sg_)?
|