Historic Stock Prices

**ride4thebrand** · 03-13-2020, 05:04 PM

My left column is stock ticker symbols (using the new data field "Stocks")….my top row is just dates in history

What I'm trying to do is create a spreadsheet that has about 50 different stocks and I want the 1st of the month from 2010 moving forward on all their stock prices.

Any idea if there is a formula that will automatically fill these in?

Thanks in advance....

**Kaper** · 03-14-2020, 04:00 AM

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough, but in your case may be 100 or so would be needed)?
Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.