6 Messages
Digest #3069
Messages
Mon May 19, 2014 4:35 am (PDT) . Posted by:
"kalyanaraman babuji" geethababuji
Can you please suggest some indian free websites for pulling put call ratio for NIFTY stocks
To: smf_addin@yahoogroups.com
From: smf_addin@yahoogroups.com
Date: Mon, 19 May 2014 00:41:23 -0700
Subject: [smf_addin] Put Call Ratio
To whom that can help,
I have been looking for any free website where I can pull individual put call ratios for any equity or stock listed in North America. I have found a bunch of websites that offer put call ratio for stocks listed on the National Stock Exchange of India Ltd.but non for the S&P 500 or AMEX.
Thanks in advance,
Thomas
Mon May 19, 2014 6:04 pm (PDT) . Posted by:
"andrei radulescu-banu" iubica2
In SMF-Template-Morningstar-Total-Return.xls<http://ogres-crypt.com/SMF/Templates/SMF-Template-Morningstar-Total-Return.xls>,
entering ticker FXSTX, the fund name in cell I11 is not working correctly.
I've tried to step with Visual Basic in RCHExtractData(), and I don't quite
understand why this does not work. The variables are tough to trace in the
debugger, they are offsets in a long URL, and I can't figure out how to
dump them.
Other mutual fund tickers work, and the HTTP page
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=fxstxseems
correct also.
I'm stumped.
Andrei
--
==================================
Andrei Radulescu-Banu
86 Cedar St, Lexington MA
617.216.8509 (m), 781.862.5854 (h)
lex-wiki.org, lex4lang.org,
andrei4schools.com, bitdribble.com
==================================
entering ticker FXSTX, the fund name in cell I11 is not working correctly.
I've tried to step with Visual Basic in RCHExtractData(), and I don't quite
understand why this does not work. The variables are tough to trace in the
debugger, they are offsets in a long URL, and I can't figure out how to
dump them.
Other mutual fund tickers work, and the HTTP page
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=fxstxseems
correct also.
I'm stumped.
Andrei
--
============
Andrei Radulescu-Banu
86 Cedar St, Lexington MA
617.216.8509 (m), 781.862.5854 (h)
lex-wiki.org, lex4lang.org,
andrei4schools.
============
Mon May 19, 2014 6:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. FXSTX is working fine here. In cell I11, I get:
Fund: Fidelity Spartan® US Bond Idx Instl
It should be doing this:
=RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=FXSTX
",0,">Fund:")
On Mon, May 19, 2014 at 6:04 PM, andrei radulescu-banu
bitdribble@gmail.com[smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
> In SMF-Template-Morningstar-Total-Return.xls<http://ogres-crypt.com/SMF/Templates/SMF-Template-Morningstar-Total-Return.xls>,
> entering ticker FXSTX, the fund name in cell I11 is not working correctly.
> I've tried to step with Visual Basic in RCHExtractData(), and I don't quite
> understand why this does not work. The variables are tough to trace in the
> debugger, they are offsets in a long URL, and I can't figure out how to
> dump them.
>
> Other mutual fund tickers work, and the HTTP page
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=fxstxseems correct also.
>
> I'm stumped.
>
Fund: Fidelity Spartan® US Bond Idx Instl
It should be doing this:
=RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=FXSTX
",0,">Fund:")
On Mon, May 19, 2014 at 6:04 PM, andrei radulescu-banu
bitdribble@gmail.com[smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
> In SMF-Template-Morningstar-Total-Return.xls<http://ogres-crypt.com/SMF/Templates/SMF-Template-Morningstar-Total-Return.xls>,
> entering ticker FXSTX, the fund name in cell I11 is not working correctly.
> I've tried to step with Visual Basic in RCHExtractData(), and I don't quite
> understand why this does not work. The variables are tough to trace in the
> debugger, they are offsets in a long URL, and I can't figure out how to
> dump them.
>
> Other mutual fund tickers work, and the HTTP page
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=fxstxseems correct also.
>
> I'm stumped.
>
Mon May 19, 2014 9:40 pm (PDT) . Posted by:
"andrei radulescu-banu" iubica2
Tracing the error back, already in this routine, the object in red
representing the web page just says "Fund: " instead of
"Fund: Fidelity Spartan® US Bond Idx Instl".
Public Function RCHGetURLData1(pURL As String, _
Optional ByVal pType As String = "GET") As String
'---------------------------------------------------------->
Version 2.0i
' 2008.07.18 -- Expand oHTTP.Status selections for "OK" to include zero
' 2009.01.26 -- Allow "GET" or "POST" requests
'----------------------------------------------------------*
On Error GoTo ErrorExit
Dim oHTTP As New XMLHTTP
oHTTP.Open pType, pURL, False
oHTTP.Send
Select Case oHTTP.Status
Case 0: RCHGetURLData1 = oHTTP.responseText
Case 200: RCHGetURLData1 = oHTTP.responseText
Case Else: GoTo ErrorExit
End Select
Exit Function
ErrorExit:
RCHGetURLData1 = vError
End Function
Here is the object dump:
debug.print Mid(oHTTP.responseText, 20000, 100 )
5" height="5" /></td><td class="msSmall" width="150" valign="top">Fund:
</td><td class="msSmall" wid
Andrei
representing the web page just says "Fund: " instead of
"Fund: Fidelity Spartan® US Bond Idx Instl".
Public Function RCHGetURLData1(
Optional ByVal pType As String = "GET"
'-------
Version 2.0i
' 2008.07.18 -- Expand oHTTP.Status selections for "OK" to include zero
' 2009.01.26 -- Allow "GET" or "POST" requests
'-------
On Error GoTo ErrorExit
Dim oHTTP As New XMLHTTP
oHTTP.Open pType, pURL, False
oHTTP.Send
Select Case oHTTP.Status
Case 0: RCHGetURLData1 = oHTTP.responseText
Case 200: RCHGetURLData1 = oHTTP.responseText
Case Else: GoTo ErrorExit
End Select
Exit Function
ErrorExit:
RCHGetURLData1 = vError
End Function
Here is the object dump:
debug.print Mid(oHTTP.responseT
5" height="
</td><
Andrei
Mon May 19, 2014 9:58 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There's really not much the add-in can do if Yahoo isn't serving up the
data on the web page...?
On Mon, May 19, 2014 at 9:40 PM, andrei radulescu-banu
bitdribble@gmail.com[smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
> Tracing the error back, already in this routine, the object in red
> representing the web page just says "Fund: " instead of
> "Fund: Fidelity Spartan® US Bond Idx Instl".
>
> Public Function RCHGetURLData1(pURL As String, _
> Optional ByVal pType As String = "GET") As String
>
> '---------------------------------------------------------->
> Version 2.0i
> ' 2008.07.18 -- Expand oHTTP.Status selections for "OK" to include zero
> ' 2009.01.26 -- Allow "GET" or "POST" requests
>
> '----------------------------------------------------------*
> On Error GoTo ErrorExit
> Dim oHTTP As New XMLHTTP
> oHTTP.Open pType, pURL, False
> oHTTP.Send
> Select Case oHTTP.Status
> Case 0: RCHGetURLData1 = oHTTP.responseText
> Case 200: RCHGetURLData1 = oHTTP.responseText
> Case Else: GoTo ErrorExit
> End Select
> Exit Function
> ErrorExit:
> RCHGetURLData1 = vError
> End Function
>
> Here is the object dump:
>
> debug.print Mid(oHTTP.responseText, 20000, 100 )
> 5" height="5" /></td><td class="msSmall" width="150" valign="top">Fund:
> </td><td class="msSmall" wid
>
data on the web page...?
On Mon, May 19, 2014 at 9:40 PM, andrei radulescu-banu
bitdribble@gmail.com[smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
> Tracing the error back, already in this routine, the object in red
> representing the web page just says "Fund: " instead of
> "Fund: Fidelity Spartan® US Bond Idx Instl".
>
> Public Function RCHGetURLData1(
> Optional ByVal pType As String = "GET"
>
> '-------
> Version 2.0i
> ' 2008.07.18 -- Expand oHTTP.Status selections for "OK" to include zero
> ' 2009.01.26 -- Allow "GET" or "POST" requests
>
> '-------
> On Error GoTo ErrorExit
> Dim oHTTP As New XMLHTTP
> oHTTP.Open pType, pURL, False
> oHTTP.Send
> Select Case oHTTP.Status
> Case 0: RCHGetURLData1 = oHTTP.responseText
> Case 200: RCHGetURLData1 = oHTTP.responseText
> Case Else: GoTo ErrorExit
> End Select
> Exit Function
> ErrorExit:
> RCHGetURLData1 = vError
> End Function
>
> Here is the object dump:
>
> debug.print Mid(oHTTP.responseT
> 5" height="
> </td><
>
Tue May 20, 2014 12:36 am (PDT) . Posted by:
"Pete A" option2z
RE: "Keep in mind he also copied this information from
<http://conscious-investor.com/> http://conscious-investor.com/
which is written by Professor John Price" (Kermit W.Prather)
This is fairly off topic, but I'd like to correct the above. Certainly the
add-in (library) conscious investor is by John Price. But WIT only made use
of that for some calculations. The vast majority was written by Tom, and I
used it for years. It had a few errors, but Tom was gracious about fixing
them. Perhaps it had something to do with how they were reported to him.
This is my last post on the topic, as this board is for SMF discussion, but
I did like the way Tom converted his large code to use SMF. It was good
stuff!
Pete A
<http://www.ttp-s.com/php/toolsmenu.php>
<http://conscious-investor.com/> http://conscious-investor.com/
which is written by Professor John Price" (Kermit W.Prather)
This is fairly off topic, but I'd like to correct the above. Certainly the
add-in (library) conscious investor is by John Price. But WIT only made use
of that for some calculations. The vast majority was written by Tom, and I
used it for years. It had a few errors, but Tom was gracious about fixing
them. Perhaps it had something to do with how they were reported to him.
This is my last post on the topic, as this board is for SMF discussion, but
I did like the way Tom converted his large code to use SMF. It was good
stuff!
Pete A
<http://www.ttp-s.com/php/toolsmenu.php>
Tidak ada komentar:
Posting Komentar