Passing Scan Results to Excel |
Post Reply |
Author | |
pipsqueek
Regular Joined: 03 Jan 2005 Location: Australia Posts: 34 |
Post Options
Quote Reply
Topic: Passing Scan Results to Excel 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.
|
|
ukipeter
Newbie Joined: 14 Sep 2005 Location: Australia Posts: 5 |
Post Options 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!
|
|
Dingo
Regular Joined: 10 Jul 2005 Posts: 35 |
Post Options 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
Newbie Joined: 14 Sep 2005 Location: Australia Posts: 5 |
Post Options Quote Reply 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!
|
|
Post Reply |
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |