FredMFoley
Board Regular
- Joined
- Mar 18, 2002
- Messages
- 58
I want to make a spreadsheet with a big list of shares (tickers or codes) in Column A, and the closing prices, say for every Friday, in the other columns, using past historical data.
I can download the historical data (which includes the closing prices) of all shares (1600 or so Australian shares) for the past date that I want, and use 'Import External Data' to get it into a new spreadsheet, in a form like:
Code Date Open High Low Close Volume
AAC 03/15/02 93 94 92 93 1269
AAR 03/15/02 3 3 3 3 2255
AAT 03/15/02 26 26.5 26 26 2437
AAU 03/15/02 90 90 85 85 26
Can I get Excel to automatically select only those rows that I want to keep from a list (eg AGY BHP BIL CML CRA DVN etc), (or discard the ones I don't want)?
I can then copy and paste the closing prices for that day into the main spreadsheet.
(Do I have to learn to use VBA??)
I hope my query is comprehensible!!
Thank You
I can download the historical data (which includes the closing prices) of all shares (1600 or so Australian shares) for the past date that I want, and use 'Import External Data' to get it into a new spreadsheet, in a form like:
Code Date Open High Low Close Volume
AAC 03/15/02 93 94 92 93 1269
AAR 03/15/02 3 3 3 3 2255
AAT 03/15/02 26 26.5 26 26 2437
AAU 03/15/02 90 90 85 85 26
Can I get Excel to automatically select only those rows that I want to keep from a list (eg AGY BHP BIL CML CRA DVN etc), (or discard the ones I don't want)?
I can then copy and paste the closing prices for that day into the main spreadsheet.
(Do I have to learn to use VBA??)
I hope my query is comprehensible!!
Thank You