3 Messages
Digest #4259
Messages
Fri Dec 8, 2017 4:58 am (PST) . Posted by:
eclipsme
But not here:
I have tried entering exactly what you present in a brand new spread sheet and get the same:
Ticker Price
IBM 153.57
MMM 153.57
Just to verify, here is the array entered formula:
=RCHGetTableCell("https://finviz.com/quote.ashx?t="&smfJoin($A$2:$A$33,","),1,"?t="&$A2&"&",">"&B$1)
Is there any difference in the equation you used? I assume you just copied and pasted from what I gave you?
The version command runs fine, Version 2.1.2017.11.30
Not remembering exactly how I constructed this, and trying to understand all of the parts of the equation, would you please explain what this part does?
?t="&$A2&";&",">"&B$1)
Any other ideas?
Thank you.
I have tried entering exactly what you present in a brand new spread sheet and get the same:
Ticker Price
IBM 153.57
MMM 153.57
Just to verify, here is the array entered formula:
=RCHGetTableCell("https://finviz.com/quote.ashx?t="&smfJoin(
Is there any difference in the equation you used? I assume you just copied and pasted from what I gave you?
The version command runs fine, Version 2.1.2017.11.
Not remembering exactly how I constructed this, and trying to understand all of the parts of the equation, would you please explain what this part does?
?t="&$A2&"
Any other ideas?
Thank you.
Fri Dec 8, 2017 5:40 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Aha! It's not supposed to be an array-entered formula. It's entered in cell
B2 and then copied down through B33 (since that is the last row you're
using for ticker symbols).
As for the two strings:
"?t="&$A2
">"&B$1
The first is looking for the link related to the specific ticker. This
positions the function before continuing the search for that second string.
When you array-enter the formula, every row will use that same ticker
symbol.
The second is looking for the tag you have in the header line. The label
for the data item you are extracting.
On Fri, Dec 8, 2017 at 5:58 AM, harvey@
...
wrote:
>
> But not here:
>
> I have tried entering exactly what you present in a brand new spread sheet
> and get the same:
>
> Ticker Price
> IBM 153.57
> MMM 153.57
>
> Just to verify, here is the array entered formula:
> =RCHGetTableCell("https://finviz.com/quote.ashx?t="&
> smfJoin($A$2:$A$33,","),1,
>
> "?t="&$A2&"&",
>
> ">"&B$1)
>
> Is there any difference in the equation you used? I assume you just copied
> and pasted from what I gave you?
>
> The version command runs fine, Version 2.1.2017.11.30
>
> Not remembering exactly how I constructed this, and trying to understand
> all of the parts of the equation, would you please explain what this part
> does?
> ?t="&$A2&";&",">"&B$1)
>
> Any other ideas?
>
>
B2 and then copied down through B33 (since that is the last row you're
using for ticker symbols).
As for the two strings:
"?t="&$A2
">"&B$1
The first is looking for the link related to the specific ticker. This
positions the function before continuing the search for that second string.
When you array-enter the formula, every row will use that same ticker
symbol.
The second is looking for the tag you have in the header line. The label
for the data item you are extracting.
On Fri, Dec 8, 2017 at 5:58 AM, harvey@
...
wrote:
>
> But not here:
>
> I have tried entering exactly what you present in a brand new spread sheet
> and get the same:
>
> Ticker Price
> IBM 153.57
> MMM 153.57
>
> Just to verify, here is the array entered formula:
> =RCHGetTableCell("https://finviz.com/quote.ashx?t="&
> smfJoin($A$2:
>
> "?t="
>
> ">"
>
> Is there any difference in the equation you used? I assume you just copied
> and pasted from what I gave you?
>
> The version command runs fine, Version 2.1.2017.11.
>
> Not remembering exactly how I constructed this, and trying to understand
> all of the parts of the equation, would you please explain what this part
> does?
> ?t="&$A2&"
>
> Any other ideas?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar