RE: [CANSLIM] Historical data in excell

From: Roger Tawa <rogerta@videotron.ca>
Subject: RE: [CANSLIM] Historical data in excell
Date: Sun, 30 Mar 2003 20:58:06 -0500

Next Article (by Author): Re: [CANSLIM] Stock Analysis Sites to Look At "Tom Worley"
Previous Article (by Author): Re: [CANSLIM] It's official. Nanocap CANSLIM works ... "Norman Boyd"
Articles sorted by: [Date] [Author] [Subject]

Hi Katherine,

Can you explain (or send a link to an explanation of) how cash divide=
nds
adjust the price of a stock?  Thanks.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D
Roger Tawa
http://tawacentral.net/
[One thing about paradigms: shift happens.]
[You ain't nothing yet.]

 -----Original Message-----
=46rom: =09owner-canslim@lists.xmission.com
[mailto:owner-canslim@lists.xmission.com]  On Behalf Of Katherine Mal=
m
Sent:=09Thursday, March 27, 2003 10:14 AM
To:=09canslim@lists.xmission.com
Subject:=09RE: [CANSLIM] Historical data in excell

Hi Sebastien,

In order to used the canned stock price chart in Excel, you'll need t=
o move
the location of the "volume" column as exported from Yahoo. Here's a =
quick
example so that you can see how the data needs to look:

http://www.cwhcharts.com/katherine/ChartYahooData.xls

Be very careful when using the exported Yahoo historical data, howeve=
r,
because when you do an export to Excel, they include the *adjusted* c=
losing
price rather than the actual closing price. That's not a problem when=
 they
pay stock dividends (splits) but a big problem when they pay cash div=
idends.
In other words, your chart will not reflect the trading closes if the=
 stock
pays a cash dividend.

Katherine

- -----Original Message-----
=46rom: owner-canslim@lists.xmission.com
[mailto:owner-canslim@lists.xmission.com]On Behalf Of S=E9bastien Der=
ks
Sent: Thursday, March 27, 2003 6:21 AM
To: canslim@lists.xmission.com
Subject: [CANSLIM] Historical data in excell


Can anyone explain how to make a chart with historical date from
finance.yahoo.com in Excel. I tried it with the stock and it tells me=
 to
put it into a certain order but it just does not work.


Thanks.

PS

Maybe an example excel sheet would be nice. Thanks :).



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

Go to Jeff Salisbury LWGate Home Page.