Sabtu, 03 Mei 2014

[smf_addin] Digest Number 3057

5 Messages

Digest #3057

Messages

Fri May 2, 2014 6:46 am (PDT) . Posted by:

"Inildo Cavele" inildo.cavele

Hi there everyone!
 
I have been thinking a lot of exploiting emerging markets. Brazil seems very interesting in terms of growth and stability.
 
I think we should start thinking of SMF Addin functionality gathering data from other markets, too like BOVESPA in Brazil and corresponding financial websites like "fundamentus". There are many interesting and cheap companies there...
 
 
Kindest regards!

Fri May 2, 2014 8:50 pm (PDT) . Posted by:

ridgebacksexcel

Randy,
I would like to start pulling some info from the Morningstar Dividend and Splits page. I recall you saying these were dynamic pages.


This is the page for Exxon (XOM).
http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=xom http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=xom


I would like to extract into Excel the Ex-Dividend date, Payable date, and the Dividend Amount.
I would also like to get the most recent split history date and ratio.


What would be a good formula to do this for each one? The view source does not seem to help me.




Fri May 2, 2014 9:29 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There are the static web pages that supply the data to that dynamic web
page:

http://performance.morningstar.com/Performance/stock/split-history.action?t=XOM
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=XOM
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=XOM

So, for example:

=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM
",1,"<tbody","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM
",2,"<tbody","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM
",3,"<tbody","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM
",4,"<tbody","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM
",5,"<tbody","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=XOM
",6,"<tbody","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/split-history.action?t=XOM
",1,"<tbody","<tr","<tr")
=RCHGetTableCell("
http://performance.morningstar.com/Performance/stock/split-history.action?t=XOM
",2,"<tbody","<tr","<tr")

On Fri, May 2, 2014 at 8:50 PM, <tmallen2@bellsouth.net> wrote:

>
> I would like to start pulling some info from the Morningstar Dividend and
> Splits page. I recall you saying these were dynamic pages.
>
> This is the page for Exxon (XOM).
>
>
> http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=xom
>
> I would like to extract into Excel the Ex-Dividend date, Payable date, and
> the Dividend Amount.
>
> I would also like to get the most recent split history date and ratio.
>
> What would be a good formula to do this for each one? The view source does
> not seem to help me.
>
>

Fri May 2, 2014 9:49 pm (PDT) . Posted by:

ridgebacksexcel

Thanks Randy. This is exactly what I was looking for. The rest should be easy to program.


I'm curious. How did you find what the URL for the static pages were should I want to do this with another page in the future?


Was it embedded somewhere in the view source page?

Fri May 2, 2014 10:02 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There are two ways that I was using. First, I was digging through
JavaScript code, finding something like:

function loadUpcomingDividends(symbol, currency,culture) {
var holdProductCode = g_productCode == "SRT" ? "COM" : g_productCode;
var path = "/upcoming-dividends.action?";
var parameters = urlAppendix+"&ndec=2&y=11";
var url = STOCK_CONTEXT_PATH + path + parameters;
$.get(url,
{},

The second way is to use some type of URL snooper. Late last year, I added
the HTTPFox add-in to FireFox. When turned on, it lists all of the web
pages accessed when a web page is opened.

Right now, I have a workbook with a large number of "uncovered" static
pages, that used one or both of these methods to discover them.

On Fri, May 2, 2014 at 8:50 PM, <tmallen2@bellsouth.net> wrote:

>
> I would like to start pulling some info from the Morningstar Dividend and
> Splits page. I recall you saying these were dynamic pages.
>
> This is the page for Exxon (XOM).
>
>
> http://performance.morningstar.com/stock/performance-return.action?p=dividend_split_page&t=xom
>
> I would like to extract into Excel the Ex-Dividend date, Payable date, and
> the Dividend Amount.
>
> I would also like to get the most recent split history date and ratio.
>
> What would be a good formula to do this for each one? The view source does
> not seem to help me.
>
Diposting oleh EXCEL FEED LEARNING di 02.25

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)