5 New Messages
Digest #2511
Messages
Fri Feb 15, 2013 6:57 am (PST) . Posted by:
"Jacob Jose" pepecan47
I was using the following formula to get the M* fair value. It worked fine until yesterday:
=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?Country=USA&Symbol= "&A25,2,"Morningstar Rating",,,,1)
Now is giving me "Premium". I have a premium subscription and I am logon'ed lo M*.
Regards,
Jose L. Jacob
=RCHGetTableCell(
Now is giving me "Premium"
Regards,
Jose L. Jacob
Fri Feb 15, 2013 7:09 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Did you log in with the EXCEL Web Query process, or with IE? Something like
FireFox won't do it.
I just logged it, and your formula works fine for me.
On Fri, Feb 15, 2013 at 7:56 AM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
> I was using the following formula to get the M* fair value. It worked fine
> until yesterday:
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?Country=USA&Symbol= "&A25,2,"MorningstarRating",,,,1)
>
> Now is giving me "Premium". I have a premium subscription and I am
> logon'ed lo M*.
>
>
FireFox won't do it.
I just logged it, and your formula works fine for me.
On Fri, Feb 15, 2013 at 7:56 AM, Jacob Jose pepecan47@yahoo.
>
> I was using the following formula to get the M* fair value. It worked fine
> until yesterday:
>
> =RCHGetTableCell(
> http://quicktake.
>
> Now is giving me "Premium"
> logon'ed lo M*.
>
>
Fri Feb 15, 2013 8:04 am (PST) . Posted by:
"Jacob Jose" pepecan47
I rebooted my computer, log in to M* as usual using IE, but it seems that something happened with the cookie, because normally M* remembers me and I get log in when opening M* site. I had to enter userid and password.
Now it works as before. thx a lot.
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Friday, February 15, 2013 10:09:50 AM
Subject: Re: [smf_addin] Morningstar fair value
Did you log in with the EXCEL Web Query process, or with IE? Something like FireFox won't do it.
I just logged it, and your formula works fine for me.
On Fri, Feb 15, 2013 at 7:56 AM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
>I was using the following formula to get the M* fair value. It worked fine until yesterday:
>
>=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?Country=USA&Symbol=%22&A25,2,%22Morningstar Rating",,,,1)
>
>Now is giving me "Premium". I have a premium subscription and I am logon'ed lo M*.
Now it works as before. thx a lot.
Regards,
Jose L. Jacob
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Friday, February 15, 2013 10:09:50 AM
Subject: Re: [smf_addin] Morningstar fair value
Did you log in with the EXCEL Web Query process, or with IE? Something like FireFox won't do it.
I just logged it, and your formula works fine for me.
On Fri, Feb 15, 2013 at 7:56 AM, Jacob Jose pepecan47@yahoo.
>
>I was using the following formula to get the M* fair value. It worked fine until yesterday:
>
>=RCHGetTableCel
>
>Now is giving me "Premium"
Fri Feb 15, 2013 4:55 pm (PST) . Posted by:
"iamruf" iamruf
Hi Randy,
The most comprehensive list of CDN MFunds is found at the site below (16,889 funds). However, there is no download feature.
I can copy paste 338 pages but wondered if you know of a way to automate the process of scrolling through the pages & copy paste or load to Excel. Please review.
Thanks
http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_report?rep_type=STD&pi_report_tab=159&order_by=&direction=ASC&start_row=&pi_report_option=&pi_report_param=&pi_show_criteria_yn=Y&iaction=fundFilter&pi_portfolio_id=
The most comprehensive list of CDN MFunds is found at the site below (16,889 funds). However, there is no download feature.
I can copy paste 338 pages but wondered if you know of a way to automate the process of scrolling through the pages & copy paste or load to Excel. Please review.
Thanks
http://globefunddb.
Fri Feb 15, 2013 6:26 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I get an empty page with that URL.
On Fri, Feb 15, 2013 at 5:55 PM, iamruf iamruf@yahoo.com > wrote:
> Hi Randy,
> The most comprehensive list of CDN MFunds is found at the site below
> (16,889 funds). However, there is no download feature.
> I can copy paste 338 pages but wondered if you know of a way to automate
> the process of scrolling through the pages & copy paste or load to Excel.
> Please review.
> Thanks
>
> http://globefunddb.theglobeandmail.com/gishome/plsql/gis.fund_report?rep_type=STD&pi_report_tab=159&order_by=&direction=ASC&start_row=&pi_report_option=&pi_report_param=&pi_show_criteria_yn=Y&iaction=fundFilter&pi_portfolio_id=
>
On Fri, Feb 15, 2013 at 5:55 PM, iamruf iamruf@yahoo.
> Hi Randy,
> The most comprehensive list of CDN MFunds is found at the site below
> (16,889 funds). However, there is no download feature.
> I can copy paste 338 pages but wondered if you know of a way to automate
> the process of scrolling through the pages & copy paste or load to Excel.
> Please review.
> Thanks
>
> http://globefunddb.
>
Tidak ada komentar:
Posting Komentar