2 Messages
Digest #3099
Messages
Sat Jun 21, 2014 1:32 pm (PDT) . Posted by:
"Fred Wright" fredwwright
Randy,
Your transpose works great. Two questions - 1) I don't see the pDim1 and pDim2 parameters in the documentation for RCHGetHTMLTable?; and 2) I really just want a one line return of the Short Interest - I was able to get just the dates and the Short Interest by reducing your pDim2 from 4 to 2 :
=TRANSPOSE(RCHGetHTMLTable("http://www.nasdaq.com/symbol/mmm/short-interest",">Settlement",-1,"",1,,25,2))
But I couldn't figure out any way to just get the second column of the table - is this possible with this function? If not I will just do my spreadsheets in a two line format.
Thanks, Fred
Your transpose works great. Two questions - 1) I don't see the pDim1 and pDim2 parameters in the documentation for RCHGetHTMLTable?; and 2) I really just want a one line return of the Short Interest - I was able to get just the dates and the Short Interest by reducing your pDim2 from 4 to 2 :
=TRANSPOSE(RCHGetHTMLTable("http://www.nasdaq.com/symbol/mmm/short-interest","
But I couldn't figure out any way to just get the second column of the table - is this possible with this function? If not I will just do my spreadsheets in a two line format.
Thanks, Fred
Sat Jun 21, 2014 2:10 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I originally added the pDim1 and pDim2 parameters for my own use, so I
could use the functions within VBA. They aren't documented because I felt
they would generate more confusion than anything else. As it is, someone
has to know and ask about TRANSPOSE() before they're of use, which means a
more advanced EXCEL user.
Reducing pDim2 from 4 to 2 really didn't do anything for you. If you only
displayed two rows, the additional two rows are just cast off anyway.
To just get the one column of data as a row, you can used EXCEL's INDEX()
function on the returned results:
=TRANSPOSE(INDEX(RCHGetHTMLTable("
http://www.nasdaq.com/symbol/mmm/short-interest
",">Settlement",-1,"",1,,25,4),,2))
On Sat, Jun 21, 2014 at 1:32 PM, Fred Wright fredwwright@... wrote:
>
> Your transpose works great. Two questions - 1) I don't see the pDim1 and
> pDim2 parameters in the documentation for RCHGetHTMLTable?; and 2) I really
> just want a one line return of the Short Interest - I was able to get just
> the dates and the Short Interest by reducing your pDim2 from 4 to 2 :
>
> =TRANSPOSE(RCHGetHTMLTable("
> http://www.nasdaq.com/symbol/mmm/short-interest
> ",">Settlement",-1,"",1,,25,2))
>
> But I couldn't figure out any way to just get the second column of the
> table - is this possible with this function? If not I will just do my
> spreadsheets in a two line format.
>
>
could use the functions within VBA. They aren't documented because I felt
they would generate more confusion than anything else. As it is, someone
has to know and ask about TRANSPOSE() before they're of use, which means a
more advanced EXCEL user.
Reducing pDim2 from 4 to 2 really didn't do anything for you. If you only
displayed two rows, the additional two rows are just cast off anyway.
To just get the one column of data as a row, you can used EXCEL's INDEX()
function on the returned results:
=TRANSPOSE(INDEX(RCHGetHTMLTable("
http://www.nasdaq.com/symbol/mmm/short-interest
",">Settlement",-1,"",1,,25,4),,2))
On Sat, Jun 21, 2014 at 1:32 PM, Fred Wright fredwwright@... wrote:
>
> Your transpose works great. Two questions - 1) I don't see the pDim1 and
> pDim2 parameters in the documentation for RCHGetHTMLTable?; and 2) I really
> just want a one line return of the Short Interest - I was able to get just
> the dates and the Short Interest by reducing your pDim2 from 4 to 2 :
>
> =TRANSPOSE(RCHGetHTMLTable("
> http://www.nasdaq.com/symbol/mmm/short-interest
> ","
>
> But I couldn't figure out any way to just get the second column of the
> table - is this possible with this function? If not I will just do my
> spreadsheets in a two line format.
>
>
Tidak ada komentar:
Posting Komentar