6 Messages
Digest #3220
4a
Re: RCHGetTableCell-Template-DiviData-Upcoming-Ex-Dividend.xls shows by "Randy Harmelink" rharmelink
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)?
>
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!...
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=
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!...
>
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=
> 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?
>
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@..
>
> I downloaded RCHGetTableCell-
> 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:
Posting Komentar