Selasa, 17 Maret 2015

[smf_addin] Digest Number 3359

11 Messages

Digest #3359

Messages

Mon Mar 16, 2015 6:24 am (PDT) . Posted by:

"Jose Jacob" pepecan47

Man, you are a genius. Thank you very much.

Regards,
Jose L. Jacob

--------------------------------------------
On Mon, 3/16/15, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Corporate Bonds Yield
To: smf_addin@yahoogroups.com
Received: Monday, March 16, 2015, 2:38 AM


 









Not sure what to tell you
-- I just pasted that formula into EXCEL and got back
1.83.

In the past,
I've had people report TRUE or FALSE when they actually
had pasted two formulas into the cell, so the second
"=" makes it a comparison of the two formula
values. But since you're giving me the formula, that
doesn't seem like it should apply...

On Sun,
Mar 15, 2015 at 5:09 PM, Jose Jacob pepecan47@wrote:
Hi Randy - I am trying
to get the 5Y AAA yield of corporate bonds. I get
"FALSE".



=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,">Corporate
Bonds",">5yr AAA")














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

#yiv5652251004 #yiv5652251004ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5652251004 #yiv5652251004ygrp-mkp #yiv5652251004hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5652251004 #yiv5652251004ygrp-mkp #yiv5652251004ads {
margin-bottom:10px;}

#yiv5652251004 #yiv5652251004ygrp-mkp .yiv5652251004ad {
padding:0 0;}

#yiv5652251004 #yiv5652251004ygrp-mkp .yiv5652251004ad p {
margin:0;}

#yiv5652251004 #yiv5652251004ygrp-mkp .yiv5652251004ad a {
color:#0000ff;text-decoration:none;}
#yiv5652251004 #yiv5652251004ygrp-sponsor
#yiv5652251004ygrp-lc {
font-family:Arial;}

#yiv5652251004 #yiv5652251004ygrp-sponsor
#yiv5652251004ygrp-lc #yiv5652251004hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5652251004 #yiv5652251004ygrp-sponsor
#yiv5652251004ygrp-lc .yiv5652251004ad {
margin-bottom:10px;padding:0 0;}

#yiv5652251004 #yiv5652251004actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv5652251004 #yiv5652251004activity span {
font-weight:700;}

#yiv5652251004 #yiv5652251004activity span:first-child {
text-transform:uppercase;}

#yiv5652251004 #yiv5652251004activity span a {
color:#5085b6;text-decoration:none;}

#yiv5652251004 #yiv5652251004activity span span {
color:#ff7900;}

#yiv5652251004 #yiv5652251004activity span
.yiv5652251004underline {
text-decoration:underline;}

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

#yiv5652251004 .yiv5652251004attach div a {
text-decoration:none;}

#yiv5652251004 .yiv5652251004attach img {
border:none;padding-right:5px;}

#yiv5652251004 .yiv5652251004attach label {
display:block;margin-bottom:5px;}

#yiv5652251004 .yiv5652251004attach label a {
text-decoration:none;}

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

#yiv5652251004 .yiv5652251004bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5652251004 .yiv5652251004bold a {
text-decoration:none;}

#yiv5652251004 dd.yiv5652251004last p a {
font-family:Verdana;font-weight:700;}

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

#yiv5652251004 dd.yiv5652251004last p
span.yiv5652251004yshortcuts {
margin-right:0;}

#yiv5652251004 div.yiv5652251004attach-table div div a {
text-decoration:none;}

#yiv5652251004 div.yiv5652251004attach-table {
width:400px;}

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

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

#yiv5652251004 div#yiv5652251004ygrp-mlmsg
#yiv5652251004ygrp-msg p a span.yiv5652251004yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5652251004 .yiv5652251004green {
color:#628c2a;}

#yiv5652251004 .yiv5652251004MsoNormal {
margin:0 0 0 0;}

#yiv5652251004 o {
font-size:0;}

#yiv5652251004 #yiv5652251004photos div {
float:left;width:72px;}

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

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

#yiv5652251004 #yiv5652251004reco-category {
font-size:77%;}

#yiv5652251004 #yiv5652251004reco-desc {
font-size:77%;}

#yiv5652251004 .yiv5652251004replbq {
margin:4px;}

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

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

#yiv5652251004 #yiv5652251004ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv5652251004 #yiv5652251004ygrp-mlmsg pre, #yiv5652251004
code {
font:115% monospace;}

#yiv5652251004 #yiv5652251004ygrp-mlmsg * {
line-height:1.22em;}

#yiv5652251004 #yiv5652251004ygrp-mlmsg #yiv5652251004logo {
padding-bottom:10px;}


#yiv5652251004 #yiv5652251004ygrp-msg p a {
font-family:Verdana;}

#yiv5652251004 #yiv5652251004ygrp-msg
p#yiv5652251004attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5652251004 #yiv5652251004ygrp-reco
#yiv5652251004reco-head {
color:#ff7900;font-weight:700;}

#yiv5652251004 #yiv5652251004ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5652251004 #yiv5652251004ygrp-sponsor #yiv5652251004ov
li a {
font-size:130%;text-decoration:none;}

#yiv5652251004 #yiv5652251004ygrp-sponsor #yiv5652251004ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5652251004 #yiv5652251004ygrp-sponsor #yiv5652251004ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5652251004 #yiv5652251004ygrp-text {
font-family:Georgia;}

#yiv5652251004 #yiv5652251004ygrp-text p {
margin:0 0 1em 0;}

#yiv5652251004 #yiv5652251004ygrp-text tt {
font-size:120%;}

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


Mon Mar 16, 2015 8:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Nope, nothing like that. Sorry. And, yup, delayed.

On Mon, Mar 16, 2015 at 12:54 AM, Pete Guy a330pete@...wrote:

>
> No, not the last last trade time, just the date/time at which the
> bid/offer being extracted was a valid quote. I'm assuming the data coming
> back is a delayed quote.
>

Mon Mar 16, 2015 9:44 am (PDT) . Posted by:

salarkhor

Hi Randy, I only started using this add-in yesterday, so I am still in the process of validating it. I have to say that I am really impressed about the possibilities, so I'd like to thank you deeply for sharing such a great plug-in.


So far everything seems to work fine, except for smfGetAdvFNElement: I get an "Error" for =smfGetAdvFNElement("MMM";"A";1;">Year End Date<") (I use ";" as separator)


As I'm a newby and don't want to waste your time asking silly questions, i have been through all the conversations, and here are the 2 things I did (none of them affected the "Error" message I got):


1 - as I am living in the Netherlands, links to "www.advfn[...]" are redirected to "uk.advfn[...]. Therefore I have created the file "smf-AdvFN-Prefix.txt" with "uk" in the folder "C:\SMF Add-In" where the add-in is stored. However, this still gives me the same error; this also holds when I type the link explicitly via =RCHGetTableCell("http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0";1; "year end date")


2 - I have changed my IE settings according to the recommendations here: https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/10464 https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/10464

Some background information:


- I use Windows 7
- Both Excel 2013 and Excel 2010 give the same "error" message
- The formula =smfGetAdvFNElement("KO";"A";999) gives "Stock Market Functions add-in, Version 2.1.2014.01.30 (C:\SMF Add-In; uk; 31)"


Do you have any idea what might be the issue here? Please let me know if I forgot to mention other relevant details. I'd appreciate your support. Great work.
Kind regards,
Sal








---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :

As far as I know, as long as that is where you're redirected, but I have no way to test it myself.

"UK" was just an example.


On Wed, Feb 12, 2014 at 1:41 AM, <carron948@... mailto:carron948@...> wrote:
Do you have to this for Australia as well ue "AU" in the "smf-AdvFN-Prefix.txt" file.
---In smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com, <rharmelink@...> wrote:

What you can do is create a file in the same folder as add-in, called "smf-AdvFN-Prefix.txt", All the file should contain is the two letters "uk". You can create the file with Notepad. This file overrides the add-in default, and the add-in will then use the "uk" version of the URL instead of the default "www" version of the URL.

You'll need the 2.1.2012.12.29 version of the add-in for this to work...
On Sun, Jan 27, 2013 at 7:26 AM, Rosendo Manuel <rosendo.jose@... mailto:rosendo.jose@...> wrote:

I'm living in Lisbon (Portugal) and you are right. When I entered your suggested address the browser redirected me to "http://uk.advfn.com/p.php?pid=financials&symbol=MMM http://uk.advfn.com/p.php?pid=financials&symbol=MMM".
Is there a way to force it to work properly (as I desire, of course :))?












Mon Mar 16, 2015 9:56 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You also need the beta version of the add-in to access AdvFN data, because
AdvFN just changed their web site earlier this month and I had to make
coding changes to the functions -- see:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28118

That ZIP file should also contain any updated element definitions from that
folder.

On Mon, Mar 16, 2015 at 9:10 AM, salarkhor@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I only started using this add-in yesterday, so I am still in the process
> of validating it. I have to say that I am really impressed about the
> possibilities, so I'd like to thank you deeply for sharing such a great
> plug-in.
>
> So far everything seems to work fine, except for smfGetAdvFNElement: I get
> an "Error" for =smfGetAdvFNElement("MMM";"A";1;">Year End Date<") (I use
> ";" as separator)
>
> As I'm a newby and don't want to waste your time asking silly questions, i
> have been through all the conversations, and here are the 2 things I did
> (none of them affected the "Error" message I got):
>
> 1 - as I am living in the Netherlands, links to "www.advfn[...]" are
> redirected to "uk.advfn[...]. Therefore I have created the file "smf-AdvFN-Prefix.txt"
> with "uk" in the folder "C:\SMF Add-In" where the add-in is stored.
> However, this still gives me the same error; this also holds when I type
> the link explicitly via =RCHGetTableCell("
> http://uk.advfn.com/p.php?pid=financials&symbol=KO&mode=annual_reports&start_date=0";1;
> "year end date")
>
> 2 - I have changed my IE settings according to the recommendations here:
> https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/10464
>
>
> Some background information:
> - I use Windows 7
> - Both Excel 2013 and Excel 2010 give the same "error" message
> - The formula =smfGetAdvFNElement("KO";"A";999) gives "Stock Market
> Functions add-in, Version 2.1.2014.01.30 (C:\SMF Add-In; uk; 31)"
>
> Do you have any idea what might be the issue here? Please let me know if I
> forgot to mention other relevant details. I'd appreciate your support.
> Great work.
>
>

Mon Mar 16, 2015 10:56 am (PDT) . Posted by:

"SaL" salarkhor

Great. The beta version has indeed solved the issue. Thank you so much for the prompt reply, much appreciated. 

Mon Mar 16, 2015 11:41 am (PDT) . Posted by:

mayedamax

The Morningstar Category Ranks, numbers 4915-4923, are returning 0 values. The other data points being pulled from the same table are also incorrect, excluding the total return (4888-4896), which is correct. 4897-4905 is pulling data from the table, but it does not match its description in smf-elements-4.




Thanks for your help.

Mon Mar 16, 2015 11:42 am (PDT) . Posted by:

mayedamax

Randy,


Thanks for creating this great tool, I just downloaded it and am very excited by the possibilities. I am having trouble with the morningstar category ranks, codes 4915-4923 in smf-elements-4. 4915-4923 are returning a zero value; as I looked into codes 4897-4914, they seemed to be returning the wrong data. 4897-4905 is pulling +/- SP500 instead of vs category trailing returns, and 4906-4923 is pulling data that I cannot find on that table on the morningstar website.


Could you help me change the numbers in smf-elements-4 to pull the correct data? Thank you so much.

Mon Mar 16, 2015 12:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried it for VFINX, and it's matching the numbers I see on the web
page:

http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=VFINX

However, that page is no longer linked to by anything on MorningStar, so it
will probably go away at some point. At some point, I need to change the
element definitions to go to one or more of these:

http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=SPECX
http://performance.morningstar.com/Performance/fund/performance-history.action?t=SPECX
http://performance.morningstar.com/Performance/fund/historical-returns.action?y=15&freq=q&t=SPECX
http://performance.morningstar.com/Performance/fund/historical-returns.action?y=15&freq=m&t=SPECX

When I first defined all of the stock and mutual fund elements, I went to
their "print page" because it had EVERYTHING on it in one place. It reduced
the need to go out and get multiple web pages for data (the real bottleneck
in the data retrieval process). Now, MorningStar has piece-mealed
everything out into separate pages for each collection of data. That means
a lot more web pages need to be retrieved to get the data.

On Mon, Mar 16, 2015 at 10:14 AM, mayedamax@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Thanks for creating this great tool, I just downloaded it and am very
> excited by the possibilities. I am having trouble with the morningstar
> category ranks, codes 4915-4923 in smf-elements-4. 4915-4923 are returning
> a zero value; as I looked into codes 4897-4914, they seemed to be returning
> the wrong data. 4897-4905 is pulling +/- SP500 instead of vs category
> trailing returns, and 4906-4923 is pulling data that I cannot find on that
> table on the morningstar website.
>
> Could you help me change the numbers in smf-elements-4 to pull the correct
> data? Thank you so much.
>
>

Mon Mar 16, 2015 1:17 pm (PDT) . Posted by:

mayedamax

Got it. Thanks for answering so quickly! That is unfortunate that they did that, I will wait to pull those data points until later. Thanks

Mon Mar 16, 2015 2:18 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I have trouble getting the syntax correct every time I try to download a table using the RCHGetHTMLTable function

In this case I am trying to download the Dividend date and payout from this link:
http://www.dividendinformation.com/search_ticker/?identifier=
where the symbol is in cell A1 my example symbol is IBM

Dividend table is the 5th table on the webpage.

The table consist of 3 columns, header are Date, amount per share, and Note (after looking at over 100 symbols, I have not seen any note in the third column)

I know how to create the array based on page 36 of the documentation for the function.

I just can't seem to get the syntax correct for the array.

Thanks,

Kermit

Mon Mar 16, 2015 2:33 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's the most basic form of the function:

=RCHGetHTMLTable("
http://www.dividendinformation.com/search_ticker/?identifier="&B3,"Amount
Per Share",-1,"",1)

I usually try to use the header of a column within the table, then go
backwards to the beginning of the table (i.e. -1) and forwards to the end
of the table (i.e. 1). In fact, that is so often the way it goes that the
beta version of the add-in now has default values of those last three
parameters. So now, with the version of the add-in I use (2015.03.05), I
just need:

=RCHGetHTMLTable("
http://www.dividendinformation.com/search_ticker/?identifier="&B3,"Amount
Per Share")

On Mon, Mar 16, 2015 at 2:18 PM, 'Kermit W. Prather' kermitp@... wrote:

>
> I have trouble getting the syntax correct every time I try to download a
> table using the RCHGetHTMLTable function
>
>
>
> In this case I am trying to download the Dividend date and payout from
> this link:
>
> http://www.dividendinformation.com/search_ticker/?identifier=
>
> where the symbol is in cell A1 my example symbol is IBM
>
>
>
> Dividend table is the 5th table on the webpage.
>
>
>
> The table consist of 3 columns, header are Date, amount per share, and
> Note (after looking at over 100 symbols, I have not seen any note in the
> third column)
>
>
>
> I know how to create the array based on page 36 of the documentation for
> the function.
>
>
>
> I just can't seem to get the syntax correct for the array.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar