Sabtu, 28 Februari 2015

[smf_addin] Digest Number 3340

5 Messages

Digest #3340

Messages

Fri Feb 27, 2015 2:42 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The defined element, which gets it from Yahoo:

=RCHGetElementNumber("AAPL",13863)

Note that "Apple Computer Company" is NOT the name of the company.

On Thu, Feb 26, 2015 at 9:43 PM, electronicjason@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> If I have the ticker AAPL how do I get the full name Apple Computer
> Company? What element will do that? A line item will suffice. Thank you.
>

Fri Feb 27, 2015 7:00 pm (PST) . Posted by:

tzewei_79

hmm...Randy, I tried replacing the link https://www.dividata.com/stock/ https://www.dividata.com/stock/ again but now it works but I had to transfer the entire sheet to a new excel file. Any idea what might cause this?

Fri Feb 27, 2015 7:16 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Ahhh. Maybe they have some type of redirection going on, from http to
https, that the XMLHTTP protocol can't handle.

But you shouldn't have needed to go to a new file. A simple "Find and
Replace All" should have fixed it.

On Fri, Feb 27, 2015 at 8:00 PM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> hmm...Randy, I tried replacing the link https://www.dividata.com/stock/ again
> but now it works but I had to transfer the entire sheet to a new excel
> file. Any idea what might cause this?
>

Fri Feb 27, 2015 7:22 pm (PST) . Posted by:

tzewei_79

Hi Randy, you are right!! I just notice the length changed. They changed from http to https! Thanks man!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar