9 New Messages
Digest #2273
4b
Re: Can't retrieve the MSN Company Name using =RCHGetElementNumber(T by "Randy Harmelink" rharmelink
5a
SMF Template Yahoo Historical Quotes MultiSymbol Run Time Error - Ne by "oscar.goodman" oscar.goodman
5b
Re: SMF Template Yahoo Historical Quotes MultiSymbol Run Time Error by "Randy Harmelink" rharmelink
Messages
Wed Jul 11, 2012 7:15 am (PDT) . Posted by:
"lexstar" lexstar
Anyone know where I can get the total return historical data for the Barclays US Aggregate Bond Index?
Wed Jul 11, 2012 8:34 am (PDT) . Posted by:
"davidphillips2976" davidphillips2976
I am trying to locate a current version of the Morningstar Ratings Retrieval Worksheet that uses SMF. It retrieves Morningstar ratings for stocks and was created in Excel 2007. A user must be logged in to the premium section of Morningstar for this to work.
The version I have will no longer get the company name but everything else works fine.
Thanks very much.
The version I have will no longer get the company name but everything else works fine.
Thanks very much.
Wed Jul 11, 2012 8:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What is the formula for getting company name? I can't recall anything that
would get name from MorningStar.
On Wed, Jul 11, 2012 at 8:24 AM, davidphillips2976 <david45@bellsouth.net >wrote:
> I am trying to locate a current version of the Morningstar Ratings
> Retrieval Worksheet that uses SMF. It retrieves Morningstar ratings for
> stocks and was created in Excel 2007. A user must be logged in to the
> premium section of Morningstar for this to work.
>
> The version I have will no longer get the company name but everything else
> works fine.
>
> Thanks very much.
>
would get name from MorningStar.
On Wed, Jul 11, 2012 at 8:24 AM, davidphillips2976 <david45@bellsouth.
> I am trying to locate a current version of the Morningstar Ratings
> Retrieval Worksheet that uses SMF. It retrieves Morningstar ratings for
> stocks and was created in Excel 2007. A user must be logged in to the
> premium section of Morningstar for this to work.
>
> The version I have will no longer get the company name but everything else
> works fine.
>
> Thanks very much.
>
Wed Jul 11, 2012 9:09 am (PDT) . Posted by:
"christianilson79" christianilson79
Hey everyone,
when I try to retrieve data from Google Finance for the range that is saved in smf-elements-3 I constantly get an error. The same goes for higher codes, e.g. Morning Star. Is there an updated Version of the file or could someone please explain me how to update it myself (if that is possible with my limited knowledge).
Thanks for your help and the great tool, I hope at some point I can give something back an contribute to further imrpove it.
cheers,
chris
when I try to retrieve data from Google Finance for the range that is saved in smf-elements-
Thanks for your help and the great tool, I hope at some point I can give something back an contribute to further imrpove it.
cheers,
chris
Wed Jul 11, 2012 9:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The last update of the smf-elements-3.txt file was 2011-02-16, so it hasn't
been changed since version 2.1.2012.02.02 of the add-in. Are you current
with that version of the add-in?
On Wed, Jul 11, 2012 at 9:09 AM, christianilson79 <
christian.weitert@googlemail.com > wrote:
>
> when I try to retrieve data from Google Finance for the range that is
> saved in smf-elements-3 I constantly get an error. The same goes for higher
> codes, e.g. Morning Star. Is there an updated Version of the file or could
> someone please explain me how to update it myself (if that is possible with
> my limited knowledge).
> Thanks for your help and the great tool, I hope at some point I can give
> something back an contribute to further imrpove it.
>
been changed since version 2.1.2012.02.
with that version of the add-in?
On Wed, Jul 11, 2012 at 9:09 AM, christianilson79 <
christian.weitert@
>
> when I try to retrieve data from Google Finance for the range that is
> saved in smf-elements-
> codes, e.g. Morning Star. Is there an updated Version of the file or could
> someone please explain me how to update it myself (if that is possible with
> my limited knowledge).
> Thanks for your help and the great tool, I hope at some point I can give
> something back an contribute to further imrpove it.
>
Wed Jul 11, 2012 1:28 pm (PDT) . Posted by:
"ts63033" ts63033
Randy,
I saw a prior post about how to correct an MSN data retrieval problem by using the updated elements definitions files. I replaced all of the old files with the new files but still am not able to retrieve the MSN Company Name using =RCHGetElementNumber(Ticker,13862). Any idea why this is not working?
I saw a prior post about how to correct an MSN data retrieval problem by using the updated elements definitions files. I replaced all of the old files with the new files but still am not able to retrieve the MSN Company Name using =RCHGetElementNumbe
Wed Jul 11, 2012 1:33 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Are you using an older version of the add-in? That element definition
requires the 2.1.2012.02.02 version or later.
On Wed, Jul 11, 2012 at 11:06 AM, ts63033 <mdlarson5@comcast.net > wrote:
>
> I saw a prior post about how to correct an MSN data retrieval problem by
> using the updated elements definitions files. I replaced all of the old
> files with the new files but still am not able to retrieve the MSN Company
> Name using =RCHGetElementNumber(Ticker,13862). Any idea why this is not
> working?
>
requires the 2.1.2012.02.
On Wed, Jul 11, 2012 at 11:06 AM, ts63033 <mdlarson5@comcast.
>
> I saw a prior post about how to correct an MSN data retrieval problem by
> using the updated elements definitions files. I replaced all of the old
> files with the new files but still am not able to retrieve the MSN Company
> Name using =RCHGetElementNumbe
> working?
>
Wed Jul 11, 2012 1:28 pm (PDT) . Posted by:
"oscar.goodman" oscar.goodman
Hi,
Am working with the SMF Template Yahoo Historical Quotes MultiSymbol (Excel spreadsheet)
Am receiving the following error:
Run-time error '1004':
Cannont run the macro "Networkdays'. The macro may not be available in this workbook or all macros may be disabled.
Macros are enabled and the analysis toolpak is installed.
Any ideas to solve this?
Thanks.
Am working with the SMF Template Yahoo Historical Quotes MultiSymbol (Excel spreadsheet)
Am receiving the following error:
Run-time error '1004':
Cannont run the macro "Networkdays'
Macros are enabled and the analysis toolpak is installed.
Any ideas to solve this?
Thanks.
Wed Jul 11, 2012 1:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'll need to contact the uploader of the file. It's not one of mine.
On Wed, Jul 11, 2012 at 11:01 AM, oscar.goodman <oscar.goodman@yahoo.com >wrote:
>
> Am working with the SMF Template Yahoo Historical Quotes MultiSymbol
> (Excel spreadsheet)
>
> Am receiving the following error:
> Run-time error '1004':
> Cannont run the macro "Networkdays'. The macro may not be available in
> this workbook or all macros may be disabled.
>
> Macros are enabled and the analysis toolpak is installed.
>
> Any ideas to solve this?
>
On Wed, Jul 11, 2012 at 11:01 AM, oscar.goodman <oscar.goodman@
>
> Am working with the SMF Template Yahoo Historical Quotes MultiSymbol
> (Excel spreadsheet)
>
> Am receiving the following error:
> Run-time error '1004':
> Cannont run the macro "Networkdays'
> this workbook or all macros may be disabled.
>
> Macros are enabled and the analysis toolpak is installed.
>
> Any ideas to solve this?
>
Tidak ada komentar:
Posting Komentar