Selasa, 14 April 2015

[smf_addin] Digest Number 3382

12 Messages

Digest #3382

Messages

Mon Apr 13, 2015 4:35 am (PDT) . Posted by:

"V. Shankar" tarakayan


| Stock Market Functions add-in, Version 2.1.2012.07.09 (C:\Program Files\SMF Add-In; 1) |
| 167.07 |

This is what I get...I need to download and install the latest?....This notebook I rarely use and while on travel..

On Friday, April 10, 2015 8:26 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  I doubt it's the operating system. Are you sure you have the add-in installed properly? No unresolved links?

If you open a new workbook, what do you get for:

=RCHGetElementNumber("Version")
=RCHGetYahooQuotes("MMM","l1")

On Fri, Apr 10, 2015 at 6:35 AM, 'V. Shankar' tarakayan@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

SMF addin works fine in my Windows 8.1 system...Recently, in my windows xp Dell Vostro notebook, not able to see rchgetyahooquotes functions working (or appearing in excel cells)....what could be the problem?

#yiv3584425763 #yiv3584425763 -- #yiv3584425763ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3584425763 #yiv3584425763ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3584425763 #yiv3584425763ygrp-mkp #yiv3584425763hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3584425763 #yiv3584425763ygrp-mkp #yiv3584425763ads {margin-bottom:10px;}#yiv3584425763 #yiv3584425763ygrp-mkp .yiv3584425763ad {padding:0 0;}#yiv3584425763 #yiv3584425763ygrp-mkp .yiv3584425763ad p {margin:0;}#yiv3584425763 #yiv3584425763ygrp-mkp .yiv3584425763ad a {color:#0000ff;text-decoration:none;}#yiv3584425763 #yiv3584425763ygrp-sponsor #yiv3584425763ygrp-lc {font-family:Arial;}#yiv3584425763 #yiv3584425763ygrp-sponsor #yiv3584425763ygrp-lc #yiv3584425763hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3584425763 #yiv3584425763ygrp-sponsor #yiv3584425763ygrp-lc .yiv3584425763ad {margin-bottom:10px;padding:0 0;}#yiv3584425763 #yiv3584425763actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3584425763 #yiv3584425763activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3584425763 #yiv3584425763activity span {font-weight:700;}#yiv3584425763 #yiv3584425763activity span:first-child {text-transform:uppercase;}#yiv3584425763 #yiv3584425763activity span a {color:#5085b6;text-decoration:none;}#yiv3584425763 #yiv3584425763activity span span {color:#ff7900;}#yiv3584425763 #yiv3584425763activity span .yiv3584425763underline {text-decoration:underline;}#yiv3584425763 .yiv3584425763attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3584425763 .yiv3584425763attach div a {text-decoration:none;}#yiv3584425763 .yiv3584425763attach img {border:none;padding-right:5px;}#yiv3584425763 .yiv3584425763attach label {display:block;margin-bottom:5px;}#yiv3584425763 .yiv3584425763attach label a {text-decoration:none;}#yiv3584425763 blockquote {margin:0 0 0 4px;}#yiv3584425763 .yiv3584425763bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3584425763 .yiv3584425763bold a {text-decoration:none;}#yiv3584425763 dd.yiv3584425763last p a {font-family:Verdana;font-weight:700;}#yiv3584425763 dd.yiv3584425763last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3584425763 dd.yiv3584425763last p span.yiv3584425763yshortcuts {margin-right:0;}#yiv3584425763 div.yiv3584425763attach-table div div a {text-decoration:none;}#yiv3584425763 div.yiv3584425763attach-table {width:400px;}#yiv3584425763 div.yiv3584425763file-title a, #yiv3584425763 div.yiv3584425763file-title a:active, #yiv3584425763 div.yiv3584425763file-title a:hover, #yiv3584425763 div.yiv3584425763file-title a:visited {text-decoration:none;}#yiv3584425763 div.yiv3584425763photo-title a, #yiv3584425763 div.yiv3584425763photo-title a:active, #yiv3584425763 div.yiv3584425763photo-title a:hover, #yiv3584425763 div.yiv3584425763photo-title a:visited {text-decoration:none;}#yiv3584425763 div#yiv3584425763ygrp-mlmsg #yiv3584425763ygrp-msg p a span.yiv3584425763yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3584425763 .yiv3584425763green {color:#628c2a;}#yiv3584425763 .yiv3584425763MsoNormal {margin:0 0 0 0;}#yiv3584425763 o {font-size:0;}#yiv3584425763 #yiv3584425763photos div {float:left;width:72px;}#yiv3584425763 #yiv3584425763photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3584425763 #yiv3584425763photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3584425763 #yiv3584425763reco-category {font-size:77%;}#yiv3584425763 #yiv3584425763reco-desc {font-size:77%;}#yiv3584425763 .yiv3584425763replbq {margin:4px;}#yiv3584425763 #yiv3584425763ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3584425763 #yiv3584425763ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3584425763 #yiv3584425763ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3584425763 #yiv3584425763ygrp-mlmsg select, #yiv3584425763 input, #yiv3584425763 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3584425763 #yiv3584425763ygrp-mlmsg pre, #yiv3584425763 code {font:115% monospace;}#yiv3584425763 #yiv3584425763ygrp-mlmsg * {line-height:1.22em;}#yiv3584425763 #yiv3584425763ygrp-mlmsg #yiv3584425763logo {padding-bottom:10px;}#yiv3584425763 #yiv3584425763ygrp-msg p a {font-family:Verdana;}#yiv3584425763 #yiv3584425763ygrp-msg p#yiv3584425763attach-count span {color:#1E66AE;font-weight:700;}#yiv3584425763 #yiv3584425763ygrp-reco #yiv3584425763reco-head {color:#ff7900;font-weight:700;}#yiv3584425763 #yiv3584425763ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3584425763 #yiv3584425763ygrp-sponsor #yiv3584425763ov li a {font-size:130%;text-decoration:none;}#yiv3584425763 #yiv3584425763ygrp-sponsor #yiv3584425763ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3584425763 #yiv3584425763ygrp-sponsor #yiv3584425763ov ul {margin:0;padding:0 0 0 8px;}#yiv3584425763 #yiv3584425763ygrp-text {font-family:Georgia;}#yiv3584425763 #yiv3584425763ygrp-text p {margin:0 0 1em 0;}#yiv3584425763 #yiv3584425763ygrp-text tt {font-size:120%;}#yiv3584425763 #yiv3584425763ygrp-vital ul li:last-child {border-right:none !important;}#yiv3584425763

Mon Apr 13, 2015 5:09 am (PDT) . Posted by:

"V. Shankar" tarakayan



I think the problem was due to reading off my "flash drive" and it was referring to smf in my other notebook drive.
I copied the files to this notebook desktop and checked/changed the links again in the cell formula....all values appeared...will check it again and report.
Thanks for your quick response, as always..
Shankar
On Monday, April 13, 2015 5:05 PM, "'V. Shankar' tarakayan@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:  
| Stock Market Functions add-in, Version 2.1.2012.07.09 (C:\Program Files\SMF Add-In; 1) |
| 167.07 |

This is what I get...I need to download and install the latest?....This notebook I rarely use and while on travel..

On Friday, April 10, 2015 8:26 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  I doubt it's the operating system. Are you sure you have the add-in installed properly? No unresolved links?

If you open a new workbook, what do you get for:

=RCHGetElementNumber("Version")
=RCHGetYahooQuotes("MMM","l1")

On Fri, Apr 10, 2015 at 6:35 AM, 'V. Shankar' tarakayan@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

SMF addin works fine in my Windows 8.1 system...Recently, in my windows xp Dell Vostro notebook, not able to see rchgetyahooquotes functions working (or appearing in excel cells)....what could be the problem?

#yiv3514393939 #yiv3514393939 -- #yiv3514393939ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3514393939 #yiv3514393939ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3514393939 #yiv3514393939ygrp-mkp #yiv3514393939hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3514393939 #yiv3514393939ygrp-mkp #yiv3514393939ads {margin-bottom:10px;}#yiv3514393939 #yiv3514393939ygrp-mkp .yiv3514393939ad {padding:0 0;}#yiv3514393939 #yiv3514393939ygrp-mkp .yiv3514393939ad p {margin:0;}#yiv3514393939 #yiv3514393939ygrp-mkp .yiv3514393939ad a {color:#0000ff;text-decoration:none;}#yiv3514393939 #yiv3514393939ygrp-sponsor #yiv3514393939ygrp-lc {font-family:Arial;}#yiv3514393939 #yiv3514393939ygrp-sponsor #yiv3514393939ygrp-lc #yiv3514393939hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3514393939 #yiv3514393939ygrp-sponsor #yiv3514393939ygrp-lc .yiv3514393939ad {margin-bottom:10px;padding:0 0;}#yiv3514393939 #yiv3514393939actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3514393939 #yiv3514393939activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3514393939 #yiv3514393939activity span {font-weight:700;}#yiv3514393939 #yiv3514393939activity span:first-child {text-transform:uppercase;}#yiv3514393939 #yiv3514393939activity span a {color:#5085b6;text-decoration:none;}#yiv3514393939 #yiv3514393939activity span span {color:#ff7900;}#yiv3514393939 #yiv3514393939activity span .yiv3514393939underline {text-decoration:underline;}#yiv3514393939 .yiv3514393939attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3514393939 .yiv3514393939attach div a {text-decoration:none;}#yiv3514393939 .yiv3514393939attach img {border:none;padding-right:5px;}#yiv3514393939 .yiv3514393939attach label {display:block;margin-bottom:5px;}#yiv3514393939 .yiv3514393939attach label a {text-decoration:none;}#yiv3514393939 blockquote {margin:0 0 0 4px;}#yiv3514393939 .yiv3514393939bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3514393939 .yiv3514393939bold a {text-decoration:none;}#yiv3514393939 dd.yiv3514393939last p a {font-family:Verdana;font-weight:700;}#yiv3514393939 dd.yiv3514393939last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3514393939 dd.yiv3514393939last p span.yiv3514393939yshortcuts {margin-right:0;}#yiv3514393939 div.yiv3514393939attach-table div div a {text-decoration:none;}#yiv3514393939 div.yiv3514393939attach-table {width:400px;}#yiv3514393939 div.yiv3514393939file-title a, #yiv3514393939 div.yiv3514393939file-title a:active, #yiv3514393939 div.yiv3514393939file-title a:hover, #yiv3514393939 div.yiv3514393939file-title a:visited {text-decoration:none;}#yiv3514393939 div.yiv3514393939photo-title a, #yiv3514393939 div.yiv3514393939photo-title a:active, #yiv3514393939 div.yiv3514393939photo-title a:hover, #yiv3514393939 div.yiv3514393939photo-title a:visited {text-decoration:none;}#yiv3514393939 div#yiv3514393939ygrp-mlmsg #yiv3514393939ygrp-msg p a span.yiv3514393939yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3514393939 .yiv3514393939green {color:#628c2a;}#yiv3514393939 .yiv3514393939MsoNormal {margin:0 0 0 0;}#yiv3514393939 o {font-size:0;}#yiv3514393939 #yiv3514393939photos div {float:left;width:72px;}#yiv3514393939 #yiv3514393939photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3514393939 #yiv3514393939photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3514393939 #yiv3514393939reco-category {font-size:77%;}#yiv3514393939 #yiv3514393939reco-desc {font-size:77%;}#yiv3514393939 .yiv3514393939replbq {margin:4px;}#yiv3514393939 #yiv3514393939ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3514393939 #yiv3514393939ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3514393939 #yiv3514393939ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3514393939 #yiv3514393939ygrp-mlmsg select, #yiv3514393939 input, #yiv3514393939 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3514393939 #yiv3514393939ygrp-mlmsg pre, #yiv3514393939 code {font:115% monospace;}#yiv3514393939 #yiv3514393939ygrp-mlmsg * {line-height:1.22em;}#yiv3514393939 #yiv3514393939ygrp-mlmsg #yiv3514393939logo {padding-bottom:10px;}#yiv3514393939 #yiv3514393939ygrp-msg p a {font-family:Verdana;}#yiv3514393939 #yiv3514393939ygrp-msg p#yiv3514393939attach-count span {color:#1E66AE;font-weight:700;}#yiv3514393939 #yiv3514393939ygrp-reco #yiv3514393939reco-head {color:#ff7900;font-weight:700;}#yiv3514393939 #yiv3514393939ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3514393939 #yiv3514393939ygrp-sponsor #yiv3514393939ov li a {font-size:130%;text-decoration:none;}#yiv3514393939 #yiv3514393939ygrp-sponsor #yiv3514393939ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3514393939 #yiv3514393939ygrp-sponsor #yiv3514393939ov ul {margin:0;padding:0 0 0 8px;}#yiv3514393939 #yiv3514393939ygrp-text {font-family:Georgia;}#yiv3514393939 #yiv3514393939ygrp-text p {margin:0 0 1em 0;}#yiv3514393939 #yiv3514393939ygrp-text tt {font-size:120%;}#yiv3514393939 #yiv3514393939ygrp-vital ul li:last-child {border-right:none !important;}#yiv3514393939

Mon Apr 13, 2015 10:52 am (PDT) . Posted by:

polomorabe

Hello Randy,

I'm also interested in being able to do this.


When I look at the Zachs screener tool, I can only see a list of predefined screening conditions.


On the left side pane:
Select a criteria: Popilar Criteria, Company descriptors, Size & Price changes, etc.


On the right side pane:
Select items: Zachs rank, Zachs indistry rank, growth score, value score, etc.


But I can't see a way to add a custom criteria such as "Next EPS Report Data" > 0.
Is this possible, or am I missing something?


Many thanks,
Paul

Mon Apr 13, 2015 12:17 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

On the left side pane, click on the 7th item down, "EPS surprises and
Actuals". Then the "Next EPS Report Date" is the second item from the
bottom on the right side pane. Change the "EQUAL" to ">" and enter 0 in the
input box next to it, then click the "Add" button. Then you should see a
message in the middle of the screener that says: "Matches: 5896".

Just click on "Run Screen". Since the "Next EPS Report Date" was a
criteria, it's automatically part of the output view. Now just click the
"Export" tab at the top and it'll export a file you can open into EXCEL.
You can also include other fields in the view if you'd like. For example, I
know some people like to use the "Sector" and "Industry" fields.

On Mon, Apr 13, 2015 at 10:52 AM, polomora@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm also interested in being able to do this.
>
> When I look at the Zachs screener tool, I can only see a list of
> predefined screening conditions.
>
> On the left side pane:
> Select a criteria: Popilar Criteria, Company descriptors, Size & Price
> changes, etc.
>
> On the right side pane:
> Select items: Zachs rank, Zachs indistry rank, growth score, value score,
> etc.
>
> But I can't see a way to add a custom criteria such as "Next EPS Report
> Data" > 0.
> Is this possible, or am I missing something?
>
>
>

Mon Apr 13, 2015 3:15 pm (PDT) . Posted by:

polomorabe

That's brilliant Randy, would never have found it on my own. Many thanks,
Paul


Mon Apr 13, 2015 11:47 am (PDT) . Posted by:

panda317

Randy;

I'm using this to fetch dividend yield from finviz.com;

=RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend %")

It does not fetch for certain symbols (GAB, GGT, MORL, CEFL, etc.) because finviz.com doesn't have the info.

Is there an alternate (google?) that would perhaps have the correct and current info?

How would I change the above formula to accomodate this?

Thanks in advance.

You really need a tip jar, or a buy me a drink button, or some way for us to 'financially&#39; show our appreciation.


Mon Apr 13, 2015 12:18 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can get the dividend amount and yield from Google Finance with
something like:

=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))

=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))

...but it will be slower, because you'll need to retrieve a web page for
each ticker symbol.

As far as donations, I always ask people to "Pay it Forward" and donate
some of their profits to a charitable group. That way, it can also get a
little tax break. :)

On Mon, Apr 13, 2015 at 11:47 AM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm using this to fetch dividend yield from finviz.com;
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend
> %")
>
> It does not fetch for certain symbols (GAB, GGT, MORL, CEFL, etc.) because
> finviz.com doesn't have the info.
>
> Is there an alternate (google?) that would perhaps have the correct and
> current info?
>
> How would I change the above formula to accomodate this?
>
> Thanks in advance.
>
> You really need a tip jar, or a buy me a drink button, or some way for us
> to 'financially&#39; show our appreciation.
>

Mon Apr 13, 2015 1:09 pm (PDT) . Posted by:

panda317

How can I change this;

=RCHGetTableCell("http://finviz.com/quote.ashx?t= http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend %")

to use this (I just want the yield %);

=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))

=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))

My tickers are in column 'D'

Would it be something like this;

=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&smfJoin($D10:$D$16,","),1,"Div/Yield"),"/","~"))

Thanks in advance

Pat

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

You can get the dividend amount and yield from Google Finance with something like:

=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))

=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))


...but it will be slower, because you'll need to retrieve a web page for each ticker symbol.


As far as donations, I always ask people to "Pay it Forward" and donate some of their profits to a charitable group. That way, it can also get a little tax break. :)


On Mon, Apr 13, 2015 at 11:47 AM, pat@... mailto:pat@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:

I'm using this to fetch dividend yield from finviz.com http://finviz.com;

=RCHGetTableCell("http://finviz.com/quote.ashx?t= http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend %")

It does not fetch for certain symbols (GAB, GGT, MORL, CEFL, etc.) because finviz.com http://finviz.com doesn't have the info.

Is there an alternate (google?) that would perhaps have the correct and current info?

How would I change the above formula to accomodate this?

Thanks in advance.

You really need a tip jar, or a buy me a drink button, or some way for us to 'financially&#39; show our appreciation.









Mon Apr 13, 2015 1:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You would do this for row 10:

=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$D10,"td",1,"Div/Yield"),"~","/"))

=smfConvertData(smfStrExtr(smfGetTagContent("
https://www.google.com/finance?q="&$D10,"td",1,"Div/Yield"),"/","~"))

...and copy the formulas down as needed. One formula per ticker.

On Mon, Apr 13, 2015 at 1:09 PM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> How can I change this;
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D10:$D$16,","),1,"?t="&$D10&"&",">Dividend
> %")
>
> to use this (I just want the yield %);
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"~","/"))
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&$C4,"td",1,"Div/Yield"),"/","~"))
>
> My tickers are in column 'D'
>
> Would it be something like this;
>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&smfJoin($D10:$D$16,",")
> ,1,"Div/Yield"),"/","~"))
>

Mon Apr 13, 2015 5:13 pm (PDT) . Posted by:

panda317

Thanks!

=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q="&$D12,"td",1,"Div/Yield"),"/","~"))/100

works like a charm for row 12!

I had to add the '/100' so it would format correctly.

Mon Apr 13, 2015 5:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just be aware that if you get a #VALUE! result, it may be because the
add-in function is returning "Error"...which can't be divided by 100.

On Mon, Apr 13, 2015 at 5:13 PM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> =smfConvertData(smfStrExtr(smfGetTagContent("
> https://www.google.com/finance?q="&$D12,"td",1,"Div/Yield"),"/","~"))/100
>
> works like a charm for row 12!
>
> I had to add the '/100' so it would format correctly.
>

Tue Apr 14, 2015 12:00 am (PDT) . Posted by:

panda317




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

Just be aware that if you get a #VALUE! result, it may be because the add-in function is returning "Error"...which can't be divided by 100.

That's ok. I'll just divide by zero in that case.

;-)

thanks again!

On Mon, Apr 13, 2015 at 5:13 PM, pat@... mailto:pat@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:

=smfConvertData(smfStrExtr(smfGetTagContent("https://www.google.com/finance?q= https://www.google.com/finance?q="&$D12,"td",1,"Div/Yield"),"/","~"))/100

works like a charm for row 12!

I had to add the '/100' so it would format correctly.








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

Tidak ada komentar:

Posting Komentar