2 Messages
Digest #3081
Messages
Sat May 31, 2014 10:26 am (PDT) . Posted by:
waleedm@sbcglobal.net
Doesnt look like current price is available anymore when using the rchgetelements function. I guess I can back calculate from the price ratio values but seems odd that I can just get the price directly.
Sat May 31, 2014 10:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Part of the reason element #25 was obsoleted is that MSN had been posting
the previous day's closing price as the "Last Price" ever since they
modified that web page back in 2012.
Instead, just use the RCHGetYahooQuotes() function. For example:
=RCHGetYahooQuotes("MMM","l1")
See the documentation of that function for detail on a number of other data
items that can be retrieved with it. And, if you array-enter the request
over a range (see example from documentation), you can get a number of data
items for up to 200 ticker symbols, in a single Internet access. Much
faster than using RCHGetElementNumber(), which usually needs to get a new
web page for each ticker symbol.
On Sat, May 31, 2014 at 9:44 AM, waleedm@... wrote:
>
> Doesnt look like current price is available anymore when using the
> rchgetelements function. I guess I can back calculate from the price ratio
> values but seems odd that I can just get the price directly.
>
the previous day's closing price as the "Last Price" ever since they
modified that web page back in 2012.
Instead, just use the RCHGetYahooQuotes(
=RCHGetYahooQuotes(
See the documentation of that function for detail on a number of other data
items that can be retrieved with it. And, if you array-enter the request
over a range (see example from documentation)
items for up to 200 ticker symbols, in a single Internet access. Much
faster than using RCHGetElementNumber
web page for each ticker symbol.
On Sat, May 31, 2014 at 9:44 AM, waleedm@... wrote:
>
> Doesnt look like current price is available anymore when using the
> rchgetelements function. I guess I can back calculate from the price ratio
> values but seems odd that I can just get the price directly.
>
Tidak ada komentar:
Posting Komentar