2 Messages
Digest #3047
Messages
Sat Apr 19, 2014 2:41 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I hate to ask but I do the RCHGetHTMLTable so seldom I can't remember
how to code it properly.
I'm trying to retrieve the table that has the split history which is at the
top right side of the webpage.
The webpage is http://www.splithistory.com/?symbol=pcar
I have been trying for 2 hours to get this done.
The formula I came up with is =RCHGetHTMLTable("&A15&A2","&L1&",-1,"",1)
Where:
URL in cell A15 is http://www.splithistory.com/?symbol=
Symbol in A2 is PCAR
Find Begin is in cell L1 is Split History Table
On the webpage it displays as PCAR Split History Table. The symbol will
change depending on cell A2 content.
So I did not include it in the Find begin string.
I built a 2 column array with 20 rows to handle a varying number of splits.
My result is nothing appears in the array. In checking the defined array
cells the formula above is in all cells.
Apparently, my formula is incorrect.
Can you tell me what my error is?
Thanks,
Kermit
how to code it properly.
I'm trying to retrieve the table that has the split history which is at the
top right side of the webpage.
The webpage is http://www.splithistory.com/?symbol=pcar
I have been trying for 2 hours to get this done.
The formula I came up with is =RCHGetHTMLTable("&A15&A2","&L1&",-1,"",1)
Where:
URL in cell A15 is http://www.splithistory.com/?symbol=
Symbol in A2 is PCAR
Find Begin is in cell L1 is Split History Table
On the webpage it displays as PCAR Split History Table. The symbol will
change depending on cell A2 content.
So I did not include it in the Find begin string.
I built a 2 column array with 20 rows to handle a varying number of splits.
My result is nothing appears in the array. In checking the defined array
cells the formula above is in all cells.
Apparently, my formula is incorrect.
Can you tell me what my error is?
Thanks,
Kermit
Sat Apr 19, 2014 3:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Already asked and answered:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25802
Answer: Not possible because they don't code the table properly.
On Sat, Apr 19, 2014 at 2:41 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> Randy, I hate to ask but I do the RCHGetHTMLTable so seldom I can't
> remember how to code it properly.
>
> I'm trying to retrieve the table that has the split history which is at
> the top right side of the webpage.
>
>
>
> The webpage is http://www.splithistory.com/?symbol=pcar
>
>
>
> I have been trying for 2 hours to get this done.
>
>
>
> The formula I came up with is =RCHGetHTMLTable("&A15&A2","&L1&",-1,"",1)
>
> Where:
>
> URL in cell A15 is http://www.splithistory.com/?symbol=
>
> Symbol in A2 is PCAR
>
> Find Begin is in cell L1 is Split History Table
>
>
>
> On the webpage it displays as PCAR Split History Table. The symbol will
> change depending on cell A2 content.
>
> So I did not include it in the Find begin string.
>
>
>
> I built a 2 column array with 20 rows to handle a varying number of
> splits.
>
>
>
> My result is nothing appears in the array. In checking the defined array
> cells the formula above is in all cells.
>
> Apparently, my formula is incorrect.
>
> Can you tell me what my error is?
>
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25802
Answer: Not possible because they don't code the table properly.
On Sat, Apr 19, 2014 at 2:41 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> Randy, I hate to ask but I do the RCHGetHTMLTable so seldom I can't
> remember how to code it properly.
>
> I'm trying to retrieve the table that has the split history which is at
> the top right side of the webpage.
>
>
>
> The webpage is http://www.splithistory.com/?symbol=pcar
>
>
>
> I have been trying for 2 hours to get this done.
>
>
>
> The formula I came up with is =RCHGetHTMLTable("&A15&A2","&L1&",-1,"",1)
>
> Where:
>
> URL in cell A15 is http://www.splithistory.com/?symbol=
>
> Symbol in A2 is PCAR
>
> Find Begin is in cell L1 is Split History Table
>
>
>
> On the webpage it displays as PCAR Split History Table. The symbol will
> change depending on cell A2 content.
>
> So I did not include it in the Find begin string.
>
>
>
> I built a 2 column array with 20 rows to handle a varying number of
> splits.
>
>
>
> My result is nothing appears in the array. In checking the defined array
> cells the formula above is in all cells.
>
> Apparently, my formula is incorrect.
>
> Can you tell me what my error is?
>
>
>
>
Tidak ada komentar:
Posting Komentar