[amibroker] Re: How to plot COT indicators data in AB ?

["vlanschot" <vlanschot@xxxxxxxxx>]

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 amibroker@xxxxxxxxxxxxxxx, "goedings" <goedings@xxx> 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?
>




Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/