AshRhazaly
New member
- Joined
- Jul 19, 2016
- Messages
- 9
- Reaction score
- 0
- Points
- 0
Hi,
I'm relatively new to VBA and would love the community's help
For the rows that have a "Yes" highlighted, I'd need to run a loop and scan the closing prices from the date and time of the "Yes" row beginning 6:30 AM if it's the Minimum for the "Oversold" columns and if it's the maximum for the "Overbought" columns.
An example would be on cell P8. The code will check if the closing price 98 is the lowest or highest on the 15/7/2015 from 6:30am to 3:10pm, the code will check from cell F9 - F16 if 98 is the minimum(for the oversold column) or maximum value(for the overbought column). If true, the code will return a "Yes" value , if false , the code will return a "No" value. Thanks so much
I'm relatively new to VBA and would love the community's help
For the rows that have a "Yes" highlighted, I'd need to run a loop and scan the closing prices from the date and time of the "Yes" row beginning 6:30 AM if it's the Minimum for the "Oversold" columns and if it's the maximum for the "Overbought" columns.
An example would be on cell P8. The code will check if the closing price 98 is the lowest or highest on the 15/7/2015 from 6:30am to 3:10pm, the code will check from cell F9 - F16 if 98 is the minimum(for the oversold column) or maximum value(for the overbought column). If true, the code will return a "Yes" value , if false , the code will return a "No" value. Thanks so much
