2 Messages

Digest #3432

Hong Kong Stock Options Data by alankc_mok

Problem with RCHgetYahooHistory quote by folonari05

Messages

1

Dear Randy,

I have used your addin for many years. Lately I come across a problem of getting Options Data. Below is the url

https://www.hkex.com.hk/eng/sorc/options/stock_options_detail.aspx?oID=115728&ucode=00941#charts https://www.hkex.com.hk/eng/sorc/options/stock_options_detail.aspx?oID=115728&ucode=00941#charts

In particular, I want to get the data such as Implied Volatility, Option Premium, Net Open Interest, Gross Open Interest.

Thanks

Alan

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

2 Problem with RCHgetYahooHistory quote

Sat Jun 13, 2015 2:13 am (PDT) . Posted by:

folonari05

Hi i'm from Italy.
I've a problem with the function RCHGetYahooHistory. I attach the file with the explanation of the problem.
as you can see the history series appear to me in the wrong format.
although I divided the matrix RCHgetYahooHistory to 10 or 100 , however, the problem is not solved .
for example see the value shown in the attached file in the line indicates F16 .
It 'just a bad value . This problem came out a few months ago . maybe it depends on the version of SMF that i use (i use the last beta version) or the settings of Italian excel . before I had no problem and the values reported in the time series were perfect.

Can you help me?

thanks

fabio

Attachment(s) from

1 of 1 Photo(s)