Optimization Problem
I am not sure what exactly you want, but if it is the sign of the
change in the indicator, use the SIGN function as in =SIGN(one-day-value - previous-day-value). -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hello, It's been asked of me to create a process that will take a oscillating indicator and maximize profitability based on price changes. So example data would look like the following: Date Price Indicator 1/1/04 601.32 4 1/2/04 610.03 -2 1/3/04 550.04 6 So looking at this data, they want me to calc optimized actions based on the change in Indicator (current day "Indicator" - previous day "Indicator"), so for 1/2/04 chg was -6. I figured the easiest way to go is make the actions have a range of (1, 0 and -1) and advance from there. Would anyone know of any methods that could help to accomplish this task? Thanks in advance |
All times are GMT +1. The time now is 04:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com