Hi to everyone,
This is a quick query whether the MS programming code is able to carry out a specific type of time calculation.
Very simply, if I input a time on which the calculation is to begin,
say, 8.10am, and I then want to add a period of time (say, 29mins, 1hr
35mins, etc, etc) to the 8.10am and have a very simple +1 plot on the
chart when and where this time period has been calculated, I'm
wondering whether MS has the resources to do this relatively simple
sounding task.
The easy part of the code to obtain start times of, say, 8.10am on a specific day is obviously this:
sm:=Input("starting month",1,12,1);
sd:=Input("starting day of month",1,31,1);
sy:=Input("starting year",1980,2100,2008);
sh:=Input("hour", 1,24,1);
se:=Input("minute",0,60,0);
start:= sd=DayOfMonth() AND sm=Month() AND sy=Year() AND sh=Hour() AND se=Minute();
However, as I stated above I don't know of a way of simply adding, say,
29 minutes to a start time such as 8.10am and I'm wondering whether the
MS code has the resources to do this or whether I'd need to create an
external dll.
To those who may be interested, numbers to add to the start such as 29
minutes are square roots of Fibonacci numbers in a simple additive
sequence. These square root calculations can be done outside of the MS
code and can simply be plugged in later. The main problem is knowing
what to do with the code (if it can be done) to add them to selected
starting times such as 8.10am.
The whole thing is pretty easy to create in Excel, but I wanted to do
it in Metastock Pro to do some real-time testing on very short term
charts (1m ideal). The automated signals that would be produced through
the "+1 plot" are much easier to work with than having to move back and
forth from Excel to the charts. Besides, if the extension of these
square root calculations from daily charts to the intraday timeframe
does work (to be determined after sufficient testing), the calculations
will need to be automated in any case because they need to be updated
throughout the trading day and this is too laborious to do in Excel.
Thanks in advance if anyone is able to help ...
Peredur
