Programs already exist that do all of that for you automatically. It is called a "trading platform," designed to handle stock market data in the data format of High, Low, and Close. It automatically retrieves data, will chart the data in any time frame from minutes to hours to days and weeks or months, with thousands of indicators available. You will also have access to research, a scanner, a simulator, help forums, and hundreds of other resources built for the investor you can't even imagine; resources every investor needs to be successful. Learn to use them now, don't spend all your time updating a spreadsheet.
Download a free trial of a trading platform from any major brokerage. You won't have to fund the account for months or years. All you have to do is register.
For some reason, Answers won't let me post a link, so I'll give you the caption. Just Google "broker reviews."
The Best Online Brokers of 2014
With equities at record highs, our picks are Interactive Brokers, tradeMonster, Place Trade, and TD Ameritrade
it really depends on how you want to use the info. You could, for example, copy/paste them into the table then just sum everything going down the list, since yahoo finance puts it in a convenient little format by date already. I hope this helps, respond here with more details and I can try to be more specific.
Sounds like you are trying to write a database in Excel.
Better to use a database program like Access
use pivot table function
Hi,
I downloaded 10 different company historical stock data from Yahoo Finance (from year 2001 - recent), and I have placed them in a table.
Right now, I want to merge the data of these 10 stocks together based on their dates to form an overall data collection of these 10 stocks into 1 table (so, prices, volume, opening and closing will all be added together based on their dates).
Is this possible?
I tried consolidate function in excel, doesn't work for large amount of data.
