your question can be well answer in this ads http://finance.groups.yahoo.com/group/amibroker/message/148126 and thanks to Herman....
Unfortunately the above using DateNum which is not continous number....so we could not add 77days to DateNum.... The "DaySince1990" is good because of it is continuous, but we can not solved 100% in logics below: 1. Today Date is changed to DAYSSINCE1990 formula, and get Var_A 2. Var_B = Var_A + 77; 3. Changed Var_B to DATEON77DAY; ....How to do the Step 3? Regards --- In [email protected], "tuzo_wilson" <j.tuzo.wil...@...> wrote: > > --- In [email protected], "Kusnady" <sawios@> wrote: > > > > 77 trading days ahead from Today...means around next three month excluding > > Friday, Saturday and Sunday.... > > A question: how can we know what trading days will occur in the future? It > is not the same thing as a standard calendar since different regions can have > different trading days. > > If we just go with 77 calendar days ahead excluding Friday, Saturday and > Sunday then you should be able to get that using VBScript's DateAdd ( > http://msdn.microsoft.com/en-us/library/cb7z8yf9%28VS.85%29.aspx ) and AFL > Scripting Host. But then you'll still need to exclude Fri., Sat. and Sun. > and determine the "rounding rules". If you land on a Friday does that mean > your date will be Thursday or Monday? > > And if you really want to exclude Holidays then you will have to store those > dates somewhere and then exclude those dates as well. > > > Tuzo >
