Selasa, 03 April 2012

[smf_addin] Digest Number 2165

Messages In This Digest (15 Messages)

Messages

1a.

Get Table Cell Formula - Help - forumals returning "error" message.

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

Mon Apr 2, 2012 8:33 am (PDT)



Hello -

I apologize in advance if this is question was already answered. When I download certain templates (ex. - "valuation DDM" template) that utilizes "GETTABLECELL" formulas, I seem to get getting the "error" value returned for all of these types of forumulas (reuters, MSN URLSs etc..). However, I know everything else is working because other formulas are retrieving data. How can I fix this? What am I missing?

I am using windows 7 and Excel 2007.

Thanks,

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

Re: Get Table Cell Formula - Help - forumals returning "error" messa

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

Mon Apr 2, 2012 8:35 am (PDT)



I've had to redefine Reuters and MSN elements in the past year or so
because of web site changes, so it's quite possible the formulas need to
have their URLs updated to the new website structures.

On Mon, Apr 2, 2012 at 6:52 AM, bagalisjt <bagalisjt@yahoo.com> wrote:

>
> I apologize in advance if this is question was already answered. When I
> download certain templates (ex. - "valuation DDM" template) that utilizes
> "GETTABLECELL" formulas, I seem to get getting the "error" value returned
> for all of these types of forumulas (reuters, MSN URLSs etc..). However, I
> know everything else is working because other formulas are retrieving data.
> How can I fix this? What am I missing?
>
> I am using windows 7 and Excel 2007.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1c.

Re: Get Table Cell Formula - Help - forumals returning "error" messa

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

Mon Apr 2, 2012 12:36 pm (PDT)



Thank you for your response. I am new to this forum and I tried to update the URLs and I am struggling with understanding how I can write the proper references to the underlying tables When I update just the URL it still comes up with an "error". I guess it could be that my table references are off but I have no way of understanding of how to write that part of the formula.

If you could point me in the right direction/thread that would be much appreciated.

Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I've had to redefine Reuters and MSN elements in the past year or so
> because of web site changes, so it's quite possible the formulas need to
> have their URLs updated to the new website structures.
>
> On Mon, Apr 2, 2012 at 6:52 AM, bagalisjt <bagalisjt@...> wrote:
>
> >
> > I apologize in advance if this is question was already answered. When I
> > download certain templates (ex. - "valuation DDM" template) that utilizes
> > "GETTABLECELL" formulas, I seem to get getting the "error" value returned
> > for all of these types of forumulas (reuters, MSN URLSs etc..). However, I
> > know everything else is working because other formulas are retrieving data.
> > How can I fix this? What am I missing?
> >
> > I am using windows 7 and Excel 2007.
> >
>

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

Re: Get Table Cell Formula - Help - forumals returning "error" messa

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

Mon Apr 2, 2012 12:49 pm (PDT)



Give me an example of one that's not working...formula and ticker.

On Mon, Apr 2, 2012 at 12:35 PM, bagalisjt <bagalisjt@yahoo.com> wrote:

> Thank you for your response. I am new to this forum and I tried to update
> the URLs and I am struggling with understanding how I can write the proper
> references to the underlying tables When I update just the URL it still
> comes up with an "error". I guess it could be that my table references are
> off but I have no way of understanding of how to write that part of the
> formula.
>
> If you could point me in the right direction/thread that would be much
> appreciated.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1e.

Re: Get Table Cell Formula - Help - forumals returning "error" messa

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

Mon Apr 2, 2012 1:35 pm (PDT)



Ticker: RDC

Formula from template (Note that Balance sheet items work but not income statement):

=RCHGetTableCell("http://quicktake.morningstar.com/Stock/Income10.asp?Symbol="&Ticker, 26, "Fiscal Year-End:", ">Revenue")

Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Give me an example of one that's not working...formula and ticker.
>
> On Mon, Apr 2, 2012 at 12:35 PM, bagalisjt <bagalisjt@...> wrote:
>
> > Thank you for your response. I am new to this forum and I tried to update
> > the URLs and I am struggling with understanding how I can write the proper
> > references to the underlying tables When I update just the URL it still
> > comes up with an "error". I guess it could be that my table references are
> > off but I have no way of understanding of how to write that part of the
> > formula.
> >
> > If you could point me in the right direction/thread that would be much
> > appreciated.
> >
>

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

Re: Get Table Cell Formula - Help - forumals returning "error" messa

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

Mon Apr 2, 2012 3:35 pm (PDT)



I thought you said MSN and Reuters?

The income statement items from Morningstar are no longer available because
Morningstar changed the web page so that it is dynamically generated. The
data is no longer within the source code of the web page, which is where it
needs to be for the add-in to extract it.

On Mon, Apr 2, 2012 at 1:35 PM, bagalisjt <bagalisjt@yahoo.com> wrote:

> Ticker: RDC
>
> Formula from template (Note that Balance sheet items work but not income
> statement):
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/Stock/Income10.asp?Symbol="&Ticker, 26,
> "Fiscal Year-End:", ">Revenue")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

Re: weeklys

Posted by: "StanG" asahi3@hotmail.com   arigato12000

Mon Apr 2, 2012 8:50 am (PDT)



Hi, Randy
Thank you, Randy but I am not differentiating between Calls and Puts but between monthly and weekly quotes. I think that I have some real Put quotes now.
Stan

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> But the point remains -- the "OX" data source is only for calls.
>
> Use "OX2" or "OX3" if the greeks aren't of import. They have both the puts
> and the calls.
>
> On Sun, Apr 1, 2012 at 8:39 AM, StanG <asahi3@...> wrote:
>
> >
> > Thank you for the quick reply. I am not talking about the Greeks just the
> > Prices - weeklys - I can get the monthly prices but not weeklys - using w -
> > W - Weekly - 4/5 or any other date method. I am using smfgetoptionquotes()
> > in a group. It works with just 4 (month) in the symbol and returns the
> > monthlys but cannot get the weekly Put prices (the weekly Call prices are
> > OK).
> > Stan
> >
>

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

Indian data providers like moneycontrol.com

Posted by: "Sowmy" sowmy.aura@yahoo.com   sowmy.aura

Mon Apr 2, 2012 10:54 am (PDT)



Hi,

I was wondering if someone tried to extract data from Indian data providers like moneycontrol.com or indiainfoline.com. If so, can someone explain how to do that, for a real 'layman'. Please note that I have no programming knowledge but I am fairly good at Excel...

Kind regards,

Sowmy

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

Re: Indian data providers like moneycontrol.com

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

Mon Apr 2, 2012 10:55 am (PDT)



Do a search of the message archives and you'll find some examples...

On Mon, Apr 2, 2012 at 10:00 AM, Sowmy <sowmy.aura@yahoo.com> wrote:

>
> I was wondering if someone tried to extract data from Indian data
> providers like moneycontrol.com or indiainfoline.com. If so, can someone
> explain how to do that, for a real 'layman'. Please note that I have no
> programming knowledge but I am fairly good at Excel...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

EPS -TTM

Posted by: "Sowmy" sowmy.aura@yahoo.com   sowmy.aura

Mon Apr 2, 2012 10:54 am (PDT)



Hi,

I have downloaded the add-in and started using it to construct my own stock screener as well as valuation spreadsheets. For someone with 0 programming knowledge, this was fairly simple. I must congratulate you for that.

Since I am analyzing Indian stocks, the only data source that I can use with the RCHgetelementnumber() function is 'Reuters'. I was wondering if there was a way to figure out EPS for the TTM using Reuters and the RCHgetelementnumber() function. I was only able to find EPS-TTM vs TTM one year ago...can you help please?

Kind regards,

Sowmy

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

Re: EPS -TTM

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

Mon Apr 2, 2012 11:05 am (PDT)



For an American company, it's on this page:

http://www.reuters.com/finance/stocks/overview?symbol=MMM

You'd need to use the RCHGetTableCell() function to pull it:

=RCHGetTableCell("http://www.reuters.com/finance/stocks/overview?symbol=MMM",1,"EPS
(TTM):")

On Mon, Apr 2, 2012 at 9:52 AM, Sowmy <sowmy.aura@yahoo.com> wrote:

>
> Since I am analyzing Indian stocks, the only data source that I can use
> with the RCHgetelementnumber() function is 'Reuters'. I was wondering if
> there was a way to figure out EPS for the TTM using Reuters and the
> RCHgetelementnumber() function. I was only able to find EPS-TTM vs TTM one
> year ago...can you help please?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5a.

How do I attach an excel file to my message?

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

Mon Apr 2, 2012 9:37 pm (PDT)





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

Re: How do I attach an excel file to my message?

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

Mon Apr 2, 2012 10:08 pm (PDT)



You'd need to use an email client to do so...
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5c.

Re: How do I attach an excel file to my message?

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

Mon Apr 2, 2012 11:26 pm (PDT)



Not clear what an e-mail client means....

I want to attach an excel sheet to my post for a query...

Thanks,

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You'd need to use an email client to do so...
>

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

Re: How do I attach an excel file to my message?

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

Mon Apr 2, 2012 11:33 pm (PDT)



The only time I've attached files is when sending mail from my GMail
account. I don't know how to do it elsewhere.

On Mon, Apr 2, 2012 at 11:26 PM, navin_agrawal_1
<navin_agrawal_1@yahoo.com>wrote:

> Not clear what an e-mail client means....
>
> I want to attach an excel sheet to my post for a query...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
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.

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)