Senin, 19 Maret 2012

[smf_addin] Digest Number 2150

Messages In This Digest (12 Messages)

Messages

1a.

Re: Returning Errors: Trend Values for http://www.masterdata.com/

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Sun Mar 18, 2012 4:39 am (PDT)



Randy,
Thank you very much for your help. Will do on your smfForceRecalculation recommendation.
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I also get a number of errors from them, but when I went to the web site,
> it said the ETF wasn't followed by them.
>
> But I don't know why you would have gotten data with trailing blanks...
>
> When you're changing things around like this, it sometimes helps to run the
> smfForceRecalculation macro, to make sure you have a "fresh" copies of the
> web pages after your changes.
>
> On Sat, Mar 17, 2012 at 5:14 PM, smithjhhic <smithjhhic@...> wrote:
>
> >
> > Yes, you found my error, I had two trailing blanks. That fixes the
> > problem for the formulas where I was getting errors. What is strange is I
> > now get errors with some of my other formulas when I remove the two
> > trailing blanks (example below).
> >
> > =RCHGetTableCell("http://www.askstockguru.com/cgi-bin/s?s="&C6,1,">Market
> > Phase:")
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
2a.

Re: CBOE Symbol List of Weekly Option

Posted by: "JB" jonb0821@comcast.net   jbrown130214

Sun Mar 18, 2012 6:22 am (PDT)



Thank you Randy for all you do for us!!!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You don't even need the add-in -- just use a normal EXCEL referral to copy
> the data directly from their XLS file. For example:
>
> ='https://www.cboe.com/publish/weelkysmf/[weeklysmf.xls]Sheet1'!A1
>
> Just copy down and across as needed.
>
> Otherwise, you can extract the table from the web page with:
>
> =RCHGetHTMLTable("https://www.cboe.com/micro/weeklys/availableweeklys.aspx","(Last
> Updated",-1,"",1)
>
> On Sat, Mar 17, 2012 at 4:03 AM, JB <jonb0821@...> wrote:
>
> > I would like to obtain a list of weekly stock symbols from CBOE site.
> >
> > The data is in a table at the below listed url
> >
> > https://www.cboe.com/micro/weeklys/availableweeklys.aspx
> >
> > Currently I visit the site and download the listing from the available xls
> > download on that same page...
> >
> > Is it possible to get the list off the page directly?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3a.

Can no longer download RCHGetElementNumber("AA",332)

Posted by: "Lawrence" lawrence.leesh@gmail.com   lawleesh

Sun Mar 18, 2012 8:05 am (PDT)



Hi

I was able to download 10-year Sales and Net Income using this formula (source MSN Money) until recently.

Is there something I can do to resolve the problem or is the data no longer available from the source?

regards

LL

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3b.

Re: Can no longer download RCHGetElementNumber("AA",332)

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Mar 18, 2012 10:22 am (PDT)



That formula is working fine here. Are you using the most recent version of
the add-in? MSN did have some URL changes at the beginning of the year...

On Sun, Mar 18, 2012 at 8:05 AM, Lawrence <lawrence.leesh@gmail.com> wrote:

>
> I was able to download 10-year Sales and Net Income using this formula
> (source MSN Money) until recently.
>
> Is there something I can do to resolve the problem or is the data no
> longer available from the source?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.

Re: Can no longer download RCHGetElementNumber("AA",332)

Posted by: "Lawrence" lawrence.leesh@gmail.com   lawleesh

Sun Mar 18, 2012 12:47 pm (PDT)



Thanks Randy. I managed to get it to work with the most recent add-in.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That formula is working fine here. Are you using the most recent version of
> the add-in? MSN did have some URL changes at the beginning of the year...
>
> On Sun, Mar 18, 2012 at 8:05 AM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > I was able to download 10-year Sales and Net Income using this formula
> > (source MSN Money) until recently.
> >
> > Is there something I can do to resolve the problem or is the data no
> > longer available from the source?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4a.

Re: getting data from IBD stock checkup page

Posted by: "ccsjeba" ccsjeba@hotmail.com   ccsjeba

Sun Mar 18, 2012 12:15 pm (PDT)



this is great. Can you share the XLS version of this file?

--- In smf_addin@yahoogroups.com, Mike Fitzpatrick <mff3429@...> wrote:
>
> thanks much, randy, for putting together the IBD template file. I've
> manually maintained a spreadsheet of all 197 industry subgroups and the
> top stocks in them, generally just updating the top 20 subgroups every
> few weeks or so. a rather tedious task. now i can get easily get a
> up-to-date listing by using the addin. attached is a pdf of the
> spreadsheet.
> i've also incorporated the ibd template into my individual stock summary
> spreadsheet, which includes not just the IBD ratings, but other info
> pulled for various sites, all based on the various template files. very
> handy.
> again thanks much. how much time a week do you put in to managing the
> add-in and emails/posts?
> - mike
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
5a.

Earning

Posted by: "MS" metastkuser100@yahoo.com   metastkuser100

Sun Mar 18, 2012 2:24 pm (PDT)



I'm using RCHGetTableCell
The website is http://finance.yahoo.com/q/ae?s=rgr

I am trying to get NEXT YEAR earnings growth estimate (near the bottom of the web page)... and the number returned should be 11.20%... but it is not working (grabbing a different Next Year field).

Thanks Randy!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.

Re: Earning

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Mar 18, 2012 2:47 pm (PDT)



This gets the 11.2% for me:

=RCHGetTableCell("http://finance.yahoo.com/q/ae?s=rgr",1,">Growth
Est",">Next Year")

On Sun, Mar 18, 2012 at 2:24 PM, MS <metastkuser100@yahoo.com> wrote:

> I'm using RCHGetTableCell
> The website is http://finance.yahoo.com/q/ae?s=rgr
>
> I am trying to get NEXT YEAR earnings growth estimate (near the bottom of
> the web page)... and the number returned should be 11.20%... but it is not
> working (grabbing a different Next Year field).
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

Microsoft Office

Posted by: "buccaneerfan55" buccaneerfan55@yahoo.com   buccaneerfan55

Sun Mar 18, 2012 6:33 pm (PDT)



Do I need to purchase the Microsoft Office to use smf addin? I thought maybe because I'm not "manipulating" the information, I could get by with just the "read only" mode. But, I'm pretty sure I will need to purchase to the package (around $110.00 or so).

I have an older computer (2007) with Excel but have used my "trial" period and not sure what options to consider.

Any thoughts? Thx.
MJS

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.

Re: Microsoft Office

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Mar 18, 2012 6:40 pm (PDT)



I suspect your "read only" mode doesn't have VBA capability.

This is what I bought back in 2008, when it was about $80:

http://www.amazon.com/gp/product/B000HCZ8EO

Actually, I downloaded a trial version from the MicroSoft website first.
Then, when I bought the software from Amazon, all I had to do was enter the
registration number so that I was no longer running a "trial" version. I
didn't need to use anything from the software other than that registration
number. No re-installation of the software.

On Sun, Mar 18, 2012 at 6:22 PM, buccaneerfan55 <buccaneerfan55@yahoo.com>wrote:

> Do I need to purchase the Microsoft Office to use smf addin? I thought
> maybe because I'm not "manipulating" the information, I could get by with
> just the "read only" mode. But, I'm pretty sure I will need to purchase to
> the package (around $110.00 or so).
>
> I have an older computer (2007) with Excel but have used my "trial" period
> and not sure what options to consider.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

Re: data from businessweek

Posted by: "sg.nite" sg.nite@yahoo.com   sg.nite

Sun Mar 18, 2012 11:00 pm (PDT)



I'm trying to get the last price done for DBS:SP and YHOO:US. It doesn't work.

How do I get it to work?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 1. The reason you need the "0" is that they have ALL of the information
> in the same table cell, instead of having the amount in a table cell
> following the label. This works for me to extract the data and convert it to
> an amount:
>
> =0+smfStrExtr(RCHGetTableCell("
> http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=5801:JP",0,"52
> WEEK HIGH")&"|",";","|")
>
> 2. This works for me for last price:
>
> =0+smfStrExtr(smfGetTagContent("
> http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=5801:JP
> ","span",1,">Last"),";","<")
>
> 3. These work for me for sector and industry:
>
> =smfGetTagContent("
> http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=5801:JP
> ","a",-1,"sectordetail")
> =smfGetTagContent("
> http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=5801:JP
> ","a",-1,"industrydetail")
>
>
> 52-week high 507 Last 277 Sector INDUSTRIALS SECTOR Industry ELECTRICAL
> EQUIPMENT INDUSTRY
> On Thu, Mar 17, 2011 at 12:26 AM, snvk1012 <krishnasnv@...> wrote:
>
> >
> > I am trying to access the data from snapshot page of businessweek and
> > request for assistance in this regard.
> >
> > a) When I used the formula
> >
> > =RCHGetTableCell("
> > http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=5801:JP",1,"52
> > WEEK HIGH") to access the 52 week high, blank space appears. But when I
> > substituted 0 in place of 1, it returns the value "52 WEEK HIGH04/5/10 -
> > ¥507.00". Could you please explain why is this and how to get number from
> > this result.
> >
> > b) How can I access the "Last" quote which is displayed just below the
> > company ticker.
> >
> > c) Is it possible to access names of classification, i.e. industrials
> > sector and electrical equipment which are displayed right above the company
> > name.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
7b.

Re: data from businessweek

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Mar 18, 2012 11:43 pm (PDT)



Replace the ";" with a "$" -- the original example was in Yen (i.e.
"&yen;"), which had to be stripped from the amount in order to convert it.

On Sun, Mar 18, 2012 at 10:31 PM, sg.nite <sg.nite@yahoo.com> wrote:

> I'm trying to get the last price done for DBS:SP and YHOO:US. It doesn't
> work.
>
> How do I get it to work?
>
> > 2. This works for me for last price:
> >
> > =0+smfStrExtr(smfGetTagContent("
> >
> http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=5801:JP
> > ","span",1,">Last"),";","<")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.50

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)