Sabtu, 25 Oktober 2014

[smf_addin] Digest Number 3220

6 Messages

Digest #3220

Messages

Fri Oct 24, 2014 9:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

=RCHGetElementNumber("MMM",13867)

A list of all the defined elements is in the XLS workbook distributed
within the ZIP archive, along with the add-in.

On Fri, Oct 24, 2014 at 8:33 PM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> How do you get the defined element (i.e. #13867)?
>

Fri Oct 24, 2014 9:07 pm (PDT) . Posted by:

tzewei_79

Hi,


How can I extract the company name without the prefix for the data? Example from https://www.google.com/finance?q=CRRC&ei=OgBLVIjZGcmkkgWAiYCQAQ https://www.google.com/finance?q=CRRC&ei=OgBLVIjZGcmkkgWAiYCQAQ , I'm trying to get Courier Corporation. I have tried =RCHGetTableCell("https://www.google.com/finance?q="&A12&ei=OgBLVIjZGcmkkgWAiYCQAQ,"Finance") where cell A12 contains the symbol CRRC. But the result is #VALUE!...

Fri Oct 24, 2014 9:19 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The concatenation is incorrect. I don't know what the "ei" parameter does.
I usually just drop it and the URL works fine. The concatenation would have
to have been (i.e. a cell reference in between two literal strings):

"https://www.google.com/finance?q=" & A12 & "&ei=OgBLVIjZGcmkkgWAiYCQAQ"

In any case, this looks to me like the easiest way to pull the company name
from that web page:

=smfGetTagContent("https://www.google.com/finance?q=
"&D7,"h3",-1,"&addticker=")

On Fri, Oct 24, 2014 at 9:07 PM, tzewei_79@... wrote:

> How can I extract the company name without the prefix for the data?
> Example from
> https://www.google.com/finance?q=CRRC&ei=OgBLVIjZGcmkkgWAiYCQAQ , I'm
> trying to get Courier Corporation. I have tried =RCHGetTableCell("
> https://www.google.com/finance?q="&A12&ei=OgBLVIjZGcmkkgWAiYCQAQ,"Finance")
> where cell A12 contains the symbol CRRC. But the result is #VALUE!...
>

Fri Oct 24, 2014 9:08 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's working fine for me. Have you ever run into location errors? That's
what I would suspect. See the item on the "Tips and FAQs" web page.

If it is the problem, running the smfFixLinks macro should fix all of the
unresolved links that are due to location errors.

Not sure what you're asking about company name -- that worksheet is just
extracting data from this web page:

http://dividata.com/dividates

So, yes, you'll only see things on that list.

On Fri, Oct 24, 2014 at 8:45 PM, tzewei_79@... wrote:

>
> I downloaded RCHGetTableCell-Template-DiviData-Upcoming-Ex-Dividend.xls to
> get a feel of how the formula works but somehow the cells were all #NAME?.
> I tried to change the rating to search for but result still the same. I
> tried looking at the documentation on smfGetTagContent but the example is
> quite different.
>
> Actually I wanted to find an example of getting the company name. From the
> example, I think it only display the company names if dividata has them on
> the upcomign Ex-div list right?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar