Selasa, 02 Juni 2015

[smf_addin] Digest Number 3421

9 Messages

Digest #3421

Messages

Mon Jun 1, 2015 3:52 am (PDT) . Posted by:

"Qinrong Fu" qrfu2003

Dear Randy,The SMF add-in of Excel is a very good function for web data application especially in daily stock data monitoring. Thanks a lot for your effort!Right now Microsoft announced the Excel add-in is ready to use in Excel app in ipad. I would like to know if any schedule to make it avalible to use SMF add-in in ipad or already there?
Best Regards,Qinrong

Mon Jun 1, 2015 4:02 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Since I don't have an iPad, and have no intention of getting one, the
add-in won't be available for the iPad. In any case, the add-in is written
in VBA and uses some Windows load libraries, neither of which are available
for use on the iPad. At least from the documentation I've seen.

On Mon, Jun 1, 2015 at 1:12 AM, Qinrong Fu qrfu2003@... wrote:

>
> Dear Randy,
> The SMF add-in of Excel is a very good function for web data application
> especially in daily stock data monitoring. Thanks a lot for your effort!
> Right now Microsoft announced the Excel add-in is ready to use in Excel
> app in ipad. I would like to know if any schedule to make it avalible to
> use SMF add-in in ipad or already there?
>
> Best Regards,
> Qinrong
>

Mon Jun 1, 2015 11:40 am (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy, Using a variation of the below formula, is it possible to get the percentage of the latest dividend increase?

Regards,
Jose L. Jacob

--------------------------------------------
On Sat, 5/9/15, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] TTM dividend using RCHGetYahooHistory
To: smf_addin@yahoogroups.com
Received: Saturday, May 9, 2015, 11:55 PM


 









Your parameter values are
not in the correct places -- try something like:

=SUM(INDEX(RCHGetYahooHistory(A3,,,,,,,"v",,0,,,4,2),,2))

...although that assumes
it pays a quarterly dividend. To truly get TTM, you should
specify a starting date and ending date. For example, if the
ending date of the 12-month period is in cell A4:

=SUM(INDEX(RCHGetYahooHistory(A3,YEAR(A4)-1,MONTH(A4),DAY(A4),YEAR(A4),MONTH(A4),DAY(A4),"v",,0,,,20,2),,2))

On Sat, May 9, 2015 at 8:18
PM, Jose Jacob pepecan47@yahoo.ca
[smf_addin] <smf_addin@yahoogroups.com>
wrote:
I need some help. I am trying to get the TTM
dividend for a stock, the dividend amount for the last 12
months.



For the 50 days MA I use



=AVERAGE(RCHGetYahooHistory(A3,,,,,,,,"A",0,1,,50,1))





Similarly, For the dividends in the last 4 periods I am
trying



=SUM(RCHGetYahooHistory(A3,,,,,,,"v",0,1,,4,1))



but I get a result of 0.












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

#yiv5158513917 #yiv5158513917ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5158513917 #yiv5158513917ygrp-mkp #yiv5158513917hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5158513917 #yiv5158513917ygrp-mkp #yiv5158513917ads {
margin-bottom:10px;}

#yiv5158513917 #yiv5158513917ygrp-mkp .yiv5158513917ad {
padding:0 0;}

#yiv5158513917 #yiv5158513917ygrp-mkp .yiv5158513917ad p {
margin:0;}

#yiv5158513917 #yiv5158513917ygrp-mkp .yiv5158513917ad a {
color:#0000ff;text-decoration:none;}
#yiv5158513917 #yiv5158513917ygrp-sponsor
#yiv5158513917ygrp-lc {
font-family:Arial;}

#yiv5158513917 #yiv5158513917ygrp-sponsor
#yiv5158513917ygrp-lc #yiv5158513917hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5158513917 #yiv5158513917ygrp-sponsor
#yiv5158513917ygrp-lc .yiv5158513917ad {
margin-bottom:10px;padding:0 0;}

#yiv5158513917 #yiv5158513917actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv5158513917 #yiv5158513917activity span {
font-weight:700;}

#yiv5158513917 #yiv5158513917activity span:first-child {
text-transform:uppercase;}

#yiv5158513917 #yiv5158513917activity span a {
color:#5085b6;text-decoration:none;}

#yiv5158513917 #yiv5158513917activity span span {
color:#ff7900;}

#yiv5158513917 #yiv5158513917activity span
.yiv5158513917underline {
text-decoration:underline;}

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

#yiv5158513917 .yiv5158513917attach div a {
text-decoration:none;}

#yiv5158513917 .yiv5158513917attach img {
border:none;padding-right:5px;}

#yiv5158513917 .yiv5158513917attach label {
display:block;margin-bottom:5px;}

#yiv5158513917 .yiv5158513917attach label a {
text-decoration:none;}

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

#yiv5158513917 .yiv5158513917bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5158513917 .yiv5158513917bold a {
text-decoration:none;}

#yiv5158513917 dd.yiv5158513917last p a {
font-family:Verdana;font-weight:700;}

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

#yiv5158513917 dd.yiv5158513917last p
span.yiv5158513917yshortcuts {
margin-right:0;}

#yiv5158513917 div.yiv5158513917attach-table div div a {
text-decoration:none;}

#yiv5158513917 div.yiv5158513917attach-table {
width:400px;}

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

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

#yiv5158513917 div#yiv5158513917ygrp-mlmsg
#yiv5158513917ygrp-msg p a span.yiv5158513917yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5158513917 .yiv5158513917green {
color:#628c2a;}

#yiv5158513917 .yiv5158513917MsoNormal {
margin:0 0 0 0;}

#yiv5158513917 o {
font-size:0;}

#yiv5158513917 #yiv5158513917photos div {
float:left;width:72px;}

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

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

#yiv5158513917 #yiv5158513917reco-category {
font-size:77%;}

#yiv5158513917 #yiv5158513917reco-desc {
font-size:77%;}

#yiv5158513917 .yiv5158513917replbq {
margin:4px;}

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

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

#yiv5158513917 #yiv5158513917ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv5158513917 #yiv5158513917ygrp-mlmsg pre, #yiv5158513917
code {
font:115% monospace;}

#yiv5158513917 #yiv5158513917ygrp-mlmsg * {
line-height:1.22em;}

#yiv5158513917 #yiv5158513917ygrp-mlmsg #yiv5158513917logo {
padding-bottom:10px;}


#yiv5158513917 #yiv5158513917ygrp-msg p a {
font-family:Verdana;}

#yiv5158513917 #yiv5158513917ygrp-msg
p#yiv5158513917attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5158513917 #yiv5158513917ygrp-reco
#yiv5158513917reco-head {
color:#ff7900;font-weight:700;}

#yiv5158513917 #yiv5158513917ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5158513917 #yiv5158513917ygrp-sponsor #yiv5158513917ov
li a {
font-size:130%;text-decoration:none;}

#yiv5158513917 #yiv5158513917ygrp-sponsor #yiv5158513917ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5158513917 #yiv5158513917ygrp-sponsor #yiv5158513917ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5158513917 #yiv5158513917ygrp-text {
font-family:Georgia;}

#yiv5158513917 #yiv5158513917ygrp-text p {
margin:0 0 1em 0;}

#yiv5158513917 #yiv5158513917ygrp-text tt {
font-size:120%;}

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


Mon Jun 1, 2015 12:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Year over year:

=SUM(INDEX(RCHGetYahooHistory(A3,YEAR(A4)-1,MONTH(A4),DAY(A4),YEAR(A4),MONTH(A4),DAY(A4),"v",,0,,,20,2),,2))/SUM(INDEX(RCHGetYahooHistory(A3,YEAR(A4)-2,MONTH(A4),DAY(A4),YEAR(A4)-1,MONTH(A4),DAY(A4),"v",,0,,,20,2),,2))-1

Payment over payment:

=INDEX(RCHGetYahooHistory(A3,,,,,,,"v",,0,,,1,2),1,2)/INDEX(RCHGetYahooHistory(A3,,,,,,,"v",,0,,,2,2),2,2)-1

Note that the date-based formulas may have an issue. Suppose one year they
pay a quarterly dividend on May 31st and the next year they pay it on May
28th. If you look at the year from May 31 to May 31, you'll get five
quarterly payments. Which technically *is* what they paid in that year. :(

On Mon, Jun 1, 2015 at 11:40 AM, Jose Jacob pepecan47@... wrote:

> Hi Randy, Using a variation of the below formula, is it possible to get
> the percentage of the latest dividend increase?
>
>

Mon Jun 1, 2015 3:38 pm (PDT) . Posted by:

jharlan

Hi,

I'm sorry but I don't see the analysts recommendation in the Morningstar template. Is there more than one? Thanks,

Mon Jun 1, 2015 4:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't know what you're looking at -- almost the entire template is
analyst-related data.

SMF-Template-Morningstar-Stock-Data.xls
<http://ogres-crypt.com/SMF/Templates/SMF-Template-Morningstar-Stock-Data.xls>

On Mon, Jun 1, 2015 at 3:38 PM, jharlan@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm sorry but I don't see the analysts recommendation in the Morningstar
> template. Is there more than one? Thanks,
>
>

Mon Jun 1, 2015 8:26 pm (PDT) . Posted by:

hjreed@swbell.net

Randy
I'm having trouble pulling Predefined Scan Results from StockCharts. (http://stockcharts.com/def/servlet/SC.scan)


This worked till a couple of weeks ago
=IF(A1="y",RCHGetHTMLTable("http://stockcharts.com/def/servlet/SC.scan?s=TXAL%5bT.T_EQ_S%5d!%5bAS0,20,TV_GT_40000%5d!%5bWW_EQ_1%5d!%5bWW1_EQ_0%5d","Symbol&quot;,-1,"",1),"")


I array enter but it started returning empty cells.


Did StockCharts change to format of these pages or am I doing something else incorrect?


Thank You
H.J.


Mon Jun 1, 2015 8:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Looks like they changed the web page. Each column header is a table of its
own. Did you used to be able to resort the table based on the content of
the columns?

I get the table (without headers) if I change your final "1" parameter to a
"10". That may change from scan to scan, depending on the number of
columns. Another way to go:

=RCHGetHTMLTable("
http://stockcharts.com/def/servlet/SC.scan?s=TXAL%5bT.T_EQ_S%5d!%5bAS0,20,TV_GT_40000%5d!%5bWW_EQ_1%5d!%5bWW1_EQ_0%5d",">Symbol",-1,">Scan
Definition",-1)

On Mon, Jun 1, 2015 at 8:26 PM, hjreed@... wrote:

>
> I'm having trouble pulling Predefined Scan Results from StockCharts. (
> http://stockcharts.com/def/servlet/SC.scan)
>
> This worked till a couple of weeks ago
>
> =IF(A1="y",RCHGetHTMLTable("
> http://stockcharts.com/def/servlet/SC.scan?s=TXAL%5bT.T_EQ_S%5d!%5bAS0,20,TV_GT_40000%5d!%5bWW_EQ_1%5d!%5bWW1_EQ_0%5d
> ","Symbol",-1,"",1),"")
>
> I array enter but it started returning empty cells.
>
> Did StockCharts change to format of these pages or am I doing something
> else incorrect?
>
>

Mon Jun 1, 2015 9:24 pm (PDT) . Posted by:

hjreed@swbell.net

I didn't resort it, I picked tickers off that I ran through other calculations...


This works for me!


I appreciate your time in helping me (really all of us!).




For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar