14 New Messages
Digest #2449
Messages
Thu Dec 27, 2012 1:22 pm (PST) . Posted by:
"Stock Jock" stockjocktrader
I'm using a code that loops through tables with the Yahoo tags and through a table with the Symbol list. This will reduce the number of code lines and I can easily change the Yahoo tags in the table. Here's a code clip of the downloading subroutine. In full download code I will have 3 loops, of which 2 are nested. Is there something in your API code that I will need for parsing?
************
strSql2 = "SELECT Symbol FROM tblSymbolList;
Set rst2 = DBEngine(0)(
rst2.MoveFirst
Do Until rst2.EOF
strSymbol = rst2!Symbol
Set objXML = CreateObject(
objXML.Open "GET", strURL & strSymbol & strWFormat, False
objXML.send
Debug.Print strSymbol
rst2.MoveNext
Loop
************
--- In smf_addin@yahoogrou
>
> No. Just that I had another file I needed to parse, and it had different
> delimiters. So I just made the delimiter a parameter to the function as
> well -- defaulting to a comma.
>
> Have you looked at their API feeds at all, that produce XML files?
>
> On Thu, Dec 27, 2012 at 12:53 PM, Stock Jock <stockjocktrader@
>
> > It appears that Yahoo doesn't provide the use of any other delimiter than
> > the ","? Are you saying that your code changes the delimiter so as not to
> > confuse other "," in the response text?
> >
>
Thu Dec 27, 2012 4:17 pm (PST) . Posted by:
"Stock Jock" stockjocktrader
I like the way your download code provides choices for other countries.
I found a spreadsheet that has code to download forex pairs that I might
eventually include in my database, but for now I have to get past the
bugs and gliches with what I've got.
++++++++++++
--- In smf_addin@yahoogrou
>
> No. Just that I had another file I needed to parse, and it had
different
> delimiters. So I just made the delimiter a parameter to the function
as
> well -- defaulting to a comma.
>
> Have you looked at their API feeds at all, that produce XML files?
>
> On Thu, Dec 27, 2012 at 12:53 PM, Stock Jock stockjocktrader@
>
> > It appears that Yahoo doesn't provide the use of any other delimiter
than
> > the ","? Are you saying that your code changes the delimiter so as
not to
> > confuse other "," in the response text?
> >
>
Thu Dec 27, 2012 4:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I'm not sure just what you're asking?
On Thu, Dec 27, 2012 at 2:22 PM, Stock Jock <stockjocktrader@yahoo.com >wrote:
>
> I'm using a code that loops through tables with the Yahoo tags and through
> a table with the Symbol list. This will reduce the number of code lines
> and I can easily change the Yahoo tags in the table. Here's a code clip of
> the downloading subroutine. In full download code I will have 3 loops, of
> which 2 are nested. Is there something in your API code that I will need
> for parsing?
> **************************************
> strSql2 = "SELECT Symbol FROM tblSymbolList;"
> Set rst2 = DBEngine(0)(0).OpenRecordset(strSql2)
> rst2.MoveFirst
> Do Until rst2.EOF
> strSymbol = rst2!Symbol
> Set objXML = CreateObject("MSXML2.ServerXMLHTTP")
> objXML.Open "GET", strURL & strSymbol & strWFormat, False
> objXML.send
> Debug.Print strSymbol
> rst2.MoveNext
> Loop
> **************************************
>
On Thu, Dec 27, 2012 at 2:22 PM, Stock Jock <stockjocktrader@
>
> I'm using a code that loops through tables with the Yahoo tags and through
> a table with the Symbol list. This will reduce the number of code lines
> and I can easily change the Yahoo tags in the table. Here's a code clip of
> the downloading subroutine. In full download code I will have 3 loops, of
> which 2 are nested. Is there something in your API code that I will need
> for parsing?
> ************
> strSql2 = "SELECT Symbol FROM tblSymbolList;
> Set rst2 = DBEngine(0)(
> rst2.MoveFirst
> Do Until rst2.EOF
> strSymbol = rst2!Symbol
> Set objXML = CreateObject(
> objXML.Open "GET", strURL & strSymbol & strWFormat, False
> objXML.send
> Debug.Print strSymbol
> rst2.MoveNext
> Loop
> ************
>
Thu Dec 27, 2012 6:40 pm (PST) . Posted by:
"Stock Jock" stockjocktrader
You asked if I looked at your API code. I don't know what or where
that code is. Please show me what you are talking about.
============
--- In smf_addin@yahoogrou
Sorry, but I'm not sure just what you're asking?
Thu Dec 27, 2012 7:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry. I meant Yahoo's API feeds -- they produce XML files instead of CSV
files. I just wrote a new function that accesses six of them.
Here's an example of their current quotes API feed, using ticker symbol
"MMM":
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22MMM%22%29&diagnostics=false&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys
On Thu, Dec 27, 2012 at 7:40 PM, Stock Jock <stockjocktrader@yahoo.com >wrote:
> You asked if I looked at your API code. I don't know what or where
> that code is. Please show me what you are talking about.
>
files. I just wrote a new function that accesses six of them.
Here's an example of their current quotes API feed, using ticker symbol
"MMM":
http://query.
On Thu, Dec 27, 2012 at 7:40 PM, Stock Jock <stockjocktrader@
> You asked if I looked at your API code. I don't know what or where
> that code is. Please show me what you are talking about.
>
Thu Dec 27, 2012 9:17 pm (PST) . Posted by:
"Stock Jock" stockjocktrader
Yahoo used to have a webpage with a complete list of all their database
tables: http://www.datatabl
They must have moved it. I was thinking of including the news on
each symbol in my database, but I don't know where the Yahoo news table
is anymore.
So is your new function available in your addin?
============
--- In smf_addin@yahoogrou
>
> Sorry. I meant Yahoo's API feeds -- they produce XML files instead of
CSV
> files. I just wrote a new function that accesses six of them.
>
> Here's an example of their current quotes API feed, using ticker
symbol
> "MMM":
>
>
http://query.
ance.quotes%
datatables.org%
>
> On Thu, Dec 27, 2012 at 7:40 PM, Stock Jock stockjocktrader@
>
> > You asked if I looked at your API code. I don't know what or where
> > that code is. Please show me what you are talking about.
> >
>
Thu Dec 27, 2012 9:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I haven't uploaded the version of the add-in with the new function...
But really, all it does is create the URL for the API feed and then call
the smfGetTagContent() function. For example, using the URL I gave you, if
you wanted to extract the Last Traded Price:
=smfGetTagContent(_URL_,"LastTradePriceOnly")
On Thu, Dec 27, 2012 at 10:17 PM, Stock Jock <stockjocktrader@yahoo.com >wrote:
> Yahoo used to have a webpage with a complete list of all their database
> tables: http://www.datatables.org/ They must have moved it. I was
> thinking of including the news on each symbol in my database, but I don't
> know where the Yahoo news table is anymore.
>
> So is your new function available in your addin?
>
But really, all it does is create the URL for the API feed and then call
the smfGetTagContent(
you wanted to extract the Last Traded Price:
=smfGetTagContent(
On Thu, Dec 27, 2012 at 10:17 PM, Stock Jock <stockjocktrader@
> Yahoo used to have a webpage with a complete list of all their database
> tables: http://www.datatabl
> thinking of including the news on each symbol in my database, but I don't
> know where the Yahoo news table is anymore.
>
> So is your new function available in your addin?
>
Thu Dec 27, 2012 4:53 pm (PST) . Posted by:
"marco.deen" marco.deen
If I want to get only the first strike that is a predefined % out of the money for a ticker, say 10% otm, would that be possible? Thanks in advance for any help here.
Marco
Marco
Thu Dec 27, 2012 5:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I would use the smfGetOptionStrikes() to get a list of strike prices, then
do a MATCH() on the returned prices to find the correct strike price...
On Thu, Dec 27, 2012 at 3:50 PM, marco.deen <marco.deen@gmail.com > wrote:
> If I want to get only the first strike that is a predefined % out of the
> money for a ticker, say 10% otm, would that be possible?
>
do a MATCH() on the returned prices to find the correct strike price...
On Thu, Dec 27, 2012 at 3:50 PM, marco.deen <marco.deen@gmail.
> If I want to get only the first strike that is a predefined % out of the
> money for a ticker, say 10% otm, would that be possible?
>
Thu Dec 27, 2012 6:02 pm (PST) . Posted by:
"Agarwal.sudhir" sudhir_agarwal1
I would recommend to get the stock price also and then compare the strike price with stock price to get 10% otm calls
Sent from my Samsung smartphone on AT&T
-------- Original message --------
Subject: [smf_addin] Get 10 % otm option strikes
From: "marco.deen" <marco.deen@gmail.com >
To: smf_addin@yahoogroups.com
CC:
If I want to get only the first strike that is a predefined % out of the money for a ticker, say 10% otm, would that be possible? Thanks in advance for any help here.
Marco
Sent from my Samsung smartphone on AT&T
-------- Original message --------
Subject: [smf_addin] Get 10 % otm option strikes
From: "marco.deen" <marco.deen@gmail.
To: smf_addin@yahoogrou
CC:
If I want to get only the first strike that is a predefined % out of the money for a ticker, say 10% otm, would that be possible? Thanks in advance for any help here.
Marco
Thu Dec 27, 2012 6:01 pm (PST) . Posted by:
"ashok" appusingh
The following has suddenly stopped working --
=RCHGetTableCell("http://cef.morningstar.com/quote?t= ",6,"Total Dist.
Rate",,,,1)
Any help will be highly apprecated .
THANKS
--- In smf_addin@yahoogroups.com , "ashok" wrote:
>
>
>
> PERFECT !
>
> THANKS !
>
> --- In smf_addin@yahoogroups.com , Martin Topper mtopper@ wrote:
> >
> > and this one with bbn in A3
> >
> > =RCHGetTableCell("http://cef.morningstar.com/quote?t= ",6,"Total
Dist. Rate",,,,1)
> >
> > Marty
> >
> >
> > the solution is to concatenate the string with the url and the cell
containing the ticker into one long string (see bold above)
> >
> >
> >
> > ________________________________
> > From: ashok appusingh@
> > To: smf_addin@yahoogroups.com
> > Sent: Monday, March 12, 2012 2:15 PM
> > Subject: [smf_addin] Re: Distribution from MorningStar
> >
> >
> > Â
> >
> >
> > Amazing !
> > Now , i want to substitute the ticker with the value of a cell how
do I do that -
> > I tried replacing with or $A1 --did not work .
> >
> > Thanks !
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
> > >
> > > Something like these should work:
> > >
> > >
=0+smfStrExtr(RCHGetWebData("http://quote.morningstar.com/stock/s.aspx?t\
=epd
> > > ","ProjectedYield:",5000,10),"ProjectedYield:""","""")
> > >
> > > =RCHGetTableCell("http://cef.morningstar.com/quote?t=bbn ",6,"Total
Dist.
> > > Rate",,,,1)
> > >
> > > On Sat, Mar 10, 2012 at 6:12 AM, ashok wrote:
> > >
> > > >
> > > > As you can say I am new so please help me -
> > > > I have done my basic first sheet using GetYahooQuotes.
> > > > Works fine -- now I wish to collect the Proj Yield for say "EPD"
> > > > Next , I want collect Total Dist Rate if it is an CEF ( say
"BBN")
> > > >
> > >
> >
>
=RCHGetTableCell(
Rate",,,,1)
Any help will be highly apprecated .
THANKS
--- In smf_addin@yahoogrou
>
>
>
> PERFECT !
>
> THANKS !
>
> --- In smf_addin@yahoogrou
> >
> > and this one with bbn in A3
> >
> > =RCHGetTableCell(
Dist. Rate",,,,1)
> >
> > Marty
> >
> >
> > the solution is to concatenate the string with the url and the cell
containing the ticker into one long string (see bold above)
> >
> >
> >
> > ____________
> > From: ashok appusingh@
> > To: smf_addin@yahoogrou
> > Sent: Monday, March 12, 2012 2:15 PM
> > Subject: [smf_addin] Re: Distribution from MorningStar
> >
> >
> > Â
> >
> >
> > Amazing !
> > Now , i want to substitute the ticker with the value of a cell how
do I do that -
> > I tried replacing with or $A1 --did not work .
> >
> > Thanks !
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Something like these should work:
> > >
> > >
=0+smfStrExtr(
=epd
> > > ","ProjectedYield:
> > >
> > > =RCHGetTableCell(
Dist.
> > > Rate",,,,1)
> > >
> > > On Sat, Mar 10, 2012 at 6:12 AM, ashok wrote:
> > >
> > > >
> > > > As you can say I am new so please help me -
> > > > I have done my basic first sheet using GetYahooQuotes.
> > > > Works fine -- now I wish to collect the Proj Yield for say "EPD"
> > > > Next , I want collect Total Dist Rate if it is an CEF ( say
"BBN")
> > > >
> > >
> >
>
Thu Dec 27, 2012 7:02 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Check out the messages in this thread from earlier this month:
http://finance.groups.yahoo.com/group/smf_addin/messages/13222?threaded=1&m=e&var=1&tidx=1
On Thu, Dec 27, 2012 at 7:01 PM, ashok <appusingh@yahoo.com > wrote:
>
> The following has suddenly stopped working --
>
> *=RCHGetTableCell("http://cef.morningstar.com/quote?t= "&A3,6,"Total Dist.
> Rate",,,,1)*
>
>
http://finance.
On Thu, Dec 27, 2012 at 7:01 PM, ashok <appusingh@yahoo.
>
> The following has suddenly stopped working --
>
> *=RCHGetTableCell(
> Rate",,,,1)*
>
>
Thu Dec 27, 2012 8:31 pm (PST) . Posted by:
"rjemery7" rjemery7
FWIW, given the template SMF-Template-Reuters-Ratios-Comparison.xls, the S&P 500 function calls in the last column no longer seem to be valid.
Thu Dec 27, 2012 10:21 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
No. Reuters dropped them from their web pages...
On Thu, Dec 27, 2012 at 9:31 PM, rjemery7 <rjemery@gmail.com > wrote:
> FWIW, given the template SMF-Template-Reuters-Ratios-Comparison.xls, the
> S&P 500 function calls in the last column no longer seem to be valid.
>
On Thu, Dec 27, 2012 at 9:31 PM, rjemery7 <rjemery@gmail.
> FWIW, given the template SMF-Template-
> S&P 500 function calls in the last column no longer seem to be valid.
>
Tidak ada komentar:
Posting Komentar