Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I write a Macro into an IF Function?
DATA TABLE ___________________ /|\ DDE TIME / OPEN /* HIGH */ LOW / CLOSE /|\ *PRICE* Greetings. I am requesting assistance. I have a data table which contains the following columns: TIME, OPEN, HIGH, LOW, CLOSE. This information was obtained separately from a Dynamic Data Exchange, which has only one field: PRICE. My goal is to record new HIGH values in the current HIGH cell. I attempted to do so with the following: "=if(PRICEHIGH, PRICE, HIGH)" but it does not work because once PRICE dips under the old HIGH value, the old HIGH value returns. Needless to say, the new HIGH value was not recorded. I've written a macro that can perform this, but I can not monitor each data table to run the macro when required. I have sought to incorporate the macro into an IF Function, but have not yet found a way. Perhaps there is a better approach I have not thought of yet. Any assistance would be greatly appreciated. :) Thanks. -- FX42N ------------------------------------------------------------------------ FX42N's Profile: http://www.excelforum.com/member.php...o&userid=34923 View this thread: http://www.excelforum.com/showthread...hreadid=548434 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I write a Macro into an IF Function?
You could try recording a list of prices and using the Max function to find the highest value. -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=548434 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Function Macro for Nested IF | Excel Worksheet Functions |