Senin, 01 Juni 2015

[smf_addin] Digest Number 3420

5 Messages

Digest #3420
1b
Re: 10 Year Annual High/Low Price by "Randy Harmelink" rharmelink
1d
Re: 10 Year Annual High/Low Price by "Randy Harmelink" rharmelink

Messages

Sun May 31, 2015 12:49 pm (PDT) . Posted by:

the.3boyds

I'm trying to figure out how to import yearly high/low prices for a 10 year period. Morningstar has a concise table containing the data I need but I can't find a way to import that data, although I found elements for all the other Morningstar data that I need. Any help is appreciated.

Sun May 31, 2015 12:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=smfGetCSVFile("
http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=MMM
")

...or did you have a different table in mind?

On Sun, May 31, 2015 at 12:22 PM, the.3boyds@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I'm trying to figure out how to import yearly high/low prices for a 10
> year period. Morningstar has a concise table containing the data I need
> but I can't find a way to import that data, although I found elements for
> all the other Morningstar data that I need. Any help is appreciated.
>

Sun May 31, 2015 1:24 pm (PDT) . Posted by:

the.3boyds

That's exactly the table I have in mind but only the title is showing up on the spreadsheet. The link works to download the whole table but I can't get the whole thing to import to an existing spreadsheet.

Sun May 31, 2015 2:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You have to array-enter that formula over a range to get the whole table.
If you just enter it into a single cell, you just get the first row and
first column of the table.

On Sun, May 31, 2015 at 1:24 PM, the.3boyds@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> That's exactly the table I have in mind but only the title is showing up
> on the spreadsheet. The link works to download the whole table but I can't
> get the whole thing to import to an existing spreadsheet.
>

Sun May 31, 2015 2:47 pm (PDT) . Posted by:

the.3boyds

Got it to work. Thanks so much for your help!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar