5 Messages
Digest #3420
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.
>
=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.
>
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:
Posting Komentar