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 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 >kmalm@earthlink.net > >----- Original Message ----- >>From: DougC >>To: 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" 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
kmalm@earthlink.net
 
- ----- Original Message -----
From: DougC
To: 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-- - - - -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" 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
Doug,
 
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! :))
 
Katherine
kmalm@earthlink.net
----- Original Message -----
From:=20 DougC =
Sent: Sunday, November 11, 2001 = 10:46=20 PM
Subject: Re: [CANSLIM] Alpha = vs. RS

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:
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:
 
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). =
 
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
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=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.

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.'

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.'

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 =

- ------=_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 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 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

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-- - - - -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" 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 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
Jeff,=20
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.
 
http://www.qp2.com
 
 
But it=20 is not real time...its end of day. Sounds like your after real=20 time.

ERIC = TANGEN

M/A-COM
Dallas=20 Design=20 Center           =             =     =20
100 N. Central Expressway =
Suite=20 200           &nb= sp;     =20
Richardson, TX=20 75080            =
 * = tangene@tycoelectronics.com 
( = (972) 234-4214=20 ext   15 <- New = Extension=20 !

-----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

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.

- ------_=_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.