Go to Jeff Salisbury LWGate Home Page.From: "Katherine Malm" <kmalm@earthlink.net>
Subject: RE: [CANSLIM] Historical data in excell
Date: Sun, 30 Mar 2003 21:25:57 -0600
Next Article (by Subject): Re: [CANSLIM] Stock Analysis Sites to Look At "Gene Ricci"
Articles sorted by: [Date]
[Author]
[Subject]
Hi Roger, It all has to do with the period of time the stock is trading ex-dividend; that is, trading without the dividend attached. For example, look at the historical data for MMM: http://table.finance.yahoo.com/k?s=mmm&g=d Notice that on 3/28/03, the actual trading close and the adjusted close listed are both $130.31. However, look a bit further down the history and notice, for example, that the trading close on 2/18/03 was $126.61 and the adjusted close was $125.95. The difference between the two is the $0.66 cash dividend paid on 2/19. When you look at any charting program, the prices you see charted are always the *trading* open/high/low/close, not the cash dividend adjusted close. If you export historical data from Yahoo into a spreadsheet, they export the *adjusted* close rather than the trading close. During those periods where the stock is trading ex-dividend, you will therefore see a distortion if you use that data for charting manually. At the bottom of the historical data, you'll also see a link to Yahoo's FAQ which explains the differences between the trading and the dividend adjusted close. Katherine - -----Original Message----- From: owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com]On Behalf Of Roger Tawa Sent: Sunday, March 30, 2003 7:58 PM To: canslim@lists.xmission.com Subject: RE: [CANSLIM] Historical data in excell Hi Katherine, Can you explain (or send a link to an explanation of) how cash dividends adjust the price of a stock? Thanks. ================================================= Roger Tawa http://tawacentral.net/ [One thing about paradigms: shift happens.] [You ain't nothing yet.] -----Original Message----- From: owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com] On Behalf Of Katherine Malm Sent: Thursday, March 27, 2003 10:14 AM To: canslim@lists.xmission.com Subject: RE: [CANSLIM] Historical data in excell 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. - - - -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.
Next Article (by Subject): Re: [CANSLIM] Stock Analysis Sites to Look At "Gene Ricci"
Articles sorted by: [Date]
[Author]
[Subject]