Sabtu, 20 Juni 2015

[smf_addin] Digest Number 3437

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.
>
>

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?

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&quot;)

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
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar