RE: [MS_AccessPros] Historical Stock Data

A "start" would be to use some version of SQL Server. Make sure you index the appropriate fields. Otherwise I don't know much about data for stock prices.

Duane Hookom
MS Access MVP

From: gilpatric59@gmail.com

Hi, I am interested in building a database for storing/analyzing end of day data for stock prices. At a minimum, I would store the following: ticker symbol, open price, high price, low price, close price, volume, open interest, sector, industry, exchange. This data would be collected on over 10,000 companies daily. Would want to upload a minimum of last 10 years of data. I would need to run a daily analysis of relationships between price and volume for entire market indexes, sectors, industries and individual companies. Are you able to get me started on a design?

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/