20 New Messages
Digest #2271
Mon Jul 9, 2012 6:46 am (PDT) . Posted by: "antonvanas1989" antonvanas1989
Sorry i meant this link http://finance.yahoo.com/q?s=KO
Btw isnt it a good idea to add currency to the yahoo codes?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Looks to me like it's in a table cell on the page you cite -- try:
>
> =smfStrExtr(RCHGetTableCell("http://finance.yahoo.com/q/pr?s=KO ",0,"Currency
> in"),"in ",".")
>
> I have no idea about your other questions...
>
> On Sun, Jul 8, 2012 at 3:20 PM, antonvanas1989 <antonvanas1989@...>wrote:
>
> >
> > Now i try to get the currency from yahoo, I don't know from what page i
> > need to get that currency? The show it on every page but is it the same?
> >
> > And what formule should i use? It's not in a table and i aint get it with
> > the smfgettag, but probbly i doing someting wrong.
> >
> > http://finance.yahoo.com/q/pr?s=KO
> >
>
Btw isnt it a good idea to add currency to the yahoo codes?
--- In smf_addin@yahoogrou
>
> Looks to me like it's in a table cell on the page you cite -- try:
>
> =smfStrExtr(
> in"),"in ",".")
>
> I have no idea about your other questions...
>
> On Sun, Jul 8, 2012 at 3:20 PM, antonvanas1989 <antonvanas1989@
>
> >
> > Now i try to get the currency from yahoo, I don't know from what page i
> > need to get that currency? The show it on every page but is it the same?
> >
> > And what formule should i use? It's not in a table and i aint get it with
> > the smfgettag, but probbly i doing someting wrong.
> >
> > http://finance.
> >
>
Mon Jul 9, 2012 7:05 am (PDT) . Posted by: "Randy Harmelink" rharmelink
Yahoo codes are defined by Yahoo, not me. And not officially documented.
Hmm. "c4" looks like a possibility. Let me know.
For the cited URL, try:
=smfStrExtr(smfGetTagContent("http://finance.yahoo.com/q?s=KO ","div",-1,"Currency
in")," in ",".")
On Mon, Jul 9, 2012 at 6:46 AM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
> Sorry i meant this link http://finance.yahoo.com/q?s=KO
>
> Btw isnt it a good idea to add currency to the yahoo codes?
>
Hmm. "c4" looks like a possibility. Let me know.
For the cited URL, try:
=smfStrExtr(
in")," in ",".")
On Mon, Jul 9, 2012 at 6:46 AM, antonvanas1989 <antonvanas1989@
> Sorry i meant this link http://finance.
>
> Btw isnt it a good idea to add currency to the yahoo codes?
>
Mon Jul 9, 2012 3:59 pm (PDT) . Posted by: "antonvanas1989" antonvanas1989
Thanxs Randy!
Where does the "c4" come from on the Yahoo site?
can you help me out with the msn line you gave, i'm trying to only show the "US Dollar" im getting "US" with this line:
=smfStrExtr(smfGetTagContent("http://investing.money.msn.com/investments/financial-statements?symbol=KO ";"span",-1,"Financial Data in"),"in "," ")
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Yahoo codes are defined by Yahoo, not me. And not officially documented.
>
> Hmm. "c4" looks like a possibility. Let me know.
>
> For the cited URL, try:
>
> =smfStrExtr(smfGetTagContent("http://finance.yahoo.com/q?s=KO ","div",-1,"Currency
> in")," in ",".")
>
> On Mon, Jul 9, 2012 at 6:46 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > Sorry i meant this link http://finance.yahoo.com/q?s=KO
> >
> > Btw isnt it a good idea to add currency to the yahoo codes?
> >
>
Where does the "c4" come from on the Yahoo site?
can you help me out with the msn line you gave, i'm trying to only show the "US Dollar" im getting "US" with this line:
=smfStrExtr(
--- In smf_addin@yahoogrou
>
> Yahoo codes are defined by Yahoo, not me. And not officially documented.
>
> Hmm. "c4" looks like a possibility. Let me know.
>
> For the cited URL, try:
>
> =smfStrExtr(
> in")," in ",".")
>
> On Mon, Jul 9, 2012 at 6:46 AM, antonvanas1989 <antonvanas1989@
>
> > Sorry i meant this link http://finance.
> >
> > Btw isnt it a good idea to add currency to the yahoo codes?
> >
>
Mon Jul 9, 2012 4:31 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
"c4" is the Yahoo code you were asking about -- for RCHGetYahooQuotes().
Unless you meant something else by Yahoo code?
You told your extraction to stop at the first blank after "in " was found,
so you just get "US". In this case you need to create a dummy string at the
end, to aid the extraction, as in:
=smfStrExtr(smfGetTagContent("
http://investing.money.msn.com/investments/financial-statements?symbol=KO ","span",-1,"Financial
Data in")&"|","in ","|")
Note that I appended the "|" to the end of the tag content, so I had
something to delimit the end of the string to extract from the tag content.
On Mon, Jul 9, 2012 at 3:59 PM, antonvanas1989 <antonvanas1989@yahoo.com >wrote:
>
> Where does the "c4" come from on the Yahoo site?
>
> can you help me out with the msn line you gave, i'm trying to only show
> the "US Dollar" im getting "US" with this line:
> =smfStrExtr(smfGetTagContent("
> http://investing.money.msn.com/investments/financial-statements?symbol=KO ";"span",-1,"Financial
> Data in"),"in "," ")
>
Unless you meant something else by Yahoo code?
You told your extraction to stop at the first blank after "in " was found,
so you just get "US". In this case you need to create a dummy string at the
end, to aid the extraction, as in:
=smfStrExtr(
http://investing.
Data in")&"|","in ","|")
Note that I appended the "|" to the end of the tag content, so I had
something to delimit the end of the string to extract from the tag content.
On Mon, Jul 9, 2012 at 3:59 PM, antonvanas1989 <antonvanas1989@
>
> Where does the "c4" come from on the Yahoo site?
>
> can you help me out with the msn line you gave, i'm trying to only show
> the "US Dollar" im getting "US" with this line:
> =smfStrExtr(
> http://investing.
> Data in"),"in "," ")
>
Mon Jul 9, 2012 8:17 am (PDT) . Posted by: "ajtalukdar" ajtalukdar
Hi Randy,
Have these two files been removed from the "Uploads by Forum Members"? If so, please point me to where they are located.
Thanks in advance.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Take a look at these files in the "Uploads by Forum Members" folder:
>
> AdvFN-Data-Dump-2.xls
> AdvFN-Data-Dump-3.xls
>
> With the techniques in them, you should be able to use the RCHGetTableCell()
> function to get whatever you need from AdvFN.
>
> On Fri, May 22, 2009 at 9:49 AM, apierce <andypierce@...> wrote:
>
> > found this old message and have a question.
> >
> > I use your wonderful spreadsheet to get all the quarterly data for the past
> > 20 quarters from ADVFN. I figured out that this data actually goes back
> > many more years and I'd love to access that via RCHGetElementNumber. Right
> > now the FQs go from 1-20. Is there a reletively easy way to access the
> > earlier data using the RCHGetElementNumber function? I don't care much how
> > long it takes.
> >
> > Thanks in advance.
>
Have these two files been removed from the "Uploads by Forum Members"? If so, please point me to where they are located.
Thanks in advance.
--- In smf_addin@yahoogrou
>
> Take a look at these files in the "Uploads by Forum Members" folder:
>
> AdvFN-Data-Dump-
> AdvFN-Data-Dump-
>
> With the techniques in them, you should be able to use the RCHGetTableCell(
> function to get whatever you need from AdvFN.
>
> On Fri, May 22, 2009 at 9:49 AM, apierce <andypierce@
>
> > found this old message and have a question.
> >
> > I use your wonderful spreadsheet to get all the quarterly data for the past
> > 20 quarters from ADVFN. I figured out that this data actually goes back
> > many more years and I'd love to access that via RCHGetElementNumber
> > now the FQs go from 1-20. Is there a reletively easy way to access the
> > earlier data using the RCHGetElementNumber function? I don't care much how
> > long it takes.
> >
> > Thanks in advance.
>
Mon Jul 9, 2012 8:22 am (PDT) . Posted by: "Randy Harmelink" rharmelink
Those were both obsoleted when AdvFN updated their website structure a few
years ago. Check out the two newer smfGetAdvFNElement() templates.
On Mon, Jul 9, 2012 at 8:00 AM, ajtalukdar <ajtalukdar@yahoo.com > wrote:
>
> Have these two files been removed from the "Uploads by Forum Members"? If
> so, please point me to where they are located.
>
years ago. Check out the two newer smfGetAdvFNElement(
On Mon, Jul 9, 2012 at 8:00 AM, ajtalukdar <ajtalukdar@yahoo.
>
> Have these two files been removed from the "Uploads by Forum Members"? If
> so, please point me to where they are located.
>
Mon Jul 9, 2012 8:48 am (PDT) . Posted by: "christianilson79" christianilson79
Hey there,
I am sure this is a mistake of mine, but though I tried to correct it and searched the posted messages for solutions I could not deal with my issue.
Therefore your help is greatly appreciated on the following problem:
When I extract historical data from Yahoo with the following formula
=RCHGetYahooHistory($A$2;J$15;J$16;J$17;K$15;K$16;K$17)
where the linke cells contain the dates for the timespan I am interested in, it gives me exactly what I want, but for some tickers (e.g. GZF.F) the adjusted close prices are always a little higher, than what yahoo gives me, when I ask for the same data for the same timespan. All other values are exactly the ones yahoo gives me directly. Can anybody explain this to my please?
Thanks a lot in advance,
Chris
I am sure this is a mistake of mine, but though I tried to correct it and searched the posted messages for solutions I could not deal with my issue.
Therefore your help is greatly appreciated on the following problem:
When I extract historical data from Yahoo with the following formula
=RCHGetYahooHistory
where the linke cells contain the dates for the timespan I am interested in, it gives me exactly what I want, but for some tickers (e.g. GZF.F) the adjusted close prices are always a little higher, than what yahoo gives me, when I ask for the same data for the same timespan. All other values are exactly the ones yahoo gives me directly. Can anybody explain this to my please?
Thanks a lot in advance,
Chris
Mon Jul 9, 2012 8:53 am (PDT) . Posted by: "Randy Harmelink" rharmelink
It looks like a Yahoo error. If you look here:
http://finance.yahoo.com/q/hp?s=GZF.F
...it says the most recent close, on July 9, is $18.01. However, it says
the adjusted closing price is $18.03. So the add-in would adjust the $18.01
to be $18.03.
If that wasn't the issue, I'd need more details...
On Mon, Jul 9, 2012 at 8:43 AM, christianilson79 <
christian.weitert@googlemail.com > wrote:
>
> I am sure this is a mistake of mine, but though I tried to correct it and
> searched the posted messages for solutions I could not deal with my issue.
> Therefore your help is greatly appreciated on the following problem:
>
> When I extract historical data from Yahoo with the following formula
>
> =RCHGetYahooHistory($A$2;J$15;J$16;J$17;K$15;K$16;K$17)
>
> where the linke cells contain the dates for the timespan I am interested
> in, it gives me exactly what I want, but for some tickers (e.g. GZF.F) the
> adjusted close prices are always a little higher, than what yahoo gives me,
> when I ask for the same data for the same timespan. All other values are
> exactly the ones yahoo gives me directly. Can anybody explain this to my
> please?
>
> Thanks a lot in advance,
>
http://finance.
...it says the most recent close, on July 9, is $18.01. However, it says
the adjusted closing price is $18.03. So the add-in would adjust the $18.01
to be $18.03.
If that wasn't the issue, I'd need more details...
On Mon, Jul 9, 2012 at 8:43 AM, christianilson79 <
christian.weitert@
>
> I am sure this is a mistake of mine, but though I tried to correct it and
> searched the posted messages for solutions I could not deal with my issue.
> Therefore your help is greatly appreciated on the following problem:
>
> When I extract historical data from Yahoo with the following formula
>
> =RCHGetYahooHistory
>
> where the linke cells contain the dates for the timespan I am interested
> in, it gives me exactly what I want, but for some tickers (e.g. GZF.F) the
> adjusted close prices are always a little higher, than what yahoo gives me,
> when I ask for the same data for the same timespan. All other values are
> exactly the ones yahoo gives me directly. Can anybody explain this to my
> please?
>
> Thanks a lot in advance,
>
Tue Jul 10, 2012 12:31 am (PDT) . Posted by: "christianilson79" christianilson79
Thanks you for your fast answer. To give you more detail:
If I request the historical adjusted close for GZF.F from 21st of august 2006 to september the 18th 2006 at yahoo directly, it get 21,64 as adjusted close for the last day (18.09.2006). If I use the tool the value I get is 23,43. While all the other adjusted close values are biased in the same way, all the other data is just fine (high, low, close, volume...)
I hope that helps in understanding my problem. Thanks a lot for your help,
Chris
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It looks like a Yahoo error. If you look here:
>
> http://finance.yahoo.com/q/hp?s=GZF.F
>
> ...it says the most recent close, on July 9, is $18.01. However, it says
> the adjusted closing price is $18.03. So the add-in would adjust the $18.01
> to be $18.03.
>
> If that wasn't the issue, I'd need more details...
>
> On Mon, Jul 9, 2012 at 8:43 AM, christianilson79 <
> christian.weitert@...> wrote:
>
> >
> > I am sure this is a mistake of mine, but though I tried to correct it and
> > searched the posted messages for solutions I could not deal with my issue.
> > Therefore your help is greatly appreciated on the following problem:
> >
> > When I extract historical data from Yahoo with the following formula
> >
> > =RCHGetYahooHistory($A$2;J$15;J$16;J$17;K$15;K$16;K$17)
> >
> > where the linke cells contain the dates for the timespan I am interested
> > in, it gives me exactly what I want, but for some tickers (e.g. GZF.F) the
> > adjusted close prices are always a little higher, than what yahoo gives me,
> > when I ask for the same data for the same timespan. All other values are
> > exactly the ones yahoo gives me directly. Can anybody explain this to my
> > please?
> >
> > Thanks a lot in advance,
> >
>
If I request the historical adjusted close for GZF.F from 21st of august 2006 to september the 18th 2006 at yahoo directly, it get 21,64 as adjusted close for the last day (18.09.2006)
I hope that helps in understanding my problem. Thanks a lot for your help,
Chris
--- In smf_addin@yahoogrou
>
> It looks like a Yahoo error. If you look here:
>
> http://finance.
>
> ...it says the most recent close, on July 9, is $18.01. However, it says
> the adjusted closing price is $18.03. So the add-in would adjust the $18.01
> to be $18.03.
>
> If that wasn't the issue, I'd need more details...
>
> On Mon, Jul 9, 2012 at 8:43 AM, christianilson79 <
> christian.weitert@
>
> >
> > I am sure this is a mistake of mine, but though I tried to correct it and
> > searched the posted messages for solutions I could not deal with my issue.
> > Therefore your help is greatly appreciated on the following problem:
> >
> > When I extract historical data from Yahoo with the following formula
> >
> > =RCHGetYahooHistory
> >
> > where the linke cells contain the dates for the timespan I am interested
> > in, it gives me exactly what I want, but for some tickers (e.g. GZF.F) the
> > adjusted close prices are always a little higher, than what yahoo gives me,
> > when I ask for the same data for the same timespan. All other values are
> > exactly the ones yahoo gives me directly. Can anybody explain this to my
> > please?
> >
> > Thanks a lot in advance,
> >
>
Tue Jul 10, 2012 12:45 am (PDT) . Posted by: "Randy Harmelink" rharmelink
This is a Yahoo problem. If I look at that range of dates on the web page,
and refresh the web page several times, the adjusted closing prices change.
The CSV file used by the add-in is doing the same thing. I suspect one or
more servers at Yahoo aren't being updated properly and the differing
result is dependent on which server satisfies the data request.
On Tue, Jul 10, 2012 at 12:31 AM, christianilson79 <
christian.weitert@googlemail.com > wrote:
> Thanks you for your fast answer. To give you more detail:
>
> If I request the historical adjusted close for GZF.F from 21st of august
> 2006 to september the 18th 2006 at yahoo directly, it get 21,64 as adjusted
> close for the last day (18.09.2006). If I use the tool the value I get is
> 23,43. While all the other adjusted close values are biased in the same
> way, all the other data is just fine (high, low, close, volume...)
>
> I hope that helps in understanding my problem. Thanks a lot for your help,
>
and refresh the web page several times, the adjusted closing prices change.
The CSV file used by the add-in is doing the same thing. I suspect one or
more servers at Yahoo aren't being updated properly and the differing
result is dependent on which server satisfies the data request.
On Tue, Jul 10, 2012 at 12:31 AM, christianilson79 <
christian.weitert@
> Thanks you for your fast answer. To give you more detail:
>
> If I request the historical adjusted close for GZF.F from 21st of august
> 2006 to september the 18th 2006 at yahoo directly, it get 21,64 as adjusted
> close for the last day (18.09.2006)
> 23,43. While all the other adjusted close values are biased in the same
> way, all the other data is just fine (high, low, close, volume...)
>
> I hope that helps in understanding my problem. Thanks a lot for your help,
>
Mon Jul 9, 2012 9:02 am (PDT) . Posted by: "rtexican" rtexican
I have been using your Barchart Trend Spotter and for quite some time I receive an error in the Overall Opinion Area. This used to give the "Strong Buy" and other signals such as "Strong Sell". It appears that the "smf-elements-9" no longer has the text for that particular cell. This Opinion is on the Quotes and links to the Opinion page.
It also appears it will need another element number and definition. Thanks
It also appears it will need another element number and definition. Thanks
Mon Jul 9, 2012 9:11 am (PDT) . Posted by: "Randy Harmelink" rharmelink
I just updated the file with a fix for the overall opinion...
On Mon, Jul 9, 2012 at 9:02 AM, rtexican <RHerb505@charter.net > wrote:
> I have been using your Barchart Trend Spotter and for quite some time I
> receive an error in the Overall Opinion Area. This used to give the
> "Strong Buy" and other signals such as "Strong Sell". It appears that the
> "smf-elements-9" no longer has the text for that particular cell. This
> Opinion is on the Quotes and links to the Opinion page.
>
> It also appears it will need another element number and definition. Thanks
>
On Mon, Jul 9, 2012 at 9:02 AM, rtexican <RHerb505@charter.
> I have been using your Barchart Trend Spotter and for quite some time I
> receive an error in the Overall Opinion Area. This used to give the
> "Strong Buy" and other signals such as "Strong Sell". It appears that the
> "smf-elements-
> Opinion is on the Quotes and links to the Opinion page.
>
> It also appears it will need another element number and definition. Thanks
>
Mon Jul 9, 2012 1:18 pm (PDT) . Posted by: "Kermit W. Prather" kermitpra
Randy, I looking for dividend yield using the Reuters template from the
files section.
Either I do not know how to interpret the values in the dividend or they are
wrong.
I tried several stocks and all appeared to be incorrect.
Any chance you can point me to the URL that is used to retrieve this data?
So I can validate the results.
SMF-Template-Reuters-Ratios-Comparison.xls was just downloaded today.
Thanks,
Kermit
GE
Company
Industry
Sector
S&P 500
Valuation Ratios
P/E Ratio (TTM)
16.36
18.90
23.12
Error
P/E High - Last 5 Yrs.
16.87
38.56
62.85
Error
P/E Low - Last 5 Yrs.
9.11
20.60
15.47
Error
Beta
1.61
1.26
1.09
Error
Price to Sales (TTM)
1.47
0.71
1.74
Error
Price to Book (MRQ)
1.77
1.02
1.18
Error
Price to Tangible Book (MRQ)
6.06
1.67
1.73
Error
Price to Cash Flow (TTM)
8.81
13.74
14.24
Error
Price to Free Cash Flow (TTM)
16.74
18.68
30.45
Error
% Owned Institutions
0.0%
0.0%
0.0%
#VALUE!
Dividends
Dividend Yield
340.0%
161.0%
195.0%
Error
Dividend Yield - 5 Year Avg.
389.0%
82.0%
138.0%
Error
Dividend 5 Year Growth Rate
-995.0%
206.0%
489.0%
Error
Payout Ratio (TTM)
52.2%
13.4%
28.7%
#VALUE!
files section.
Either I do not know how to interpret the values in the dividend or they are
wrong.
I tried several stocks and all appeared to be incorrect.
Any chance you can point me to the URL that is used to retrieve this data?
So I can validate the results.
SMF-Template-
Thanks,
Kermit
GE
Company
Industry
Sector
S&P 500
Valuation Ratios
P/E Ratio (TTM)
16.36
18.90
23.12
Error
P/E High - Last 5 Yrs.
16.87
38.56
62.85
Error
P/E Low - Last 5 Yrs.
9.11
20.60
15.47
Error
Beta
1.61
1.26
1.09
Error
Price to Sales (TTM)
1.47
0.71
1.74
Error
Price to Book (MRQ)
1.77
1.02
1.18
Error
Price to Tangible Book (MRQ)
6.06
1.67
1.73
Error
Price to Cash Flow (TTM)
8.81
13.74
14.24
Error
Price to Free Cash Flow (TTM)
16.74
18.68
30.45
Error
% Owned Institutions
0.0%
0.0%
0.0%
#VALUE!
Dividends
Dividend Yield
340.0%
161.0%
195.0%
Error
Dividend Yield - 5 Year Avg.
389.0%
82.0%
138.0%
Error
Dividend 5 Year Growth Rate
-995.0%
206.0%
489.0%
Error
Payout Ratio (TTM)
52.2%
13.4%
28.7%
#VALUE!
Mon Jul 9, 2012 1:41 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
I just opened the one from the FILES area of the group and it's working
fine for me. All of my dividend fields are divided by 100, though. And the
S&P 500 fields are #VALUE instead of "Error", which is what would happen if
you tried to divide "Error" by 100.
The question is why aren't yours divided by 100?
For example, the formula I see for the Dividend Yield for the Company is:
=RCHGetElementNumber(Ticker,13666)/100
It doesn't work for all elements, but typically you can just pass "P-URL"
as the ticker symbol to find out the web page the data comes from.
On Mon, Jul 9, 2012 at 1:18 PM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> Randy, I looking for dividend yield using the Reuters template from the
> files section.****
>
> Either I do not know how to interpret the values in the dividend or they
> are wrong. ****
>
> ** **
>
> I tried several stocks and all appeared to be incorrect.****
>
> ** **
>
> Any chance you can point me to the URL that is used to retrieve this data?
> So I can validate the results.****
>
> ** **
>
> SMF-Template-Reuters-Ratios-Comparison.xls was just downloaded today. ****
>
> ** **
>
> Thanks,****
>
> Kermit****
>
> *GE***
>
> *Company*
>
> *Industry*
>
> *Sector*
>
> *S&P 500*
>
> *Valuation Ratios*
>
> * P/E Ratio (TTM) *
>
> 16.36****
>
> 18.90****
>
> 23.12****
>
> Error****
>
> * P/E High - Last 5 Yrs. *
>
> 16.87****
>
> 38.56****
>
> 62.85****
>
> Error****
>
> * P/E Low - Last 5 Yrs. *
>
> 9.11****
>
> 20.60****
>
> 15.47****
>
> Error****
>
> * Beta *
>
> 1.61****
>
> 1.26****
>
> 1.09****
>
> Error****
>
> * Price to Sales (TTM) *
>
> 1.47****
>
> 0.71****
>
> 1.74****
>
> Error****
>
> * Price to Book (MRQ) *
>
> 1.77****
>
> 1.02****
>
> 1.18****
>
> Error****
>
> * Price to Tangible Book (MRQ) *
>
> 6.06****
>
> 1.67****
>
> 1.73****
>
> Error****
>
> * Price to Cash Flow (TTM) *
>
> 8.81****
>
> 13.74****
>
> 14.24****
>
> Error****
>
> * Price to Free Cash Flow (TTM) *
>
> 16.74****
>
> 18.68****
>
> 30.45****
>
> Error****
>
> *% Owned Institutions*
>
> 0.0%****
>
> 0.0%****
>
> 0.0%****
>
> #VALUE!****
>
> * Dividends *
>
> * Dividend Yield *
>
> 340.0%****
>
> 161.0%****
>
> 195.0%****
>
> Error****
>
> * Dividend Yield - 5 Year Avg. *
>
> 389.0%****
>
> 82.0%****
>
> 138.0%****
>
> Error****
>
> * Dividend 5 Year Growth Rate *
>
> -995.0%****
>
> 206.0%****
>
> 489.0%****
>
> Error****
>
> * Payout Ratio (TTM) *
>
> 52.2%****
>
> 13.4%****
>
> 28.7%****
>
> #VALUE!****
>
> ** **
>
> ** **
>
>
fine for me. All of my dividend fields are divided by 100, though. And the
S&P 500 fields are #VALUE instead of "Error", which is what would happen if
you tried to divide "Error" by 100.
The question is why aren't yours divided by 100?
For example, the formula I see for the Dividend Yield for the Company is:
=RCHGetElementNumbe
It doesn't work for all elements, but typically you can just pass "P-URL"
as the ticker symbol to find out the web page the data comes from.
On Mon, Jul 9, 2012 at 1:18 PM, Kermit W. Prather
<kermitp@tampabay.
>
> Randy, I looking for dividend yield using the Reuters template from the
> files section.****
>
> Either I do not know how to interpret the values in the dividend or they
> are wrong. ****
>
> ** **
>
> I tried several stocks and all appeared to be incorrect.**
>
> ** **
>
> Any chance you can point me to the URL that is used to retrieve this data?
> So I can validate the results.****
>
> ** **
>
> SMF-Template-
>
> ** **
>
> Thanks,****
>
> Kermit****
>
> *GE***
>
> *Company*
>
> *Industry*
>
> *Sector*
>
> *S&P 500*
>
> *Valuation Ratios*
>
> * P/E Ratio (TTM) *
>
> 16.36****
>
> 18.90****
>
> 23.12****
>
> Error****
>
> * P/E High - Last 5 Yrs. *
>
> 16.87****
>
> 38.56****
>
> 62.85****
>
> Error****
>
> * P/E Low - Last 5 Yrs. *
>
> 9.11****
>
> 20.60****
>
> 15.47****
>
> Error****
>
> * Beta *
>
> 1.61****
>
> 1.26****
>
> 1.09****
>
> Error****
>
> * Price to Sales (TTM) *
>
> 1.47****
>
> 0.71****
>
> 1.74****
>
> Error****
>
> * Price to Book (MRQ) *
>
> 1.77****
>
> 1.02****
>
> 1.18****
>
> Error****
>
> * Price to Tangible Book (MRQ) *
>
> 6.06****
>
> 1.67****
>
> 1.73****
>
> Error****
>
> * Price to Cash Flow (TTM) *
>
> 8.81****
>
> 13.74****
>
> 14.24****
>
> Error****
>
> * Price to Free Cash Flow (TTM) *
>
> 16.74****
>
> 18.68****
>
> 30.45****
>
> Error****
>
> *% Owned Institutions*
>
> 0.0%****
>
> 0.0%****
>
> 0.0%****
>
> #VALUE!****
>
> * Dividends *
>
> * Dividend Yield *
>
> 340.0%****
>
> 161.0%****
>
> 195.0%****
>
> Error****
>
> * Dividend Yield - 5 Year Avg. *
>
> 389.0%****
>
> 82.0%****
>
> 138.0%****
>
> Error****
>
> * Dividend 5 Year Growth Rate *
>
> -995.0%****
>
> 206.0%****
>
> 489.0%****
>
> Error****
>
> * Payout Ratio (TTM) *
>
> 52.2%****
>
> 13.4%****
>
> 28.7%****
>
> #VALUE!****
>
> ** **
>
> ** **
>
>
Mon Jul 9, 2012 4:16 pm (PDT) . Posted by: "Kermit W. Prather" kermitpra
Thanks, Randy
The "P-URL" did not work in this case.
I downloaded the template again following the same steps I did the first time. This time the template has the divide by 100.
I can't explain how the divide by 100 was not in the first template as I did not change any cells in the template.
Thanks again, Sorry for troubling you.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Monday, July 09, 2012 4:41 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Dividend Yield on the Reuters template appears to be incorrect
I just opened the one from the FILES area of the group and it's working fine for me. All of my dividend fields are divided by 100, though. And the S&P 500 fields are #VALUE instead of "Error", which is what would happen if you tried to divide "Error" by 100.
The question is why aren't yours divided by 100?
For example, the formula I see for the Dividend Yield for the Company is:
=RCHGetElementNumber(Ticker,13666)/100
It doesn't work for all elements, but typically you can just pass "P-URL" as the ticker symbol to find out the web page the data comes from.
On Mon, Jul 9, 2012 at 1:18 PM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
Randy, I looking for dividend yield using the Reuters template from the files section.
Either I do not know how to interpret the values in the dividend or they are wrong.
I tried several stocks and all appeared to be incorrect.
Any chance you can point me to the URL that is used to retrieve this data? So I can validate the results.
SMF-Template-Reuters-Ratios-Comparison.xls was just downloaded today.
Thanks,
Kermit
GE
Company
Industry
Sector
S&P 500
Valuation Ratios
P/E Ratio (TTM)
16.36
18.90
23.12
Error
P/E High - Last 5 Yrs.
16.87
38.56
62.85
Error
P/E Low - Last 5 Yrs.
9.11
20.60
15.47
Error
Beta
1.61
1.26
1.09
Error
Price to Sales (TTM)
1.47
0.71
1.74
Error
Price to Book (MRQ)
1.77
1.02
1.18
Error
Price to Tangible Book (MRQ)
6.06
1.67
1.73
Error
Price to Cash Flow (TTM)
8.81
13.74
14.24
Error
Price to Free Cash Flow (TTM)
16.74
18.68
30.45
Error
% Owned Institutions
0.0%
0.0%
0.0%
#VALUE!
Dividends
Dividend Yield
340.0%
161.0%
195.0%
Error
Dividend Yield - 5 Year Avg.
389.0%
82.0%
138.0%
Error
Dividend 5 Year Growth Rate
-995.0%
206.0%
489.0%
Error
Payout Ratio (TTM)
52.2%
13.4%
28.7%
#VALUE!
The "P-URL" did not work in this case.
I downloaded the template again following the same steps I did the first time. This time the template has the divide by 100.
I can't explain how the divide by 100 was not in the first template as I did not change any cells in the template.
Thanks again, Sorry for troubling you.
Kermit
From: smf_addin@yahoogrou
Sent: Monday, July 09, 2012 4:41 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Dividend Yield on the Reuters template appears to be incorrect
I just opened the one from the FILES area of the group and it's working fine for me. All of my dividend fields are divided by 100, though. And the S&P 500 fields are #VALUE instead of "Error", which is what would happen if you tried to divide "Error" by 100.
The question is why aren't yours divided by 100?
For example, the formula I see for the Dividend Yield for the Company is:
=RCHGetElementNumbe
It doesn't work for all elements, but typically you can just pass "P-URL" as the ticker symbol to find out the web page the data comes from.
On Mon, Jul 9, 2012 at 1:18 PM, Kermit W. Prather <kermitp@tampabay.
Randy, I looking for dividend yield using the Reuters template from the files section.
Either I do not know how to interpret the values in the dividend or they are wrong.
I tried several stocks and all appeared to be incorrect.
Any chance you can point me to the URL that is used to retrieve this data? So I can validate the results.
SMF-Template-
Thanks,
Kermit
GE
Company
Industry
Sector
S&P 500
Valuation Ratios
P/E Ratio (TTM)
16.36
18.90
23.12
Error
P/E High - Last 5 Yrs.
16.87
38.56
62.85
Error
P/E Low - Last 5 Yrs.
9.11
20.60
15.47
Error
Beta
1.61
1.26
1.09
Error
Price to Sales (TTM)
1.47
0.71
1.74
Error
Price to Book (MRQ)
1.77
1.02
1.18
Error
Price to Tangible Book (MRQ)
6.06
1.67
1.73
Error
Price to Cash Flow (TTM)
8.81
13.74
14.24
Error
Price to Free Cash Flow (TTM)
16.74
18.68
30.45
Error
% Owned Institutions
0.0%
0.0%
0.0%
#VALUE!
Dividends
Dividend Yield
340.0%
161.0%
195.0%
Error
Dividend Yield - 5 Year Avg.
389.0%
82.0%
138.0%
Error
Dividend 5 Year Growth Rate
-995.0%
206.0%
489.0%
Error
Payout Ratio (TTM)
52.2%
13.4%
28.7%
#VALUE!
Mon Jul 9, 2012 4:35 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
Hmm. It works for me:
=RCHGetElementNumber("P-URL",13666)
...returns:
http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~
Just substitute the "~~~~~" string with a ticker symbol.
On Mon, Jul 9, 2012 at 4:16 PM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
>
> The "P-URL" did not work in this case. ****
>
> ** **
>
> I downloaded the template again following the same steps I did the first
> time. This time the template has the divide by 100. ****
>
> ** **
>
> I can't explain how the divide by 100 was not in the first template as I
> did not change any cells in the template.
>
=RCHGetElementNumbe
...returns:
http://www.reuters.
Just substitute the "~~~~~" string with a ticker symbol.
On Mon, Jul 9, 2012 at 4:16 PM, Kermit W. Prather
<kermitp@tampabay.
>
>
> The "P-URL" did not work in this case. ****
>
> ** **
>
> I downloaded the template again following the same steps I did the first
> time. This time the template has the divide by 100. ****
>
> ** **
>
> I can't explain how the divide by 100 was not in the first template as I
> did not change any cells in the template.
>
Mon Jul 9, 2012 6:55 pm (PDT) . Posted by: "SFWBEV" s.wasinger
25 is supposed to find the last price at MSN. I have noticed in last few weeks that it seems to be a day or so late. Is there something I am missing or doing wrong?
Mon Jul 9, 2012 8:11 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
Sorry, but that's what MSN is posting for last price...
You can use the RCHGetYahooQuotes() function to get current quotes data
from Yahoo.
On Mon, Jul 9, 2012 at 6:55 PM, SFWBEV <s.wasinger@yahoo.com > wrote:
> 25 is supposed to find the last price at MSN. I have noticed in last few
> weeks that it seems to be a day or so late. Is there something I am
> missing or doing wrong?
>
You can use the RCHGetYahooQuotes(
from Yahoo.
On Mon, Jul 9, 2012 at 6:55 PM, SFWBEV <s.wasinger@yahoo.
> 25 is supposed to find the last price at MSN. I have noticed in last few
> weeks that it seems to be a day or so late. Is there something I am
> missing or doing wrong?
>
Mon Jul 9, 2012 7:47 pm (PDT) . Posted by: "yobo100" yobo100
Ugh, I just traded in my PC for an imac but now have no idea how to create files on an imac to install the add in. Any experts out there that can post the steps for an apple illiterate like me?
Mon Jul 9, 2012 8:12 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
As I understand it, you need to create a Windows emulation environment for
everything to work. But I know nothing about Macs.
On Mon, Jul 9, 2012 at 7:47 PM, yobo100 <yobo100@yahoo.com > wrote:
> Ugh, I just traded in my PC for an imac but now have no idea how to create
> files on an imac to install the add in. Any experts out there that can
> post the steps for an apple illiterate like me?
>
everything to work. But I know nothing about Macs.
On Mon, Jul 9, 2012 at 7:47 PM, yobo100 <yobo100@yahoo.
> Ugh, I just traded in my PC for an imac but now have no idea how to create
> files on an imac to install the add in. Any experts out there that can
> post the steps for an apple illiterate like me?
>
Tidak ada komentar:
Posting Komentar