View Full Version : Mkt price close to Moving average

05-11-2006, 08:11 AM
Hi guys I am stuck again. Here is the problem. I want to be alerted when the market price is within 05 cents of the SMA. I can use conditional formating to change the color of the result. I do not know how to make a column to show what I am after. Can you help with this. Thanks for your time. I would like the result to be a dollar figure rather than a Percent but I will take anything

05-11-2006, 12:17 PM
Are you working with formulas or VBA?
In general, it sounds like you want something like:

If(ABS(SMA - ClosingPrice) <= 0.05, then ...