4 New Messages
Digest #2919
Messages
Tue Jan 7, 2014 12:17 pm (PST) . Posted by:
"Dave Charlaff" copthornelabs
Randy,
Yahoo provides Total Volume for the NYSE at
<http://finance.yahoo.com/q?s=%5ETV.o&ql=1>
http://finance.yahoo.com/q?s=%5ETV.o&ql=1. Their actual symbol is ^TV.N.
I am trying to capture Total Volume for the NTSE and the OTC (NASDAQ -
^TV.O) and the American Stock Exchange(^TV.AQ I think) to try and get a feel
for total volume of shares traded daily.
This is not a price. What is the simplest way to get these volume stats into
separate cells in my spreadsheet?
Dave C.
Yahoo provides Total Volume for the NYSE at
<http://finance.
http://finance.
I am trying to capture Total Volume for the NTSE and the OTC (NASDAQ -
^TV.O) and the American Stock Exchange(^TV.
for total volume of shares traded daily.
This is not a price. What is the simplest way to get these volume stats into
separate cells in my spreadsheet?
Dave C.
Tue Jan 7, 2014 3:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just array-enter this over a 3-row by 1-column range:
=RCHGetYahooQuotes("^TV.O,^TV.N,^TV.AQ","l1")
On Tue, Jan 7, 2014 at 1:17 PM, Dave Charlaff <davecharlaff@hotmail.com>wrote:
>
> Yahoo provides Total Volume for the NYSE at
> http://finance.yahoo.com/q?s=%5ETV.o&ql=1. Their actual symbol is ^TV.N.
>
>
>
> I am trying to capture Total Volume for the NTSE and the OTC (NASDAQ -
> ^TV.O) and the American Stock Exchange(^TV.AQ I think) to try and get a
> feel for total volume of shares traded daily.
>
>
>
> This is not a price. What is the simplest way to get these volume stats
> into separate cells in my spreadsheet?
>
>
>
=RCHGetYahooQuotes(
On Tue, Jan 7, 2014 at 1:17 PM, Dave Charlaff <davecharlaff@
>
> Yahoo provides Total Volume for the NYSE at
> http://finance.
>
>
>
> I am trying to capture Total Volume for the NTSE and the OTC (NASDAQ -
> ^TV.O) and the American Stock Exchange(^TV.
> feel for total volume of shares traded daily.
>
>
>
> This is not a price. What is the simplest way to get these volume stats
> into separate cells in my spreadsheet?
>
>
>
Tue Jan 7, 2014 5:24 pm (PST) . Posted by:
soar2morrow
The "/o/" in =RCHGetHTMLTable("http://www.nasdaq.com/symbol/o/dividend-history http://www.nasdaq.com/symbol/o/dividend-history","Cash Amount",-1,"",1) is the symbol for Realty Income Corp; how do you invoke a call to RCHGetHTMLTable where the symbol is a variable set in another cell?
Thanks,
Tom
Thanks,
Tom
Tue Jan 7, 2014 5:33 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You just use the normal EXCEL operator to concatenate strings/cells:
"http://www.nasdaq.com/symbol/" & C5 & "/dividend-history"
On Tue, Jan 7, 2014 at 6:06 PM, <tom_systek@msn.com> wrote:
> The "/o/" in =RCHGetHTMLTable("
> http://www.nasdaq.com/symbol/o/dividend-history","Cash Amount",-1,"",1)
> is the symbol for Realty Income Corp; how do you invoke a call to RCHGetHTMLTable
> where the symbol is a variable set in another cell?
>
"http://www.nasdaq.
On Tue, Jan 7, 2014 at 6:06 PM, <tom_systek@msn.
> The "/o/" in =RCHGetHTMLTable(
> http://www.nasdaq.
> is the symbol for Realty Income Corp; how do you invoke a call to RCHGetHTMLTable
> where the symbol is a variable set in another cell?
>
Tidak ada komentar:
Posting Komentar