This is a simple test I am trying to perform on the way to a more complex
looping system.
I discovered that the following small piece of code produces a weird result
in the AA Window.
The calculated values of RSI inside the loop produce "offset results" when
sent to the AA window via the AddColumn function.
AB = CreateObject("Broker.Application");
AA = AB.Analysis;
WL = AA.Filter(0, "WatchList");
WLSyms = CategoryGetSymbols(categoryWatchlist, WL);
if (Name() == StrExtract(WLSyms, 0))
{
WLQty = 0;
for (i = 0; (Symbol = StrExtract(WLSyms, i)) != ""; i++)
{
WLQty = WLQty + 1;
SetForeign(Symbol);
RSIx = (RSI(14));
ROCx = (ROC(C, 14));
RestorePriceArrays();
}
}
RSIn = RSI( 14 );
ROCn = ROC(C,14);
Filter = 1;
Buy = 0;
AddTextColumn(Name(),"Name",1.0);
AddColumn(RSIx,"RSIx",1.2);
AddColumn(ROCx,"ROCx",1.2);
AddColumn(RSIn,"RSIn",1.2);
AddColumn(ROCn,"ROCn",1.2);
Notice the 0.00 for RSIx for DJ-30 is the values for RUT-I--the thing is
offset and I can not figure out why or what is causing this to be offset.
The i in the StrExtract command is supposed to be zero based, but the RSIx
array is getting switched (really offset) somehow.
There are only two symbols in the Watchlist. The first symbol in the
Watchlist is RUT-I, while the second is DJ-30, so the order printed is
reversed also.
Ticker Date/Time Name RSIx ROCx RSIn ROCn
DJ-30 6/20/2008 DJ-30 0.00 0.00 31.92 -5.29
DJ-30 6/23/2008 DJ-30 0.00 0.00 31.91 -4.52
DJ-30 6/24/2008 DJ-30 0.00 0.00 31.11 -4.71
DJ-30 6/25/2008 DJ-30 0.00 0.00 31.34 -6.29
DJ-30 6/26/2008 DJ-30 0.00 0.00 24.10 -6.19
DJ-30 6/27/2008 DJ-30 0.00 0.00 22.43 -7.60
DJ-30 6/30/2008 DJ-30 0.00 0.00 22.62 -7.65
RUT-I 6/20/2008 RUT-I 31.92 -5.29 46.59 -2.06
RUT-I 6/23/2008 RUT-I 31.91 -4.52 44.02 -2.60
RUT-I 6/24/2008 RUT-I 31.11 -4.71 39.34 -4.81
RUT-I 6/25/2008 RUT-I 31.34 -6.29 43.87 -6.15
RUT-I 6/26/2008 RUT-I 24.10 -6.19 37.44 -5.67
RUT-I 6/27/2008 RUT-I 22.43 -7.60 37.35 -5.05
RUT-I 6/30/2008 RUT-I 22.62 -7.65 34.57 -5.86
While you may not be that interested, I am attempting to modify some code
that FredT gave me here where I wanted to get the ordinal rank numbers for
symbols based on an indicator's value. Fred's code produced this just fine
for the last date in the From-To Range. I would like to modify the code
approach to calculate Rank Ordinals for each Bar, and this modification was
a step towards trying to accomplish that. But seeing the unexpected result
has me stopped.
Anyone care to speculate on what is going on?
Thanks,
Ken
