2 New Messages
Digest #2352
| |
Messages
Sat Sep 22, 2012 12:31 pm (PDT) . Posted by:
"antonvanas1989" antonvanas1989
The file gives the same close as on Yahoo, So "KO" is still 69.97 at close of 2011 and not 34.99
So the same bug as i am strugle with
--- In smf_addin@yahoogroups.com , "dguillett1" <dguillett1@...> wrote:
>
>
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@...
>
> From: antonvanas1989
> Sent: Wednesday, September 19, 2012 2:16 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Yahoo Historical Prices - close
>
>
> Hi Randy,
>
> Im looking at my sheet at the moment and i found a problem.
>
> The problem is i'm retrieving data from Yahoo and ADVFN. (I'm using those data together) Now is the problem Yahoo Historical Prices give me a close with's not adjusted by stocksplits.
>
> Example:
> Tick = KO
> Stocksplit = 13 august 2012 (2:1 split)
>
> Following data from Annual 2011
> before sp. after split
> Outstanding shares 2284 4568
> EPS 3.75 1.88
> Share Price 69.97 69.97
>
> P/E Ratio 18.66 37.32
>
> So my P/E ratio is doubling because of the 2:1 Split. Same for all other ratio's using Yahoo Historical Close price.
>
> Possible Fix 1: Fixing my sheet so Yahoo price close gets adjusted by splits
>
> Possible Fix 2: I think i'm not the only one with this, (Yahoo is showing the "Before adjustment at end of year price") But maybe it's better for Add-In to adjust these data by splits?
>
> How do you think about this bug?
>
> Greets Anton
>
So the same bug as i am strugle with
--- In smf_addin@yahoogrou
>
>
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@.
>
> From: antonvanas1989
> Sent: Wednesday, September 19, 2012 2:16 PM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Yahoo Historical Prices - close
>
>
> Hi Randy,
>
> Im looking at my sheet at the moment and i found a problem.
>
> The problem is i'm retrieving data from Yahoo and ADVFN. (I'm using those data together) Now is the problem Yahoo Historical Prices give me a close with's not adjusted by stocksplits.
>
> Example:
> Tick = KO
> Stocksplit = 13 august 2012 (2:1 split)
>
> Following data from Annual 2011
> before sp. after split
> Outstanding shares 2284 4568
> EPS 3.75 1.88
> Share Price 69.97 69.97
>
> P/E Ratio 18.66 37.32
>
> So my P/E ratio is doubling because of the 2:1 Split. Same for all other ratio's using Yahoo Historical Close price.
>
> Possible Fix 1: Fixing my sheet so Yahoo price close gets adjusted by splits
>
> Possible Fix 2: I think i'm not the only one with this, (Yahoo is showing the "Before adjustment at end of year price") But maybe it's better for Add-In to adjust these data by splits?
>
> How do you think about this bug?
>
> Greets Anton
>
Sat Sep 22, 2012 3:38 pm (PDT) . Posted by:
"dguillett1" donaldb36
Yahoo figures for KO shown on the file I sent. You can look at the data sheet for both or select actual or adjusted before updating.
From the Data sheet
01/05/2012 69.76 69.87 69.35 69.37 14,287,600 33.97
01/04/2012 69.91 70.07 69.50 69.70 14,239,200 34.13
01/03/2012 70.15 70.71 70.10 70.14 15,639,600 34.35
12/30/2011 70.00 70.29 69.97 69.97 7,862,000 34.26
12/29/2011 69.60 70.19 69.51 70.16 8,734,000 34.36
12/28/2011 69.82 70.05 69.40 69.51 8,210,000 34.04
12/27/2011 69.81 70.20 69.81 69.88 10,099,800 34.22
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: antonvanas1989
Sent: Saturday, September 22, 2012 2:31 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Yahoo Historical Prices - close
The file gives the same close as on Yahoo, So "KO" is still 69.97 at close of 2011 and not 34.99
So the same bug as i am strugle with
--- In mailto:smf_addin%
>
>
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@.
>
> From: antonvanas1989
> Sent: Wednesday, September 19, 2012 2:16 PM
> To: mailto:smf_addin%
> Subject: [smf_addin] Yahoo Historical Prices - close
>
>
> Hi Randy,
>
> Im looking at my sheet at the moment and i found a problem.
>
> The problem is i'm retrieving data from Yahoo and ADVFN. (I'm using those data together) Now is the problem Yahoo Historical Prices give me a close with's not adjusted by stocksplits.
>
> Example:
> Tick = KO
> Stocksplit = 13 august 2012 (2:1 split)
>
> Following data from Annual 2011
> before sp. after split
> Outstanding shares 2284 4568
> EPS 3.75 1.88
> Share Price 69.97 69.97
>
> P/E Ratio 18.66 37.32
>
> So my P/E ratio is doubling because of the 2:1 Split. Same for all other ratio's using Yahoo Historical Close price.
>
> Possible Fix 1: Fixing my sheet so Yahoo price close gets adjusted by splits
>
> Possible Fix 2: I think i'm not the only one with this, (Yahoo is showing the "Before adjustment at end of year price") But maybe it's better for Add-In to adjust these data by splits?
>
> How do you think about this bug?
>
> Greets Anton
>
Attachments with this message:
1 of 1 File(s)
Tidak ada komentar:
Posting Komentar