Passing Scan Results to Excel

   Does anybody know if it is possible to copy the results of a scan into an excel spreadsheet?

Author	Message / View First Unread Post Share Topic Printable Version Delicious Digg Facebook Furl Google Boomarks Google Buzz MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
ukipeter Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 14 Sep 2005 Location: Australia Posts: 5	Post Options Post Reply Quote ukipeter Report Post Quote Reply Topic: Passing Scan Results to Excel Posted: 19 Sep 2005 at 5:22pm
	Does anybody know if it is possible to copy the results of a scan into an excel spreadsheet?
	just starting!

Dingo Members Profile Send Private Message Find Members Posts Add to Buddy List Regular Joined: 10 Jul 2005 Posts: 35	Post Options Post Reply Quote Dingo Report Post Quote Reply Posted: 19 Sep 2005 at 6:10pm
	Run the Scan From the Scan Results; select FILE - EXPORT (exports as CSV file) In EXCEL, on a blank Worksheet, use the DATA - IMPORT EXTERNAL DATA option (need to select a COMMA as the value separator)

ukipeter Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 14 Sep 2005 Location: Australia Posts: 5	Post Options Post Reply Quote ukipeter Report Post Quote Reply Posted: 20 Sep 2005 at 9:19am
	Thanks for that. I am using the trial version and that button does not appear to be on the form!
	just starting!

pipsqueek Members Profile Send Private Message Find Members Posts Add to Buddy List Regular Joined: 03 Jan 2005 Location: Australia Posts: 34	Post Options Post Reply Quote pipsqueek Report Post Quote Reply Posted: 24 Sep 2005 at 7:30pm
	You should be able to copy your symbols with the trial version using Dingo's suggestion, but here's another method to try. Run your scan again.You should be able to see the list of stocks resulting from your scan in the scan results window. Now click on the Edit button on the top LHS of your screen. Left click "Copy Symbols" and go to your spreadsheet and paste into the appropriate spot. You can also copy the contents of any watchlist by right clicking on the name of the watchlist and then selecting "copy symbols". Good luck....
	failing to plan is planning to fail.