Rabu, 15 Oktober 2014

[smf_addin] Digest Number 3208

14 Messages

Digest #3208
1b
Re: Option quotes from Yahoo by "Randy Harmelink" rharmelink
3a
Re: MSN data by obanduzzy
4a
Re: SMF-Template-Morningstar-Stock-Data by "Randy Harmelink" rharmelink
4b
5b
Re: Need Average Annual P/E ratios by "Randy Harmelink" rharmelink
6a
Re: 5 year income growth rate by "Chester Grablewski" cgrablew
6b
Re: 5 year income growth rate by "Randy Harmelink" rharmelink

Messages

Tue Oct 14, 2014 9:12 am (PDT) . Posted by:

CostelloT

Randy,

I have been using the smfGetYahooOptionQuote function for a long time and it recently started to return "Error" results. Has something changed with Yahoo or is there a better function and source for free option quotes? Here is the syntax I have been using:

=smfGetYahooOptionQuote(A6,LEFT(S6,1),D6,E6,"L")

where:
A6 = Underlying ticker symbol
S6 = Call or Put
D6 = Expiration Date
E6 = Strike

Thanks for your help and this awesome add-in!

Tony Costello

Tue Oct 14, 2014 1:20 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried this and it worked fine for me:

=smfGetYahooOptionQuote("SPY","C","10/18/2014",188,"L")

Could be Yahoo is missing some contracts, or had a temporary problem? Hard
to say without specific examples of errors that are repeatable.

I usually use OptionsXPress as the data source. It is slower though. But
since they have people actually trading based on the data they put up, I
expect it to be more accurate.

On Tue, Oct 14, 2014 at 9:12 AM, costellot@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have been using the smfGetYahooOptionQuote function for a long time
> and it recently started to return "Error" results. Has something changed
> with Yahoo or is there a better function and source for free option
> quotes? Here is the syntax I have been using:
>
> =smfGetYahooOptionQuote(A6,LEFT(S6,1),D6,E6,"L")
>
> where:
> A6 = Underlying ticker symbol
> S6 = Call or Put
> D6 = Expiration Date
> E6 = Strike
>

Tue Oct 14, 2014 11:54 am (PDT) . Posted by:

souloflineage

Hi,
I am trying to locate a way to download historical NYSE data. I tried the above function but am getting an error message. It does not seem to recognize "YahooMS". I also tried "YahooMS2";Are market stats for Yahoo no longer available? Is there an alternative way to get the data.
Thanks.

Tue Oct 14, 2014 1:31 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

All of the "YahooMS" items are working fine for me. The "YahooMS2" items
are now failing because Yahoo changed the URL. I'll have to fix that.

However, I'm confused by your reference to "historical data", since there
is only the current day's data there. You can get history from:

http://unicorn.us.com/advdec/

...but it may not match Yahoo's data. Different sources apparently have
different definitions of what's included in the statistics.

On Tue, Oct 14, 2014 at 11:54 AM, souloflineage@... wrote:

>
> I am trying to locate a way to download historical NYSE data. I tried the
> above function but am getting an error message. It does not seem to
> recognize "YahooMS". I also tried "YahooMS2";Are market stats for Yahoo no
> longer available? Is there an alternative way to get the data.
>

Tue Oct 14, 2014 3:13 pm (PDT) . Posted by:

souloflineage

Hi Randy,
Thank you fro the reply and the data source. I was hoping that I could get the historical data from Yahoo as well. Similar to historical individual ticker stock prices.
If that is not possible, I will use the data you directed me to. When I use =RCHGetElementNumber("YahooMS&quot;, 13822) I get a return of "Error".
Thanks for your help.

Tue Oct 14, 2014 4:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just double checked -- the "YahooMS" element definitions were redefined in
February of this year. If you still have the old smf-elements-2.txt file,
they won't work. You'd need the new one from the "Works in Progress" folder
on the web site. Hopefully, that's why mine is working and yours is not?

On Tue, Oct 14, 2014 at 3:13 PM, souloflineage@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> When I use =RCHGetElementNumber("YahooMS&quot;, 13822) I get a return of
> "Error".
>

Tue Oct 14, 2014 5:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

A new copy of the smf-elements-2.txt file has been uploaded to the "Works
in Progress" folder, with fixes for the Yahoo change in URL for the
"YahooMS2" element definitions.

On Tue, Oct 14, 2014 at 1:31 PM, Randy Harmelink <rharmelink@gmail.com>
wrote:

> The "YahooMS2"; items are now failing because Yahoo changed the URL. I'll
> have to fix that.
>

Tue Oct 14, 2014 12:57 pm (PDT) . Posted by:

obanduzzy

Those Bozos.

That was a big part of my spreadsheet. GRRRRRR


Tue Oct 14, 2014 5:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

OK. New element #14443 on smf-elements-4.txt, in the "Works in Progress"
folder on the web site. A new version of the template has also been
uploaded to the web site.

On Sun, Oct 5, 2014 at 2:34 PM, Jose Jacob pepecan47@...wrote:

> Hi Randy - what I am asking is to retrieve from the internet the value
> (USD or CAD) and write it in the template as a variable. Currently in the
> template the literal is a hard coded "USD".
>
> To do that I am suggesting to define al element # for the currency to use,
> and stick that in the spreadsheet.
>
> See the following page for an example of a Canadian stock:
>
> http://financials.morningstar.com/valuation/earnings-estimates.html?t=BCE
>
>
>

Tue Oct 14, 2014 7:37 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Randy - you are amazing. On behalf of the SMF community, thank you very much!!.

Regards,
Jose L. Jacob

--------------------------------------------
On Tue, 10/14/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] SMF-Template-Morningstar-Stock-Data
To: smf_addin@yahoogroups.com
Received: Tuesday, October 14, 2014, 8:13 PM


 









OK. New element #14443 on
smf-elements-4.txt, in the "Works in Progress"
folder on the web site. A new version of the template has
also been uploaded to the web site.

On Sun, Oct 5, 2014 at 2:34
PM, Jose Jacob pepecan47@...wrote:
Hi Randy - what I am
asking is to retrieve from the internet the value (USD or
CAD) and write it in the template as a variable. Currently
in the template the literal is a hard coded
"USD".



To do that I am suggesting to define al element # for the
currency to use, and stick that in the spreadsheet.



See the following page for an example of a Canadian
stock:



http://financials.morningstar.com/valuation/earnings-estimates.html?t=BCE

















#yiv1983006060 #yiv1983006060 --
#yiv1983006060ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv1983006060 #yiv1983006060ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv1983006060 #yiv1983006060ygrp-mkp #yiv1983006060hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv1983006060 #yiv1983006060ygrp-mkp #yiv1983006060ads {
margin-bottom:10px;}

#yiv1983006060 #yiv1983006060ygrp-mkp .yiv1983006060ad {
padding:0 0;}

#yiv1983006060 #yiv1983006060ygrp-mkp .yiv1983006060ad p {
margin:0;}

#yiv1983006060 #yiv1983006060ygrp-mkp .yiv1983006060ad a {
color:#0000ff;text-decoration:none;}
#yiv1983006060 #yiv1983006060ygrp-sponsor
#yiv1983006060ygrp-lc {
font-family:Arial;}

#yiv1983006060 #yiv1983006060ygrp-sponsor
#yiv1983006060ygrp-lc #yiv1983006060hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1983006060 #yiv1983006060ygrp-sponsor
#yiv1983006060ygrp-lc .yiv1983006060ad {
margin-bottom:10px;padding:0 0;}

#yiv1983006060 #yiv1983006060actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv1983006060 #yiv1983006060activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv1983006060 #yiv1983006060activity span {
font-weight:700;}

#yiv1983006060 #yiv1983006060activity span:first-child {
text-transform:uppercase;}

#yiv1983006060 #yiv1983006060activity span a {
color:#5085b6;text-decoration:none;}

#yiv1983006060 #yiv1983006060activity span span {
color:#ff7900;}

#yiv1983006060 #yiv1983006060activity span
.yiv1983006060underline {
text-decoration:underline;}

#yiv1983006060 .yiv1983006060attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv1983006060 .yiv1983006060attach div a {
text-decoration:none;}

#yiv1983006060 .yiv1983006060attach img {
border:none;padding-right:5px;}

#yiv1983006060 .yiv1983006060attach label {
display:block;margin-bottom:5px;}

#yiv1983006060 .yiv1983006060attach label a {
text-decoration:none;}

#yiv1983006060 blockquote {
margin:0 0 0 4px;}

#yiv1983006060 .yiv1983006060bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv1983006060 .yiv1983006060bold a {
text-decoration:none;}

#yiv1983006060 dd.yiv1983006060last p a {
font-family:Verdana;font-weight:700;}

#yiv1983006060 dd.yiv1983006060last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv1983006060 dd.yiv1983006060last p
span.yiv1983006060yshortcuts {
margin-right:0;}

#yiv1983006060 div.yiv1983006060attach-table div div a {
text-decoration:none;}

#yiv1983006060 div.yiv1983006060attach-table {
width:400px;}

#yiv1983006060 div.yiv1983006060file-title a, #yiv1983006060
div.yiv1983006060file-title a:active, #yiv1983006060
div.yiv1983006060file-title a:hover, #yiv1983006060
div.yiv1983006060file-title a:visited {
text-decoration:none;}

#yiv1983006060 div.yiv1983006060photo-title a,
#yiv1983006060 div.yiv1983006060photo-title a:active,
#yiv1983006060 div.yiv1983006060photo-title a:hover,
#yiv1983006060 div.yiv1983006060photo-title a:visited {
text-decoration:none;}

#yiv1983006060 div#yiv1983006060ygrp-mlmsg
#yiv1983006060ygrp-msg p a span.yiv1983006060yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1983006060 .yiv1983006060green {
color:#628c2a;}

#yiv1983006060 .yiv1983006060MsoNormal {
margin:0 0 0 0;}

#yiv1983006060 o {
font-size:0;}

#yiv1983006060 #yiv1983006060photos div {
float:left;width:72px;}

#yiv1983006060 #yiv1983006060photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv1983006060 #yiv1983006060photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv1983006060 #yiv1983006060reco-category {
font-size:77%;}

#yiv1983006060 #yiv1983006060reco-desc {
font-size:77%;}

#yiv1983006060 .yiv1983006060replbq {
margin:4px;}

#yiv1983006060 #yiv1983006060ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv1983006060 #yiv1983006060ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv1983006060 #yiv1983006060ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv1983006060 #yiv1983006060ygrp-mlmsg select,
#yiv1983006060 input, #yiv1983006060 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv1983006060 #yiv1983006060ygrp-mlmsg pre, #yiv1983006060
code {
font:115% monospace;}

#yiv1983006060 #yiv1983006060ygrp-mlmsg * {
line-height:1.22em;}

#yiv1983006060 #yiv1983006060ygrp-mlmsg #yiv1983006060logo {
padding-bottom:10px;}


#yiv1983006060 #yiv1983006060ygrp-msg p a {
font-family:Verdana;}

#yiv1983006060 #yiv1983006060ygrp-msg
p#yiv1983006060attach-count span {
color:#1E66AE;font-weight:700;}

#yiv1983006060 #yiv1983006060ygrp-reco
#yiv1983006060reco-head {
color:#ff7900;font-weight:700;}

#yiv1983006060 #yiv1983006060ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv1983006060 #yiv1983006060ygrp-sponsor #yiv1983006060ov
li a {
font-size:130%;text-decoration:none;}

#yiv1983006060 #yiv1983006060ygrp-sponsor #yiv1983006060ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1983006060 #yiv1983006060ygrp-sponsor #yiv1983006060ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv1983006060 #yiv1983006060ygrp-text {
font-family:Georgia;}

#yiv1983006060 #yiv1983006060ygrp-text p {
margin:0 0 1em 0;}

#yiv1983006060 #yiv1983006060ygrp-text tt {
font-size:120%;}

#yiv1983006060 #yiv1983006060ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv1983006060


Tue Oct 14, 2014 5:19 pm (PDT) . Posted by:

hattawayml

I have spent a lot of time looking, but I can't seem to find average annual P/E ratios (2000 to present preferably). I need them for a school project. If anyone could point me in the right direction it would be greatly appreciated.


Thanks,
Mason

Tue Oct 14, 2014 5:30 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Well, "average" is rather meaningless there, since it could mean the
average of monthly closing values, daily closing values, or even the end of
each 5 minutes of trading.

The closest I know of would be the closing, high, and low values from
AdvFN. They can be retrieved on a quarterly or annual basis. However, they
will be based on fiscal periods, not calendar periods, so they will not be
consistent from equity to equity, and thus not really comparable.

On Tue, Oct 14, 2014 at 5:11 PM, hattawayml@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I have spent a lot of time looking, but I can't seem to find average
> annual P/E ratios (2000 to present preferably). I need them for a school
> project. If anyone could point me in the right direction it would be
> greatly appreciated.
>

Tue Oct 14, 2014 5:29 pm (PDT) . Posted by:

"Chester Grablewski" cgrablew

Randy,

I was looking for 5 Year Income Growth Rate as opposed to Revenue Growth Rate. I found it on web at another site and I'm using GetTblCell to retrieve it but it's not there for many stocks. So if you have any other ideas please let me know.

Thanks,

Chuck
cgrablew@gmail.com

On Oct 12, 2014, at 3:11 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

>
> StockScouter is kaput as far as I know, unless someone else contracts for it when MSN's contract runs out.
>
> For the growth rate, how about:
>
> # Usage Source Element Template or Notes
> 14243 S MorningstarGR Key Ratios -- Revenue Growth -- 5-Year Average -- Year 1 SMF-Template-Morningstar-Key-Ratios.xls
>
> I just filtered the XLS file for things that contain "5" and "growth"...
>
> On Sun, Oct 12, 2014 at 5:48 AM, Chuck cgrablew@...wrote:
>
> Since msn changed its site, I have been unable to find another source for 5 yr income growth rate or stock scouter. Any ideas where I can get this data?
>
>
>

Tue Oct 14, 2014 5:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Take a look at the SMF-Template-Morningstar-Key-Ratios.xls template and see
if what you need is there.

On Tue, Oct 14, 2014 at 5:22 PM, Chester Grablewski cgrablew@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
> I was looking for 5 Year Income Growth Rate as opposed to Revenue Growth
> Rate. I found it on web at another site and I'm using GetTblCell to
> retrieve it but it's not there for many stocks. So if you have any other
> ideas please let me know.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.33

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)