Senin, 31 Oktober 2011

[smf_addin] Digest Number 2002

Messages In This Digest (8 Messages)

Messages

1a.

Reuters financial statements

Posted by: "pinetreelondon" vanhulten@yahoo.com   pinetreelondon

Sun Oct 30, 2011 10:47 am (PDT)



Randy,
I am interested in using Reuters Financial statements and have been looking through the posts here. However, to get 5 years of data instead of just the last year - the website requires a logon. And so i did and i check this using the web query alt +d +d + w - which then shows i am logged on. Still, i get errors in retrieving the table data whether i use rchgethtmltable or rchgettablecell (i am able to get the last year of data but my interest is in getting the extended 5 column/year table.

the URL is http://www.reuters.com/finance/stocks/incomeStatement/detail?symbol=CELG.O&detail?stmtType=INC&perType=ANN

when i run it though i get a java script error (line 455, object required, http://www.reuters.com/resources_v2/js/rcom-tns-frontend.js). but if i click yes it will work correctly nevertheless.

Question is: is it possible to retrieve the table or has reuters got it shielded off in some we we cant get around? Or is is just my ignorance - wondered if there is a solution if it can be done.

Many thanks,

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

Re: Reuters financial statements

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

Sun Oct 30, 2011 11:17 am (PDT)



Not sure where you are running into a problem -- this works fine for me:

=RCHGetHTMLTable("
http://www.reuters.com/finance/stocks/incomeStatement/detail?symbol=CELG.O&detail?stmtType=INC&perType=ANN","per
share items",-1,"",1)

The RCHGetTableCell() functions work fine for me as well.

On Sun, Oct 30, 2011 at 10:47 AM, pinetreelondon <vanhulten@yahoo.com>wrote:

> Randy,
> I am interested in using Reuters Financial statements and have been
> looking through the posts here. However, to get 5 years of data instead of
> just the last year - the website requires a logon. And so i did and i check
> this using the web query alt +d +d + w - which then shows i am logged on.
> Still, i get errors in retrieving the table data whether i use
> rchgethtmltable or rchgettablecell (i am able to get the last year of data
> but my interest is in getting the extended 5 column/year table.
>
> the URL is
> http://www.reuters.com/finance/stocks/incomeStatement/detail?symbol=CELG.O&detail?stmtType=INC&perType=ANN
>
> when i run it though i get a java script error (line 455, object required,
> http://www.reuters.com/resources_v2/js/rcom-tns-frontend.js). but if i
> click yes it will work correctly nevertheless.
>
> Question is: is it possible to retrieve the table or has reuters got it
> shielded off in some we we cant get around? Or is is just my ignorance -
> wondered if there is a solution if it can be done.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

MSN SCOUTER

Posted by: "Ken B" kab777@optonline.net   mustang66.7599

Sun Oct 30, 2011 2:26 pm (PDT)



Absolutely cannot believe how exciting this add-in is!! I love it!I have retrieved everything I am looking for except MSN Scouter does not work - specifically line 543 returns ERROR - is there a fix for this?

Thanks!

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

Re: MSN SCOUTER

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

Sun Oct 30, 2011 2:28 pm (PDT)



It's working here. You probably just need the new element definitions for
MSN from the "Works in Progress" folder from the files area. They redid
their web site structure earlier this year.

On Sun, Oct 30, 2011 at 2:24 PM, Ken B <kab777@optonline.net> wrote:

> Absolutely cannot believe how exciting this add-in is!! I love it!I have
> retrieved everything I am looking for except MSN Scouter does not work -
> specifically line 543 returns ERROR - is there a fix for this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2c.

Re: MSN SCOUTER

Posted by: "ken" kab777@optonline.net   mustang66.7599

Sun Oct 30, 2011 2:47 pm (PDT)



Did it - now it all works - how did you ever do all this? I have been
spending around four hours a week reviewing stocks for my trading activities
- now it will take a half hour - what a great add-in!!

Thank you!

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy Harmelink
Sent: Sunday, October 30, 2011 5:29 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] MSN SCOUTER

It's working here. You probably just need the new element definitions for
MSN from the "Works in Progress" folder from the files area. They redid
their web site structure earlier this year.

On Sun, Oct 30, 2011 at 2:24 PM, Ken B <kab777@optonline.net> wrote:

Absolutely cannot believe how exciting this add-in is!! I love it!I have
retrieved everything I am looking for except MSN Scouter does not work -
specifically line 543 returns ERROR - is there a fix for this?

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

anyone have a cool spreadsheet that scans stocks for buy-sell signal

Posted by: "scott" scott_grant2@yahoo.com   scott_grant2

Sun Oct 30, 2011 3:54 pm (PDT)



i love this excel add-in, its very cool...
and im an analyst at heart, of course i just missed
this latest market rally.. i was using it with a
tom demark spreadsheet that i paid for (so sorry cant
share it) but wondering if anyone else has a cool
spreadsheeet that maybe scans alot of stocks for buy and
sell signals that generally work.. i saw the analyst recomendation
in the attachment folder, does that one work?
anyone have a cool one they can share? that scans
alot of stocks and gives buy and sell signals based
on some kind of logic.. moving average, macd, stock rsi, etc..

anyway.. very very cool

thanks
Scott

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

Re: anyone have a cool spreadsheet that scans stocks for buy-sell si

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

Sun Oct 30, 2011 4:10 pm (PDT)



You shouldn't be using the add-in as a screener/scanner. You should be
using other screeners/scanners to get down to a small number of stocks and
then use the add-in to get more detailed information on those few stocks.

You just need to collect too much data to do your own screener in EXCEL,
and that's not fair to the free data providers.

On Sun, Oct 30, 2011 at 3:54 PM, scott <scott_grant2@yahoo.com> wrote:

> i love this excel add-in, its very cool...
> and im an analyst at heart, of course i just missed
> this latest market rally.. i was using it with a
> tom demark spreadsheet that i paid for (so sorry cant
> share it) but wondering if anyone else has a cool
> spreadsheeet that maybe scans alot of stocks for buy and
> sell signals that generally work.. i saw the analyst recomendation
> in the attachment folder, does that one work?
> anyone have a cool one they can share? that scans
> alot of stocks and gives buy and sell signals based
> on some kind of logic.. moving average, macd, stock rsi, etc..
>
> anyway.. very very cool
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.

Re: anyone have a cool spreadsheet that scans stocks for buy-sell si

Posted by: "scott" scott_grant2@yahoo.com   scott_grant2

Sun Oct 30, 2011 4:59 pm (PDT)



ok, does anyone have a cool excel spreadsheet that helps with
more detailed information and has helped them with their trading?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You shouldn't be using the add-in as a screener/scanner. You should be
> using other screeners/scanners to get down to a small number of stocks and
> then use the add-in to get more detailed information on those few stocks.
>
> You just need to collect too much data to do your own screener in EXCEL,
> and that's not fair to the free data providers.
>
> On Sun, Oct 30, 2011 at 3:54 PM, scott <scott_grant2@...> wrote:
>
> > i love this excel add-in, its very cool...
> > and im an analyst at heart, of course i just missed
> > this latest market rally.. i was using it with a
> > tom demark spreadsheet that i paid for (so sorry cant
> > share it) but wondering if anyone else has a cool
> > spreadsheeet that maybe scans alot of stocks for buy and
> > sell signals that generally work.. i saw the analyst recomendation
> > in the attachment folder, does that one work?
> > anyone have a cool one they can share? that scans
> > alot of stocks and gives buy and sell signals based
> > on some kind of logic.. moving average, macd, stock rsi, etc..
> >
> > anyway.. very very cool
> >
>

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

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

New business?

Get new customers.

List your web site

in Yahoo! Search.

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

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 02.52

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)