[amibroker] Re: Create Export File to Match IB Import Requirements

["Pete" <dryheat3@xxxxxxx>]

Mike, Thanks a bunch. 

  Pete  :-)

--- In amibroker@xxxxxxxxxxxxxxx, "Mike" <sfclimbers@xxx> wrote:
>
> Write a simple exploration and run it against the watchlist. Then 
> export the result as a .csv file. Technically, you would still have 
> the manual step of having to remove the header line from the 
> resulting file. But it's pretty close.
> 
> Something along the lines of:
> 
> Filter = 1;
> SetOption("NoDefaultColumns", true);
> AddTextColumn("SYM", "Import");
> AddTextColumn(Name(), "Symbol");
> AddTextColumn("SMART", "Exchange");
> ...
> 
> Otherwise, you could make use of fopen, fputs, fclose and write the 
> file yourself from code without the header line. Run the following as 
> a Scan.
> 
> Buy = Sell = Open = Close;
> Filter = 1;
> 
> fh = fopen("data.csv", "a");
> 
> if (fh) {
> 	fputs("SYM, " + Name() + ", SMART\n", fh);
> 	fclose(fh);
> }
> 
> Just be sure to delete the file after each run so that you don't keep 
> appending to the existing file. You may be able to clean it up, but 
> the idea is there.
> 
> Mike
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "Pete" <dryheat3@> wrote:
> >
> > I was wondering if there is a way to configure an exploration or use
> > some other tool to take a watch list and export it into a format 
> ready
> > to be imported in IB's TWS.
> > For instance:
> > For regular stocks the .csv or .txt file must be configured as such:
> > SYM, XYZ, Exchange
> > 
> > Where 'SYM' tells TWS you are importing a ticker symbol, 'XYZ' tells
> > TWS the ticker, and 'Exchange' tells TWS how you would like trades 
> for
> > this ticker routed. The default I would use for this would 
> be 'SMART'. 
> > 
> > Let me know if any of you have figured out an easy way to do this 
> that
> > doesn't require manually adjusting the file before importing into 
> TWS.
> > Thanks.
> > 
> >   Pete  :-)
> >
>



------------------------------------

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/