15 New Messages
Digest #2415
Messages
Wed Nov 28, 2012 6:58 am (PST) . Posted by:
"mrnervez" mrnervez
I want an Excel sheet where a macro automatically refreshes the following datas:
US CPI
US BAA Bond Yield
US Industrial Production
S&P 500 index
CBOE VIX volatility index
Do you know how to go about doin this? I know I can get many of these fith the FRED Excel plugin, but I wish it was possible to control it through macro instead of through the plugin.
US CPI
US BAA Bond Yield
US Industrial Production
S&P 500 index
CBOE VIX volatility index
Do you know how to go about doin this? I know I can get many of these fith the FRED Excel plugin, but I wish it was possible to control it through macro instead of through the plugin.
Wed Nov 28, 2012 7:07 am (PST) . Posted by:
"Randy Harmelink" rharmelink
This group would just be another plugin solution. It would mainly be a
matter of finding a source for the data items that the add-in can extract
the data from. For example, to get S&P 500 Index:
=RCHGetYahooQuotes("^GSPC","l1")
You could always write a macro to invoke the add-in functions. I think it
just complicates things though for five presumably simple items.
On Wed, Nov 28, 2012 at 5:10 AM, mrnervez <oystein@nerva.priv.no > wrote:
> I want an Excel sheet where a macro automatically refreshes the following
> datas:
>
> US CPI
> US BAA Bond Yield
> US Industrial Production
> S&P 500 index
> CBOE VIX volatility index
>
> Do you know how to go about doin this? I know I can get many of these fith
> the FRED Excel plugin, but I wish it was possible to control it through
> macro instead of through the plugin.
>
matter of finding a source for the data items that the add-in can extract
the data from. For example, to get S&P 500 Index:
=RCHGetYahooQuotes(
You could always write a macro to invoke the add-in functions. I think it
just complicates things though for five presumably simple items.
On Wed, Nov 28, 2012 at 5:10 AM, mrnervez <oystein@nerva.
> I want an Excel sheet where a macro automatically refreshes the following
> datas:
>
> US CPI
> US BAA Bond Yield
> US Industrial Production
> S&P 500 index
> CBOE VIX volatility index
>
> Do you know how to go about doin this? I know I can get many of these fith
> the FRED Excel plugin, but I wish it was possible to control it through
> macro instead of through the plugin.
>
Wed Nov 28, 2012 12:36 pm (PST) . Posted by:
"Jacob Jose" pepecan47
Randy, Morningstar elements 13961 to 13970 are not working anymore.
Is there another place/element where I can get the average p/e ratio for the last 3/5/10 years?
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, October 10, 2012 2:20:13 PM
Subject: Re: [smf_addin] MorningStar p/e values
The web page you cite has data placed on it dynamically, so the add-in can't extract data from it.
Element #13971 comes from this web page:
http://quicktake.morningstar.com/stocknet/Valuation10.aspx?Symbol=MCD
You could compute your own 5-year average from the data there.
On Wed, Oct 10, 2012 at 11:13 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
>This is the page I am looking at :
>http://financials.morningstar.com/valuation/price-ratio.html?t=MCD®ion=USA&culture=en-US
>
>Element 13971 (TTM p/e) works.
>Element 13946 (5y avg p/e) gives "obsolete".
>Both are in the same above web page.
>
Is there another place/element where I can get the average p/e ratio for the last 3/5/10 years?
Regards,
Jose L. Jacob
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Wednesday, October 10, 2012 2:20:13 PM
Subject: Re: [smf_addin] MorningStar p/e values
The web page you cite has data placed on it dynamically, so the add-in can't extract data from it.
Element #13971 comes from this web page:
http://quicktake.
You could compute your own 5-year average from the data there.
On Wed, Oct 10, 2012 at 11:13 AM, Jacob Jose <pepecan47@yahoo.
>
>This is the page I am looking at :
>http://financials.
>
>Element 13971 (TTM p/e) works.
>Element 13946 (5y avg p/e) gives "obsolete".
>Both are in the same above web page.
>
Wed Nov 28, 2012 1:16 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Morningstar changed the web page to be dynamically generated, so the
elements are no longer available.
You can retrieve 10 years of closing P/E ratios from AdvFN and compute your
own averages.
On Wed, Nov 28, 2012 at 1:36 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> Morningstar elements 13961 to 13970 are not working anymore.
>
> Is there another place/element where I can get the average p/e ratio for
> the last 3/5/10 years?
>
>
elements are no longer available.
You can retrieve 10 years of closing P/E ratios from AdvFN and compute your
own averages.
On Wed, Nov 28, 2012 at 1:36 PM, Jacob Jose <pepecan47@yahoo.
>
> Morningstar elements 13961 to 13970 are not working anymore.
>
> Is there another place/element where I can get the average p/e ratio for
> the last 3/5/10 years?
>
>
Wed Nov 28, 2012 4:40 pm (PST) . Posted by:
"Nat Turner - Gmail" naturn3
Randy,
Does this mean that all of the Morningstar functions are going to stop working?
Nat
Regards, Nat Turner
<mailto:nruttan@gmail.com > nruttan@gmail.com
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Wednesday, November 28, 2012 3:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] MorningStar p/e values
Morningstar changed the web page to be dynamically generated, so the elements are no longer available.
You can retrieve 10 years of closing P/E ratios from AdvFN and compute your own averages.
On Wed, Nov 28, 2012 at 1:36 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
Morningstar elements 13961 to 13970 are not working anymore.
Is there another place/element where I can get the average p/e ratio for the last 3/5/10 years?
Does this mean that all of the Morningstar functions are going to stop working?
Nat
Regards, Nat Turner
<mailto:nruttan@gmail.
From: smf_addin@yahoogrou
Sent: Wednesday, November 28, 2012 3:16 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] MorningStar p/e values
Morningstar changed the web page to be dynamically generated, so the elements are no longer available.
You can retrieve 10 years of closing P/E ratios from AdvFN and compute your own averages.
On Wed, Nov 28, 2012 at 1:36 PM, Jacob Jose <pepecan47@yahoo.
Morningstar elements 13961 to 13970 are not working anymore.
Is there another place/element where I can get the average p/e ratio for the last 3/5/10 years?
Wed Nov 28, 2012 5:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Eventually, I think so...
You can get a lot of data with:
=smfGetCSVFile("
http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM ")
On Wed, Nov 28, 2012 at 5:00 PM, Nat Turner - Gmail <nruttan@gmail.com >wrote:
>
>
> Does this mean that all of the Morningstar functions are going to stop
> working?****
>
>
>
You can get a lot of data with:
=smfGetCSVFile(
http://financials.
On Wed, Nov 28, 2012 at 5:00 PM, Nat Turner - Gmail <nruttan@gmail.
>
>
> Does this mean that all of the Morningstar functions are going to stop
> working?****
>
>
>
Wed Nov 28, 2012 12:54 pm (PST) . Posted by:
"invesco88" invesco88
Is there any way to extract all of the earnings announcements (fiscal qtr, eps est, eps actual, prev yr actual, calendar date) from the earnings.com website? In the earnings.com spreadsheet only the last 23 announcements are available.
Wed Nov 28, 2012 1:19 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try something like:
=RCHGetHTMLTable("http://www.earnings.com/company.asp?client=cb&ticker=IBM ",">Earnings
Releases",1,"",2)
On Wed, Nov 28, 2012 at 1:54 PM, invesco88 <franklin.forward@gmail.com >wrote:
> Is there any way to extract all of the earnings announcements (fiscal qtr,
> eps est, eps actual, prev yr actual, calendar date) from the earnings.comwebsite? In the
> earnings.com spreadsheet only the last 23 announcements are available.
>
=RCHGetHTMLTable(
Releases",1,
On Wed, Nov 28, 2012 at 1:54 PM, invesco88 <franklin.forward@
> Is there any way to extract all of the earnings announcements (fiscal qtr,
> eps est, eps actual, prev yr actual, calendar date) from the earnings.comwebsite
> earnings.com spreadsheet only the last 23 announcements are available.
>
Wed Nov 28, 2012 2:01 pm (PST) . Posted by:
"Roger Diaz" rogerdiazbernal
Hi Randy:
I only see "Symbol"
Roger
2012/11/28 Randy Harmelink <rharmelink@gmail.com >
> **
>
>
> Try something like:
>
> =RCHGetHTMLTable("http://www.earnings.com/company.asp?client=cb&ticker=IBM ",">Earnings
> Releases",1,"",2)
>
>
> On Wed, Nov 28, 2012 at 1:54 PM, invesco88 <franklin.forward@gmail.com >wrote:
>
>> Is there any way to extract all of the earnings announcements (fiscal
>> qtr, eps est, eps actual, prev yr actual, calendar date) from the
>> earnings.com website? In the earnings.com spreadsheet only the last 23
>> announcements are available.
>>
>
>
>
I only see "Symbol"
Roger
2012/11/28 Randy Harmelink <rharmelink@gmail.
> **
>
>
> Try something like:
>
> =RCHGetHTMLTable(
> Releases",1,
>
>
> On Wed, Nov 28, 2012 at 1:54 PM, invesco88 <franklin.forward@
>
>> Is there any way to extract all of the earnings announcements (fiscal
>> qtr, eps est, eps actual, prev yr actual, calendar date) from the
>> earnings.com website? In the earnings.com spreadsheet only the last 23
>> announcements are available.
>>
>
>
>
Wed Nov 28, 2012 3:01 pm (PST) . Posted by:
"invesco88" invesco88
Enter it as an array.
--- In smf_addin@yahoogroups.com , Roger Diaz <rogerdiazb@...> wrote:
>
> Hi Randy:
> I only see "Symbol"
>
> Roger
>
> 2012/11/28 Randy Harmelink <rharmelink@...>
>
> > **
> >
> >
> > Try something like:
> >
> > =RCHGetHTMLTable("http://www.earnings.com/company.asp?client=cb&ticker=IBM ",">Earnings
> > Releases",1,"",2)
> >
> >
> > On Wed, Nov 28, 2012 at 1:54 PM, invesco88 <franklin.forward@...>wrote:
> >
> >> Is there any way to extract all of the earnings announcements (fiscal
> >> qtr, eps est, eps actual, prev yr actual, calendar date) from the
> >> earnings.com website? In the earnings.com spreadsheet only the last 23
> >> announcements are available.
> >>
> >
> >
> >
>
--- In smf_addin@yahoogrou
>
> Hi Randy:
> I only see "Symbol"
>
> Roger
>
> 2012/11/28 Randy Harmelink <rharmelink@
>
> > **
> >
> >
> > Try something like:
> >
> > =RCHGetHTMLTable(
> > Releases",1,
> >
> >
> > On Wed, Nov 28, 2012 at 1:54 PM, invesco88 <franklin.forward@
> >
> >> Is there any way to extract all of the earnings announcements (fiscal
> >> qtr, eps est, eps actual, prev yr actual, calendar date) from the
> >> earnings.com website? In the earnings.com spreadsheet only the last 23
> >> announcements are available.
> >>
> >
> >
> >
>
Wed Nov 28, 2012 3:53 pm (PST) . Posted by:
"invesco88" invesco88
Randy is it possible to use the "ticker" named range in arrays? I have tried using the smfjoin function but I can't get it to work properly with the formula you provided. Thanks again.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try something like:
>
> =RCHGetHTMLTable("http://www.earnings.com/company.asp?client=cb&ticker=IBM ",">Earnings
> Releases",1,"",2)
>
> On Wed, Nov 28, 2012 at 1:54 PM, invesco88 <franklin.forward@...>wrote:
>
> > Is there any way to extract all of the earnings announcements (fiscal qtr,
> > eps est, eps actual, prev yr actual, calendar date) from the earnings.comwebsite? In the
> > earnings.com spreadsheet only the last 23 announcements are available.
> >
>
--- In smf_addin@yahoogrou
>
> Try something like:
>
> =RCHGetHTMLTable(
> Releases",1,
>
> On Wed, Nov 28, 2012 at 1:54 PM, invesco88 <franklin.forward@
>
> > Is there any way to extract all of the earnings announcements (fiscal qtr,
> > eps est, eps actual, prev yr actual, calendar date) from the earnings.comwebsite
> > earnings.com spreadsheet only the last 23 announcements are available.
> >
>
Wed Nov 28, 2012 4:23 pm (PST) . Posted by:
"Roger Diaz" rogerdiazbernal
Thanks Franklin, but How do I get this data from multiple stocks?
Roger
2012/11/28 invesco88 <franklin.forward@gmail.com >
> Randy is it possible to use the "ticker" named range in arrays? I have
> tried using the smfjoin function but I can't get it to work properly with
> the formula you provided. Thanks again.
Roger
2012/11/28 invesco88 <franklin.forward@
> Randy is it possible to use the "ticker" named range in arrays? I have
> tried using the smfjoin function but I can't get it to work properly with
> the formula you provided. Thanks again.
Wed Nov 28, 2012 5:11 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure what you're asking? The URL can only do one ticker symbol at a
time.
On Wed, Nov 28, 2012 at 4:53 PM, invesco88 <franklin.forward@gmail.com >wrote:
> Randy is it possible to use the "ticker" named range in arrays? I have
> tried using the smfjoin function but I can't get it to work properly with
> the formula you provided. Thanks again.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Try something like:
> >
> > =RCHGetHTMLTable("
> http://www.earnings.com/company.asp?client=cb&ticker=IBM ",">Earnings
> > Releases",1,"",2)
>
time.
On Wed, Nov 28, 2012 at 4:53 PM, invesco88 <franklin.forward@
> Randy is it possible to use the "ticker" named range in arrays? I have
> tried using the smfjoin function but I can't get it to work properly with
> the formula you provided. Thanks again.
>
> --- In smf_addin@yahoogrou
> >
> > Try something like:
> >
> > =RCHGetHTMLTable(
> http://www.earnings
> > Releases",1,
>
Wed Nov 28, 2012 5:11 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You'd need to do one function invocation for each stock.
On Wed, Nov 28, 2012 at 5:23 PM, Roger Diaz <rogerdiazb@gmail.com > wrote:
>
> How do I get this data from multiple stocks?
>
On Wed, Nov 28, 2012 at 5:23 PM, Roger Diaz <rogerdiazb@gmail.
>
> How do I get this data from multiple stocks?
>
Wed Nov 28, 2012 5:11 pm (PST) . Posted by:
"invesco88" invesco88
I would just put the array in separate worksheets. Although it may not be the easiest way it should work fine. You could use another worksheet to consolidate the data if you need to be able to compare them side by side.
--- In smf_addin@yahoogroups.com , Roger Diaz <rogerdiazb@...> wrote:
>
> Thanks Franklin, but How do I get this data from multiple stocks?
>
> Roger
>
> 2012/11/28 invesco88 <franklin.forward@...>
>
> > Randy is it possible to use the "ticker" named range in arrays? I have
> > tried using the smfjoin function but I can't get it to work properly with
> > the formula you provided. Thanks again.
>
--- In smf_addin@yahoogrou
>
> Thanks Franklin, but How do I get this data from multiple stocks?
>
> Roger
>
> 2012/11/28 invesco88 <franklin.forward@
>
> > Randy is it possible to use the "ticker" named range in arrays? I have
> > tried using the smfjoin function but I can't get it to work properly with
> > the formula you provided. Thanks again.
>
Tidak ada komentar:
Posting Komentar