First, why don't you use the odbc-plugin to link directly to the Access-db?
Second, is there a conflict between th values of the Open-field and the High/Low values, i.e. have you switched off automatic range checking? Just guessing here. PS --- In [email protected], "goedings" <[EMAIL PROTECTED]> wrote: > > 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? >
