Selasa, 13 Maret 2012

[smf_addin] Digest Number 2145[1 Attachment]

Messages In This Digest (8 Messages)

Messages

1a.

Re: Distribution from MorningStar

Posted by: "ashok" appusingh@yahoo.com   appusingh

Mon Mar 12, 2012 11:15 am (PDT)





Amazing !
Now , i want to substitute the ticker with the value of a cell how do I do that -
I tried replacing with &A1 or $A1 --did not work .

Thanks !

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Something like these should work:
>
> =0+smfStrExtr(RCHGetWebData("http://quote.morningstar.com/stock/s.aspx?t=epd
> ","ProjectedYield:",5000,10),"ProjectedYield:""","""")
>
> =RCHGetTableCell("http://cef.morningstar.com/quote?t=bbn",6,"Total Dist.
> Rate",,,,1)
>
> On Sat, Mar 10, 2012 at 6:12 AM, ashok <appusingh@...> wrote:
>
> >
> > As you can say I am new so please help me -
> > I have done my basic first sheet using GetYahooQuotes.
> > Works fine -- now I wish to collect the Proj Yield for say "EPD"
> > Next , I want collect Total Dist Rate if it is an CEF ( say "BBN")
> >
>

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

Re: Distribution from MorningStar

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Mon Mar 12, 2012 1:46 pm (PDT)



try this

=0+smfStrExtr(RCHGetWebData("http://quote.morningstar.com/stock/s.aspx?t="&A1,"ProjectedYield:",5000,10),"ProjectedYield:""","""")

with epd in cell A1

Marty

________________________________
From: ashok <appusingh@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Monday, March 12, 2012 2:15 PM
Subject: [smf_addin] Re: Distribution from MorningStar


 

Amazing !
Now , i want to substitute the ticker with the value of a cell how do I do that -
I tried replacing with &A1 or $A1 --did not work .

Thanks !

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Something like these should work:
>
> =0+smfStrExtr(RCHGetWebData("http://quote.morningstar.com/stock/s.aspx?t=epd
> ","ProjectedYield:",5000,10),"ProjectedYield:""","""")
>
> =RCHGetTableCell("http://cef.morningstar.com/quote?t=bbn",6,"Total Dist.
> Rate",,,,1)
>
> On Sat, Mar 10, 2012 at 6:12 AM, ashok <appusingh@...> wrote:
>
> >
> > As you can say I am new so please help me -
> > I have done my basic first sheet using GetYahooQuotes.
> > Works fine -- now I wish to collect the Proj Yield for say "EPD"
> > Next , I want collect Total Dist Rate if it is an CEF ( say "BBN")
> >
>

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

Re: Distribution from MorningStar

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Mon Mar 12, 2012 1:52 pm (PDT)



and this one with bbn in A3

=RCHGetTableCell("http://cef.morningstar.com/quote?t="&A3,6,"Total Dist. Rate",,,,1)

Marty

the solution is to concatenate the string with the url and the cell containing the ticker into one long string (see bold above)

________________________________
From: ashok <appusingh@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Monday, March 12, 2012 2:15 PM
Subject: [smf_addin] Re: Distribution from MorningStar


 

Amazing !
Now , i want to substitute the ticker with the value of a cell how do I do that -
I tried replacing with &A1 or $A1 --did not work .

Thanks !

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Something like these should work:
>
> =0+smfStrExtr(RCHGetWebData("http://quote.morningstar.com/stock/s.aspx?t=epd
> ","ProjectedYield:",5000,10),"ProjectedYield:""","""")
>
> =RCHGetTableCell("http://cef.morningstar.com/quote?t=bbn",6,"Total Dist.
> Rate",,,,1)
>
> On Sat, Mar 10, 2012 at 6:12 AM, ashok <appusingh@...> wrote:
>
> >
> > As you can say I am new so please help me -
> > I have done my basic first sheet using GetYahooQuotes.
> > Works fine -- now I wish to collect the Proj Yield for say "EPD"
> > Next , I want collect Total Dist Rate if it is an CEF ( say "BBN")
> >
>

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

Re: Distribution from MorningStar

Posted by: "ashok" appusingh@yahoo.com   appusingh

Mon Mar 12, 2012 7:21 pm (PDT)





PERFECT !

THANKS !

--- In smf_addin@yahoogroups.com, Martin Topper <mtopper@...> wrote:
>
> and this one with bbn in A3
>
> =RCHGetTableCell("http://cef.morningstar.com/quote?t="&A3,6,"Total Dist. Rate",,,,1)
>
> Marty
>
>
> the solution is to concatenate the string with the url and the cell containing the ticker into one long string (see bold above)
>
>
>
> ________________________________
> From: ashok <appusingh@...>
> To: smf_addin@yahoogroups.com
> Sent: Monday, March 12, 2012 2:15 PM
> Subject: [smf_addin] Re: Distribution from MorningStar
>
>
>  
>
>
> Amazing !
> Now , i want to substitute the ticker with the value of a cell how do I do that -
> I tried replacing with &A1 or $A1 --did not work .
>
> Thanks !
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Something like these should work:
> >
> > =0+smfStrExtr(RCHGetWebData("http://quote.morningstar.com/stock/s.aspx?t=epd
> > ","ProjectedYield:",5000,10),"ProjectedYield:""","""")
> >
> > =RCHGetTableCell("http://cef.morningstar.com/quote?t=bbn",6,"Total Dist.
> > Rate",,,,1)
> >
> > On Sat, Mar 10, 2012 at 6:12 AM, ashok <appusingh@> wrote:
> >
> > >
> > > As you can say I am new so please help me -
> > > I have done my basic first sheet using GetYahooQuotes.
> > > Works fine -- now I wish to collect the Proj Yield for say "EPD"
> > > Next , I want collect Total Dist Rate if it is an CEF ( say "BBN")
> > >
> >
>

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

Re: getting data from IBD stock checkup page

Posted by: "mff2805" mff3429@comcast.net   mff2805

Mon Mar 12, 2012 12:05 pm (PDT)



thanks for the template. i've incorporated it into my main stock info page. i would have an interest in getting a list of the top 5 stocks based on composite rating into individual cells. i've browsed the page source and dinked around with the GetTagContent and GetHTMLTable functions but to no avail - i'm not sure what to look for.
is there a way to add that info into the template file?
thanks.
- mike

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I threw together a template, because I had an idea of how I might be able
> to drive data retrieval using just the ticker symbol, creating the
> necessary URL with exchange and company name:
>
> RCHGetTableCell-Template-IBD-Stock-Checkup.xls
>
> On Fri, Mar 9, 2012 at 3:27 AM, mff2805 <mff3429@...> wrote:
>
> >
> > got a sample spreadsheet for ibd data?
> >
>

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

Re: getting data from IBD stock checkup page

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

Mon Mar 12, 2012 3:08 pm (PDT)



I uploaded a new copy of the workbook, with the group leaders added for
each rating category. I also added the "percentage" value of the requested
stock for each rating category.

On Mon, Mar 12, 2012 at 12:05 PM, mff2805 <mff3429@comcast.net> wrote:

> thanks for the template. i've incorporated it into my main stock info
> page. i would have an interest in getting a list of the top 5 stocks based
> on composite rating into individual cells. i've browsed the page source
> and dinked around with the GetTagContent and GetHTMLTable functions but to
> no avail - i'm not sure what to look for.
> is there a way to add that info into the template file?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2c.

Re: getting data from IBD stock checkup page

Posted by: "Mike Fitzpatrick" mff3429@comcast.net   mff2805

Mon Mar 12, 2012 11:28 pm (PDT)

[Attachment(s) from Mike Fitzpatrick included below]

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

Attachment(s) from Mike Fitzpatrick

1 of 1 File(s)

IBD Sector & Subgroup Rankings.pdf
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2d.

Re: getting data from IBD stock checkup page [1 Attachment]

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

Mon Mar 12, 2012 11:53 pm (PDT)



Ummm -- just be sure not to violate the TOS. They only allow you to get 300
IBD Checkups within a 24-hour period.

No idea how much time I put into it. It's not been a burden. Usually. :)

I'm disabled and spend most my time on the computer or watching TV/movies,
or reading eBooks on my Kindle, so it provides a welcome distraction from
the other activities. And I use it regularly myself, mostly researching
ideas that don't pan out. :(

On Mon, Mar 12, 2012 at 11:28 PM, Mike Fitzpatrick <mff3429@comcast.net>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 (9)
Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Odd News

You won't believe

it, but it's true

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
Diposting oleh EXCEL FEED LEARNING di 02.06

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)