home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.xmission.com
/
2014.06.ftp.xmission.com.tar
/
ftp.xmission.com
/
pub
/
lists
/
canslim
/
archive
/
v02.n1430
< prev
next >
Wrap
Internet Message Format
|
2001-06-02
|
45KB
From: owner-canslim-digest@lists.xmission.com (canslim-digest)
To: canslim-digest@lists.xmission.com
Subject: canslim-digest V2 #1430
Reply-To: canslim
Sender: owner-canslim-digest@lists.xmission.com
Errors-To: owner-canslim-digest@lists.xmission.com
Precedence: bulk
Content-Transfer-Encoding: quoted-printable
X-No-Archive: yes
canslim-digest Sunday, June 3 2001 Volume 02 : Number 1430
In this issue:
Re: [CANSLIM] canslim.net screen
Re: [CANSLIM] canslim.net screen
Re: [CANSLIM] canslim.net screen
Re: [CANSLIM] canslim.net screen
Re: [CANSLIM] canslim.net screen
Re: [CANSLIM] canslim.net screen
----------------------------------------------------------------------
Date: Sun, 3 Jun 2001 15:38:23 -0700
From: "Tracie Oken" <imtoken@yahoo.com>
Subject: Re: [CANSLIM] canslim.net screen
The difference maybe that I am on Word 2000 (but Excel 97). When I copy the
screen starting with AAS it automatically pastes as a nice, clean table in
Word. When I try to grab the whole table (including the headings) it is
unusable. I use Word 97 at the office and will try experiment with it over
the next couple of days.
- ----- Original Message -----
From: "Norman" <theboyd@tisd.net>
To: <canslim@lists.xmission.com>
Sent: Sunday, June 03, 2001 3:03 PM
Subject: Re: [CANSLIM] canslim.net screen
> Hey Jay,
>
> Thanks for the input. Unfortunately I have already tried this method
> without luck. When I paste into Word 97 I get only the text with no table
> formatting. This makes it impossible to select a column and copy to the
> clipboard.
>
> However, when I just tried grabbing the whole table, HEADINGS AND ALL, it
> preserved the table settings with no vertical or horizontal lines. Now I
> can copy the first column to a worksheet. Wow!
>
> I am interested in how you were able to make it work by leaving out the
top
> headings and starting your copy with AAS. I wonder if there is a Word
> setting that forces paste function to retain the table formatting?
>
> Thanks again, from all of us.
>
> Norman
>
> ----- Original Message -----
> From: "Jay Oken" <imjoken@mindspring.com>
> To: <canslim@lists.xmission.com>
> Sent: Sunday, June 03, 2001 4:40 PM
> Subject: Re: [CANSLIM] canslim.net screen
>
>
> > Norman,
> >
> > Here is a way to import a screen into Excel from Canslim.Net. I would
> > suggest printing this out so you have a reference as you try it. It
really
> > isn't as hard as it may seem and will go quickly after you use it a time
> or
> > two.
> >
> > 1. Go to the screen and highlight the table you want to extract. For
> example
> > the breakout list today starts with AAS and ends with TRR (page 1). Left
> > click at the beginning of AAS and drag your mouse to the bottom right
hand
> > corner of the last column for TRR.
> >
> > 2. With your mouse over the table highlighted, Right click and select
> > Copy.
> >
> > 3. Go into MS Word, Right click on a blank document and select paste.
> MS
> > Word will now have created a table from the screen you just copied on
> > Canslim.Net.
> >
> > 4. Above the table (your mouse will turn into a downward pointing
> arrow),
> > left click on the symbols column with the symbols to highlight it (you
can
> > also drag the mouse to the right and select all the columns). Right
click
> > and select Copy.
> >
> > 5. Go into Excel and Right click on any cell (preferably A1) and
select
> > Paste Special. At the bottom of the dialogue box select Text and click
> O.K.
> > You will now have the column (or table) in a usable Excel worksheet.
> >
> > Note that if you skip the step of importing into MS Word, and try to
copy
> > directly into Excel, you will not get a user friendly worksheet. Also,
you
> > can not get the column headings. You could, of course, set up a
template
> in
> > Excel with the column headings in row 1 and then paste from MS Word into
> > cell A2.
> >
> > Hope this helps.
> >
> >
> >
> > ----- Original Message -----
> > From: "Norman" <theboyd@tisd.net>
> > To: <canslim@lists.xmission.com>
> > Sent: Sunday, June 03, 2001 12:25 PM
> > Subject: Re: [CANSLIM] canslim.net screen
> >
> >
> > > Hey Perry,
> > >
> > > Yes, great site for the price :-)
> > >
> > > I mailed them this morn and it bounced back.
> > >
> > > I did the cut-n-paste thing but it really screws around with the
> worksheet
> > > formatting.
> > >
> > > Maybe our local Excel guru, Tim, can solve the equation.
> > >
> > > Norm
> > >
> > > ----- Original Message -----
> > > From: "Perry Stanfield" <mpstan@home.com>
> > > To: <canslim@lists.xmission.com>
> > > Sent: Sunday, June 03, 2001 2:16 PM
> > > Subject: Re: [CANSLIM] canslim.net screen
> > >
> > >
> > > > Hi Norman,
> > > >
> > > > Boy do I wish I did know how............if you figure this one out
let
> > me
> > > > know......
> > > >
> > > > I've emailed the website makers twice but never got a reply.
Pretty
> > > > interesting site for the price, isn't it?
> > > >
> > > > Perry
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Norman" <theboyd@tisd.net>
> > > > To: <canslim@lists.xmission.com>
> > > > Sent: Sunday, June 03, 2001 9:57 AM
> > > > Subject: [CANSLIM] canslim.net screen
> > > >
> > > >
> > > > > Does anyone know of a way to import/copy the canslim.net screens
> into
> > an
> > > > > Excel worksheet?
> > > > >
> > > > > Norman
> > > > >
> > > > >
> > > > > -
> > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > -In the email body, write "subscribe canslim" or
> > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > >
> > > >
> > > > -
> > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > -In the email body, write "subscribe canslim" or
> > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > >
> > > >
> > >
> > >
> > > -
> > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > -In the email body, write "subscribe canslim" or
> > > -"unsubscribe canslim". Do not use quotes in your email.
> >
> >
> > -
> > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > -In the email body, write "subscribe canslim" or
> > -"unsubscribe canslim". Do not use quotes in your email.
> >
> >
>
>
> -
> -To subscribe/unsubscribe, email "majordomo@xmission.com"
> -In the email body, write "subscribe canslim" or
> -"unsubscribe canslim". Do not use quotes in your email.
- -
- -To subscribe/unsubscribe, email "majordomo@xmission.com"
- -In the email body, write "subscribe canslim" or
- -"unsubscribe canslim". Do not use quotes in your email.
------------------------------
Date: Sun, 3 Jun 2001 17:52:59 -0500
From: "Norman" <theboyd@tisd.net>
Subject: Re: [CANSLIM] canslim.net screen
Tracie (Jay?),
And I will try Office 2000 at work. Could just be the versions. Thanks for
the info.
Norman
- ----- Original Message -----
From: "Tracie Oken" <imtoken@yahoo.com>
To: <canslim@lists.xmission.com>
Sent: Sunday, June 03, 2001 5:38 PM
Subject: Re: [CANSLIM] canslim.net screen
> The difference maybe that I am on Word 2000 (but Excel 97). When I copy
the
> screen starting with AAS it automatically pastes as a nice, clean table in
> Word. When I try to grab the whole table (including the headings) it is
> unusable. I use Word 97 at the office and will try experiment with it
over
> the next couple of days.
>
> ----- Original Message -----
> From: "Norman" <theboyd@tisd.net>
> To: <canslim@lists.xmission.com>
> Sent: Sunday, June 03, 2001 3:03 PM
> Subject: Re: [CANSLIM] canslim.net screen
>
>
> > Hey Jay,
> >
> > Thanks for the input. Unfortunately I have already tried this method
> > without luck. When I paste into Word 97 I get only the text with no
table
> > formatting. This makes it impossible to select a column and copy to the
> > clipboard.
> >
> > However, when I just tried grabbing the whole table, HEADINGS AND ALL,
it
> > preserved the table settings with no vertical or horizontal lines. Now
I
> > can copy the first column to a worksheet. Wow!
> >
> > I am interested in how you were able to make it work by leaving out the
> top
> > headings and starting your copy with AAS. I wonder if there is a Word
> > setting that forces paste function to retain the table formatting?
> >
> > Thanks again, from all of us.
> >
> > Norman
> >
> > ----- Original Message -----
> > From: "Jay Oken" <imjoken@mindspring.com>
> > To: <canslim@lists.xmission.com>
> > Sent: Sunday, June 03, 2001 4:40 PM
> > Subject: Re: [CANSLIM] canslim.net screen
> >
> >
> > > Norman,
> > >
> > > Here is a way to import a screen into Excel from Canslim.Net. I would
> > > suggest printing this out so you have a reference as you try it. It
> really
> > > isn't as hard as it may seem and will go quickly after you use it a
time
> > or
> > > two.
> > >
> > > 1. Go to the screen and highlight the table you want to extract. For
> > example
> > > the breakout list today starts with AAS and ends with TRR (page 1).
Left
> > > click at the beginning of AAS and drag your mouse to the bottom right
> hand
> > > corner of the last column for TRR.
> > >
> > > 2. With your mouse over the table highlighted, Right click and
select
> > > Copy.
> > >
> > > 3. Go into MS Word, Right click on a blank document and select
paste.
> > MS
> > > Word will now have created a table from the screen you just copied on
> > > Canslim.Net.
> > >
> > > 4. Above the table (your mouse will turn into a downward pointing
> > arrow),
> > > left click on the symbols column with the symbols to highlight it (you
> can
> > > also drag the mouse to the right and select all the columns). Right
> click
> > > and select Copy.
> > >
> > > 5. Go into Excel and Right click on any cell (preferably A1) and
> select
> > > Paste Special. At the bottom of the dialogue box select Text and click
> > O.K.
> > > You will now have the column (or table) in a usable Excel worksheet.
> > >
> > > Note that if you skip the step of importing into MS Word, and try to
> copy
> > > directly into Excel, you will not get a user friendly worksheet. Also,
> you
> > > can not get the column headings. You could, of course, set up a
> template
> > in
> > > Excel with the column headings in row 1 and then paste from MS Word
into
> > > cell A2.
> > >
> > > Hope this helps.
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Norman" <theboyd@tisd.net>
> > > To: <canslim@lists.xmission.com>
> > > Sent: Sunday, June 03, 2001 12:25 PM
> > > Subject: Re: [CANSLIM] canslim.net screen
> > >
> > >
> > > > Hey Perry,
> > > >
> > > > Yes, great site for the price :-)
> > > >
> > > > I mailed them this morn and it bounced back.
> > > >
> > > > I did the cut-n-paste thing but it really screws around with the
> > worksheet
> > > > formatting.
> > > >
> > > > Maybe our local Excel guru, Tim, can solve the equation.
> > > >
> > > > Norm
> > > >
> > > > ----- Original Message -----
> > > > From: "Perry Stanfield" <mpstan@home.com>
> > > > To: <canslim@lists.xmission.com>
> > > > Sent: Sunday, June 03, 2001 2:16 PM
> > > > Subject: Re: [CANSLIM] canslim.net screen
> > > >
> > > >
> > > > > Hi Norman,
> > > > >
> > > > > Boy do I wish I did know how............if you figure this one out
> let
> > > me
> > > > > know......
> > > > >
> > > > > I've emailed the website makers twice but never got a reply.
> Pretty
> > > > > interesting site for the price, isn't it?
> > > > >
> > > > > Perry
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Norman" <theboyd@tisd.net>
> > > > > To: <canslim@lists.xmission.com>
> > > > > Sent: Sunday, June 03, 2001 9:57 AM
> > > > > Subject: [CANSLIM] canslim.net screen
> > > > >
> > > > >
> > > > > > Does anyone know of a way to import/copy the canslim.net screens
> > into
> > > an
> > > > > > Excel worksheet?
> > > > > >
> > > > > > Norman
> > > > > >
> > > > > >
> > > > > > -
> > > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > > -In the email body, write "subscribe canslim" or
> > > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > > >
> > > > >
> > > > > -
> > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > -In the email body, write "subscribe canslim" or
> > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > > >
> > > > >
> > > >
> > > >
> > > > -
> > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > -In the email body, write "subscribe canslim" or
> > > > -"unsubscribe canslim". Do not use quotes in your email.
> > >
> > >
> > > -
> > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > -In the email body, write "subscribe canslim" or
> > > -"unsubscribe canslim". Do not use quotes in your email.
> > >
> > >
> >
> >
> > -
> > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > -In the email body, write "subscribe canslim" or
> > -"unsubscribe canslim". Do not use quotes in your email.
>
>
> -
> -To subscribe/unsubscribe, email "majordomo@xmission.com"
> -In the email body, write "subscribe canslim" or
> -"unsubscribe canslim". Do not use quotes in your email.
>
>
- -
- -To subscribe/unsubscribe, email "majordomo@xmission.com"
- -In the email body, write "subscribe canslim" or
- -"unsubscribe canslim". Do not use quotes in your email.
------------------------------
Date: Sun, 3 Jun 2001 16:05:51 -0700
From: "Perry Stanfield" <mpstan@home.com>
Subject: Re: [CANSLIM] canslim.net screen
Norman, Tracy, (Jay?),
Oh my gosh, I just followed those directions and it worked!!!!!
I did a leader's screen with canslims within 4% of a 52 week high, and now
I have a spreadsheet with 107 symbols in a nice spreadsheet. I have Office
2000.
If you'd like, just let me know and I can send you a spreadsheet today if
you're wanting to do some dd for tomorrow. Just let me know what you want
in the spreadsheet.
This is huge.......now I wonder how close this list is to a DGO list that I
wonder if can be generated.........an all inclusive world of considerable
stocks, say, like all 75 75 DBB or better, within 5% of a 52 week high,
above a certain volume (maybe 80,000-100,000 share volume)............
- ----- Original Message -----
From: "Norman" <theboyd@tisd.net>
To: <canslim@lists.xmission.com>
Sent: Sunday, June 03, 2001 3:52 PM
Subject: Re: [CANSLIM] canslim.net screen
> Tracie (Jay?),
>
> And I will try Office 2000 at work. Could just be the versions. Thanks
for
> the info.
>
> Norman
>
> ----- Original Message -----
> From: "Tracie Oken" <imtoken@yahoo.com>
> To: <canslim@lists.xmission.com>
> Sent: Sunday, June 03, 2001 5:38 PM
> Subject: Re: [CANSLIM] canslim.net screen
>
>
> > The difference maybe that I am on Word 2000 (but Excel 97). When I copy
> the
> > screen starting with AAS it automatically pastes as a nice, clean table
in
> > Word. When I try to grab the whole table (including the headings) it is
> > unusable. I use Word 97 at the office and will try experiment with it
> over
> > the next couple of days.
> >
> > ----- Original Message -----
> > From: "Norman" <theboyd@tisd.net>
> > To: <canslim@lists.xmission.com>
> > Sent: Sunday, June 03, 2001 3:03 PM
> > Subject: Re: [CANSLIM] canslim.net screen
> >
> >
> > > Hey Jay,
> > >
> > > Thanks for the input. Unfortunately I have already tried this method
> > > without luck. When I paste into Word 97 I get only the text with no
> table
> > > formatting. This makes it impossible to select a column and copy to
the
> > > clipboard.
> > >
> > > However, when I just tried grabbing the whole table, HEADINGS AND ALL,
> it
> > > preserved the table settings with no vertical or horizontal lines.
Now
> I
> > > can copy the first column to a worksheet. Wow!
> > >
> > > I am interested in how you were able to make it work by leaving out
the
> > top
> > > headings and starting your copy with AAS. I wonder if there is a Word
> > > setting that forces paste function to retain the table formatting?
> > >
> > > Thanks again, from all of us.
> > >
> > > Norman
> > >
> > > ----- Original Message -----
> > > From: "Jay Oken" <imjoken@mindspring.com>
> > > To: <canslim@lists.xmission.com>
> > > Sent: Sunday, June 03, 2001 4:40 PM
> > > Subject: Re: [CANSLIM] canslim.net screen
> > >
> > >
> > > > Norman,
> > > >
> > > > Here is a way to import a screen into Excel from Canslim.Net. I
would
> > > > suggest printing this out so you have a reference as you try it. It
> > really
> > > > isn't as hard as it may seem and will go quickly after you use it a
> time
> > > or
> > > > two.
> > > >
> > > > 1. Go to the screen and highlight the table you want to extract. For
> > > example
> > > > the breakout list today starts with AAS and ends with TRR (page 1).
> Left
> > > > click at the beginning of AAS and drag your mouse to the bottom
right
> > hand
> > > > corner of the last column for TRR.
> > > >
> > > > 2. With your mouse over the table highlighted, Right click and
> select
> > > > Copy.
> > > >
> > > > 3. Go into MS Word, Right click on a blank document and select
> paste.
> > > MS
> > > > Word will now have created a table from the screen you just copied
on
> > > > Canslim.Net.
> > > >
> > > > 4. Above the table (your mouse will turn into a downward pointing
> > > arrow),
> > > > left click on the symbols column with the symbols to highlight it
(you
> > can
> > > > also drag the mouse to the right and select all the columns). Right
> > click
> > > > and select Copy.
> > > >
> > > > 5. Go into Excel and Right click on any cell (preferably A1) and
> > select
> > > > Paste Special. At the bottom of the dialogue box select Text and
click
> > > O.K.
> > > > You will now have the column (or table) in a usable Excel worksheet.
> > > >
> > > > Note that if you skip the step of importing into MS Word, and try to
> > copy
> > > > directly into Excel, you will not get a user friendly worksheet.
Also,
> > you
> > > > can not get the column headings. You could, of course, set up a
> > template
> > > in
> > > > Excel with the column headings in row 1 and then paste from MS Word
> into
> > > > cell A2.
> > > >
> > > > Hope this helps.
> > > >
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Norman" <theboyd@tisd.net>
> > > > To: <canslim@lists.xmission.com>
> > > > Sent: Sunday, June 03, 2001 12:25 PM
> > > > Subject: Re: [CANSLIM] canslim.net screen
> > > >
> > > >
> > > > > Hey Perry,
> > > > >
> > > > > Yes, great site for the price :-)
> > > > >
> > > > > I mailed them this morn and it bounced back.
> > > > >
> > > > > I did the cut-n-paste thing but it really screws around with the
> > > worksheet
> > > > > formatting.
> > > > >
> > > > > Maybe our local Excel guru, Tim, can solve the equation.
> > > > >
> > > > > Norm
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Perry Stanfield" <mpstan@home.com>
> > > > > To: <canslim@lists.xmission.com>
> > > > > Sent: Sunday, June 03, 2001 2:16 PM
> > > > > Subject: Re: [CANSLIM] canslim.net screen
> > > > >
> > > > >
> > > > > > Hi Norman,
> > > > > >
> > > > > > Boy do I wish I did know how............if you figure this one
out
> > let
> > > > me
> > > > > > know......
> > > > > >
> > > > > > I've emailed the website makers twice but never got a reply.
> > Pretty
> > > > > > interesting site for the price, isn't it?
> > > > > >
> > > > > > Perry
> > > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "Norman" <theboyd@tisd.net>
> > > > > > To: <canslim@lists.xmission.com>
> > > > > > Sent: Sunday, June 03, 2001 9:57 AM
> > > > > > Subject: [CANSLIM] canslim.net screen
> > > > > >
> > > > > >
> > > > > > > Does anyone know of a way to import/copy the canslim.net
screens
> > > into
> > > > an
> > > > > > > Excel worksheet?
> > > > > > >
> > > > > > > Norman
> > > > > > >
> > > > > > >
> > > > > > > -
> > > > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > > > -In the email body, write "subscribe canslim" or
> > > > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > > > >
> > > > > >
> > > > > > -
> > > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > > -In the email body, write "subscribe canslim" or
> > > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > -
> > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > -In the email body, write "subscribe canslim" or
> > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > >
> > > >
> > > > -
> > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > -In the email body, write "subscribe canslim" or
> > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > >
> > > >
> > >
> > >
> > > -
> > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > -In the email body, write "subscribe canslim" or
> > > -"unsubscribe canslim". Do not use quotes in your email.
> >
> >
> > -
> > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > -In the email body, write "subscribe canslim" or
> > -"unsubscribe canslim". Do not use quotes in your email.
> >
> >
>
>
> -
> -To subscribe/unsubscribe, email "majordomo@xmission.com"
> -In the email body, write "subscribe canslim" or
> -"unsubscribe canslim". Do not use quotes in your email.
- -
- -To subscribe/unsubscribe, email "majordomo@xmission.com"
- -In the email body, write "subscribe canslim" or
- -"unsubscribe canslim". Do not use quotes in your email.
------------------------------
Date: Sun, 3 Jun 2001 16:12:12 -0700
From: "Jay Oken" <imjoken@mindspring.com>
Subject: Re: [CANSLIM] canslim.net screen
Norman et al,
Here is another method which eliminates the Word step.
1. Highlight the table and Copy to the clipboard.
2. Paste into Excel using the normal paste function.
3. Highlight column A. Select Format/Cells (from the toolbar). Select the
Alignment Tab. Click on the boxes next to Wrap Text and Merge Cells until
both boxes are clear. Click O.K.
4. Delete columns D - I and any rows above the first stock symbol. (i.e.
symbol AAS should be in cell A1).
5. In cell B1 put the formula +A1 and copy it down the full length of
what is in column A. (Note that some rows will look empty due to the
background color but they actually have data in them).
6. Select the length of formulas in column B that was just created and
copy to the clipboard.
7. Using Paste Special, select Values and paste into column C. Delete
columns A & B.
8. Sort column C so that all the symbols are together and delete the rows
with 0's in them.
You now should have a usable symbol list that can be imported into DGO.
- ----- Original Message -----
From: "Norman" <theboyd@tisd.net>
To: <canslim@lists.xmission.com>
Sent: Sunday, June 03, 2001 3:03 PM
Subject: Re: [CANSLIM] canslim.net screen
> Hey Jay,
>
> Thanks for the input. Unfortunately I have already tried this method
> without luck. When I paste into Word 97 I get only the text with no table
> formatting. This makes it impossible to select a column and copy to the
> clipboard.
>
> However, when I just tried grabbing the whole table, HEADINGS AND ALL, it
> preserved the table settings with no vertical or horizontal lines. Now I
> can copy the first column to a worksheet. Wow!
>
> I am interested in how you were able to make it work by leaving out the
top
> headings and starting your copy with AAS. I wonder if there is a Word
> setting that forces paste function to retain the table formatting?
>
> Thanks again, from all of us.
>
> Norman
>
> ----- Original Message -----
> From: "Jay Oken" <imjoken@mindspring.com>
> To: <canslim@lists.xmission.com>
> Sent: Sunday, June 03, 2001 4:40 PM
> Subject: Re: [CANSLIM] canslim.net screen
>
>
> > Norman,
> >
> > Here is a way to import a screen into Excel from Canslim.Net. I would
> > suggest printing this out so you have a reference as you try it. It
really
> > isn't as hard as it may seem and will go quickly after you use it a time
> or
> > two.
> >
> > 1. Go to the screen and highlight the table you want to extract. For
> example
> > the breakout list today starts with AAS and ends with TRR (page 1). Left
> > click at the beginning of AAS and drag your mouse to the bottom right
hand
> > corner of the last column for TRR.
> >
> > 2. With your mouse over the table highlighted, Right click and select
> > Copy.
> >
> > 3. Go into MS Word, Right click on a blank document and select paste.
> MS
> > Word will now have created a table from the screen you just copied on
> > Canslim.Net.
> >
> > 4. Above the table (your mouse will turn into a downward pointing
> arrow),
> > left click on the symbols column with the symbols to highlight it (you
can
> > also drag the mouse to the right and select all the columns). Right
click
> > and select Copy.
> >
> > 5. Go into Excel and Right click on any cell (preferably A1) and
select
> > Paste Special. At the bottom of the dialogue box select Text and click
> O.K.
> > You will now have the column (or table) in a usable Excel worksheet.
> >
> > Note that if you skip the step of importing into MS Word, and try to
copy
> > directly into Excel, you will not get a user friendly worksheet. Also,
you
> > can not get the column headings. You could, of course, set up a
template
> in
> > Excel with the column headings in row 1 and then paste from MS Word into
> > cell A2.
> >
> > Hope this helps.
> >
> >
> >
> > ----- Original Message -----
> > From: "Norman" <theboyd@tisd.net>
> > To: <canslim@lists.xmission.com>
> > Sent: Sunday, June 03, 2001 12:25 PM
> > Subject: Re: [CANSLIM] canslim.net screen
> >
> >
> > > Hey Perry,
> > >
> > > Yes, great site for the price :-)
> > >
> > > I mailed them this morn and it bounced back.
> > >
> > > I did the cut-n-paste thing but it really screws around with the
> worksheet
> > > formatting.
> > >
> > > Maybe our local Excel guru, Tim, can solve the equation.
> > >
> > > Norm
> > >
> > > ----- Original Message -----
> > > From: "Perry Stanfield" <mpstan@home.com>
> > > To: <canslim@lists.xmission.com>
> > > Sent: Sunday, June 03, 2001 2:16 PM
> > > Subject: Re: [CANSLIM] canslim.net screen
> > >
> > >
> > > > Hi Norman,
> > > >
> > > > Boy do I wish I did know how............if you figure this one out
let
> > me
> > > > know......
> > > >
> > > > I've emailed the website makers twice but never got a reply.
Pretty
> > > > interesting site for the price, isn't it?
> > > >
> > > > Perry
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Norman" <theboyd@tisd.net>
> > > > To: <canslim@lists.xmission.com>
> > > > Sent: Sunday, June 03, 2001 9:57 AM
> > > > Subject: [CANSLIM] canslim.net screen
> > > >
> > > >
> > > > > Does anyone know of a way to import/copy the canslim.net screens
> into
> > an
> > > > > Excel worksheet?
> > > > >
> > > > > Norman
> > > > >
> > > > >
> > > > > -
> > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > -In the email body, write "subscribe canslim" or
> > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > >
> > > >
> > > > -
> > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > -In the email body, write "subscribe canslim" or
> > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > >
> > > >
> > >
> > >
> > > -
> > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > -In the email body, write "subscribe canslim" or
> > > -"unsubscribe canslim". Do not use quotes in your email.
> >
> >
> > -
> > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > -In the email body, write "subscribe canslim" or
> > -"unsubscribe canslim". Do not use quotes in your email.
> >
> >
>
>
> -
> -To subscribe/unsubscribe, email "majordomo@xmission.com"
> -In the email body, write "subscribe canslim" or
> -"unsubscribe canslim". Do not use quotes in your email.
- -
- -To subscribe/unsubscribe, email "majordomo@xmission.com"
- -In the email body, write "subscribe canslim" or
- -"unsubscribe canslim". Do not use quotes in your email.
------------------------------
Date: Sun, 3 Jun 2001 18:26:16 -0500
From: "Norman" <theboyd@tisd.net>
Subject: Re: [CANSLIM] canslim.net screen
Jay,
Another Office 2000 trick I suspect. I will try these at work tomorrow. I
may have to load 2000 here at home. By the way, I am creating portfolios at
clearstation.com with these screens. In fact I create a portfolio with all
the good stock lists I come across so I can view them in bulk. Of course I
have to use investors.com or stockcharts.com charting functions for a good
chart.
Norman
- ----- Original Message -----
From: "Jay Oken" <imjoken@mindspring.com>
To: <canslim@lists.xmission.com>
Sent: Sunday, June 03, 2001 6:12 PM
Subject: Re: [CANSLIM] canslim.net screen
> Norman et al,
>
> Here is another method which eliminates the Word step.
>
> 1. Highlight the table and Copy to the clipboard.
> 2. Paste into Excel using the normal paste function.
> 3. Highlight column A. Select Format/Cells (from the toolbar). Select
the
> Alignment Tab. Click on the boxes next to Wrap Text and Merge Cells until
> both boxes are clear. Click O.K.
> 4. Delete columns D - I and any rows above the first stock symbol.
(i.e.
> symbol AAS should be in cell A1).
> 5. In cell B1 put the formula +A1 and copy it down the full length of
> what is in column A. (Note that some rows will look empty due to the
> background color but they actually have data in them).
> 6. Select the length of formulas in column B that was just created and
> copy to the clipboard.
> 7. Using Paste Special, select Values and paste into column C. Delete
> columns A & B.
> 8. Sort column C so that all the symbols are together and delete the
rows
> with 0's in them.
>
> You now should have a usable symbol list that can be imported into DGO.
>
> ----- Original Message -----
> From: "Norman" <theboyd@tisd.net>
> To: <canslim@lists.xmission.com>
> Sent: Sunday, June 03, 2001 3:03 PM
> Subject: Re: [CANSLIM] canslim.net screen
>
>
> > Hey Jay,
> >
> > Thanks for the input. Unfortunately I have already tried this method
> > without luck. When I paste into Word 97 I get only the text with no
table
> > formatting. This makes it impossible to select a column and copy to the
> > clipboard.
> >
> > However, when I just tried grabbing the whole table, HEADINGS AND ALL,
it
> > preserved the table settings with no vertical or horizontal lines. Now
I
> > can copy the first column to a worksheet. Wow!
> >
> > I am interested in how you were able to make it work by leaving out the
> top
> > headings and starting your copy with AAS. I wonder if there is a Word
> > setting that forces paste function to retain the table formatting?
> >
> > Thanks again, from all of us.
> >
> > Norman
> >
> > ----- Original Message -----
> > From: "Jay Oken" <imjoken@mindspring.com>
> > To: <canslim@lists.xmission.com>
> > Sent: Sunday, June 03, 2001 4:40 PM
> > Subject: Re: [CANSLIM] canslim.net screen
> >
> >
> > > Norman,
> > >
> > > Here is a way to import a screen into Excel from Canslim.Net. I would
> > > suggest printing this out so you have a reference as you try it. It
> really
> > > isn't as hard as it may seem and will go quickly after you use it a
time
> > or
> > > two.
> > >
> > > 1. Go to the screen and highlight the table you want to extract. For
> > example
> > > the breakout list today starts with AAS and ends with TRR (page 1).
Left
> > > click at the beginning of AAS and drag your mouse to the bottom right
> hand
> > > corner of the last column for TRR.
> > >
> > > 2. With your mouse over the table highlighted, Right click and
select
> > > Copy.
> > >
> > > 3. Go into MS Word, Right click on a blank document and select
paste.
> > MS
> > > Word will now have created a table from the screen you just copied on
> > > Canslim.Net.
> > >
> > > 4. Above the table (your mouse will turn into a downward pointing
> > arrow),
> > > left click on the symbols column with the symbols to highlight it (you
> can
> > > also drag the mouse to the right and select all the columns). Right
> click
> > > and select Copy.
> > >
> > > 5. Go into Excel and Right click on any cell (preferably A1) and
> select
> > > Paste Special. At the bottom of the dialogue box select Text and click
> > O.K.
> > > You will now have the column (or table) in a usable Excel worksheet.
> > >
> > > Note that if you skip the step of importing into MS Word, and try to
> copy
> > > directly into Excel, you will not get a user friendly worksheet. Also,
> you
> > > can not get the column headings. You could, of course, set up a
> template
> > in
> > > Excel with the column headings in row 1 and then paste from MS Word
into
> > > cell A2.
> > >
> > > Hope this helps.
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Norman" <theboyd@tisd.net>
> > > To: <canslim@lists.xmission.com>
> > > Sent: Sunday, June 03, 2001 12:25 PM
> > > Subject: Re: [CANSLIM] canslim.net screen
> > >
> > >
> > > > Hey Perry,
> > > >
> > > > Yes, great site for the price :-)
> > > >
> > > > I mailed them this morn and it bounced back.
> > > >
> > > > I did the cut-n-paste thing but it really screws around with the
> > worksheet
> > > > formatting.
> > > >
> > > > Maybe our local Excel guru, Tim, can solve the equation.
> > > >
> > > > Norm
> > > >
> > > > ----- Original Message -----
> > > > From: "Perry Stanfield" <mpstan@home.com>
> > > > To: <canslim@lists.xmission.com>
> > > > Sent: Sunday, June 03, 2001 2:16 PM
> > > > Subject: Re: [CANSLIM] canslim.net screen
> > > >
> > > >
> > > > > Hi Norman,
> > > > >
> > > > > Boy do I wish I did know how............if you figure this one out
> let
> > > me
> > > > > know......
> > > > >
> > > > > I've emailed the website makers twice but never got a reply.
> Pretty
> > > > > interesting site for the price, isn't it?
> > > > >
> > > > > Perry
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Norman" <theboyd@tisd.net>
> > > > > To: <canslim@lists.xmission.com>
> > > > > Sent: Sunday, June 03, 2001 9:57 AM
> > > > > Subject: [CANSLIM] canslim.net screen
> > > > >
> > > > >
> > > > > > Does anyone know of a way to import/copy the canslim.net screens
> > into
> > > an
> > > > > > Excel worksheet?
> > > > > >
> > > > > > Norman
> > > > > >
> > > > > >
> > > > > > -
> > > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > > -In the email body, write "subscribe canslim" or
> > > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > > >
> > > > >
> > > > > -
> > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > -In the email body, write "subscribe canslim" or
> > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > > >
> > > > >
> > > >
> > > >
> > > > -
> > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > -In the email body, write "subscribe canslim" or
> > > > -"unsubscribe canslim". Do not use quotes in your email.
> > >
> > >
> > > -
> > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > -In the email body, write "subscribe canslim" or
> > > -"unsubscribe canslim". Do not use quotes in your email.
> > >
> > >
> >
> >
> > -
> > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > -In the email body, write "subscribe canslim" or
> > -"unsubscribe canslim". Do not use quotes in your email.
>
>
> -
> -To subscribe/unsubscribe, email "majordomo@xmission.com"
> -In the email body, write "subscribe canslim" or
> -"unsubscribe canslim". Do not use quotes in your email.
>
>
- -
- -To subscribe/unsubscribe, email "majordomo@xmission.com"
- -In the email body, write "subscribe canslim" or
- -"unsubscribe canslim". Do not use quotes in your email.
------------------------------
Date: Sun, 3 Jun 2001 16:45:58 -0700
From: "Jay Oken" <imjoken@mindspring.com>
Subject: Re: [CANSLIM] canslim.net screen
Norman,
I am actually using Office 97. Only Word is 2000. This second method should
work regardless of what version you are using. If you want to e-mail me
offline maybe I can help you get it to work.
- ----- Original Message -----
From: "Norman" <theboyd@tisd.net>
To: <canslim@lists.xmission.com>
Sent: Sunday, June 03, 2001 4:26 PM
Subject: Re: [CANSLIM] canslim.net screen
> Jay,
>
> Another Office 2000 trick I suspect. I will try these at work tomorrow.
I
> may have to load 2000 here at home. By the way, I am creating portfolios
at
> clearstation.com with these screens. In fact I create a portfolio with
all
> the good stock lists I come across so I can view them in bulk. Of course
I
> have to use investors.com or stockcharts.com charting functions for a good
> chart.
>
> Norman
>
> ----- Original Message -----
> From: "Jay Oken" <imjoken@mindspring.com>
> To: <canslim@lists.xmission.com>
> Sent: Sunday, June 03, 2001 6:12 PM
> Subject: Re: [CANSLIM] canslim.net screen
>
>
> > Norman et al,
> >
> > Here is another method which eliminates the Word step.
> >
> > 1. Highlight the table and Copy to the clipboard.
> > 2. Paste into Excel using the normal paste function.
> > 3. Highlight column A. Select Format/Cells (from the toolbar). Select
> the
> > Alignment Tab. Click on the boxes next to Wrap Text and Merge Cells
until
> > both boxes are clear. Click O.K.
> > 4. Delete columns D - I and any rows above the first stock symbol.
> (i.e.
> > symbol AAS should be in cell A1).
> > 5. In cell B1 put the formula +A1 and copy it down the full length of
> > what is in column A. (Note that some rows will look empty due to the
> > background color but they actually have data in them).
> > 6. Select the length of formulas in column B that was just created
and
> > copy to the clipboard.
> > 7. Using Paste Special, select Values and paste into column C. Delete
> > columns A & B.
> > 8. Sort column C so that all the symbols are together and delete the
> rows
> > with 0's in them.
> >
> > You now should have a usable symbol list that can be imported into DGO.
> >
> > ----- Original Message -----
> > From: "Norman" <theboyd@tisd.net>
> > To: <canslim@lists.xmission.com>
> > Sent: Sunday, June 03, 2001 3:03 PM
> > Subject: Re: [CANSLIM] canslim.net screen
> >
> >
> > > Hey Jay,
> > >
> > > Thanks for the input. Unfortunately I have already tried this method
> > > without luck. When I paste into Word 97 I get only the text with no
> table
> > > formatting. This makes it impossible to select a column and copy to
the
> > > clipboard.
> > >
> > > However, when I just tried grabbing the whole table, HEADINGS AND ALL,
> it
> > > preserved the table settings with no vertical or horizontal lines.
Now
> I
> > > can copy the first column to a worksheet. Wow!
> > >
> > > I am interested in how you were able to make it work by leaving out
the
> > top
> > > headings and starting your copy with AAS. I wonder if there is a Word
> > > setting that forces paste function to retain the table formatting?
> > >
> > > Thanks again, from all of us.
> > >
> > > Norman
> > >
> > > ----- Original Message -----
> > > From: "Jay Oken" <imjoken@mindspring.com>
> > > To: <canslim@lists.xmission.com>
> > > Sent: Sunday, June 03, 2001 4:40 PM
> > > Subject: Re: [CANSLIM] canslim.net screen
> > >
> > >
> > > > Norman,
> > > >
> > > > Here is a way to import a screen into Excel from Canslim.Net. I
would
> > > > suggest printing this out so you have a reference as you try it. It
> > really
> > > > isn't as hard as it may seem and will go quickly after you use it a
> time
> > > or
> > > > two.
> > > >
> > > > 1. Go to the screen and highlight the table you want to extract. For
> > > example
> > > > the breakout list today starts with AAS and ends with TRR (page 1).
> Left
> > > > click at the beginning of AAS and drag your mouse to the bottom
right
> > hand
> > > > corner of the last column for TRR.
> > > >
> > > > 2. With your mouse over the table highlighted, Right click and
> select
> > > > Copy.
> > > >
> > > > 3. Go into MS Word, Right click on a blank document and select
> paste.
> > > MS
> > > > Word will now have created a table from the screen you just copied
on
> > > > Canslim.Net.
> > > >
> > > > 4. Above the table (your mouse will turn into a downward pointing
> > > arrow),
> > > > left click on the symbols column with the symbols to highlight it
(you
> > can
> > > > also drag the mouse to the right and select all the columns). Right
> > click
> > > > and select Copy.
> > > >
> > > > 5. Go into Excel and Right click on any cell (preferably A1) and
> > select
> > > > Paste Special. At the bottom of the dialogue box select Text and
click
> > > O.K.
> > > > You will now have the column (or table) in a usable Excel worksheet.
> > > >
> > > > Note that if you skip the step of importing into MS Word, and try to
> > copy
> > > > directly into Excel, you will not get a user friendly worksheet.
Also,
> > you
> > > > can not get the column headings. You could, of course, set up a
> > template
> > > in
> > > > Excel with the column headings in row 1 and then paste from MS Word
> into
> > > > cell A2.
> > > >
> > > > Hope this helps.
> > > >
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Norman" <theboyd@tisd.net>
> > > > To: <canslim@lists.xmission.com>
> > > > Sent: Sunday, June 03, 2001 12:25 PM
> > > > Subject: Re: [CANSLIM] canslim.net screen
> > > >
> > > >
> > > > > Hey Perry,
> > > > >
> > > > > Yes, great site for the price :-)
> > > > >
> > > > > I mailed them this morn and it bounced back.
> > > > >
> > > > > I did the cut-n-paste thing but it really screws around with the
> > > worksheet
> > > > > formatting.
> > > > >
> > > > > Maybe our local Excel guru, Tim, can solve the equation.
> > > > >
> > > > > Norm
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Perry Stanfield" <mpstan@home.com>
> > > > > To: <canslim@lists.xmission.com>
> > > > > Sent: Sunday, June 03, 2001 2:16 PM
> > > > > Subject: Re: [CANSLIM] canslim.net screen
> > > > >
> > > > >
> > > > > > Hi Norman,
> > > > > >
> > > > > > Boy do I wish I did know how............if you figure this one
out
> > let
> > > > me
> > > > > > know......
> > > > > >
> > > > > > I've emailed the website makers twice but never got a reply.
> > Pretty
> > > > > > interesting site for the price, isn't it?
> > > > > >
> > > > > > Perry
> > > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "Norman" <theboyd@tisd.net>
> > > > > > To: <canslim@lists.xmission.com>
> > > > > > Sent: Sunday, June 03, 2001 9:57 AM
> > > > > > Subject: [CANSLIM] canslim.net screen
> > > > > >
> > > > > >
> > > > > > > Does anyone know of a way to import/copy the canslim.net
screens
> > > into
> > > > an
> > > > > > > Excel worksheet?
> > > > > > >
> > > > > > > Norman
> > > > > > >
> > > > > > >
> > > > > > > -
> > > > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > > > -In the email body, write "subscribe canslim" or
> > > > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > > > >
> > > > > >
> > > > > > -
> > > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > > -In the email body, write "subscribe canslim" or
> > > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > -
> > > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > > -In the email body, write "subscribe canslim" or
> > > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > >
> > > >
> > > > -
> > > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > > -In the email body, write "subscribe canslim" or
> > > > -"unsubscribe canslim". Do not use quotes in your email.
> > > >
> > > >
> > >
> > >
> > > -
> > > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > > -In the email body, write "subscribe canslim" or
> > > -"unsubscribe canslim". Do not use quotes in your email.
> >
> >
> > -
> > -To subscribe/unsubscribe, email "majordomo@xmission.com"
> > -In the email body, write "subscribe canslim" or
> > -"unsubscribe canslim". Do not use quotes in your email.
> >
> >
>
>
> -
> -To subscribe/unsubscribe, email "majordomo@xmission.com"
> -In the email body, write "subscribe canslim" or
> -"unsubscribe canslim". Do not use quotes in your email.
- -
- -To subscribe/unsubscribe, email "majordomo@xmission.com"
- -In the email body, write "subscribe canslim" or
- -"unsubscribe canslim". Do not use quotes in your email.
------------------------------
End of canslim-digest V2 #1430
******************************
To unsubscribe to canslim-digest, send an email to "majordomo@xmission.com"
with "unsubscribe canslim-digest" in the body of the message.
For information on digests or retrieving files and old messages send
"help" to the same address. Do not use quotes in your message.