7 Messages
Digest #4103
1a
Re: help me:Why not and How can I get the info by rchGetTableCell fr by "Randy Harmelink" rharmelink
1d
Re: help me:Why not and How can I get the info by rchGetTableCell fr by "Randy Harmelink" rharmelink
Messages
Thu Jul 27, 2017 7:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's definitely the Chinese characters. Your formula didn't work for me
either. I used RCHGetWebData() with the string you gave me and the add-in
doesn't find it either. At all. But I do find the string within the source
code of the web page using the browser though.
So somewhere in the process, either the Windows communication library the
add-in uses, or EXCEL, is changing those Chinese characters to be something
else.
I've attached a workbook with what works for me, because I'm not sure how
the Yahoo group processing might mangle the characters in an email.
The way I figured out what to use was:
1. I used your search string in my browser to find out what data you were
going after.
2. I opened the SMF-Quick-Webpage-Examination.xls
3. I entered your URL into the "By HTML Tag" sheet and searched for "td"
HTML tags
4. Looked for the data you were after
5. Checked to see what EXCEL had as a label in the preceding "td" tag.
On Thu, Jul 27, 2017 at 6:54 PM, fortune.rao@
...
wrote:
>
> =rchGetTableCell("http://www.cninfo.com.cn/information/brief/shmb
> "&$A5&".html",1,I$3)
>
> where $A5="600000" and I$3="注册资本"
>
>
>
either. I used RCHGetWebData() with the string you gave me and the add-in
doesn't find it either. At all. But I do find the string within the source
code of the web page using the browser though.
So somewhere in the process, either the Windows communication library the
add-in uses, or EXCEL, is changing those Chinese characters to be something
else.
I've attached a workbook with what works for me, because I'm not sure how
the Yahoo group processing might mangle the characters in an email.
The way I figured out what to use was:
1. I used your search string in my browser to find out what data you were
going after.
2. I opened the SMF-Quick-Webpage-Examination.xls
3. I entered your URL into the "By HTML Tag" sheet and searched for "td"
HTML tags
4. Looked for the data you were after
5. Checked to see what EXCEL had as a label in the preceding "td" tag.
On Thu, Jul 27, 2017 at 6:54 PM, fortune.rao@
...
wrote:
>
> =rchGetTableCell("http://www.cninfo.com.cn/information/brief/shmb
> "&$A5&"
>
> where $A5="600000&qu
>
>
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)
Thu Jul 27, 2017 7:33 pm (PDT) . Posted by:
fortune.rao
=rchGetTableCell("http://www.cninfo.com.cn/information/stock/cashflow_.jsp?stockCode="&$A5,1,L$3)
where $A5="600000" and L$3="经营活动产生的现金流量净额"
it can get the value of the first season info of 2017 with default.
But I don't know how to formula to get the value for the annual info of 2016.
where $A5="600000&qu
it can get the value of the first season info of 2017 with default.
But I don't know how to formula to get the value for the annual info of 2016.
Thu Jul 27, 2017 7:50 pm (PDT) . Posted by:
fortune.rao
Dear Randy Harmelink, thank you very much for your help. but I don't know why the other formula can get the right value of the default period (2017 the first season)
=rchGetTableCell("http://www.cninfo.com.cn/information/stock/cashflow_.jsp?stockCode="&$A5,1,L$3)
where $A5="600000" and L$3="经营活动产生的现金流量净额".
I was some confused and I don't know how to get the other period value (for example:2016 annual info)
=rchGetTableCell("http://www.cninfo.com.cn/information/stock/cashflow_.jsp?stockCode="&$A5,1,
where $A5="600000" and L$3="经营活动产生的现金流量净额".
I was some confused and I don't know how to get the other period value (for example:2016 annual info)
Thu Jul 27, 2017 7:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to add a year parameter to get the web page for 2016. For example:
=RCHGetTableCell("
http://www.cninfo.com.cn/information/stock/cashflow_.jsp?yyyy=2016&stockCode=
"&$A5,1,L3)
On Thu, Jul 27, 2017 at 7:33 PM, fortune.rao@
...
wrote:
>
> =rchGetTableCell("http://www.cninfo.com.cn/information/
> stock/cashflow_.jsp?stockCode="&$A5,1,L$3)
>
> where $A5="600000" and L$3="经营活动产生的现金流量净额"
>
> it can get the value of the first season info of 2017 with default.
>
> But I don't know how to formula to get the value for the annual info of
> 2016.
>
>
=RCHGetTableCell("
http://www.cninfo.com.cn/information/stock/cashflow_.jsp?yyyy=2016&stockCode=
"&$A5,1,L3)
On Thu, Jul 27, 2017 at 7:33 PM, fortune.rao@
...
wrote:
>
> =rchGetTableCell("http://www.cninfo.com.cn/information/
> stock/cashflow_
>
> where $A5="600000&qu
>
> it can get the value of the first season info of 2017 with default.
>
> But I don't know how to formula to get the value for the annual info of
> 2016.
>
>
Fri Jul 28, 2017 10:54 am (PDT) . Posted by:
pete_cook2001
In the documentation for smfGetOptionQuotes, the data source in the last column is "B." What is the actual source of the data?
(I'm trying to speed up acquisition of greeks, and I see that other sources that used to be fast are now slow.)
(I'm trying to speed up acquisition of greeks, and I see that other sources that used to be fast are now slow.)
Fri Jul 28, 2017 1:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The "B" is for Barchart. It extracts data from barchart.com's JSON file. A
web page created from the JSON file:
https://www.barchart.com/stocks/quotes/MMM/options
https://www.barchart.com/stocks/quotes/MMM/volatility-greeks
I use them because they are very quick, but I recently found out that they
only update option prices once an hour, so quotes can be a little stale.
On Fri, Jul 28, 2017 at 10:54 AM, peterscottcook@
...
wrote:
> In the documentation for smfGetOptionQuotes, the data source in the last
> column is "B." What is the actual source of the data?
>
> (I'm trying to speed up acquisition of greeks, and I see that other
> sources that used to be fast are now slow.)
>
web page created from the JSON file:
https://www.barchart.com/stocks/quotes/MMM/options
https://www.barchart.com/stocks/quotes/MMM/volatility-greeks
I use them because they are very quick, but I recently found out that they
only update option prices once an hour, so quotes can be a little stale.
On Fri, Jul 28, 2017 at 10:54 AM, peterscottcook@
...
wrote:
> In the documentation for smfGetOptionQuotes, the data source in the last
> column is "B." What is the actual source of the data?
>
> (I'm trying to speed up acquisition of greeks, and I see that other
> sources that used to be fast are now slow.)
>
Fri Jul 28, 2017 1:24 pm (PDT) . Posted by:
pete_cook2001
Suddenly, all of my fields that use RCHGetYahooQuotes are returning errors. Yesterday everything was fine. I just downloaded the latest release and still no change. Any ideas?
(smfGetOptionQuotes fields work fine.)
(smfGetOptionQuotes fields work fine.)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar