Minggu, 14 Juni 2015

[smf_addin] Digest Number 3433[1 Attachment]

6 Messages

Digest #3433

Messages

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

"Randy Harmelink" rharmelink

I suspect it has to do with you not using U.S. regional settings on your
computer. Without that, the VBA processing is going to interpret commas and
periods differently when converting text data to numeric.

On Sat, Jun 13, 2015 at 2:13 AM, folonari05@yahoo.it [smf_addin] <
smf_addin@yahoogroups.com> wrote:

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

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

folonari05

thanks randy


why I had never had problems until a few months ago? try to see the new file.
For some ticker like ckp there is no problem. In the file attched, in the ticker in red, i've replaced simbol "a" adjusted with "c" cloe, and divided to 100. for other simbol like AA there's a mix, some values are right and some are wrong..
Is it normal?


Attachment(s) from
1 of 1 Photo(s)

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

"Randy Harmelink" rharmelink

The ones that are a mix may have to do with how well decimal data can be
stored in binary.

How does Italian interpret something like 127.1699998?

On Sat, Jun 13, 2015 at 3:44 AM, folonari05@yahoo.it [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> why I had never had problems until a few months ago? try to see the new
> file.
>
> For some ticker like ckp there is no problem. In the file attched, in the
> ticker in red, i've replaced simbol "a" adjusted with "c" cloe, and divided
> to 100. for other simbol like AA there's a mix, some values are right and
> some are wrong..
>
> Is it normal?
>
>

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

nelsonmuntz1000

The formula works great, Randy. I combined the formula for single formula reference to a fund code as follows:

=smfConvertData(smfStrExtr(smfGetTagContent("http://quotes.morningstar.com/fund/c-header?region=CAN&culture=en-CA&cur=CAD&productCode=CAN&t="&smfStrExtr(RCHGetWebData("http://quote.morningstar.ca/QuickTakes/fund/f_ca.aspx?t="&$A1&"®ion=CAN&culture=en-CA","ticker=",20),"ticker=","/"),"div",-1,"r_star"),"r_star","'"))


where $A1 contains the fund code. Fund codes can be found from http://www.theglobeandmail.com/globe-investor/funds-and-etfs/fund-lookup/ http://www.theglobeandmail.com/globe-investor/funds-and-etfs/fund-lookup/ and from the asset manager websites for anyone that's interested.

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

"Randy Harmelink" rharmelink

Try something like:

=RCHGetTableCell("
https://www.hkex.com.hk/eng/sorc/options/stock_options_detail.aspx?oID=115728&ucode=00941",1,"Contract
Information","Implied Volatility")

You can't use a location modifier in the URL (i.e. "#charts"). The XMLHTTP
protocol I use hiccups if that's part of the URL. It is a browser directive.

On Fri, Jun 12, 2015 at 9:43 PM, alankc_mok@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> 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
>
> In particular, I want to get the data such as Implied Volatility, Option
> Premium, Net Open Interest, Gross Open Interest.
>
>

Sat Jun 13, 2015 6:01 pm (PDT) . Posted by:

alankc_mok

Randy,

Thanks for your prompt reply.


And appreciated for your help.


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

Tidak ada komentar:

Posting Komentar