Using excel to automatically build a database of stock data

Excel Help for Using Excel To Automatically Build A Database Of Stock Data in Automating Data Analysis Tasks

Find Excel Solutions

Search Forums:
Recent Activity:
Importing Data From Pdf Files
Same Output By Varying The Target Returns
Web Query
Vba Save To Skydrive
Auto-timing Not Working Properly
"runtime Error 13" And "runtime Error -2147483640" Excel 2011 Mac

Follow Business Spreadsheets On:
Forum TopicReply Login

Using Excel To Automatically Build A Database Of Stock Data

Rate this:
(3/5 from 1 vote)
ConfusedHey guys,

I've an excel project that I could use a little help with.

I'm trying to build a spreadsheet that will automatically download stock data and add it to a cummulitive database.  

Here's what I want the spreadsheet to do:

1. Download the data (particularly stuff like the PE ratio) at the close of a market day.
2. Add this to the dataset in, say, row one, with the date it was downloaded.  
3. Download updated data the next day, at the market close.
4. Add the new numbers to the dataset, but this time in row TWO, without deleting the older data.

I know how to download stock data and how to update it automatically, but I don't know how to do make those downloads cummulitive. Right now, each new download replaces the older data. 

I've seen references to the indirect function, but no information on how it's used in this context.

I'd appreciate any advice you guys can provide. 


 Posted by on
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Rate this:
(3/5 from 1 vote)
You probably need to find the last cell in the column and then offset 1 down to populate the the row with the new date and price.  We can do this in VBA like:
VBA Code:

There is an open source program to download market data for multiple stocks that we developed here. This has a lot of code that might also help with your project.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Using excel to automatically build a database of stock data:
Solutions: Pricing and Breakeven Analysis Database Report Builder File Explorer Stock Trading System Fund Management System Spread Trading System Spreadsheet to ASP/ASP.NET Converter Batch Replace Tools Project Planner Statistics Training Useful Add-ins OPC Data Connection Dependency Auditing OCX Office Viewer Component Spreadsheet Search Functions and Formulas Warehouse Management SQL Statements Cube Functions


Find Excel templates
and add-ins in the
Excel Business Solutions Directory
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |