6 Messages
Digest #3228
Messages
Sat Nov 1, 2014 3:59 am (PDT) . Posted by:
alankc_mok
Randy,
I have been successfully using your add in to get US Stock Options Quote. Currently, I want to get the data for HK Stock Options.
https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157 https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157
I am new to RchGetTableCell and may I ask how can I get the Last Traded for C Nov-14 - 120.00, P Nov-14 - 120.00 ?
Thanks
Alan
I have been successfully using your add in to get US Stock Options Quote. Currently, I want to get the data for HK Stock Options.
https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157 https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157
I am new to RchGetTableCell and may I ask how can I get the Last Traded for C Nov-14 - 120.00, P Nov-14 - 120.00 ?
Thanks
Alan
Sat Nov 1, 2014 4:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Actually, both can be done with the simplest form of the function:
=RCHGetTableCell("
https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157",4,"C Nov-14 -
120.00")
=RCHGetTableCell("
https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157",4,"P Nov-14 -
120.00")
On Sat, Nov 1, 2014 at 3:59 AM, alankc_mok@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I have been successfully using your add in to get US Stock Options
> Quote. Currently, I want to get the data for HK Stock Options.
>
> https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157
>
> I am new to RchGetTableCell and may I ask how can I get the Last Traded
> for C Nov-14 - 120.00, P Nov-14 - 120.00 ?
>
=RCHGetTableCell("
https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157",4,"C Nov-14 -
120.00")
=RCHGetTableCell("
https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157",4,"P Nov-14 -
120.00")
On Sat, Nov 1, 2014 at 3:59 AM, alankc_mok@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I have been successfully using your add in to get US Stock Options
> Quote. Currently, I want to get the data for HK Stock Options.
>
> https://www.hkex.com.hk/eng/ddp/Contract_Details.asp?PId=157
>
> I am new to RchGetTableCell and may I ask how can I get the Last Traded
> for C Nov-14 - 120.00, P Nov-14 - 120.00 ?
>
Sat Nov 1, 2014 6:25 am (PDT) . Posted by:
alankc_mok
Randy,
Thanks for your prompt reply.
Appreciated.
Alan
Thanks for your prompt reply.
Appreciated.
Alan
Sat Nov 1, 2014 10:48 am (PDT) . Posted by:
dsellari
Would it be possible to add flags or optional parameters to allow bypassing the code
I have commented out? They seem to cause problems especially then Calculate Full procedures. Thanks.
Public Sub smfForceRecalculation()
'If Val(Application.Version) < 10 Then
' Application.CalculateFull
'Else
' Application.CalculateFullRebuild
' End If
End Sub
Public Function RCHGetURLData1(pURL As String, _
Optional ByVal pType As String = "GET") As String
Do While bASync
'DoEvents
If oHTTP.ReadyState = 4 Then Exit Do
I have commented out? They seem to cause problems especially then Calculate Full procedures. Thanks.
Public Sub smfForceRecalculati
'If Val(Application.
' Application.
'Else
' Application.
' End If
End Sub
Public Function RCHGetURLData1(
Optional ByVal pType As String = "GET"
Do While bASync
'DoEvents
If oHTTP.ReadyState = 4 Then Exit Do
Sat Nov 1, 2014 4:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but your request makes no sense to me.
There's no point in running smfForceRecalculation if you don't want to
recalculate.
And the "bASync" is already a flag to indicate whether it should do events
until the Asynchronous call completes...that was the whole point of adding
it. Just leave it in the default synchronous mode if you don't want that
processing.
On Sat, Nov 1, 2014 at 10:48 AM, don@cemero... wrote:
>
> Would it be possible to add flags or optional parameters to allow
> bypassing the code
> I have commented out? They seem to cause problems especially then
> Calculate Full procedures. Thanks.
>
> Public Sub smfForceRecalculation()
>
> 'If Val(Application.Version) < 10 Then
> ' Application.CalculateFull
> 'Else
> ' Application.CalculateFullRebuild
> ' End If
> End Sub
>
>
> Public Function RCHGetURLData1(pURL As String, _
> Optional ByVal pType As String = "GET") As String
>
> Do While bASync
> 'DoEvents
> If oHTTP.ReadyState = 4 Then Exit Do
>
There's no point in running smfForceRecalculati
recalculate.
And the "bASync" is already a flag to indicate whether it should do events
until the Asynchronous call completes...
it. Just leave it in the default synchronous mode if you don't want that
processing.
On Sat, Nov 1, 2014 at 10:48 AM, don@cemero..
>
> Would it be possible to add flags or optional parameters to allow
> bypassing the code
> I have commented out? They seem to cause problems especially then
> Calculate Full procedures. Thanks.
>
> Public Sub smfForceRecalculati
>
> 'If Val(Application.
> ' Application.
> 'Else
> ' Application.
> ' End If
> End Sub
>
>
> Public Function RCHGetURLData1(
> Optional ByVal pType As String = "GET"
>
> Do While bASync
> 'DoEvents
> If oHTTP.ReadyState = 4 Then Exit Do
>
Sat Nov 1, 2014 8:57 pm (PDT) . Posted by:
tzewei_79
Hi Randy,
I think yahoo is very unstable....their links keep changing. Just yesterday I can see your smfConvertData works but today it gave error because the link does not show any fiancial statement...I'm switching to barchart or zacks. Thanks.
I think yahoo is very unstable....
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar