To get this data from a web address into an Excel spreadsheet, we can use the WEBSERVICE() function. I'll also wrap a NUMBERVALUE() function around to convert the import text from Yahoo! Finance into a numerical value we can use inside Excel. Example 1: Pull The 'Current Stock Price' for Microsoft's Stock. Download the excel investment portfolio spreadsheet to keep track of your stock portfolio holdings in an easy to use excel spreadsheet. SMF ” and then choose the file “RCH_Stock_Market_Functions.xla” and click OK. Edit: follow the link to view the full and comprehensive installation manual and FAQ. RCH_Stock_Market_Functions-2.1.2014.01.30 Research Offers Trend Exhaustion Stock Market Excel Spreadsheet ($70.00) Rental Income Property Analysis Excel Spreadsheet ($45.00) Fix-N-Flip Rehab Analyzer for Excel ($30.00) Kelly Formula For Stocks Excel Spreadsheet ($15.00) Car Cost Comparison Tool ($13.00) My Net Worth Spreadsheet ($10.00) HP-1: R.

• Rch Stock Market Functions Download Free

• > the SMF folder, select the 'RCH_Stock_ Market_Functions', and click 'OK'. > At this point Excel informs me that a file with that name already exists in > that location and asks if I want to replace it.
• Excel based software that makes it easy to research and invest in stock markets. Expensive product and several pricing tiers to access all functions. Market XLS has degraded in terms of.

I am developing an application that relies on stock market information. For the moment, I use Yahoo Finance CSV API. Unfortnautely OpenTick stopped its service, Google Finance API will soon, too.

I have a list of stock symbols I am interested in and download a CSV and parse it. I do not need 'live' and 'legit' data, as I want to test out how my application can handle high-frequent stock event stream. Ideally, at least several 100k quotes should be contained, the more, the better (up to a certain extent).

Data should be somehow similar to this site, but I'd need way more data. Only concern is, that it must contain the typical stock symbols, the data itself doenst need to be too detailed (date/time, high, low, EOD, volume would do).

Does anyone know, where I could get historic data (like an enourmous CSV), which I could feed into my application?

Paying for that data is not an option. Would be great, if somebody could share his experiences/knowledge, where to get such data. I know about xignite, NxCore etc. but as this is an academic project, it must be free-to-use data. I cannot hope for some free equivalent of NxCore, but probaly you guys can help me out with some advice and hints..

If I am too optimistic and there basically is no free source, I'll have to 'randomize' stock quotes, but this is the last option. The big advantage with a static historic data set is, that I can really compare the performance of my application with regard to the same input data.

I've already searched StackOverflow, but most threads are quite old and refer to no more existent soultions as in this question.

This site EODdata.com mentioned in a related question gets close - but unfortunately their data is not free, but at least the prices seem reasonable.

Another related SO question can be found here.

closed as off-topic by Taryn♦Jul 4 '14 at 17:36

This question appears to be off-topic. The users who voted to close gave this specific reason:

• 'Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.' – Taryn

1 Answer

On the site of Southwest Cyberport one can download some historic stock market data sets.

I've downloaded S&P 500 historic data as 'daily update' and got approx. 11 MB of uncompressed txt files. Each file is 25 KB and can easily be concatenated into one big single file.

Chinese call of duty online download. The format is CSV and a corresponds to:
Date, Company, Open, High, Low, Close, Volume

Small sample can be found below:

Not the answer you're looking for? Browse other questions tagged datasetstocksstockquotes or ask your own question.

Rch Stock Market Functions Download Free