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" 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" To: 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" > To: > 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" > > To: > > 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" > > > To: > > > 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" > > > > To: > > > > 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" 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" To: 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" > To: > 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" > > To: > > 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" > > > To: > > > 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" > > > > To: > > > > 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" > > > > > To: > > > > > 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" 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" To: 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" > To: > 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" > > To: > > 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" > > > To: > > > 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" > > > > To: > > > > 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" > > > > > To: > > > > > 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" > > > > > > To: > > > > > > 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" 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" To: 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" > To: > 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" > > To: > > 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" > > > To: > > > 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" > > > > To: > > > > 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" 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" To: 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" > To: > 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" > > To: > > 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" > > > To: > > > 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" > > > > To: > > > > 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" > > > > > To: > > > > > 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" 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" To: 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" > To: > 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" > > To: > > 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" > > > To: > > > 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" > > > > To: > > > > 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" > > > > > To: > > > > > 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" > > > > > > To: > > > > > > 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.