Sabtu, 02 Juni 2012

[smf_addin] Digest Number 2233

Messages In This Digest (11 Messages)

Messages

1a.

Re: Error in Formula

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Fri Jun 1, 2012 6:43 am (PDT)



It also worked for me. After changing the link to the SMF addin location.

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, May 31, 2012 7:36 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Error in Formula


Lines 49-86 worked fine here, except for those with bad ticker symbols.
On Thu, May 31, 2012 at 4:22 PM, Christina Guo <cguo563@yahoo.com> wrote:

Darn, I thought everything was running smoothly. But here's my spreadsheet once more. Do you know why the formula stopped working for the chunk of data from line 49-86?

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

Re: Error in Formula

Posted by: "Christina Guo" cguo563@yahoo.com   cguo563

Fri Jun 1, 2012 9:58 am (PDT)



I restarted my computer and loaded it again. Perfect. Thanks so much.

________________________________
From: Kermit W. Prather <kermitp@tampabay.rr.com>
To: smf_addin@yahoogroups.com
Sent: Friday, June 1, 2012 6:43 AM
Subject: RE: [smf_addin] Error in Formula


 

It also worked for me. After changing the link to the SMF addin location.
 
Kermit
 
From:smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, May 31, 2012 7:36 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Error in Formula
 

Lines 49-86 worked fine here, except for those with bad ticker symbols.
On Thu, May 31, 2012 at 4:22 PM, Christina Guo <cguo563@yahoo.com> wrote:
 
Darn, I thought everything was running smoothly. But here's my spreadsheet once more. Do you know why the formula stopped working for the chunk of data from line 49-86?

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

MSN Financial Statements

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

Fri Jun 1, 2012 9:50 pm (PDT)



Hello, Randy!

I downloaded "RCHGetTableCell-Template-MSN-Financial-Statements", and find some cell value is #value!, but I couldn't find the problem.
Period End Date =DATEVALUE(RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement?stmtView=Ann&Symbol="&Ticker, 1,"Period End Date"))

Where is the problem? Could you please give me some instructions?

Thank you very much!

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

Re: MSN Financial Statements

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

Fri Jun 1, 2012 10:05 pm (PDT)



That formula works fine for me for ticker symbol MMM.

On Fri, Jun 1, 2012 at 9:50 PM, rebalance85 <rebalance85@yahoo.com> wrote:

>
> I downloaded "RCHGetTableCell-Template-MSN-Financial-Statements", and find
> some cell value is #value!, but I couldn't find the problem.
> Period End Date =DATEVALUE(RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement?stmtView=Ann&Symbol="&Ticker,
> 1,"Period End Date"))
>
> Where is the problem? Could you please give me some instructions?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2c.

Re: MSN Financial Statements

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

Fri Jun 1, 2012 10:15 pm (PDT)



Mine is not working, #value!. Is there any other formula to replace this one?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That formula works fine for me for ticker symbol MMM.
>
> On Fri, Jun 1, 2012 at 9:50 PM, rebalance85 <rebalance85@...> wrote:
>
> >
> > I downloaded "RCHGetTableCell-Template-MSN-Financial-Statements", and find
> > some cell value is #value!, but I couldn't find the problem.
> > Period End Date =DATEVALUE(RCHGetTableCell("
> > http://investing.money.msn.com/investments/stock-income-statement?stmtView=Ann&Symbol="&Ticker,
> > 1,"Period End Date"))
> >
> > Where is the problem? Could you please give me some instructions?
> >
>

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

Re: MSN Financial Statements

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

Fri Jun 1, 2012 10:28 pm (PDT)



I try =DATEVALUE(12/31/2011), it seems that the excel couldn't reconige the 12/31/2011.

--- In smf_addin@yahoogroups.com, "rebalance85" <rebalance85@...> wrote:
>
> Mine is not working, #value!. Is there any other formula to replace this one?
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > That formula works fine for me for ticker symbol MMM.
> >
> > On Fri, Jun 1, 2012 at 9:50 PM, rebalance85 <rebalance85@> wrote:
> >
> > >
> > > I downloaded "RCHGetTableCell-Template-MSN-Financial-Statements", and find
> > > some cell value is #value!, but I couldn't find the problem.
> > > Period End Date =DATEVALUE(RCHGetTableCell("
> > > http://investing.money.msn.com/investments/stock-income-statement?stmtView=Ann&Symbol="&Ticker,
> > > 1,"Period End Date"))
> > >
> > > Where is the problem? Could you please give me some instructions?
> > >
> >
>

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

Re: MSN Financial Statements

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

Fri Jun 1, 2012 11:19 pm (PDT)



You must not be using U.S. Regional settings. Just take off the
DATEVALUE() function and leave the date as a string literal.

On Fri, Jun 1, 2012 at 10:28 PM, rebalance85 <rebalance85@yahoo.com> wrote:

> I try =DATEVALUE(12/31/2011), it seems that the excel couldn't reconige
> the 12/31/2011.
>
> --- In smf_addin@yahoogroups.com, "rebalance85" <rebalance85@...> wrote:
> >
> > Mine is not working, #value!. Is there any other formula to replace this
> one?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3a.

Randy, Turley M Muller, Pls see this message, thank you!!

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

Fri Jun 1, 2012 10:05 pm (PDT)



Hi!
I just download "Cash_Flow Model_v17" written by Turley M Muller. And you see the link of MSN Finance has been changed, I corrected most of them, but I couldn't find the "per share item" in "financial import" page.

Could you give me some instructions? =RCHGetTablecell("http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker, 6,"per share items",,,1)
How to correct the above formula?

And Turley M Muller, thank you very much for your great product, do you have the update one? The verson you uploaded has some problems of the data source, if you have the new verson,hope you can send me one copy.

Thank you very much!

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

Re: Randy, Turley M Muller, Pls see this message, thank you!!

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

Fri Jun 1, 2012 11:18 pm (PDT)



That's the same reason I had to redefine so many elements. MSN has revamped
their website structure. So you would need to remap all of the URL
references in the workbook.

On Fri, Jun 1, 2012 at 10:05 PM, rebalance85 <rebalance85@yahoo.com> wrote:

>
> I just download "Cash_Flow Model_v17" written by Turley M Muller. And you
> see the link of MSN Finance has been changed, I corrected most of them, but
> I couldn't find the "per share item" in "financial import" page.
>
> Could you give me some instructions? =RCHGetTablecell("
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker,
> 6,"per share items",,,1)
> How to correct the above formula?
>
> And Turley M Muller, thank you very much for your great product, do you
> have the update one? The verson you uploaded has some problems of the data
> source, if you have the new verson,hope you can send me one copy.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.

Re: Randy, Turley M Muller, Pls see this message, thank you!!

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

Sat Jun 2, 2012 12:50 am (PDT)



Thanks Randy.
You see from the formula, it will get the " per share items" in the annual incom statement, but I couldn't find this item in that page. That's my problem, do you know what is the item so I can make the correction.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That's the same reason I had to redefine so many elements. MSN has revamped
> their website structure. So you would need to remap all of the URL
> references in the workbook.
>
> On Fri, Jun 1, 2012 at 10:05 PM, rebalance85 <rebalance85@...> wrote:
>
> >
> > I just download "Cash_Flow Model_v17" written by Turley M Muller. And you
> > see the link of MSN Finance has been changed, I corrected most of them, but
> > I couldn't find the "per share item" in "financial import" page.
> >
> > Could you give me some instructions? =RCHGetTablecell("
> > http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker,
> > 6,"per share items",,,1)
> > How to correct the above formula?
> >
> > And Turley M Muller, thank you very much for your great product, do you
> > have the update one? The verson you uploaded has some problems of the data
> > source, if you have the new verson,hope you can send me one copy.
> >
>

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

Re: Randy, Turley M Muller, Pls see this message, thank you!!

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

Sat Jun 2, 2012 1:08 am (PDT)



Not precisely sure what it's picking up -- try:

=RCHGetTableCell("
http://investing.money.msn.com/investments/stock-income-statement/?symbol=MMM",-1,"Period
End Date",,,,-2)

...varying the -1 from -1 to -5.

On Sat, Jun 2, 2012 at 12:50 AM, rebalance85 <rebalance85@yahoo.com> wrote:

>
> You see from the formula, it will get the " per share items" in the annual
> incom statement, but I couldn't find this item in that page. That's my
> problem, do you know what is the item so I can make the correction.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)