![]() |
Passing Scan Results to Excel |
Post Reply ![]() |
Author | |
pipsqueek ![]() Regular ![]() Joined: 03 Jan 2005 Location: Australia Posts: 34 |
![]() ![]() ![]() ![]() 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 |
![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() |
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 |