I'm trying to create a formula to plot continuous moving averages of the highest high value, the lowest low value, and the close of each month on a daily chart. For example: Yesterday's values must be the highest high value of this month, the lowest low value of this month, and the close of yesterday. Today's values must be the highest high value of this month, the lowest low value of this month, and the close of today, etc... Last month will utilize datas only from last month and next month will utilize datas only from next month as they develope every trading day during the month, etc.
Hope it's not too confusing and many thanks and appreciation for any assistance possible.
