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

["Mike" <sfclimbers@xxxxxxxxx>]

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@xxx> 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/