Hi, I have read Larry Williams book on COT and its application to
trading. I have downloaded the historical data and have it all in one
MS Access db. Now I want the data in AB and construct the indicators.
I have been able to get the data in AB: I have exported key fields per
ticker to ASCI and imported them in AB as a new symbol basically
mapping those fields to standard o/h/l/c fields. In the ASCI wizard I
have ticked the non-quotes, allow for neg pricing etc.
The mapping is:
High -> Open interest
Open -> Nett Commercials
Low -> Nett Traders
Close -> Nett Public
>From the dataview for the new created ticker I see the data there. So
I have e.g. a ticker called "OI_GBP" which contains the key
OpenInterest data fields for British Pound.
Now come the difficulties. If I have GBPUSD as active symbol and
create a new indcator that acesses via Foreign() the ticker with COT
data ("OI_GBP") it won't plot the required fields. It seems that it
will only plot the values in the "close" field of ("OI_GBP").
Probably this is caused by the foreign() function:
wOI=TimeFrameCompress(Foreign("OI_GBP","open",1),inWeekly);
It should plot nett commercials but it plots the nett public....
Anyone?
