Sabtu, 21 Maret 2015

[smf_addin] Digest Number 3363

8 Messages

Digest #3363
1b
Re: I get "error" from my smf addin by "Randy Harmelink" rharmelink
1c
1d
Re: I get "error" from my smf addin by "Randy Harmelink" rharmelink
1e
2a
WACC by thealphainvestor
2b
Re: WACC by "Randy Harmelink" rharmelink

Messages

Fri Mar 20, 2015 12:55 pm (PDT) . Posted by:

jtassielli2003


When I set it up, linked to advfn, yahoo, zacks, etc.. When I reopen all the cells have "error".

An example below in a cell. Retrieve, dividend data.

=RCHGetTableCell("http://www.advfn.com/stock-market/"&+U$1&"/"&+U$2&"/financials?btn=start_date&start_date="&+U121&"&mode=annual_reports",1,"Dividends Paid Per Share (DPS)")

This is my output.

Error Error Error Error Error Error Error Error Error Error Error Error
It worked perfectly when I created it, now I get this. Also, spreadsheet is about 40 columns by 60 rows.

Thanks

Fri Mar 20, 2015 1:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you, since your formula below worked fine here.
EXCEL's not warning you of unresolved links, is it?

This returned 2.1 for me:

=RCHGetTableCell("http://www.advfn.com/stock-market/"&B5&"/"&C5&"/financials?btn=start_date&start_date="&D5&"&mode=annual_reports",1,"Dividends
Paid Per Share (DPS)")

...where:

B5: NYSE
C5: MMM
D5: 0

You could just use the smfGetAdvFNElement() function. For example, the
above would be equivalent to:

=smfGetAdvFNElement("MMM","A",5,">Dividends Paid Per Share")

...or even:

=RCHGetElementNumber("MMM",5900)

On Fri, Mar 20, 2015 at 12:44 PM, jtassielli2003@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> When I set it up, linked to advfn, yahoo, zacks, etc.. When I reopen
> all the cells have "error".
>
> An example below in a cell. Retrieve, dividend data.
>
> =RCHGetTableCell("http://www.advfn.com/stock-market/"&+U$1&"/"&+U$2&"/financials?btn=start_date&start_date="&+U121&"&mode=annual_reports",1,"Dividends
> Paid Per Share (DPS)")
>
> This is my output.
>
> Error Error Error Error Error Error Error Error Error Error Error Error
>
> It worked perfectly when I created it, now I get this. Also, spreadsheet
> is about 40 columns by 60 rows.
>
>

Fri Mar 20, 2015 1:44 pm (PDT) . Posted by:

"Joe" jtassielli2003


From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, March 20, 2015 4:07 PM
Subject: Re: [smf_addin] I get "error" from my smf addin
No. no unresolved links. I used those other functions you mentioned in the spreadsheet and received "error" in the ADVFN cells.  Then triedusing the Rchgettablecell function.  It worked.  Then when reopened, received all these "errors." I can't use outlook.  But i will send you screen prints form excel, when I use the "edit links" button, when I'm home.  If you have the time, let me know if this where the problem is? Thanks Joe
  Not sure what to tell you, since your formula below worked fine here. EXCEL's not warning you of unresolved links, is it?

This returned 2.1 for me:

=RCHGetTableCell("http://www.advfn.com/stock-market/"&B5&"/"&C5&"/financials?btn=start_date&start_date="&D5&"&mode=annual_reports",1,"Dividends Paid Per Share (DPS)")

...where:

B5: NYSE
C5: MMM
D5: 0

You could just use the smfGetAdvFNElement() function. For example, the above would be equivalent to:

=smfGetAdvFNElement("MMM","A",5,">Dividends Paid Per Share")

...or even:

=RCHGetElementNumber("MMM",5900)

On Fri, Mar 20, 2015 at 12:44 PM, jtassielli2003@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

When I set it up, linked to advfn, yahoo, zacks, etc..  When I reopen all the cells have "error".An example below in a cell.  Retrieve, dividend data.=RCHGetTableCell("http://www.advfn.com/stock-market/"&+U$1&"/"&+U$2&"/financials?btn=start_date&start_date="&+U121&"&mode=annual_reports",1,"Dividends Paid Per Share (DPS)")This is my output.
| Error | Error | Error |
| Error | Error | | Error | |
| |
| Error | | Error | | Error | |
| |
| Error | | Error | | Error | |
| |

It worked perfectly when I created it, now I get this.  Also, spreadsheet is about 40 columns by 60 rows.

#yiv4889160317 #yiv4889160317 -- #yiv4889160317ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4889160317 #yiv4889160317ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4889160317 #yiv4889160317ygrp-mkp #yiv4889160317hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4889160317 #yiv4889160317ygrp-mkp #yiv4889160317ads {margin-bottom:10px;}#yiv4889160317 #yiv4889160317ygrp-mkp .yiv4889160317ad {padding:0 0;}#yiv4889160317 #yiv4889160317ygrp-mkp .yiv4889160317ad p {margin:0;}#yiv4889160317 #yiv4889160317ygrp-mkp .yiv4889160317ad a {color:#0000ff;text-decoration:none;}#yiv4889160317 #yiv4889160317ygrp-sponsor #yiv4889160317ygrp-lc {font-family:Arial;}#yiv4889160317 #yiv4889160317ygrp-sponsor #yiv4889160317ygrp-lc #yiv4889160317hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4889160317 #yiv4889160317ygrp-sponsor #yiv4889160317ygrp-lc .yiv4889160317ad {margin-bottom:10px;padding:0 0;}#yiv4889160317 #yiv4889160317actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4889160317 #yiv4889160317activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4889160317 #yiv4889160317activity span {font-weight:700;}#yiv4889160317 #yiv4889160317activity span:first-child {text-transform:uppercase;}#yiv4889160317 #yiv4889160317activity span a {color:#5085b6;text-decoration:none;}#yiv4889160317 #yiv4889160317activity span span {color:#ff7900;}#yiv4889160317 #yiv4889160317activity span .yiv4889160317underline {text-decoration:underline;}#yiv4889160317 .yiv4889160317attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4889160317 .yiv4889160317attach div a {text-decoration:none;}#yiv4889160317 .yiv4889160317attach img {border:none;padding-right:5px;}#yiv4889160317 .yiv4889160317attach label {display:block;margin-bottom:5px;}#yiv4889160317 .yiv4889160317attach label a {text-decoration:none;}#yiv4889160317 blockquote {margin:0 0 0 4px;}#yiv4889160317 .yiv4889160317bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4889160317 .yiv4889160317bold a {text-decoration:none;}#yiv4889160317 dd.yiv4889160317last p a {font-family:Verdana;font-weight:700;}#yiv4889160317 dd.yiv4889160317last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4889160317 dd.yiv4889160317last p span.yiv4889160317yshortcuts {margin-right:0;}#yiv4889160317 div.yiv4889160317attach-table div div a {text-decoration:none;}#yiv4889160317 div.yiv4889160317attach-table {width:400px;}#yiv4889160317 div.yiv4889160317file-title a, #yiv4889160317 div.yiv4889160317file-title a:active, #yiv4889160317 div.yiv4889160317file-title a:hover, #yiv4889160317 div.yiv4889160317file-title a:visited {text-decoration:none;}#yiv4889160317 div.yiv4889160317photo-title a, #yiv4889160317 div.yiv4889160317photo-title a:active, #yiv4889160317 div.yiv4889160317photo-title a:hover, #yiv4889160317 div.yiv4889160317photo-title a:visited {text-decoration:none;}#yiv4889160317 div#yiv4889160317ygrp-mlmsg #yiv4889160317ygrp-msg p a span.yiv4889160317yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4889160317 .yiv4889160317green {color:#628c2a;}#yiv4889160317 .yiv4889160317MsoNormal {margin:0 0 0 0;}#yiv4889160317 o {font-size:0;}#yiv4889160317 #yiv4889160317photos div {float:left;width:72px;}#yiv4889160317 #yiv4889160317photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4889160317 #yiv4889160317photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4889160317 #yiv4889160317reco-category {font-size:77%;}#yiv4889160317 #yiv4889160317reco-desc {font-size:77%;}#yiv4889160317 .yiv4889160317replbq {margin:4px;}#yiv4889160317 #yiv4889160317ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4889160317 #yiv4889160317ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4889160317 #yiv4889160317ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4889160317 #yiv4889160317ygrp-mlmsg select, #yiv4889160317 input, #yiv4889160317 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4889160317 #yiv4889160317ygrp-mlmsg pre, #yiv4889160317 code {font:115% monospace;}#yiv4889160317 #yiv4889160317ygrp-mlmsg * {line-height:1.22em;}#yiv4889160317 #yiv4889160317ygrp-mlmsg #yiv4889160317logo {padding-bottom:10px;}#yiv4889160317 #yiv4889160317ygrp-msg p a {font-family:Verdana;}#yiv4889160317 #yiv4889160317ygrp-msg p#yiv4889160317attach-count span {color:#1E66AE;font-weight:700;}#yiv4889160317 #yiv4889160317ygrp-reco #yiv4889160317reco-head {color:#ff7900;font-weight:700;}#yiv4889160317 #yiv4889160317ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4889160317 #yiv4889160317ygrp-sponsor #yiv4889160317ov li a {font-size:130%;text-decoration:none;}#yiv4889160317 #yiv4889160317ygrp-sponsor #yiv4889160317ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4889160317 #yiv4889160317ygrp-sponsor #yiv4889160317ov ul {margin:0;padding:0 0 0 8px;}#yiv4889160317 #yiv4889160317ygrp-text {font-family:Georgia;}#yiv4889160317 #yiv4889160317ygrp-text p {margin:0 0 1em 0;}#yiv4889160317 #yiv4889160317ygrp-text tt {font-size:120%;}#yiv4889160317 #yiv4889160317ygrp-vital ul li:last-child {border-right:none !important;}#yiv4889160317

Fri Mar 20, 2015 2:08 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Oops. smfGetAdvFNElement() and RCHGetElementNumber() won't work for AdvFN
unless you're using the beta version of the add-in from the "Works in
Progress" web page, as I had to make programming changes for AdvFN web page
changes.

But it's going to be difficult for me to diagnose a problem if I can't
repeat it here. That's why I'm asking about unresolved links. That's the
most likely reason for it to malfunction when reopening the file.

Can you localize it to a single formula, save it in a workbook, and open
it, to repeat the error. If so, does the formula look any differently after
you open the file?

On Fri, Mar 20, 2015 at 1:44 PM, Joe jtassielli2003@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> ------------------------------
> *From:* "Randy Harmelink rharmelink@gmail.com [smf_addin]" <
> smf_addin@yahoogroups.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Friday, March 20, 2015 4:07 PM
> *Subject:* Re: [smf_addin] I get "error" from my smf addin
> No. no unresolved links.
>
> I used those other functions you mentioned in the spreadsheet and received
> "error" in the ADVFN cells. Then tried
> using the Rchgettablecell function. It worked. Then when reopened,
> received all these "errors."
>
> I can't use outlook. But i will send you screen prints form excel, when I
> use the "edit links" button, when I'm home.
>
> If you have the time, let me know if this where the problem is?
>
>
>

Fri Mar 20, 2015 9:48 pm (PDT) . Posted by:

"Joe" jtassielli2003

Randy, I attached a spreadsheet.  The tab "hard copy" is valuescopied when I open spreadsheet.  The other, is with formulas.   There are no unresolved links.  I run the "fix links macro"if this should occur.  I downloaded the beta version, deleted the 01.30.15version.   Also, I get this (print screen below) message when I open myworkbooks.  Not sure why?  "Canyou localize it to a single formula, save it in a workbook, and open it, torepeat the error. If so, does the formula look any differently after you openthe file?" NO.  running the "fix links" macro, should take care ofthis. Thanks     
    
  From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, March 20, 2015 5:02 PM
Subject: Re: [smf_addin] I get "error" from my smf addin

  Oops. smfGetAdvFNElement() and RCHGetElementNumber() won't work for AdvFN unless you're using the beta version of the add-in from the "Works in Progress" web page, as I had to make programming changes for AdvFN web page changes.

But it's going to be difficult for me to diagnose a problem if I can't repeat it here. That's why I'm asking about unresolved links. That's the most likely reason for it to malfunction when reopening the file.

Can you localize it to a single formula, save it in a workbook, and open it, to repeat the error. If so, does the formula look any differently after you open the file?

On Fri, Mar 20, 2015 at 1:44 PM, Joe jtassielli2003@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, March 20, 2015 4:07 PM
Subject: Re: [smf_addin] I get "error" from my smf addin
No. no unresolved links. I used those other functions you mentioned in the spreadsheet and received "error" in the ADVFN cells.  Then triedusing the Rchgettablecell function.  It worked.  Then when reopened, received all these "errors." I can't use outlook.  But i will send you screen prints form excel, when I use the "edit links" button, when I'm home.  If you have the time, let me know if this where the problem is? 

#yiv8419210022 #yiv8419210022 -- #yiv8419210022ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8419210022 #yiv8419210022ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8419210022 #yiv8419210022ygrp-mkp #yiv8419210022hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8419210022 #yiv8419210022ygrp-mkp #yiv8419210022ads {margin-bottom:10px;}#yiv8419210022 #yiv8419210022ygrp-mkp .yiv8419210022ad {padding:0 0;}#yiv8419210022 #yiv8419210022ygrp-mkp .yiv8419210022ad p {margin:0;}#yiv8419210022 #yiv8419210022ygrp-mkp .yiv8419210022ad a {color:#0000ff;text-decoration:none;}#yiv8419210022 #yiv8419210022ygrp-sponsor #yiv8419210022ygrp-lc {font-family:Arial;}#yiv8419210022 #yiv8419210022ygrp-sponsor #yiv8419210022ygrp-lc #yiv8419210022hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8419210022 #yiv8419210022ygrp-sponsor #yiv8419210022ygrp-lc .yiv8419210022ad {margin-bottom:10px;padding:0 0;}#yiv8419210022 #yiv8419210022actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8419210022 #yiv8419210022activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8419210022 #yiv8419210022activity span {font-weight:700;}#yiv8419210022 #yiv8419210022activity span:first-child {text-transform:uppercase;}#yiv8419210022 #yiv8419210022activity span a {color:#5085b6;text-decoration:none;}#yiv8419210022 #yiv8419210022activity span span {color:#ff7900;}#yiv8419210022 #yiv8419210022activity span .yiv8419210022underline {text-decoration:underline;}#yiv8419210022 .yiv8419210022attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8419210022 .yiv8419210022attach div a {text-decoration:none;}#yiv8419210022 .yiv8419210022attach img {border:none;padding-right:5px;}#yiv8419210022 .yiv8419210022attach label {display:block;margin-bottom:5px;}#yiv8419210022 .yiv8419210022attach label a {text-decoration:none;}#yiv8419210022 blockquote {margin:0 0 0 4px;}#yiv8419210022 .yiv8419210022bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8419210022 .yiv8419210022bold a {text-decoration:none;}#yiv8419210022 dd.yiv8419210022last p a {font-family:Verdana;font-weight:700;}#yiv8419210022 dd.yiv8419210022last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8419210022 dd.yiv8419210022last p span.yiv8419210022yshortcuts {margin-right:0;}#yiv8419210022 div.yiv8419210022attach-table div div a {text-decoration:none;}#yiv8419210022 div.yiv8419210022attach-table {width:400px;}#yiv8419210022 div.yiv8419210022file-title a, #yiv8419210022 div.yiv8419210022file-title a:active, #yiv8419210022 div.yiv8419210022file-title a:hover, #yiv8419210022 div.yiv8419210022file-title a:visited {text-decoration:none;}#yiv8419210022 div.yiv8419210022photo-title a, #yiv8419210022 div.yiv8419210022photo-title a:active, #yiv8419210022 div.yiv8419210022photo-title a:hover, #yiv8419210022 div.yiv8419210022photo-title a:visited {text-decoration:none;}#yiv8419210022 div#yiv8419210022ygrp-mlmsg #yiv8419210022ygrp-msg p a span.yiv8419210022yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8419210022 .yiv8419210022green {color:#628c2a;}#yiv8419210022 .yiv8419210022MsoNormal {margin:0 0 0 0;}#yiv8419210022 o {font-size:0;}#yiv8419210022 #yiv8419210022photos div {float:left;width:72px;}#yiv8419210022 #yiv8419210022photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8419210022 #yiv8419210022photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8419210022 #yiv8419210022reco-category {font-size:77%;}#yiv8419210022 #yiv8419210022reco-desc {font-size:77%;}#yiv8419210022 .yiv8419210022replbq {margin:4px;}#yiv8419210022 #yiv8419210022ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8419210022 #yiv8419210022ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8419210022 #yiv8419210022ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8419210022 #yiv8419210022ygrp-mlmsg select, #yiv8419210022 input, #yiv8419210022 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8419210022 #yiv8419210022ygrp-mlmsg pre, #yiv8419210022 code {font:115% monospace;}#yiv8419210022 #yiv8419210022ygrp-mlmsg * {line-height:1.22em;}#yiv8419210022 #yiv8419210022ygrp-mlmsg #yiv8419210022logo {padding-bottom:10px;}#yiv8419210022 #yiv8419210022ygrp-msg p a {font-family:Verdana;}#yiv8419210022 #yiv8419210022ygrp-msg p#yiv8419210022attach-count span {color:#1E66AE;font-weight:700;}#yiv8419210022 #yiv8419210022ygrp-reco #yiv8419210022reco-head {color:#ff7900;font-weight:700;}#yiv8419210022 #yiv8419210022ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8419210022 #yiv8419210022ygrp-sponsor #yiv8419210022ov li a {font-size:130%;text-decoration:none;}#yiv8419210022 #yiv8419210022ygrp-sponsor #yiv8419210022ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8419210022 #yiv8419210022ygrp-sponsor #yiv8419210022ov ul {margin:0;padding:0 0 0 8px;}#yiv8419210022 #yiv8419210022ygrp-text {font-family:Georgia;}#yiv8419210022 #yiv8419210022ygrp-text p {margin:0 0 1em 0;}#yiv8419210022 #yiv8419210022ygrp-text tt {font-size:120%;}#yiv8419210022 #yiv8419210022ygrp-vital ul li:last-child {border-right:none !important;}#yiv8419210022

Sat Mar 21, 2015 2:50 am (PDT) . Posted by:

"Salar" salarkhor

I used to get the same error message when opening excel. I solved it as follows:
-Open a new workbook
-uncheck the addin in (under options/add-in)
-close workbook

Then open a workbook again, check the plugin, close it again. In my case it worked again when opening a new workbook. If it doesnt, try repeating the steps, but then instead of rechecking the add-in you can try to browse and reselect the xla file.

Good luck,
Sal

> Op 21 mrt. 2015 om 05:48 heeft "Joe jtassielli2003@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com> het volgende geschreven:
>
> Randy,
>
> I attached a spreadsheet. The tab "hard copy" is values copied when I open spreadsheet. The other, is with formulas.
>
> There are no unresolved links. I run the "fix links macro" if this should occur. I downloaded the beta version, deleted the 01.30.15 version.
>
> Also, I get this (print screen below) message when I open my workbooks. Not sure why?
>
>
> "Can you localize it to a single formula, save it in a workbook, and open it, to repeat the error. If so, does the formula look any differently after you open the file?"
>
> NO. running the "fix links" macro, should take care of this.
>
> Thanks
>
>
>
>
>
> <datauri-file.png>
>
>
>
>
>
>
> From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
> To: smf_addin@yahoogroups.com
> Sent: Friday, March 20, 2015 5:02 PM
> Subject: Re: [smf_addin] I get "error" from my smf addin
>
>
> Oops. smfGetAdvFNElement() and RCHGetElementNumber() won't work for AdvFN unless you're using the beta version of the add-in from the "Works in Progress" web page, as I had to make programming changes for AdvFN web page changes.
>
> But it's going to be difficult for me to diagnose a problem if I can't repeat it here. That's why I'm asking about unresolved links. That's the most likely reason for it to malfunction when reopening the file.
>
> Can you localize it to a single formula, save it in a workbook, and open it, to repeat the error. If so, does the formula look any differently after you open the file?
>
> On Fri, Mar 20, 2015 at 1:44 PM, Joe jtassielli2003@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
> From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
> To: smf_addin@yahoogroups.com
> Sent: Friday, March 20, 2015 4:07 PM
> Subject: Re: [smf_addin] I get "error" from my smf addin
> No. no unresolved links.
>
> I used those other functions you mentioned in the spreadsheet and received "error" in the ADVFN cells. Then tried
> using the Rchgettablecell function. It worked. Then when reopened, received all these "errors."
>
> I can't use outlook. But i will send you screen prints form excel, when I use the "edit links" button, when I'm home.
>
> If you have the time, let me know if this where the problem is?
>
>
>
>
>
>
> <datauri-file.png>
> <FINANCIAL DATA Consumers Discretionary to Randy.xlsx>

Fri Mar 20, 2015 3:48 pm (PDT) . Posted by:

thealphainvestor

Randy,

Trying to grab Weighted Average Cost of Capital from GuruFocus. It is in a weird spot built into a bar. I have tried this code (based on code you posted for Piotroski F-Score) with no success:

=smfConvertData(smfstrExtr(RCHGetTableCell("http://www.gurufocus.com/stock/AAPL",0,"inner_bar_right"),":","~"))

Any thoughts?

Bruce


Fri Mar 20, 2015 4:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28167

On Fri, Mar 20, 2015 at 3:48 PM, the.alpha.investor@... wrote:

>
> Trying to grab Weighted Average Cost of Capital from GuruFocus. It is in a
> weird spot built into a bar. I have tried this code (based on code you
> posted for Piotroski F-Score) with no success:
>
> =smfConvertData(smfstrExtr(RCHGetTableCell("
> http://www.gurufocus.com/stock/AAPL",0,"inner_bar_right"),":","~"))
>
> Any thoughts?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar