15 New Messages
Digest #2664
Messages
Thu Jun 20, 2013 6:35 am (PDT) . Posted by:
"Rich" rlmacduff
Could you provide the syntax for pulling the next month's first OTM strike price based on knowing the stock ticker symbol and the current trading price? For example … I would like to populate the July strike price for stocks I am monitoring. I think it has to do with using OTM1, I'm just at a loss as to how to create the correct code.
Thanks in advance …. Rich
Thanks in advance …. Rich
Thu Jun 20, 2013 6:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, first thing I would do is to find the expiration date:
B2: =smfGetOptionExpiry(2013,7,"M")
Then, I would use the smfGetOptionStrikes() function to get the strike
prices. It's more reliable than using the OTM1 and ITM1 parameters, because
weekly options now mean the near-team months can have multiple expiration
dates on a Yahoo web page.
B4: =smfGetOptionStrikes("SPY";,B2,"C","Y",1)
Or, to get the first ITM price only:
=smfGetOptionStrikes("SPY";,B2,"C","Y",1,2,1)
Note that if you array-entered the above over a 1-column by 4-row range,
you would get the 2 ITM and 2 OTM strike prices. The last "1" parameter
tells it to make option ticker symbols for the smfGetOptionQuotes()
function, instead of just returning the strike price.
So, you could either have:
2013-07-20 SPY 7/20 2013 $164.00 Call
...or:
2013-07-20 SPY 7/20 2013 $162.00 Call SPY 7/20 2013
$163.00 Call SPY 7/20 2013 $164.00 Call SPY 7/20 2013 $165.00 Call
For info on more option functions, take a look at:
http://finance.groups.yahoo.com/group/smf_addin/message/17234
On Thu, Jun 20, 2013 at 6:29 AM, Rich <rlmacduff@cox.net > wrote:
> Could you provide the syntax for pulling the next month's first OTM strike
> price based on knowing the stock ticker symbol and the current trading
> price? For example … I would like to populate the July strike price for
> stocks I am monitoring. I think it has to do with using OTM1, I'm just at a
> loss as to how to create the correct code.
> Thanks in advance …. Rich
>
B2: =smfGetOptionExpiry
Then, I would use the smfGetOptionStrikes
prices. It's more reliable than using the OTM1 and ITM1 parameters, because
weekly options now mean the near-team months can have multiple expiration
dates on a Yahoo web page.
B4: =smfGetOptionStrike
Or, to get the first ITM price only:
=smfGetOptionStrike
Note that if you array-entered the above over a 1-column by 4-row range,
you would get the 2 ITM and 2 OTM strike prices. The last "1" parameter
tells it to make option ticker symbols for the smfGetOptionQuotes(
function, instead of just returning the strike price.
So, you could either have:
2013-07-20 SPY 7/20 2013 $164.00 Call
...or:
2013-07-20 SPY 7/20 2013 $162.00 Call SPY 7/20 2013
$163.00 Call SPY 7/20 2013 $164.00 Call SPY 7/20 2013 $165.00 Call
For info on more option functions, take a look at:
http://finance.
On Thu, Jun 20, 2013 at 6:29 AM, Rich <rlmacduff@cox.
> Could you provide the syntax for pulling the next month's first OTM strike
> price based on knowing the stock ticker symbol and the current trading
> price? For example … I would like to populate the July strike price for
> stocks I am monitoring. I think it has to do with using OTM1, I'm just at a
> loss as to how to create the correct code.
> Thanks in advance …. Rich
>
Thu Jun 20, 2013 8:38 am (PDT) . Posted by:
"ron125" ron125
Is there a work around to get the last quote into a cell?
--- In smf_addin@yahoogrou
>
> I see that MSN has changed things around. It seems they also changed data providers.
>
> I sometimes use the Excel MSN web query (Stock Quotes Provided by MSN Money)and note that it's now limited to 50 quotes per query.
>
> Also note that the company name is now all upper case. Some quotes no longer available (for warrants) in the Cdn market.
>
> All this changed yesterday.
>
Thu Jun 20, 2013 8:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not a work-around. A better method. Use the RCHGetYahooQuotes() function.
For example:
=RCHGetYahooQuotes("MMM","l1")
On Thu, Jun 20, 2013 at 8:26 AM, ron125 <ron125@yahoo.com > wrote:
>
> Is there a work around to get the last quote into a cell?
>
For example:
=RCHGetYahooQuotes(
On Thu, Jun 20, 2013 at 8:26 AM, ron125 <ron125@yahoo.
>
> Is there a work around to get the last quote into a cell?
>
Thu Jun 20, 2013 9:54 am (PDT) . Posted by:
"bablam" bablam
Hi,
Given that Yahoo!Finance has a 200-stock limit per download, is there a workaround to quickly get the data for say about 5,000 stocks. If not, is there a better way than to get just 200-stocks at a time?
Thanks
Given that Yahoo!Finance has a 200-stock limit per download, is there a workaround to quickly get the data for say about 5,000 stocks. If not, is there a better way than to get just 200-stocks at a time?
Thanks
Thu Jun 20, 2013 9:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Of course, my first question is why you would even need that much data?
In any case, one alternative would be to grab the FinViz screener output,
which does have closing price and volume. That can be a single CSV file for
everything they cover.
Otherwise, you would need the 250 RCHGetYahooQuotes() functions.
On Thu, Jun 20, 2013 at 9:48 AM, bablam <mbabla@gmail.com > wrote:
>
> Given that Yahoo!Finance has a 200-stock limit per download, is there a
> workaround to quickly get the data for say about 5,000 stocks. If not, is
> there a better way than to get just 200-stocks at a time?
>
In any case, one alternative would be to grab the FinViz screener output,
which does have closing price and volume. That can be a single CSV file for
everything they cover.
Otherwise, you would need the 250 RCHGetYahooQuotes(
On Thu, Jun 20, 2013 at 9:48 AM, bablam <mbabla@gmail.
>
> Given that Yahoo!Finance has a 200-stock limit per download, is there a
> workaround to quickly get the data for say about 5,000 stocks. If not, is
> there a better way than to get just 200-stocks at a time?
>
Thu Jun 20, 2013 10:12 am (PDT) . Posted by:
"Manish Babla" bablam
HI Randy,
Thanks for your response. The closing prices would not work entirely, as I
need intra-day data several times a day as well. Either way, what functions
do I need to grab the FinViz screener output? And if there is any other way
that is more efficient than running the Yahoo!Finance 250-times please let
me know, or even of a way to running them more efficiently.
Thanks,
Manish
On Thu, Jun 20, 2013 at 12:58 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> Of course, my first question is why you would even need that much data?
>
> In any case, one alternative would be to grab the FinViz screener output,
> which does have closing price and volume. That can be a single CSV file for
> everything they cover.
>
> Otherwise, you would need the 250 RCHGetYahooQuotes() functions.
>
>
> On Thu, Jun 20, 2013 at 9:48 AM, bablam <mbabla@gmail.com > wrote:
>
>>
>> Given that Yahoo!Finance has a 200-stock limit per download, is there a
>> workaround to quickly get the data for say about 5,000 stocks. If not, is
>> there a better way than to get just 200-stocks at a time?
>>
>
>
>
Thanks for your response. The closing prices would not work entirely, as I
need intra-day data several times a day as well. Either way, what functions
do I need to grab the FinViz screener output? And if there is any other way
that is more efficient than running the Yahoo!Finance 250-times please let
me know, or even of a way to running them more efficiently.
Thanks,
Manish
On Thu, Jun 20, 2013 at 12:58 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> Of course, my first question is why you would even need that much data?
>
> In any case, one alternative would be to grab the FinViz screener output,
> which does have closing price and volume. That can be a single CSV file for
> everything they cover.
>
> Otherwise, you would need the 250 RCHGetYahooQuotes(
>
>
> On Thu, Jun 20, 2013 at 9:48 AM, bablam <mbabla@gmail.
>
>>
>> Given that Yahoo!Finance has a 200-stock limit per download, is there a
>> workaround to quickly get the data for say about 5,000 stocks. If not, is
>> there a better way than to get just 200-stocks at a time?
>>
>
>
>
Thu Jun 20, 2013 10:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
For FinViz, check out the entries in the LINKS area of the group. The
prices are intraday if retrieved during the day.
On Thu, Jun 20, 2013 at 10:12 AM, Manish Babla <mbabla@gmail.com > wrote:
>
> Thanks for your response. The closing prices would not work entirely, as I
> need intra-day data several times a day as well. Either way, what functions
> do I need to grab the FinViz screener output? And if there is any other way
> that is more efficient than running the Yahoo!Finance 250-times please let
> me know, or even of a way to running them more efficiently.
>
>
prices are intraday if retrieved during the day.
On Thu, Jun 20, 2013 at 10:12 AM, Manish Babla <mbabla@gmail.
>
> Thanks for your response. The closing prices would not work entirely, as I
> need intra-day data several times a day as well. Either way, what functions
> do I need to grab the FinViz screener output? And if there is any other way
> that is more efficient than running the Yahoo!Finance 250-times please let
> me know, or even of a way to running them more efficiently.
>
>
Thu Jun 20, 2013 10:41 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Manish, you are abusing the use of this fantastic Addin by grabbing so much
data. Plus real-time? Why not just subscribe to a real-time data feed?
Checkout https://www.kinetick.com/purchase $50/month
Many times Randy has ask folks to not abuse the websites by pulling the
entire market.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Manish Babla
Sent: Thursday, June 20, 2013 1:12 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] downloading current price-volume data for 5,000+
symbols
HI Randy,
Thanks for your response. The closing prices would not work entirely, as I
need intra-day data several times a day as well. Either way, what functions
do I need to grab the FinViz screener output? And if there is any other way
that is more efficient than running the Yahoo!Finance 250-times please let
me know, or even of a way to running them more efficiently.
Thanks,
Manish
On Thu, Jun 20, 2013 at 12:58 PM, Randy Harmelink <rharmelink@gmail.com >
wrote:
Of course, my first question is why you would even need that much data?
In any case, one alternative would be to grab the FinViz screener output,
which does have closing price and volume. That can be a single CSV file for
everything they cover.
Otherwise, you would need the 250 RCHGetYahooQuotes() functions.
On Thu, Jun 20, 2013 at 9:48 AM, bablam <mbabla@gmail.com > wrote:
Given that Yahoo!Finance has a 200-stock limit per download, is there a
workaround to quickly get the data for say about 5,000 stocks. If not, is
there a better way than to get just 200-stocks at a time?
data. Plus real-time? Why not just subscribe to a real-time data feed?
Checkout https://www.
Many times Randy has ask folks to not abuse the websites by pulling the
entire market.
Kermit
From: smf_addin@yahoogrou
Of Manish Babla
Sent: Thursday, June 20, 2013 1:12 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] downloading current price-volume data for 5,000+
symbols
HI Randy,
Thanks for your response. The closing prices would not work entirely, as I
need intra-day data several times a day as well. Either way, what functions
do I need to grab the FinViz screener output? And if there is any other way
that is more efficient than running the Yahoo!Finance 250-times please let
me know, or even of a way to running them more efficiently.
Thanks,
Manish
On Thu, Jun 20, 2013 at 12:58 PM, Randy Harmelink <rharmelink@gmail.
wrote:
Of course, my first question is why you would even need that much data?
In any case, one alternative would be to grab the FinViz screener output,
which does have closing price and volume. That can be a single CSV file for
everything they cover.
Otherwise, you would need the 250 RCHGetYahooQuotes(
On Thu, Jun 20, 2013 at 9:48 AM, bablam <mbabla@gmail.
Given that Yahoo!Finance has a 200-stock limit per download, is there a
workaround to quickly get the data for say about 5,000 stocks. If not, is
there a better way than to get just 200-stocks at a time?
Thu Jun 20, 2013 11:01 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Checkout www.Ninjatrader.com subscribe to their real-time feed and you get
the charting software free. You can then write your own indicators or
whatever programming you want to do with the datafeed.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Kermit W. Prather
Sent: Thursday, June 20, 2013 1:41 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] downloading current price-volume data for 5,000+
symbols
Manish, you are abusing the use of this fantastic Addin by grabbing so much
data. Plus real-time? Why not just subscribe to a real-time data feed?
Checkout https://www.kinetick.com/purchase $50/month
Many times Randy has ask folks to not abuse the websites by pulling the
entire market.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Manish Babla
Sent: Thursday, June 20, 2013 1:12 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] downloading current price-volume data for 5,000+
symbols
HI Randy,
Thanks for your response. The closing prices would not work entirely, as I
need intra-day data several times a day as well. Either way, what functions
do I need to grab the FinViz screener output? And if there is any other way
that is more efficient than running the Yahoo!Finance 250-times please let
me know, or even of a way to running them more efficiently.
Thanks,
Manish
On Thu, Jun 20, 2013 at 12:58 PM, Randy Harmelink <rharmelink@gmail.com >
wrote:
Of course, my first question is why you would even need that much data?
In any case, one alternative would be to grab the FinViz screener output,
which does have closing price and volume. That can be a single CSV file for
everything they cover.
Otherwise, you would need the 250 RCHGetYahooQuotes() functions.
On Thu, Jun 20, 2013 at 9:48 AM, bablam <mbabla@gmail.com > wrote:
Given that Yahoo!Finance has a 200-stock limit per download, is there a
workaround to quickly get the data for say about 5,000 stocks. If not, is
there a better way than to get just 200-stocks at a time?
the charting software free. You can then write your own indicators or
whatever programming you want to do with the datafeed.
From: smf_addin@yahoogrou
Of Kermit W. Prather
Sent: Thursday, June 20, 2013 1:41 PM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] downloading current price-volume data for 5,000+
symbols
Manish, you are abusing the use of this fantastic Addin by grabbing so much
data. Plus real-time? Why not just subscribe to a real-time data feed?
Checkout https://www.
Many times Randy has ask folks to not abuse the websites by pulling the
entire market.
Kermit
From: smf_addin@yahoogrou
Of Manish Babla
Sent: Thursday, June 20, 2013 1:12 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] downloading current price-volume data for 5,000+
symbols
HI Randy,
Thanks for your response. The closing prices would not work entirely, as I
need intra-day data several times a day as well. Either way, what functions
do I need to grab the FinViz screener output? And if there is any other way
that is more efficient than running the Yahoo!Finance 250-times please let
me know, or even of a way to running them more efficiently.
Thanks,
Manish
On Thu, Jun 20, 2013 at 12:58 PM, Randy Harmelink <rharmelink@gmail.
wrote:
Of course, my first question is why you would even need that much data?
In any case, one alternative would be to grab the FinViz screener output,
which does have closing price and volume. That can be a single CSV file for
everything they cover.
Otherwise, you would need the 250 RCHGetYahooQuotes(
On Thu, Jun 20, 2013 at 9:48 AM, bablam <mbabla@gmail.
Given that Yahoo!Finance has a 200-stock limit per download, is there a
workaround to quickly get the data for say about 5,000 stocks. If not, is
there a better way than to get just 200-stocks at a time?
Thu Jun 20, 2013 1:39 pm (PDT) . Posted by:
"Fred Wright" fredwwright
Has anyone noticed that retrieving the morningstar * rating (I am a subscriber) using:
=VALUE(RCHGetWebData("http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol= "&A3,"stars_purple.gif",1,-11))
that the result varies sometimes from what you get on the site? Perhaps the quicktake... is pulling from a stored page rather than the live database? A recent example is KRFT - the above code returns 4 while the morningstar quote page shows 3.
Thanks for any advice, Fred
=VALUE(RCHGetWebDat
that the result varies sometimes from what you get on the site? Perhaps the quicktake... is pulling from a stored page rather than the live database? A recent example is KRFT - the above code returns 4 while the morningstar quote page shows 3.
Thanks for any advice, Fred
Thu Jun 20, 2013 5:10 pm (PDT) . Posted by:
"kabrod77" mustang66.7599
Do you know where I can get the Relative Strength numbers?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Wednesday, June 19, 2013 8:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] 13862 now returns a blank
It appears MSN dropped those items...I don't see them anywhere on the new print page.
On Wed, Jun 19, 2013 at 5:40 PM, kabrod77 <kabrod77@verizon.net > wrote:
Tried the new file â€" have errors with
=RCHGetElementNumber($A$1,27)
=RCHGetElementNumber($A$1, 28)
From: smf_addin@yahoogrou
Sent: Wednesday, June 19, 2013 8:43 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] 13862 now returns a blank
It appears MSN dropped those items...I don't see them anywhere on the new print page.
On Wed, Jun 19, 2013 at 5:40 PM, kabrod77 <kabrod77@verizon.
Tried the new file â€" have errors with
=RCHGetElementNumbe
=RCHGetElementNumbe
Thu Jun 20, 2013 7:10 pm (PDT) . Posted by:
"james morlock" kagawonger
You might consider calculating them yourself.
http://wiki.
On Thu, Jun 20, 2013 at 8:10 PM, kabrod77 wrote:
Do you know where I can get the Relative Strength numbers?
From: smf_addin@yahoogrou
Behalf Of Randy Harmelink
Sent: Wednesday, June 19, 2013 8:43 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] 13862 now returns a blank
It appears MSN dropped those items...I don't see them anywhere on the
new print page.
On Wed, Jun 19, 2013 at 5:40 PM, kabrod77 < kabrod77@verizon.
<javascript:
wrote:
<javascript:
<javascript:
Tried the new file â€" have errors with
<javascript:
<javascript:
=RCHGetElementNumbe
<javascript:
=RCHGetElementNumbe
<javascript:
<javascript:
<javascript:
<javascript:
Thu Jun 20, 2013 7:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
FinViz has a number of technical and performance values. See the LINKS area
entries on FinViz for more info on getting data from it.
On Thu, Jun 20, 2013 at 5:10 PM, kabrod77 <kabrod77@verizon.net > wrote:
>
> *Do you know where I can get the Relative Strength numbers?*
>
entries on FinViz for more info on getting data from it.
On Thu, Jun 20, 2013 at 5:10 PM, kabrod77 <kabrod77@verizon.
>
> *Do you know where I can get the Relative Strength numbers?*
>
Thu Jun 20, 2013 9:59 pm (PDT) . Posted by:
"kkm2706" kkm2706
Hi,
I am using the RCHGetYahooQuotes and smfGetOptionQuotes functions in an excel designed to track my portfolio. I have noticed that if I use the array version of these and the stocks have an error, the stock values returned are incorrect across a series of values. For example (first column of prices is calculated using an array formula and the second is calculated individually),
AAPL 416.838 416.838
AIG 44.27 44.27
AMZN 273.44 273.44
AT 4.02 4.02
AYR 15.39 15.39
BBEP 17.95 17.95
BIDU 93.23 93.23
BRK B 0 0
BRK.B 28.99 0
BRK-B 0 111.41 ************ see error here
DDD 111.41 43.95 ************ see error here
EXC 43.95 29.9 ************ see error here
FB 29.9 23.9 ************ see error here
Does anyone know a workaround or a fix?
Thanks
I am using the RCHGetYahooQuotes and smfGetOptionQuotes functions in an excel designed to track my portfolio. I have noticed that if I use the array version of these and the stocks have an error, the stock values returned are incorrect across a series of values. For example (first column of prices is calculated using an array formula and the second is calculated individually)
AAPL 416.838 416.838
AIG 44.27 44.27
AMZN 273.44 273.44
AT 4.02 4.02
AYR 15.39 15.39
BBEP 17.95 17.95
BIDU 93.23 93.23
BRK B 0 0
BRK.B 28.99 0
BRK-B 0 111.41 ************ see error here
DDD 111.41 43.95 ************ see error here
EXC 43.95 29.9 ************ see error here
FB 29.9 23.9 ************ see error here
Does anyone know a workaround or a fix?
Thanks
Tidak ada komentar:
Posting Komentar