3 Messages
Digest #4102
1b
Re: help me:Why not and How can I get the info by rchGetTableCell fr by "Randy Harmelink" rharmelink
Messages
Thu Jul 27, 2017 6:38 pm (PDT) . Posted by:
fortune.rao
I think it's a bug in the modExtractData of the SMF add-in:
If pEnd <> "" Then
iRowEnd = InStr(iPos2, sData(3), "</TR")
and it should be
If pEnd <> "" Then
iRowEnd = InStr(iPos2, sData(3), pEnd)
But I can't find the reason why I can't get the info by rchGetTableCell function from www.cninfo.com.cn/information/cashflow/shmb600000.html http://www.cninfo.com.cn/information/cashflow/shmb600000.html
or even from www.cninfo.com.cn/information/lastest/shmb600000.html http://www.cninfo.com.cn/information/lastest/shmb600000.html
Some of the possible reasons is
1. the confusion or mixation with ascii code of the chinese characters;
2. the webpage containing the form with the post method using some parameters.
and then how can I get the info from www.cninfo.com.cn/information http://www.cninfo.com.cn/information/cashflow/shmb600000.html
,i.e. the most official information website of the china stock market.
If pEnd <> "" Then
iRowEnd = InStr(iPos2, sData(3), "</TR")
and it should be
If pEnd <> "" Then
iRowEnd = InStr(iPos2, sData(3), pEnd)
But I can't find the reason why I can't get the info by rchGetTableCell function from www.cninfo.com.cn/information/cashflow/shmb600000.html http://www.cninfo.com.cn/information/cashflow/shmb600000.html
or even from www.cninfo.com.cn/information/lastest/shmb600000.html http://www.cninfo.com.cn/information/lastest/shmb600000.html
Some of the possible reasons is
1. the confusion or mixation with ascii code of the chinese characters;
2. the webpage containing the form with the post method using some parameters.
and then how can I get the info from www.cninfo.com.cn/information http://www.cninfo.com.cn/information/cashflow/shmb600000.html
,i.e. the most official information website of the china stock market.
Thu Jul 27, 2017 6:41 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sample formula of what you're trying to extract, please...so I have
something specific in front of me when I look at it.
On Thu, Jul 27, 2017 at 6:33 PM, fortune.rao@
...
wrote:
>
> I think it's a bug in the modExtractData of the SMF add-in:
>
> If pEnd <> "" Then
>
> iRowEnd = InStr(iPos2, sData(3), "</TR")
>
> and it should be
>
> If pEnd <> "" Then
>
> iRowEnd = InStr(iPos2, sData(3), pEnd)
>
> But I can't find the reason why I can't get the info by rchGetTableCell
> function from www.cninfo.com.cn/information/cashflow/shmb600000.html
>
> or even from www.cninfo.com.cn/information/lastest/shmb600000.html
>
> Some of the possible reasons is
>
> 1. the confusion or mixation with ascii code of the chinese characters;
>
> 2. the webpage containing the form with the post method using some
> parameters.
>
> and then how can I get the info from www.cninfo.com.cn/information
> <http://www.cninfo.com.cn/information/cashflow/shmb600000.html>
>
> ,i.e. the most official information website of the china stock market.
>
>
>
something specific in front of me when I look at it.
On Thu, Jul 27, 2017 at 6:33 PM, fortune.rao@
...
wrote:
>
> I think it's a bug in the modExtractData of the SMF add-in:
>
> If pEnd <> "" Then
>
> iRowEnd = InStr(iPos2, sData(3), "</TR")
>
> and it should be
>
> If pEnd <> "" Then
>
> iRowEnd = InStr(iPos2, sData(3), pEnd)
>
> But I can't find the reason why I can't get the info by rchGetTableCell
> function from www.cninfo.com.cn/information/cashflow/shmb600000.html
>
> or even from www.cninfo.com.cn/information/lastest/shmb600000.html
>
> Some of the possible reasons is
>
> 1. the confusion or mixation with ascii code of the chinese characters;
>
> 2. the webpage containing the form with the post method using some
> parameters.
>
> and then how can I get the info from www.cninfo.com.cn/information
> <http://www.cninfo.com.cn/information/cashflow/shmb600000.html>
>
> ,i.e. the most official information website of the china stock market.
>
>
>
Thu Jul 27, 2017 6:54 pm (PDT) . Posted by:
fortune.rao
=rchGetTableCell("http://www.cninfo.com.cn/information/brief/shmb"&$A5&".html",1,I$3)
where $A5="600000" and I$3="注册资本"
where $A5="600000&qu
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar