Jumat, 08 Juni 2012

[smf_addin] Digest Number 2239

Messages In This Digest (24 Messages)

Messages

1a.

MorningStar Financial Statements

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

Thu Jun 7, 2012 1:24 am (PDT)



Hello, Randy,

I want to get the financial statements data from MorningStar, use this formula, the result is error:
=RCHGetTableCell("http://financials.morningstar.com/income-statement/is.html?t=MMM",0,"Revenue","fundnum"), and
=RCHGetTableCell("http://financials.morningstar.com/income-statement/is.html?t=MMM",0,"Revenue")is not workable.

Another issue is I want to get the number in thousands, what should I do?

Thanks.

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

Re: MorningStar Financial Statements

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

Thu Jun 7, 2012 1:56 am (PDT)



Sorry, but it's a dynamically generated page, so there's no data in the
source code of the web page to extract.

On Thu, Jun 7, 2012 at 1:24 AM, rebalance85 <rebalance85@yahoo.com> wrote:

>
> I want to get the financial statements data from MorningStar, use this
> formula, the result is error:
> =RCHGetTableCell("
> http://financials.morningstar.com/income-statement/is.html?t=MMM",0,"Revenue","fundnum"),
> and
> =RCHGetTableCell("
> http://financials.morningstar.com/income-statement/is.html?t=MMM",0,"Revenue")is
> not workable.
>
> Another issue is I want to get the number in thousands, what should I do?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

SMF-Template-Yahoo-Analyst-Estimates

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

Thu Jun 7, 2012 3:43 am (PDT)



I having problems getting, SMF-Template-Yahoo-Analyst-Estimates, to work. Any guidance would be appreciated.

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

Re: SMF-Template-Yahoo-Analyst-Estimates

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

Thu Jun 7, 2012 3:46 am (PDT)



You'll have to be more specific about what problems you're having. I just
tried it with ticker symbol MMM and it's working fine here.

On Thu, Jun 7, 2012 at 3:26 AM, andrewhills97 <andrewhills97@yahoo.com>wrote:

> I having problems getting, SMF-Template-Yahoo-Analyst-Estimates, to work.
> Any guidance would be appreciated.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2c.

Re: SMF-Template-Yahoo-Analyst-Estimates

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

Thu Jun 7, 2012 4:10 am (PDT)



I have estabished, c:/Program Files/SMF Add-In/RCH_Stock_Market_Functions.xla

Open MS Excel & in the Add-Ins available box, tick 'Stock Mkt Functions Add-In' then Ok

Nothing refering to this Add In is shown in the Add In tab at the top.

Open SMF_Template_Yahoo_Analyst_Estimates (from different directory)

Type in MMM, and then see 'Undefined' everywhere

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You'll have to be more specific about what problems you're having. I just
> tried it with ticker symbol MMM and it's working fine here.
>
> On Thu, Jun 7, 2012 at 3:26 AM, andrewhills97 <andrewhills97@...>wrote:
>
> > I having problems getting, SMF-Template-Yahoo-Analyst-Estimates, to work.
> > Any guidance would be appreciated.
> >
>

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

Re: SMF-Template-Yahoo-Analyst-Estimates

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

Thu Jun 7, 2012 4:52 am (PDT)



Have now fixed problem. thankyou.
While im here, im trying to update an Excel file with the latest revenue and EPS estimates for all companies in the Russell 2000 index. The SMF_Template-Yahoo-Analyst-Estimates file does this for 1 company. How can i most easily have 1 page per company (ie 500 pages), or maybe create 1 page with all the tickers going down ColumnA and then Revenue and EPS estimates in Columns B to .....
Thanks

--- In smf_addin@yahoogroups.com, "andrewhills97" <andrewhills97@...> wrote:
>
> I have estabished, c:/Program Files/SMF Add-In/RCH_Stock_Market_Functions.xla
>
> Open MS Excel & in the Add-Ins available box, tick 'Stock Mkt Functions Add-In' then Ok
>
> Nothing refering to this Add In is shown in the Add In tab at the top.
>
> Open SMF_Template_Yahoo_Analyst_Estimates (from different directory)
>
> Type in MMM, and then see 'Undefined' everywhere
>
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > You'll have to be more specific about what problems you're having. I just
> > tried it with ticker symbol MMM and it's working fine here.
> >
> > On Thu, Jun 7, 2012 at 3:26 AM, andrewhills97 <andrewhills97@>wrote:
> >
> > > I having problems getting, SMF-Template-Yahoo-Analyst-Estimates, to work.
> > > Any guidance would be appreciated.
> > >
> >
>

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

Re: SMF-Template-Yahoo-Analyst-Estimates

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

Thu Jun 7, 2012 6:18 am (PDT)



Please don't do things like that with the add-in. I don't want people
abusing the free data services by downloading and maintaining databases. In
fact, the add-in has a built-in limitation of allowing only 1000 web pages
to be accessed per "session".

Besides, you can easily get something like that from the Finviz or Zacks
screeners in an single export file, instead of retrieving the data piece by
piece for each ticker symbol.

On Thu, Jun 7, 2012 at 4:52 AM, andrewhills97 <andrewhills97@yahoo.com>wrote:

> While im here, im trying to update an Excel file with the latest revenue
> and EPS estimates for all companies in the Russell 2000 index. The
> SMF_Template-Yahoo-Analyst-Estimates file does this for 1 company. How can
> i most easily have 1 page per company (ie 500 pages), or maybe create 1
> page with all the tickers going down ColumnA and then Revenue and EPS
> estimates in Columns B to .....
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2f.

Re: SMF-Template-Yahoo-Analyst-Estimates

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

Thu Jun 7, 2012 1:04 pm (PDT)




ok, thanks Randy

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Please don't do things like that with the add-in. I don't want people
> abusing the free data services by downloading and maintaining databases. In
> fact, the add-in has a built-in limitation of allowing only 1000 web pages
> to be accessed per "session".
>
> Besides, you can easily get something like that from the Finviz or Zacks
> screeners in an single export file, instead of retrieving the data piece by
> piece for each ticker symbol.
>
> On Thu, Jun 7, 2012 at 4:52 AM, andrewhills97 <andrewhills97@...>wrote:
>
> > While im here, im trying to update an Excel file with the latest revenue
> > and EPS estimates for all companies in the Russell 2000 index. The
> > SMF_Template-Yahoo-Analyst-Estimates file does this for 1 company. How can
> > i most easily have 1 page per company (ie 500 pages), or maybe create 1
> > page with all the tickers going down ColumnA and then Revenue and EPS
> > estimates in Columns B to .....
> >
>

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

Daily and weekly historical prices for a stock

Posted by: "timdbui" timdbui@gmail.com   timdbui

Thu Jun 7, 2012 5:54 am (PDT)



Hi Randy,

I am sure someone had asked this question before, but I could not find the answer for this code:

Could you show me how to get daily and weekly closing prices for a particular stock? I would like to go back really far: say 400 daily prices and 400 weekly prices, using either Yahoo or MSN prices.

Is this possible, Randy? Thanks so much!

Regards,

Tim

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

Re: Daily and weekly historical prices for a stock

Posted by: "timdbui" timdbui@gmail.com   timdbui

Thu Jun 7, 2012 5:56 am (PDT)



By the way, the format I am trying to see is exactly like the picture of MMM daily prices as posted on the front page of this site. Thanks!

--- In smf_addin@yahoogroups.com, "timdbui" <timdbui@...> wrote:
>
> Hi Randy,
>
> I am sure someone had asked this question before, but I could not find the answer for this code:
>
> Could you show me how to get daily and weekly closing prices for a particular stock? I would like to go back really far: say 400 daily prices and 400 weekly prices, using either Yahoo or MSN prices.
>
> Is this possible, Randy? Thanks so much!
>
> Regards,
>
> Tim
>

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

Re: Daily and weekly historical prices for a stock

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

Thu Jun 7, 2012 6:19 am (PDT)



Use the RCHGetYahooHistory() function. It can return either daily or weekly
data, and is how the front page example was created.

On Thu, Jun 7, 2012 at 5:54 AM, timdbui <timdbui@gmail.com> wrote:

>
> I am sure someone had asked this question before, but I could not find the
> answer for this code:
>
> Could you show me how to get daily and weekly closing prices for a
> particular stock? I would like to go back really far: say 400 daily prices
> and 400 weekly prices, using either Yahoo or MSN prices.
>
> Is this possible, Randy? Thanks so much!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
3d.

Re: Daily and weekly historical prices for a stock

Posted by: "timdbui" timdbui@gmail.com   timdbui

Thu Jun 7, 2012 6:25 am (PDT)



Thanks, Randy! Let me try that. Regards,

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Use the RCHGetYahooHistory() function. It can return either daily or weekly
> data, and is how the front page example was created.
>
> On Thu, Jun 7, 2012 at 5:54 AM, timdbui <timdbui@...> wrote:
>
> >
> > I am sure someone had asked this question before, but I could not find the
> > answer for this code:
> >
> > Could you show me how to get daily and weekly closing prices for a
> > particular stock? I would like to go back really far: say 400 daily prices
> > and 400 weekly prices, using either Yahoo or MSN prices.
> >
> > Is this possible, Randy? Thanks so much!
> >
>

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

Re: Daily and weekly historical prices for a stock

Posted by: "timdbui" timdbui@gmail.com   timdbui

Thu Jun 7, 2012 7:07 am (PDT)



Hi Randy,

Is there a way for me to get prices, say from latest close and go back -200 days, without specifying the dates?

Thanks!

Tim

--- In smf_addin@yahoogroups.com, "timdbui" <timdbui@...> wrote:
>
> Thanks, Randy! Let me try that. Regards,
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Use the RCHGetYahooHistory() function. It can return either daily or weekly
> > data, and is how the front page example was created.
> >
> > On Thu, Jun 7, 2012 at 5:54 AM, timdbui <timdbui@> wrote:
> >
> > >
> > > I am sure someone had asked this question before, but I could not find the
> > > answer for this code:
> > >
> > > Could you show me how to get daily and weekly closing prices for a
> > > particular stock? I would like to go back really far: say 400 daily prices
> > > and 400 weekly prices, using either Yahoo or MSN prices.
> > >
> > > Is this possible, Randy? Thanks so much!
> > >
> >
>

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

Re: Daily and weekly historical prices for a stock

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

Thu Jun 7, 2012 8:53 am (PDT)



Just array-enter the RCHGetYahooHistory() function over 200 rows.

When you don't specify dates, it always assumes the ending date is the last
date available, and backfills the available range from there.

I almost never use dates with the RCHGetYahooHistory() function. Typically,
if I want closing prices for one or more given dates, I end up using the
smfPricesByDates() function. Even to the point I will use it for weekly and
monthly prices, instead of RCHGetYahooHistory(), because *I* can determine
when the weeks and months start/end, instead of them being the calendar
week/month default that Yahoo uses.

On Thu, Jun 7, 2012 at 7:07 AM, timdbui <timdbui@gmail.com> wrote:

>
> Is there a way for me to get prices, say from latest close and go back
> -200 days, without specifying the dates?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
3g.

Re: Daily and weekly historical prices for a stock

Posted by: "timdbui" timdbui@gmail.com   timdbui

Thu Jun 7, 2012 10:39 am (PDT)



Hi Randy,

Sorry for my lack of knowledge, but when I do the code RCHYahooHistory($C$1) and array down, I get the dates and the OPEN daily prices. Would you show me how to get Daily Close, and Weekly close?

Thanks!

Tim

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just array-enter the RCHGetYahooHistory() function over 200 rows.
>
> When you don't specify dates, it always assumes the ending date is the last
> date available, and backfills the available range from there.
>
> I almost never use dates with the RCHGetYahooHistory() function. Typically,
> if I want closing prices for one or more given dates, I end up using the
> smfPricesByDates() function. Even to the point I will use it for weekly and
> monthly prices, instead of RCHGetYahooHistory(), because *I* can determine
> when the weeks and months start/end, instead of them being the calendar
> week/month default that Yahoo uses.
>
> On Thu, Jun 7, 2012 at 7:07 AM, timdbui <timdbui@...> wrote:
>
> >
> > Is there a way for me to get prices, say from latest close and go back
> > -200 days, without specifying the dates?
> >
>

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

Re: Daily and weekly historical prices for a stock

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

Thu Jun 7, 2012 12:26 pm (PDT)



Dates and adjusted closing prices on daily data:

=RCHGetYahooHistory("MMM",,,,,,,"d","DA")

Dates and adjusted closing prices on weekly data:

=RCHGetYahooHistory("MMM",,,,,,,"w","DA")

On Thu, Jun 7, 2012 at 10:33 AM, timdbui <timdbui@gmail.com> wrote:

>
> Sorry for my lack of knowledge, but when I do the code
> RCHYahooHistory($C$1) and array down, I get the dates and the OPEN daily
> prices. Would you show me how to get Daily Close, and Weekly close?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
3i.

Re: Daily and weekly historical prices for a stock

Posted by: "timdbui" timdbui@gmail.com   timdbui

Thu Jun 7, 2012 2:24 pm (PDT)



It works! Thanks so much, Randy!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Dates and adjusted closing prices on daily data:
>
> =RCHGetYahooHistory("MMM",,,,,,,"d","DA")
>
> Dates and adjusted closing prices on weekly data:
>
> =RCHGetYahooHistory("MMM",,,,,,,"w","DA")
>
> On Thu, Jun 7, 2012 at 10:33 AM, timdbui <timdbui@...> wrote:
>
> >
> > Sorry for my lack of knowledge, but when I do the code
> > RCHYahooHistory($C$1) and array down, I get the dates and the OPEN daily
> > prices. Would you show me how to get Daily Close, and Weekly close?
> >
>

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

Historical Prices

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

Thu Jun 7, 2012 6:56 am (PDT)



How can I access a stock's price as of a given date.

Actually, I want a couple of columns in my excel worksheet that gives the performance over the last 30 days, the last 60 days, ....etc.

Can you help me with this. Thanks, David

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

Re: Historical Prices

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

Thu Jun 7, 2012 8:50 am (PDT)



I typically use the smfPricesByDates() function for that type of thing.

On Thu, Jun 7, 2012 at 6:56 AM, ufdn16 <ufdn16@yahoo.com> wrote:

> How can I access a stock's price as of a given date.
>
> Actually, I want a couple of columns in my excel worksheet that gives the
> performance over the last 30 days, the last 60 days, ....etc.
>
> Can you help me with this. Thanks, David
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5a.

Historical Price Data

Posted by: "SCHRES" schres@cox.net   SCHRES

Thu Jun 7, 2012 12:23 pm (PDT)



Randy

I have two questions.

First is there a way to alter the smfPricesByDates() function so that you can obtain the open price or the volume for a given date.

Second where does the information come from for the smf earnings.com template that returns 23 weeks of earnings data.

Thanks for all your work on the various templates. I have an old version of excel and not all of them work, but the ones that do will save hours of work

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

Re: Historical Price Data

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

Thu Jun 7, 2012 12:37 pm (PDT)



You would need to alter the actual VBA code to get open prices or volumes
by date from smfPricesByDates(). However, you can get O/H/L/C/V for any
given date by specifying the date with RCHGetYahooHistory().

Earnings.com *is* the source of the data:

http://www.earnings.com/company.asp?client=cb&ticker=MMM

In most cases, you can find the URL from which an element is extracted with:

=RCHGetElementNumber("P-URL",1354)

...which returns:

http://www.earnings.com/company.asp?client=cb&ticker=~~~~~

Just substitute a ticker symbol for the "~~~~~".

On Thu, Jun 7, 2012 at 11:23 AM, SCHRES <schres@cox.net> wrote:

>
> I have two questions.
>
> First is there a way to alter the smfPricesByDates() function so that you
> can obtain the open price or the volume for a given date.
>
> Second where does the information come from for the smf earnings.comtemplate that returns 23 weeks of earnings data.
>
> Thanks for all your work on the various templates. I have an old version
> of excel and not all of them work, but the ones that do will save hours of
> work
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
5c.

Re: Historical Price Data

Posted by: "SCHRES" schres@cox.net   SCHRES

Thu Jun 7, 2012 10:11 pm (PDT)



Thanks
Took me a little while to get the syntax right but I can now get the additional individual quotes by date.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You would need to alter the actual VBA code to get open prices or volumes
> by date from smfPricesByDates(). However, you can get O/H/L/C/V for any
> given date by specifying the date with RCHGetYahooHistory().
>
> Earnings.com *is* the source of the data:
>
> http://www.earnings.com/company.asp?client=cb&ticker=MMM
>
> In most cases, you can find the URL from which an element is extracted with:
>
> =RCHGetElementNumber("P-URL",1354)
>
> ...which returns:
>
> http://www.earnings.com/company.asp?client=cb&ticker=~~~~~
>
> Just substitute a ticker symbol for the "~~~~~".
>
> On Thu, Jun 7, 2012 at 11:23 AM, SCHRES <schres@...> wrote:
>
> >
> > I have two questions.
> >
> > First is there a way to alter the smfPricesByDates() function so that you
> > can obtain the open price or the volume for a given date.
> >
> > Second where does the information come from for the smf earnings.comtemplate that returns 23 weeks of earnings data.
> >
> > Thanks for all your work on the various templates. I have an old version
> > of excel and not all of them work, but the ones that do will save hours of
> > work
> >
>

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

Market Cap function does not function

Posted by: "Peter" peter.teichert@gmail.com   peter_teichert

Thu Jun 7, 2012 1:55 pm (PDT)



Hello SMF ADDIN Users
I am new to this excel addin and I am trying to get the Market Cap data from YAHOO key Statistics.
This does not work; I am using the same formula as in the pdf description.

What I am doing wrong ?

Thanks for reply

Best regards

Peter

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

Re: Market Cap function does not function

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

Thu Jun 7, 2012 2:03 pm (PDT)



Both of these examples in the documentation:

=RCHGetElementNumber("IBM", 941)
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM",1,"Market Cap
(intraday)")

...worked fine for me. Without more details about what you are doing, I
have no idea what you are doing wrong.

On Thu, Jun 7, 2012 at 12:51 PM, Peter <peter.teichert@gmail.com> wrote:

>
> I am new to this excel addin and I am trying to get the Market Cap data
> from YAHOO key Statistics.
> This does not work; I am using the same formula as in the pdf description.
>
> What I am doing wrong ?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

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.21

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)