|
Historical Stock Close Value
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? |
Historical Stock Close Value
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? |
Historical Stock Close Value
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. |
Historical Stock Close Value
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. |
| All times are GMT +1. The time now is 06:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com