ftp.xmission.com

home *** CD-ROM | disk | FTP | other *** search

/ ftp.xmission.com / 2014.06.ftp.xmission.com.tar / ftp.xmission.com / pub / lists / canslim / archive / v02.n1805 < prev next >

Wrap

Internet Message Format | 2001-11-11 | 42KB

From: owner-canslim-digest@lists.xmission.com (canslim-digest) To: canslim-digest@lists.xmission.com Subject: canslim-digest V2 #1805 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 Monday, November 12 2001 Volume 02 : Number 1805 In this issue: Re: [CANSLIM] Alpha vs. RS Re: [CANSLIM] Alpha vs. RS Re: [CANSLIM] M in 2002 RE: [CANSLIM] Stock Quotes into Excell RE: [CANSLIM] Stock Quotes into Excell ---------------------------------------------------------------------- Date: Sun, 11 Nov 2001 21:46:09 -0700 From: DougC <dzc@qwest.net> Subject: Re: [CANSLIM] Alpha vs. RS - --=====================_123119081==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Hello Katherine Thanks very much for the excellent response. It's taking a while to sink in but I think I'm getting it. Like the formula simply shows and as WON has also tried to teach and as you state; there is a linear relationship between returns on a stock and returns on a market. You also pointed out that alpha is a single component on the return of a stock (Rs) and that RS is an indication of the return of the stock versus the return of the market. I still need to ponder this some more just to make sure I really do get it...and perhaps will end up finding myself a book on quantitative finance. Thanks again DougC At 12:47 AM 11/11/01 -0600, you wrote: >Hi Doug, > >I'm having to reach way back into the deep recesses of my brain to pull >out what little quantitative finance remains, but hope this might help. >I'll start with a forumla that makes a connection: > >Return on a Stock = Rs >Return on the Market = Rm >Alpha = a >Beta = b > >Rs = a + b*Rm > >This is a linear relationship between returns on the market and returns on >the stock. >Alpha just shows the portion of the stock's return that is *insensitive >to* or *independent of* the market. >Beta is a constant that shows an expected change in Rs given a change in >Rm, that is, how *sensitive* the return is to the market. (A narrow >measure of "volatility" or "risk") > >Example 1: b=0, Rm=0, a=1. That would mean, on average, a stock is no more >volatile than the market and would generate a 1% return, even if the >market returns nothing. > >Example 2: b=3, Rm=1, a=3. That would mean, on average, a stock is 3 times >as volatile as the market and would generate a 6% return, when the market >is returning 1%. > >There's all sorts of statistics, error measurement, etc. in this. But this >is the generally accepted view of theoretical relative returns of an >individual stock against the market. A fancy way of saying, "if I'm going >to take the addtional risk, you better give me a return that's better than >the market average." > >In the best equivalent terms I can use to equate these variables, then, >WON's Relative Strength Ranking "RS" = Rs/Rm > >You can see that you cannot relate alpha and RS directly, as alpha is only >a single component of the return on the stock (Rs). > >Hope this is helpful. But I'll warn you, if you ask me too many questions >on this one, I'll have to go dig out my textbooks, and they are dustier >than my brain! :)) > >Katherine ><mailto:kmalm@earthlink.net>kmalm@earthlink.net > >----- Original Message ----- >>From: <mailto:dzc@qwest.net>DougC >>To: <mailto:canslim@lists.xmission.com>canslim@lists.xmission.com >>Sent: Saturday, November 10, 2001 10:39 PM >>Subject: [CANSLIM] Alpha vs. RS >> >>Never paid much attention to Alpha until recently. Been wondering how it >>correlates to RS. I just did a screen on DGO looking for stocks with >>alpha greater than 3 and used no other criteria. Zero stocks showed up. >>Then I lowered alpha to 2 and got 1 stock. Then I lowered alpha to 1 and >>got 41 stocks also with no other criteria selected. Then I added a >>second criteria of RS of 80 to the alpha of 1 and that reduced my list >>further to 29 stocks. >> >>Here's DGO's definition of RS: 'Understanding the price data for stocks >>is the first step in becoming a smart investor. The next step is learning >>how to compare a particular stock's price performance with all the other >>stocks in the market. The Relative Price Strength (RS) Rating measures a >>stock's price movement over the last 12 months and compares it to all >>other stocks on the NYSE, NASDAQ, and AMEX markets. The results are >>ranked on a 1-99 scale, 99 being the strongest. For example, XYZ Corp. >>has a RS Rating of 98. This means that during the past 52 weeks, XYZ's >>price outperformed 98% of all other stocks. Stocks rated above 80 in RS >>Rating can be considered strong performers, and stocks below 70 in RS >>Rating can generally be considered laggard performers. The Relative Price >>Strength Rating lets you compare any stock's price performance against >>the rest of the over 10,000 stocks tracked in the William O'Neil + Co. >>Incorporated database.' >> >>Here's DGO's definition of alpha: 'An expression of how much a stock >>would have appreciated or depreciated on average every month over the >>last 12 months, assuming the S&P 500 remained unchanged during the >>period. For example, an ALPHA of 1.0 means the stock's price would have >>appreciated at the rate of 1% per month over the last year, assuming an >>unchanged S&P 500 Index. At least 260 days of price history are needed to >>compute the Alpha data item. It is calculated at the end of every trading >>week.' >> >>Am I wrong in assuming that a high RS stock should have a high alpha. Do >>they only correlate during a bull market. Now that I think about it I >>think Yes. I wonder if I had done the above screen 3 years ago how many >>stocks would have had alpha greater than 2. Is there any methodology that >>tracks alpha for the stock universe and flags that conditions are optimum >>if, say, the average alpha is greater than 1? Just wondering. Or maybe >>I'm just being obtuse. >> - --=====================_123119081==_.ALT Content-Type: text/html; charset="us-ascii" <html> Hello Katherine Thanks very much for the excellent response. It's taking a while to sink in but I think I'm getting it. Like the formula simply shows and as WON has also tried to teach and as you state; there is a linear relationship between returns on a stock and returns on a market. You also pointed out that alpha is a single component on the return of a stock (Rs) and that RS is an indication of the return of the stock versus the return of the market. I still need to ponder this some more just to make sure I really do get it...and perhaps will end up finding myself a book on quantitative finance. Thanks again DougC At 12:47 AM 11/11/01 -0600, you wrote: <blockquote type=cite cite>Hi Doug, I'm having to reach way back into the deep recesses of my brain to pull out what little quantitative finance remains, but hope this might help. I'll start with a forumla that makes a connection: Return on a Stock = Rs Return on the Market = Rm Alpha = a Beta = b Rs = a + b*Rm This is a linear relationship between returns on the market and returns on the stock. Alpha just shows the portion of the stock's return that is *insensitive to* or *independent of* the market. Beta is a constant that shows an expected change in Rs given a change in Rm, that is, how *sensitive* the return is to the market. (A narrow measure of "volatility" or "risk") Example 1: b=0, Rm=0, a=1. That would mean, on average, a stock is no more volatile than the market and would generate a 1% return, even if the market returns nothing. Example 2: b=3, Rm=1, a=3. That would mean, on average, a stock is 3 times as volatile as the market and would generate a 6% return, when the market is returning 1%. There's all sorts of statistics, error measurement, etc. in this. But this is the generally accepted view of theoretical relative returns of an individual stock against the market. A fancy way of saying, "if I'm going to take the addtional risk, you better give me a return that's better than the market average." In the best equivalent terms I can use to equate these variables, then, WON's Relative Strength Ranking "RS" = Rs/Rm You can see that you cannot relate alpha and RS directly, as alpha is only a single component of the return on the stock (Rs). Hope this is helpful. But I'll warn you, if you ask me too many questions on this one, I'll have to go dig out my textbooks, and they are dustier than my brain! :)) Katherine <a href="mailto:kmalm@earthlink.net">kmalm@earthlink.net</a> - ----- Original Message ----- <blockquote> <dl> <dd>From: <a href="mailto:dzc@qwest.net">DougC</a> <dd>To: <a href="mailto:canslim@lists.xmission.com">canslim@lists.xmission.com</a> <dd>Sent: Saturday, November 10, 2001 10:39 PM <dd>Subject: [CANSLIM] Alpha vs. RS <dd>Never paid much attention to Alpha until recently. Been wondering how it correlates to RS. I just did a screen on DGO looking for stocks with alpha greater than 3 and used no other criteria. Zero stocks showed up. Then I lowered alpha to 2 and got 1 stock. Then I lowered alpha to 1 and got 41 stocks also with no other criteria selected. Then I added a second criteria of RS of 80 to the alpha of 1 and that reduced my list further to 29 stocks. <dd>Here's DGO's definition of RS: 'Understanding the price data for stocks is the first step in becoming a smart investor. The next step is learning how to compare a particular stock's price performance with all the other stocks in the market. The Relative Price Strength (RS) Rating measures a stock's price movement over the last 12 months and compares it to all other stocks on the NYSE, NASDAQ, and AMEX markets. The results are ranked on a 1-99 scale, 99 being the strongest. For example, XYZ Corp. has a RS Rating of 98. This means that during the past 52 weeks, XYZ's price outperformed 98% of all other stocks. Stocks rated above 80 in RS Rating can be considered strong performers, and stocks below 70 in RS Rating can generally be considered laggard performers. The Relative Price Strength Rating lets you compare any stock's price performance against the rest of the over 10,000 stocks tracked in the William O'Neil + Co. Incorporated database.' <dd>Here's DGO's definition of alpha: 'An expression of how much a stock would have appreciated or depreciated on average every month over the last 12 months, assuming the S&P 500 remained unchanged during the period. For example, an ALPHA of 1.0 means the stock's price would have appreciated at the rate of 1% per month over the last year, assuming an unchanged S&P 500 Index. At least 260 days of price history are needed to compute the Alpha data item. It is calculated at the end of every trading week.' <dd>Am I wrong in assuming that a high RS stock should have a high alpha. Do they only correlate during a bull market. Now that I think about it I think Yes. I wonder if I had done the above screen 3 years ago how many stocks would have had alpha greater than 2. Is there any methodology that tracks alpha for the stock universe and flags that conditions are optimum if, say, the average alpha is greater than 1? Just wondering. Or maybe I'm just being obtuse. </dl></blockquote></html> - --=====================_123119081==_.ALT-- - - - -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, 11 Nov 2001 23:05:11 -0600 From: "Katherine Malm" <kmalm@earthlink.net> Subject: Re: [CANSLIM] Alpha vs. RS This is a multi-part message in MIME format. - ------=_NextPart_000_0021_01C16B05.509A9100 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Doug, Glad it was useful to you. One thing I should note is that I had a typo = in example 1. Beta should have been =3D 1. This is a stock that has = "equally volatility" to the market. There are some excellent studies = done on beta, how it is derived, how "predictive" it is and whether or = not it should be based on price performance vs. fundamentals. But really = only worth reading if you need a sleeping pill! :)) Katherine kmalm@earthlink.net ----- Original Message -----=20 From: DougC=20 To: canslim@lists.xmission.com=20 Sent: Sunday, November 11, 2001 10:46 PM Subject: Re: [CANSLIM] Alpha vs. RS Hello Katherine Thanks very much for the excellent response. It's taking a while to = sink in but I think I'm getting it. Like the formula simply shows and as = WON has also tried to teach and as you state; there is a linear = relationship between returns on a stock and returns on a market. You = also pointed out that alpha is a single component on the return of a = stock (Rs) and that RS is an indication of the return of the stock = versus the return of the market. I still need to ponder this some more = just to make sure I really do get it...and perhaps will end up finding = myself a book on quantitative finance.=20 Thanks again DougC At 12:47 AM 11/11/01 -0600, you wrote: Hi Doug, =20 I'm having to reach way back into the deep recesses of my brain to = pull out what little quantitative finance remains, but hope this might = help. I'll start with a forumla that makes a connection: =20 Return on a Stock =3D Rs Return on the Market =3D Rm Alpha =3D a Beta =3D b =20 Rs =3D a + b*Rm =20 This is a linear relationship between returns on the market and = returns on the stock. Alpha just shows the portion of the stock's return that is = *insensitive to* or *independent of* the market. Beta is a constant that shows an expected change in Rs given a = change in Rm, that is, how *sensitive* the return is to the market. (A = narrow measure of "volatility" or "risk") =20 Example 1: b=3D0, Rm=3D0, a=3D1. That would mean, on average, a = stock is no more volatile than the market and would generate a 1% = return, even if the market returns nothing. =20 Example 2: b=3D3, Rm=3D1, a=3D3. That would mean, on average, a = stock is 3 times as volatile as the market and would generate a 6% = return, when the market is returning 1%. =20 There's all sorts of statistics, error measurement, etc. in this. = But this is the generally accepted view of theoretical relative returns = of an individual stock against the market. A fancy way of saying, "if = I'm going to take the addtional risk, you better give me a return that's = better than the market average." =20 In the best equivalent terms I can use to equate these variables, = then, WON's Relative Strength Ranking "RS" =3D Rs/Rm =20 You can see that you cannot relate alpha and RS directly, as alpha = is only a single component of the return on the stock (Rs).=20 =20 Hope this is helpful. But I'll warn you, if you ask me too many = questions on this one, I'll have to go dig out my textbooks, and they = are dustier than my brain! :)) =20 Katherine kmalm@earthlink.net =20 ----- Original Message -----=20 From: DougC=20 To: canslim@lists.xmission.com=20 Sent: Saturday, November 10, 2001 10:39 PM=20 Subject: [CANSLIM] Alpha vs. RS Never paid much attention to Alpha until recently. Been = wondering how it correlates to RS. I just did a screen on DGO looking = for stocks with alpha greater than 3 and used no other criteria. Zero = stocks showed up. Then I lowered alpha to 2 and got 1 stock. Then I = lowered alpha to 1 and got 41 stocks also with no other criteria = selected. Then I added a second criteria of RS of 80 to the alpha of 1 = and that reduced my list further to 29 stocks.=20 Here's DGO's definition of RS: 'Understanding the price data for = stocks is the first step in becoming a smart investor. The next step is = learning how to compare a particular stock's price performance with all = the other stocks in the market. The Relative Price Strength (RS) Rating = measures a stock's price movement over the last 12 months and compares = it to all other stocks on the NYSE, NASDAQ, and AMEX markets. The = results are ranked on a 1-99 scale, 99 being the strongest. For example, = XYZ Corp. has a RS Rating of 98. This means that during the past 52 = weeks, XYZ's price outperformed 98% of all other stocks. Stocks rated = above 80 in RS Rating can be considered strong performers, and stocks = below 70 in RS Rating can generally be considered laggard performers. = The Relative Price Strength Rating lets you compare any stock's price = performance against the rest of the over 10,000 stocks tracked in the = William O'Neil + Co. Incorporated database.' Here's DGO's definition of alpha: 'An expression of how much a = stock would have appreciated or depreciated on average every month over = the last 12 months, assuming the S&P 500 remained unchanged during the = period. For example, an ALPHA of 1.0 means the stock's price would have = appreciated at the rate of 1% per month over the last year, assuming an = unchanged S&P 500 Index. At least 260 days of price history are needed = to compute the Alpha data item. It is calculated at the end of every = trading week.'=20 Am I wrong in assuming that a high RS stock should have a high = alpha. Do they only correlate during a bull market. Now that I think = about it I think Yes. I wonder if I had done the above screen 3 years = ago how many stocks would have had alpha greater than 2. Is there any = methodology that tracks alpha for the stock universe and flags that = conditions are optimum if, say, the average alpha is greater than 1? = Just wondering. Or maybe I'm just being obtuse.=20 - ------=_NextPart_000_0021_01C16B05.509A9100 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV>Doug,</DIV> <DIV> </DIV> <DIV>Glad it was useful to you. One thing I = should note=20 is that I had a typo in example 1. Beta should have been =3D 1. = This is a=20 stock that has "equally volatility" to the market. There are some = excellent=20 studies done on beta, how it is derived, how "predictive" it is and = whether or=20 not it should be based on price performance vs. fundamentals. But really = only=20 worth reading if you need a sleeping pill! :))</DIV> <DIV> </DIV> <DIV>Katherine</DIV> <DIV><A=20 href=3D"mailto:kmalm@earthlink.net">kmalm@earthlink.net</A></DIV> <BLOCKQUOTE dir=3Dltr=20 style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20 <A title=3Ddzc@qwest.net href=3D"mailto:dzc@qwest.net">DougC</A> = </DIV> <DIV style=3D"FONT: 10pt arial">To: <A = title=3Dcanslim@lists.xmission.com=20 = href=3D"mailto:canslim@lists.xmission.com">canslim@lists.xmission.com</A>= </DIV> <DIV style=3D"FONT: 10pt arial">Sent: Sunday, November 11, 2001 = 10:46=20 PM</DIV> <DIV style=3D"FONT: 10pt arial">Subject: Re: [CANSLIM] Alpha = vs. RS</DIV> <DIV> </DIV>Hello Katherine Thanks very much for the = excellent=20 response. It's taking a while to sink in but I think I'm getting it. = Like the=20 formula simply shows and as WON has also tried to teach and as you = state;=20 there is a linear relationship between returns on a stock and returns = on a=20 market. You also pointed out that alpha is a single component on the = return of=20 a stock (Rs) and that RS is an indication of the return of the stock = versus=20 the return of the market. I still need to ponder this some more just = to make=20 sure I really do get it...and perhaps will end up finding myself a = book on=20 quantitative finance. Thanks again DougC At 12:47 AM = 11/11/01 -0600, you wrote: <BLOCKQUOTE cite type=3D"cite">Hi Doug, I'm having to reach way back into the deep recesses of my = brain to=20 pull out what little quantitative finance remains, but hope this = might help.=20 I'll start with a forumla that makes a = connection: <FONT=20 face=3Darial size=3D2>Return on a Stock =3D Rs Return on = the Market =3D=20 Rm Alpha =3D a Beta =3D b Rs =3D a +=20 b*Rm This is a = linear=20 relationship between returns on the market and returns on the=20 stock. Alpha just shows the portion of the stock's return = that is=20 *insensitive to* or *independent of* the market. Beta is a = constant that=20 shows an expected change in Rs given a change in Rm, that is, how=20 *sensitive* the return is to the market. (A narrow measure of = "volatility"=20 or "risk") Example 1: = b=3D0, Rm=3D0, a=3D1.=20 That would mean, on average, a stock is no more volatile than the = market and=20 would generate a 1% return, even if the market returns=20 nothing. Example 2: = b=3D3, Rm=3D1,=20 a=3D3. That would mean, on average, a stock is 3 times as volatile = as the=20 market and would generate a 6% return, when the market is returning=20 1%. There's all = sorts of=20 statistics, error measurement, etc. in this. But this is the = generally=20 accepted view of theoretical relative returns of an individual stock = against=20 the market. A fancy way of saying, "if I'm going to take the = addtional risk,=20 you better give me a return that's better than the market=20 average." In the = best equivalent=20 terms I can use to equate these variables, then, WON's Relative = Strength=20 Ranking "RS" =3D Rs/Rm You can see=20 that you cannot relate alpha and RS directly, as alpha is only a = single=20 component of the return on the stock (Rs). = <FONT=20 face=3Darial size=3D2>Hope this is helpful. But I'll warn you, if = you ask me too=20 many questions on this one, I'll have to go dig out my textbooks, = and they=20 are dustier than my brain! :)) Katherine <A=20 = href=3D"mailto:kmalm@earthlink.net">kmalm@earthlink.net</A> = - -----=20 Original Message -----=20 <BLOCKQUOTE> <DL> <DD>From: <A href=3D"mailto:dzc@qwest.net">DougC</A>=20 <DD>To: <A=20 = href=3D"mailto:canslim@lists.xmission.com">canslim@lists.xmission.com</A>= =20 <DD>Sent: Saturday, November 10, 2001 10:39 PM=20 <DD>Subject: [CANSLIM] Alpha vs. RS <DD>Never paid much attention to Alpha until recently. = Been=20 wondering how it correlates to RS. I just did a screen on DGO = looking=20 for stocks with alpha greater than 3 and used no other criteria. = Zero=20 stocks showed up. Then I lowered alpha to 2 and got 1 stock. = Then I=20 lowered alpha to 1 and got 41 stocks also with no other criteria = selected. Then I added a second criteria of RS of 80 to = the alpha=20 of 1 and that reduced my list further to 29 stocks. <DD>Here's DGO's definition of RS: 'Understanding the = price data=20 for stocks is the first step in becoming a smart investor. The = next step=20 is learning how to compare a particular stock's price = performance with=20 all the other stocks in the market. The Relative Price Strength = (RS)=20 Rating measures a stock's price movement over the last 12 months = and=20 compares it to all other stocks on the NYSE, NASDAQ, and AMEX = markets.=20 The results are ranked on a 1-99 scale, 99 being the strongest. = For=20 example, XYZ Corp. has a RS Rating of 98. This means that during = the=20 past 52 weeks, XYZ's price outperformed 98% of all other stocks. = Stocks=20 rated above 80 in RS Rating can be considered strong performers, = and=20 stocks below 70 in RS Rating can generally be considered laggard = performers. The Relative Price Strength Rating lets you compare = any=20 stock's price performance against the rest of the over 10,000 = stocks=20 tracked in the William O'Neil + Co. Incorporated = database.' <DD>Here's DGO's definition of alpha: 'An expression of how much = a stock=20 would have appreciated or depreciated on average every month = over the=20 last 12 months, assuming the S&P 500 remained unchanged = during the=20 period. For example, an ALPHA of 1.0 means the stock's price = would have=20 appreciated at the rate of 1% per month over the last year, = assuming an=20 unchanged S&P 500 Index. At least 260 days of price history = are=20 needed to compute the Alpha data item. It is calculated at the = end of=20 every trading week.' <DD>Am I wrong in assuming that a high RS stock should have a = high=20 alpha. Do they only correlate during a bull market. Now that I = think=20 about it I think Yes. I wonder if I had done the above screen 3 = years=20 ago how many stocks would have had alpha greater than 2. Is = there any=20 methodology that tracks alpha for the stock universe and flags = that=20 conditions are optimum if, say, the average alpha is greater = than 1?=20 Just wondering. Or maybe I'm just being obtuse.=20 = </DD></DL></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> - ------=_NextPart_000_0021_01C16B05.509A9100-- - - - -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, 11 Nov 2001 21:51:05 -0800 From: David Thompson <david@epud.net> Subject: Re: [CANSLIM] M in 2002 Tom I had the same problems with Frank Cochrane's prognosis on the market. However, I was glad that he said it because up markets climb a wall of worry. So I get worried when there isn't someone out there whispering (or screaming) that the market has no clothes. :-) David - - - -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: Mon, 12 Nov 2001 10:32:49 -0500 From: David Bojanowski <dbojanowski@csreit.com> Subject: RE: [CANSLIM] Stock Quotes into Excell This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. - ------_=_NextPart_001_01C16B8F.4D0ACFE8 Content-Type: text/plain; charset="iso-8859-1" We use BridgeStation at work and are able to pull real-time stock quotes from Bridge into Excel. The prices constantly update on Excel without us needing to refresh the screen, etc. I don't know if Bridge offers anything geared towards individual investors. - -----Original Message----- From: Jeff Salisbury [mailto:Jeff.Salisbury@WallStreet-LLC.com] Sent: Saturday, November 10, 2001 5:19 PM To: canslim@lists.xmission.com Subject: [CANSLIM] Stock Quotes into Excell Hello Everyone, I'm trying to find a software package that will allow me to enter a ticker in an Excel spreadsheet cell, and then program another cell to display the current price. I know there must be some DDE application out there that will do this. Can anyone point me in the right direction? Jeff - - -To subscribe/unsubscribe, email "majordomo@xmission.com" -In the email body, write "subscribe canslim" or -"unsubscribe canslim". Do not use quotes in your email. - ------_=_NextPart_001_01C16B8F.4D0ACFE8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 9"> <meta name=3DOriginator content=3D"Microsoft Word 9"> <link rel=3DFile-List href=3D"cid:filelist.xml@01C16B5B.F3BD4CF0">  <style>  </style> </head> <body lang=3DEN-US style=3D'tab-interval:.5in'> <div class=3DSection1> We use BridgeStation at work and are able to pull real-time stock quotes = from Bridge into Excel. The = prices constantly update on Excel without us needing to refresh the screen, = etc. I don’t know if Bridge = offers anything geared towards individual investors. = <o:p></o:p> <![if = !supportEmptyParas]> <![endif]><o:p></o:p>= -----Original Message----- From: Jeff Salisbury [mailto:Jeff.Salisbury@WallStreet-LLC.com] Sent: Saturday, November = 10, 2001 5:19 PM To: = canslim@lists.xmission.com Subject: [CANSLIM] Stock = Quotes into Excell <![if = !supportEmptyParas]> <![endif]><o:p></o:p> Hello Everyone, <o:p></o:p> I'm trying to find a software = package that will allow me to enter a ticker in an Excel spreadsheet cell, and then = program another cell to display the current price. I know there must be = some DDE application out there that will do this. Can anyone point me in = the right direction? <o:p></o:p> Jeff<o:p></o:p>= </div> </body> </html> - - - -To subscribe/unsubscribe, email "majordomo@xmission.com" - -In the email body, write "subscribe canslim" or - -"unsubscribe canslim". Do not use quotes in your email. - ------_=_NextPart_001_01C16B8F.4D0ACFE8-- - - - -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: Mon, 12 Nov 2001 11:23:09 -0500 From: "Tangen, Eric" <tangene@tycoelectronics.com> Subject: RE: [CANSLIM] Stock Quotes into Excell This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. - ------_=_NextPart_001_01C16B96.5176A140 Content-Type: text/plain Jeff, The quotes plus data feed lets you do exactly what you want to do here...you can access the quotes plus database as Excel functions or via VBA code in excell. http://www.qp2.com <http://www.qp2.com> But it is not real time...its end of day. Sounds like your after real time. ERIC TANGEN M/A-COM Dallas Design Center 100 N. Central Expressway Suite 200 Richardson, TX 75080 * tangene@tycoelectronics.com * (972) 234-4214 ext 15 <- New Extension ! - -----Original Message----- From: Jeff Salisbury [mailto:Jeff.Salisbury@WallStreet-LLC.com] Sent: Saturday, November 10, 2001 4:19 PM To: canslim@lists.xmission.com Subject: [CANSLIM] Stock Quotes into Excell Hello Everyone, I'm trying to find a software package that will allow me to enter a ticker in an Excel spreadsheet cell, and then program another cell to display the current price. I know there must be some DDE application out there that will do this. Can anyone point me in the right direction? Jeff - -To subscribe/unsubscribe, email "majordomo@xmission.com" -In the email body, write "subscribe canslim" or -"unsubscribe canslim". Do not use quotes in your email. - ------_=_NextPart_001_01C16B96.5176A140 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD> <BODY> <DIV>Jeff,=20 </DIV> <DIV>The=20 quotes plus data feed lets you do exactly what you want to do = here...you can=20 access the quotes plus database as Excel functions or via VBA code in=20 excell.</DIV> <DIV> </DIV> <DIV><A=20 href=3D"http://www.qp2.com">http://www.qp2.com</A></DIV> <DIV><SPAN=20 class=3D796061716-12112001> </DIV> <DIV><SPAN=20 class=3D796061716-12112001> </DIV> <DIV>But it=20 is not real time...its end of day. Sounds like your after real=20 time.</DIV> ERIC<FONT=20 color=3D#808080 face=3D"Dutch801 Rm BT" size=3D5> = TANGEN M/A-COM Dallas=20 Design=20 Center = = =20 100 N. Central Expressway = <FONT=20 face=3DTahoma size=3D2>Suite=20 200 &nb= sp; =20 Richardson, TX=20 75080 = <FONT=20 face=3D"Courier New"> * = <FONT=20 color=3D#0000ff face=3DArial = size=3D2>tangene@tycoelectronics.com<FONT=20 color=3D#0000ff face=3DArial size=3D2> ( = <FONT=20 color=3D#000000 face=3DArial size=3D2>(972) 234-4214=20 ext <I= > <FONT=20 color=3D#ff0000 face=3DArial>15 <- New = Extension=20 ! <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"> <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: Jeff Salisbury=20 [mailto:Jeff.Salisbury@WallStreet-LLC.com] Sent: Saturday, = November=20 10, 2001 4:19 PM To: = canslim@lists.xmission.com Subject:=20 [CANSLIM] Stock Quotes into Excell </DIV>Hello = Everyone,=20 I'm trying to find a software package that will allow me to enter = a ticker=20 in an Excel spreadsheet cell, and then program another cell to = display the=20 current price. I know there must be some DDE application out = there that=20 will do this. Can anyone point me in the right direction?=20 Jeff - -To subscribe/unsubscribe, email "majordomo@xmission.com" = - -In the=20 email body, write "subscribe canslim" or -"unsubscribe canslim". Do = not use=20 quotes in your email.</BLOCKQUOTE></BODY></HTML> - ------_=_NextPart_001_01C16B96.5176A140-- - - - -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 #1805 ****************************** 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.