1 Message
Digest #4398
1a
Re: smfPricesByDates delivers "adjusted Close" / yahoos "Close" also by "Randy Harmelink" rharmelink
Message
Tue Sep 11, 2018 11:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You could grab the whole table with:
=RCHGetHTMLTable("
http://performance.morningstar.com/perform/Performance/stock/price-history.action?&t=MMM&culture=en-US&cur=&ops=clear&pd=10y&sd=&ed=&freq=a&pg=0&pgsz=20
",">Open")
But unfortunately, they code it with every other row blank. You can pick up
an individual column, with no blank rows, with something like:
=INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/perform/Performance/stock/price-history.action?&t=MMM&culture=en-US&cur=&ops=clear&pd=10y&sd=&ed=&freq=a&pg=0&pgsz=20
",">Open",,,,,50,6),{1;3;5;7;9;11;13;15;17;19;21;23;25;27;29;31;33;35;37;39},5)
Both of the above would need to be array-entered over a range, of course.
On Tue, Sep 11, 2018 at 10:46 AM stan_12@ymail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> In addition there is a quick way to get to Year-End (and other)
> OHLC-Prices using for example RCHGetTableCell in combination with this:
>
> http://performance.morningstar.com/perform/Performance/stock/price-history.action?&t=MMM&culture=en-US&cur=&ops=clear&pd=10y&sd=&ed=&freq=a&pg=0&pgsz=20
>
>
>
=RCHGetHTMLTable("
http://performance.morningstar.com/perform/Performance/stock/price-history.action?&t=MMM&culture=en-US&cur=&ops=clear&pd=10y&sd=&ed=&freq=a&pg=0&pgsz=20
",">Open")
But unfortunately, they code it with every other row blank. You can pick up
an individual column, with no blank rows, with something like:
=INDEX(RCHGetHTMLTable("
http://performance.morningstar.com/perform/Performance/stock/price-history.action?&t=MMM&culture=en-US&cur=&ops=clear&pd=10y&sd=&ed=&freq=a&pg=0&pgsz=20
",">Open",,,,,50,6),{1;3;5;7;9;11;13;15;17;19;21;23;25;27;29;31;33;35;37;39},5)
Both of the above would need to be array-entered over a range, of course.
On Tue, Sep 11, 2018 at 10:46 AM stan_12@ymail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> In addition there is a quick way to get to Year-End (and other)
> OHLC-Prices using for example RCHGetTableCell in combination with this:
>
> http://performance.morningstar.com/perform/Performance/stock/price-history.action?&t=MMM&culture=en-US&cur=&ops=clear&pd=10y&sd=&ed=&freq=a&pg=0&pgsz=20
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar