Rabu, 14 September 2011

[smf_addin] Digest Number 1954

Messages In This Digest (12 Messages)

Messages

1.1.

question for Randy   Re: RCHGetElementNumber

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

Tue Sep 13, 2011 11:48 am (PDT)



Hello Randy...
There seems to be a problem with the data at this MSN website, the one you use where it has all the information together...

Here is one example...I am looking for the MSN Stock Scouter Rating for the stock SDRL

http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=SDRL

The above website, the one you say you use, shows N/A.

However, If I go to the MSN Stock Scouter site,

http://investing.money.msn.com/investments/stock-ratings?symbol=SDRL&

...it shows me that the MSN Stock Scouter rating is 7.

This is one example. There are other examples.

Question: How would I use your tools to get the '7' from this website?
Pls show formula, and I could change it for other stock tickers. Thanks a lot.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> MSN creates it. When looking at a stock:
>
> http://investing.money.msn.com/investments/stock-price?symbol=MMM
>
> ...click on the printer icon to the right of the "Trade" button. Then click
> on "Select All" and "Generate Report". That's the URL I'm using. It's their
> "Print Report" page.
>
> I have the add-in get the data from there because it IS all on one web page,
> and I don't have to waste time getting each individual web page for the
> different pieces of data. Although the layout and some of the content is
> quite different today than it was a few years ago...
>
> On Sun, Sep 11, 2011 at 1:25 PM, investor952 <investor952@...> wrote:
>
> > "(
> > http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=IBM
> > )"
> >
> > WOW!! Randy, did you create this somehow? It shows LOTS of info and I can
> > get it for other companies just by changing the ticker symbol at the end.
> > This link gets it ALL on one page? Thanks.
> >
>

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

Re: question for Randy Re: RCHGetElementNumber

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

Tue Sep 13, 2011 12:25 pm (PDT)



Try:

=smfGetTagContent("
http://investing.money.msn.com/investments/stock-ratings?symbol=SDRL
","div",-2,">Scouter")

On Tue, Sep 13, 2011 at 11:48 AM, investor952 <investor952@yahoo.com> wrote:

>
> There seems to be a problem with the data at this MSN website, the one you
> use where it has all the information together...
>
> Here is one example...I am looking for the MSN Stock Scouter Rating for the
> stock SDRL
>
>
> http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=SDRL
>
> The above website, the one you say you use, shows N/A.
>
> However, If I go to the MSN Stock Scouter site,
>
> http://investing.money.msn.com/investments/stock-ratings?symbol=SDRL&
>
> ...it shows me that the MSN Stock Scouter rating is 7.
>
> This is one example. There are other examples.
>
> Question: How would I use your tools to get the '7' from this website?
> Pls show formula, and I could change it for other stock tickers. Thanks a
> lot.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (34)
2a.

Getting cells from columns

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

Tue Sep 13, 2011 12:20 pm (PDT)



I am using the RCHGetTableCell function to get information from a table in this website: http://www.ism.ws/ismreport/index.cfm

I set it up so that the URL is first, followed by the number of columns to skip across, followed by the string to look for. How would I set it up so that it will look for a string and then make it skip not across columns but down a column. So basically search for a string on top of a column and then tell it how many rows to go down to find the piece of information I want. Is this possible?

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

Re: Getting cells from columns

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

Tue Sep 13, 2011 12:27 pm (PDT)



I don't see a table at that URL. However, there is a parameter that allows
you to skip rows, but then you'd do a column count from the start of the
row. Check the documentation for details.

On Tue, Sep 13, 2011 at 11:20 AM, csegovia0238 <csegovia0238@yahoo.com>wrote:

> I am using the RCHGetTableCell function to get information from a table in
> this website: http://www.ism.ws/ismreport/index.cfm
>
> I set it up so that the URL is first, followed by the number of columns to
> skip across, followed by the string to look for. How would I set it up so
> that it will look for a string and then make it skip not across columns but
> down a column. So basically search for a string on top of a column and then
> tell it how many rows to go down to find the piece of information I want.
> Is this possible?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

another question for Randy regarding RCHGetElementNumber(x, 543)

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

Tue Sep 13, 2011 12:28 pm (PDT)



Hello Randy,

In Excel, I am trying to get the MSN Stock Scouter Rating for PMT.
It is returning N/A.

Yet, when I go to the website you use:

http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=PMT

It shows a '9'.

FUNDAMENTAL DATA
Debt/Equity Ratio NA
Gross Margin -5710.78%
Net Profit Margin 52.83%
Total Shares Outstanding 27.8 Mil
Market Capitalization 463.84 Mil
Earnings/Share 1.82
StockScouter Rating 9

Why isn't the formula picking it up?

Also, as per my previous message..there are also cases where this website does show N/A, but the MSN Stock Scouter website shows the number and appears to be more up to date. Thanks.

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

Re: another question for Randy regarding RCHGetElementNumber(x, 543)

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

Tue Sep 13, 2011 12:37 pm (PDT)



Interesting. I tried:

=RCHGetElementNumber("PMT",543)

...and it got the 9 for me. But then I used the smfForceRecalculation and
got "NA".

When I go into FireFox and use that web address, I also see values changing
on the page if I refresh it a number of times. So it appears that MSN is
still having problems. Some servers may have not gotten changes or updates
propagated to them, so your results may depend on which server returns the
information.

On Tue, Sep 13, 2011 at 12:28 PM, investor952 <investor952@yahoo.com> wrote:

>
> In Excel, I am trying to get the MSN Stock Scouter Rating for PMT.
> It is returning N/A.
>
> Yet, when I go to the website you use:
>
>
> http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=PMT
>
>
> It shows a '9'.
>
> FUNDAMENTAL DATA
> Debt/Equity Ratio NA
> Gross Margin -5710.78%
> Net Profit Margin 52.83%
> Total Shares Outstanding 27.8 Mil
> Market Capitalization 463.84 Mil
> Earnings/Share 1.82
> StockScouter Rating 9
>
> Why isn't the formula picking it up?
>
> Also, as per my previous message..there are also cases where this website
> does show N/A, but the MSN Stock Scouter website shows the number and
> appears to be more up to date. Thanks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: real time quotes

Posted by: "Richard W Stephenson" rwstephenson@sbcglobal.net   rwsvivid

Tue Sep 13, 2011 1:27 pm (PDT)



Randy,
I followed your instructions to log in using the Web Query window, and now it
works so I get real time quotes from Yahoo. Thank you so much for your help and
your program. Today I have been trying to determine how to write the function
to make it do automatic 1 minute updates, but so far have not been successful.
The function I am using is "=RCHGetYahooQuotes(A3,B2:H2)". Please let me know
how to write this function so that it gets the automatic updates if possible?
Thanks again - rwvivid

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Mon, September 12, 2011 10:19:10 PM
Subject: Re: [smf_addin] real time quotes

You don't actually need to DO a Web Query -- just log in using the Web Query
window. Once you are logged in, you can just cancel out of the dialog. However,
when you were in the Web Query dialog, were you seeing real time quotes or
delayed quotes?

On Mon, Sep 12, 2011 at 8:02 PM, Richard W Stephenson
<rwstephenson@sbcglobal.net> wrote:

Thanks again for the prompt reply. The first thing I did was to login using IE
to see if that would work, but it didn't and I still only got 15 minute delayed
quotes. Then I worked for quite a while trying to get the EXCEL Web Entry to
work, but could not. It may be because I have a 2002 version of EXCEL and am
running System 7 Windows. Don't know what the problem was, but I could get to
the point of highlighting the items on the Yahoo page after using the New Web
Inquiry from Excel. I could mark the item on Yahoo but then it would never let
me switch back to Excel to hit the Import Data command. Thanks for your help.
Do you think that the older version of Excel is the problem?
>

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

Re: real time quotes

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

Tue Sep 13, 2011 2:18 pm (PDT)



You would need to write your own VBA routine to do automatic updates. Do a
search on the message archives (or Google) for the "OnTime" VBA command.

On Tue, Sep 13, 2011 at 1:27 PM, Richard W Stephenson <
rwstephenson@sbcglobal.net> wrote:

> I followed your instructions to log in using the Web Query window, and now
> it works so I get real time quotes from Yahoo. Thank you so much for your
> help and your program. Today I have been trying to determine how to write
> the function to make it do automatic 1 minute updates, but so far have not
> been successful. The function I am using is "=RCHGetYahooQuotes(A3,B2:H2)".
> Please let me know how to write this function so that it gets the automatic
> updates if possible?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
5a.

Re: Refresh Button

Posted by: "D" n1144n@comcast.net   n1144n

Tue Sep 13, 2011 4:29 pm (PDT)



Hi Randy,
Follow up question.
I am using the =RCHGetYahooQuotes(Xxx,"Yy") add-in.

It won't update the data every 15 minutes like it should. I have to close and reload the spreadsheet to update. Even an end of day.

Can you help?

thanks, --N

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> No. EXCEL "Refresh all" is an EXCEL process that just applies to EXCEL data
> queries. It will not update add-in functions.
>
> On Fri, Sep 9, 2011 at 11:58 AM, D <n1144n@...> wrote:
>
> >
> > On the EXCEL 2007 Data tab there is an icon named "Refresh All". Does this
> > do the same update as your "refresh button"?
> > thanks, --N
> >
>

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

Re: Refresh Button

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

Tue Sep 13, 2011 4:48 pm (PDT)



It shouldn't update every 15 minutes. Check out the smfForceRecalculation
entries in the "Links" area of the group for ways to refresh the data. But
you need refresh the data manually unless you write your own VBA routine.

On Tue, Sep 13, 2011 at 4:29 PM, D <n1144n@comcast.net> wrote:

>
> Follow up question.
> I am using the =RCHGetYahooQuotes(Xxx,"Yy") add-in.
>
> It won't update the data every 15 minutes like it should. I have to close
> and reload the spreadsheet to update. Even an end of day.
>
> Can you help?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
6a.

Install smf_addin file for Windows 7 and Excel 2007

Posted by: "earlyride" allons5372@yahoo.com   earlyride

Tue Sep 13, 2011 6:02 pm (PDT)



I downloaded the files to C:\Program\smf add-in. I started Excel 2007, went to Option, the Add-in tab. But the add-in file was not listed. Can xla files run under Excel 2007? Or does it need to be an xlam file?

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

Re: Install smf_addin file for Windows 7 and Excel 2007

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

Tue Sep 13, 2011 6:08 pm (PDT)



Read the documentation. I'm not going to repeat it here. Also check the
"Links" area of the group.

On Tue, Sep 13, 2011 at 5:32 PM, earlyride <allons5372@yahoo.com> wrote:

> I downloaded the files to C:\Program\smf add-in. I started Excel 2007, went
> to Option, the Add-in tab. But the add-in file was not listed. Can xla files
> run under Excel 2007? Or does it need to be an xlam file?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

A bad score is 579. A good idea is checking yours at freecreditscore.com.
Diposting oleh EXCEL FEED LEARNING di 03.26

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)