10 New Messages
Digest #2336
| 3a Is there a way to get the Morningstar Key-Ratios Template working? by "leiliao78@ymail.com" leiliao78@ymail.com 3b Re: Is there a way to get the Morningstar Key-Ratios Template workin by "Randy Harmelink" rharmelink 3c Re: Is there a way to get the Morningstar Key-Ratios Template workin by "Lei Liao" leiliao78@ymail.com |
Messages
Sun Sep 2, 2012 6:26 pm (PDT) . Posted by:
"andrewhills97" andrewhills97
Thanks Randy, much appreciated.
Have tried the smfUpdateDownloadTable macro and it is much better.
Is it possible to retrieve historical data using this file? for say 3,6,9, 12 months ago?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Most likely a temporary issue with Yahoo. Were you just running it? This
> time of morning can be sporadic with Yahoo, because of maintenance and
> updates that they do overnight.
>
> Given the nature of what you're doing, I would think the
> smfUpdateDownloadTable macro might be a better way to go (see the LINKS
> area of the group for more info).
>
> On Tue, Aug 28, 2012 at 4:56 AM, andrewhills97 <andrewhills97@...>wrote:
>
> > I retrieve data on about 40 companies using the template file called
> > SMF-Template-Yahoo-Key-Statistics. I use a macro which copies tickers in
> > Column A into the template and then copies the page into a new page titled
> > with the corresponding ticker.
> >
> > Until today this macro has been running quickly and successfully on Excel
> > 2007. I updated to Excel 2010 today and its now running very slow and most
> > of the time stalling before completion. Have you come across this problem
> > before? any advice would be much appreciated.
> >
>
Have tried the smfUpdateDownloadTa
Is it possible to retrieve historical data using this file? for say 3,6,9, 12 months ago?
--- In smf_addin@yahoogrou
>
> Most likely a temporary issue with Yahoo. Were you just running it? This
> time of morning can be sporadic with Yahoo, because of maintenance and
> updates that they do overnight.
>
> Given the nature of what you're doing, I would think the
> smfUpdateDownloadTa
> area of the group for more info).
>
> On Tue, Aug 28, 2012 at 4:56 AM, andrewhills97 <andrewhills97@
>
> > I retrieve data on about 40 companies using the template file called
> > SMF-Template-
> > Column A into the template and then copies the page into a new page titled
> > with the corresponding ticker.
> >
> > Until today this macro has been running quickly and successfully on Excel
> > 2007. I updated to Excel 2010 today and its now running very slow and most
> > of the time stalling before completion. Have you come across this problem
> > before? any advice would be much appreciated.
> >
>
Sun Sep 2, 2012 6:27 pm (PDT) . Posted by:
"andrewhills97" andrewhills97
Thanks for your advice
--- In smf_addin@yahoogroups.com , zarathustra_winced@... wrote:
>
> What kind of processor do you have? Go to the File tab, Options, Advanced in Excel 2010 and make sure the Enable Multi Threaded Calculation setting is appropriate for your processor. When I used to run excel 2010 on an old pentium IV, it would bog down to a crawl when multi-threaded calc was enabled. For multi-core, make sure the settings make sense. This has helped me in the past, but your problem may be something different.
>
> K
> Sent via BlackBerry by AT&T
>
> -----Original Message-----
> From: "andrewhills97" <andrewhills97@...>
> Sender: smf_addin@yahoogroups.com
> Date: Tue, 28 Aug 2012 11:56:33
> To: <smf_addin@yahoogroups.com >
> Reply-To: smf_addin@yahoogroups.com
> Subject: [smf_addin] SMF-Template-Yahoo-Key-Statistics
>
> I retrieve data on about 40 companies using the template file called SMF-Template-Yahoo-Key-Statistics. I use a macro which copies tickers in Column A into the template and then copies the page into a new page titled with the corresponding ticker.
>
> Until today this macro has been running quickly and successfully on Excel 2007. I updated to Excel 2010 today and its now running very slow and most of the time stalling before completion. Have you come across this problem before? any advice would be much appreciated.
>
> File attached.
>
> Thanks and regards, Andrew
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
--- In smf_addin@yahoogrou
>
> What kind of processor do you have? Go to the File tab, Options, Advanced in Excel 2010 and make sure the Enable Multi Threaded Calculation setting is appropriate for your processor. When I used to run excel 2010 on an old pentium IV, it would bog down to a crawl when multi-threaded calc was enabled. For multi-core, make sure the settings make sense. This has helped me in the past, but your problem may be something different.
>
> K
> Sent via BlackBerry by AT&T
>
> -----Original Message-----
> From: "andrewhills97" <andrewhills97@
> Sender: smf_addin@yahoogrou
> Date: Tue, 28 Aug 2012 11:56:33
> To: <smf_addin@yahoogrou
> Reply-To: smf_addin@yahoogrou
> Subject: [smf_addin] SMF-Template-
>
> I retrieve data on about 40 companies using the template file called SMF-Template-
>
> Until today this macro has been running quickly and successfully on Excel 2007. I updated to Excel 2010 today and its now running very slow and most of the time stalling before completion. Have you come across this problem before? any advice would be much appreciated.
>
> File attached.
>
> Thanks and regards, Andrew
>
>
>
> ------------
>
> Yahoo! Groups Links
>
Sun Sep 2, 2012 6:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can get the 3-, 6-, and 12-month performance from MSN. But it wouldn't
be a good way to get data from Yahoo's historical quotes, since each data
item would require an Internet access.
On Sun, Sep 2, 2012 at 6:26 PM, andrewhills97 <andrewhills97@yahoo.com >wrote:
>
> Have tried the smfUpdateDownloadTable macro and it is much better.
>
> Is it possible to retrieve historical data using this file? for say 3,6,9,
> 12 months ago?
>
be a good way to get data from Yahoo's historical quotes, since each data
item would require an Internet access.
On Sun, Sep 2, 2012 at 6:26 PM, andrewhills97 <andrewhills97@
>
> Have tried the smfUpdateDownloadTa
>
> Is it possible to retrieve historical data using this file? for say 3,6,9,
> 12 months ago?
>
Sun Sep 2, 2012 8:27 pm (PDT) . Posted by:
"andrewhills97" andrewhills97
I dont mean historical price data (if thats what you are referring to), I mean Element # by date.
Thanks and regards,
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You can get the 3-, 6-, and 12-month performance from MSN. But it wouldn't
> be a good way to get data from Yahoo's historical quotes, since each data
> item would require an Internet access.
>
> On Sun, Sep 2, 2012 at 6:26 PM, andrewhills97 <andrewhills97@...>wrote:
>
> >
> > Have tried the smfUpdateDownloadTable macro and it is much better.
> >
> > Is it possible to retrieve historical data using this file? for say 3,6,9,
> > 12 months ago?
> >
>
Thanks and regards,
--- In smf_addin@yahoogrou
>
> You can get the 3-, 6-, and 12-month performance from MSN. But it wouldn't
> be a good way to get data from Yahoo's historical quotes, since each data
> item would require an Internet access.
>
> On Sun, Sep 2, 2012 at 6:26 PM, andrewhills97 <andrewhills97@
>
> >
> > Have tried the smfUpdateDownloadTa
> >
> > Is it possible to retrieve historical data using this file? for say 3,6,9,
> > 12 months ago?
> >
>
Sun Sep 2, 2012 8:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Nah. Point-in-time data costs big money.
On Sun, Sep 2, 2012 at 8:27 PM, andrewhills97 <andrewhills97@yahoo.com >wrote:
> I dont mean historical price data (if thats what you are referring to), I
> mean Element # by date.
> > >
> > > Have tried the smfUpdateDownloadTable macro and it is much better.
> > >
> > > Is it possible to retrieve historical data using this file? for say
> 3,6,9,
> > > 12 months ago?
>
On Sun, Sep 2, 2012 at 8:27 PM, andrewhills97 <andrewhills97@
> I dont mean historical price data (if thats what you are referring to), I
> mean Element # by date.
> > >
> > > Have tried the smfUpdateDownloadTa
> > >
> > > Is it possible to retrieve historical data using this file? for say
> 3,6,9,
> > > 12 months ago?
>
Sun Sep 2, 2012 6:30 pm (PDT) . Posted by:
"pharnsbe" pharnsbe
There are a number of premium/institutional data providers that would have what you need. They are all very expensive though:
https://www.globalfinancialdata.com/Databases/Data.html#Equities_to_1693
http://www.compustat.com/Total_Return/
http://www.crsp.com/
I'd start with Shillers website as his links are free: http://www.econ.yale.edu/~shiller/data.htm
Then try some of the better retail providers:
http://www.csidata.com/
http://www.metastock.com/products/endofday/reutersdatalink/?overview
http://premiumdata.net/
Also, not sure if AAII would have this but it's worth a check.
--- In smf_addin@yahoogroups.com , "Minh" <minh0279@...> wrote:
>
> Hi pharnsbe and group,
>
> Thank you very much for the link http://www.standardandpoors.com/indices/sp-500/en/us/?indexId=spusa-500-usduf--p-us-l-- . I clicked "Dividend Rate Change" – "Payouts and Yields" worksheet and I see the dividend payout from 03/31/1977 quarterly. Anyone know how I can get the dividend payout more further such as from 1957?
>
> Another question is when I clicked http://www.multpl.com/s-p-500-dividend/table?f=m I am confused about the numbers. Why the monthly dividend here is much higher than the quarterly dividend on the first link?
>
> Thanks
>
> Minh
>
> --- In smf_addin@yahoogroups.com , "pharnsbe" <harnsberger@> wrote:
> >
> > Check out the S&P website:
> > http://www.standardandpoors.com/indices/sp-500/en/us/?indexId=spusa-500-usduf--p-us-l--
> >
> > If you click on the "Download Index Data" link there's a list of Excel spreadsheets containing historical dividend info.
> >
> >
> > --- In smf_addin@yahoogroups.com , "Minh" <minh0279@> wrote:
> > >
> > > hi all,
> > >
> > > I am looking for the S&P 500 historical daily dividend. Please let me know if you know how to get it.
> > >
> > > Thanks
> > >
> > > Minh
> > >
> >
>
https://www.
http://www.compusta
http://www.crsp.
I'd start with Shillers website as his links are free: http://www.econ.
Then try some of the better retail providers:
http://www.csidata.
http://www.metastoc
http://premiumdata.
Also, not sure if AAII would have this but it's worth a check.
--- In smf_addin@yahoogrou
>
> Hi pharnsbe and group,
>
> Thank you very much for the link http://www.standard
>
> Another question is when I clicked http://www.multpl.
>
> Thanks
>
> Minh
>
> --- In smf_addin@yahoogrou
> >
> > Check out the S&P website:
> > http://www.standard
> >
> > If you click on the "Download Index Data" link there's a list of Excel spreadsheets containing historical dividend info.
> >
> >
> > --- In smf_addin@yahoogrou
> > >
> > > hi all,
> > >
> > > I am looking for the S&P 500 historical daily dividend. Please let me know if you know how to get it.
> > >
> > > Thanks
> > >
> > > Minh
> > >
> >
>
Sun Sep 2, 2012 8:56 pm (PDT) . Posted by:
"leiliao78@ymail.com" leiliao78@ymail.com
Hi Randy,
Can you fix the Morningstar Key Ratios Template you designed? Cos the figures for Profit Margin and Profitability are not working. I have no ideas what's wrong with that.
Thanks
Lei
Can you fix the Morningstar Key Ratios Template you designed? Cos the figures for Profit Margin and Profitability are not working. I have no ideas what's wrong with that.
Thanks
Lei
Sun Sep 2, 2012 9:19 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Those elements have all been obsoleted, because they are now on a web page
that MorningStar dynamically generates.
For an alternative, see:
http://finance.groups.yahoo.com/group/smf_addin/message/19776
On Sun, Sep 2, 2012 at 8:56 PM, leiliao78@ymail.com <liaolei78@gmail.com >wrote:
>
> Can you fix the Morningstar Key Ratios Template you designed? Cos the
> figures for Profit Margin and Profitability are not working. I have no
> ideas what's wrong with that.
>
that MorningStar dynamically generates.
For an alternative, see:
http://finance.
On Sun, Sep 2, 2012 at 8:56 PM, leiliao78@ymail.
>
> Can you fix the Morningstar Key Ratios Template you designed? Cos the
> figures for Profit Margin and Profitability are not working. I have no
> ideas what's wrong with that.
>
Sun Sep 2, 2012 9:22 pm (PDT) . Posted by:
"Lei Liao" leiliao78@ymail.com
Oh, I see.
Thanks a lot,
Thanks a lot,
Sun Sep 2, 2012 9:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
For the #NAME? error, see the "Location errors" item in the LINKS area of
the Yahoo group.
Also, you may want to check out the AdvFN item there, to see if your IE
settings may be the cause of your errors.
And, see: http://finance.groups.yahoo.com/group/smf_addin/message/18693
You would use "uk" instead of "cn".
On Sat, Sep 1, 2012 at 7:33 PM, valuhunteruk <calum@valuhunteruk.com > wrote:
>
> I am a user from the UK and I have been using the smfGetAdvFNElement
> function for a while successfully (as part of OSV if that matters). I am
> now getting the standard "Error" message when I use it and the #NAME error
> with the template ADVFN data dump.
>
> I have tried replacing the " & kAdvFNPrefix & " with uk (putting it
> directly into the code) but this has not solved the problem although
> believe that when I started using this SMF in early 2011 this "prefix
> switch" solved the problem. Unfortunately, this is not the case today.
>
> I am able to use the RCHGetTableCell on uk.advfn.com but
> RCHGetElementNumber is not working with ADVFN either (in fact, as far as I
> can tell, only Google is working with RCHGetElementNumber).
>
> Tbh, I am more than happy with RCHGetTableCell and RCHGetWebData however,
> the problem is only being able to switch tickers through editing the code
> directly which is obviously very cumbersome. As far as I am aware this
> can't be circumvented (before discovering SMF I spent many hours trying
> although I am not good with VB). If anyone knows a solution to this issue I
> would be grateful too.
>
the Yahoo group.
Also, you may want to check out the AdvFN item there, to see if your IE
settings may be the cause of your errors.
And, see: http://finance.
You would use "uk" instead of "cn".
On Sat, Sep 1, 2012 at 7:33 PM, valuhunteruk <calum@valuhunteruk.
>
> I am a user from the UK and I have been using the smfGetAdvFNElement
> function for a while successfully (as part of OSV if that matters). I am
> now getting the standard "Error" message when I use it and the #NAME error
> with the template ADVFN data dump.
>
> I have tried replacing the " & kAdvFNPrefix & " with uk (putting it
> directly into the code) but this has not solved the problem although
> believe that when I started using this SMF in early 2011 this "prefix
> switch" solved the problem. Unfortunately, this is not the case today.
>
> I am able to use the RCHGetTableCell on uk.advfn.com but
> RCHGetElementNumber is not working with ADVFN either (in fact, as far as I
> can tell, only Google is working with RCHGetElementNumber
>
> Tbh, I am more than happy with RCHGetTableCell and RCHGetWebData however,
> the problem is only being able to switch tickers through editing the code
> directly which is obviously very cumbersome. As far as I am aware this
> can't be circumvented (before discovering SMF I spent many hours trying
> although I am not good with VB). If anyone knows a solution to this issue I
> would be grateful too.
>
Tidak ada komentar:
Posting Komentar