7 New Messages
Digest #2414
Messages
Tue Nov 27, 2012 4:44 am (PST) . Posted by:
"mic_peg" mic_peg
hi,i try using this formula but doesn't work on Dow Jones. It works for FTSE, London.
=smfPricesByDates("^DJI","31-jan-2005") = not working
=smfPricesByDates("^FTSE","31-jan-2005") = 4852.30
tks !
=smfPricesByDates(
=smfPricesByDates(
tks !
Tue Nov 27, 2012 5:21 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but Dow Jones has restricted access to their indexes, so Yahoo can
no longer offer such data in the CSV file format that the function uses.
On Tue, Nov 27, 2012 at 5:44 AM, mic_peg <mic_peg@yahoo.com > wrote:
> hi,i try using this formula but doesn't work on Dow Jones. It works for
> FTSE, London.
>
> =smfPricesByDates("^DJI","31-jan-2005") = not working
>
> =smfPricesByDates("^FTSE","31-jan-2005") = 4852.30
>
no longer offer such data in the CSV file format that the function uses.
On Tue, Nov 27, 2012 at 5:44 AM, mic_peg <mic_peg@yahoo.
> hi,i try using this formula but doesn't work on Dow Jones. It works for
> FTSE, London.
>
> =smfPricesByDates(
>
> =smfPricesByDates(
>
Tue Nov 27, 2012 5:14 am (PST) . Posted by:
"mrpgdvb" mrpgdvb
Hi all,
I am new to your group and was wondering if anyone has set up a program to download the morning star fair value estimates and the recommended buy under price and transfer this to an excel spreadsheet.
cheers
Darryl
I am new to your group and was wondering if anyone has set up a program to download the morning star fair value estimates and the recommended buy under price and transfer this to an excel spreadsheet.
cheers
Darryl
Tue Nov 27, 2012 5:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
There are several files containing the proprietary items for people with
subscriptions. For example:
RCHGetTableCell-Template-Morningstar-Stock-Grades.xls
On Tue, Nov 27, 2012 at 1:33 AM, mrpgdvb <darrylbrizan@gmail.com > wrote:
> I am new to your group and was wondering if anyone has set up a program to
> download the morning star fair value estimates and the recommended buy
> under price and transfer this to an excel spreadsheet.
>
subscriptions. For example:
RCHGetTableCell-
On Tue, Nov 27, 2012 at 1:33 AM, mrpgdvb <darrylbrizan@
> I am new to your group and was wondering if anyone has set up a program to
> download the morning star fair value estimates and the recommended buy
> under price and transfer this to an excel spreadsheet.
>
Tue Nov 27, 2012 11:37 pm (PST) . Posted by:
"Darryl Brizan" mrpgdvb
Hi Randy,
Thanks for the very fast reply and info. I did the following
1. Downloaded the excel
spreadsheet RCHGetTableCell-Template-Morningstar-Stock-Grades.xls from your
website
2. entered data ,import external data, new web query, input the url of the
morningstar site portfolio section and input my premium membership
password. The site opened into my portfolio.
3. The spreadsheet showed results for AAPL as an example.
4. I entered MSFT or other stock symbols and all I got was ###### across
each of the cells;.I entered f9 to recalc but nothing happened
Do you know what I may have done wrong. I am using MS excel 2003.
cheers
Darryl
On Tue, Nov 27, 2012 at 5:20 AM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> There are several files containing the proprietary items for people with
> subscriptions. For example:
>
> RCHGetTableCell-Template-Morningstar-Stock-Grades.xls
>
> On Tue, Nov 27, 2012 at 1:33 AM, mrpgdvb <darrylbrizan@gmail.com > wrote:
>
>> I am new to your group and was wondering if anyone has set up a program
>> to download the morning star fair value estimates and the recommended buy
>> under price and transfer this to an excel spreadsheet.
>>
>
>
>
--
Cheers,
Darryl V. Brizan
7938 St John Cres
Prince George BC. V2N 4H7
res 250-964-6621 cel 250-961-5208
wk 250-562-1977 fax 250-562-1967
wk email: dbrizan@lmengineering.bc.ca
Thanks for the very fast reply and info. I did the following
1. Downloaded the excel
spreadsheet RCHGetTableCell-
website
2. entered data ,import external data, new web query, input the url of the
morningstar site portfolio section and input my premium membership
password. The site opened into my portfolio.
3. The spreadsheet showed results for AAPL as an example.
4. I entered MSFT or other stock symbols and all I got was ###### across
each of the cells;.I entered f9 to recalc but nothing happened
Do you know what I may have done wrong. I am using MS excel 2003.
cheers
Darryl
On Tue, Nov 27, 2012 at 5:20 AM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> There are several files containing the proprietary items for people with
> subscriptions. For example:
>
> RCHGetTableCell-
>
> On Tue, Nov 27, 2012 at 1:33 AM, mrpgdvb <darrylbrizan@
>
>> I am new to your group and was wondering if anyone has set up a program
>> to download the morning star fair value estimates and the recommended buy
>> under price and transfer this to an excel spreadsheet.
>>
>
>
>
--
Cheers,
Darryl V. Brizan
7938 St John Cres
Prince George BC. V2N 4H7
res 250-964-6621 cel 250-961-5208
wk 250-562-1977 fax 250-562-1967
wk email: dbrizan@lmengineeri
Wed Nov 28, 2012 3:26 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Is it possible you had location errors (i.e. unresolved links)? See the
LINKS area of the group for more info. What does your formula in cell C12
look like?
While in the LINKS area of the group, check out the smfForceRecalculation
items. F9 is not the proper way to recalc the add-in functions.
On Wed, Nov 28, 2012 at 12:37 AM, Darryl Brizan <darrylbrizan@gmail.com >wrote:
> Thanks for the very fast reply and info. I did the following
> 1. Downloaded the excel
> spreadsheet RCHGetTableCell-Template-Morningstar-Stock-Grades.xls from your
> website
> 2. entered data ,import external data, new web query, input the url of the
> morningstar site portfolio section and input my premium membership
> password. The site opened into my portfolio.
> 3. The spreadsheet showed results for AAPL as an example.
> 4. I entered MSFT or other stock symbols and all I got was ###### across
> each of the cells;.I entered f9 to recalc but nothing happened
> Do you know what I may have done wrong. I am using MS excel 2003.
>
>
LINKS area of the group for more info. What does your formula in cell C12
look like?
While in the LINKS area of the group, check out the smfForceRecalculati
items. F9 is not the proper way to recalc the add-in functions.
On Wed, Nov 28, 2012 at 12:37 AM, Darryl Brizan <darrylbrizan@
> Thanks for the very fast reply and info. I did the following
> 1. Downloaded the excel
> spreadsheet RCHGetTableCell-
> website
> 2. entered data ,import external data, new web query, input the url of the
> morningstar site portfolio section and input my premium membership
> password. The site opened into my portfolio.
> 3. The spreadsheet showed results for AAPL as an example.
> 4. I entered MSFT or other stock symbols and all I got was ###### across
> each of the cells;.I entered f9 to recalc but nothing happened
> Do you know what I may have done wrong. I am using MS excel 2003.
>
>
Tue Nov 27, 2012 5:19 am (PST) . Posted by:
"lezm001" lezm001
Thanks, all set.
--- In smf_addin@yahoogrou
>
> Check the AdvFN item in the LINKS area of the group. Also, item 9.4.2.
>
> On Mon, Nov 26, 2012 at 7:20 AM, lezm001 <dlezman@...
>
> > The SMF addin was working fine for me until I upgraded from IE8 to IE9. I
> > recall having to change something in the internet explorer setting before
> > so the file opens without errors. Does anyone know what IE settings need
> > to change?
> >
>
Tidak ada komentar:
Posting Komentar