Kamis, 21 Mei 2015

[smf_addin] Digest Number 3412

8 Messages

Digest #3412
1c
Re: Quarterly data for the past 5 years? by "Randy Harmelink" rharmelink
2a
Re: Excel 2013 by option2z
3b
Re: Import file using smf by "Randy Harmelink" rharmelink
4a
Re: MS data by cgrauballe
4b
Re: MS data by "Randy Harmelink" rharmelink

Messages

Wed May 20, 2015 8:38 am (PDT) . Posted by:

sirons1962

Randy,

I dug up the RCHGetTableCell-Template-Nasdaq-Quarterly-Financials and in trying to get the functions right for "Net Income" I am running into an issue since there are 3 areas with "Net Income" in the label. They are:

Net Income-Cont. Operations
Net Income
Net Income Applicable to Common Shareholders

When I look at the source they are listed in this order and I get the proper data for the first one and the third one but the second one always grabs the same data as the first one.

Now I will admit I have dabbled with your work but I am by no means anything other than a novice at this so I may be missing something simple. It is stopping at the first "Net Income" it sees so I am thinking it needs something else to get it to the correct one?

Below is what I am using:

=IF(Ticker="None","--",RCHGetTableCell("http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=1&Duration=1&NumPeriods=60&selected="&Ticker,0,"Ending:",">Net Income","fundnum"))

Wed May 20, 2015 8:39 am (PDT) . Posted by:

sirons1962

Randy,

Right after I posted my original message I went back and figured it out.

I had to add one more Find to get it pointed closer to the data.


Sorry for cluttering up the messages.

Wed May 20, 2015 8:53 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The other thing you can do is make that first search term more specific, as
in:

">Net Income-Cont. Oper"
">Net Income<"
">Net Income Applicable"

On Wed, May 20, 2015 at 8:39 AM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Right after I posted my original message I went back and figured it out.
>
> I had to add one more Find to get it pointed closer to the data.
>

On Wed, May 20, 2015 at 8:22 AM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I dug up the RCHGetTableCell-Template-Nasdaq-Quarterly-Financials and in
> trying to get the functions right for "Net Income" I am running into an
> issue since there are 3 areas with "Net Income" in the label. They are:
>
> Net Income-Cont. Operations
> Net Income
> Net Income Applicable to Common Shareholders
>
> When I look at the source they are listed in this order and I get the
> proper data for the first one and the third one but the second one always
> grabs the same data as the first one.
>
> Now I will admit I have dabbled with your work but I am by no means
> anything other than a novice at this so I may be missing something simple.
> It is stopping at the first "Net Income" it sees so I am thinking it needs
> something else to get it to the correct one?
>
> Below is what I am using:
>
> =IF(Ticker="None","--",RCHGetTableCell("
> http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=1&Duration=1&NumPeriods=60&selected="&Ticker,0,"Ending:",">Net
> Income","fundnum&quot;))
>

Wed May 20, 2015 9:49 am (PDT) . Posted by:

option2z

The add-in works fine in my windows 8.1 excel 2013 system. I also run excel 2010 with the add-in on the same computer at the same time with no problems (at least no problems associated with operating the SMF Add-In :) ). It is handy to be able to run two independent versions of excel, and 2013 did away with the MDI (lets you have multiple spreadsheets open in the same excel window. 2013 opens a new excel instance for each spreadsheet open...a waste of a lot of screen space.


Good luck, 2013 works as designed with the SMF Add-In.

Wed May 20, 2015 7:00 pm (PDT) . Posted by:

boo1712


http://www.aastocks.com/en/stocks/market/top-rank/stock?type=V&t=1&s=&o=1&p=&export=1


Hi Guys,
Any idea how to get the above file using smf addin? Possible?
Its downloaded as xls.
Thank you for reading my email.
Terry


Wed May 20, 2015 7:18 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It actually creates an HTML document with an HTML table that opens up in
EXCEL.

So all you need to do is array-enter this over a range:

=RCHGetHTMLTable("
http://www.aastocks.com/en/stocks/market/top-rank/stock?type=V&t=1&s=&o=1&p=&export=1
","",1,"",1)

On Wed, May 20, 2015 at 7:00 PM, boo1712@yahoo.co.uk [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> http://www.aastocks.com/en/stocks/market/top-rank/stock?type=V&t=1&s=&o=1&p=&export=1
>
> Any idea how to get the above file using smf addin? Possible?
> Its downloaded as xls.
>
>

Thu May 21, 2015 12:13 am (PDT) . Posted by:

cgrauballe

Thanks Randy,


Is it just me or does it seem like there isn't any consistent item on the page?
Is it the same for Valuation history on this one:http://financials.morningstar.com/valuation/price-ratio.html?t=MSFT®ion=usa&culture=en-US


Sorry for the stupid questions :)


/Caspar


Thu May 21, 2015 12:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what you mean by "consistent item"?

Valuation history is loaded from here:

http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings&t=MMM

On Thu, May 21, 2015 at 12:13 AM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is it just me or does it seem like there isn't any consistent item on the
> page?
>
> Is it the same for Valuation history on this one:
> http://financials.morningstar.com/valuation/price-ratio.html?t=MSFT®ion=usa&culture=en-US
>
> Sorry for the stupid questions :)
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar