7 New Messages
Digest #2478
Messages
Wed Jan 23, 2013 11:12 am (PST) . Posted by:
"Steven" stevenletzer
Yahoo provides a Direct Competitors Comparison table. For example: for the symbol ABT, the URL is http://finance.yahoo.com/q/co?s=ABT&ql=1
What would be the easiest way to capture the table in Excel.
What would be the easiest way to capture the table in Excel.
Wed Jan 23, 2013 11:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetHTMLTable("http://finance.yahoo.com/q/co?s=MMM ","Market
Cap:",-1,"",1)
Or, see: http://finance.groups.yahoo.com/group/smf_addin/message/6974
On Wed, Jan 23, 2013 at 12:12 PM, Steven stevenletzer@yahoo.com > wrote:
> Yahoo provides a Direct Competitors Comparison table. For example: for the
> symbol ABT, the URL is http://finance.yahoo.com/q/co?s=ABT&ql=1
>
> What would be the easiest way to capture the table in Excel.
>
=RCHGetHTMLTable(
Cap:",-
Or, see: http://finance.
On Wed, Jan 23, 2013 at 12:12 PM, Steven stevenletzer@
> Yahoo provides a Direct Competitors Comparison table. For example: for the
> symbol ABT, the URL is http://finance.
>
> What would be the easiest way to capture the table in Excel.
>
Wed Jan 23, 2013 3:09 pm (PST) . Posted by:
"Tommy" atb1023
Randy
I use the add-in to track stock positions at the end of the day. Today I opened the spreadsheet and got #NAME? on all the entries. Just using Yahoo to get the closing amounts. Nothing else changed on the computer. Any suggestions?
Tommy
I use the add-in to track stock positions at the end of the day. Today I opened the spreadsheet and got #NAME? on all the entries. Just using Yahoo to get the closing amounts. Nothing else changed on the computer. Any suggestions?
Tommy
Wed Jan 23, 2013 3:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sounds like either location errors (see LINKS area of Yahoo group), or the
add-in has been deactivated (check the add-in manager to make sure it's
still checked).
On Wed, Jan 23, 2013 at 4:09 PM, Tommy tommybrown@cfl.rr.com > wrote:
> I use the add-in to track stock positions at the end of the day. Today I
> opened the spreadsheet and got #NAME? on all the entries. Just using Yahoo
> to get the closing amounts. Nothing else changed on the computer. Any
> suggestions?
>
add-in has been deactivated (check the add-in manager to make sure it's
still checked).
On Wed, Jan 23, 2013 at 4:09 PM, Tommy tommybrown@cfl.
> I use the add-in to track stock positions at the end of the day. Today I
> opened the spreadsheet and got #NAME? on all the entries. Just using Yahoo
> to get the closing amounts. Nothing else changed on the computer. Any
> suggestions?
>
Wed Jan 23, 2013 3:20 pm (PST) . Posted by:
"Tommy" atb1023
The add-in was disabled. Turned it on and all works fine.
Tommy
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Sounds like either location errors (see LINKS area of Yahoo group), or the
> add-in has been deactivated (check the add-in manager to make sure it's
> still checked).
>
> On Wed, Jan 23, 2013 at 4:09 PM, Tommy wrote:
>
> > I use the add-in to track stock positions at the end of the day. Today I
> > opened the spreadsheet and got #NAME? on all the entries. Just using Yahoo
> > to get the closing amounts. Nothing else changed on the computer. Any
> > suggestions?
> >
>
Tommy
--- In smf_addin@yahoogrou
>
> Sounds like either location errors (see LINKS area of Yahoo group), or the
> add-in has been deactivated (check the add-in manager to make sure it's
> still checked).
>
> On Wed, Jan 23, 2013 at 4:09 PM, Tommy wrote:
>
> > I use the add-in to track stock positions at the end of the day. Today I
> > opened the spreadsheet and got #NAME? on all the entries. Just using Yahoo
> > to get the closing amounts. Nothing else changed on the computer. Any
> > suggestions?
> >
>
Thu Jan 24, 2013 7:23 am (PST) . Posted by:
"bholscher@rocketmail.com" bholscher@rocketmail.com
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)
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:25 am (PST) . Posted by:
"jsawyermib" jsawyermib
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?
rgrds
John Sawyers
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> I think you can extract the RepNo from the HTML code of the original web
> page:
>
> =smfStrExtr(RCHGetWebData("
> http://www.4-traders.com/PETROLEO-BRASILEIRO-PETRO-6496795/calendar/
> ","RepNo"),"""","""")
>
> On Tue, Jan 22, 2013 at 5:39 PM, cesarcrivelli wrote:
>
> > Ow, amazing!
> >
> > You got it from html code, at this.RepNo right?
> >
> > So, as I need to get this same table for almost 100 stocks, I must enter
> > in each html table and discover the correspondent code for each ticker? By
> > your knolege and experience, do you think this code is randon and will
> > change? Any faster way to get this for the other tickers?
> >
> > Tks!
> >
>
rgrds
John Sawyers
--- In smf_addin@yahoogrou
>
> I think you can extract the RepNo from the HTML code of the original web
> page:
>
> =smfStrExtr(
> http://www.4-
> ","
>
> On Tue, Jan 22, 2013 at 5:39 PM, cesarcrivelli wrote:
>
> > Ow, amazing!
> >
> > You got it from html code, at this.RepNo right?
> >
> > So, as I need to get this same table for almost 100 stocks, I must enter
> > in each html table and discover the correspondent code for each ticker? By
> > your knolege and experience, do you think this code is randon and will
> > change? Any faster way to get this for the other tickers?
> >
> > Tks!
> >
>
Tidak ada komentar:
Posting Komentar