Sabtu, 21 Januari 2012

[smf_addin] Digest Number 2084

Messages In This Digest (13 Messages)

Messages

1a.

MoneyCentral MSN Issue

Posted by: "jrgeico" rerren.jeroen@gmail.com   jrgeico

Fri Jan 20, 2012 5:34 am (PST)



Hye everyone!

I used functions such as:

=RCHGetTablecell("http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker, 3,"Unusual Expense (Income)")

to get my BS, IS and CF items (on which all ratios and other are calculated) but when I opened my spreadsheet a few minutes ago I noticed that it does not retrieve the data from this source any longer?

Anyone who knows what causes this?

The BS items still work and a few items on the CF statement work, the IS does not retrieve any numeric value at all...

If I did not provide sufficient information, do ask!

Thanks!

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

Re: MoneyCentral MSN Issue

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Fri Jan 20, 2012 5:44 am (PST)



when I typed the url address you provided below the moneycentral website
redirected me to a different page - one that contained the balance sheet.

On that page I clicked on the "Income Statement" in the left menu and the
url address became:
http://investing.money.msn.com/investments/stock-income-statement/?symbol=IB
M

(for IBM - substitute your ticker as you've done in your formula)

So, it appears money has changed their web page names and you need to update
your formulas with the new addresses.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of jrgeico
Sent: Friday, January 20, 2012 8:35 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] MoneyCentral MSN Issue

Hye everyone!

I used functions such as:

=RCHGetTablecell("http://moneycentral.msn.com/investor/invsub/results/statem
nt.aspx?lstStatement=Income
<http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatem
ent=Income&stmtView=Ann&Symbol=> &stmtView=Ann&Symbol="&Ticker, 3,"Unusual
Expense (Income)")

to get my BS, IS and CF items (on which all ratios and other are calculated)
but when I opened my spreadsheet a few minutes ago I noticed that it does
not retrieve the data from this source any longer?

Anyone who knows what causes this?

The BS items still work and a few items on the CF statement work, the IS
does not retrieve any numeric value at all...

If I did not provide sufficient information, do ask!

Thanks!

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

Re: MoneyCentral MSN Issue

Posted by: "Steven Sun" ssun24cd@gmail.com   ssun_tdam

Fri Jan 20, 2012 5:49 am (PST)



That's likely the website issue as I have same problem. It may implement
time-out option for updating financial data. Let's wait and see what
happens after a couple of hours.

Stevo

On Fri, Jan 20, 2012 at 8:34 AM, jrgeico <rerren.jeroen@gmail.com> wrote:

> **
>
>
> Hye everyone!
>
> I used functions such as:
>
> =RCHGetTablecell("
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker,
> 3,"Unusual Expense (Income)")
>
> to get my BS, IS and CF items (on which all ratios and other are
> calculated) but when I opened my spreadsheet a few minutes ago I noticed
> that it does not retrieve the data from this source any longer?
>
> Anyone who knows what causes this?
>
> The BS items still work and a few items on the CF statement work, the IS
> does not retrieve any numeric value at all...
>
> If I did not provide sufficient information, do ask!
>
> Thanks!
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
1d.

Re: MoneyCentral MSN Issue

Posted by: "jrgeico" rerren.jeroen@gmail.com   jrgeico

Fri Jan 20, 2012 7:57 am (PST)



It is in fact caused by changed URLS by MSN:

You have to find and replace your BS items URLS with the new ones (such as:

http://investing.money.msn.com/investments/stock-balance-sheet/?stmtView=Qtr&symbol=

etc etc)

If you have any questions do ask!

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

Re: MoneyCentral MSN - try FINVIZ.com

Posted by: "Murray Lindhout" murray.lindhout@yahoo.com   murraylindhout

Fri Jan 20, 2012 8:03 am (PST)



I used to use MoneyCentral....  but now my financial homepage is www.finviz.com
 
It's the best and most complete source of financial information I have every found... and it's FREE!
 
Murray

From: Mike McQuaid <mikemcq802@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Friday, January 20, 2012 8:44 AM
Subject: RE: [smf_addin] MoneyCentral MSN Issue

 
when I typed the url address you provided below the moneycentral website redirected me to a different page - one that contained the balance sheet.
 
On that page I clicked on the "Income Statement" in the left menu and the url address became:
http://investing.money.msn.com/investments/stock-income-statement/?symbol=IBM
 
(for IBM - substitute your ticker as you've done in your formula)
 
So, it appears money has changed their web page names and you need to update your formulas with the new addresses.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of jrgeico
Sent: Friday, January 20, 2012 8:35 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] MoneyCentral MSN Issue

 
Hye everyone!

I used functions such as:

=RCHGetTablecell("http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker, 3,"Unusual Expense (Income)")

to get my BS, IS and CF items (on which all ratios and other are calculated) but when I opened my spreadsheet a few minutes ago I noticed that it does not retrieve the data from this source any longer?

Anyone who knows what causes this?

The BS items still work and a few items on the CF statement work, the IS does not retrieve any numeric value at all...

If I did not provide sufficient information, do ask!

Thanks!

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

Re: MoneyCentral MSN - try FINVIZ.com

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

Fri Jan 20, 2012 8:33 am (PST)



Hardly a complete source. If you click on their "financial highlights" or
"statements" links, they route you to other websites. FinViz has no
financial statements data, which it the subject of the thread...

On Fri, Jan 20, 2012 at 8:56 AM, Murray Lindhout
<murray.lindhout@yahoo.com>wrote:

>
> I used to use MoneyCentral.... but now my financial homepage is
> www.finviz.com
>
> It's the best and most complete source of financial information I have
> every found... and it's FREE!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
1g.

Re: MoneyCentral MSN Issue

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

Fri Jan 20, 2012 9:02 am (PST)



Thanks for the heads up about the change!

I updated the two MSN financial statements templates in the files area by
changing these text strings:

http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=
http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Balance&stmtView=
http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=CashFlow&stmtView=

...to these:

http://investing.money.msn.com/investments/stock-income-statement?stmtView=
http://investing.money.msn.com/investments/stock-balance-sheet?stmtView=
http://investing.money.msn.com/investments/stock-cash-flow?stmtView=

Oddly enough, I had to change the URLs in the templates last January as
well. I hope they don't make this an annual chore.

On Fri, Jan 20, 2012 at 6:34 AM, jrgeico <rerren.jeroen@gmail.com> wrote:

>
> I used functions such as:
>
> =RCHGetTablecell("
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol="&Ticker,
> 3,"Unusual Expense (Income)")
>
> to get my BS, IS and CF items (on which all ratios and other are
> calculated) but when I opened my spreadsheet a few minutes ago I noticed
> that it does not retrieve the data from this source any longer?
>
> Anyone who knows what causes this?
>
> The BS items still work and a few items on the CF statement work, the IS
> does not retrieve any numeric value at all...
>
> If I did not provide sufficient information, do ask!
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2.

Help with extracting table from http://www.nasdaq.com/quotes/nasdaq-

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

Fri Jan 20, 2012 8:42 am (PST)



The table is dynamically generated, so there is no HTML table in the
source code of the web page from which the add-in can extract the data.
In fact, the data is within JavaScript code, such as:

<script type="text/javascript">var table_body = [["ATVI", "Activision
Blizzard, Inc", 12.16, -0.18, -1.46, 3434715, -0.19, "N", "N"],...

You could extract it from there, but is it worth the trouble? You can
get most of the data using RCHGetYahooQuotes() as long as you have the
ticker list.

PS: In the future, please direct add-in related questions to the Yahoo
group. Thanks.

On Fri, Jan 20, 2012 at 7:22 AM, Liu Bing <bliu88@yahoo.com> wrote:
I have been playing around to extract the Nasdaq 100 table from
http://www.nasdaq.com/quotes/nasdaq-100-stocks.aspx
<http://www.nasdaq.com/quotes/nasdaq-100-stocks.aspx> into an excel
worksheet.
=RCHGetHTMLTable("http://www.nasdaq.com/quotes/nasdaq-100-stocks.aspx","\
Company
<http://www.nasdaq.com/quotes/nasdaq-100-stocks.aspx%22,%22Company>
Name",-1,"This table",-1) I could not seem to get this work out.
Could you please help out if you get a chance?

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

Re: Pulling 5 years financials from FT.com

Posted by: "tombostar" pedeleconline@googlemail.com   tombostar

Fri Jan 20, 2012 10:46 am (PST)



Exactly, that's the point. It is in fact just one link, but little down it is possible to choose between annual and quaterly data without any change of the link. I think that is a java script menue or something...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The old URL still gets annual data for me, but I don't see a URL for the
> quarterly data...
>
> On Thu, Jan 19, 2012 at 12:21 PM, tombostar <pedeleconline@...>wrote:
>
> >
> > I think FT.com changed links for quaterly and annual information isn't it.
> >
> > Is there nonetheless a workaround to extract annual as well as quaterly
> > information from the website?
> >
>

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

Re: Pulling 5 years financials from FT.com

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

Fri Jan 20, 2012 12:12 pm (PST)



The add-in can only extract data from the source code of a web page with a
bookmarkable URL. So that would been the quarterly data is unavailable now.

On Fri, Jan 20, 2012 at 11:46 AM, tombostar <pedeleconline@googlemail.com>wrote:

> Exactly, that's the point. It is in fact just one link, but little down it
> is possible to choose between annual and quaterly data without any change
> of the link. I think that is a java script menue or something...
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > The old URL still gets annual data for me, but I don't see a URL for the
> > quarterly data...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (16)
3c.

Re: Pulling 5 years financials from FT.com

Posted by: "tombostar" pedeleconline@googlemail.com   tombostar

Sat Jan 21, 2012 2:36 am (PST)



Damm it, but that's actually what I expected already. Thanks anyway....

thomas

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The add-in can only extract data from the source code of a web page with a
> bookmarkable URL. So that would been the quarterly data is unavailable now.
>
> On Fri, Jan 20, 2012 at 11:46 AM, tombostar <pedeleconline@...>wrote:
>
> > Exactly, that's the point. It is in fact just one link, but little down it
> > is possible to choose between annual and quaterly data without any change
> > of the link. I think that is a java script menue or something...
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > The old URL still gets annual data for me, but I don't see a URL for the
> > > quarterly data...
> >
>

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

SMF-Template-MSN-10-Year-Summaries.xls

Posted by: "P Palminha" palminha@yahoo.com   palminha

Fri Jan 20, 2012 3:59 pm (PST)



Hi Randy,
 
In this template now I have some error as follows:
 

Current Assets Error
Current Liabilities Error
Long Term Debt Error
Shares Outstanding Error
Sales Error
EBIT Error
Depreciation Error
Total Net Income Error
Earnings Per Share Error
% Tax Rate #VALUE!
 
So, are there any changes in progress for this template?
 
Thank you in advanced
 
Best Regards
Paulo Palminha 
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
5.

SMF-Template-MSN-10-Year-Summaries.xls errors

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

Fri Jan 20, 2012 4:49 pm (PST)



MSN has changed the web page addresses and content on the 10-year
summaries for Income Statement and Balance sheet. I just updated the
element definition file, smf-elements-1.txt, and uploaded it to the
"Works in Progress" folder of the files area.

You'll need to replace your version of that file in the SMF folder to
pick up those new definitions. Best practice is to exit EXCEL before
updating that file.

PS: In the future, please direct such issues directly to the Yahoo group
and not to my email address. They too easily end up in my SPAM bucket if
sent to me directly. Thanks.

On Fri, Jan 20, 2012 at 4:59 PM, P Palminha <palminha@...> wrote:
In this template now I have some error as follows: Current Assets
Error Current Liabilities Error Long Term Debt Error Shares
Outstanding Error Sales Error EBIT Error Depreciation Error
Total Net Income Error Earnings Per Share Error % Tax Rate
#VALUE! So, are there any changes in progress for this template? Thank
you in advanced Best RegardsPaulo Palminha

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)