Messages In This Digest (4 Messages)
- 1a.
- RCH GET History Question. From: clifford.dowler
- 1b.
- Re: RCH GET History Question. From: Randy Harmelink
- 2.
- FWD: From: krishna kutty
- 3.
- Does anyone have an excel that uses a moving average crossover? From: scott_grant2
Messages
- 1a.
-
RCH GET History Question.
Posted by: "clifford.dowler" clifford.dowler@yahoo.com clifford.dowler
Sat Apr 14, 2012 3:00 pm (PDT)
I have successfully retrieved the closing price "C" from one date to another for a particular stock down a column after selecting the cell range and CSE closing it. I can also re-input the same formula and CSE close it to manually get the same data for another stock in another column.
My question is, presuming I have a stock symbol at the top of the column and I have 1000 symbols across the columns of the sheet, how do I mass copy the formula to retrieve that specific data item for all stock symbols in the range?
When I try to set the ticker data item to a range of cells, I get the dreaded #Value# error, or if I simply copy the formula, I get the data in the first column, blanks in the rest, and the formula that is copied does not change the ticker variable to the cell at the top of the column. Instead it retains the ticker cell reference of the first column.
Ultimately, what i want to do is to get the closing prices of a group of stocks for say daily data going back 10 years and perhaps also get any dividends paid. Still the work around would be to get just the closing prices in one table and the dividends in another,and then combine the two tables to get total return for any given stock over a specific period.
Thank you.
Cliff
- 1b.
-
Re: RCH GET History Question.
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Apr 14, 2012 5:27 pm (PDT)
On Sat, Apr 14, 2012 at 2:13 PM, clifford.dowler
<clifford.dowler@yahoo.com >wrote:
> I have successfully retrieved the closing price "C" from one date to
> another for a particular stock down a column after selecting the cell range
> and CSE closing it. I can also re-input the same formula and CSE close it
> to manually get the same data for another stock in another column.
>
> My question is, presuming I have a stock symbol at the top of the column
> and I have 1000 symbols across the columns of the sheet, how do I mass copy
> the formula to retrieve that specific data item for all stock symbols in
> the range?
>
Just copy it from one column to all the others.
However, I can't think of a good reason to get that many different sets of
historical quotes. If you're doing some type of screening, you'd be better
off using something like StockFetcher. Yahoo hasn't been all that reliable
lately, so I am thinking at least a few of those 1000 symbols are going to
error out. And that means it will take a LONG time to get the data. And
some of it will not be there.
> When I try to set the ticker data item to a range of cells, I get the
> dreaded #Value# error, or if I simply copy the formula, I get the data in
> the first column, blanks in the rest, and the formula that is copied does
> not change the ticker variable to the cell at the top of the column.
> Instead it retains the ticker cell reference of the first column.
>
The function only retrieves data for a single ticker symbol.
The cell reference should change when you copy the formula, unless you're
using an absolute reference.
> Ultimately, what i want to do is to get the closing prices of a group of
> stocks for say daily data going back 10 years and perhaps also get any
> dividends paid. Still the work around would be to get just the closing
> prices in one table and the dividends in another,and then combine the two
> tables to get total return for any given stock over a specific period.
>
If you're doing total returns, you should be using adjusted closing prices.
Their changes account for dividends.
Getting total returns for 1000 stocks is this manner is NOT a trivial task.
- 2.
-
FWD:
Posted by: "krishna kutty" kkkutty@yahoo.com kkkutty
Sat Apr 14, 2012 7:12 pm (PDT)
- 3.
-
Does anyone have an excel that uses a moving average crossover?
Posted by: "scott_grant2" scott_grant2@yahoo.com scott_grant2
Sat Apr 14, 2012 10:11 pm (PDT)
I have an excel sheet that does a different kind
of trend, i could try and write it, i love the plug-in
but i wouldnt be ashamed to ask if anyone else has
already written one..
thanks
Scott
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar