7 Messages
Digest #3437
Messages
Fri Jun 19, 2015 6:03 am (PDT) . Posted by:
tzewei_79
From the post 28511, I saw the formula =RCHGetTableCell("http://dividata.com/stock/ http://dividata.com/stock/"&F6,1,"Dividend Yield:",,,,,,,,2) but when I try this with adding "s" after http and putting F6 as "MCD", it still gives error.
Fri Jun 19, 2015 6:09 am (PDT) . Posted by:
tzewei_79
If I want to grab industry, do I need to change the number of commas and the number after that? Don't really understand the syntax here.
Fri Jun 19, 2015 8:03 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like they've changed their web pages, again...this appears to work:
=smfConvertData(smfGetTagContent("https://dividata.com/stock/"&F6,"span",1,">Dividend
Yield"))
On Fri, Jun 19, 2015 at 6:03 AM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> From the post 28511, I saw the formula =RCHGetTableCell("
> http://dividata.com/stock/"&F6,1,"Dividend Yield:",,,,,,,,2) but when I
> try this with adding "s" after http and putting F6 as "MCD", it still gives
> error.
>
>
=smfConvertData(smfGetTagContent("https://dividata.com/stock/"&F6,"span",1,">Dividend
Yield"))
On Fri, Jun 19, 2015 at 6:03 AM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> From the post 28511, I saw the formula =RCHGetTableCell("
> http://dividata.com/stock/"&F6,1,
> try this with adding "s" after http and putting F6 as "MCD"
> error.
>
>
Fri Jun 19, 2015 7:32 am (PDT) . Posted by:
jharlan
Hi,
After updating with latest beta, I tried but it returned "Error" in the cell.
Thoughts?
After updating with latest beta, I tried but it returned "Error" in the cell.
Thoughts?
Fri Jun 19, 2015 8:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Confused...I can't think of any reason the new version of the add-in would
have a problem with the retrieval function.
Did you need to have a security cookie or something? Did you update the
add-in with EXCEL closed down? Did you verify the version of the add-in
changed?
=RCHGetElementNumber("Version")
On Fri, Jun 19, 2015 at 7:32 AM, jharlan@... wrote:
>
> After updating with latest beta, I tried but it returned "Error" in the
> cell.
>
> Thoughts?
>
have a problem with the retrieval function.
Did you need to have a security cookie or something? Did you update the
add-in with EXCEL closed down? Did you verify the version of the add-in
changed?
=RCHGetElementNumbe
On Fri, Jun 19, 2015 at 7:32 AM, jharlan@... wrote:
>
> After updating with latest beta, I tried but it returned "Error" in the
> cell.
>
> Thoughts?
>
Fri Jun 19, 2015 12:00 pm (PDT) . Posted by:
jharlan
Stock Market Functions add-in, Version 2.1.2015.06.08 (C:\SMF; ; ; 1)
Fri Jun 19, 2015 12:04 pm (PDT) . Posted by:
jharlan
had to make sure the "http://" preceded the www.
works like a charm... now for the word count!
Thank you sir.
-Jim
works like a charm... now for the word count!
Thank you sir.
-Jim
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar