Jumat, 24 Oktober 2014

[smf_addin] Digest Number 3219[1 Attachment]

15 Messages

Digest #3219
1a
Re: ReutersRat and ticker KORS by "Randy Harmelink" rharmelink
3b
Re: Historical data of market corrections by "Randy Harmelink" rharmelink
4a
Re: MSN data by "cgrain" cgrain76

Messages

Fri Oct 24, 2014 3:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Reuters doesn't have a web page for ticker symbol KORS.

On Fri, Oct 24, 2014 at 1:02 AM, Folonari Darilo folonari05@... wrote:

> HI, i've a problem with function RCHGetElementNumber and all data
> reutersRat only for ticker KORS.
> For example when i use RCHGetElementNumber (KORS;731)or (kors;13626) etc.
> it returns me an "error". Only for KORS (?!?).
>

Fri Oct 24, 2014 8:54 am (PDT) . Posted by:

zacharycal

Randy, thanks again for your help. You really are incredible with all this and I really appreciate it!
Zach

Fri Oct 24, 2014 10:48 am (PDT) . Posted by:

steven_rourk

Excellent!. It worked like a charm....I´m almost there... Just one more and hopefully last one: now i need the same formula but searching for the minimum amount in ColumnB... It should be easy right?.. just exchange the formulas MIN instead of MAX, and the columns from A to B, so I put it like this:

=MIN(OFFSET(B3,0,0,MAX(IF(A3:A100>0,ROW(A3:A100),99999))-ROW(A3),1))

The problem is that the formula will result in 0 as cero is correctly the minimum amount, but a need the minimun amount other than 0....


Column A
Column B
Row1
0
0
Row2
0
1088
Row3
0
0
Row4
0
0
Row5
0
1084
Row6
0
0
Row7
0
1087
Row8
0
0
Row9
0
1082
Row10
0
0
Row11
0
0
Row12
1200
0
Row13
1185
0
Row14
1183
0


Fri Oct 24, 2014 5:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

How about the array-entered:

=SMALL(OFFSET(B3,0,0,MAX(IF(A3:A100>0,ROW(A3:A100),0))-ROW(A3),1),COUNTIF(OFFSET(B3,0,0,MAX(IF(A3:A100>0,ROW(A3:A100),0))-ROW(A3),1),0)+1)

I used SMALL() instead of MIN(), and then counted the number of zeros, so I
could take the smallest number that is larger than zero. Note I also
changed the 99999 constant to zero -- otherwise 99999 will always be your
MAX() value.

Note that SMALL(xxx,1) and MIN(xxx) are more or less equivalent, as are
LARGE(xxx,1) and MAX(). I often have to resort to SMALL() and LARGE() for
one reason or another -- such as non-zero.

On Fri, Oct 24, 2014 at 10:48 AM, steven_rourk@...wrote:

> Excellent!. It worked like a charm....I´m almost there... Just one more
> and hopefully last one: now i need the same formula but searching for the
> minimum amount in ColumnB... It should be easy right?.. just exchange the
> formulas MIN instead of MAX, and the columns from A to B, so I put it like
> this:
>
> =MIN(OFFSET(B3,0,0,MAX(IF(A3:A100>0,ROW(A3:A100),99999))-ROW(A3),1))
>
> The problem is that the formula will result in 0 as cero is correctly the
> minimum amount, but a need the minimun amount other than 0....
>
>
>
> *Column A*
>
> *Column B*
>
> *Row1*
>
> 0
>
> 0
>
> *Row2*
>
> 0
>
> 1088
>
> *Row3*
>
> 0
>
> 0
>
> *Row4*
>
> 0
>
> 0
>
> *Row5*
>
> 0
>
> 1084
>
> *Row6*
>
> 0
>
> 0
>
> *Row7*
>
> 0
>
> 1087
>
> *Row8*
>
> 0
>
> 0
>
> *Row9*
>
> 0
>
> 1082
>
> *Row10*
>
> 0
>
> 0
>
> *Row11*
>
> 0
>
> 0
>
> *Row12*
>
> 1200
>
> 0
>
> *Row13*
>
> 1185
>
> 0
>
> *Row14*
>
> 1183
>
> 0
>
>
>
>

Fri Oct 24, 2014 12:52 pm (PDT) . Posted by:

"cgrain" cgrain76

Try guru.com.

Clark Grain

From: mailto:smf_addin@yahoogroups.com
Sent: Friday, October 24, 2014 3:17 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: MSN data

yah, the page is different now. I can't seems to work with my original excel now other than creating a new one from scratch.... Was there a summary on how we can extract from other sites? I lost the link.

Fri Oct 24, 2014 2:31 pm (PDT) . Posted by:

bob_15861586

Randy,

You solved my problem again. It now works.


Thank you very much.


Bob

Fri Oct 24, 2014 7:14 pm (PDT) . Posted by:

tzewei_79

Hi,


I'm trying to extract "Industry:" from =RCHGetTableCell("http://finance.yahoo.com/q/in?s="&A12,1,"industry:") but it always shows blank. I could get "Sector:" thought. How do I get the industry below sector to show up?

Fri Oct 24, 2014 7:30 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You get blank returned because the first occurrence of the string
"Industry:" is in the title of the page. It's actually on the web page
numerous times.

The defined element (i.e. #13867) for that data item does something like
this:

=RCHGetTableCell("http://finance.yahoo.com/q/in?s="&C5,1,">Industry:<")

Another option would be to position yourself on the page first, before
finding the NEXT occurrence of "Industry:". For example:

=RCHGetTableCell("http://finance.yahoo.com/q/in?s=
"&C6,1,"Membership","Industry:")

On Fri, Oct 24, 2014 at 7:14 PM, tzewei_79@... wrote:

>
> I'm trying to extract "Industry:" from =RCHGetTableCell("
> http://finance.yahoo.com/q/in?s="&A12,1,"industry:") but it always shows
> blank. I could get "Sector:" thought. How do I get the industry below
> sector to show up?
>

Fri Oct 24, 2014 8:33 pm (PDT) . Posted by:

tzewei_79

How do you get the defined element (i.e. #13867)?

Fri Oct 24, 2014 8:28 pm (PDT) . Posted by:

ridgebacksexcel

Randy,


I tried to find the static page for the Financials for the stock Allstate:ALL from the source code but was not able to locate it this time.
Here is the dynamic page: http://financials.morningstar.com/cash-flow/cf.html?t=ALL http://financials.morningstar.com/cash-flow/cf.html?t=ALL


I am trying to build formulas to extract quarterly data as a backup to the gurufocus data if it is possible to even do this.


Perhaps an example and I can build the rest.


The 6-2014 Net Income is $645.


What formula would best find that on the web site above? I know you have to get to the static web page first.








Fri Oct 24, 2014 9:02 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The static page is a nightmare to extract from. Take a look:

http://financials.morningstar.com/ajax/ReportProcess4HtmlAjax.html?reportType=is&period=3&dataType=A&order=asc&columnYear=5&rounding=3&view=raw&t=ALL

Instead, I suggest just pulling in the CSV file versions of the data, and
extract the data from there using VLOOKUP(). See:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/19776

On Fri, Oct 24, 2014 at 8:28 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I tried to find the static page for the Financials for the stock
> Allstate:ALL from the source code but was not able to locate it this time.
>
> Here is the dynamic page:
> http://financials.morningstar.com/cash-flow/cf.html?t=ALL
>
> I am trying to build formulas to extract quarterly data as a backup to the
> gurufocus data if it is possible to even do this.
>
> Perhaps an example and I can build the rest.
>
> The 6-2014 Net Income is $645.
>
> What formula would best find that on the web site above? I know you have
> to get to the static web page first.
>

Fri Oct 24, 2014 8:45 pm (PDT) . Posted by:

tzewei_79

Hi,


I downloaded RCHGetTableCell-Template-DiviData-Upcoming-Ex-Dividend.xls to get a feel of how the formula works but somehow the cells were all #NAME?. I tried to change the rating to search for but result still the same. I tried looking at the documentation on smfGetTagContent but the example is quite different.


Actually I wanted to find an example of getting the company name. From the example, I think it only display the company names if dividata has them on the upcomign Ex-div list right?

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 21.02

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)