Hi, I want to create an expert/exploration in a Monthly time frame wherein I want to study how certain parameters are met in the first 5 - 7 days of the month and the rest are then dependent on how the opening was in the said period. Eg if for me if say $100 is important and and the low opens above that in the first 5 days of the month I will approach with a certain strategy day 6 onwards. If the low is lower than $100 then i will approach with a different strategy. How do I make an expert with these criteria?? Thanks for your time and support. Best Regards.

Hi, In order to determine what happened in the first 5 days of the month you would need Daily data (or Intraday, potentially). You would not be able to determine Daily values from a Monthly chart. The MetaStock formula language operates off whatever the interval in the chart is. Typically you can take smaller time interval data and compress to larger time intervals formulaically, but you cannot take larger time intervals and determine lower time interval values. Beyond the above concern, you would typically need some sort of conditional (If/Then) logic in your formulas. MetaStock's formula language supports Date/Time functions such as DayOfMonth() so you can use these to determine if a security's price meets a certain criteria on specific days. Because securities do not trade on the same days every month, you would also likely need to make the formulas a bit more dynamic to determine the first 5 trading days each month. There are various ways you could likely do this, such as: X:=ROC(DayOfMonth(),1,$) < 0; Sum(X=0,5)=4 AND Sum(L > 100,5)=5 This is a very general explanation. You would then need to take the above and combine it with your other trading rules, such as: X:=ROC(DayOfMonth(),1,$) < 0; Y:=Sum(X=0,5)=4 AND Sum(L > 100,5)=5; If(Y,condition1,condition2) So in essence we use an If/Then/Else statement. You can get even more elaborate by nesting multiple IF statements. However, all of this is moot if you want to be able to get Daily values from a Monthly chart.