2 Messages
Digest #3041
Messages
Fri Apr 11, 2014 9:12 am (PDT) . Posted by:
joagraha
I'm looking for a formula which will simply allow me to pull in last price or prior closing price for an equity or ETF. There had been a an element pulling from MSN, but that is now marked as obsolete. Can anyone tell me how best to do this?
Thanks,
Adam
Thanks,
Adam
Fri Apr 11, 2014 9:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You should use the RCHGetYahooQuotes() to get current quotes data.
It has a big advantage -- when array-entered over a range, you can get a
number of data items on up to 200 ticker symbols, all with one Internet
access. Much faster than using RCHGetElementNumber() and getting a single
stock quote for each Internet access.
For example, to get the last traded price:
=RCHGetYahooQuotes("MMM","l1")
On Fri, Apr 11, 2014 at 8:47 AM, <joagraha@yahoo.com> wrote:
>
> I'm looking for a formula which will simply allow me to pull in last price
> or prior closing price for an equity or ETF. There had been a an element
> pulling from MSN, but that is now marked as obsolete. Can anyone tell me
> how best to do this?
>
It has a big advantage -- when array-entered over a range, you can get a
number of data items on up to 200 ticker symbols, all with one Internet
access. Much faster than using RCHGetElementNumber() and getting a single
stock quote for each Internet access.
For example, to get the last traded price:
=RCHGetYahooQuotes("MMM","l1")
On Fri, Apr 11, 2014 at 8:47 AM, <joagraha@yahoo.com> wrote:
>
> I'm looking for a formula which will simply allow me to pull in last price
> or prior closing price for an equity or ETF. There had been a an element
> pulling from MSN, but that is now marked as obsolete. Can anyone tell me
> how best to do this?
>
Tidak ada komentar:
Posting Komentar