8 Messages
Digest #3363
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&"
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.
>
>
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&"
> 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&"
| 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-
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?
>
>
>
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
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.
#yiv8419210022 #yiv8419210022 -- #yiv8419210022ygrp-
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>
-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-
> <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
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,"
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?
>
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,"
>
> Any thoughts?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar