15 New Messages
Digest #2479
Messages
Thu Jan 24, 2013 7:43 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The problem is that Yahoo mixes expiration dates within given expiration
months, so the offset of OTMx and ITMx won't work on those months (the
algorithm just looks for the first ITM strike price, and pulls rows based
on that). It used to work, before they added all of the weekly options.
The best solution is to use smfGetOptionStrikes() and retrieve the ITM/OTM
strike prices from OptionsXPress.
I always use OptionsXPress these days. They are more reliable because they
have to have customers trading on the data, instead of someone like Yahoo,
who is merely reporting the data.
On Thu, Jan 24, 2013 at 8:23 AM, bholscher@rocketmail.com <
bholscher@rocketmail.com > wrote:
> Hello - I am running into a problem when pulling option quotes on SPY.
>
> When I input:
>
> spy Feb 2013 OTM1 Put.....returns: 149 strike exp. 2/22
> spy Feb 2013 OTM2 Put.....returns: 149 strike exp. 2/16
> spy Feb 2013 OTM3 Put.....returns: 149 strike exp. 2/8
> spy Feb 2013 OTM4 Put.....returns: 149 strike exp. 2/1
> etc
>
> Is there a way to just pull the OTMs with 2/16 expiration?
>
> When I input:
>
> spy 2/16 OTM1 Put..... returns options with 1/25 expirations
> (this is also the case when inputing other month-end expiration dates;
> 3/16...returns 1/25 expirations.... 4/20 returns 1/25 expirations)
>
months, so the offset of OTMx and ITMx won't work on those months (the
algorithm just looks for the first ITM strike price, and pulls rows based
on that). It used to work, before they added all of the weekly options.
The best solution is to use smfGetOptionStrikes
strike prices from OptionsXPress.
I always use OptionsXPress these days. They are more reliable because they
have to have customers trading on the data, instead of someone like Yahoo,
who is merely reporting the data.
On Thu, Jan 24, 2013 at 8:23 AM, bholscher@rocketmai
bholscher@rocketmai
> Hello - I am running into a problem when pulling option quotes on SPY.
>
> When I input:
>
> spy Feb 2013 OTM1 Put.....returns: 149 strike exp. 2/22
> spy Feb 2013 OTM2 Put.....returns: 149 strike exp. 2/16
> spy Feb 2013 OTM3 Put.....returns: 149 strike exp. 2/8
> spy Feb 2013 OTM4 Put.....returns: 149 strike exp. 2/1
> etc
>
> Is there a way to just pull the OTMs with 2/16 expiration?
>
> When I input:
>
> spy 2/16 OTM1 Put..... returns options with 1/25 expirations
> (this is also the case when inputing other month-end expiration dates;
> 3/16...returns 1/25 expirations.
>
Thu Jan 24, 2013 7:48 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Why would you need the REPNO for consensus data? Extraction appear to work
from the original web page.
On Thu, Jan 24, 2013 at 8:25 AM, jsawyermib jsawyermib@yahoo.com > wrote:
> Apologies for breaking into this thread but this is also something that I
> am trying to do (extract consensus company forecasts from 4-Traders.com). I
> tried the below code but it did not work for me (left just a blank in my
> worksheet). Is there some other setup that I am perhaps missing?
>
from the original web page.
On Thu, Jan 24, 2013 at 8:25 AM, jsawyermib jsawyermib@yahoo.
> Apologies for breaking into this thread but this is also something that I
> am trying to do (extract consensus company forecasts from 4-Traders.com)
> tried the below code but it did not work for me (left just a blank in my
> worksheet). Is there some other setup that I am perhaps missing?
>
Thu Jan 24, 2013 8:05 am (PST) . Posted by:
"Shri K" truebangalorean
Randy,
In your timed refresh RCHGetYahooQuotes file, what makes it refresh itself using the time mentioned in the rows above. Because the RCHGetYahooQuotes seems to be the same as the usual function.
thanks,
Shri
Thu Jan 24, 2013 8:18 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You need to click the "Start Updates" button to start the process. A VBA
routine runs the updates.
On Thu, Jan 24, 2013 at 9:05 AM, Shri K truebangalorean@yahoo.com > wrote:
>
> In your timed refresh RCHGetYahooQuotes file, what makes it refresh itself
> using the time mentioned in the rows above. Because the RCHGetYahooQuotes
> seems to be the same as the usual function.
>
routine runs the updates.
On Thu, Jan 24, 2013 at 9:05 AM, Shri K truebangalorean@
>
> In your timed refresh RCHGetYahooQuotes file, what makes it refresh itself
> using the time mentioned in the rows above. Because the RCHGetYahooQuotes
> seems to be the same as the usual function.
>
Thu Jan 24, 2013 8:59 am (PST) . Posted by:
"NicholasDavid" davidnicholas738
Hi, I have a separate question.
I just created a new worksheet on excel and all my function codes work except the following:
rchgetelementnumber
rchgetelementnumber
I'm confused because these functions work ok in another worksheet I have.
thanks, David
----- Original Message -----
From: "Randy Harmelink" rharmelink@gmail.
To: "smf addin" smf_addin@yahoogrou
Sent: Thursday, January 24, 2013 10:18:23 AM
Subject: Re: [smf_addin] Re: Timed refresh during market hours
You need to click the "Start Updates" button to start the process. A VBA routine runs the updates.
On Thu, Jan 24, 2013 at 9:05 AM, Shri K < truebangalorean@
In your timed refresh RCHGetYahooQuotes file, what makes it refresh itself using the time mentioned in the rows above. Because the RCHGetYahooQuotes seems to be the same as the usual function.
Thu Jan 24, 2013 9:14 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm surprised element 13730 would work anywhere, since Reuter's isn't
really showing data on their web page right now. It's been a problem since
last weekend.
Element 542 might not work if your element definitions aren't current. MSN
changed their website structure early last year.
On Thu, Jan 24, 2013 at 9:59 AM, NicholasDavid nicholasdavid@comcast.net >wrote:
> Hi, I have a separate question.
>
> I just created a new worksheet on excel and all my function codes work
> except the following:
>
> rchgetelementnumber(symbol,13730) and
>
> rchgetelementnumber(symbol,542)
>
> I'm confused because these functions work ok in another worksheet I have.
>
really showing data on their web page right now. It's been a problem since
last weekend.
Element 542 might not work if your element definitions aren't current. MSN
changed their website structure early last year.
On Thu, Jan 24, 2013 at 9:59 AM, NicholasDavid nicholasdavid@
> Hi, I have a separate question.
>
> I just created a new worksheet on excel and all my function codes work
> except the following:
>
> rchgetelementnumber
>
> rchgetelementnumber
>
> I'm confused because these functions work ok in another worksheet I have.
>
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Templates and Examples/smfGetTagC
Uploaded by : rharmelink rharmelink@gmail.
Description : This is an example of a quick process I sometimes use to examine what types of things may be on the web page, and whether things might be extractable. By varying the HTML tag and start string, you can explore the contents of the web page pretty quickly. For example, I might start by seeing how many HTML tables are present, then maybe table rows, and so forth.
You can access this file at the URL:
http://groups.
To learn more about file sharing for your group, please visit:
http://help.
Regards,
rharmelink rharmelink@gmail.
Thu Jan 24, 2013 12:22 pm (PST) . Posted by:
"thomas91112" thomas91112
I have searched high and low for a website that will provide real time pricing for a broad array of investments e.g. stocks, ETFs, commodities, foreign exchange, indices, cash and futures pricing. The only site I have found is Investing.com. Have compared their quotes with other real time services and they are valid. Could you write coding much like you have for RCHGetYahooHistory and RCHGetYahooQuotes? It would be so great to everything coming in through one source with real time pricing which I know is of growing interest based on queries through this Group.
Thu Jan 24, 2013 1:11 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The reason for RCHGetYahooQuotes() and RCHGetYahooHistory() is that Yahoo
provides a CSV file with the data. Is that something that investing.comprovides?
Otherwise, you'd have to do it web page by web page, which is significantly
slower.
On Thu, Jan 24, 2013 at 1:22 PM, thomas91112 thomas91112@yahoo.com > wrote:
> I have searched high and low for a website that will provide real time
> pricing for a broad array of investments e.g. stocks, ETFs, commodities,
> foreign exchange, indices, cash and futures pricing. The only site I have
> found is Investing.com. Have compared their quotes with other real time
> services and they are valid. Could you write coding much like you have for
> RCHGetYahooHistory and RCHGetYahooQuotes? It would be so great to
> everything coming in through one source with real time pricing which I know
> is of growing interest based on queries through this Group.
>
provides a CSV file with the data. Is that something that investing.comprovid
Otherwise, you'd have to do it web page by web page, which is significantly
slower.
On Thu, Jan 24, 2013 at 1:22 PM, thomas91112 thomas91112@
> I have searched high and low for a website that will provide real time
> pricing for a broad array of investments e.g. stocks, ETFs, commodities,
> foreign exchange, indices, cash and futures pricing. The only site I have
> found is Investing.com. Have compared their quotes with other real time
> services and they are valid. Could you write coding much like you have for
> RCHGetYahooHistory and RCHGetYahooQuotes? It would be so great to
> everything coming in through one source with real time pricing which I know
> is of growing interest based on queries through this Group.
>
Thu Jan 24, 2013 12:44 pm (PST) . Posted by:
"Thomas S" mrtomschu
Please direct me to the template that shows the top 5 stocks in each of the IBD industry subgroups. I messed mine up and I been searching all over the site for the original template. Thanks Tom
Thu Jan 24, 2013 1:15 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Is this what you're referring to?
http://finance.groups.yahoo.com/group/smf_addin/message/18014
On Thu, Jan 24, 2013 at 1:44 PM, Thomas S mrtomschu@gmail.com > wrote:
> Please direct me to the template that shows the top 5 stocks in each of
> the IBD industry subgroups. I messed mine up and I been searching all over
> the site for the original template. Thanks Tom
>
http://finance.
On Thu, Jan 24, 2013 at 1:44 PM, Thomas S mrtomschu@gmail.
> Please direct me to the template that shows the top 5 stocks in each of
> the IBD industry subgroups. I messed mine up and I been searching all over
> the site for the original template. Thanks Tom
>
Thu Jan 24, 2013 5:15 pm (PST) . Posted by:
"Thomas S" mrtomschu
--- In smf_addin@yahoogrou
>
> Is this what you're referring to?
>
> http://finance.
>
> On Thu, Jan 24, 2013 at 1:44 PM, Thomas S wrote:
>
> > Please direct me to the template that shows the top 5 stocks in each of
> > the IBD industry subgroups. I messed mine up and I been searching all over
> > the site for the original template. Thanks Tom
> >
>
That's the one. Thank you very much Tom
Thu Jan 24, 2013 6:36 pm (PST) . Posted by:
"lexstar" lexstar
If I want to pull the price only OHLC for the last year (ie. 12/31/2011 to 12/31/2012) can I use RCHGetYahooHistory()?
I tried using that and only got the LAST months OHLC. I didn't get the OHLC for the period specified.
Here's what I used: =RCHGetYahooHistory($A5,YEAR(J$1),MONTH(J$1),DAY(J$1),YEAR(C$1),MONTH(C$1),DAY(C$1),"m","ohlc",0,0,1,4)
where J$1 is 12/31/2011 and C$1 is 12/31/2012
Any help appreciated.
Thanks,
Luke
I tried using that and only got the LAST months OHLC. I didn't get the OHLC for the period specified.
Here's what I used: =RCHGetYahooHistory
where J$1 is 12/31/2011 and C$1 is 12/31/2012
Any help appreciated.
Thanks,
Luke
Thu Jan 24, 2013 7:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The last two parameters, "1,4", say to only return 1 row and 4 columns of
data. That's why you only have one row of data.
On Thu, Jan 24, 2013 at 7:36 PM, lexstar lexstar@yahoo.com > wrote:
> If I want to pull the price only OHLC for the last year (ie. 12/31/2011 to
> 12/31/2012) can I use RCHGetYahooHistory()?
>
> I tried using that and only got the LAST months OHLC. I didn't get the
> OHLC for the period specified.
>
> Here's what I used:
> =RCHGetYahooHistory($A5,YEAR(J$1),MONTH(J$1),DAY(J$1),YEAR(C$1),MONTH(C$1),DAY(C$1),"m","ohlc",0,0,1,4)
>
> where J$1 is 12/31/2011 and C$1 is 12/31/2012
>
data. That's why you only have one row of data.
On Thu, Jan 24, 2013 at 7:36 PM, lexstar lexstar@yahoo.
> If I want to pull the price only OHLC for the last year (ie. 12/31/2011 to
> 12/31/2012) can I use RCHGetYahooHistory(
>
> I tried using that and only got the LAST months OHLC. I didn't get the
> OHLC for the period specified.
>
> Here's what I used:
> =RCHGetYahooHistory
>
> where J$1 is 12/31/2011 and C$1 is 12/31/2012
>
Thu Jan 24, 2013 7:25 pm (PST) . Posted by:
"lexstar" lexstar
I do wanted just 1 row and 4 columns of data...
I want the OHLC for the period between the 2 dates, not just the last month.
I don't want to download the whole history each month's OHLC from the beginning of the period to the end.
I try the SMFPricesBetween(), but that only provides me with the adjusted OHLC prices, which is not want. I want the "non-adjusted" OHLC.
And, the RCHGetYahooQuotes() has its limitations.
So, if any function that could provide me with the same thing as the smfPricesBetween(), but only gives me the "non-adjusted" prices, that would solve my problem.
Thanks in advance.
Luke
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> The last two parameters, "1,4", say to only return 1 row and 4 columns of
> data. That's why you only have one row of data.
>
> On Thu, Jan 24, 2013 at 7:36 PM, lexstar wrote:
>
> > If I want to pull the price only OHLC for the last year (ie. 12/31/2011 to
> > 12/31/2012) can I use RCHGetYahooHistory()?
> >
> > I tried using that and only got the LAST months OHLC. I didn't get the
> > OHLC for the period specified.
> >
> > Here's what I used:
> > =RCHGetYahooHistory($A5,YEAR(J$1),MONTH(J$1),DAY(J$1),YEAR(C$1),MONTH(C$1),DAY(C$1),"m","ohlc",0,0,1,4)
> >
> > where J$1 is 12/31/2011 and C$1 is 12/31/2012
> >
>
I want the OHLC for the period between the 2 dates, not just the last month.
I don't want to download the whole history each month's OHLC from the beginning of the period to the end.
I try the SMFPricesBetween(
And, the RCHGetYahooQuotes(
So, if any function that could provide me with the same thing as the smfPricesBetween(
Thanks in advance.
Luke
--- In smf_addin@yahoogrou
>
> The last two parameters, "1,4"
> data. That's why you only have one row of data.
>
> On Thu, Jan 24, 2013 at 7:36 PM, lexstar wrote:
>
> > If I want to pull the price only OHLC for the last year (ie. 12/31/2011 to
> > 12/31/2012) can I use RCHGetYahooHistory(
> >
> > I tried using that and only got the LAST months OHLC. I didn't get the
> > OHLC for the period specified.
> >
> > Here's what I used:
> > =RCHGetYahooHistory
> >
> > where J$1 is 12/31/2011 and C$1 is 12/31/2012
> >
>
Tidak ada komentar:
Posting Komentar