Minggu, 18 September 2011

[smf_addin] Digest Number 1958

Messages In This Digest (9 Messages)

Messages

1a.

Re: wikiposit.org, great source to use the plug-in

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

Sat Sep 17, 2011 12:05 pm (PDT)



What's useful to me is it ability to read Excel and zip links and put them in a standard html format which your plug-in can communicate with.

A lot of economic data (that are not available on Fred) are in Excel files on the web. And this website becomes my solution when using your plug-in.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It appears to get its historical stock quotes data from Yahoo...
>
> If it's just someone collecting data from different sources, there's no
> guarantee they'll keep the data up-to-date. And if they are getting their
> data from other sources, I might wonder about its continued availability.
>
> You'd be better off getting the data from the original source.
>
> On Fri, Sep 16, 2011 at 8:21 PM, gz_cp <gz_cp@...> wrote:
>
> > I am able to use the plug-in to create and download so many economic data
> > there.
> >
> > Stocks and futures data too.
> >
> > rharmelink you might want to consider making an efficient function for that
> > because I think it will become a popular data source very soon.
> >
>

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

Sortino Ratio from Morningstar.com

Posted by: "Joel" joel.andrews@lpl.com   joelfp2000

Sat Sep 17, 2011 1:45 pm (PDT)



Randy,

I was wondering if you would please add an element number for the "sortino ratio?" This ratio can be found on the Morningstar.com website under the ratings and risk tab. You already capture the sharpe ratio (element 4673), the standard deviation (element 4671), amoung others.

Thank you so much for all of your time and effort in making this excel add-in a great "free" tool. Your incrediable work has saved me so much time!

Joel

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

Re: Sortino Ratio from Morningstar.com

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

Sat Sep 17, 2011 3:29 pm (PDT)



Sorry, but the Sortino ratio is on the dynamically generated web page, where
the add-in can't access it. The other risk measures you mention come from
the "Print Report" page, which doesn't contain the Sortino ratio:

http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=VFINX

On Sat, Sep 17, 2011 at 1:45 PM, Joel <joel.andrews@lpl.com> wrote:

>
> I was wondering if you would please add an element number for the "sortino
> ratio?" This ratio can be found on the Morningstar.com website under the
> ratings and risk tab. You already capture the sharpe ratio (element 4673),
> the standard deviation (element 4671), amoung others.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3.1.

question for Randy Re: RCHGetElementNumber

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

Sat Sep 17, 2011 2:37 pm (PDT)



Hello Randy..

How would I change the formula you suggest below to pick up
MSN's Fundamental, Ownership, Valuation, and Technical Grades which
are on the same webpage..for example, at:

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

thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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 (37)
3.2.

Re: question for Randy Re: RCHGetElementNumber

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

Sat Sep 17, 2011 3:04 pm (PDT)



Try:

=SUBSTITUTE(smfGetTagContent("
http://investing.money.msn.com/investments/stock-ratings?symbol=sdrl","div",-1,"Grade:"),"Grade:
","")
=SUBSTITUTE(smfGetTagContent("
http://investing.money.msn.com/investments/stock-ratings?symbol=sdrl","div",-1,"Grade:","Grade:"),"Grade:
","")
=SUBSTITUTE(smfGetTagContent("
http://investing.money.msn.com/investments/stock-ratings?symbol=sdrl","div",-1,"Grade:","Grade:","Grade:"),"Grade:
","")
=SUBSTITUTE(smfGetTagContent("
http://investing.money.msn.com/investments/stock-ratings?symbol=sdrl","div",-1,"Grade:","Grade:","Grade:","Grade:"),"Grade:
","")

On Sat, Sep 17, 2011 at 2:37 PM, investor952 <investor952@yahoo.com> wrote:

>
> How would I change the formula you suggest below to pick up
> MSN's Fundamental, Ownership, Valuation, and Technical Grades which
> are on the same webpage..for example, at:
>
> http://investing.money.msn.com/investments/stock-ratings?symbol=sdrl&
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (37)
4a.

Why RCHGetTableCell returning error?

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

Sat Sep 17, 2011 8:44 pm (PDT)



Hi rharmelink,

Would you mind taking a quick look at why RCHGetTableCell(A1,1,"12-Aug-2010") returns Error?

A1 is "http://wikiposit.org/w.pl?action=dl&dltypes=html%20table&sp=daily&uid=STOCKINDEX.SPX&sd=2010-05-15"

Shouldn't this table be pretty straight forward and should return the price 1083.61?

Thanks.

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

Re: Why RCHGetTableCell returning error?

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

Sat Sep 17, 2011 8:49 pm (PDT)



After cutting and pasting the forumla a few times it returns the number.
Do you know why? How to prevent it from returning Error again?(Error even when RCHGetWebData returns the html codes)

Thanks.

--- In smf_addin@yahoogroups.com, "gz_cp" <gz_cp@...> wrote:
>
> Hi rharmelink,
>
> Would you mind taking a quick look at why RCHGetTableCell(A1,1,"12-Aug-2010") returns Error?
>
> A1 is "http://wikiposit.org/w.pl?action=dl&dltypes=html%20table&sp=daily&uid=STOCKINDEX.SPX&sd=2010-05-15"
>
> Shouldn't this table be pretty straight forward and should return the price 1083.61?
>
> Thanks.
>

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

Re: Why RCHGetTableCell returning error?

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

Sat Sep 17, 2011 9:30 pm (PDT)



I get the 1083.61 returned...

On Sat, Sep 17, 2011 at 8:44 PM, gz_cp <gz_cp@yahoo.com> wrote:

>
> Would you mind taking a quick look at why
> RCHGetTableCell(A1,1,"12-Aug-2010") returns Error?
>
> A1 is "
> http://wikiposit.org/w.pl?action=dl&dltypes=html%20table&sp=daily&uid=STOCKINDEX.SPX&sd=2010-05-15
> "
>
> Shouldn't this table be pretty straight forward and should return the price
> 1083.61?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4d.

Re: Why RCHGetTableCell returning error?

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

Sat Sep 17, 2011 9:34 pm (PDT)



If RCHGetWebData() is returning "Error", it typically means it couldn't get
the source code of the web page. That is, the XMLHTTP protocol errored out
trying to get the web page.

And, actually, cutting and pasting the formula a few times should NOT make a
difference. Once XMLHTTP has been used on a given URL, the add-in saves the
result from that invocation, and does all further extractions from that
saved copy. So you should never see a change. Now, if you were doing
smfForceRecalculation and purging the saved copy of the web page, then that
might happen.

On Sat, Sep 17, 2011 at 8:49 PM, gz_cp <gz_cp@yahoo.com> wrote:

> After cutting and pasting the forumla a few times it returns the number.
> Do you know why? How to prevent it from returning Error again?(Error even
> when RCHGetWebData returns the html codes)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

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
A bad score is 596. A good idea is checking yours at freecreditscore.com.

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

Diposting oleh EXCEL FEED LEARNING di 03.22

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)