I'm trying to get the Historical Closing Price of stocks. I recorded a
macro that will download, and also found several scripts that will
download historical info for stocks. However it downloads a table for
the stock with "Open", "Hi", "Low", but I do not want the whole table,
I only want the "Close" price. Is there a way to do this?

I do this sort of thing often.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Charles" wrote in message
...
I'm trying to get the Historical Closing Price of stocks. I recorded a
macro that will download, and also found several scripts that will
download historical info for stocks. However it downloads a table for
the stock with "Open", "Hi", "Low", but I do not want the whole table,
I only want the "Close" price. Is there a way to do this?

On Dec 1, 2:01*pm, "Don Guillett" wrote:
I do this sort of thing often.
* * * If desired, send your file to my address below. I will only look if:
* * * 1. You send a copy of this message on an inserted sheet
* * * 2. You give me the newsgroup and the subject line
* * * 3. You send a clear explanation of what you want
* * * 4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Charles" wrote in message

...

I'm trying to get the Historical Closing Price of stocks. I recorded a
macro that will download, and also found several scripts that will
download historical info for stocks. However it downloads a table for
the stock with "Open", "Hi", "Low", but I do not want the whole table,
I only want the "Close" price. Is there a way to do this?

Don,

Thanks for your offer. However after some more research I think I
found a solution by using an Array and the extract the closing price.

One way is to extract with INDIRECT

=IF(ISNUMBER(D29),VLOOKUP($A29,INDIRECT("Data!B1:X 1000"),5,FALSE),"")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Charles" wrote in message
...
On Dec 1, 2:01 pm, "Don Guillett" wrote:
I do this sort of thing often.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Charles" wrote in
message

...

I'm trying to get the Historical Closing Price of stocks. I recorded a
macro that will download, and also found several scripts that will
download historical info for stocks. However it downloads a table for
the stock with "Open", "Hi", "Low", but I do not want the whole table,
I only want the "Close" price. Is there a way to do this?

Don,

Thanks for your offer. However after some more research I think I
found a solution by using an Array and the extract the closing price.

On Dec 1, 3:09*pm, "Don Guillett" wrote:
One way is to extract with INDIRECT

* * * *=IF(ISNUMBER(D29),VLOOKUP($A29,INDIRECT("Data!B1: X1000"),5,FALSE),"")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Charles" wrote in message

...
On Dec 1, 2:01 pm, "Don Guillett" wrote:



I do this sort of thing often.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Charles" wrote in
message

....

I'm trying to get the Historical Closing Price of stocks. I recorded a
macro that will download, and also found several scripts that will
download historical info for stocks. However it downloads a table for
the stock with "Open", "Hi", "Low", but I do not want the whole table,
I only want the "Close" price. Is there a way to do this?

Don,

Thanks for your offer. However after some more research I think I
found a solution by using an Array and the extract the closing price.

Thanks for the information. The way I found was to only select 1 date
( which is all I needed) and load an Array without having the table
loaded to a spread sheet.
First I dimmed a string and set the element of the array to the
string. This seems to work for me.
Again thanks for your interest and help.