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 the Forums:
	Search
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel

Follow Business Spreadsheets On:

Home > Forum Home > Automating Data Analysis Tasks > Using excel to automatically build a database of stock data

Forum Topic

Using excel to automatically build a database of stock data

Rate this:

(3/5 from 1 vote)

	Hey 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. Thanks
	Posted by Bokononblue22 on 23-Feb-2012

Replies - Displaying 1 to 1 of 1

Order 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:

Selection.End(xlDown).Offset(1,0).Select

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 Excel Helper on 23-Feb-2012

Displaying page 1 of 1

Excel templates and solutions matched for Using excel to automatically build a database of stock data:
Products: 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

© 2013 Business Spreadsheets. All Rights Reserved. Legal | About Us