6 New Messages
Digest #2524
Messages
Tue Feb 26, 2013 6:03 am (PST) . Posted by:
"JCHyjun" JCHyjun
Thank you!
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> A workaround would be to grab it from the quotes page:
>
> =RCHGetTableCell("http://finance.yahoo.com/q?s=mmm ",1,"Next Earnings Date")
>
> On Mon, Feb 25, 2013 at 7:19 AM, JCHyjun wrote:
>
> > You are right but how to grab this info in MS_Excel?
> >
>
--- In smf_addin@yahoogrou
>
> A workaround would be to grab it from the quotes page:
>
> =RCHGetTableCell(
>
> On Mon, Feb 25, 2013 at 7:19 AM, JCHyjun wrote:
>
> > You are right but how to grab this info in MS_Excel?
> >
>
Tue Feb 26, 2013 7:58 pm (PST) . Posted by:
"Jeff F" jeff_fulkerson
I was wondering if smf_addin works with Excel 2013. I was planning on upgrading from 2007, but won't do it if the addin is not compatible.
Thanks.
Thanks.
Tue Feb 26, 2013 8:01 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Same question was asked in November and someone reported it worked for them:
http://finance.groups.yahoo.com/group/smf_addin/message/20210
On Tue, Feb 26, 2013 at 8:54 PM, Jeff F jeff_fulkerson@yahoo.com > wrote:
> I was wondering if smf_addin works with Excel 2013. I was planning on
> upgrading from 2007, but won't do it if the addin is not compatible.
>
http://finance.
On Tue, Feb 26, 2013 at 8:54 PM, Jeff F jeff_fulkerson@
> I was wondering if smf_addin works with Excel 2013. I was planning on
> upgrading from 2007, but won't do it if the addin is not compatible.
>
Wed Feb 27, 2013 2:17 am (PST) . Posted by:
"ds5ec" ds5ec
Hi all,
I've written some Excel VBA to cycle through the following functions for each of about 1200 stocks.
smfGetOptionStrikes
smfGetOptionQuotes
smfGetOptionExpirations
RCHGetYahooQuotes
RCHGetElementNumber
It seems that after about the 300th stock the OX source stops providing data. For example, smfGetOptionStrikes gives "" even though there are valid strikes. To check this I used smfGetOptionQuotes-Example-Table-Building-Exercise.xls as a starting point and added the stock list to sheet 2. Then used smfGetOptionStrikes for each stock. The data stops after about the 900 stock. At that point sheet1 doesn't return data, which it did before.
Would you expect the data feed to stop after so many requests? I've tried waiting a couple of seconds between each function but get the same result. Do you have any advice for dealing with this?
Thanks, David
I've written some Excel VBA to cycle through the following functions for each of about 1200 stocks.
smfGetOptionStrikes
smfGetOptionQuotes
smfGetOptionExpirat
RCHGetYahooQuotes
RCHGetElementNumber
It seems that after about the 300th stock the OX source stops providing data. For example, smfGetOptionStrikes gives "" even though there are valid strikes. To check this I used smfGetOptionQuotes-
Would you expect the data feed to stop after so many requests? I've tried waiting a couple of seconds between each function but get the same result. Do you have any advice for dealing with this?
Thanks, David
Wed Feb 27, 2013 2:34 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The add-in itself is internally limited to 1000 web page accesses. I'm sure
that's what you're running into.
The add-in is intended for ad hoc data retrieval, not for loading up of
databases. It's not fair to place that level of burden on the free data
sources.
If you need that amount of data, you should be using a paid data provider.
On Wed, Feb 27, 2013 at 3:17 AM, ds5ec ds5ec@yahoo.com > wrote:
> I've written some Excel VBA to cycle through the following functions for
> each of about 1200 stocks.
>
> smfGetOptionStrikes
> smfGetOptionQuotes
> smfGetOptionExpirations
> RCHGetYahooQuotes
> RCHGetElementNumber
>
> It seems that after about the 300th stock the OX source stops providing
> data. For example, smfGetOptionStrikes gives "" even though there are valid
> strikes. To check this I used
> smfGetOptionQuotes-Example-Table-Building-Exercise.xls as a starting point
> and added the stock list to sheet 2. Then used smfGetOptionStrikes for each
> stock. The data stops after about the 900 stock. At that point sheet1
> doesn't return data, which it did before.
>
> Would you expect the data feed to stop after so many requests? I've tried
> waiting a couple of seconds between each function but get the same result.
> Do you have any advice for dealing with this?
>
that's what you're running into.
The add-in is intended for ad hoc data retrieval, not for loading up of
databases. It's not fair to place that level of burden on the free data
sources.
If you need that amount of data, you should be using a paid data provider.
On Wed, Feb 27, 2013 at 3:17 AM, ds5ec ds5ec@yahoo.
> I've written some Excel VBA to cycle through the following functions for
> each of about 1200 stocks.
>
> smfGetOptionStrikes
> smfGetOptionQuotes
> smfGetOptionExpirat
> RCHGetYahooQuotes
> RCHGetElementNumber
>
> It seems that after about the 300th stock the OX source stops providing
> data. For example, smfGetOptionStrikes gives "" even though there are valid
> strikes. To check this I used
> smfGetOptionQuotes-
> and added the stock list to sheet 2. Then used smfGetOptionStrikes for each
> stock. The data stops after about the 900 stock. At that point sheet1
> doesn't return data, which it did before.
>
> Would you expect the data feed to stop after so many requests? I've tried
> waiting a couple of seconds between each function but get the same result.
> Do you have any advice for dealing with this?
>
Wed Feb 27, 2013 5:29 am (PST) . Posted by:
"DonaldB" donald_brown_48367
Thanks Randy! I'll check out the other websites first.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Actually, if you look at the values, the element numbers are returning
> both. Apparently, Yahoo has modified the web page, and added the percentage
> values in the same table cell as the number of shares, since I defined the
> elements for their Market Statistics web page.
>
> For example, when I look at the upper left-hand corner of the template,
> this formula:
>
> =RCHGetElementNumber("YahooMS", 13822)
>
> ...is actually returning:
>
> 996 (24%)
>
> The two values can easily be extracted:
>
> =0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"~"," ")
> =0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"(",")")
>
> HOWEVER -- take a look at the differences between these three web page:
>
> http://finance.yahoo.com/advances
> http://www.barchart.com/stocks/momentum.php
> http://online.wsj.com/mdc/public/page/2_3021-tradingdiary2.html
> http://unicorn.us.com/advdec/
>
> Quite a difference in values, huh? To me, the Yahoo numbers look very bad.
> First off, I suspect the other sources omit things like ETFs? It doesn't
> really help to count advancing/declining when you can have ETFs that are
> both long and short -- if one advances, the other should be declining.
>
> On Mon, Feb 25, 2013 at 5:18 PM, DonaldB wrote:
>
> >
> > Is there a way to get the actual number of advancing / declining stocks
> > off the yahoo market statistics page rather than the percentage in
> > brackets? (I can use the percentage and then calculate the number from the
> > total number of stocks but it is always a little off from the actual posted
> > number). Thanks for your help.
> >
>
--- In smf_addin@yahoogrou
>
> Actually, if you look at the values, the element numbers are returning
> both. Apparently, Yahoo has modified the web page, and added the percentage
> values in the same table cell as the number of shares, since I defined the
> elements for their Market Statistics web page.
>
> For example, when I look at the upper left-hand corner of the template,
> this formula:
>
> =RCHGetElementNumbe
>
> ...is actually returning:
>
> 996 (24%)
>
> The two values can easily be extracted:
>
> =0+smfStrExtr(
> =0+smfStrExtr(
>
> HOWEVER -- take a look at the differences between these three web page:
>
> http://finance.
> http://www.barchart
> http://online.
> http://unicorn.
>
> Quite a difference in values, huh? To me, the Yahoo numbers look very bad.
> First off, I suspect the other sources omit things like ETFs? It doesn't
> really help to count advancing/declining when you can have ETFs that are
> both long and short -- if one advances, the other should be declining.
>
> On Mon, Feb 25, 2013 at 5:18 PM, DonaldB wrote:
>
> >
> > Is there a way to get the actual number of advancing / declining stocks
> > off the yahoo market statistics page rather than the percentage in
> > brackets? (I can use the percentage and then calculate the number from the
> > total number of stocks but it is always a little off from the actual posted
> > number). Thanks for your help.
> >
>
Tidak ada komentar:
Posting Komentar