[smf_addin] Digest Number 3289

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3289

1a

Re: Question for MSN's smf-element by bleushin19

2a

Re: Newbie Questions for HK Stock Options Data by alankc_mok

2b

Re: Newbie Questions for HK Stock Options Data by "Randy Harmelink" rharmelink

Messages

1a

Re: Question for MSN's smf-element

Tue Jan 6, 2015 7:46 pm (PST) . Posted by:

bleushin19

Okay. Thank you for the reply. I'll just go on with the alternative. It's easier to use the elements though.

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

2a

Re: Newbie Questions for HK Stock Options Data

Wed Jan 7, 2015 1:11 am (PST) . Posted by:

alankc_mok

Randy,

I run into problem again today when trying to get the HK Stock Option price , in particular, I am looking for the below

=RCHGetTableCell("https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157 https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157",4,"C Jan-15 - 120.00")

The return value is 1.19 and is this related to the version of SMF Add In being used ?

Thanks

Alan

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

2b

Re: Newbie Questions for HK Stock Options Data

Wed Jan 7, 2015 1:32 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I can't see any reason for 1.19 to be returned. The version of the add-in
shouldn't matter. Not with that function.

Do you perhaps have a cached web page? Either with the add-in, or with your
Internet options?

You can refresh the retrieved web page for the add-in by using the
smfForceRecalculation macro.

And/or you can turn off the Internet Options caching by setting it so that
new web pages are retrieved every time a web page is visited.

See the "Tips and FAQs" web page for more detail on both of those
possibilities.

On Wed, Jan 7, 2015 at 2:11 AM, alankc_mok@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I run into problem again today when trying to get the HK Stock Option
> price , in particular, I am looking for the below
>
> =RCHGetTableCell("
> https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157",4,"C Jan-15
> - 120.00")
>
> The return value is 1.19 and is this related to the version of SMF Add In
> being used ?
>

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

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

Visit Your Group

• New Members 33

• Privacy • Unsubscribe • Terms of Use