9 Messages
Digest #3058
Messages
Sat May 3, 2014 5:59 am (PDT) . Posted by:
ridgebacksexcel
Ok. Thanks. That might be a bit beyond my capabilities.
Perhaps I will just ask you for a static page URL in the future should the need should arise.
Thanks again for all your help.
Perhaps I will just ask you for a static page URL in the future should the need should arise.
Thanks again for all your help.
Sat May 3, 2014 6:32 am (PDT) . Posted by:
lexstar
Has anyone experienced pulling mutual fund and ETF adjusted data from MSN Money? Since Morningstar is providing the data, I assume that these data may be more accurate than those from Yahoo Finance or Google Finance.
And, is there an add-in function to pull the historical data from the MSN website? I'm interested in pulling many tickers (excess of 500 or more) for Mutual Funds and ETFs.
Any help greatly appreciated. And, thanks in advance.
And, is there an add-in function to pull the historical data from the MSN website? I'm interested in pulling many tickers (excess of 500 or more) for Mutual Funds and ETFs.
Any help greatly appreciated. And, thanks in advance.
Sat May 3, 2014 8:13 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can get the download file from MSN with something like:
=smfGetCSVFile("
http://investing.money.msn.com/investments/etf-historical-price/?PT=7&D4=1&DD=1&D5=0&DCS=2&MA0=0&MA1=0&CF=0&nocookie=1&SZ=0&symbol=SPY&Download=1
")
Just use the link that is on their "Download" button.
But I notice that their O/H/L for SPY are all set to the closing price.
The data is adjusted for splits, but not for dividends.
On Sat, May 3, 2014 at 6:32 AM, <lexstar@yahoo.com> wrote:
> Has anyone experienced pulling mutual fund and ETF adjusted data from
> MSN Money? Since Morningstar is providing the data, I assume that these
> data may be more accurate than those from Yahoo Finance or Google Finance.
>
> And, is there an add-in function to pull the historical data from the MSN
> website? I'm interested in pulling many tickers (excess of 500 or more)
> for Mutual Funds and ETFs.
>
> Any help greatly appreciated. And, thanks in advance.
>
=smfGetCSVFile("
http://investing.money.msn.com/investments/etf-historical-price/?PT=7&D4=1&DD=1&D5=0&DCS=2&MA0=0&MA1=0&CF=0&nocookie=1&SZ=0&symbol=SPY&Download=1
")
Just use the link that is on their "Download" button.
But I notice that their O/H/L for SPY are all set to the closing price.
The data is adjusted for splits, but not for dividends.
On Sat, May 3, 2014 at 6:32 AM, <lexstar@yahoo.com> wrote:
> Has anyone experienced pulling mutual fund and ETF adjusted data from
> MSN Money? Since Morningstar is providing the data, I assume that these
> data may be more accurate than those from Yahoo Finance or Google Finance.
>
> And, is there an add-in function to pull the historical data from the MSN
> website? I'm interested in pulling many tickers (excess of 500 or more)
> for Mutual Funds and ETFs.
>
> Any help greatly appreciated. And, thanks in advance.
>
Sat May 3, 2014 9:24 am (PDT) . Posted by:
JCHyjun
Hello
WSJ has nice WWW page http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004 http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004 where they posted updates on dividends from various companies. To me the most interesting parts are INCREASED and REDUCED in http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004#dividendsB http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004#dividendsB sub-page.
Is it possible to convert this info in Excel file?
Thank you!
J.C. Hyjun
WSJ has nice WWW page http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004 http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004 where they posted updates on dividends from various companies. To me the most interesting parts are INCREASED and REDUCED in http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004#dividendsB http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004#dividendsB sub-page.
Is it possible to convert this info in Excel file?
Thank you!
J.C. Hyjun
Sat May 3, 2014 10:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetHTMLTable("
http://online.wsj.com/mdc/public/page/2_3022-dividends.html",">%
Yield",-1,"",1)
On Sat, May 3, 2014 at 9:24 AM, <jchyjun@yahoo.com> wrote:
>
> WSJ has nice WWW page
> http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004where they posted updates on dividends from various companies. To me the
> most interesting parts are INCREASED and REDUCED in
> http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004#dividendsBsub-page.
>
> Is it possible to convert this info in Excel file?
>
=RCHGetHTMLTable("
http://online.wsj.com/mdc/public/page/2_3022-dividends.html",">%
Yield",-1,"",1)
On Sat, May 3, 2014 at 9:24 AM, <jchyjun@yahoo.com> wrote:
>
> WSJ has nice WWW page
> http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004where they posted updates on dividends from various companies. To me the
> most interesting parts are INCREASED and REDUCED in
> http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3004#dividendsBsub-page.
>
> Is it possible to convert this info in Excel file?
>
Sat May 3, 2014 12:47 pm (PDT) . Posted by:
ridgebacksexcel
Randy,
I am trying to extract the Next Earnings Report for Exxon from the Wall Street Journal as it seems to have better information than Yahoo.
I am using this formula for Exxon (XOM) but no luck so far.
=RCHGetTableCell("http://quotes.wsj.com/XOM/financials",1,">Next Earnings Report<")
Could you steer me in the right direct for this type of page.
Thanks.
I am trying to extract the Next Earnings Report for Exxon from the Wall Street Journal as it seems to have better information than Yahoo.
I am using this formula for Exxon (XOM) but no luck so far.
=RCHGetTableCell("http://quotes.wsj.com/XOM/financials",1,"
Could you steer me in the right direct for this type of page.
Thanks.
Sat May 3, 2014 12:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The data isn't presented in an HTML table, so RCHGetTableCell() won't do
the job. They use "div" and "span" tags to duplicate a table structure. Try:
=smfGetTagContent("http://quotes.wsj.com/XOM/financials","span",1,">Next
Earnings Report")
On Sat, May 3, 2014 at 12:47 PM, <tmallen2@bellsouth.net> wrote:
>
> I am trying to extract the Next Earnings Report for Exxon from the Wall
> Street Journal as it seems to have better information than Yahoo.
>
> I am using this formula for Exxon (XOM) but no luck so far.
>
> =RCHGetTableCell("http://quotes.wsj.com/XOM/financials",1,">Next Earnings
> Report<")
>
> Could you steer me in the right direct for this type of page.
>
the job. They use "div" and "span" tags to duplicate a table structure. Try:
=smfGetTagContent("http://quotes.wsj.com/XOM/financials","span",1,">Next
Earnings Report")
On Sat, May 3, 2014 at 12:47 PM, <tmallen2@bellsouth.net> wrote:
>
> I am trying to extract the Next Earnings Report for Exxon from the Wall
> Street Journal as it seems to have better information than Yahoo.
>
> I am using this formula for Exxon (XOM) but no luck so far.
>
> =RCHGetTableCell("http://quotes.wsj.com/XOM/financials",1,"
> Report<"
>
> Could you steer me in the right direct for this type of page.
>
Tidak ada komentar:
Posting Komentar