Mike, Thanks a bunch. Pete :-)
--- In [email protected], "Mike" <[EMAIL PROTECTED]> 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 [email protected], "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 :-) > > >
