7 New Messages
Digest #2355
| |
Messages
Tue Sep 25, 2012 5:57 am (PDT) . Posted by:
"Ron Spruell" hashky
I don't know your dividend calculation, but something like this should work. If you don't like "--", you could use 0.
=IF(ISNUMBER(Dividend Yield)=TRUE,+"Dividend calc","--")
Where Dividend Yield = Cell containing the Dividend Yield, and Dividend calc is your Dividend Calculation.
I am curious why you would use and Array calculation like =RCHGetYahooQuotes(A1:A25,"y"), where A1:A25 contains your stock symbols.
Or even Finviz.
Ron Spruell
>________________________________
> From: bobc94595 <conlonrc@comcast.net >
>To: smf_addin@yahoogroups.com
>Sent: Monday, September 24, 2012 2:36 PM
>Subject: [smf_addin] RCHGetElementNumber(ticker, 46) - Return "NA"
>
>
>
>I have a spreadsheet with one column which uses RCHGetElementNumber(ticker, 46), to get Dividend Rates for about 25 stocks. Those stocks that do not pay dividends return "NA", without the quotes. I am using that Dividend Rate column information to calculate another column of Dividend Income, but I get a #VALUE! in the Dividend Income column for any stock with an NA in the Dividend Rate column.
>Do you have a formula to convert NA to zero in the Dividend Rate column?
>
>
>
>
>
=IF(ISNUMBER(
Where Dividend Yield = Cell containing the Dividend Yield, and Dividend calc is your Dividend Calculation.
I am curious why you would use and Array calculation like =RCHGetYahooQuotes(
Or even Finviz.
Ron Spruell
>___________
> From: bobc94595 <conlonrc@comcast.
>To: smf_addin@yahoogrou
>Sent: Monday, September 24, 2012 2:36 PM
>Subject: [smf_addin] RCHGetElementNumber
>
>
>
>I have a spreadsheet with one column which uses RCHGetElementNumber
>Do you have a formula to convert NA to zero in the Dividend Rate column?
>
>
>
>
>
Tue Sep 25, 2012 6:12 am (PDT) . Posted by:
"Ron Spruell" hashky
That's why you would NOT use instead of use.
>________________________________
> From: Ron Spruell <hashky@yahoo.com >
>To: "smf_addin@yahoogroups.com " <smf_addin@yahoogroups.com >
>Sent: Tuesday, September 25, 2012 7:57 AM
>Subject: Re: [smf_addin] RCHGetElementNumber(ticker, 46) - Return "NA"
>
>
>
>I don't know your dividend calculation, but something like this should work. If you don't like "--", you could use 0.
>
>
>
>=IF(ISNUMBER(Dividend Yield)=TRUE,+"Dividend calc","--")
>Where Dividend Yield = Cell containing the Dividend Yield, and Dividend calc is your Dividend Calculation.
>
>
>I am curious why you would use and Array calculation like =RCHGetYahooQuotes(A1:A25,"y"), where A1:A25 contains your stock symbols.
>
>
>Or even Finviz.
>
>
>Ron Spruell
>
>
>>________________________________
>> From: bobc94595 <conlonrc@comcast.net >
>>To: smf_addin@yahoogroups.com
>>Sent: Monday, September 24, 2012 2:36 PM
>>Subject: [smf_addin] RCHGetElementNumber(ticker, 46) - Return "NA"
>>
>>
>>
>>I have a spreadsheet with one column which uses RCHGetElementNumber(ticker, 46), to get Dividend Rates for about 25 stocks. Those stocks that do not pay dividends return "NA", without the quotes. I am using that Dividend Rate column information to calculate another column of Dividend Income, but I get a #VALUE! in the Dividend Income column for any stock with an NA in the Dividend Rate column.
>>Do you have a formula to convert NA to zero in the Dividend Rate column?
>>
>>
>>
>>
>
>
>
>___________
> From: Ron Spruell <hashky@yahoo.
>To: "smf_addin@yahoogrou
>Sent: Tuesday, September 25, 2012 7:57 AM
>Subject: Re: [smf_addin] RCHGetElementNumber
>
>
>
>I don't know your dividend calculation, but something like this should work. If you don't like "--", you could use 0.
>
>
>
>=IF(ISNUMBER(
>Where Dividend Yield = Cell containing the Dividend Yield, and Dividend calc is your Dividend Calculation.
>
>
>I am curious why you would use and Array calculation like =RCHGetYahooQuotes(
>
>
>Or even Finviz.
>
>
>Ron Spruell
>
>
>>__________
>> From: bobc94595 <conlonrc@comcast.
>>To: smf_addin@yahoogrou
>>Sent: Monday, September 24, 2012 2:36 PM
>>Subject: [smf_addin] RCHGetElementNumber
>>
>>
>>
>>I have a spreadsheet with one column which uses RCHGetElementNumber
>>Do you have a formula to convert NA to zero in the Dividend Rate column?
>>
>>
>>
>>
>
>
>
Tue Sep 25, 2012 8:29 pm (PDT) . Posted by:
"bobc94595" bobc94595
Thanks, Ron, for taking the time to respond.
In order to visualize my very simple calculation, consider that I have stock symbols listed in column A- 1 through A-25, that column B1 through B25 lists the number of shares for each stock, that each cell within column C-1 through C-25 lists RCHGetElementNumber(ticker, 46) for the Dividend Rate for each stock listed in column A, and that column D-1 through D-25 is simply a formula multiplying, for example, B-1 by C-1 to arrive at the income from a particular stock in D-1.
For those stocks listed in column A which have dividends, and return that information, the calculation in column D works perfectly.
For those stocks listed in column A which do not pay dividends, the search return is NA in column C, and #VALUE! in column D, and I, therefore, cannot total column D to arrive at a total income figure.
I don't think I was using an Array calculation as you mentioned, and I tried using the formula that you suggested, but had difficulty in properly entering the formula. I then went to Excel Forum and, rather than trying to change NA to zero in column C, I instead successfully attacked column D to ignore all entries of #VALUE! with the following formula: =SUMIF(D4:D105,"<>#value!"). It seems to have worked fine.
Thanks for your effort.
--- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
>
> That's why you would NOT use instead of use.
>
>
>
>
> >________________________________
> > From: Ron Spruell <hashky@...>
> >To: "smf_addin@yahoogroups.com " <smf_addin@yahoogroups.com >
> >Sent: Tuesday, September 25, 2012 7:57 AM
> >Subject: Re: [smf_addin] RCHGetElementNumber(ticker, 46) - Return "NA"
> >
> >
> >Â
> >I don't know your dividend calculation, but something like this should work. If you don't like "--", you could use 0.
> >
> >
> >
> >=IF(ISNUMBER(Dividend Yield)=TRUE,+"Dividend calc","--")
> >Where Dividend Yield = Cell containing the Dividend Yield, and Dividend calc is your Dividend Calculation.
> >
> >
> >I am curious why you would use and Array calculation like =RCHGetYahooQuotes(A1:A25,"y"), where A1:A25 contains your stock symbols.
> >
> >
> >Or even Finviz.
> >
> >
> >Ron Spruell
> >
> >
> >>________________________________
> >> From: bobc94595 <conlonrc@...>
> >>To: smf_addin@yahoogroups.com
> >>Sent: Monday, September 24, 2012 2:36 PM
> >>Subject: [smf_addin] RCHGetElementNumber(ticker, 46) - Return "NA"
> >>
> >>
> >>Â
> >>I have a spreadsheet with one column which uses RCHGetElementNumber(ticker, 46), to get Dividend Rates for about 25 stocks. Those stocks that do not pay dividends return "NA", without the quotes. I am using that Dividend Rate column information to calculate another column of Dividend Income, but I get a #VALUE! in the Dividend Income column for any stock with an NA in the Dividend Rate column.
> >>Do you have a formula to convert NA to zero in the Dividend Rate column?
> >>
> >>
> >>
> >>
> >
> >
> >
>
In order to visualize my very simple calculation, consider that I have stock symbols listed in column A- 1 through A-25, that column B1 through B25 lists the number of shares for each stock, that each cell within column C-1 through C-25 lists RCHGetElementNumber
For those stocks listed in column A which have dividends, and return that information, the calculation in column D works perfectly.
For those stocks listed in column A which do not pay dividends, the search return is NA in column C, and #VALUE! in column D, and I, therefore, cannot total column D to arrive at a total income figure.
I don't think I was using an Array calculation as you mentioned, and I tried using the formula that you suggested, but had difficulty in properly entering the formula. I then went to Excel Forum and, rather than trying to change NA to zero in column C, I instead successfully attacked column D to ignore all entries of #VALUE! with the following formula: =SUMIF(D4:D105,
Thanks for your effort.
--- In smf_addin@yahoogrou
>
> That's why you would NOT use instead of use.
>
>
>
>
> >___________
> > From: Ron Spruell <hashky@...>
> >To: "smf_addin@yahoogrou
> >Sent: Tuesday, September 25, 2012 7:57 AM
> >Subject: Re: [smf_addin] RCHGetElementNumber
> >
> >
> >Â
> >I don't know your dividend calculation, but something like this should work. If you don't like "--", you could use 0.
> >
> >
> >
> >=IF(ISNUMBER(
> >Where Dividend Yield = Cell containing the Dividend Yield, and Dividend calc is your Dividend Calculation.
> >
> >
> >I am curious why you would use and Array calculation like =RCHGetYahooQuotes(
> >
> >
> >Or even Finviz.
> >
> >
> >Ron Spruell
> >
> >
> >>__________
> >> From: bobc94595 <conlonrc@..
> >>To: smf_addin@yahoogrou
> >>Sent: Monday, September 24, 2012 2:36 PM
> >>Subject: [smf_addin] RCHGetElementNumber
> >>
> >>
> >>Â
> >>I have a spreadsheet with one column which uses RCHGetElementNumber
> >>Do you have a formula to convert NA to zero in the Dividend Rate column?
> >>
> >>
> >>
> >>
> >
> >
> >
>
Tue Sep 25, 2012 6:23 am (PDT) . Posted by:
"lexstar" lexstar
I was using smfPricesByDates this past weekend and it works. Yesterday and today, when I went back to update my spreadsheet, it only gives me #NA.
Something going on with this function?
Everything was working fine before.
Something going on with this function?
Everything was working fine before.
Tue Sep 25, 2012 9:54 am (PDT) . Posted by:
"antonvanas1989" antonvanas1989
01-03-2012 - 34.35
12-30-2011 - 34.26
12-29-2011 - 34.36
I Get this. So the 34.26 is the same as your outcome, but still the problem here is that this 34.36 is not right.
if you split the 69.97 by 2 it's not 34.36 so the "34.36" is adjusted somehow.
--- In smf_addin@yahoogroups.com , "dguillett1" <dguillett1@...> wrote:
>
>
> 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@...
>
> From: antonvanas1989
> Sent: Saturday, September 22, 2012 2:31 PM
> To: smf_addin@yahoogroups.com
> 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%40yahoogroups.com, "dguillett1" <dguillett1@> wrote:
> >
> >
> >
> > Don Guillett
> > Microsoft Excel Developer
> > SalesAid Software
> > dguillett1@
> >
> > From: antonvanas1989
> > Sent: Wednesday, September 19, 2012 2:16 PM
> > To: mailto:smf_addin%40yahoogroups.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
> >
>
12-30-2011 - 34.26
12-29-2011 - 34.36
I Get this. So the 34.26 is the same as your outcome, but still the problem here is that this 34.36 is not right.
if you split the 69.97 by 2 it's not 34.36 so the "34.36" is adjusted somehow.
--- In smf_addin@yahoogrou
>
>
> 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@.
>
> 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
> >
>
Tue Sep 25, 2012 11:31 am (PDT) . Posted by:
"dguillett1" donaldb36
Talk to Yahoo....
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: antonvanas1989
Sent: Tuesday, September 25, 2012 11:54 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Yahoo Historical Prices - close
01-03-2012 - 34.35
12-30-2011 - 34.26
12-29-2011 - 34.36
I Get this. So the 34.26 is the same as your outcome, but still the problem here is that this 34.36 is not right.
if you split the 69.97 by 2 it's not 34.36 so the "34.36" is adjusted somehow.
--- In mailto:smf_addin%40yahoogroups.com, "dguillett1" <dguillett1@...> wrote:
>
>
> 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@...
>
> From: antonvanas1989
> Sent: Saturday, September 22, 2012 2:31 PM
> To: mailto:smf_addin%40yahoogroups.com
> 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%40yahoogroups.com, "dguillett1" <dguillett1@> wrote:
> >
> >
> >
> > Don Guillett
> > Microsoft Excel Developer
> > SalesAid Software
> > dguillett1@
> >
> > From: antonvanas1989
> > Sent: Wednesday, September 19, 2012 2:16 PM
> > To: mailto:smf_addin%40yahoogroups.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
> >
>
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: antonvanas1989
Sent: Tuesday, September 25, 2012 11:54 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Yahoo Historical Prices - close
01-03-2012 - 34.35
12-30-2011 - 34.26
12-29-2011 - 34.36
I Get this. So the 34.26 is the same as your outcome, but still the problem here is that this 34.36 is not right.
if you split the 69.97 by 2 it's not 34.36 so the "34.36" is adjusted somehow.
--- In mailto:smf_addin%
>
>
> 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@.
>
> From: antonvanas1989
> Sent: Saturday, September 22, 2012 2:31 PM
> To: mailto:smf_addin%
> 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
> >
>
Tue Sep 25, 2012 11:58 am (PDT) . Posted by:
"zarathustra_winced@yahoo.com" zarathustra_winced
The adjusted close is also adjusted for dividends.
Sent via BlackBerry by AT&T
-----Original Message-----
From: "antonvanas1989" <antonvanas1989@yahoo.com >
Sender: smf_addin@yahoogroups.com
Date: Tue, 25 Sep 2012 16:54:15
To: <smf_addin@yahoogroups.com >
Reply-To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Yahoo Historical Prices - close
01-03-2012 - 34.35
12-30-2011 - 34.26
12-29-2011 - 34.36
I Get this. So the 34.26 is the same as your outcome, but still the problem here is that this 34.36 is not right.
if you split the 69.97 by 2 it's not 34.36 so the "34.36" is adjusted somehow.
--- In smf_addin@yahoogroups.com , "dguillett1" <dguillett1@...> wrote:
>
>
> 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@...
>
> From: antonvanas1989
> Sent: Saturday, September 22, 2012 2:31 PM
> To: smf_addin@yahoogroups.com
> 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%40yahoogroups.com, "dguillett1" <dguillett1@> wrote:
> >
> >
> >
> > Don Guillett
> > Microsoft Excel Developer
> > SalesAid Software
> > dguillett1@
> >
> > From: antonvanas1989
> > Sent: Wednesday, September 19, 2012 2:16 PM
> > To: mailto:smf_addin%40yahoogroups.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
> >
>
------------------------------------
Yahoo! Groups Links
Sent via BlackBerry by AT&T
-----Original Message-----
From: "antonvanas1989" <antonvanas1989@
Sender: smf_addin@yahoogrou
Date: Tue, 25 Sep 2012 16:54:15
To: <smf_addin@yahoogrou
Reply-To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Yahoo Historical Prices - close
01-03-2012 - 34.35
12-30-2011 - 34.26
12-29-2011 - 34.36
I Get this. So the 34.26 is the same as your outcome, but still the problem here is that this 34.36 is not right.
if you split the 69.97 by 2 it's not 34.36 so the "34.36" is adjusted somehow.
--- In smf_addin@yahoogrou
>
>
> 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@.
>
> 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
> >
>
------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar