Hello. Dear professionals please help in 2 tasks. How to describe these 2 occurrence in Metastock formulas. 1. If I want to trade intra-day and have HOURLY or 5-MINUTES charts, how could I get PREVIOUS DAY CLOSE in formula? 2. I want to trade only from 8.00 AM to 8.00 PM (for example). How can I write this condition to BUY or SELL rules?

Hi alextox

Try this.

{Day CLOSE}
Day:=DayOfWeek();
NewDay:= Day <> ValueWhen(2,1,Day);
DayClose:=ValueWhen(1,NewDay,ValueWhen(2,1,C));
DayClose;

Just in case the Forum decides to mangle my code here's what it says in English.

Day:=day-of-week
NewDay:= Day not equal previous bar's day
DayClose:= ValueWhen(1, NewDay, CLOSE for previous bar)
plot DayClose

This code can easily return the wrong price IF your chart is at a higher periodicity than the underlying data. If chart and underlying data are the same periodicity then there's no problem as far as I can see. The formula should still function correctly on stock data with time stamps coinciding with normal trading hours (no time stamps near midnight). On 24 hour data you very likely to have a problem. Test the formula and see if it returns the same daily CLOSE as several different chart periodicities.

Roy

Hi alextox

1. ValueWhen(2,1,Day) is functionally the same as Ref(Day,-1) - it returns Day delayed by one bar.

2. From memory the code I provided returned the CLOSE for the previous days trading. How you use that information is up to you. I don't understand what it is that you are now asking.

Roy