Senin, 10 Juni 2013

[smf_addin] Digest Number 2651

2 New Messages

Digest #2651
1a
Extracting Data from Some sites are a Problem by "handc.jones@sbcglobal.net" handc.jones@sbcglobal.net
1b

Messages

Sun Jun 9, 2013 12:14 pm (PDT) . Posted by:

"handc.jones@sbcglobal.net" handc.jones@sbcglobal.net

Hello:

I would love to use your add in more effectively to extract data from the various sites. I have no problem extracting data from Yahoo Finance but for some reason cannot extract data from MSN, Zachs, Morningstar. For example, I opened the file from your site http://finance.groups.yahoo.com/group/smf_addin/?prop=eupdate "Consistency Investment Spreadsheet" and had errors on the 3 sites mentioned. Data from Yahoo was ok.

I am using a PC with Windows Office 2010.

Thanks, Henrietta

Sun Jun 9, 2013 12:17 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The URL you cite doesn't get me to any spreadsheet.

Examples of troublesome formulas would help.

Morningstar does require a visit in the EXCEL Web Query or IE before using.
They have a redirection set up on your first visit (used to be daily, but I
don't think so anymore), for advertising purposes.

Others have mentioned troubles with Zacks, but they cannot even visit the
website with their browser.

I've not had issues with MSN, other than people having old element
definitions (they updated their website structure early last year).

On Sun, Jun 9, 2013 at 8:18 AM, handc.jones@sbcglobal.net <
handc.jones@sbcglobal.net> wrote:

>
> I would love to use your add in more effectively to extract data from the
> various sites. I have no problem extracting data from Yahoo Finance but
> for some reason cannot extract data from MSN, Zachs, Morningstar. For
> example, I opened the file from your site
> http://finance.groups.yahoo.com/group/smf_addin/?prop=eupdate "Consistency Investment Spreadsheet" and had errors on the 3 sites
> mentioned. Data from Yahoo was ok.
>
> I am using a PC with Windows Office 2010.
>

Tidak ada komentar:

Posting Komentar