I currently plot support and resistance zones manually on a chart like the attached image. Then I manually enter these figures into MS Excel to determine if today's price is within the Support and resistance zones. WHAT I NEED I need to calculate these support and resistance levels within MS Excel programmatically or using some sort of algorithm. I currently download daily data that includes open, high, low, and close values for each currency pair or stock symbol. So this granular data can be used to calculate what is required.