Kamis, 27 Juli 2017

[smf_addin] Digest Number 4102

3 Messages

Digest #4102

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.


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.
>
>
>

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&quot; and I$3="注册资本"



For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar