RE: [CANSLIM] Historical data in excell

From: "Katherine Malm" <kmalm@earthlink.net>
Subject: RE: [CANSLIM] Historical data in excell
Date: Thu, 27 Mar 2003 09:14:20 -0600

Next Article (by Date): Re: [CANSLIM] Fundamental Analysis: P/S - I Love You (Sometimes) "Tom Worley"
Previous Article (by Date): [CANSLIM] Historical data in excell =?iso-8859-1?Q?S=E9bastien_Derks?=
Top of Thread: [CANSLIM] Historical data in excell =?iso-8859-1?Q?S=E9bastien_Derks?=
Articles sorted by: [Date] [Author] [Subject]

Hi Sebastien,

In order to used the canned stock price chart in Excel, you'll need to 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, however,
because when you do an export to Excel, they include the *adjusted* closing
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 dividends.
In other words, your chart will not reflect the trading closes if the stock
pays a cash dividend.

Katherine

- -----Original Message-----
From: owner-canslim@lists.xmission.com
[mailto:owner-canslim@lists.xmission.com]On Behalf Of Sébastien Derks
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.

Go to Jeff Salisbury LWGate Home Page.